N/APosted on - 02/03/2013
Hello, I have 8 databases. I understand that I have to keep an error log, query log and a binary log. But I don’t understand the steps in how to maintain these databases. Can anyone explain the steps for mysql database maintenance?
How to maintain MySQL Database Maintenance
MySQL typically requires relatively little house keeping work as compared to other types of RDBMS. But the minimum actions that one needs to take in order to properly do maintenance on MySQL databases include the following.
Back up database with mysqldump.
Check table integrity for errors. You can do it on either one table at a time or all tables in one go.
Optimize tables to reclaim unused space. Tools that can be used for this purpose include MyISAM and InnoDB.
Analyze, in order to rebuild and optimize the indices performance.
Please have a look at the website below for more details on MySQL database maintenance.
Hope it helps.