Bigint BUG

2001-02-21 Thread chchen
is it overflow?. Regards chChen

BigInt with primary key

2001-02-20 Thread 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

Re: BigInt with primary key

2001-02-20 Thread chchen
- 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

Performance of Heap table?!

2001-02-15 Thread chchen
with the same structure. and the speed almost double while the table grows up to 200K+ rows any ldeas? Regards chChen

Lock with update,insert and select

2001-02-14 Thread chchen
fast without Lock write? Regards chchen

Speed of mysql

2001-02-10 Thread chchen
500MB for the MYD and MYI Regards chChen

Re: Speed of mysql

2001-02-10 Thread 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