Re: Load of CPU because of Mysql,PHP and SOAP
Posted by:
Rick James
Date: January 18, 2015 11:42AM
What queries are being performed? How often?
High CPU in MySQL almost always involves a missing index, poorly written SELECT, or an especially difficult problem. Knowing the queries and SHOW CREATE TABLE will help us zoom in on the problem and (hopefully) a solution.
(I doubt if SOAP or PHP is part of the problem.)
If the code is repeatedly doing "find nearest" without any indexes, that would explain it.
Subject
Written By
Posted
Re: Load of CPU because of Mysql,PHP and SOAP
January 18, 2015 11:42AM
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.