“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
query results in the popular JSON (JavaScript Object Notation)
format, useful for integrating data to Web applications.”
LinuxToday is a trusted, contributor-driven news resource supporting all types of Linux users. Our thriving international community engages with us through social media and frequent content contributions aimed at solving problems ranging from personal computing to enterprise-level IT operations. LinuxToday serves as a home for a community that struggles to find comparable information elsewhere on the web.
Property of TechnologyAdvice. © 2025 TechnologyAdvice. All Rights Reserved
Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.