Skip to main content

Bulk optimization of Mysql tables

Fragmented mysql databases are known to slow down the mysql server. And these bases need to be sometimes optimized: to defragment.

There are two ways to optimize tables with the mysqlcheck utility. The first:

  mysqlcheck -Ao 

Here: key A checks tables for errors, and key o performs optimization.

The second way:

  mysqloptimize -A 

The value of the keys here is the same. :)