Sekhar,
do your updates have good indexes through which they can access only the
rows they are going to update?
>From section 8.4 of http://www.innodb.com/ibman.html:
"
UPDATE ... SET ... WHERE ... : sets an exclusive next-key lock on every
record the search encounters
"
>From section 8.5:
"
Hi,
I have did setup for MySQL - Innodb tables. But I am not getting support for
row level locks. Whenever I am issuing a update the innodb tables are
locking my tables. Please help me whether I need to set any variables in
sqld file to get the support for row level locks ???
Regards,
Sekhar
-
