List:Internals« Previous MessageNext Message »
From:Lenz Grimmer Date:July 24 2007 6:42pm
Subject:Re: the IN list optimizer speed [Re: How can I disable equality
propagation in MySQL 5.0]
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Fri, 20 Jul 2007, Martin Friebe wrote:

> Part of the problem (at least where myisam is involved) is the way the
> optimizer calculates the cost.
> 
> 2 older patches to gain about 20% in the  myisam key lookup are
> http://bugs.mysql.com/bug.php?id=26232
> http://bugs.mysql.com/bug.php?id=26453
> 
> This isn't enough of course. and I am looking fwrd to see how this may be
> solved. (Also the above affects myisam only)

Well, gaining 20% is not too shabby!

I notice that there has not been much activity on getting these patches
incorporated since Martin posted them in February this year. Sergey, as you
are the assignee for both of these: what's the status? Any plans on incorporating
Martin's suggestions?

Bye,
	LenZ
- -- 
 Lenz Grimmer <lenz@stripped>, Community Relations Manager, EMEA
 MySQL GmbH, http://www.mysql.de/, Radlkoferstr. 2, D-81373 München
 Geschäftsführer: Kaj Arnö - HRB München 162140
 http://forge.mysql.com/ | http://planetmysql.org/ | http://dev.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: For info see http://quantumlab.net/pine_privacy_guard/

iD8DBQFGpkgXSVDhKrJykfIRAu/WAJ9IdNjSZ8zIruexpiXT2FRsKS+3WQCfXybN
m9SyPSK4qtINx9mOQtrU6Mk=
=ORBE
-----END PGP SIGNATURE-----
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