Re: High CPU usage by mysql process
select benchmark(50000000,(1234*5678/37485-1298+8596^2));
Return result in 11.1261 seconds.
select * from performance_schema.setup_instruments where name like 'wait/sync%' and (enabled='yes' or timed='yes');
Return no result.
Composite indexes helped a lot. Difference is really huge.
CPU Ussage now is jumping from 0% to 30% (sometimes 80%) when there are 200 online users on the site at the same time. Iis it fine or should be still lower?
Subject
Views
Written By
Posted
12653
May 04, 2016 03:32PM
4110
May 05, 2016 09:51PM
3337
May 06, 2016 09:33AM
Re: High CPU usage by mysql process
3016
May 08, 2016 04:56PM
2652
May 09, 2016 08:57PM
2714
May 10, 2016 02:30PM
2421
May 10, 2016 05:56PM
2341
May 10, 2016 07:59PM
2434
May 11, 2016 11:19AM
2168
May 08, 2016 04:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.