While running a -rq on a large table, I got the following error: myisamchk: warning: Duplicate key for record at 54381140 against record at 54380810
How do I find which records are duplicated (without doing the typical self-join or "having cnt(*)>1" query)? This table has 144 million rows, so that's not really feasible. myisamchk --block-search # looked promising, but I can't find any documentation on how to use it properly. I tried "myisamchk -b 54381140 table-name" but it really doesn't do anything. I posted this identical question here six years ago, and I have the same problem again. I still can't find ANY documentation on "--block-search" or how to use it. Has anything changed in six years? Thanks.
