Open Source

What’s New with MySQL?

If you think that MySQL 5.5 is great, then you will be pleased to find out that MySQL 5.6 is even better.

Why?

When using MySQL 5.6, you get improved scalability and performance.

Better diagnostic and faster query execution

You also get to use the optimizer to help you get better diagnostic and faster query execution times.  The improvements in this regard include enhancements in subqueries, file sort, index condition pushdown, batched key access, delaying materialization of subqueries or view in FROM.  Each one of these improvements drastically improved execution times.  For example, file sort optimizations improved execution times by 300x, while multi-range reads cut down execution times from 2000 seconds to 10 seconds.  Truly, what used to take a couple of seconds before now finish in a matter of milliseconds!  When it comes to diagnostics, the improvements include enhancements in EXPLAIN, optimizer traces, among other things.

Better instrumentation

You get better instrumentation because of an improved performance schema, while replication is enhanced so you get higher data integrity and availability.

In these regards, MySQL 5.6.5 has replication admin tools as well as utilities for failovers.  You get binlogs and slaves that are crash-free, and replication checksums.  You also have multi-threaded slaves and reduced binlog sizes when it comes to RBR.  You can also delay replication for added flexibility while getting better management and monitoring.

Improved InnoDB

Furthermore, there’s an improved InnoDB so you get better throughput for your transactions.  These improvements help you get better performance on multicore servers and also CPU servers, while improving thread scheduling.  MySQL 5.6.5 also has fast checksum, improved LRU flushing and non-recursive deadlock detention.  Another major InnoDB enhancement focused on usability, where you can now do full-text searches, variable page sizes and bigger limits on index key prefixes.

[expand title=”Click here to read more about this article”]

Another improvement is the NotOnlySQL options, so you get to improve your flexibility.

Aside from these, there are also other enhancements that were put into MySQL 5.6.5.

  • DATETIME, TIME and TIMESTAMP
  • Improvements in the IPv6 protocols
  • It can now support unicode in the command client for Windows
  • You can now export or import tables even if the source or destination is a partitioned table.

NotOnlySQL improvements include a memcached API, which allows for simple and fast access to InnoDB, NotOnlySQL access and others.

More useful commercial extensions

There are also commercial extensions available for MySQL Enterprise Edition, including MySQL Enterprise Security, MySQL Enterprise Scalability, MySQL Enterprise High Availability and Oracle product certifications.

All of these are planned for MySQL 5.6, which aims to improve an already outstanding MySQL 5.5.  There are other improvements in the works that relate to MySQL Database:

  • More cloud, SaaS and DaaS features including multi-tenancy, elastic scale and Web-based management
  • High availability, including conflict detection, auto-failover, multi-source replication and pluggable architectures

They are also aiming to make MySQL Cluster easier to use, with enhanced API support and increased capacity and performance capabilities, and the ability to be deployed on the cloud or in virtualized environments.

You have the MySQL Enterprise

Lastly, there is the MySQL Enterprise, where you could expect to have better security and high availability when the improvements are applied.  What’s more, there are planned improvements on MySQL Enterprise Backup, Workbench SE and MySQL Enterprise Monitor.

Looking for help getting into MySQL?  Call Four Cornerstone today and let our team of MySQL experts help you![/expand]

Cloud Blog

4 Ways To Benefit from…

One of the benefits you get when you work with cloud applications is that you often have quarterly updates that are packed with features. This...

Keep Reading

Artificial Intelligence

Data and Analytics: Cross the…

  Artificial intelligence is a manna sent from digital heaven. That’s how blessed your business can get if you immerse into the AI of things....

Keep Reading

Business Intelligence Blog

How Brand Names Survive in…

  The age of digital marketplace has made it possible for unknown and smaller companies to compete with better-known and well-established brands. Take for example...

Keep Reading

Artificial Intelligence

The Phenomenon That Is Artificial…

  Artificial intelligence is when a machine does cognitive functions that are more associated with humans, such as thinking, learning, problem solving, and reasoning. As...

Keep Reading

Cloud

Digital Transformation in Banking: Shift…

  The start of a new decade is already shaping up to be exciting for financial services, especially for banks as they continue to compete...

Keep Reading

Business Intelligence Blog

Data Science and Its Economic…

It would seem that artificial intelligence is the focus of businesses that are looking to future proof their organizations and stay competitive. And why not?...

Keep Reading

Data Blog

Ensure Efficient Data Science and…

In an ever-expanding landscape called Internet of Things and the exploding development of artificial intelligence, we are bombarded with complex methods of integrating data science...

Keep Reading

Business Intelligence Blog

Cybersecurity: The Top 5 Expectations…

  If you think about it, cybersecurity is closely tied to human rights, privacy, freedom, and even basic safety. As a whole, we have become...

Keep Reading

Business Intelligence Blog

Tech Security Should Be Easy…

  IT professionals know that tech security is important in everything that they do. And that there are a lot of products, tools, innovations, and...

Keep Reading

Business Intelligence Blog

The Top 6 Success Stories…

Nearly nine out of 10 digital transformation initiatives fail. Digital transformation projects fail for a variety of reasons. It can be because of a lack...

Keep Reading

Live Chat | Emergency