- Original Message -
> From: "Hank"
>
> I'm trying to rebuild an index after disabling all keys using
> myisamchk and adding all 144 million records, so there is no current index on
> the
> table.
Ahhh... I didn't realise that.
> But in order to create the index, mysql has to do a fu
>
> > Exactly - I can't create an index on the table until I remove the
> > duplicate records.
>
> I was under the impression you were seeing this during a myisamchk run -
> which indicates you should *already* have a key on that field. Or am I
> interpreting that wrong?
>
>
I'm trying to rebuild a
- Original Message -
> From: "Hank"
>
> Exactly - I can't create an index on the table until I remove the
> duplicate records.
I was under the impression you were seeing this during a myisamchk run - which
indicates you should *already* have a key on that field. Or am I interpreting
t
On Mon, Sep 19, 2011 at 7:19 AM, Johan De Meersman wrote:
> - Original Message -
> > From: "Hank"
> >
> > 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 f
- Original Message -
> From: "Hank"
>
> 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 o
Hank <[EMAIL PROTECTED]> writes:
>How do I find which record is duplicated (without doing the typical
>self-join query)? This table has 70 million rows, so that's not
>really feasible.
select col, count(1) cnt from tab group by col having cnt > 1;
This will print out all duplicated col rows.
Hello,
Further searching for this problem reveals that it was reported as a bug:
http://bugs.mysql.com/bug.php?id=779
but for Version 3. Does this mean that the fix was not implemented in Version 4?
What is the workaround for this? Do I have to load the table while creating the
indices? Thi
Hi Fraser,
Thats a famous one (I like it - you probably wont ;-)
It means that your hard disk (partition) is full.
http://www.knowd.co.jp/staff/nils/mysql-error-codes.html
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 6日 金曜日 10:27、Fraser MacKenzie さんは書きました:
> I am using mysql 3.23.54 and a
Victoria Reznichenko wrote:
>
> Do-Risika,
> Monday, April 29, 2002, 7:54:51 AM, you wrote:
>
> DRR> Can someone tell me what this error mean ?
>
> DRR> myisamchk: MyISAM file /var/lib/mysql/radius/radacct.MYI
> DRR> myisamchk: warning: 1 clients is using or hasn't closed the table
> DRR> prope
Do-Risika,
Monday, April 29, 2002, 7:54:51 AM, you wrote:
DRR> Can someone tell me what this error mean ?
DRR> myisamchk: MyISAM file /var/lib/mysql/radius/radacct.MYI
DRR> myisamchk: warning: 1 clients is using or hasn't closed the table
DRR> properly
DRR> myisamchk: error: Found key at page 24
10 matches
Mail list logo
