MySQL Engineering Blogs
Hash join in MySQL 8
For a long time, the only algorithm for executing a join in MySQL has been variations of the nested loop algorithm. With the release of MySQL 8.0.18, the server can now execute joins using hash join. This blog post will have a look at how it works, when it is used, and how it compares to the old...
InnoDB : Tablespace Space Management
A user defined table and its corresponding index data, in InnoDB, is stored in files that have an extension .ibd. There are two types of tablespaces, general (or shared) tablespace and file-per-table. For shared tablespaces, data from many different tables and their corresponding indexes...
MySQL is Ready for Fedora 31
Fedora 31 is out today; another rev on one of the most popular community Linux distros out there. As usual, we support the latest Fedora from day one, and we have added the following MySQL products to our official MySQL yum repos: MySQL Server (8.0.18 and 5.7.28) Connector C++ 8.0.18 Connector...
MySQL Keyring now speaks Hashicorp Vault
As an intro to his performance act, an “old school” entertainer Victor Borge once famously asked the audience: “Do you care for piano music?“, which was greeted by a crowd, only to be immediately followed by a self-ironic punch line – “Too bad.” Security...
Group Replication delivery message service
In the process of enhancing MySQL replication with new features for our users, we also improve the internals. A lot of work goes also to modernize the codebase and make it easier to maintain and obviously extend as well. In MySQL 8.0.18, we have extended the set of internal services with a group...
Automatic member fencing with OFFLINE_MODE in Group Replication
Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Even if some of the servers subsequently fail, as long it is not all or a majority, the system is still available.…
MySQL EXPLAIN ANALYZE
MySQL 8.0.18 was just released, and it contains a brand new feature to analyze and understand how queries are executed: EXPLAIN ANALYZE. What is it? EXPLAIN ANALYZE is a profiling tool for your queries that will show you where MySQL spends time on your query and why.…
MySQL Shell 8.0.18 – What’s New?
The MySQL Development team is proud to announce a new version of the MySQL Shell with the following major improvements: Migration to Python 3 Built-in thread reports Ability to use an external editor Ability to execute system commands within the shell Admin API Improvements: New options to log...
MySQL Community Server
- Connector/ODBC 5.3
- Connector/C++ 1.1
- MySQL for Visual Studio 1.2
- MySQL Cluster 7.6
- MySQL Cluster 7.5
Which backup features do you require for your MySQL database backups?
"The Documents contained within this site may include statements about Oracle's product development plans. Many factors can materially affect Oracle's product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle.