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 - 76 through 90 (of 96 total)
  • torbent

    (@torbentschechnegmailcom)

    Hello,
    I did implemented the fix in the mu-plugins directory and edited the taxonomy.php, but still my site shows a white screen.

    How can I do the necessary actions directly in the database?

    Thanks!

    Hi,

    I have a multisite and after the update to wordpress 4.3 the media library (from all my websites) was broken links and the images aren’t showing anymore.

    I did try the Otto solution by modifying taxonomy.php and adding the fix.php code to mu-plugins folder, still not working

    Any ideeas? Please help me, Thank you

    Moderator Samuel Wood (Otto)

    (@otto42)

    www.ads-software.com Admin

    @torben, @dudutz This is not a generic magic pill that will fix every possible problem. The post I wrote specifically addresses people having a problem with “high CPU load”. If you have other problems, like whitescreens or broken links and such, then you probably have some other issue. Start your own thread about your other, different problem.

    I found the problem, seems like the 4.3 version updated my wordpress multisite .htaccess file (which is not the same like a simple wordpress website), I have deleted the .htaccess and uploaded this, if helps someone, now my media library it’s back and the images path are working again.

    # BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]

# uploaded files
RewriteRule ^([_0-9a-zA-Z-]+/)?files/(.+) wp-includes/ms-files.php?file=$2 [L]

# add a trailing slash to /wp-admin
RewriteRule ^([_0-9a-zA-Z-]+/)?wp-admin$ $1wp-admin/ [R=301,L]

RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^ - [L]
RewriteRule  ^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*) $2 [L]
RewriteRule  ^([_0-9a-zA-Z-]+/)?(.*\.php)$ $2 [L]
RewriteRule . index.php [L]
</IfModule>
# END WordPress

    I am having the same issue. too many cron jobs being created causing the server to crash.

    I implemented this fix: https://www.ads-software.com/support/topic/high-cpu-load-after-update-to-v43?replies=82#post-7330770

    We’ll see if that fixes it. So far so good.

    Thanks for the WordPress community and Otto for fixing it. One of the more damaging bugs for an upgrade though.

    Thank you very much Samuel Wood (Otto)! Also for explaining everything so good. ??

    It worked like a charm. I already spend too much time on it and even moved servers because I was thinking it was my hosting (just like some others), but I’m glad this major problem is over now. I wasn’t sure anymore what to do next, so I’m glad I can put this all behind me.

    I just wonder why it takes WP so long to publish a new update with a fix. Or was this just affecting only a few sites?

    Thanks fix works for me. Now low cpu usage.

    https://postimg.org/image/sg7a8py9j/

    Thank you Otto, it works perfectly!

    So was this updated in the release of Version 4.3.1?

    Just want to confirm, as I know probably others are interested in knowing as well.

    https://core.trac.www.ads-software.com/log/branches/4.3/?rev=34199&stop_rev=33647

    The details on this is not very clear but feel this is a big enough issue to show concern.

    Thanks!

    Thank you !

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

    I updated to 4.3.1 and works fine, extra fine, go fast. Normal CPU usage and ram

    As posted above, I was successful with the mu-plugins fix. I would be interested to know, for these who did not go this route, does the 4.3.1 update fix the cron issues that would still exist and especially all the garbage in the database?

    Moderator Samuel Wood (Otto)

    (@otto42)

    www.ads-software.com Admin

    Yes, this is automatically fixed by 4.3.1. Both the issue with the reversed parameters and the extraneous cron entries are fixed.

    If you still have the issue, updating to 4.3.1 and performing any “database update” it asks of you will solve it immediately. The auto-upgrade process or the one-click upgrade process will perform the database fix automatically; there are no extra steps required there.

    For multisite installs, you must perform the “Upgrade Network” step for it to run the database fix over all the sites in your network.

    If you still have the mu-plugin I originally posted about on page 1 of this thread, then you can remove it. It is not necessary with 4.3.1.

    Hello,

    I also had the problem that I couldn’t login any more due to the cron entries in the database.

    I followed the steps of Otto on the first page. Now the site (backend) and everything works fine! Thank you for the instructions!

    I’m only wondered about one point: Before I followed the steps I looked into the source code to find out which version of WordPress currently runs on my webspace: It was 4.3.
    After I “patched” the installation with the help of the above post, WordPress says that now 4.3.1 is installed.
    Is that normal?

    Thanks in advance for every reply!

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