What are the options and variables introduced in MySQL 8.0?

MySQLMySQLi Database

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.
raja
Published on 12-Feb-2021 09:47:45
Advertisements