[Plugin: WP SlimStat] Table wp_slim_stats crashing

  • Resolved Ben Lobaugh (blobaugh)

    (@blobaugh)


    14 years, 5 months ago

    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://ww.wp.xz.cn/extend/plugins/wp-slimstat/

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

    (@coolmann)

    14 years, 5 months 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

    Thread Starter Ben Lobaugh (blobaugh)

    (@blobaugh)

    14 years, 5 months ago

    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

    (@coolmann)

    14 years, 5 months 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

    Thread Starter Ben Lobaugh (blobaugh)

    (@blobaugh)

    14 years, 5 months ago

    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

    (@coolmann)

    14 years, 5 months ago

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

    Camu

    Thread Starter Ben Lobaugh (blobaugh)

    (@blobaugh)

    14 years, 5 months ago

    Ok, thanks Camu. If I get it figured out I will report back 🙂

    Plugin Contributor Jason Crouse

    (@coolmann)

    14 years, 5 months 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.

    Thread Starter Ben Lobaugh (blobaugh)

    (@blobaugh)

    14 years, 5 months ago

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

    Plugin Contributor Jason Crouse

    (@coolmann)

    14 years, 5 months ago

    Oh, thank you!

    Thread Starter Ben Lobaugh (blobaugh)

    (@blobaugh)

    14 years, 5 months ago

    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

    (@coolmann)

    14 years, 5 months ago

    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)

    (@blobaugh)

    14 years, 5 months ago

    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

    (@coolmann)

    14 years, 5 months ago

    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.