Back to Top

New Features in MySQL 5.6

If you are using MySQL, You have to know about new features in next version of MySQL and the next version of MySQL has been made available for testing and feedback and changes are focused on better scalability, High performance and Improved flexibility.

Let’s get some quick idea about top 5 New features of Mysql 5.6.

Here is the list of top 5 features that you will get in MySQL 5.6.

Improved Optimizer

The MySQL Optimizer team has done a great job for implementing improvements so query execution more efficient in 5.6 that is index condition pushdown and multi-range reads.Index condition pushdown means that processing of WHERE clauses are moved to the storage engine, so its reduce the overhead and Multi-range Reads mean that when a query makes use of a secondary index, the disk blocks are sorted.

InnoDB improvements

The MySQL InnoDB team have been doing some awesome things with InnoDB in 5.6 because InnoDB now provides “No-SQL” access to your InnoDB data via new New Memcached API to InnoDB tables.

New NoSQL with memcached APIs

We can say it’s a major addition that Mysql provides NO-SQL Interface.To increase a performance of web-based services has generated NoSQL access methods to MySQL providing the fast performance for simple queries.With the use of the Memcached API, web services can now directly access the InnoDB storage engine.

Better Replication

The MySQL entire Replication team had got users review and implemented some of the most enabling features because replication is the feature can enhance the data integrity and availability with performance.

Must Read: MySQL Connection: Let be Assured

Performance Schema

The Performance Schema that was created in 5.5 has been improved in 5.6 with some new functionality like Table Locks, Table I/Os, Table Lock Wait.

Comments (10)

    1. You have the moopnoly on useful information-aren’t monopolies illegal? 😉

  1. Nice post. thanks for sharing information. with facebook using mysql now I am sure will increase recognition of mysql.

    1. Woah nelly, how about them aplpes!

  2. Got it! Thanks a lot again for hlpieng me out!

    1. Reading through your blog posting made me realize what I appreciate most in database systems: Ones that just work without me needing to know what’s going on behind the scenes

  3. At last, sooemne comes up with the “right” answer!

  4. You have my take part in an election for New facial appearance in MySQL 5.6 | imaginative Dev and I’ll bookmark your blog now.

  5. Great post at New Features in MySQL 5.6 | Creative Dev. I was checking continuously this blog and I am impressed! Very useful information particularly the last part 🙂 I care for such information a lot. I was looking for this certain information for a very long time. Thank you and good luck.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Most Popular Posts

How to use Ajax in WordPress

Posted on 11 years ago

Bhumi

How to use Git init command

Posted on 7 years ago

Bhumi

Getting Started with CodeIgniter

Posted on 12 years ago

Bhumi

MySQL FULLTEXT Index and Search

Posted on 9 years ago

Bhumi