I installed W3TC on WP 3.1. and 3.1.1 and my database crashed on both (all posts and pages were missing)…
“WordPress database error: [Table ‘./pxxxxxx_wrdp15/wp_posts’ is marked as crashed and last (automatic?) repair failed]
SELECT post_status, COUNT( * ) AS num_posts FROM wp_posts WHERE post_type = ‘post’ GROUP BY post_status”
I went to my phpMyAdmin at Hostgator and found two tables, wp_pba_index_7 and wp_posts, inside database wrpd_15 were listed as ‘in use’. I had to deactivate the W3TC plugin and repair both tables to get all of my posts and pages back to my WP blog.
This occurred a few times after trying to resolve the first and second crash. I’ve given up… didn’t find any help in the forum or solution as of yet that could be causing the issue. The plugin was working fine and made my blog faster but I can’t say for sure if this had anything do with the plugin being incompatible to WP 3.1 and 3.1.1 or something I overlooked.