RE: InnoDB table lock on INSERT

Baron- Thank you for the InnoDB Lock Monitor pointer. I now have a greate deal of informaiton to digest. I will try innotop when I have a chance. :) -Paul Hi Paul, Power, Paul C. wrote: I have an INSERT waiting for a table lock, and i do not understand why. ---TRANSACTION 0

InnoDB table lock on INSERT

I have an INSERT waiting for a table lock, and i do not understand why. ---TRANSACTION 0 308691, ACTIVE 5 sec, process no 8876, OS thread id 1296547864 inserting mysql tables in use 1, locked 1 LOCK WAIT 1 lock struct(s), heap size 320 MySQL thread id 79126, query id 1113322 bil.oneeighty.com

Re: InnoDB table lock on INSERT

Hi Paul, Power, Paul C. wrote: I have an INSERT waiting for a table lock, and i do not understand why. ---TRANSACTION 0 308691, ACTIVE 5 sec, process no 8876, OS thread id 1296547864 inserting mysql tables in use 1, locked 1 LOCK WAIT 1 lock struct(s), heap size 320 MySQL thread id 79126,