13. Health ...................................................................................................31
13.1. Introduction .................................................................................31
13.2. Connection Health ........................................................................31
13.3. Memory Health ............................................................................31
13.4. Creating Custom Health Graphs ......................................................32
13.5. Status Variables ...........................................................................34
13.6. System Variables ..........................................................................34
14. Server Logs ...........................................................................................36
14.1. Introduction .................................................................................36
14.2. Error Log ....................................................................................37
14.3. Slow Log ....................................................................................37
14.4. General Log ................................................................................37
15. Backup .................................................................................................38
15.1. Introduction .................................................................................38
15.2. Backup Project .............................................................................38
15.3. Advanced Options ........................................................................38
15.3.1. Backup Execution Method ...................................................38
15.3.2. Output File Options ............................................................39
15.4. Schedule .....................................................................................39
16. Restore .................................................................................................41
16.1. Introduction .................................................................................41
16.2. The General Tab ...........................................................................41
16.3. Restore Content ............................................................................41
17. Replication Status ...................................................................................43
17.1. Introduction .................................................................................43
17.2. Configuring Replication Servers ......................................................43
17.3. Using the Replication Status Section ................................................43
18. Catalogs ................................................................................................45
18.1. Introduction .................................................................................45
18.2. Schema Tables .............................................................................45
18.2.1. Table Status ......................................................................46
18.2.2. Row Status .......................................................................46
18.3. Schema Indexes ...........................................................................46
II. MySQL Query Browser .....................................................................................47
19. Introduction to the MySQL Query Browser ..................................................49
20. A Tour of the MySQL Query Browser ........................................................50
20.1. The Main Query Window ...............................................................50
20.2. The Query Toolbar .......................................................................51
20.2.1. The Navigation Buttons .......................................................51
20.2.2. The Query Area .................................................................51
20.2.3. The Action Buttons ............................................................52
20.3. The Advanced Toolbar ..................................................................52
20.4. The Result Area ...........................................................................53
20.5. The Object Browser ......................................................................53
20.5.1. The Database Browser ........................................................53
20.5.2. The Bookmark Browser ......................................................55
20.5.3. The History Browser ...........................................................55
20.6. The Information Browser ...............................................................55
20.6.1. The Syntax Browser ...........................................................56
20.6.2. The Function browser .........................................................56
20.6.3. The Parameter Browser .......................................................56
20.6.4. The Transaction Browser .....................................................56
20.7. The Script Editor ..........................................................................56
20.7.1. The Script Debugging Buttons ..............................................58
20.7.2. The Script Area .................................................................58
21. Using The MySQL Query Browser .............................................................60
21.1. Entering and Editing Queries Manually .............................................60
21.2. Building Queries ..........................................................................60
21.3. Creating Views ............................................................................61
21.4. Navigating Result Sets Within the Result Area ...................................61
21.5. Exporting Result Sets ....................................................................62
21.6. Handling BLOB and TEXT Columns ...............................................62
21.7. Editing Result Sets Within the Result Area ........................................63
MySQL GUI Tools Manual
v