MySQL Forums
Forum List  »  General

Index not updating - help needed
Posted by: N.Z. Bear
Date: November 28, 2004 11:38AM

I've a baffling problem: I have a table (~ 2M rows) with several indexes. Recently, the indexes have simply stopped updating accurately. For example, column 'destid' has 15,000+ unique values, but the cardinality of the 'destid' index (viewed via PHPMyAdmin) only shows 800.

What's worse, I tried the obvious solution of dropping the table, recreating it, and reloading the data --- and the same problem has come back. I've also tried 'Check Table' and 'Analyze Table' from PHPMyAdmin with no result (both report table is "OK").

I haven't made any SQL or code changes recently, so I'm assuming I have some kind of database corruption issue going on. Suggestions on where to look to debug this would be most welcome.


N.Z. Bear
The Truth Laid Bear

Options: ReplyQuote

Written By
Index not updating - help needed
November 28, 2004 11:38AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.