Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have been using Postgres and MySQL for a long time now. There are a few routine maintenance chores that must be performed on a regular basis to keep a PostgreSQL server running smoothly. As as example

PostgreSQL's VACUUM command must be run on a regular basis for several reasons:

  1. To recover disk space occupied by updated or deleted rows.

  2. To update data statistics used by the PostgreSQL query planner.

  3. To protect against loss of very old data due to transaction ID wraparound.

Read more

But using MySQL database we don't have to do any of the above. Simply we don't have to do any maintenance on a MySQL database.

My problems are,

  1. Why is that we don't have to do any maintenance on a MySQL database?
  2. Is there a way to carry out maintenance on a MySQL database?

Given that I'm looking for a technical answer. As an example "database backup" is not the answer I'm looking for therefore below is not acceptable

General Mysql database maintenance advice

share|improve this question

migrated from stackoverflow.com Mar 3 at 12:13

This question came from our site for professional and enthusiast programmers.

1  
OPTIMIZE TABLE? Btw, in postgresql you don't even VACUUM explicitly because of autovacuum. –  zerkms Feb 28 at 4:13
    
Your question seems to be looking for some general idea of maintenance which this answer seems to carry just fine, General Mysql database maintenance advice –  Prix Feb 28 at 4:15
    
It's not only VACUUM, There are tons of way to get the maintenance work done. –  Techie Feb 28 at 4:16
5  
You're reading the 8.1 documentation. Try reading documentation for a less pre-historic version, where it will discuss autovacuum. –  Craig Ringer Feb 28 at 5:07
    
Thanks for info –  Techie Feb 28 at 5:16

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.