Posts Tagged ‘OPTIMIZE TABLE’

MySQL Partitioning & OPTIMIZE TABLE

MySQL table Partitioning can be used in various way to improve performance. I wanted to get some idea of how this would affect database maintenance operations like OPTIMIZE TABLE. For these tests I used a default install of MySQL 5.6.15, with a key_buffer_size of 2GB, and executed OPTIMIZE TABLE table_name after a series of actions […]