[Maria-developers] really annoying bug in mysql 5.0/5.1 optimiser, opened for more than 2 years, and still present in MariaDB
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 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
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
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