Linux.com

Home Linux Community Forums Software Productivity Speeding up MySQL reads using noatime

Speeding up MySQL reads using noatime

Link to this post 15 May 09

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!

Link to this post 29 May 09

No journaling right? Wouldnt file system type selection also be important?

Link to this post 30 May 09

This works on any journaling file system like ext3

Who we are ?

The Linux Foundation is a non-profit consortium dedicated to the growth of Linux.

More About the foundation...

Frequent Questions

Join / Linux Training / Board