The Table List has been sub-divided into six sub-sections:
Table Name: Displays the MySQL Database Table name.
Table Type: Displays the Storage Engine type for this table. SupportSuite uses ‘MyISAM‘ and ‘HEAP‘ as the storage engines for its database tables.
MyISAM: MyISAM is the default storage engine based on the ISAM code but has many useful extensions.
HEAP: The MEMORY storage engine creates tables with contents that are stored in memory. Before MySQL 4.1, MEMORY tables are called HEAP tables. As of 4.1, MEMORY is the preferred term, and HEAP is a synonym for MEMORY.
For more information, please refer to MySQL.com
Rows: Displays the number of Rows the table contains.
Size: Displays the Size of the data the table contains
Index Size: Displays the Index size of the table
Options: The Options section have two settings:
– Repair: Using this setting you can repair the database table.
– Optimize: Using this setting you can optimize the database table.
Repairing a table means you are correcting a possibly corrupted table. Normally you would never have to run this statement, however, if disaster strikes the Repair Table feature is very likely to get back all your data from a table.
Optimizing a table should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows. You can use this feature to reclaim the unused space and to defragment the data file. The process can be CPU intensive incase of large tables as optimizing a table/database results in rewriting of index files.
SupportSuite also allows you to Repair as well as Optimize all the MySQL database tables together. You can do so by clicking on the ‘Repair All‘ or ‘Optimize All‘ tabs found at the bottom of the MySQL Table List.