• Hi there. The table wflivetraffichuman made too many updates and my website went down. Is there a bug, or do I have to make something on my part?

    mysql> show processlist;
    +--------+--------------------------+-----------------+---------------------------+---------+------+---------------------+------------------------------------------------------------------------------------------------------+
    | Id     | User                     | Host            | db                        | Command | Time | State               | Info                                                                                                 |
    +--------+--------------------------+-----------------+---------------------------+---------+------+---------------------+------------------------------------------------------------------------------------------------------+
    | 119490 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |   16 | Sending data        | SELECT SQL_CALC_FOUND_ROWS  uoLyTC_posts.ID
    | 119873 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | update              | REPLACE INTO uoLyTC_bv_activities_store (user_id, username, request_id, site_id, ip, `ev |
    | 120226 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | Opening tables      | SHOW FULL COLUMNS FROM uoLyTC_wflivetraffichuman                                                   |
    | 120229 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Sleep   |    0 |                     | NULL                                                                                                 |
    | 120335 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'JdgW8qFrCvGUJkvt30f582O1N3sibhy9x2ID6mXRqKGB6Yr1rdZP6d |
    | 120944 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = '4Ykr6heLzsGslO41l9W+hSsx65KReyBDCn68PtQ/FVUhcX5l1zVFg4 |
    | 121042 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'kd+NyzTXwMMqkfK8KR4p4BVdrOE1YRKbPJeZ/a97+JY4UxW3p26VVP |
    | 121441 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = '4Ykr6heLzsGslO41l9W+hSsx65KReyBDCn68PtQ/FVUhcX5l1zVFg4 |
    | 121459 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = '0Lhv7Ias+yK3ABH6behQBJlcVrA7ojZSqNmw45azLE7pSrgkA0IZCu |
    | 121602 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'jwzmORsr2LHp7fvljy1ufLLulaK8zffPqhscijRQNq1CFW9zNHhKo7 |
    | 121607 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | query end           | UPDATE uoLyTC_options SET option_value = 'yC6yak+MxjHaPMSLqpts4hNbAQEG2zljepOtzpmf1lscHa+ikPwlBQ |
    | 121623 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = '170U/upKzILcMKev6ZBXaSzkdairawdW4RNNarHenwTbl/tP6Tko6a |
    | 121639 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'Vlb3IitiUq3I0Mz11xa6nBq07BYuOeXnh9EclWsgCAgqKIZqRpNk2d |
    | 121640 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'SZvwJIR4IbZ7XTfAIdxCDLMVCDblnFJGWVPPUZ7v4I5n8UzTArC4JW |
    | 121647 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'EL3hDE1cIbv4UUIsi+lhHwWUi1MsrfrbuRn/dSH6vQsW3NBxixEFK4 |
    | 121932 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'isUuRWyrVOzZN87RMvZDJHHr/nnWDycjNGDLBAp0Su/dWzwbJ1Mn4w |
    | 122144 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'jwzmORsr2LHp7fvljy1ufLLulaK8zffPqhscijRQNq1CFW9zNHhKo7 |
    | 122251 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = '8he55NFt8T11z/WgbhiZXb03+Oav49Td9a27SOgGGiRwcPbidx4lv8 |
    | 122297 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = '0egM1VE5N/d6GX5QZdYohSIN/J2ziGQ0/8p5MccmIsyxcnftbH8Tkh |
    | 122436 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = '8he55NFt8T11z/WgbhiZXb03+Oav49Td9a27SOgGGiRwcPbidx4lv8 |
    | 122566 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'RpPWkw+T+YgpQ+SPUQnXC8oRZOxtInyJVNlkVUqjoQ7aAVF8EUD4XM |
    | 122592 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'kEpN2BTlIMsWeJj06fVeUfMMBfwtd5nFpPOq9oOo+sQdfXx02PvFz2 |
    | 122605 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'PzYeC/DZ/tfWpOlswDJ4uBm9jBfHzmWimIFhE6CTFbwSVpRSNGvmyE |
    | 122670 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'cnaLrynVXU2jtBeLTZFc0uhLW082Ok8C7xgSwmnwXZZ/rYp2Mn09c+ |
    | 122674 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = '7rmJp5HCrbJcgGt46N+5SUAn4MUk7aflOBosh6epnVzEgceGIYFWjG |
    | 122979 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'cvvzMocVlXO1nw7GtWp4OcM9ZLmvBJFGS6F4SyeL+hxHGv7Dy0SLWi |
    | 123404 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'dcACWXyVwUHQxJppR4e4gXIiWzvqkZUPc8bcDYuHkxdzjD3RLCU+lu |
    | 123506 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'q5mTcO5UMxJHB8kJaj1KsHEsqxCl1HT4RF67PkOwioy+cU9g4WEffT |
    | 123653 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'dcACWXyVwUHQxJppR4e4gXIiWzvqkZUPc8bcDYuHkxdzjD3RLCU+lu |
    | 123764 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'ERoUDG920v2RWYM3UGBuZNeujzyaLRBZLwOvtGxTlVqa1Q/+1XSqHR |
    | 124267 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'q/Q0Sgv36yt5ebAPogYAlS7ZJHVfB2UDpkGdHE9+Vk+0LGXNQvpKqG |
    | 124543 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'cvvzMocVlXO1nw7GtWp4OcM9ZLmvBJFGS6F4SyeL+hxHGv7Dy0SLWi |
    | 124657 | ziuaonline_wp_qufzd      | localhost       | ziuaonline_wp_omsct       | Query   |    0 | updating            | UPDATE uoLyTC_options SET option_value = 'jwzmORsr2LHp7fvljy1ufLLulaK8zffPqhscijRQNq1CFW9zNHhKo7 |
    +--------+--------------------------+-----------------+---------------------------+---------+------+---------------------+------------------------------------------------------------------------------------------------------+
    • This topic was modified 1 year, 4 months ago by alexmanase. Reason: use the correct context
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support WFAdam

    (@wfadam)

    Hello @alexmanase and thanks for reaching out to us!

    I am wondering if your site is seeing a lot of human traffic or if the IP detection might be set incorrectly.

    Can you send a diagnostic report to wftest @ wordfence . com? You can find the link to do so 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 again!

    Thread Starter alexmanase

    (@alexmanase)

    Hi there!

    Sorry for the late response. I’ve sent the report now.

    • This reply was modified 1 year, 4 months ago by alexmanase. Reason: Fix typo
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘wflivetraffichuman makes too many updates’ is closed to new replies.