What’s New in MySQL 9.0 Innovation Edition? Key Features and Improvements

On July 1, 2024, MySQL released the Innovation Edition 9.0 GA, distinct from the Long‑Term Support (LTS) line. This article outlines the most important changes and new capabilities introduced in this version.

Removed or Modified Features

The mysql_native_password authentication plugin has been removed; clients lacking CLIENT_PLUGIN_AUTH cannot connect, though the plugin remains usable on 9.0 clients for backward compatibility with older servers.

SQL statements CREATE EVENT, ALTER EVENT, and DROP EVENT can now be executed via PREPARE.

The error ER_SUBQUERY_NO_1_ROW, previously generated by statements containing the IGNORE keyword, has been eliminated from the error list.

Performance Schema Extensions

variables_metadata : Provides general information about system variables, including name, scope, type, range (if applicable), and description.

global_variable_attributes : Supplies attribute‑value pairs for properties assigned to global system variables.

EXPLAIN ANALYZE JSON Output

The result of EXPLAIN ANALYZE can now be saved in JSON format using the following syntax:

EXPLAIN ANALYZE FORMAT=JSON INTO @variable select_stmt

Windows Version Improvements

Windows users receive numerous experience enhancements, including the resolution of many installer‑related errors.

MySQL Shell Enhancements

Simplified lock handling in InnoDB ReplicaSet, eliminating the need for multiple per‑instance locks.

Support for partially or fully dissolving a ClusterSet.

Ability to execute .execute() on all reachable members of a cluster.

The upgrade checker now validates foreign‑key references.

These updates collectively expand MySQL’s functionality, improve performance diagnostics, and streamline administration across platforms.