Table wp_wfLiveTrafficHuman count

  • Resolved ivojerkovic

    (@ivojerkovic)


    5 years, 9 months ago

    Every hour at 0 minutes something runs a 100 queries like this one
    Query | 27 | Waiting for table level lock | SELECT COUNT(*) FROM wp_wfLiveTrafficHuman WHERE IP = '\0\0\0\0\0\0\0\0\0\0??T??&' AND identifier = | 0.000 |

    This completely blocks the database for 2 minutes, website becomes slow or completely unresponsive. Does anyone knows how to disable this or at least change the schedule so it doesn’t run every hour?
    It has a big impact on the website because it’s a web shop and this 2 minutes delay creates failed orders and similar problems.

    • This topic was modified 5 years, 9 months ago by ivojerkovic.
Viewing 1 replies (of 1 total)

  • Hey @ivojerkovic,

    It sounds like you’re running out of disk space while adding the rows. Can you please navigate to WordPress Dashboard > Wordfence > All Options > Tool Options > Live Traffic Options and adjust the Live Traffic configuration? First, make sure you’re using SECURITY TRAFFIC versus ALL TRAFFIC for the Traffic logging mode. Then lower the Amount of Live Traffic data to store (number of rows). But ultimately, it seems like a disk space/memory issue you’ll want to speak with your host about.

    Please let me know how it goes.

    Thanks,

    Gerroald

Viewing 1 replies (of 1 total)
  • The topic ‘Table wp_wfLiveTrafficHuman count’ is closed to new replies.