MysSQL using 2 or 4 CPUs

MySQL & MariaDB Other MySQL® Questions
1

Hello Forum:

I need to optimize my MySQL database to use more than one cpu.
Currently it is only using one CPU. I would like to know if there is a command or parameter that I can add tot he my.cnf file for this to happen.

This is the cpu’s info:
model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
I would like to use 2 cpus on one server and 4 cpus on another server for mysql.

Thanks.
–Willie

2

MySQL uses several CPU’s as default.
BUT one query can only be executed in one thread.

So if you have long running queries like reports or something that is very CPU bound they will unfortunately basically only load one CPU on the machine.

On the other hand if you have a very CPU intensive query it usually is a sign that you could tune some indexes to speed it up.