Re: High CPU usage by mysql process

[Shane Bester]

this is really a shot in the dark, but can you check these two queries?


select benchmark(50000000,(1234*5678/37485-1298+8596^2)); #should take less than 16 seconds

select * from performance_schema.setup_instruments where name like 'wait/sync%' and (enabled='yes' or timed='yes');

If the second query returns many rows, you may have too much P_S instrumentation enabled, which can consume a lot of CPU.