wpslimstat kills my server
-
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.
Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
The topic ‘wpslimstat kills my server’ is closed to new replies.