Wordfence slow queries crashing Mysql

  • Resolved Kokomo

    (@kokomoweb)


    6 years, 4 months ago

    Hi, we currently have Wordfence installed on our website, latest version of WF, latest version of WP. We are getting the following MySql errors that are regularly crashing our server. Can you let us know what can be done to solve this?

    8. Executed 1h 11m 58s ago for 4.255249 sec on Database –> Unknown (NOT FOUND / DELETED)
    Date: 2018-11-13 18:58:50 Query_time: 4.255249 Rows_examined: 0: Rows_sent 0 Lock_time: 0.279801
    # Schema: monicaa2_mason Last_errno: 0 Killed: 0 SELECT *, CASE WHEN type = 3 THEN 0 WHEN type = 4 THEN 1 WHEN type = 7 THEN 2 WHEN type = 6 THEN 3 WHEN type = 5 THEN 4 WHEN type = 9 THEN 5 WHEN type = 8 THEN 6 WHEN type = 2 THEN 7 WHEN type = 1 THEN 8 ELSE 9999 END AS typeSort, CASE WHEN type = 3 THEN parameters WHEN type = 4 THEN parameters WHEN type = 1 THEN IP WHEN type = 9 THEN IP WHEN type = 5 THEN IP WHEN type = 6 THEN IP WHEN type = 7 THEN IP WHEN type = 2 THEN IP WHEN type = 8 THEN IP ELSE 9999 END AS detailSort FROM wp_e2c86c314b_wfBlocks7 WHERE type IN (4) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC;
    ———————————————————————————————–
    10. Executed 16h 30m 33s ago for 2.416912 sec on Database –> Unknown (NOT FOUND / DELETED)
    Date: 2018-11-13 03:40:15 Query_time: 2.416912 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000033
    # Schema: monicaa2_mason Last_errno: 0 Killed: 0 INSERT IGNORE INTO wp_e2c86c314b_wfConfig (name, val, autoload) VALUES (‘wfSyncGeoIP.lock’, ‘1542102012’, ‘no’);

Viewing 4 replies - 1 through 4 (of 4 total)

  • Hi @kokomoweb,
    We’ve had a couple of reports that I think are related where they’re getting deadlock on that same query. We believe it may be happening on sites where the GeoLite2-Country.mmdb (The GeoIP country database) fails to sync as it should.

    Here is a proposed temporary fix that may work:

    1. Delete GeoLite2-Country.mmdb file located in wflogs
    2. Delete “_transient_timeout_wfSyncGeoIPActive” and “_transient_wfSyncGeoIPActive” from the wp_options table

    If that works, let me know!

    Thread Starter Kokomo

    (@kokomoweb)

    Done. Thanks for the reply! I’ll keep you posted.

    Hi @kokomoweb,

    I’ll be taking over this thread now!

    Please feel free to reply to this thread once you’ve had a chance to test Asa’s fix.

    Thanks!

    Dave

    Hi again!

    We haven’t heard back from you in a while, so I’ve gone ahead and marked this thread as resolved.

    Please feel free to open another thread if you’re still having issues with Wordfence.

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Wordfence slow queries crashing Mysql’ is closed to new replies.