• Davi Arnaut's avatar
    Bug#40536: SELECT is blocked by INSERT DELAYED waiting on · bc03c9ef
    Davi Arnaut authored
               upgrading lock, even with low_priority_updates
    
    The problem is that there is no mechanism to control whether a
    delayed insert takes a high or low priority lock on a table.
    
    The solution is to modify the delayed insert thread ("handler")
    to take into account the global value of low_priority_updates
    when taking table locks. The value of low_priority_updates is
    retrieved when the insert delayed thread is created and will
    remain the same for the duration of the thread.
    bc03c9ef
delayed.test 9.79 KB