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 being killed. MySQL had to be restarted to free them up. 4.0.13 doesn't exhibit this behavior.
--- Mike Lucente <[EMAIL PROTECTED]> wrote: > 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] > __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
