Re: make mysql server use more cpu power

[Rick James]

You have 8 cores? And it is using one of them solidly? Alas, MySQL does not use more than one core for one query.

Let's see the naughty query; 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 ]