Feature: #25341 - Scheduler task to optimize database tables
See forge#25341
Description
A scheduler task to run the OPTIMIZE TABLE command on selected
database tables has been added. The OPTIMIZE TABLE command
reorganizes the physical storage of table data and associated index
data to reduce storage space and improve I/O efficiency when
accessing the table. The exact changes made to each table depend
on the storage engine used by that table. For more information see
the MySQL manual.
The scheduler task is meant for the MySQL database system and only shows tables matching the MySQL storage engines MyISAM, InnoDB and ARCHIVE. Using this task with DBAL and other DBMS is not supported as the commands used are MySQL specific.
Impact
Optimizing tables is I/O intensive. On MySQL < 5.6.17 it also locks the tables for the whole time, which can severely impact the website while it is running. When considering whether or not to run optimize, consider the workload of transactions that your server will process as InnoDB tables do not suffer from fragmentation in the same way that MyISAM tables do.