雑だけど5.5～5.7の秘伝のタレ差分

55_vs_56.diff

1c1
< ### template_55.my.cnf revision 20150121
---
> ### template_56.my.cnf revision 20150319
4c4
< socket= __datadir__/mysql.sock #<< /data/path_name
---
> socket= __datadir__/mysql.sock #<<
11a12
> #malloc-lib= /usr/lib64/libjemalloc.so.1
23c24
< performance-schema= 0
---
> performance-schema= 1
24a26
> explicit_defaults_for_timestamp = ON
34d35
< #ft_min_word_len= 1
41c42
< server-id= __server_id_auto__ #<< (IPアドレスの第3オクテット * 256 + 第4オクテット)
---
> server-id= __server_id_auto__ #<< (IPアドレスの第3オクテット * 256 + 第4オクテット)
50a52
> table_open_cache_instances= 8
73c75
< max_binlog_size= 256M
---
> max_binlog_size= 256M
76a79,80
> binlog_rows_query_log_events
> binlog_row_image= minimal
88a93
> relay-log-info-repository= TABLE
108a114
> innodb_monitor_enable= all
113a120,121
> innodb-sort-buffer-size= 64M
> #innodb_lru_scan_depth= 1024
114a123
> innodb_checksum_algorithm= crc32
120c129,130
< #innodb_io_capacity= 40000
---
> innodb_io_capacity= 13000 #<<
> innodb_io_capacity_max= 20000 #<<
122a133,135
> innodb_flush_neighbors= 0       # For SSD.
> innodb_random_read_ahead= false # For SSD.
> innodb_read_ahead_threshold= 0  # For SSD.
124c137
< innodb_fast_shutdown= 1
---
> innodb_fast_shutdown= 1
126a140,142
> innodb-buffer-pool-dump-at-shutdown= 1
> innodb-buffer-pool-load-at-startup= 0
>

55_vs_57.diff

1c1
< ### template_55.my.cnf revision 20150121
---
> ### template_57.my.cnf revision 20160825
4c4
< socket= __datadir__/mysql.sock #<< /data/path_name
---
> socket= __datadir__/mysql.sock #<<
11a12
> #malloc-lib= /usr/lib64/libjemalloc.so.1
18a20
> log_timestamps= SYSTEM
22,23d23
< #old-password
< performance-schema= 0
24a25,48
> secure-file-priv= /data/tmp
> default-password-lifetime= 0
> #show_compatibility_56= 1
>
> ### avoid "autosized"(-1) default value
> performance-schema= 1
> performance_schema_accounts_size= 100
> performance_schema_hosts_size= 100
> performance_schema_max_cond_instances= 3000
> performance_schema_max_file_instances= 8000
> performance_schema_max_index_stat= 1000
> performance_schema_max_metadata_locks= 1000
> performance_schema_max_mutex_instances = 8000
> performance_schema_max_prepared_statements_instances= 1000
> performance_schema_max_program_instances= 1000
> performance_schema_max_rwlock_instances= 8000
> performance_schema_max_socket_instances= 500
> performance_schema_max_table_handles= 4000
> performance_schema_max_table_instances= 8000
> performance_schema_max_table_lock_stat= 8000
> performance_schema_max_thread_instances= 500
> performance_schema_setup_actors_size= 100
> performance_schema_setup_objects_size= 100
> performance_schema_users_size= 100
26c50
< #sql_mode=
---
> #sql_mode= NO_ENGINE_SUBSTITUTION ### 5.6 compatibility
34d57
< #ft_min_word_len= 1
41c64
< server-id= __server_id_auto__ #<< (IPアドレスの第3オクテット * 256 + 第4オクテット)
---
> server-id= __server_id_auto__ #<< (IPアドレスの第3オクテット * 256 + 第4オクテット)
47a71,72
> gtid_mode= ON
> enforce_gtid_consistency= ON
50a76
> table_open_cache_instances= 8
55d80
< #log-warnings= 2
59,60c84,85
< #log_slow_slave_statements= 1
< #log-queries-not-using-indexes
---
> log-queries-not-using-indexes =0
> min_examined_row_limit= 0
71c96
< #sync_binlog= 1
---
> sync_binlog= 1
73c98
< max_binlog_size= 256M
---
> max_binlog_size= 256M
76a102,112
> slave_parallel_type= LOGICAL_CLOCK
> binlog_rows_query_log_events
> binlog_row_image= minimal
>
> ### Semisync and offline configuration for mikasafabric
> #loose-rpl_semi_sync_master_enabled= 1
> #loose-rpl_semi_sync_master_timeout= 1000
> #loose-rpl_semi_sync_master_wait_no_slave = OFF
> #loose-rpl_semi_sync_master_wait_for_slave_count= 1
> #offline_mode
> #read_only = 0
78a115
> #super_read_only
88a126
> relay-log-info-repository= TABLE
100c138
< key_buffer_size= 128M
---
> key_buffer_size= 64M
104,108c142,145
< innodb_file_per_table
< innodb_file_format= barracuda
< innodb_large_prefix
< innodb_strict_mode= 1
< innodb_stats_on_metadata= 0
---
> #innodb_temp_data_file_path= ibtmp1:512M
> internal_tmp_disk_storage_engine= MyISAM
> #default_tmp_storage_engine= MyISAM
> innodb_undo_tablespaces= 2
109a147
> #innodb_numa_interleave= ON
113a152,153
> innodb-sort-buffer-size= 64M
> #innodb_lru_scan_depth= 1024
114a155,156
> innodb_checksum_algorithm= crc32
> innodb_autoinc_lock_mode= 1
120a163
> #innodb_io_capacity_max= 40000
122a166,168
> innodb_flush_neighbors= 0       # For SSD.
> innodb_random_read_ahead= false # For SSD.
> innodb_read_ahead_threshold= 0  # For SSD.
124c170
< innodb_fast_shutdown= 1
---
> innodb_fast_shutdown= 1
126a173,183
> innodb-buffer-pool-dump-pct= 100
> innodb-buffer-pool-dump-at-shutdown= 1
> innodb-buffer-pool-load-at-startup= 0
> innodb_monitor_enable= all
>
> ### Configuration for InnoDB FTS
> #loose-mecab-rc-file= /etc/mecabrc
> innodb_ft_min_token_size= 1
> innodb_ft_total_cache_size= 100M
> innodb_ft_result_cache_limit= 100M
>
140a198
> syslog

