Arrow

wp_cas_count record 0 never increases in size keeps corrupting | Peter's Custom Anti-Spam for WordPress | Forum

Back to the custom anti-spam plugin page

Please consider registering
guest

Log In

Lost password?
Advanced Search

— Forum Scope —

  

— Match —

   

— Forum Options —

   

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
wp_cas_count record 0 never increases in size keeps corrupting
November 4, 2010
7:06 pm
Alborz
Guest

Hey Peter,

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.

Regards,

November 4, 2010
9:51 pm
Peter
Admin
Forum Posts: 841
Offline

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.