This article summarizes the parameters and features removed in the first version of MySQL 8.0. Some parameters and features are currently set to deprecated in MySQL 8.0. Some others have been set to deprecated in MySQL 5.7 or earlier versions, but are removed from the code in MySQL 8.0.
MySQL 8.0.0
WL#7704:InnoDB: Remove deprecated file format parameters in 8.0
The purpose of supporting file-format configuration is to stay compatible with earlier versions. In versions earlier than MySQL 8.0, two primary file formats are supported:
1. Antelope: The corresponding row format is: COMPACT and REDUNDANT.
2. Barracuda: the new file format. The corresponding row format is: COMPRESSED and DYNAMIC.
Since earlier versions have passed the deadline for long-time maintenance, the old file formats are not maintained in MySQL 8.0 any more.
So removing the old code is helpful to clarify the code structure.
Several parameters related to file_format are removed:
innodb_file_format
innodb_file_format_check
innodb_file_format_max
innodb_large_prefix
Columns related to file-format in INFORMATION_SCHEMA are removed:
innodb_sys_tables
After the code is committed, a large amount of code is erased and the structure looks much clearer.
WL#8157: Remove deprecated GIS functions
Old functions related to GIS are removed. New functions are replaced with ST_xxx. A total of 67 functions are removed, including their test cases.
WL#8843: Deprecate and remove the parameter innodb_support_xa
Parameter innodb_support_xa is removed. The reason is that this parameter has been invalid. On the one hand, when XA is set to OFF, PREPARE transactions can only be rolled back and cannot be committed; on the other hand, the data consistency of Binlog/Engine failure recovery should be ensured.
After this parameter is removed, the XA is enabled by default.
WL#8894: InnoDB: Remove deprecated parameter innodb_locks_unsafe_for_binlog
The same as above, the parameter innodb_locks_unsafe_for_binlog has been marked as deprecated in MySQL 5.6 and is removed from the code in MySQL 8.0. (The instruction document of the parameter. But again, I guess no one will set it in normal cases.)
WL#9071: Remove mysql_install_db and server --bootstrap option
The mysql_install_db is removed and the bootstrap parameter of mysqld is also deleted. In future, to install instances, you need to usemysqld --initialize
WL#9014: Deprecate and remove mysql_shutdown()
The C API mysql_shutdown is deleted and the Command type COM_SHUTDOWN is deleted.COM_SHUTDOWN
WL#9091: Remove --ssl, --ssl-verify-server-cert client-side options
The --ssl, --ssl-verify-server-cert client-side options are removed. In future, you can use --ssl-mode options implemented by WL#8785.
2,599 posts | 763 followers
FollowAlibaba Cloud Community - October 10, 2024
Morningking - September 26, 2023
Alibaba Cloud MaxCompute - December 7, 2018
Morningking - September 26, 2023
Alibaba Cloud Product Launch - December 12, 2018
Alibaba F(x) Team - August 29, 2022
2,599 posts | 763 followers
FollowAnalyticDB for MySQL is a real-time data warehousing service that can process petabytes of data with high concurrency and low latency.
Learn MoreAlibaba Cloud PolarDB for MySQL is a cloud-native relational database service 100% compatible with MySQL.
Learn MoreAn on-demand database hosting service for MySQL with automated monitoring, backup and disaster recovery capabilities
Learn MoreApsaraDB Dedicated Cluster provided by Alibaba Cloud is a dedicated service for managing databases on the cloud.
Learn MoreMore Posts by Alibaba Clouder
Raja_KT March 5, 2019 at 4:01 am
Thanks for the list. It is handy for referral.