Curtis

Yeah, I agree… this looks like an issue of their tables not getting upgraded properly. Hopefully I can find a procedure for getting them out of that predicament. Thanks!

@joseph,

Their dashboard says they’re running WordPress 3.0.4.

I went ahead and ran an optimize on the table, but the table didn’t shrink any.

But, I guess you’re saying this isn’t an Akismet issue since they don’t even have a commentmeta table. I guess it’s time I actually take a look at the raw data and see if I can figure out where all the extra records are coming from.

Joseph, I have a hosting customer that is having this same problem, I think. Unfortunately, I’m not a WordPress expert and so I’m not sure. I don’t see a table called commentmeta in their install, but their comment table is almost 800MB in size and their dashboard says they only have around 3,000 comments and less than a dozen in the spam queue. Queries are running very slow as a result of the size of this table. They disabled the Akismet plug-in this morning to stop the growth of the table.

I’d like to delete the extra data from her comment table, but not being familiar with WordPress table structures or Akismet, I don’t know what criteria to use to delete the Akismet data without also deleting her comments.

Can you help? ??