Welcome to the new Linux Foundation Forum!

Speeding up MySQL reads using noatime

Here's a little secret not many Linux administrators know:

If you don't care about post-mortem analysis of a system and just want it to perform much faster, especially if you're running MySQL just remount the partition where your databases are stored with the noatime option:

[[email protected]]# mount -o remount,noatime /var/lib/mysql

This will improve the system I/O by at least 25%.

The only drawback is that none of the file's atime (access time) will be updated.

Enjoy!

Comments

  • tinnytinny Posts: 5
    No journaling right? Wouldnt file system type selection also be important?
  • CyberGodCyberGod Posts: 2
    This works on any journaling file system like ext3
Sign In or Register to comment.