Options and Variables Introduced in MySQL 8.0 • print_identified_with_as_hex : For SHOW CREATE USER, print hash values containing unprintable characters in hex. Added in MySQL 8.0.17. • protocol_compression_algorithms : Permitted compression algorithms for incoming connections. Added in MySQL 8.0.18. • regexp_stack_limit : Regular expression match stack size limit. Added in MySQL 8.0.4. • regexp_time_limit : Regular expression match timeout. Added in MySQL 8.0.4. • replication_optimize_for_static_plugin_config : Shared locks for semisynchronous replication. Added in MySQL 8.0.23. • replication_sender_observe_commit_only : Limited callbacks for semisynchronous replication. Added in MySQL 8.0.23. • require_row_format : For internal server use. Added in MySQL 8.0.19. • resultset_metadata : Whether server returns result set metadata. Added in MySQL 8.0.3. • rpl_read_size : Set minimum amount of data in bytes which is read from binary log files and relay log files. Added in MySQL 8.0.11. • secondary_engine_cost_threshold : Optimizer cost threshold for query offload to a secondary engine.. Added in MySQL 8.0.16. • select_into_buffer_size : Size of buffer used for OUTFILE or DUMPFILE export file; overrides read_buffer_size. Added in MySQL 8.0.22. • select_into_disk_sync : Synchronize data with storage device after flushing buffer for OUTFILE or DUMPFILE export file; OFF disables synchronization and is default value. Added in MySQL 8.0.22. • select_into_disk_sync_delay : When select_into_sync_disk = ON, sets delay in milliseconds after each synchronization of OUTFILE or DUMPFILE export file buffer, no effect otherwise. Added in MySQL 8.0.22. • show_create_table_skip_secondary_engine : Whether to exclude the SECONDARY ENGINE clause from SHOW CREATE TABLE output. Added in MySQL 8.0.18. • show_create_table_verbosity : Whether to display ROW_FORMAT in SHOW CREATE TABLE even if it has default value. Added in MySQL 8.0.11. • sql_require_primary_key : Whether tables must have primary key. Added in MySQL 8.0.13. • ssl_fips_mode : Whether to enable FIPS mode on server side. Added in MySQL 8.0.11. • syseventlog.facility : Facility for syslog messages. Added in MySQL 8.0.13. • syseventlog.include_pid : Whether to include server PID in syslog messages. Added in MySQL 8.0.13. • syseventlog.tag : Tag for server identifier in syslog messages. Added in MySQL 8.0.13. • table_encryption_privilege_check : Enables TABLE_ENCRYPTION_ADMIN privilege check. Added in MySQL 8.0.16. • temptable_max_mmap : The maximum amount of memory the TempTable storage engine can allocate from memory-mapped temporary files. Added in MySQL 8.0.23. 65