UPDATE on INNODB status - INNODB_TABLE_LOCKS=1

Default value of INNODB_TABLE_LOCKS=ON, which means that Lock tables causes innodb to lock a table internally is autocommit=0;