Syntax error What are the options and variables introduced in MySQL 8.0?

What are the options and variables introduced in MySQL 8.0?

Some of the options and variables newly introduced in MySQL 8.0 have been listed below:

  • Com_clone: It refers to the number of CLONE statements. It was added in MySQL 8.0.2.
  • Com_create_role: It refers to the number of CREATE ROLE statements that are used. It was added in MySQL 8.0.0.
  • Com_drop_role: It refers to the number of DROP ROLE statements that were used. It was added in MySQL 8.0.0.
  • Com_restart: It refers to the number of RESTART statements that were used. It was added in MySQL 8.0.4.
  • Firewall_access_denied: It refers to the number of statements that were rejected by MySQL Enterprise Firewall. It was added in MySQL 8.0.11.
  • Innodb_redo_log_enabled: It 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 or not. It was added in MySQL 8.0.11.
  • audit_log_encryption: It refers to the audit log file encryption method. It was added in MySQL 8.0.11.
  • clone_autotune_concurrency: It enables dynamic spawning of threads for remote cloning 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 the checkpoints so that deliberate server exit always initiates the process of recovery. It was added in MySQL 8.0.2.
  • innodb_deadlock_detect: It enables or disables the deadlock detection. It was added in MySQL 8.0.0.
  • innodb_dedicated_server: It enables the automatic configuration of buffer pool size, log file size, and flush method. It was added in MySQL 8.0.3.
  • innodb_directories: It defines the directories so as to scan at startup for tablespace data files. It was added in MySQL 8.0.4.
  • thread_pool_size: It refers to the number of thread groups in the thread pool. It was added in MySQL 8.0.11.
Updated on: 2021-02-24T12:10:15+05:30

204 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements