is it overflow?.
Regards
chChen
hi all
i use mysql-3.23.32
my project need to use unsigned Bigint as a primary key.
but when i insert many rows in this table.
sometimes it will error with Duplicate such like
insert into Table
-
From: "chchen" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 20, 2001 18:56
Subject: BigInt with primary key
hi all
i use mysql-3.23.32
my project need to use unsigned Bigint as a primary key.
but when i insert many rows in this table.
sometimes it will error with
with the same structure.
and the speed almost double while the table grows up
to 200K+ rows
any ldeas?
Regards
chChen
fast without Lock write?
Regards
chchen
500MB for the MYD and MYI
Regards
chChen
a couple of the fields indexed
jason
- Original Message -
From: "chchen" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 10, 2001 6:35 PM
Subject: Speed of mysql
hi,all
i have a strange question.
I use FreeBSD4.2-RELEASE + mysql-3.23.32
Dual PIII667+ 768MB R