• Annamalai Gurusami's avatar
    Bug #14226171 EXCESSIVE ROW LOCKING WITH UPDATE IN 5.5.25 · 6ff71d0d
    Annamalai Gurusami authored
    When a DML statement is issued, and if the index merge 
    access method is chosen, then many rows from the
    storage engine will be locked because of the way the
    algorithm works.  Many rows will be locked, but they
    will not be part of the final result set.
    
    To reduce the excessive locking, the locks of unmatched
    rows are released by this patch.  This patch will 
    affect only transactions with isolation level
    equal to or less stricter than READ COMMITTED. This is
    because of the behaviour of ha_innobase::unlock_row().
    
    rb://1296 approved by jorgen and olav.
    6ff71d0d
opt_range.cc 371 KB