56_vs_57.diff

1c1
< ### template_56.my.cnf revision 20150319
---
> ### template_57.my.cnf revision 20160825
19a20
> log_timestamps= SYSTEM
23,24d23
< #old-password
< performance-schema= 1
26c25,48
< explicit_defaults_for_timestamp = ON
---
> secure-file-priv= /data/tmp
> default-password-lifetime= 0
> #show_compatibility_56= 1
>
> ### avoid "autosized"(-1) default value
> performance-schema= 1
> performance_schema_accounts_size= 100
> performance_schema_hosts_size= 100
> performance_schema_max_cond_instances= 3000
> performance_schema_max_file_instances= 8000
> performance_schema_max_index_stat= 1000
> performance_schema_max_metadata_locks= 1000
> performance_schema_max_mutex_instances = 8000
> performance_schema_max_prepared_statements_instances= 1000
> performance_schema_max_program_instances= 1000
> performance_schema_max_rwlock_instances= 8000
> performance_schema_max_socket_instances= 500
> performance_schema_max_table_handles= 4000
> performance_schema_max_table_instances= 8000
> performance_schema_max_table_lock_stat= 8000
> performance_schema_max_thread_instances= 500
> performance_schema_setup_actors_size= 100
> performance_schema_setup_objects_size= 100
> performance_schema_users_size= 100
28c50
< #sql_mode=
---
> #sql_mode= NO_ENGINE_SUBSTITUTION ### 5.6 compatibility
48a71,72
> gtid_mode= ON
> enforce_gtid_consistency= ON
57d80
< #log-warnings= 2
61,62c84,85
< #log_slow_slave_statements= 1
< #log-queries-not-using-indexes
---
> log-queries-not-using-indexes =0
> min_examined_row_limit= 0
73c96
< #sync_binlog= 1
---
> sync_binlog= 1
78a102
> slave_parallel_type= LOGICAL_CLOCK
81a106,113
> ### Semisync and offline configuration for mikasafabric
> #loose-rpl_semi_sync_master_enabled= 1
> #loose-rpl_semi_sync_master_timeout= 1000
> #loose-rpl_semi_sync_master_wait_no_slave = OFF
> #loose-rpl_semi_sync_master_wait_for_slave_count= 1
> #offline_mode
> #read_only = 0
>
82a115
> #super_read_only
105c138
< key_buffer_size= 128M
---
> key_buffer_size= 64M
109,114c142,145
< innodb_file_per_table
< innodb_file_format= barracuda
< innodb_large_prefix
< innodb_strict_mode= 1
< innodb_stats_on_metadata= 0
< innodb_monitor_enable= all
---
> #innodb_temp_data_file_path= ibtmp1:512M
> internal_tmp_disk_storage_engine= MyISAM
> #default_tmp_storage_engine= MyISAM
> innodb_undo_tablespaces= 2
115a147
> #innodb_numa_interleave= ON
123a156
> innodb_autoinc_lock_mode= 1
129,130c162,163
< innodb_io_capacity= 13000 #<<
< innodb_io_capacity_max= 20000 #<<
---
> #innodb_io_capacity= 40000
> #innodb_io_capacity_max= 40000
139a173
> innodb-buffer-pool-dump-pct= 100
141a176,182
> innodb_monitor_enable= all
>
> ### Configuration for InnoDB FTS
> #loose-mecab-rc-file= /etc/mecabrc
> innodb_ft_min_token_size= 1
> innodb_ft_total_cache_size= 100M
> innodb_ft_result_cache_limit= 100M
156a198
> syslog