The first DMR of MySQL 8 was recently released. While a DMR (or Developer Milestone Release) is not yet a GA product, it does come with our commitment that each feature has been tested and qualified for inclusion.
In MySQL 8.0 we have made additional improvements to the MySQL test framework (MTR) and the test suite.…
With MySQL 8.0, we are bringing in an important change in the way user management DDLs are executed.
User management DDLs cover following user management actions:
- Creating user/role (CREATE USER [IF NOT EXISTS] / CREATE ROLE [IF NOT EXISTS])
- Altering user account properties (ALTER USER [IF EXISTS])
- Dropping user/role from database (DROP USER [IF EXISTS] / DROP ROLE [IF EXISTS])
- Granting/Revoking privileges to/from a user/role (GRANT/REVOKE)
Each of these administrative action can handle multiple entities as a part of single command.…
The MySQL development team just published a Labs release of the MySQL Server (available under “MySQL Server 8.0.0 Optimizer”).
A prominent feature of this release, which I developed, is [Recursive] Common Table Expressions, also known as
- [recursive] CTE,
- [recursive] subquery factoring,
- WITH [RECURSIVE] clause.
Traditionally, setting up high availability (HA) in MySQL has been a challenging task, especially for people without advanced knowledge of MySQL. From understanding concepts and technologies, to the tooling, specific commands and files to execute and edit, there’s a lot of things you need to know even when planning a test deployment (the Quick Start Guide for Group Replication should give you an idea).…
Today we are introducing a new MySQL feature called MySQL InnoDB Cluster. Make sure to watch the demo video on the MySQL YouTube Channel!
Find out more by looking into the MySQL InnoDB Cluster documentation.
If you got questions or feedback please feel free to post on the MySQL Forums.…
Introducing the new MySQL InnoDB Cluster Feature
MySQL has had good support for replication for a long time. After all, it is one of the key features that have enabled companies like Facebook, Booking, Twitter and so many others to grow and scale to such extreme scale with MySQL as their primary database engine.…
In MySQL 8.0.0, the Performance Schema can now instrument server errors. There are 5 new summary tables introduced:
mysql> show tables like "%by_error%";
| Tables_in_performance_schema (%by_error%) |
| events_errors_summary_by_account_by_error |
| events_errors_summary_by_host_by_error |
| events_errors_summary_by_thread_by_error |
| events_errors_summary_by_user_by_error |
| events_errors_summary_global_by_error |
5 rows in set (0.02 sec)
As names suggest, statistics of errors in these tables are aggregated by error.…
In MySQL 8.0 we are improving the Performance Schema to support indexes. This increases the flexibility and ease of use of using performance_schema, as a number of monitoring queries will see a dramatic speed up in performance.
Since it’s initial launch in MySQL 5.5, the Performance Schema has grown to 93 tables, with some of these exposing a lot of data.…
Starting with MySQL 8.0 we are introducing a new feature which will allow configuration variables to be persisted. This means that for a number of configuration settings, you will no longer need to manually edit a configuration file and can instead make modifications directly via an SQL connection.…
One of the things we have been working on for MySQL 8, is speeding up scans that read multiple records from a table or an index. Such scans benefit from reading the records in batches, so that they don’t get the overhead of latching data pages and navigating in the B-tree for every single record that is read.…