BT

New Early adopter or innovator? InfoQ has been working on some new features for you. Learn more

MySQL 5.6 Enterprise Edition with Full Text Indexes and Online DDL

| by Jonathan Allen on Feb 07, 2013. Estimated reading time: less than one minute |

The 5.6 series for MySQL has reached the point where Oracle feels comfortable in releasing an updated MySQL Enterprise Edition for its paying customers. The Enterprise Edition components included in this release are:

  • MySQL Enterprise Security (PAM and Windows authentication plugins)
  • MySQL Enterprise Audit
  • MySQL Thread Pool.

Previously these extensions were only available for MySQL 5.5 users.

MySQL 5.6 improves security features such as how it encrypts key configuration files and user passwords, but the big news is the improvements to InnoDB. The last major impediment to using this storage engine is the lack of full text indexing, which has finally been corrected.

A feature that is sure to make DBAs happy is the introduction of online DDL for InnoDB. Many common operations such as adding, renaming, and removing columns can be performed without preventing concurrent queries. Most of the online DDL operations can be performed in-place, though some data copying or reorganization may be involved.

The MySQL 5.6 Reference Manual includes a full list of new features.

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and dont miss out on content that matters to you

BT