Re: bzr commit into mysql-5.1-bugteam branch (davi:2728) Bug#40536

[Sergei Golubchik]

Hi, Davi!

On Jan 06, Davi Arnaut wrote:
> # At a local mysql-5.1-bugteam repository of davi
> 
>  2728 Davi Arnaut	2009-01-06
>       Bug#40536: SELECT is blocked by INSERT DELAYED waiting on
>                  upgrading lock, even with low_pri
>       
>       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 add a new global variable which specifies
>       whether a delayed insert thread should take high or low priority
>       locks. The name of the variable is low_priority_delayed_updates.

I think this new feature is uncalled for.
Why don't you use low_priority_updates ?

Regards / Mit vielen Grüßen,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  Principal Software Engineer/Server Architect
/_/  /_/\_, /___/\___\_\___/  Sun Microsystems GmbH, HRB München 161028
       <___/                  Sonnenallee 1, 85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Häring