What’s New in MySQL 8.0 GA? Key Features and Upgrade Tips

Upgrade Note

Upgrading from MySQL 5.7 to MySQL 8.0 must be performed using the in‑place upgrade method. Downgrading from any MySQL 8.0 version to an earlier 8.0 version or to 5.7 is not supported. The only safe fallback is to back up all data before starting the upgrade.

Key New Features

Performance : Up to 2× faster throughput for read/write, I/O‑intensive, and high‑contention (hot‑spot) workloads compared with MySQL 5.7.

NoSQL Document Store : Enhanced schema‑less JSON document support with multi‑document transactions and full ACID compliance, reducing the need for a separate NoSQL database.

Window Functions : New window functions operate like aggregate functions without collapsing rows, allowing queries that would otherwise require GROUP BY to be expressed more naturally.

Hidden Indexes : Indexes can be hidden from the optimizer for performance testing and later made visible again.

Descending Indexes : Support for indexes that store values in descending order, improving efficiency of range queries that need reverse ordering.

Common Table Expressions (CTE) : Allows definition of temporary result sets that can be referenced within the same statement, making complex queries clearer and more modular.

UTF‑8 Default : The default character set is now utf8mb4, providing full Unicode support out of the box.

JSON Enhancements : New functions such as JSON_EXTRACT(), JSON_ARRAYAGG(), and JSON_OBJECTAGG() improve JSON data extraction and aggregation.

Reliability : InnoDB DDL operations are now atomic and crash‑safe, with metadata stored in a single transactional data dictionary.

High Availability : InnoDB Cluster offers native HA capabilities integrated directly into the database server.

Security : Updated OpenSSL integration, new default authentication plugin, SQL roles, password‑strength enforcement, and refined authorization mechanisms.

Technical References

Release notes: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html

Official announcement blog: https://blogs.oracle.com/mysql/announcing-general-availability-of-mysql-80

Feature overview: https://mysqlserverteam.com/whats-new-in-mysql-8-0-generally-available/

Download Links

General download page: https://dev.mysql.com/downloads/mysql/8.0.html

Windows x86_64 ZIP (183.3 MB): https://dev.mysql.com/downloads/file/?id=476233

Windows x86_64 ZIP Debug/Test (230.5 MB): https://dev.mysql.com/downloads/file/?id=476234