What options and variables are deprecated in MySQL 8.0?

Listed below are some options and variables that have been deprecated in MySQL 8.0:

• Compression: It tells the client to connect Whether to use compression on the client/server protocol or not. Deprecated since MySQL 8.0.18.
• expire_logs_days: It clears binary logs after a specific number of days. Deprecated as of MySQL 8.0.3.
• log_syslog: Determines whether to write error logs to syslog. Deprecated since MySQL 8.0.2.
• master-info-file: This helps determine the location and name of the file that remembers the source and the position of the I/O replication thread in the source's binary log. Deprecated since MySQL 8.0.18.
• master_info_repository: It determines whether to write to the connection metadata repository, containing source information and replication I/O thread locations in the source binary log, or to a file or table. Deprecated since MySQL 8.0.23.
• max_length_for_sort_data: It refers to the maximum number of bytes present in a sorted record. Deprecated since MySQL 8.0.20.
• no-dd-upgrade: It prevents automatic upgrade of data dictionary tables at startup. Deprecated since MySQL 8.0.16.
• relay_log_info_file: Refers to the file name of the application metadata repository where the replica records information about the relay log. Deprecated as of MySQL 8.0.18.
• relay_log_info_repository: Determines whether the location of the replicated SQL thread in the relay log is written to a file or table. Deprecated as of MySQL 8.0.23.
• slave_compressed_protocol: Used for source/replica protocol compression. Deprecated since MySQL 8.0.18.
• Symbolic links: It provides permissions for symbolic links to MyISAM tables. Deprecated since MySQL 8.0.2.

The above is the detailed content of What options and variables are deprecated in MySQL 8.0?. For more information, please follow other related articles on the PHP Chinese website!