hanging queries from wp_itsec_temp

  • Resolved djixas

    (@djixas)


    1 year, 2 months ago

    Hello,

    I am having a few httpd downtimes per day due to hanging queries from your script. Below is a snapshot of these hanging queries from the loadwatch logs:

    Command: Query
    Time: 1860
    State: Waiting for table level lock
    Info: INSERT INTO wp_itsec_temp (temp_type, temp_date, temp_date_gmt, temp_host) VALUES (‘brute_
    Progress: 0.000

    Command: Query
    Time: 1747
    State: Waiting for table level lock
    Info: DELETE FROM wp_itsec_opaque_tokens WHERE token_created_at < ‘2023-12-06 13:42:51’
    Progress: 0.000

    When these took place, the queries were piling up on the server, which had caused the Mysql connection slots to fill up, at which point Apache was stuck waiting for processes to clear so it can fulfill its requests, which is when those connections start to pile up, causing Apache to not be reachable. At which point, chkservd sees that Apache is not reachable and restarts it, which then clears out the connections, which clears out the hung queries, which then causes the server to return to normal.

    What are these tables responsible for and what can you do to fix this? Latest version, 9.2, started happening around a month ago

    • This topic was modified 1 year, 2 months ago by djixas.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support chandelierrr

    (@shanedelierrr)

    Hi @djixas, thanks for reaching out!

    I want to assure you that I’ve reached out to our development team internally about this and am waiting for their feedback. Although, please note that the turnaround might be slow due to the ongoing holiday season. I’ll get back to you as soon as I get a response.

    I appreciate your patience.

    Plugin Support Ben Meredith

    (@benmeredithgmailcom)

    Hey @djixas!

    ( I just typed up a long reply that apparently the forum goblins have eaten… but apologies if you are getting this twice)

    I spoke with our lead developer and our strong hunch is that your problems are stemming from an incompatible Database Storage engine. We’d recommend converting over to InnoDB if you are not already.

    Here’s an article on how to convert over to InnoDB. It’s a bit technical, but not too cumbersome.

    Let us know if you are already on InnoDB, and we can keep digging, here!

    Plugin Support chandelierrr

    (@shanedelierrr)

    Hi there,

    Following up here to see if the tip to convert to InnoDB helped resolve the hanging queries issue. Tracking notifications on this forum can become tricky over time, and since we haven’t received a response, I’ll mark this post resolved.

    If you still require further assistance, feel free to open a new support topic, and we’d be happy to assist.

    Thank you!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘hanging queries from wp_itsec_temp’ is closed to new replies.