[Maria-developers] really annoying bug in mysql 5.0/5.1 optimiser, opened for more than 2 years, and still present in MariaDB
![](https://secure.gravatar.com/avatar/b6a4a6527136d87b3f9682ddfcf80dbe.jpg?s=120&d=mm&r=g)
Hi, There's a really annoying bug in the mysql optimiser existing for a really long time now, and which has a direct impact on performances : http://bugs.mysql.com/bug.php?id=36817 Since MySQL definitly doesn't seem to want to fix it, I hope MariaDB could do something to help the poor developpers who need to heavily hack there apps with USE INDEX ;) Note I've tested with mariadb 5.2.1-beta, and the bug is still present. Thanks a lot ! Jocelyn Fournier
![](https://secure.gravatar.com/avatar/0dd7f81a9d0395acbbcfefd7f7ff3f40.jpg?s=120&d=mm&r=g)
Jocelyn Fournier wrote:
Hi,
There's a really annoying bug in the mysql optimiser existing for a really long time now, and which has a direct impact on performances :
http://bugs.mysql.com/bug.php?id=36817
Since MySQL definitly doesn't seem to want to fix it, I hope MariaDB could do something to help the poor developpers who need to heavily hack there apps with USE INDEX ;)
Note I've tested with mariadb 5.2.1-beta, and the bug is still present.
Thanks a lot ! Jocelyn Fournier
Jocelyn, I will take care of this bug. Regards, Igor.
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
![](https://secure.gravatar.com/avatar/b6a4a6527136d87b3f9682ddfcf80dbe.jpg?s=120&d=mm&r=g)
Thanks a lot Igor ! This will definitly help me to finished to convince my system admins to switch from MySQL to MariaDB ;) Jocelyn Le 27/08/2010 18:04, Igor Babaev a écrit :
Jocelyn Fournier wrote:
Hi,
There's a really annoying bug in the mysql optimiser existing for a really long time now, and which has a direct impact on performances :
http://bugs.mysql.com/bug.php?id=36817
Since MySQL definitly doesn't seem to want to fix it, I hope MariaDB could do something to help the poor developpers who need to heavily hack there apps with USE INDEX ;)
Note I've tested with mariadb 5.2.1-beta, and the bug is still present.
Thanks a lot ! Jocelyn Fournier Jocelyn,
I will take care of this bug.
Regards, Igor.
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
![](https://secure.gravatar.com/avatar/b6a4a6527136d87b3f9682ddfcf80dbe.jpg?s=120&d=mm&r=g)
Hi Igor, Just curious, is there any bug corresponding to this issue in launchpad ? Thanks ! Jocelyn Le 27/08/10 18:04, Igor Babaev a écrit :
Jocelyn Fournier wrote:
Hi,
There's a really annoying bug in the mysql optimiser existing for a really long time now, and which has a direct impact on performances :
http://bugs.mysql.com/bug.php?id=36817
Since MySQL definitly doesn't seem to want to fix it, I hope MariaDB could do something to help the poor developpers who need to heavily hack there apps with USE INDEX ;)
Note I've tested with mariadb 5.2.1-beta, and the bug is still present.
Thanks a lot ! Jocelyn Fournier Jocelyn,
I will take care of this bug.
Regards, Igor.
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
participants (2)
-
Igor Babaev
-
Jocelyn Fournier