Mike, what version of MySQL are you running?
A month ago or so, I tried 4.1alpha on a FreeBSD4.8 machine and noticed the same
thing you are describing. I had a bunch of threads inserting on a MyISAM table and
the threads would just wedge. They'd show up in SHOW PROCESSLIST and wouldn't
respond to
I use mytop. The only thing that I see is x "insert" queries all trying to
insert to the same table. Killing the oldest query doesn't help, in fact
killing any or all of them doesn't do any good either (they just appear to
get "marked" as killed).
Note that the table that they're waiting for is
On Thu, Jul 03, 2003 at 06:51:28PM +, Mike Lucente wrote:
> Hello,
>
> I have nine process that import data to tables with the same structure
> within about 1000 databases on a server. Each process fires at the same
> time, every 5 minutes.
>
> Lately I'm seeing these inserts hang, all wait
Hello,
I have nine process that import data to tables with the same structure
within about 1000 databases on a server. Each process fires at the same
time, every 5 minutes.
Lately I'm seeing these inserts hang, all waiting upon the same table, and
they do not clear up. I've searched through th
