MySQL DBA Tools (Revision #18)

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

Instance Manager is the latest DBA Tools feature for MySQL which provides a simple view of  the Server information, which includes

• Variables

• Status

• Charsets

• Collations

• Plugins

With the latest Storage Manager for MySQL, a user can visualize and maintain storage. This feature provides a tree view of objects which includes the path, size and usage. Users can view storage information
 

• Databases

• Engines

• Table Status

• Open Tables

Security Manager is another new feature for MySQL which provides a simple view of Users and their Database access. This is designed specifically to
 

• Create Users in a Server

• Alter either a single User or group of Users and privileges

• Create object permissions for Users across all objects in a database

• Provide a simple tree view of Users

Session Manager is Aqua Data Studio’s latest feature which provides manageability of database sessions. This tool can quickly identify session information and avoid unnecessary overheads. Session Manager allows the user to monitor and kill sessions. The various parameters that are captured in this tool are
 

• Database

• Process ID

• Host

• Port

• User

• Command

• Time

• State