There is almost no reason to use LOCK TABLES on InnoDB tables.
I prefer to have auto_commit=1, then use explicit BEGIN and COMMIT for
clumps of statements that need ACID. I never use auto_commit=0.
Following those two rules, your issue with innodb_table_locks being on
goes away.
On 4/5/12
Dear All,
Today i faced an issue while issuing commands on my innodb tables.
When I issued any drop table or alter table command my query gets into
waiting state for more than 15-20 minutes.
Mysql Version :-5.5.4 community
I researched on the issue and find that every command try to get lock
