We have a set of MySQL servers with 110GB of ram and 2x 6core intel cpus.
We get fairly good MySQL performance however when we do experience slow queries I take a look at system resources and see that RAM utilisation is good (nice and high) however CPU load is between 0.0 and 0.90.
Is this a good thing or is there settings I could change to make MySQL use more CPU to gain some performance?
I already renice MySQL to -20.
Thanks in advance