Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.
Oracle announces general availability of MySQL 5.6
Posted on 6-Feb-2013 09:51. | Tags Filed under: News.



Oracle today announced the general availability of open-source database MySQL 5.6. With increased performance, scalability, reliability and manageability, MySQL 5.6 helps users meet the most demanding Web, Cloud and embedded application requirements.

MySQL 5.6 improves developer agility with subquery optimizations, online Data Definition Language (DDL) operations, NoSQL access to InnoDB, new instrumentation in Performance Schema and better condition handling.

With this version, users can experience simplified query development and faster execution, better transactional throughput and application availability, flexible NoSQL access, improved replication and enhanced instrumentation.

"MySQL 5.6 Release Candidate received great feedback from the community and helped us to efficiently mature the technology to announce General Availability," said Tomas Ulin, vice president of MySQL Engineering. "The new features and enhancements that MySQL 5.6 delivers further demonstrate Oracle's investment in driving MySQL innovation, making MySQL a fantastic fit for today's most demanding Web, Cloud and embedded application requirements."

Highlights of MySQL 5.6 include better query execution times and diagnostics provided through an enhanced MySQL Optimizer diagnostics.

The addition of Index Condition Pushdown (ICP) and Batch Key Access (BKA) can improve selected query throughput by up to 280x according to the company.

Oracle also says the new version brings greater performance throughput and application availability with an improved InnoDB storage engine, with up to 230 percent improvement in transactional and read only throughput. InnoDB has been re-factored to minimize legacy threading, flushing, and purge mutex contentions and bottlenecks, enabling better concurrency on heavily loaded OLTP systems, and resulting in significantly improved throughput for both transactional and read only workloads.

New online DDL operations enable DBAs to add indexes and perform table alterations while the application remains available for updates.

Other performance enhancements include a simple key value lookup, with flexible NoSQL access to InnoDB providing access to data via the familiar Memcached API. This means users get key-value operations and complex SQL queries in the same database.

MySQL 5.6 includes a number of additional enhancements including Geographic Information Systems for precise spatial operations, improved IPv6 compliance and optimized server defaults.



comments powered by Disqus




Trending now »

Hot discussions in our forums right now:

Sour experience with Spark.
Created by jeeg, last reply by networkn on 26-Aug-2016 21:58 (19 replies)
Pages... 2


Slingshot traffic shaping on NZB - any point going to UFB?
Created by Digikiwi, last reply by toejam316 on 26-Aug-2016 19:29 (18 replies)
Pages... 2


import modem from china
Created by techrebel, last reply by Behodar on 26-Aug-2016 15:18 (37 replies)
Pages... 2 3


Geekzone Father's Day giveaway: PowerAll Deluxe
Created by freitasm, last reply by Tel69 on 25-Aug-2016 20:39 (87 replies)
Pages... 4 5 6


Galaxy Note 7 Announcement and Owners' Thread
Created by eracode, last reply by lquify on 26-Aug-2016 17:50 (401 replies)
Pages... 25 26 27


Greens' Proposed restrictions in Kiwi Saver?
Created by MikeAqua, last reply by Geektastic on 26-Aug-2016 09:56 (114 replies)
Pages... 6 7 8


Geekzone Father's Day giveaway: Fugoo +Style Bluetooth speaker
Created by freitasm, last reply by Finch on 25-Aug-2016 13:49 (74 replies)
Pages... 3 4 5


GTX1060 in mobile only 10% slower than desktop, true?
Created by TeaLeaf, last reply by TeaLeaf on 26-Aug-2016 14:28 (11 replies)