Title: [Plugin: WP SlimStat] Table wp_slim_stats crashing Last modified: August 20, 2016 --- # [Plugin: WP SlimStat] Table wp_slim_stats crashing * Resolved [Ben Lobaugh (blobaugh)](https://wordpress.org/support/users/blobaugh/) * (@blobaugh) * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-table-wp_slim_stats-crashing/) * For the past several months each week I have received the following error from mysqldump about the wp_slim_stats table crashing: * > mysqldump: Error 1194: Table ‘wp_slim_stats’ is marked as crashed and should > be repaired when dumping table `wp_slim_stats` at row: 181873 * The row number changes but the error stays the same. * In MySQL running “CHECK TABLE `wp_slim_stats` ” gives db21288_ben.wp_slim_stats check error Found 183320 keys of 183319 db21288_ben.wp_slim_stats check error Corrupt * “ANALYZE TABLE `wp_slim_stats`” gives db21288_ben.wp_slim_stats analyze error Found 183320 keys of 183319 db21288_ben.wp_slim_stats analyze error Corrupt * And the fix is REPAIR TABLE `wp_slim_stats` which gives db21288_ben.wp_slim_stats repair info Key 1 – Found wrong stored record at 22432364 db21288_ben.wp_slim_stats repair warning Number of rows changed from 183319 to 183318 db21288_ben.wp_slim_stats repair status OK * Any thoughts on why this is happening? * I am currently on WP 3.3, however this was also affecting 3.2.1. Also it may be worthy of note that I always have slimstat updated as soon as I see a new version and there have be a few updates that did not solve this issue. * [http://wordpress.org/extend/plugins/wp-slimstat/](http://wordpress.org/extend/plugins/wp-slimstat/) Viewing 13 replies - 1 through 13 (of 13 total) * Plugin Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/) * (@coolmann) * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-table-wp_slim_stats-crashing/#post-2454278) * Hi there, * it seems like your MySQL installation is not working properly. WP SlimStat makes a very intense use of the database to record all the information, so it could be that your box is not powerful enough to carry that load. Also, what version of MySQL are you using? * I would suggest backing up your data and starting from scratch (uninstall and reinstall WP SlimStat) to see what happens. Please remember that uninstalling WP SlimStat, you will also lose all its settings. * Best, Camu * Thread Starter [Ben Lobaugh (blobaugh)](https://wordpress.org/support/users/blobaugh/) * (@blobaugh) * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-table-wp_slim_stats-crashing/#post-2454350) * Camu, * Thanks for the quick response. You can take the server not being powerful enough off the list. I have a dedicated cluster of quad processor machines with tons of ram. It can handle the load no problem. There are several sites more active than this one and I rarely see a blip on resource usage. * The MySQL version being used is 5.0.32. * I am ok with reconfiguring WP SlimStat after uninstalling it as long as I do not lose any data that currently exists. Doesn’t an upgrade basically do this though? * Plugin Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/) * (@coolmann) * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-table-wp_slim_stats-crashing/#post-2454356) * > There are several sites more active than this one and I rarely see a blip on > resource usage. * Hi there, I meant the MySQL service. Maybe it’s not correctly sized to handle the amount of requests that come from WP SlimStat? I’m sure you know about tweaking my.conf 🙂 * If you uninstall (not deactivating) WP SlimStat, all the data and tables will be removed as well, so yes, you will lose all the data. That’s why I was suggesting to backup everything before you proceed. * Reading around, it seems like this problem is caused by a corrupted file on your filesystem. Recreating the tables from scratch could be the way to go… * Camu * Thread Starter [Ben Lobaugh (blobaugh)](https://wordpress.org/support/users/blobaugh/) * (@blobaugh) * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-table-wp_slim_stats-crashing/#post-2454357) * Trust me, horsepower to the MySQL servers is not an issue. * A corrupted file on the filesystem? Like the file that holds the actual table? If that is the case why when I fix the corruption would it keep coming back? * Plugin Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/) * (@coolmann) * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-table-wp_slim_stats-crashing/#post-2454361) * Good question. I’m not a MySQL expert to that extent, not sure why that is happening. * Camu * Thread Starter [Ben Lobaugh (blobaugh)](https://wordpress.org/support/users/blobaugh/) * (@blobaugh) * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-table-wp_slim_stats-crashing/#post-2454368) * Ok, thanks Camu. If I get it figured out I will report back 🙂 * Plugin Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/) * (@coolmann) * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-table-wp_slim_stats-crashing/#post-2454369) * Please, that will be really appreciated! * PS: once you find out, a vote for my plugin would be a nice way to say thank you. * Thread Starter [Ben Lobaugh (blobaugh)](https://wordpress.org/support/users/blobaugh/) * (@blobaugh) * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-table-wp_slim_stats-crashing/#post-2454370) * Pretty sure I voted for you plugin already. I recommend it to everyone and install it for all my clients 😉 * Plugin Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/) * (@coolmann) * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-table-wp_slim_stats-crashing/#post-2454371) * Oh, thank you! * Thread Starter [Ben Lobaugh (blobaugh)](https://wordpress.org/support/users/blobaugh/) * (@blobaugh) * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-table-wp_slim_stats-crashing/#post-2454466) * Update – I backed up the data in the wp_slim_stat table. Deleted the table. Recreated wp_slim_stat. Copied the data back. A few hours later a corruption appeared again: S * Plugin Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/) * (@coolmann) * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-table-wp_slim_stats-crashing/#post-2454467) * Really weird. Do you have access to your MySQL log files? Maybe you can track down the error when it occurs… * Camu * Thread Starter [Ben Lobaugh (blobaugh)](https://wordpress.org/support/users/blobaugh/) * (@blobaugh) * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-table-wp_slim_stats-crashing/#post-2454509) * Update – My table is no longer having this crashing issue, but there is another site on my server somewhere having the same problem. I have not had a chance to track it down which site yet, but this is very odd. * Plugin Contributor [Jason Crouse](https://wordpress.org/support/users/coolmann/) * (@coolmann) * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-table-wp_slim_stats-crashing/#post-2454510) * Yes, it is! Viewing 13 replies - 1 through 13 (of 13 total) The topic ‘[Plugin: WP SlimStat] Table wp_slim_stats crashing’ is closed to new replies. * ![](https://ps.w.org/wp-slimstat/assets/icon.svg?rev=2832242) * [SlimStat Analytics](https://wordpress.org/plugins/wp-slimstat/) * [Frequently Asked Questions](https://wordpress.org/plugins/wp-slimstat/#faq) * [Support Threads](https://wordpress.org/support/plugin/wp-slimstat/) * [Active Topics](https://wordpress.org/support/plugin/wp-slimstat/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-slimstat/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-slimstat/reviews/) * 13 replies * 2 participants * Last reply from: [Jason Crouse](https://wordpress.org/support/users/coolmann/) * Last activity: [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-wp-slimstat-table-wp_slim_stats-crashing/#post-2454510) * Status: resolved