MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

Re: Help! 15 users causing 100% CPU Usage by MySQL 5.7 in Windows 2012 R2
Posted by: Peter Brawley
Date: May 22, 2017 07:04PM

Is Windows swapping? If so, you need more RAM right away.

Run Show Processlist when the erver bogs down.

Is MySQL sharing the machine with the app?

Are you mostly using MyISAM or InnoDB?

Queries reported in the slow query log need optimisation, better indexing &c. If you have trouble, post Explain <query> and SHow C reate Table for referenced tables.

To get started ...

- run MySQLTuner and let's see itsoutput after a busy day,

- review http://mysql.rjweb.org/doc.php/memory

- run the scripts under "Optimisation cheatsheet" at https://www.artfulsoftware.com/infotree/mysqltips.php, post those results here too.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Help! 15 users causing 100% CPU Usage by MySQL 5.7 in Windows 2012 R2
Ben HACKNEY
May 22, 2017 04:52PM
Re: Help! 15 users causing 100% CPU Usage by MySQL 5.7 in Windows 2012 R2
Peter Brawley
May 22, 2017 07:04PM


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.