WordPress.org

Ready to get started?Download WordPress

Forums

WP SlimStat
[resolved] Table wp_slim_stats crashing (14 posts)

  1. 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/

  2. camu
    Member
    Plugin Author

    Posted 2 years ago #

    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

  3. 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?

  4. camu
    Member
    Plugin Author

    Posted 2 years ago #

    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

  5. 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?

  6. camu
    Member
    Plugin Author

    Posted 2 years ago #

    Good question. I'm not a MySQL expert to that extent, not sure why that is happening.

    Camu

  7. Ok, thanks Camu. If I get it figured out I will report back :)

  8. camu
    Member
    Plugin Author

    Posted 2 years ago #

    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.

  9. Pretty sure I voted for you plugin already. I recommend it to everyone and install it for all my clients ;)

  10. camu
    Member
    Plugin Author

    Posted 2 years ago #

    Oh, thank you!

  11. 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

  12. camu
    Member
    Plugin Author

    Posted 2 years ago #

    Really weird. Do you have access to your MySQL log files? Maybe you can track down the error when it occurs...

    Camu

  13. 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.

  14. camu
    Member
    Plugin Author

    Posted 2 years ago #

    Yes, it is!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic