Hey Thanks! That script worked like a charm. Pointed out some serious issues I can work on!

This is not mission-critical stuff as I am working on a personal development box, but nonetheless I want to squeeze every bit of performance I can out of it!

The box is a Pentium M 1.6GHz with 512MB ram and a 4800rpm IDE hard drive. Hopefully soon I will be upgrading! The processor can manage easily enough for most tasks I throw at it, but the low ram (along with everything else the box does) is killing it.

top - 17:05:44 up 10 days, 18:44, 1 user, load average: 0.00, 0.06, 0.11

Tasks: 141 total, 1 running, 140 sleeping, 0 stopped, 0 zombie

Cpu(s): 0.3%us, 0.0%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st

Mem: 493668k total, 461716k used, 31952k free, 36972k buffers

Swap: 524284k total, 246276k used, 278008k free, 191976k cached

All scream with me now... lol

Thanks for the script. It helped quite a bit! Granted most of the recommendations won't work on this old machine. Unless I throw a ton of ram at it, but that is not possible.

nathan


On Thursday, February 21, 2013 15:41:51 Vimal Shah wrote:

Agreed on both fronts (optimizing queries and understanding locking)

You may have already done this, but tuning the my.cnf file to take advantage of the hardware can lead to some gains as well. Specifically during peak traffic times. There are many out there, but here's one that we'd had success with:

https://github.com/rackerhacker/MySQLTuner-perl