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 -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 31 days, processed 976,290,982 queries (358/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
