From: Hank
Date: September 19 2011 12:30am
Subject: myisamchk error (duplicate key records)
List-Archive: http://lists.mysql.com/mysql/225755
Message-Id: <CAPs4VGn1yTYRc+4z_x1_zrX2rcxQ1UT+8YDEOKzL_+LTU9F8DA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0016e642d2c4ce3a9004ad4071bb

--0016e642d2c4ce3a9004ad4071bb
Content-Type: text/plain; charset=ISO-8859-1

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.

--0016e642d2c4ce3a9004ad4071bb--