I'm on a quadcore CENTOS 5.9 i686 standard running WHM 11.36.0. It's a dedicated LAMP server with lots of websites, most of which are using databases. I'm monitoring the server using Munin and notice the load is always quite high, pushing the limits (often >4). Munin also shows a memory graph which indicates constant swapping and committed memory averaging around 5-6 GB on a 4GB RAM server. Surely this isn't healthy?
I have tried to tweak mysql using tuning-primer.sh and mysqltuner.pl, but I'm now at a point where I feel I cannot do more. These tools keep recommending stuff, but whatever I do, they keep giving new advice, and I feel I am running in circles now. So my question is: is there a point when it's becoming practically pointless to try and tweak mysql further, even though it may theoretically be possible to squeeze out more performance?
Is there an easy way to know if mysql is maxed out?