Home › Forums › WoodMart support forum › Dedicated Server Crashing

Dedicated Server Crashing

Viewing 22 posts - 1 through 22 (of 22 total)
  • Author
    Posts
  • February 18, 2025 at 9:17 pm #639180

    mark-3189
    Participant

    Hi there,

    I am having an issue with too many mySQL queries. It has only been a problem in the last few weeks, kind of since my last update of everything.
    The website is now crashing a couple of times a day. I have had the guys at Plesk look at it for me. This is the problem:
    According to their analysis, the issue is related to the application causing a high load on MySQL, resulting in “Too many connections” errors.

    I have increased many things like ‘max_connections’ from 151 to 300 and php memory but nothing is helping. If anything it is getting worse. I restart the server each time which solves the problem until the next time.
    Could you please help! The site is looking good and running nice and fast, until it crashes the server.

    I wonder if a good start might if you could recommend dedicated server settings for this theme running 10,000+ products. And then if you could help me identify the cause of the mySQL load.

    Kind regards,

    Mark

    February 19, 2025 at 10:11 am #639278

    Artem Temos
    Keymaster

    Hello,

    Thank you so much for contacting our support center.

    To better assist you, could you kindly test the functionality with default WordPress themes such as TwentyTwenty or WooCommerce Storefront? This will help us determine whether the issue stems from our theme or elsewhere.

    Regards

    February 19, 2025 at 1:39 pm #639376

    mark-3189
    Participant

    Hi there,

    Could you explain a little more how you would like me to do that? Are you suggesting that I let it run like that for a few hours?

    Also, not sure if this could be related or not but I see you have a patcher tool. I have never seen this type of thing. I usually just update the theme. Is this OK to do? I assume the patcher is great for specific issues people find but if I don’t have the issue to bypass them and wait for the main theme update? OR should I apply all of the patches!? After testing of course.

    Kind regards,

    Mark

    February 19, 2025 at 4:52 pm #639425

    mark-3189
    Participant

    UPDATE: I am doing more plugin research. I have seen that you say the Woo legacy API plugin is not needed. I have deactivated that on LIVE and everything seems good. Maybe this will solve my problems!?

    I am now just updating everything and then will of course keep a close eye on things. I hope it can last the night without crashing.

    February 20, 2025 at 10:23 am #639567

    Artem Temos
    Keymaster

    Hello,

    This issue doesn’t seem to be related to our theme that is why we recommend to test with a default theme for some period also.

    As for the patcher tool, read more information in the documentation here https://xtemos.com/docs-topic/automatic-patcher/

    Kind Regards

    February 20, 2025 at 5:38 pm #639717

    mark-3189
    Participant

    Thank you for the link regarding the Patcher tool. I completely understand that now.

    My server still crashes although less frequently now after I have done more server balancing and got rid of a few more plugins that weren’t needed. I am also now running Immunify360 on the server.

    I am trying to avoid running the site on 2025 theme. Might I possibly let you know what Plesk support replied to my issue:

    *****
    Hello,

    I checked the server and indeed MySQL is getting a hit, Plesk was not available for the same reason:

    Error: SQLSTATE[08004] [1040] Too many connections
    [2025-02-06 13:34:02.013] 442322:67a4ba4a01d22 ERR [panel] DB query failed: SQLSTATE[08004] [1040] Too many connections:
    0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79
    Db_Adapter_Pdo_Mysql->query(string ‘SET sql_mode = ”’)
    1: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:113
    CommonPanel_Application_Abstract::initDbAdapter()
    2: /opt/psa/admin/plib/Session/Helper.php:176
    Plesk\Session\Helper::initStorage()
    3: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:48
    CommonPanel_Application_Abstract->run()
    4: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:30
    CommonPanel_Application_Abstract::init()
    5: /opt/psa/admin/plib/pm/Bootstrap.php:18
    pm_Bootstrap::init()
    6: /opt/psa/admin/plib/sdk.php:11
    I also checked the list of queries, and some of them seem to be quite large: [see image attached]

    At this point, I suggest optimizing the application that causes load on MySQL. We can increase the pool size even more, but the issue will return until the root cause is solved.
    ******

    So this is where I am at. Does the above shed any more light on this from your prospective? Again the site is still running very nicely when not crashed.

    Kind regards,

    Mark

    February 21, 2025 at 10:09 am #639816

    Artem Temos
    Keymaster

    Anyway, you need to run your tests with the default theme to see if it is somehow related to our theme or not.
    As a side note, the error is about the connections limit, not the number or size of the queries.

    February 21, 2025 at 1:44 pm #639909

    mark-3189
    Participant

    Hi there,

    I have now activated twenty twenty five theme. I will let it run for 24 hours. I really appreciate your help with this and hope to find the issue soon.

    Kind regards,

    Mark

    February 21, 2025 at 7:14 pm #640021

    mark-3189
    Participant

    I just wanted to update you before the end of the day. Please see attached image.
    You can see where I activated 2025 theme at 10:30 and the RAM usage has reduced by 25%. Woodmart when running seems to use near 100% of our 32GB RAM. I have just spoken to IONOS our dedicated server provider and they have said that it does seem that Woodmart is causing memory issues based on this evidence from today.

    I do hope this helps find the solution.

    Kind regards,

    Mark

    Attachments:
    You must be logged in to view attached files.
    February 24, 2025 at 10:57 am #640337

    Artem Temos
    Keymaster

    Hello,

    Do I understand correctly that it is a new issue not related to the initial database errors?
    If so, we need your full website access and allow us to switch between themes and monitor memory consumption in real time.

    Kind Regards

    February 24, 2025 at 1:25 pm #640432

    mark-3189
    Participant

    We are now just running the 2025 theme as the Woodmart crashes after an hour or 2. 2025 I have been running for nearly 2 days now and it seems very stable.

    Kind regards

    Mark

    • This reply was modified 1 month, 4 weeks ago by Artem Temos.
    February 24, 2025 at 1:55 pm #640447

    Artem Temos
    Keymaster

    We also need to monitor your server’s memory in real time to see the difference between themes.

    February 24, 2025 at 6:42 pm #640602

    mark-3189
    Participant

    root

    • This reply was modified 1 month, 4 weeks ago by mark-3189. Reason: log in details put in wrong field :/
    February 24, 2025 at 6:42 pm #640603

    mark-3189
    Participant

    https://server.watermonkey.co.uk:8443

    February 25, 2025 at 11:19 am #640754

    Artem Temos
    Keymaster

    As we can see, the memory usage is the same while our theme was not activated at all. Here is the screenshot https://gyazo.com/c14dd184fac341db86a9c0faac9fa284

    February 25, 2025 at 4:07 pm #640888

    mark-3189
    Participant

    If you activate Woodmart. The server will crash after a few hours. 2025 is very stable. I admit, the RAM usage does go up over time even with 2025 activated.
    With 10000+ products (including variations) and large product descriptions, should the website run on a dedicated server with 32GB ram?

    If you think having more RAM is a good idea, we could move to a server with more. We just need to find a solution as we love the website the Woodmart but it just doesn’t work for us at the minute. What do you suggest?

    Kind regards,

    Mark

    February 25, 2025 at 4:14 pm #640891

    Artem Temos
    Keymaster

    Server crashes are generic issues, and you need to understand what exactly is wrong. As we understood, they told you that the theme has a memory issue. But as you already noticed, it has no relation to the theme and to the memory at all. That is why you need to continue discussing this with your server providers.

    Kind Regards

    February 26, 2025 at 12:11 pm #641065

    mark-3189
    Participant

    Again, I really appreciate your help.
    I do seem to get different opinions depending who I speak to at IONOS – my server provider did find in the logs that the reason was huge SQL queries, but I am guessing that is because we have so much data. I did see that the image i tried to attach of the SQL queries never attached as it was too large. I have reduced it and attached it now.
    In your professional opinion, do you think that if we migrated to a dedicated server with 128GB ram it will not crash?

    Kind regards,

    Mark

    February 26, 2025 at 12:24 pm #641070

    mark-3189
    Participant

    please see attached image of the mySQL queries

    February 26, 2025 at 1:00 pm #641095

    mark-3189
    Participant

    I’m sorry, third time lucky it is now under 2meg

    Attachments:
    You must be logged in to view attached files.
    February 26, 2025 at 1:32 pm #641109

    Artem Temos
    Keymaster

    Hello,

    This screenshot doesn’t make any sense to us. It doesn’t look like a theme-related query. But anyway, if the issue is caused by ONE CONCRETE query, please let us know how we can see this query in your logs so we can check it properly and see if it is related to WoodMart or not.

    Kind Regards

    March 2, 2025 at 4:32 pm #642113

    mark-3189
    Participant

    Hi there,

    I have been running Woodmart live again and it has not crashed for a few days now. I hope all the small things I have done have made it more stable.

    If it does crash again I will find out exactley the reason.

    Kind regards,

    Mark

  • Author
    Posts

Tagged: 

Viewing 22 posts - 1 through 22 (of 22 total)