MySQL Forums
Forum List  »  PHP

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.

Options: ReplyQuote


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.