database connections are maxed out

  • Resolved hampalm1

    (@hampalm1)


    2 years, 3 months ago

    When I tried to log in to my dashboard this morning I got a database error. I spoke to my host and they said
    “`So basically the problem is that the database connections are maxed out due to these queries which run for more than 16 hours now –

    | 64667580 | yachtsan_db | localhost | yachtsan_db | Query | 55659 | Waiting for table metadata lock | INSERT INTO wp_vc4sr5ckta_wfhits (attackLogTime, ctime, IP, UA, isGoogle, referer, `UR | 0.000 |

    | 64670642 | yachtsan_db | localhost | yachtsan_db | Query | 55543 | Waiting for table metadata lock | UPDATE wp_vc4sr5ckta_wfhits SET actionData = ‘{\”learningMode\”:0,\”failedRules\”:\”307\”,\”para | 0.000 |

    | 64693119 | yachtsan_db | localhost | yachtsan_db | Query | 54745 | Waiting for table metadata lock | INSERT INTO wp_vc4sr5ckta_wfhits (attackLogTime, ctime, IP, UA, isGoogle, referer, UR | 0.000 |”

    Which they said are being run by Wordfence and advised me to speak to you. After they cleared this I was still getting timeouts but they fixed that as well. So at the moment everything appears to be working but it does concern me that something may have been causing wordfence to work overtime. Can anyone give me an insight in to what could have been happening and if I still need to be concerned about this. You may have guessed, I have no experience with any of this, I’m just following the advice given by my host.

    Thank you

    Andrew

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support wfpeter

    (@wfpeter)

    Hi @hampalm1, thanks for reaching out to us.

    Just for some background information here, are you on a shared hosting server? Sometimes we see high levels of activity on other sites actually affecting operations.

    It’s also plausible for a very slowly moving scan to hold up other processes, or a high volume of live traffic activity where an IP is constantly trying your site creating a lot of wfhits entries so that could be consistent with what you’re seeing here.

    With general performance, Wordfence runs well and unintrusively on the vast majority of ~5m sites it’s installed on despite having to consider many server and plugin/theme combinations. We constantly work on making the plugin faster, perform better, and use less resources but there are not set amounts of RAM, CPU or database queries that we know Wordfence will definitely require in each use-case or hosting environment. The cases of slow-down are small in relation to the quantity of customers using Wordfence, but does crop up from time to time with certain configurations or larger databases/number of installed plugins.

    You could always send us a diagnostic report if you’d like us just to check over your settings. You can send them to wftest @ wordfence . com using the link at the top of the Wordfence > Tools > Diagnostics page. Then click on “Send Report by Email”. Please add your forum username where indicated and respond here after you have sent it.

    NOTE: It should look as follows – Screenshot of Tools > Diagnostic > Send by Email

    Thanks,

    Peter.

    Thread Starter hampalm1

    (@hampalm1)

    Hi Peter

    Yes I am on shared hosting

    I tried sending the diagnostics report but got an error popup saying “There was an error while sending the email.” I used hampalm1 as the username was that correct ? Is there anything else I could have done wrong ?

    Kind regards

    Andrew

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘database connections are maxed out’ is closed to new replies.