| Version | Change log |
| MySQL 9.0.1 Innova Jul 23, 2024 |
Features Added or Changed in MySQL 9.0: The following features have been added to MySQL 9.0: Saving JSON output from EXPLAIN ANALYZE INTO. As of MySQL 9.0.0, support is now provided for saving JSON output from EXPLAIN ANALYZE into a user variable, using the synatx shown here: EXPLAIN ANALYZE FORMAT=JSON INTO @variable select_stmt The variable can be used subsequently as a JSON argument to any of MySQL's JSON functions (see Section 14.17, “JSON Functions”). The INTO clause is supported only with FORMAT=JSON; FORMAT must be specified explicitly. This form of EXPLAIN ANALYZE also supports an optional FOR SCHEMA or FOR DATABASE clause. Event DDL in prepared statements. Beginning with MySQL 9.0.0, the following statements can be prepared: CREATE EVENT ALTER EVENT DROP EVENT Positional parameters (? placeholders) are not supported for these statements; you must assemble the text of the statement to be prepared from some combination of string literals, system variables, and user variables. One way to accomplish this in a reusable fashion is to assemble the text of, for instance, a CREATE EVENT statement in the body of a stored procedure, passing any variable parts of the statement as IN parameters to the stored procedure; prepare the assembled text with PREPARE; invoke the procedure using the desired parameter values. See PREPARE, EXECUTE, and DEALLOCATE PREPARE Statements, and SQL Syntax Permitted in Prepared Statements, for more information. See Section 15.1.13, “CREATE EVENT Statement”, for an example. Performance Schema system variable tables. MySQL 9.0 add two new tables to the Performance Schema that provide information about server system variables. These tables are listed here: The variables_metadata table provides general information about system variables. This information includes the name, scope, type, range (where applicable), and description of each system variable recognized by the MySQL server. Two of the columns in this table (MIN_VALUE and MAX_ |
| MySQL 8.0.34 Jul 19, 2023 | |
| MySQL 8.0.33 May 2, 2023 | |
| MySQL 8.0.32 Jan 26, 2023 | |
| MySQL 8.0.31 Dec 14, 2022 | |
| MySQL 8.0.30 Jul 26, 2022 | |
| MySQL 8.0.29.0 Apr 26, 2022 | |
| MySQL 8.0.28.0 Jan 18, 2022 | |
| MySQL 8.0.27.1 Nov 29, 2021 | |
| MySQL 8.0.27 Oct 18, 2021 |
