binlog_expire_logs_seconds 自动清理历史Binlog
binlog_row_value_options json优化版本binlog
cte_max_recursion_depth cte递归深度
cte：Common Table Express
innodb_checkpoint_disabled DEBUG模式的参数，用于调试recovery
innodb_ddl_log_crash_reset_debug DEBUG模式参数，Enable this debug option to reset DDL log crash injection counters to 1.
innodb_log_checkpoint_fuzzy_now DEBUG模式参数，Enable this debug option to force InnoDB to write a fuzzy checkpoint.
innodb_log_spin_cpu_abs_lwm
innodb_log_spin_cpu_pct_hwm
innodb_log_wait_for_flush_spin_hwm
Optimize the use of spin delay by user threads waiting for flushed redo.
以上几个参数参考：https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-logging.html
innodb_log_buffer_size在8.0变成动态参数
innodb_print_ddl_logs 打印改写系统表的DDL日志（现在DDL是原子的，有一个mysql.innodb_ddl_log系统表记录）
innodb_scan_directories There are two tablespace map files (tablespaces.open.1 and tablespaces.open.2) that are written to in circular fashion. Tablespace map file丢失的时候，指定一个扫tablespace的路径 https://dev.mysql.com/doc/refman/8.0/en/innodb-recovery.html#innodb-tablespace-discovery-scan-directory
innodb_temp_tablespaces_dir 临时表目录
internal_tmp_mem_storage_engine 支持两个参数TempTable和MEMORY
original_commit_timestamp replication的时候备库执行还是用主库的timestamp
persisted_globals_load 加载持久化的变量配置
resultset_metadata 不传metadata给client
temptable_max_ram TempTable占用的最大内存，超出就写DISK
windowing_use_high_precision Whether to compute window operations without loss of precision.
网友评论