How to maintain MySQL Database Maintenance

Asked By jackson whiter 0 points N/A Posted 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?

• Status: Open
• Question Views: 677
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Parisi Petrusic 0 points N/A #157288

How to maintain MySQL Database Maintenance

Hello,

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.

https://www.laurencegellert.com/2011/07/mysql-maintenance-tasks-for-innodb-with-mysql-5-1/

 

Hope it helps.

 

Best Regards,

Parisi

About Parisi Petrusic

Questions
2

Answers
100

Best Answers
12

• Vote Up 0 Vote Down

• Posted on - 02/15/2013
• Question Category: MySQL Server