• Resolved dandv

    (@dandv)


    Before disabling wpslimstat, I had horribly high CPU usage. MySQL showed this:

    mysql> SHOW PROCESSLIST;
    +-------+---------+------+-------------------------------+------------
    | Id    | Command | Time | State                         | Info                                                                                                 |
    +-------+---------+------+-------------------------------+-------------
    | 12990 | Sleep   |   27 |                               | NULL                                                                                                 |
    | 12994 | Query   |   70 | Sending data                  | SELECT id FROM wp_slim_stats WHERE ip = '3191469579' AND language = 'en-us' AND country = 'a         |
    | 12996 | Query   |   70 | storing result in query cache | SELECT id FROM wp_slim_stats WHERE ip = '2921651987' AND language = 'xx' AND country = 'us'          |
    | 12999 | Query   |   66 | Sending data                  | SELECT id FROM wp_slim_stats WHERE ip = '2975066379' AND language = 'pt-br' AND country = 'b         |
    | 13000 | Query   |   70 | Sending data                  | SELECT id FROM wp_slim_stats WHERE ip = '1113027096' AND language = 'en-us' AND country = 'u         |
    | 13001 | Query   |   71 | storing result in query cache | SELECT id FROM wp_slim_stats WHERE ip = '2921651987' AND language = 'xx' AND country = 'us'          |
    | 13005 | Query   |   72 | storing result in query cache | SELECT id FROM wp_slim_stats WHERE ip = '2921651987' AND language = 'xx' AND country = 'us'          |
    | 13010 | Query   |   72 | Sending data                  | SELECT id FROM wp_slim_stats WHERE ip = '3191469579' AND language = 'en-us' AND country = 'a         |
    | 13012 | Query   |    4 | Sending data                  | INSERT INTO wp_slim_stats ( ip, language, country, searchterms, resource, content_info_id, browser_i |
    +-------+---------+------+-------------------------------+-------------
    11 rows in set (0.13 sec)

    A day after disabling it, everything has been great. I was using 2.8.2 because I don’t plan to update the WP instance.

    https://wordpress.org/plugins/wp-slimstat/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Jason Crouse

    (@coolmann)

    We’ve Introduced a lot of db optimizations since that version. Not sure what we can do to help other that recommending that you upgrade to at least version 3.5.

    I have the same problem!
    The loading time of my website was about 20 seconds when I activated WP SlimStat. Without this plugin everything is normal.

    Plugin Contributor Jason Crouse

    (@coolmann)

    This issue is now addressed in version 3.6.2.

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

The topic ‘wpslimstat kills my server’ is closed to new replies.