MySQL Forums
Forum List  »  Performance

CPU Usage Maxing Out
Posted by: Anna M
Date: February 03, 2014 05:39PM

Hello,

I have installed a fresh version of a Wordpress site on my web host's server, deactivated plugins, installed WP Super Cache, limited certain countries' IPs from hitting my site, and altered code to up the memory limits to 256MB. I still get 100% CPU usage stats on the server.

My web host says my PHP memory limit is 256MB and my CPU RAM is 1 GB.

I look at phpMyAdmin and run the status/advisor and it returns 17 issues and recommendations. Since I am a newbie, I don't know how to begin to implement the recommendations. One such issue I show is:

"The rate of reading the first index entry is high. This usually indicates frequent full index scans. Full index scans are faster than table scans but require lots of CPU cycles in big tables, if those tables that have or had high volumes of UPDATEs and DELETEs, running 'OPTIMIZE TABLE' might reduce the amount of and/or speed up full index scans. Other than that full index scans can only be reduced by rewriting queries."

Could someone please point me in the right direction of how to do this/troubleshoot?

Thanks very much for taking a look!

Options: ReplyQuote


Subject
Views
Written By
Posted
CPU Usage Maxing Out
3136
February 03, 2014 05:39PM
1342
February 03, 2014 05:46PM
1154
February 04, 2014 10:20PM
1355
February 05, 2014 02:07PM
1296
February 06, 2014 07:41PM
1277
February 07, 2014 12:55PM
1523
February 07, 2014 06:32PM
1280
February 13, 2014 10:34AM


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.