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.