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
