phploh Posted February 8, 2012 Share Posted February 8, 2012 Hi, My hosting company (Bluehost) told me when someone goes to my home page, it sends these series of queries and this is the reason for my high cpu usage and this is why my site says Error Establishing Database. The hosting company gave me these: Each script is using a decent about of CPU. [2:09:33 AM] hollane3 31881 6.2 0.1 186084 49000 ? RN 01:59 0:26 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php hollane3 934 6.6 0.1 184012 48652 ? RN 01:59 0:25 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php hollane3 5344 7.1 0.1 184008 48440 ? RN 02:01 0:21 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/wp-cron.php hollane3 5164 7.1 0.1 186444 48772 ? RN 02:01 0:22 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php hollane3 7246 6.9 0.1 184116 48196 ? RN 02:02 0:18 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php hollane3 11221 5.8 0.1 185160 47852 ? RN 02:03 0:09 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php hollane3 11236 6.4 0.1 182992 47620 ? RN 02:03 0:10 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/wp-cron.php hollane3 12595 5.4 0.1 183088 47264 ? RN 02:04 0:07 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php hollane3 13969 5.4 0.1 184648 47396 ? RN 02:04 0:05 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php hollane3 14161 6.1 0.1 182480 47140 ? RN 02:04 0:06 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/wp-cron.php hollane3 14198 6.7 0.1 183092 47204 ? RN 02:04 0:06 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php hollane3 16343 4.9 0.1 181968 46496 ? RN 02:05 0:02 | \_ /ramdisk/bin/php5 /home4/hollane3/public_html/index.php I am not well versed with scripting, so I don't know what this mean. Can anyone PLEASE help me to answer these questions: + Is this related to a particular plugin or widget or theme? + What could be the possible source of this issue, that is, which file should I look at to resolve this? + Can I fix this myself or do I need a php coder to help me? Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/256645-do-i-need-a-php-expert-to-solve-this-problem/ Share on other sites More sharing options...
QuickOldCar Posted February 8, 2012 Share Posted February 8, 2012 browse to public_html/wp-config.php and add this define('DISABLE_WP_CRON', true); If you need the wp-cron.php to run at specific times, create a cron job to point to wp-cron.php This can usually be done through your admin panel Run every 2 hours 0 */2 * * * Can use one of the following 2 methods php -q /home/cPanel_User/public_html/wp-cron.php wget http://YourDomain.com/wp-cron.php Quote Link to comment https://forums.phpfreaks.com/topic/256645-do-i-need-a-php-expert-to-solve-this-problem/#findComment-1315682 Share on other sites More sharing options...
phploh Posted February 8, 2012 Author Share Posted February 8, 2012 Hi, Thanks for your reply . Would like to ask you a few questions coz I am not sure: + browse to public_html/wp-config.php and add this: define('DISABLE_WP_CRON', true); Where exactly in the file should I insert this code? Also, I have just modified the memory limit in my PHP.ini file and added "define('WP_MEMORY_LIMIT', '64M'); " to my wp-config.php file (still cannot access site). Will there be any conflict? Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/256645-do-i-need-a-php-expert-to-solve-this-problem/#findComment-1315696 Share on other sites More sharing options...
QuickOldCar Posted February 8, 2012 Share Posted February 8, 2012 Almost any blank line would be good, just not within a comment /* */, or inside an if statement. Placing it before this line will be ok. /* That's all, stop editing! Happy blogging. */ WP_MEMORY_LIMIT and DISABLE_WP_CRON are 2 different things and will not conflict. As for your error connecting to database, it could be that your host disabled you due to the cpu usage, contact them and let them know you made these changes. Quote Link to comment https://forums.phpfreaks.com/topic/256645-do-i-need-a-php-expert-to-solve-this-problem/#findComment-1315766 Share on other sites More sharing options...
phploh Posted February 8, 2012 Author Share Posted February 8, 2012 OKay, thanks for your help. I will try it out. Cheers! Quote Link to comment https://forums.phpfreaks.com/topic/256645-do-i-need-a-php-expert-to-solve-this-problem/#findComment-1315789 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.