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
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss 
(text/plain)