MySQL CPU use

MySQL & MariaDB Other MySQL® Questions
1

Hi All,

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

2

“CPU load of 0.90” means 90% of all 12 cores?

CPU cycles are not always well spent, what if a global mutex is slowing everything down? You could use a profiler to verify this.

What version of MySQL are you using?

3

I wouldn’t renice mysqld that much. If it goes crazy for any reason, and you have to try to log in to shut it down or something… good luck getting a command prompt :slight_smile: