14. Health ..................................................................................................................................32
14.1. Introduction .................................................................................................................32
14.2. Connection Health .........................................................................................................32
14.3. Memory Health .............................................................................................................32
14.4. Creating Custom Health Graphs .........................................................................................32
14.5. Status Variables ............................................................................................................35
14.6. System Variables ...........................................................................................................35
15. Server Logs ............................................................................................................................36
15.1. Introduction .................................................................................................................36
15.2. Error Log ....................................................................................................................37
15.3. Slow Log ....................................................................................................................37
15.4. General Log .................................................................................................................37
16. Backup .................................................................................................................................38
16.1. Introduction .................................................................................................................38
16.2. Backup Project ..............................................................................................................38
16.3. Advanced Options ..........................................................................................................38
16.3.1. Backup Execution Method ......................................................................................38
16.3.2. Output File Options ..............................................................................................39
16.4. Schedule .....................................................................................................................39
17. Restore .................................................................................................................................41
17.1. Introduction .................................................................................................................41
17.2. The General Tab ............................................................................................................41
17.3. Restore Content .............................................................................................................41
18. Replication Status ....................................................................................................................43
18.1. Introduction .................................................................................................................43
18.2. Configuring Replication Servers .........................................................................................43
18.3. Using the Replication Status Section ....................................................................................43
19. Catalogs ................................................................................................................................45
19.1. Introduction .................................................................................................................45
19.2. Schema Tables ..............................................................................................................45
19.2.1. Table Status .......................................................................................................46
19.2.2. Row Status ........................................................................................................46
19.3. Schema Indexes ............................................................................................................46
II. MySQL Query Browser ......................................................................................................................47
20. Introduction to the MySQL Query Browser ......................................................................................49
21. A Tour of the MySQL Query Browser ............................................................................................50
21.1. The Main Query Window .................................................................................................50
21.2. The Query Toolbar .........................................................................................................51
21.2.1. The Navigation Buttons .........................................................................................51
21.2.2. The Query Area ..................................................................................................51
21.2.3. The Action Buttons ..............................................................................................52
21.3. The Advanced Toolbar ....................................................................................................52
21.4. The Result Area ............................................................................................................53
21.5. The Object Browser ........................................................................................................53
21.5.1. The Database Browser ..........................................................................................53
21.5.2. The Bookmark Browser .........................................................................................55
21.5.3. The History Browser ............................................................................................55
21.6. The Information Browser .................................................................................................55
21.6.1. The Syntax Browser .............................................................................................55
21.6.2. The Function browser ...........................................................................................55
21.6.3. The Parameter Browser .........................................................................................56
21.6.4. The Transaction Browser .......................................................................................56
21.7. The Script Editor ...........................................................................................................56
21.7.1. The Script Debugging Buttons .................................................................................58
21.7.2. The Script Area ...................................................................................................59
22. Using The MySQL Query Browser ................................................................................................60
22.1. Entering and Editing Queries Manually .................................................................................60
22.2. Building Queries ...........................................................................................................60
22.3. Creating Views .............................................................................................................61
22.4. Navigating Result Sets Within the Result Area ........................................................................61
22.5. Exporting Result Sets ......................................................................................................62
22.6. Handling BLOB and TEXT Columns ...................................................................................62
22.7. Editing Result Sets Within the Result Area ............................................................................62
22.8. Comparing Result Sets ....................................................................................................63
22.9. Managing Stored Procedures and Functions with MySQL Query Browser ........................................63
MySQL GUI Tools Manual
v