List:Internals« Previous MessageNext Message »
From:Jay Pipes Date:July 20 2007 8:17pm
Subject:Re: How can I disable equality propagation in MySQL 5.0
View as plain text  
Hi Sergey!

OK, no worries.  That's exactly why I asked if there were difficulties I 
should be aware of.  :)

Jay

Sergey Petrunia wrote:
> Hi Jay,
> 
> On 7/20/07, Jay Pipes <jay@stripped> wrote:
>> Sergey, would this be something that might be better as a server
>> variable, configurable at runtime?  Seems like, given your patch below,
>> a community member might be able to put together a proper patch for
>> MySQL to have a configurable server setting to control this behaviour?
>>
>> What do you think?  Are there difficulties I should be aware of?
> 
> This patch is a rather crude fix targeted to solve one specific case.
> I don't think it should go into the server, nor in its current form
> neither as a server variable. If we start introducing such server
> variables, we will quickly end up with dozens of them, and it will be
> nearly impossible to tune them.
> 
> The real fix is to make everything to work automatically. I have one
> similar bug in the works (BUG#20932), and as far as I am aware, we'll
> get a bug entry for Mark's case and will take time to find the root
> causes of the slowdown (there may be several) and create a proper fix.
> The proper fix will likely have little in common with the provided
> band-aid patch.
> 
> BR
> Sergey
> -- 
> Sergey Petrunia, Software Developer
> MySQL AB, www.mysql.com
> Office: N/A
> Blog: http://s.petrunia.net/blog
> 

Thread
How can I disable equality propagation in MySQL 5.0Mark Callaghan18 Jul
Re: How can I disable equality propagation in MySQL 5.0Sergey Petrunia19 Jul
  • Re: How can I disable equality propagation in MySQL 5.0Mark Callaghan19 Jul
    • Re: How can I disable equality propagation in MySQL 5.0Jay Pipes20 Jul
      • Re: How can I disable equality propagation in MySQL 5.0Sergey Petrunia20 Jul
        • the IN list optimizer speed [Re: How can I disable equality propagationin MySQL 5.0]Martin Friebe20 Jul
          • Re: the IN list optimizer speed [Re: How can I disable equalitypropagation in MySQL 5.0]Lenz Grimmer24 Jul
            • Re: the IN list optimizer speed [Re: How can I disable equality propagation in MySQL 5.0]Sergey Petrunia31 Jul
          • Re: the IN list optimizer speed [Re: How can I disable equality propagation in MySQL 5.0]Sergey Petrunia31 Jul
        • Re: How can I disable equality propagation in MySQL 5.0Jay Pipes20 Jul