wp_cas_count record 0 never increases in size keeps corrupting | Peter's Custom Anti-Spam for WordPress | Forum
Please consider registering
We've used your plugin for some time on CarAdvice.com.au - we get over 60,000 unique visitors per day and as such are a large traffic website.
Recently we are getting a lot of overhead and fragmentation to wp_cas_count, I went through, deleted the table and recreated it with :
CREATE TABLE wp_cas_count (
id int(10) NOT NULL AUTO_INCREMENT,
UNIQUE KEY id (id)
Ever since then, it has 0 rows in it, always (which means it can't be working), yet it continues to get overhead and require repairing constantly.
Please let me know what needs to be done to get it working again.
Unfortunately as it has caused a few server crashes I don't wish to replace the plugin but I can't seem to find the solution.
That table is actually supposed to have no rows in it. Its only purpose is to store the auto increment value for the main table that stores the anti-spam words. (Here's a more detailed explanation.)
However, it's definitely a problem if it keeps getting corrupted. Perhaps MySQL as a whole is not handling the traffic well. You could set up a cronjob to optimize the table(s) daily at low traffic times.