High CPU Load After Update to v4.3

  • Resolved Tranny

    (@tranny)


    9 years, 3 months ago

    I run a busy high traffic and high community participation site, so MySQL has always run very high on my server. But after upgrading to v4.3 (no other change), my CPU load tripled, and it’s crippling the server, causing frequent crashes and generally degraded responsiveness.

    The site is hosted on a high end dedicated server with 4 SSD drive in hardware RAID. I spoke with my host and they assured me no changes have been done to the server, and all server side applications are up to date.

    Problems started after the update to v4.3, No other change whatsoever has been done to neither the WP installation, nor the server itself.

    My log shows high http connection count, which use abnormally high CPU never seen before:

    PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
17368 mysql 20 0 9348m 441m 6852 S 42.0 1.8 8:35.43 mysqld
17941 xxxxx 20 0 1474m 54m 4748 S 27.5 0.2 0:10.38 httpd
18526 xxxxx 20 0 1463m 43m 4680 S 27.1 0.2 0:01.42 httpd
16675 xxxxx 20 0 1467m 46m 4284 S 24.8 0.2 0:17.30 httpd
16830 xxxxx 20 0 1463m 42m 4300 S 23.5 0.2 0:16.92 httpd
17777 xxxxx 20 0 1454m 34m 4780 S 23.5 0.1 0:11.56 httpd
18358 xxxxx 20 0 1460m 40m 4760 S 23.5 0.2 0:04.49 httpd
17881 xxxxx 20 0 1460m 40m 4716 S 23.2 0.2 0:09.88 httpd
18220 xxxxx 20 0 1441m 21m 4768 S 23.2 0.1 0:05.12 httpd
18472 xxxxx 20 0 1460m 40m 4748 S 23.2 0.2 0:04.12 httpd
18331 xxxxx 20 0 1505m 84m 4700 S 22.5 0.4 0:04.02 httpd
16892 xxxxx 20 0 1463m 43m 4316 S 22.2 0.2 0:09.67 httpd
16872 xxxxx 20 0 1441m 20m 4240 S 17.9 0.1 0:21.70 httpd
18248 xxxxx 20 0 1446m 26m 4756 S 16.9 0.1 0:03.51 httpd
16479 xxxxx 20 0 1461m 41m 4688 S 16.2 0.2 0:19.24 httpd
16870 xxxxx 20 0 1458m 37m 4216 S 16.2 0.2 0:16.59 httpd
18452 xxxxx 20 0 1474m 54m 4652 R 14.2 0.2 0:01.97 httpd
16729 xxxxx 20 0 1461m 40m 4208 S 12.2 0.2 0:18.65 httpd
16978 xxxxx 20 0 1455m 35m 4248 S 9.3 0.1 0:11.55 httpd

    Can anyone help me out with this? What happened? This is the first time I see my server getting crippled after a WP update and I’ve run this particular site on WP since 2008.

