Options and Variables Introduced in MySQL 8.0 • temptable_max_ram : Defines maximum amount of memory that can occupied by TempTable storage engine before data is stored on disk. Added in MySQL 8.0.2. • temptable_use_mmap : Defines whether TempTable storage engine allocates memory-mapped files when the temptable_max_ram threshold is reached. Added in MySQL 8.0.16. • thread_pool_algorithm : Thread pool algorithm. Added in MySQL 8.0.11. • thread_pool_high_priority_connection : Whether current session is high priority. Added in MySQL 8.0.11. • thread_pool_max_active_query_threads : Maximum permissible number of active query threads per group. Added in MySQL 8.0.19. • thread_pool_max_unused_threads : Maximum permissible number of unused threads. Added in MySQL 8.0.11. • thread_pool_prio_kickup_timer : How long before statement is moved to high-priority execution. Added in MySQL 8.0.11. • thread_pool_size : Number of thread groups in thread pool. Added in MySQL 8.0.11. • thread_pool_stall_limit : How long before statement is defined as stalled. Added in MySQL 8.0.11. • tls_ciphersuites : Permissible TLSv1.3 ciphersuites for encrypted connections. Added in MySQL 8.0.16. • upgrade : Control automatic upgrade at startup. Added in MySQL 8.0.16. • use_secondary_engine : Whether to execute queries using a secondary engine. Added in MySQL 8.0.13. • validate-config : Validate server configuration. Added in MySQL 8.0.16. • validate_password.check_user_name : Whether to check passwords against user name. Added in MySQL 8.0.4. • validate_password.dictionary_file : validate_password dictionary file. Added in MySQL 8.0.4. • validate_password.dictionary_file_last_parsed : When dictionary file was last parsed. Added in MySQL 8.0.4. • validate_password.dictionary_file_words_count : Number of words in dictionary file. Added in MySQL 8.0.4. • validate_password.length : validate_password required password length. Added in MySQL 8.0.4. • validate_password.mixed_case_count : validate_password required number of uppercase/ lowercase characters. Added in MySQL 8.0.4. • validate_password.number_count : validate_password required number of digit characters. Added in MySQL 8.0.4. • validate_password.policy : validate_password password policy. Added in MySQL 8.0.4. • validate_password.special_char_count : validate_password required number of special characters. Added in MySQL 8.0.4. 66