Welcome to the 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:

[root@host]# 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

  • tinny
    tinny Posts: 5
    No journaling right? Wouldnt file system type selection also be important?
  • CyberGod
    CyberGod Posts: 2
    This works on any journaling file system like ext3

Categories

Upcoming Training