• Inaam Rana's avatar
    Bug#13789853 SHOW ENGINE INNODB STATUS HANGS DUE TO EXCESSIVE WORK · e56854d8
    Inaam Rana authored
    IN LOCK_VALIDATE()
    
    rb://917
    approved by: Marko Makela
    
    In lock_validate() the limit is used to release the kernel_mutex during
    the validation, to obey the latching order.
    If we do the limit++ then we are rechecking the same lock most times on
    each iteration because limit is being incremented by one and
    <space, page_no> will nearly always be > limit. If we set the limit
    correctly to (space, page+1) then we are actually making progress
    during the iteration.
    e56854d8
lock0lock.c 160 KB