What options and variables were introduced in MySQL 8.0?

Listed below are some of the options and variables newly introduced in MySQL 8.0:

• Com_clone: ​​It refers to the CLONE statement quantity. It was added in MySQL 8.0.2.
• Com_create_role: It refers to the number of CREATE ROLE statements used. It was added in MySQL 8.0.0.
• Com_drop_role: It refers to the number of DROP ROLE statements used. It was added in MySQL 8.0.0.
• Com_restart: It refers to the number of RESTART statements used. It was added in MySQL 8.0.4.
• Firewall_access_denied: It refers to the number of statements denied by the MySQL Enterprise Firewall. Added in MySQL 8.0.11.
• Innodb_redo_log_enabled: refers to the InnoDB redo log status. It was added in MySQL 8.0.21.
• audit_log_current_session: It tells whether the current session needs to be audited. Added in MySQL 8.0.11.
• audit_log_encryption: Audit log file encryption method. It was added in MySQL 8.0.11.
• clone_autotune_concurrency: It supports dynamically generating threads for remote clone operations. It was added in MySQL 8.0.17.
• group_replication_flow_control_period: It defines the number of seconds to wait between flow control iterations. It was added in MySQL 8.0.2.
• innodb_checkpoint_disabled: It disables checkpoints so that intentional server exit always initiates the recovery process. It was added in MySQL 8.0.2.
• innodb_deadlock_detect: It enables or disables deadlock detection. It was added in MySQL 8.0.0.
• innodb_dedicated_server: It can automatically configure the buffer pool size, log file size and refresh method. It was added in MySQL 8.0.3.
• innodb_directories: It defines directories to scan tablespace data files at startup. Added in MySQL 8.0.4.
• thread_pool_size: refers to the number of thread groups in the thread pool. It was added in MySQL 8.0.11.

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