MySQL DBA Tools (Revision #36)

New DBA Tools for MySQL, including Instance Manager, Storage Manager, Security Manager and Session Manager.

MySQL DBA Tools	Instance Manager	Storage Manager	Security Manager	Session Manager

The Instance Manager provides instance-wide server statistics and information.

• Variables - Current mysql global and session variable values
• Status - system-wide global and session usage statistics
• Charsets - Character encodings available on this server
• Collations - Character encodings available on this server
• Plugins (starting MySQL 5.1) - Components installed on the server

The Storage Manager contains information about the amount of data contained in the database.

• Databases - Total storage used in each individual database
• Engines - Database Engines available in this instance
• Table Status - Individual table summaries with usage breakdowns
• Open Tables - tables currently open

Security Manager is another new feature for DB2 UDB which provides a simple view of Users. This is designed specifically to

• Create, alter, drop and view Users in a Server
• Provide a simple tree view of Users and Hosts, with sorting available using host name or user name

Session Manager is Aqua Data Studio’s latest feature which provides manageability of database sessions.  Session Manager allows the user to monitor and kill sessions. The parameters that are captured in this tool are

• Sessions - shows Session details with current statement being executed

Documentation -> MySQL DBA Tools -> Instance Manager

Documentation -> MySQL DBA Tools -> Storage Manager

Documentation -> MySQL DBA Tools -> Security Manager

Documentation -> MySQL DBA Tools -> Session Manager