Over a period of time, "mysql" tables usually get fragmented. It
degrades the performance of "mysql-server" significantly.
You may also find it worth your while to defragment your database tables regularly if you are using VARCHAR fields: these variable-length columns are particularly prone to fragmentation.
To defragment tables manually from command-line using mysqlcheck
You may also find it worth your while to defragment your database tables regularly if you are using VARCHAR fields: these variable-length columns are particularly prone to fragmentation.
Run the following command by replacing USER & PASS
values:
mysqlcheck -Aos -u <user> -p <password>
No comments:
Post a Comment