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
