MySQL 9.0 GA is Here!

Photo by Rubaitul Azad on Unsplash

My article is open to everyone; non-member readers can click this link to read the full text.

On July 2, 2024, the MySQL 9.0 GA version was officially released. Remember, MySQL 8.0 was officially released on April 19, 2018.

After a long span of six years, MySQL has finally released the 9.0 version with a major version number change.

Let me introduce the new changes in MySQL 9.0. This article includes the following content:

• Features added or changed in MySQL 9.0
• Deprecated features in MySQL 9.0
• Removed features in MySQL 9.0

New or Changed Features in MySQL 9.0

MySQL 9.0 has added the following features:

• Saving EXPLAIN Analyze JSON Output
• New Event Syntax for DDL Statements
• Two New Tables in the Performance Schema

Saving EXPLAIN Analyze JSON Output

Starting from MySQL 9.0.0, it is now possible to save the JSON output of the EXPLAIN ANALYZE command into a user variable using the following new…