MySQL, One of the World’s Great Databases, Keeps Improving

MySQL 5.6 will have some dramatic increases in performance:

  • “Oracle says that the throughput of InnoDB tables has been greatly improved and that it handles, for example, twice as many read transactions per second as in version 5.5, and almost four times as many write transactions. InnoDB tables can now also be saved on any number of physical devices, this functionality is due to a feature called “portable table spaces”.”
  • “The optimiser now uses semi-joins and subquery materialisation. Oracle says that this has allowed MySQL to execute query 18 in the DBT3 database benchmark in a reasonable amount of time – while the estimated execution time used to be about 45 days, the test can now be completed within seconds.”

This will make one of the most popular FLOSS database also one of the best. Not bad. Oracle is concentrating on InnoDB database engine. That will likely kill off some competition or spur greater efforts. PostgreSQL is pretty solid these days, too. Choice is good and better choices are better, too.

see Release candidate for MySQL 5.6 available.

About Robert Pogson

I am a retired teacher in Canada. I taught in the subject areas where I have worked for almost forty years: maths, physics, chemistry and computers. I love hunting, fishing, picking berries and mushrooms, too.
This entry was posted in technology. Bookmark the permalink.

19 Responses to MySQL, One of the World’s Great Databases, Keeps Improving

  1. dougman says:

    When you boil it all down, its about control.

    Linus was smart with open-sourcing Linux, that way no single entity has ownership, its free and available to anyone and everyone that’s willing to learn it.

  2. JR says:

    @ Dougman

    Here’s hoping you are right.

    Let’s see what happens to the TPP first.

  3. dougman says:

    The federal government cannot regulate the Internet. Therefore, it cannot regulate public opinion. Talk about this has been going on for some time.

    With the most recent DOS attacks on banking things are beginning to heat up, but nothing will change, industry and society would revolt.

    Use SOPA as a recent example.

    In 1963, there were only three television networks. The liberals controlled all three. Today, there are hundreds of alternatives to the status quo. If we count Internet options, there are millions of alternatives. In November 1963, there were three television network news services. They were all liberal. They dominated American information distribution. Not today.

    The fact that there are individual examples of petty tyrannical behavior, meaning arrogant bureaucratic behavior, is not proof of a systematic policy to take us down the road to serfdom. It means that we find out about these incidents through the Internet. That was harder to do in 1963 or even 1993. When Matt Drudge blew the digital whistle in 1998 on Newsweek for having suppressed a story on Bill Clinton and an intern, the road out of serfdom got smoother. Drudge still is a dominant news site. It gets about 3,000,000 hits a day. In contrast, Newsweek was sold for one dollar in 2010.

  4. JR says:

    @ All Posters

    You all post here nitpicking about the pros and cons of Windows and Linux and anything in between.

    Read this and get your priorities right:

    http://www.forbes.com/sites/ciocentral/2012/10/02/net-threat-the-dangers-from-global-web-regulation/

    Not to say that this shall come to pass but if it does,
    Well!? Duct Tape will not cut it!

  5. Chris Weig says:

    They are not but clearly, with the work they did on MySQL they are working hard to earn my trust.

    For your trust to be earned it’s enough for someone to write “M$ is evil!” on this blog. Your trust is worthless.

  6. Mongrol wrote, “Why are Oracle now back in Mr Pogson’s good books”.

    They are not but clearly, with the work they did on MySQL they are working hard to earn my trust. I have PostgrSQL queued up and ready to go. I could drop-in MariaDB also. MySQL is pretty good and useful software before the latest tweaks but this looks like they mean business. I think it’s good that a business like Oracle promotes a little diversity. It was a huge blunder what they did with OpenOffice.org and Java but that is mostly water under the bridge. I don’t see Oracle deliberately doing harm. They seem intent on maximizing their return on effort which is a good thing.

  7. Mongrol says:

    Why are Oracle now back in Mr Pogson’s good books, when not so long ago he was raking them over the coals in too many articles to list?

  8. dougman says:

    Hacking the registry in Windows to do something that you want it to, is the best analogy of duct taping if any.

  9. oiaohm says:

    oldman really lives on duct tape hardly.

    Compare to a quality OS yes Linux lives on duct tape.

    But the reality is windows is used like duct tape by people who don’t know that OS’s should be properly built. Linux is a better grade of duct tape still not the best secure solution. But at least I did not waste money on tape.

  10. oldman says:

    Duct Tape is a good way to define MS Windows.

    ROFLMAO

    Linux lives on duct tape.

  11. oiaohm says:

    Duct Tape is a good way to define MS Windows.

  12. Chris Weig says:

    Expolited Dude, vainly attempts to deflect the issue by comparing Duct tape to MySql.

    Dougman, it’s embarassing, stop wailing and flailing.

  13. That Exploit Guy says:

    @dougmon

    ‘Expolited Dude, vainly attempts to deflect the issue by comparing Duct tape to MySql.’

    You haven’t even defined the issue yet, and you are expecting an answer?

    Seriously, is that the kind of ethos you have when you go around asking people to buy your solutions?

  14. dougman says:

    Expolited Dude, vainly attempts to deflect the issue by comparing Duct tape to MySql.

    What’s your answer?? Access??

  15. That Exploit Guy says:

    ‘WordPress is run on MySQL. MySQL is the most popular database product used by everyone from a pre-teen aspiring to be a hacker to the largest Internet properties like Facebook, Yahoo and Google.’

    Duct tape is also used by everyone from backyard mechanics to professional tradespeople. So what?

    So many words, yet so little meaning.

  16. dougman says:

    Weigy’s was concerned enough to compose a colorful Troll-like retort to Pogson in a vain attempt to incite him, however it’s latest response belies the facts with earlier nescient comments such as:

    Perhaps Nokia’s move to Windows Phone wasn’t such a bad one…….Android will keep sinking deeper and deeper into the mud, Windows Phone will be rising from the “ashes”.

    Meanwhile, in the real world…..

    http://www.dailytech.com/Investors+Growing+Tired+of+Nokias+Elop+Eye+Android+Escape+Route/article27729.htm

    http://www.reuters.com/article/2012/09/19/us-nokia-strategy-idUSBRE88I0IQ20120919

    Weigy’s comments are of little use, eh?

  17. Chris Weig says:

    Dougman, you really can’t read.

    First of all, I’m not the one who’s concerned. FLOSS people are. (You also don’t need to link to a 2009 blog post when I presented to you a blog post from 2012 giving expression to certain concerns.) I could care less if Oracle restricts access to MySQL’s source code even further. But apparently you can’t.

    Second, you haven’t grasped the intention of my comment at all. FLOSS is per definitionem about doing the right thing. And these days MariaDB is the “right thing”, if you look at it from the highly moralistic FLOSS point of view. Therefore my comment merely expresses amusement, because Mr. Pogson implicitly endorses Oracle, a company which — when seen through the FLOSS lens — is anything but ethical.

  18. dougman says:

    Armchair Chris at it again,

    WordPress is run on MySQL. MySQL is the most popular database product used by everyone from a pre-teen aspiring to be a hacker to the largest Internet properties like Facebook, Yahoo and Google.

    Matt Mullenweg said back in 2009 “not to worry”, so why are you concerned?

    http://ma.tt/2009/04/oracle-and-open-source/

  19. Chris Weig says:

    Wait, didn’t your FLOSS friends come to the conclusion that Oracle is evil? Yes, they did:

    http://blog.mariadb.org/disappearing-test-cases/

    Get with the program, Pogson.

Leave a Reply