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. :)
How do you rate the article?
(No ratings yet)
Loading...
(No ratings yet) Loading...
Sometimes (for example in ubunt) you may need to specify the name / password explicitly
something like: mysqlcheck —user = username —password = password -Ao
Yeah, I missed that moment. I have a .my.cnf file in my root folder where my mysql root password is registered. And the password is not requested. :)