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.

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!

Uncategorized

Security Trends For 2024: SBOMs

A recent article on Forbes, linked below, lists five security trends that are likely to be important in 2024. Of course, AI-related security topics top...

Keep Reading

Uncategorized

Getting started with your first…

Anyone looking at writing their first Generative AI application should read this to save time. In June 2023, Google Cloud published a useful blog post,...

Keep Reading

Uncategorized

Read-Write and Read-Only query splitting…

Optimize the usage of the standby (secondary) read-only MySQL InnoDB Cluster servers by automatically and transparently distributing read-queries to them. A great feature in MySQL...

Keep Reading

Uncategorized

Considering Cloud Diversification?

Moving an enterprise to a Public Cloud can quickly feel like moving into a locked-in relationship with the Cloud vendor. One solution to diminish this...

Keep Reading

Uncategorized

Gartner: Global cloud consumption will…

Gartner forecasts that 2024 will see a 20% global cloud consumption increase from 2023 to $679B, while 2023 has seen an 18% increase from 2022...

Keep Reading

Uncategorized

ByteDance: Use AI for tuning…

ZDNet is reporting that a ByteDance (the maker of TikTok) Linux kernel developer has proposed to implement AI to tune the performance of Linux systems...

Keep Reading

AI Governance

What is AI TRiSM?

If reading now about AI TRiSM for the first time, it might be good read on and learn what it’s about because it leads the...

Keep Reading

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

Live Chat | Emergency