
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
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.
- Related Articles
- What are the options and variables deprecated in MySQL 8.0?
- What are the options and variables that were removed in MySQL 8.0?
- Using Options to Set MySQL Program Variables
- What are the main features and enhancements introduced in Java 9?
- What are the properties of MySQL user variables?
- What are the new changes introduced in C++11?
- What are class variables, instance variables and local variables in Java?
- What are Call and Put Options?
- What are variables and types of variables in C++?
- What are local variables and global variables in C++?
- What are the new types introduced in HTML for input type?
- What are the variables?
- What are Bullish and Bearish Spreads in Stock Options Strategies?
- What are variables?
- Why are interfaces introduced in Java?\n

Advertisements