Re: MySQL huge CPU usage

[Rick James]

STATUS, without VARIABLES --> not enough information.

Query cache --> rarely much impact on CPU.

Find the "slow" queries -- either through SHOW PROCESSLIST or the slowlog. Then show us one or two queries, together with SHOW CREATE TABLE and EXPLAIN SELECT ...;

We may be able to help you improve the queries to avoid high CPU. Inadequate indexes is a common cause. Or lack of understanding "compound indexes". Or poorly formulated queries.