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
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:
>
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