Re: URGENT: MySQL don't get enough CPU

[Rick James]

Your specific question is an OS question.

But usually the problem is really that the queries need to be better optimized. Find the queries that are running too slowly, then please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]

If we can make the queries run faster, the original question will be moot.