High CPU usage when upgrade to WooCommerce version 5.5.1

  • Resolved Daniel Trieu

    (@vietcuong82)


    2 years, 9 months ago

    After 2 days of upgrading to version 5.5.1, I was forced to downgrade back to version 4.4.2.
    I had the problem of high CPU usage for the Mysql process. When using version 5.5.1, and opening a few orders at the same time, cpu usage for mysql process has increased over 90% it makes my website almost unresponsive within 5-10 minutes because of CPU overload. Note that this problem only occurs when opening order detail or product detail page, other pages work normally.

    I also had the same problem with Wocommerce admin plugin version 2.4.1, when opening the oder detail pages and product detail page cause high CPU usage for MySQL process.

    Now I have removed the Wocommerce admin plugin and downgraded WooCommerce to version 4.4.2, everything is back to normal.

    Has anyone had the same problem as me?

Viewing 8 replies - 1 through 8 (of 8 total)
  • lidiacrochettricot

    (@lidiacrochettricot)

    2 years, 9 months ago

    Yes, same issue here, I had to downgrade. To open an order (in backend) was almost impossible, to much time to load. And the frontend became slow also.

    gferguson78

    (@gferguson78)

    2 years, 9 months ago

    Exactly the same issue here as well. Opening a product page was taking about 30secs – most of that was just to update the _edit_lock meta. There’s clearly an issue with MySQL processes in V5.5.1

    LitExtension_Lucas

    (@lucaslitextension)

    2 years, 9 months ago

    Hi @vietcuong82,

    Here are my suggestions:

    1. Change the default login url ( Recommended to all wordpress sites )
    It can be done by changing it in the wp-login.php file in your WordPress directory where plugin needs to write hooks.
    Or the simplest way is to using available plugins.

    2. Forbidden all of access to wp-login.php by editing your htaccess.

    3. I dont recommended to use web application firewalls plugins cause they can reduce your website’s performance.

    Let me know if my answer can help you resolve your issue.

    Thread Starter Daniel Trieu

    (@vietcuong82)

    2 years, 9 months ago

    Hi @lucaslitextension,

    Thanks for your reply. But as I mentioned, The WooCommerce version 5.5.1 cause “high CPU usage”, Then I downgraded WooCommerce to version 4.4.2, everything is back to normal.

    It means that I have already solved my issue. It took me all day to figure out the problem is Woocommerce version 5.5.1 and Woocommere admin 2.4.1 have an issue when querying table wp_postmeta which has around 1.2 million rows. I tested this issue by delete all plugins, just keep only Woocommerce plugin, and also stop all traffic from outside. It means I’m the only one who can access the website.

    My conclusion: there is some issue in my wp_postmeta table (empty/null value or something) and Woocommerce version 5.5.1 just keeps query until timeout, then it causes high CPU usage. Of course, if we set up a new website without any data, then this issue will never happen.

    I just wanted to post it here so that if anyone has the same problem as me, they can try to downgrade Woocommerce to check whether it can solve the problem.

    • This reply was modified 2 years, 9 months ago by Daniel Trieu.
    • This reply was modified 2 years, 9 months ago by Daniel Trieu.
    Thread Starter Daniel Trieu

    (@vietcuong82)

    2 years, 9 months ago

    I am aware of the risk of “Critical WooCommerce SQL Injection Vulnerability” if I don’t upgrade to version 5.5.1 but I have no choice. I have to downgrade back to version 5.4.2 because I can’t stand opening only 1, 2 orders that cause CPU to reach nearly 100%. While without opening the order, the CPU is only at 20-30%.

    I’m still trying to figure out what’s going on between WooCommerce 5.5.1 and my database.

    Plugin Support Gabriel – a11n

    (@gabrielfuentes)

    2 years, 9 months ago

    Hi everyone 👋

    It sounds like the following topic I’m sharing with you discusses this issue. In that topic, you will find a workaround and more details about this issue. Here is the linK:

    https://wordpress.org/support/topic/mysql-problem-with-5-5x-update/

    Cheers! 🙂

    Thread Starter Daniel Trieu

    (@vietcuong82)

    2 years, 9 months ago

    HI @gabrielfuentes,

    Thank you so much.

    Plugin Support Gabriel – a11n

    (@gabrielfuentes)

    2 years, 9 months ago

    You are very welcome 😃

    Great! I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Cheers.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘High CPU usage when upgrade to WooCommerce version 5.5.1’ is closed to new replies.