MySQL Storage Manager (Revision #12)

With Aqua Data Studio 7.5 you can plan, initialize, allocate, manage, and tune MySQL database objects for better performance

The MySQL Storage Manager Engine Tab now gives:

• Summary of Engine Storage Information. This now includes Rows, Data Size, Table Count, Index Size and Total Size

New enhanced Object Tab in Aqua Data Studio 7.5 gives:

• High-level storage information of Tables which helps in tracking growth. This includes Engine, Rows, Data Length, Index Length, Data, Update Date, Collation, Created Options and Created Date
• Overall Database Storage information. You can sort and filter databases to quickly identify which Tables takes up more space. You can configure Storage and eliminate wasted storage

Object Tab - Display of the Tables.

Documentation -> MySQL DBA Tools -> Storage Manager

Below text goes to ADS 7.5 Documentation.

Object Name: Name of the database object
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: Total number of rows in the table
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: When the table was created.
Comment: The comment used when creating the table
Update Date:When the data file was last updated.
Check Date: When the table was last checked. Not all storage engines update this time, in which case the value is always NULL.
Collation: The table's character set and collation.
Checksum: The live checksum value (if any).
Create Options: Extra options used with CREATE TABLE.The original options supplied when CREATE TABLE is called are retained and the options reported here may differ from the active table settings and options.