Hello all; Is myisamchk known to have problems in tables with lots of rows?
I've a table with a simple, single, 32 bit integer as a key. I have about 200 million rows in it. I can run myisamchk -o -e names three times in a row and receive this message each time: Duplicate key 1 for record at 6816077328 against new record at 1491264864 Duplicate key 1 for record at 6816090172 against new record at 1491264864 Duplicate key 1 for record at 6816090224 against new record at 1491264864 Duplicate key 1 for record at 6816090276 against new record at 1491264864 Duplicate key 1 for record at 6816090328 against new record at 1491264864 Duplicate key 1 for record at 6816090380 against new record at 1491264864 Duplicate key 1 for record at 6816090432 against new record at 1491264864 Duplicate key 1 for record at 6816090484 against new record at 1491264864 Duplicate key 1 for record at 6816090536 against new record at 1491264864 Duplicate key 1 for record at 6816090588 against new record at 1491264864 Duplicate key 1 for record at 6816090640 against new record at 1491264864 Duplicate key 1 for record at 7004869336 against new record at 1491265060 myisamchk: warning: 21187 records have been removed cinnamon:ip# Thinking there must be some subtle corruption that even the extended check couldn't find I wrote a program to dump the values of the table into a flat file, deleted the table, recreated the table, then used "load data infile /usr/tmp/names.data into table names" to reload it. It reloaded without apparent error. Wanting to check the myisamchk utility, I then shut mysql down and re-ran myisamchk -o -e names and got the same error message: Duplicate key 1 for record at 6830620264 against new record at 1493850944 Duplicate key 1 for record at 6830620316 against new record at 1493850944 Duplicate key 1 for record at 6830620368 against new record at 1493850944 Duplicate key 1 for record at 6830620420 against new record at 1493850944 Duplicate key 1 for record at 6830620472 against new record at 1493850944 Duplicate key 1 for record at 7019553820 against new record at 1493850712 Data records: 201562542 myisamchk: warning: 21181 records have been removed cinnamon:ip# Is this normal behavior? It sure doesn't seem right to me. Thanks, --- David --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php