Oracle previews MySQL 5.6
Apr 12, 2012, 14:01 (0 Talkback[s])
(Other stories by Joab Jackson)
Full Text Search: The Key to Better Natural Language Queries for NoSQL in Node.js
"In regards to replication, MySQL introduces Global Transactions
Identifiers (GTIDs), which assure the system can track data as it
is replicated across different servers. GTIDs will ease the process
of automatically switching to a duplicate server should the
original fail. Third-party software now offers this capability, but
this will be the first time MySQL itself can do the job.
"MySQL 5.6 offers a number of new features that should speed
queries. It can now consolidate multiple queries or result sets
into a single unit of work. It can assign the current date and time
as the default for DATETIME columns, eliminating the need for the
application to do that work itself. The software can also speed
query time by determining the best order of execution for Filesort
and ORDER BY queries.
"Another new benefit for developers: MySQL can also deliver
format, useful for integrating data to Web applications."