optimization

Hello All, I am bit struggling for load balancing on the Linux server.The rise in load is primarily because of mysqld daemon which occupies 99% of cpu.We have 4CPU and 2GB of RAM on server but still load on server always shows the figure of 12-20. With this I am attaching my output of...

Hey, I need some help with optimization of Apache & mySQL as sometimes my server load gets upto 1.30+. Average it remains 0.40+... I have already optimized my.cnf file by replacing the default my.cnf with the my-huge.cnf file. I had to optimize mySQL because a site that has a mysql db...

erm, confused by the formatting. the way i read it, mmcache did the best? p