03-16-2009, 06:15 PM
Join Date: Mar 2009
|As for noatime... it will help.. but it is actually minimal. I have done testing... only expect a very very slight performance gain.
You can google "noatime" and find many pages about how to enable this attribute.
As for optimizing your mySQL, download and install MONyog... 30 days is free... it is helpful.
Let it run for a few days, and use the Monitors / Advisors page to see what you should optimize in your my.cnf.
Turn on your slow-log also, and get the users on your server who have slow queries to optimize them.
As for IOWAIT, SSH into your server and run top
It will give you and idea of your IOWAIT times.
Also, monitor your server with Wormly - and setup health monitoring - it will keep graphs about your server performance giving you data to reference when doing tweaks.
Or hire an experienced SysAdmin... we offer these services if you need it.