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:
a.. Add good indexes to your tables. Then your queries need to scan less
index records and consequently set less locks. Use EXPLAIN SELECT to
determine that MySQL picks appropriate indexes for your queries.
Best regards,
Heikki
Innobase Oy
(sql query)
Copied message:
...
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
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
