A message for Linux.com registered users: We are in the process of making changes to the Linux forums. Starting Monday, 8/13/18 at 6:00 PM PT, you will be unable to access the forums. They will re-launch as soon as possible on Wednesday, 8/15/18 with new features and improved functionality. Thank you for your patience and stay tuned for the new improved forums.
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.