Bigint BUG

returns 0656 is it overflow?. Regards chChen

Re: BigInt with primary key

etc. Your insert is very difficult to figure out especially with unmatched brackets, which doesn't make sense at all. I'm surprised the insert even works. Thirdly, have you tried checktable/myisamcheck? - Original Message - From: "chchen" <[EMAIL PROTECTED]>

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 Duplicate such like insert into Table values('9231852172526977164',0,0,52056,0,0,0,0,0,52056,0,0,0,0,0,0,0,11,0,'184000','184000',1),'9231

Performance of Heap table?!

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

fast without Lock write? Regards chchen

Re: Speed of mysql

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

Speed of mysql

ne have good idea to solve this situation? please don't ask me to put it all into the memory. i tried before. but table is too big. i guess about 500MB for the MYD and MYI Regards chChen