I have setup for innodb database tables. But all our updates and select .. for updates are still locking at table level. I am looking for the ways to provide row llevel locks. Please help me what parameters I need to setup to get the row level locks with Innodb tables.
If you do not have indexed WHERE clauses (e.g. table scans) on your UPDATE/DELETEs it will trigger a table scan and lock the table. Also if you are locking 30% or more of the table it is escalated to a table lock.