MySQL 8.2 Release Highlights and Community Contributions

MySQL 8.2, released on October 25, 2023, is the second Innovation version and moves the project closer to the first LTS release.

The release incorporates many community contributions from Meta, Amazon, Tencent and other developers.

1 Service Compilation

#111549 – Additional improvements to WITH_ZLIB (Nikolai Kostrigin)

#111467 – Build failure when using WITH_ZLIB="system" because ZLIB cannot be found (Meng‑Hsiu Chiang, Amazon)

2 Client

mysqldump: added --ignore-views option to skip table views in dump files (Meta)

mysqldump: added --init-command and --init-command-add options to execute SQL after connecting or reconnecting (Meta)

mysql: added --init-command-add option, similar to --init-command , to run extra SQL after (re)connection (Meta)

3 InnoDB

Fix for unexpected server shutdown when a table has an INSTANT ADD column added before 8.0.29 and DML is executed after upgrading beyond 8.0.29 (Richard Dang)

Fixed FTS parser handling of single‑character tokens (Shaohua Wang)

4 Optimizer

#109595 – records_in_range caused excessive disk reads during inserts (Meta)

#111564 – EXPLAIN FORMAT=TREE lost subqueries in Hash Join (Wen He, Tencent)

Fix for stored procedures containing SET statements that were not executed correctly after the first call (Hao Lu)

5 Clone Plugin

#110569 – Clone plugin sometimes fails with errno 22; always creates OS_CLONE_DATA_FILE and uses flush_redo() handling OS_CLONE_LOG_FILE , which can cause os_file_set_size() errors (Yin Peng, Tencent)

6 Documentation

#111200 – Updated internal MySQL manual links (Dan)

Developers who have patches can easily become MySQL contributors by sending a pull request to the MySQL GitHub repository or submitting patches for MySQL Bugs after signing the Oracle Contributor Agreement.