Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    8

    Unanswered: row level locking in innodb tables

    Hi All,

    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.

    Regards,
    sekhar

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    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.
    Thanks,

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •