Posts Under 'optimize mysql database'

PHP Script to Optimize All Tables In A MySQL Database

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 […]

Read more »