MySQL - Storage Manager

Toolbar Operations - Depending on the Tab selected, there are different Toolbar Operations available.

Available Operations for Databases Tab
Refresh: Refreshes all tabs in the storage manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Size: Shows total size of the database in the selected unit of measurement
Create Database: Creates a new database
Drop Database: Drops the selected database
Database Properties: Shows properties of selected database

Available Operations for Engines Tab
Refresh: Refreshes all tabs in the storage manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Size: Shows total size of the database in the selected unit of measurement

Available Operations for Objects Tab
Refresh: Refreshes all tabs in the storage manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Size: Shows total size of the database in the selected unit of measurement
Database: Chooses the database you want to see the objects from

Available Operations for Open Tables Tab
Refresh: Refreshes all tabs in the storage manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Size: Shows total size of the database in the selected unit of measurement
Database: Chooses the database you want to see the objects from
 

Databases Tab - Provides a list of the databases

Name: Name of the database or database device
Default Char Set: Type of char set
Default Collation: Name of collation
Total Size: Total allocated space for the database/database device

Engines Tab - Provides a detailed information on each ENGINE.

Name: Name of the engine
Support: Indicates support for engines. Default engine is also displayed
Transaction Support: Indicates support for Transaction
XA Support: Indicates support for XA
Savepoint Support: Indicates support for Savepoints
Comments: Displays the comments associated with the Engine
Table Count: Total number of tables in the Engine
Rows: The number of rows of the Engine
Data Size: Total size of data in the Engine
Index Size: Total size of index in the Engine
Total Size: Total space utilized in the Engine
Index Fraction: The index fraction of the Engine
 
 

Objects Tab - Provides a detailed information of Tables in Databases. Contains the usage of space which is helpful to the Users

Name: The name of the table
Engine: The storage engine for the table
Version: The version number of the table's .frm file
Row format: The row storage format (Fixed, Dynamic, Compressed, Redundant, Compact). The format of InnoDB tables is reported as Redundant or Compact
Rows: The number of rows. Some storage engines, such as MyISAM, store the exact count. For other storage engines, such as InnoDB, this value is an approximation, and may vary from the actual value by as much as 40 to 50%
Avg Row Length: The average row length
Data length: The length of the data file
Max Data Length: The maximum length of the data file. This is the total number of bytes of data that can be stored in the table, given the data pointer size used
Index Length: The length of the index file
Data Free: The number of allocated but unused bytes
Auto Increment: The next AUTO_INCREMENT value
Create Date: Date and time the table was created
Update Date: Date and time the data file was last updated
 

Open Tables - Provides a list of database tables and detailed information on each

Database: Name of the database
Name: Name of the table
Lock Requests: Number of lock requests
Name Locked: Whether the name is locked or not