Re: Major MySQL problems

[Rick James]

The settings cannot fix a high CPU problem. Find the slow queries (do SHOW PROCESSLIST, or look at the slowlog), then 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 ]
How much RAM do you have?

Recommend changing long_query_time to 2 to get more slow queries in the slowlog.