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.

- Robert Pogson

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


  1. 1 Chris Weig Oct 1st, 2012 at 12:21 pm

    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.

  2. 2 dougman Oct 1st, 2012 at 12:51 pm

    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/

  3. 3 Chris Weig Oct 1st, 2012 at 1:08 pm

    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.

  4. 4 dougman Oct 1st, 2012 at 5:53 pm

    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?

  5. 5 That Exploit Guy Oct 1st, 2012 at 5:58 pm

    ‘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.

  6. 6 dougman Oct 1st, 2012 at 6:03 pm

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

    What’s your answer?? Access??

  7. 7 That Exploit Guy Oct 1st, 2012 at 6:17 pm

    @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?

  8. 8 Chris Weig Oct 2nd, 2012 at 12:03 am

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

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

  9. 9 oiaohm Oct 2nd, 2012 at 12:43 am

    Duct Tape is a good way to define MS Windows.

  10. 10 oldman Oct 2nd, 2012 at 3:36 am

    Duct Tape is a good way to define MS Windows.

    ROFLMAO

    Linux lives on duct tape.

  11. 11 oiaohm Oct 2nd, 2012 at 7:16 am

    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.

  12. 12 dougman Oct 2nd, 2012 at 7:40 am

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

  13. 13 Mongrol Oct 2nd, 2012 at 1:26 pm

    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?

  14. 14 Robert Pogson Oct 2nd, 2012 at 1:37 pm

    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.

  15. 15 Chris Weig Oct 3rd, 2012 at 12:07 am

    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.

  16. 16 JR Oct 3rd, 2012 at 12:39 am

    @ 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!

  17. 17 dougman Oct 3rd, 2012 at 6:41 am

    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.

  18. 18 JR Oct 3rd, 2012 at 8:42 am

    @ Dougman

    Here’s hoping you are right.

    Let’s see what happens to the TPP first.

  19. 19 dougman Oct 3rd, 2012 at 9:59 am

    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.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>




Archives by Month

My Mission

My observations and opinions about IT are based on 40 years of use in science and technology and lately, in education. I like IT that is fast, cost-effective and reliable. I do not care whether my solution is the same as yours. I like to think for myself.

My first use of GNU/Linux in 2001 was so remarkably better than what I had been using, I feel it is important work to share GNU/Linux with the world. I have been blessed by working in schools where students and school systems have benefited by good, modular software easily installed in most systems.

I have shown GNU/Linux to thousands of students and hundreds of teachers over the years and will continue in some way doing that until I die in spite of the opposition.

Posts

October 2012
S M T W T F S
« Sep   Nov »
 123456
78910111213
14151617181920
21222324252627
28293031  

    Writing

    3425 articles
    30494 comments

      Comments

      platforms
      linux 17406
      windows 12727
      macos 206
      sun 3
      wp 2

      browsers
      firefox 23839 
      safari 11829 
      chrome 11681 
      ie 4610 
      iceweasel 4236 
      opera 1641 
      konqueror 198 
      netnewswire 14 
      epiphany 2 
      flock 0 
      bonecho 0 
      lynx 0 

Bad Behavior has blocked 3348 access attempts in the last 7 days.