23天学完mysql系统变量（九）

字母I开头的，基本都是关于InnoDB的，有点多（64个），慢慢来。

1.ignore_builtin_innodb

2.init_connect

3.init_file

4.init_slave

5.innodb_adaptive_flushing

6.innodb_adaptive_hash_index

7.innodb_additional_mem_pool_size

8.innodb_autoextend_increment

9.innodb_autoinc_lock_mode

10.innodb_buffer_pool_instances

11.innodb_buffer_pool_size

12.innodb_change_buffering

13.innodb_checksums

14.innodb_commit_concurrency

15.innodb_concurrency_tickets

16.innodb_data_file_path

17.innodb_data_home_dir

18.innodb_doublewrite

19.innodb_fast_shutdown

20.innodb_file_format

21.innodb_file_format_check

22.innodb_file_format_max

23.innodb_file_per_table

24.innodb_flush_log_at_trx_commit

25.innodb_flush_method

26.innodb_force_load_corrupted

27.innodb_force_recovery

28.innodb_io_capacity

29.innodb_large_prefix

30.innodb_lock_wait_timeout

31.innodb_locks_unsafe_for_binlog

32.innodb_log_buffer_size

33.innodb_log_file_size

34.innodb_log_files_in_group

35.innodb_log_group_home_dir

36.innodb_max_dirty_pages_pct 

37.innodb_max_purge_lag

38.innodb_mirrored_log_groups

39.innodb_old_blocks_pct

40.innodb_old_blocks_time

41.innodb_open_files

42.innodb_purge_batch_size

43.innodb_purge_threads

44.innodb_random_read_ahead

45.innodb_read_ahead_threshold

46.innodb_read_io_threads

47.innodb_replication_delay

48.innodb_rollback_on_timeout

49.innodb_rollback_segments

50.innodb_spin_wait_delay

51.innodb_stats_method

52.innodb_stats_on_metadata

53.innodb_stats_sample_pages

54.innodb_strict_mode

55.innodb_support_xa

56.innodb_sync_spin_loops

57.innodb_table_locks

58.innodb_thread_concurrency

59.innodb_thread_sleep_delay

60.innodb_use_native_aio

61.innodb_use_sys_malloc

62.innodb_version

63.innodb_write_io_threads

64.interactive_timeout