It’s a good idea to optimize and repair your MySQL databases on a regular basis, especially of the tables in your database undergo a lot of writes and deletes. Fortunately, it’s fairly easy to perform:
mysqlcheck -r your_database
And when that is complete you can optimize it like so:
mysqlcheck -o your_database
