Concurrent queries 'wait for each other'

2002-11-26 Thread Claus Reestrup
Hi! I have a problem with MySQL that hangs when concurrent queries run. The symptom is this: A) A Perl program that performs several queries using temporary tables takes 8 seconds to run. CPU utilisation around 30% (using the 'top' command) B) Running two instances of the same perl program in

Fw: Concurrent queries 'wait for each other'

2002-11-26 Thread Claus Reestrup
- Original Message - From: gerald_clark [EMAIL PROTECTED] Wrote: Perhaps each process simply requires 8 seconds of disk access. Since they share the same disk it will take 8sec. times the number of processes running to complete. You have a strange definition of hang. Claus