Repair/Optimize – Database
This section of SupportSuite displays the software MySQL database Tables in a list providing its details and allowing you with the options to Repair/Optimize the individually as well as all of them together.

Kayako ss dbase002 Repair/Optimize

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.

Notes: What is MyISAM and HEAP?

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

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.

Notes: What is the difference between REPAIRING a table and OPTIMIZING a 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.

Kayako ss dbase003 Repair/Optimize

Note: Optimizing all the database tables together can be CPU intensive and hence it can slow down your server temporarily.