Support

Hello,

at the end of the day, database tables are just files on disk containing organized data. Every single operation on the table creates a little of "mess" with those organized files, so from time to time it's a good habit to let MySQL tidy up everything and restore a clean status.
This won't affect your data (ie you won't lose users or information), it's merely an internal operation to boost performance.

That said, you can schedule Admin Tools to do that automatically using a CRON, the logic is the same of the PHP File Scanner, you only have to change the target file with admintools-dbrepair.php.

The equivalent command in MySQL is (surprise surprise) OPTIMIZE table_name. You can run this query by yourself using phpMyAdmin, but you'll have to do that manually for each table, there isn't a "optimize all" button.