As well adding new features, our goal in the server team is to make MySQL easier to use. We try to design features with the goal of making a net improvement on usability. However, the actual definition of usable server software is not so straight-forward.…
One of the more frequently asked questions about the native JSON data type, is what size can a JSON document be. The short answer is that the maximum size is 1GB. However, JSON often changes how data modeling is done, and deserves a slightly longer response.…
The long awaited first release candidate of MySQL 8.0 is now available. The theme of this release is “making MySQL better for modern apps”. What does that mean exactly?
- A modern application is mobile first. Mobile-first is not just a theme applied to an existing app, it is about using context about the user (such as their location) and reducing the clicks required for a transaction.
Although MySQL Query Cache was meant to improve performance, it has serious scalability issues and it can easily become a severe bottleneck.
This is indeed something we have observed in the MySQL team for a while.…
Long time MySQL users will recognize that there are two varieties of utf8 support in MySQL; utf8mb3 and utf8mb4. Let me dig a little bit deeper in explaining the history between the two:
- MySQL 4.1 (2004) was the first version to support character sets and collations.
In MySQL 5.7, one of the most popular new features is the introduction of JSON:
- The JSON data type
- A set of 20 functions to search, manipulate and create JSON documents
- Virtual Columns for JSON indexing
In MySQL 8.0 we plan to extend this functionality (for example: with the addition of JSON aggregate functions), but we are also considering changing the behaviour of one of the existing functions.…
In the MySQL team, one of our focuses over the last few releases has been improving the usability of the MySQL Server for operations teams. The results can be seen in a number of areas:
- Our continued investment in Performance Schema.
Starting with MySQL 8.0, we will drop libmysqld (aka “embedded server”). This change will affect only a handful of users, but for context let me start with an introduction.
libmysqld (also referred to as “the embedded server”) is a way of using MySQL without the client server protocol.…
On behalf of the entire team, I would like to thank you for stopping by our “meet the MySQL engineering team” BOF held Tuesday night.
Thank you for both your questions and suggestions. It is great to meet with such an enthusiastic audience, and be able to share ideas on what we are currently working on.…
A number of members of the MySQL Engineering Team will be at Percona Live and the MySQL Innovation Day over the next week or so. Here is where you can find us: