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? Server: Dell 2600, RAID-5 OS: RedHat 9 MySQL version: 3.23.56-log Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
