10.GTID相关... 17
11.同步相关参数... 17
12.查看mysql事务隔离级别... 19
12.1 查询语句... 19
12.2 事务隔离级别描述... 19
12.3修改事务的隔离级别... 20
13.innodb_autoinc_lock_mode. 21
13.1我们先对insert做一下分类... 21
13.2 innodb_autoinc_lock_mode 的说明... 21
13.2.1 tradition(innodb_autoinc_lock_mode=0) 模式: 22
13.2.2 consecutive(innodb_autoinc_lock_mode=1,推荐模式) 模式: 22
13.2.3 interleaved(innodb_autoinc_lock_mode=2) 模式... 22
13.3备注... 23
14.log_timestamps. 23
15.timezone. 23
15.1 可以通过修改my.cnf 23
15.2 另外也可以通过命令行在线修改... 24
15.3 通过select now()来验证时区... 24
16.lock_wait_timeout. 24
17.innodb_spin_wait_delay. 24
18.innodb_read_io_threads、 innodb_write_io_threads. 25
19.innodb_io_capacity. 25
20.innodb_max_dirty_pages_pct. 25
21.innodb_force_recovery. 25
22.undo tablespaces相关参数... 26
23.innodb_page_size. 27
24.innodb_buffer_pool_instances. 27
25.快速预热相关参数... 28
26.innodb_flush_method. 28
27.innodb_old_blocks_pct、innodb_old_blocks_time. 29
28.innodb_fill_factor. 30
29.日志相关参数... 30
29.1 innodb_log_file_size. 30
29.2 innodb_log_buffer_size. 30
29.3 innodb_log_fles_in_group. 30
30.Innodb_fast_shutdown. 31
31.innodb_flush_neighbors. 31
评论