mysql logo
Recently Oracle announced the release of the new branch of its DBMS «MySQL 8.3» along with which a corrective update of «MySQL 8.0.36» was also released. MySQL 8.3 introduces new features and some removals, fixes, and more.
For those who do not know about MySQL, you should know that this is the most popular and widely used relational database management system in the world, it is open source and uses the structured query language (SQL). It is developed and supported by Oracle Corporation. MySQL, especially in web applications.
Main new features of MySQL 8.3
In this new version, which is presented of MySQL 8.3, it stands out that added support for mold linker, a faster and more transparent replacement for the linked GNU on Linux systems. Support is not enabled by default and can be enabled using the option «-DWITH_LD=mold|lld«.
Another of the changes that stands out in this new version of MySQL 8.3 extended GTID format (global transaction identifier), used during replication to identify groups of transactions. The improvement is that it is now possible to easily group and identify sets of transactions. The new GTID format is “UUID::NUMBER” (instead of “UUID:NUMBER”), where TAG is an arbitrary string that allows unique names to be assigned to a specific group of transactions to facilitate processing and analysis.
In addition to this, in the MySQL Enterprise Edition now supports telemetry collection with metrics on server performance in the OpenTelemetry format, which can now transfer data to a network processor that supports this format.
It is also highlighted that Requirements for the C++ standard supported by the compiler have been raised from C++17 to C++20 and support for compiling with external Boost C++ libraries has been discontinued, as only the built-in Boost libraries are now used when compiling MySQL.
Moreover, thread pool plugin now includes additional information in the MySQL performance scheme. New tables and columns provide comprehensive information about connections and thread pool states, facilitating better performance analysis.
Las new variables and tables presented in MySQL 8.3, are the following:
- Varables “Deprecated_use_i_s_processlist_count” and “Deprecated_use_i_s_processlist_last_timestamp” to track the use of the obsolete INFORMATION_SCHEMA.PROCESSLIST table.
- explain_json_format_version variable: to select the JSON format version in “EXPLAIN FORMAT=JSON” statements.
- Table: tp_connections with detailed information about each connection in the thread pool.
- New columns in tp_thread_state: TIME_OF_ATTACH, MARKED_STALLED, STATE, EVENT_COUNT, ACCUMULATED_EVENT_TIME, EXEC_COUNT, and ACCUMULATED_EXEC_TIME
Se They have fixed 25 vulnerabilities of which one (affecting OpenSSL) can be exploited remotely. The most serious issue related to the use of the Kerberos protocol is assigned a severity level of 8,8. Less serious vulnerabilities with severity level 6.5 affect the optimizer, UDF, DDL, DML, replication, privilege system, and encryption tools
Of the other changes that stand out of this new version:
- In InnoDB, the “–innodb” and “–skip-innodb” options have been removed, as has the Memcached plugin for InnoDB.
Removed obsolete configurations and command line options related to replication. - Discontinuation of the Expression “FLUSH HOSTS”
The following MySQL C API functions were deprecated in previous versions of MySQL and have now been removed: - mysql_kill()
- mysql_list_fields()
- mysql_list_processes()
- mysql_refresh()
- flush-threads
- mysql_reload()
- mysql_shutdown()
Finally, if you are interested in being able to know more about it, you can consult the details in the following link
Get MySQL 8.3.0
For thes interested in being able to obtain the new version of MySQL 8.3.0, you should know that as part of the renewed launch model that divides MySQL into “Innovation” and “LTS” branches To address different needs, the Innovation branches (8.1, 8.2 and 8.3) are ideal for those looking to quickly access new features, with releases every 3 months and support until the next major version.
On the other hand, LTS branches offer long-term stability, with releases every two years and standard support for 5 years, optionally extended for an additional 3 years. The LTS release of MySQL 8.4 is planned for Spring 2024, followed by the launch of the Innovation 9.0 branch. Additionally, Oracle has released a corrective update, MySQL 8.0.36, to improve the stability and security of the MySQL 8.0 DBMS.
MySQL Community Server 8.3.0 builds are ready for Linux, FreeBSD, macOS, and Windows. You can get the new version In the following link.