Linux.com

CyberGod

CyberGod

  • Linux.com Member
  • Posts: 2
  • Member Since: 14 May 09
  • Last Logged In: 17 Dec 12

Latest Posts

Posted by
Topic
Post Preview
Posted
  • CyberGod
    RE: Speeding up MySQL reads using noatime
    This works on any journaling file system like ext3
    Link to this post 30 May 09

    This works on any journaling file system like ext3

  • CyberGod
    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!
    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!

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