Friday, December 15, 2006

INNODB Performance bug will not be fixed in 4.x Community Edition

This bug 15815 a huge problem in thread handling with INNODB-will not be available for the Community Edition. Here are your options:


  1. Upgrade to 5.0

  2. Get a support contract that enables the Enterprise Edition

  3. Hope that pressure from the community will push MySQL to giving this patch to the masses




What sort of compensation would MySQL need to allow this patch into the community edition?

Getting everyone to use 5.0 is good for MySQL, maintaining what 5 versions of mySQL must suck. Also to keep this product alive, it takes money and talented engineers that need money too! Yet, for me personally I like 4.1 so I want to be a bit selfish and get this into the 4.1 community edition :)

9 comments:

Anonymous said...

I don't see the problem here.
InnoDB patching is complex and requires interaction with Oracle (as you can see from the bug report), MySQL 4 is an old release and, last but not least, money must be squeezed out somehow.
The real question is, if you need InnoDB like features and completely free software, why are you running mysql at all? There are other excellent OS databases around

benjamin said...

If there is a functionally and performance equivalent ACID compliant alternative, please tell us all about it and share some benchmarks. A lot of people will be interested. :)

Patching is not so complex, but testing is.

4.1 CE should probably be patched simply due to the severe nature of the problem and the prevalence of dual-core cpu's. That's just my opinion.

That said, anyone running it in production for a commercial purpose ought to be paying for an EE support license, period, IMO. ;-)

Sheeri said...

Enterprise licenses aren't that expensive, and it's not like they'll bind you into a multi-year agreement.

The lifecycle policy is at:

http://www.mysql.com/company/legal/lifecycle/

And it's pretty standard -- only working on 2 major versions at a time. This isn't a critical security fix, so it doesn't go into 4.1.

There's a blog post about how MySQL is releasing versions really fast and we're not used to it yet, and that's why this is such an issue. 5.0 came out in Oct. 2005 and here it is a year later the preferred version. OK, that sounds dumb....but most people wouldn't even think of upgrading for 6 months, when the kinks have been worked out, and so basically those folks have only had 6 months of time in which to upgrade.

So even though 4.1 has been out a long time, there has only been a short time in which there was something to upgrade *to*.

Anonymous said...

Well, it's possible to scrap the patch off 5.0/5.1 release and try to backport it to 4.1 manually, but I guess it's a lot of work...

Anonymous said...

Sorry, this is a free horse offer. The saddle is not included. If you want that, you can choose to pay for it, buy it elsewhere or make your own.

Feel free to kick the gift horse in the mouth because it's not as nice as you'd like it to be.

Anonymous said...

Since 4.x is EOL'ed at the end of this year (in 10 days, in fact), it doesn't make a whole lot of sense for MySQL to patch performance bugs at this time.

R2K said...

: )

Anonymous said...

benjamin, do you want to start a flamewar?
There is plenty of blogposts and benchmarks on the web that show strengths and weaknesses of MySQL and other opensource databases like PostgreSQL and Firebird, just Google or follow sites like www.planetpostgresql.org and www.firebirdnews.org.

sexy said...

情趣用品,情趣用品,情趣用品,情趣用品,情趣用品,情趣用品,情趣用品,情趣用品,情趣,情趣,情趣,情趣,情趣,情趣,情趣,情趣,按摩棒,跳蛋,充氣娃娃,情境坊歡愉用品,情趣用品,情人節禮物,情惑用品性易購

免費A片,AV女優,美女視訊,情色交友,免費AV,色情網站,辣妹視訊,美女交友,色情影片,成人影片,成人網站,A片,H漫,18成人,成人圖片,成人漫畫,情色網,日本A片,免費A片下載,性愛

A片,色情,成人,做愛,情色文學,A片下載,色情遊戲,色情影片,色情聊天室,情色電影,免費視訊,免費視訊聊天,免費視訊聊天室,一葉情貼圖片區,情色,情色視訊,免費成人影片,視訊交友,視訊聊天,視訊聊天室,言情小說,愛情小說,AIO,AV片,A漫,av dvd,聊天室,自拍,情色論壇,視訊美女,AV成人網,色情A片,SEX

情趣用品,A片,免費A片,AV女優,美女視訊,情色交友,色情網站,免費AV,辣妹視訊,美女交友,色情影片,成人網站,H漫,18成人,成人圖片,成人漫畫,成人影片,情色網


情趣用品,A片,免費A片,日本A片,A片下載,線上A片,成人電影,嘟嘟成人網,成人,成人貼圖,成人交友,成人圖片,18成人,成人小說,成人圖片區,微風成人區,成人文章,成人影城,情色,情色貼圖,色情聊天室,情色視訊,情色文學,色情小說,情色小說,臺灣情色網,色情,情色電影,色情遊戲,嘟嘟情人色網,麗的色遊戲,情色論壇,色情網站,一葉情貼圖片區,做愛,性愛,美女視訊,辣妹視訊,視訊聊天室,視訊交友網,免費視訊聊天,美女交友,做愛影片

av,情趣用品,a片,成人電影,微風成人,嘟嘟成人網,成人,成人貼圖,成人交友,成人圖片,18成人,成人小說,成人圖片區,成人文章,成人影城,愛情公寓,情色,情色貼圖,色情聊天室,情色視訊,情色文學,色情小說,情色小說,色情,寄情築園小遊戲,情色電影,aio,av女優,AV,免費A片,日本a片,美女視訊,辣妹視訊,聊天室,美女交友,成人光碟

情趣用品.A片,情色,情色貼圖,色情聊天室,情色視訊,情色文學,色情小說,情色小說,色情,寄情築園小遊戲,情色電影,色情遊戲,色情網站,聊天室,ut聊天室,豆豆聊天室,美女視訊,辣妹視訊,視訊聊天室,視訊交友網,免費視訊聊天,免費A片,日本a片,a片下載,線上a片,av女優,av,成人電影,成人,成人貼圖,成人交友,成人圖片,18成人,成人小說,成人圖片區,成人文章,成人影城,成人網站,自拍,尋夢園聊天室