Home > Database > Mysql Tutorial > body text

What options and variables are deprecated in MySQL 8.0?

WBOY
Release: 2023-09-13 20:21:07
forward
817 people have browsed it

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!

source:tutorialspoint.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template