In MYSQL OPTIMIZE 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. Deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions. You can use OPTIMIZE TABLE to reclaim the unused space and to defragment the data file.
OPTIMIZE TABLE statement requires SELECT and INSERT privileges for the table.
This PHP script will optimize all the tables in a particular mysql database.
Comments are closed.