Viewing 15 replies - 61 through 75 (of 96 total)

  • Just writing to say THANKS – when I look at my resource graph over the past 28 days, I can see the memory usage creeping up and it’s more than halved after this fix! And no CPU warnings at all.

    What a crazy bug.

    Thanks guys for the fix, we got literally crazy finding out why the site was so slow.

    Anonymous User 7600456

    (@anonymized-7600456)

    Yep, like many others I have spent a couple of days trying to figure this out.

    Otto’s fix worked. Thanks Otto!

    Best,

    Joseph

    I’ve been going crazy with website crashes and slow loads (longer than 30 seconds). I was going to hire someone, when I found this post.

    And it worked. Almost instantly. Pages now load in 1 second, maybe faster.

    Thank you Otto. You saved me from buying a new MacBook Pro, since I was about to fling this out of my window. So you save me the cost of the computer AND one window.

    I also have write a hotfix. Its a bit simulat to others hotfixes, but you don’t need to change source code and it works as a plugin

    https://github.com/butuzov/hotfix-wp_batch_split_terms

    1) it clean up your cron events array
    2) it replace a broken action by working one.

    I am so thankful I came across this thread, I just had a white screen after updating the Woocommerce plugin on the latest version of WP (V4.3) (on the latest version of the Divi by Elegant Themes theme).

    I’ve just tried this fix and I can confirm it worked a treat for me – I’ve reactivated the updated Woocommerce plugin and everything is working all A ok now.

    Thank you so much to the person that came up with this fix, I can’t thank you enough!!!!

    Re: Post 68
    GoDaddy-ADMIN had to remove the excessive System Processes – They could not deleted from within their utility.
    So far so good – Hope Otto’s fix works – and holds . . .

    I am using nginx 1.9.4 + wordpress + mariadb + php 5.6 and was also experiencing the problem. I had several hundred wp_batch_split_terms cron jobs scheduled. This issue was causing scheduled posts to miss their schedule.

    After editing taxonomy, I ran fix #1 in mu-plugins. It resulted in a very slight load increase for about 2 minutes.

    I could see that it worked because the cron jobs were all gone, except for one which I assume was legitimate. Using the Debug Objects plugin or the WP Advanced Cron Manager plugin helps you see the spammed cron jobs go away.

    I changed my cron_fix.php to include the one-db-call version Otto worked on. I am going to leave that in place for a bit as it seems to have zero impact on my site and I don’t want the problem to return.

    Thanks so much for all your hard work and patience, @otto42.

    WPChina

    (@wordpresschina)

    Thank you Otto!! I’ve been part of the WordPress community for almost 10 years, and this is one of the oddest things I have seen. We had a log file grow to 2GB+ and this type of load on one server:

    [root@webserver ~]# uptime
 07:08:21 up 59 min,  1 user,  load average: 199.18, 141.22, 76.20

    Now things are back to normal here:

    [root@webserver ~]# uptime
 07:19:51 up  1:10,  1 user,  load average: 4.24, 48.87, 71.06

    I HIGHLY suggest WordPress issue fixes immediately. We notified law enforcement in the jurisdiction one of our clients because part of our log files involved a DDOS support company getting involved and we followed our security policies. More hosts and companies need to be aware of this, because at first glance, it appears like DDOS on a WordPress site.

    Josh

    (@modernspark)

    I found this solution way too late. Otto’s fix resolved so many issues I was having. I thought it was my server, so I migrated to a new server. Then the new server got completely overloaded, so I upgraded to a better plan. That was still getting overloaded with no clear reason or change in traffic or usage. I thought it was just the hosting providers, but this had to be the issue. Since the server was getting overloaded, everything was acting strange, including uploading photos, scheduling posts, and my calendar loading. So far, this seems to resolve my issues. This bug has cost me a lot of time and money, but I’m thankful for the fix.

    Thumbs up for Otto!

    Great workaround, you got my credits for this!
    Why does we have to wait for 4.3.1 so long?

    Thank you Otto!

    Used your alternative solution and it worked super fast, super well.

    Thank you Otto, I was having problems trying to open pages to edit since the update to 4.3. Having just done some major maintenance on my computer and changed browsers, I thought that the problem might be at my end. About a week ago, I decided to check it out and found these pages about the time that Otto posted his first fix. Seeing some possible issues, I waited another day and saw the second fix. I ran it and everything was back to normal. Very satisfying! Where is 4.3.1?

    This is a bad bad issue created by 4.3. Like many others I was going mad with tracking this down. I’d recently moved servers on one of my sites and I thought that might be the issue.

    Many thanks to those that contributed to the fix, it worked fine and I am grateful.

    But why isn’t there a generic 4.3.1 fix released yet? I have over a hundred sites on a variety of hosts and manually checking which are blasting the poor hosts to death and fixing them is not something I relish.

    THANK YOU VERY MUCH OTTO! ??

Viewing 15 replies - 61 through 75 (of 96 total)
  • The topic ‘High CPU Load After Update to v4.3’ is closed to new replies.