Re: insert hang problem on Solaris 8

2003-06-21 Thread Nils Valentin
Hi Randy, I am not sure if this is working, but did you try the slow query log ?? Why I am not sure is because I believe the result is logged AFTER the request is complete (which never happens in your case if I understood correctly)? Best regards Nils Valentin Tokyo/Japan 2003年 6月 18日 水曜日 2

Re: insert hang problem on Solaris 8

2003-06-19 Thread Randy Locklair
It looks like my MYI file was seriously corrupted, beyond myisamchk being able to do a thing with it. Has anyone seen this before on Solaris 8? Fortunately the data was trashable but when this hits production it wont always be. Thanks.. Randy On Wed, 2003-06-18 at 21:46, Nils Valentin wrote: >

insert hang problem on Solaris 8

2003-06-18 Thread Randy Locklair
Hey there everyone. I'm having a problem on a MySQL installation (vsn 4.0.12-standard) on Solaris 8. I've got a few tables that get inserted into maybe 1000-1500 times a day. It seems to be pretty random, but I've seen three or four times that the database just hangs on the insert. SHOW PROCE