During the last MySQL & HeatWave Summit, Wim Coekaerts announced that a new optimizer is available and is already enabled in MySQL HeatWave. Let’s have a quick look at it and how to use it. The first step is to verify that Hypergraph is available: MySQL > SET SESSION optimizer_switch='hypergraph_optimizer=on'; ERROR: 3999 (42000): The hypergraph […]

MySQL Enterprise Monitor, aka MEM, retired in January 2025, after almost 20 years of exemplary service! What’s next? Of course, plenty of alternatives exist, open source, proprietary, and on the cloud. For MySQL customers, we provide two alternatives: This post focuses on the latter, as there is no apparent reason to deploy an Oracle Database […]

MySQL Group Replication is a powerful feature that allows you to create a fault-tolerant and redundant database system, ensuring high availability and data consistency across multiple servers. The primary goal of this technology is to provide automatic failover and improve the overall system’s reliability. If one of the servers in the group fails, the others […]

In previous posts, I discussed how to use MySQL Shell to dump and load data using a multithreaded process. When using util.dumpInstance(), we create a dump of all the data and schema changes, even those that have already been dumped previously. But what if we only want to dump the data and schema changes that have occurred since the last dump? In […]

You may have noticed that MySQL now supports creating functions (and store procedures) in Javascript using GraalVM. This new functionality is only available in MySQL Enterprise and MySQL HeatWave. As a developer, you can also get free access to MySQL Enterprise from Oracle Technology Network (OTN): MySQL Enterprise Download. I also recommend you look at […]

To be honest, the comparison between the two MySQL distributions is not something that excited me a lot. Mainly because from my MySQL memories, I knew that there is not a real difference between the two distributions when talking about the code base.To my knowledge the differences in the enterprise version are in the additional […]

  For Official MySQL Release Policy    https://dev.mysql.com/doc/refman/en/mysql-releases.html     

Preface This blog begins by introducing an alternative and optional thread handling mechanism called MySQL Thread Pool, available in the MySQL Enterprise Edition. It then delves into the “Max Transaction Limit” feature that was added to MySQL Thread Pool in MySQL 8.0. The blog shows the recommended MySQL Thread pool configuration and proceeds to compare […]

Last year, in March 2022, our MySQL Operator for Kubernetes became Generally Available. Since then, several new features were added to our operator and along with the release of MySQL Server 8.0.32 comes a new release of our MySQL Operator for Kubernetes 8.0.32-2.0.8.  The goal of the MySQL Operator for Kubernetes is to provide an easy way […]

On January 17 2023, MySQL Server 8.0.32 was released. It is the latest release of our MySQL 8.0 General Availability Release. The new release introduces a few new features alongside with some deprecations, as well as bugfixes and security fixes. Let’s dive into some detail on these new features and changes MySQL Enterprise Optimizer mysql> […]