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 a MyISAM table. These should be atomic processes. Is there something at the OS-level that might tell me what's causing the hangup? Did I jump onto the RH9 bandwagon too soon? On Fri, 4 Jul 2003, Jeremy Zawodny wrote: > On Thu, Jul 03, 2003 at 06:51:28PM +0000, 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 waiting upon the same table, and > > they do not clear up. I've searched through the docs and googled through > > the lists and can't seem to find anything that would help me to solve this > > one. > > > > I've changed to single-threading the processes for now but would like to > > revert back to the original method. Note that I had originally wrapped the > > inserts with "LOCK/UNLOCK" but this was hanging more often (on the LOCK > > query). > > > > Does anyone know where I might begin? Is there something that I can query > > to find out what the inserts are waiting for? > > Have a look at the output of SHOW PROCESSLIST or use a tool like mytop > to see what's going on. You can usually get a good idea of what's > wating on on what by doing so. > > Jeremy > -- Mike Lucente [EMAIL PROTECTED] 561.218.5527 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
