Carl, Locked status in SHOW PROCESSLIST and a table being locked are different. There is a bug in MySQL that shows Locked status for queries accessing InnoDB tables in some cases. What version of MySQL are you using?
The table is not really locked, you're just seeing that as a side effect of whatever's really happening. Baron On Wed, Mar 4, 2009 at 2:01 PM, Carl <c...@etrak-plus.com> wrote: > I did check that all tables are Innodb. > > I was using the Navicat Server Monitor because I know that when I see the > monitor reporting a status of locked during an attempted query, that user > comes to a complete halt until the lock is cleared (usually by the bad query > finishing.) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
