Re: Load avg is 65 and cpu is 100% on mysqld

[Rick James]

SHOW VARIABLES LIKE 'query%';

Don't set query_cache_size bigger than 50M; it efficiency declines.

Or maybe you should turn off the QC. The ratio hits/inserts is very low.

Then, look in the slowlog to see which queries are slow, and 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 ]