different from default different from t1.micro different from t1.micro     different from default different from t1.micro different from t1.micro  
          different from 5.5.31 different from 5.5.31     different from 5.5.31
No. Variable_name 5.5.31 default 5.5.31 t1.micro 5.5.31 t1.small 5.5.31 t1.micro slave modifiable 5.6.12 default 5.6.12 t1.micro 5.6.12 t1.small 5.6.12 t1.micro slave modifiable
1 auto_increment_increment 1 1 1 1 TRUE 1 1 1 1 TRUE
2 auto_increment_offset 1 1 1 1 TRUE 1 1 1 1 TRUE
3 autocommit ON ON ON ON TRUE ON ON ON ON TRUE
4 automatic_sp_privileges ON ON ON ON TRUE ON ON ON ON TRUE
5 back_log 50 50 50 50 TRUE 80 56 74 56 TRUE
6 basedir /usr /rdsdbbin/mysql/ /rdsdbbin/mysql/ /rdsdbbin/mysql/ FALSE /usr /rdsdbbin/mysql/ /rdsdbbin/mysql/ /rdsdbbin/mysql/ FALSE
7 big_tables OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
8 bind_address (N/A) (N/A) (N/A) (N/A) (N/A) * * * * (N/A)
9 binlog_cache_size 32768 32768 32768 32768 TRUE 32768 32768 32768 32768 TRUE
10 binlog_checksum (N/A) (N/A) (N/A) (N/A) (N/A) CRC32 CRC32 CRC32 CRC32 TRUE
11 binlog_direct_non_transactional_updates OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
12 binlog_format STATEMENT MIXED MIXED STATEMENT FALSE STATEMENT MIXED MIXED STATEMENT FALSE
13 binlog_max_flush_queue_time (N/A) (N/A) (N/A) (N/A) (N/A) 0 0 0 0 TRUE
14 binlog_order_commits (N/A) (N/A) (N/A) (N/A) (N/A) ON ON ON ON TRUE
15 binlog_row_image (N/A) (N/A) (N/A) (N/A) (N/A) FULL FULL FULL FULL FALSE
16 binlog_rows_query_log_events (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF FALSE
17 binlog_stmt_cache_size 32768 32768 32768 32768 (N/A) 32768 32768 32768 32768 TRUE
18 bulk_insert_buffer_size 8388608 8388608 8388608 8388608 TRUE 8388608 8388608 8388608 8388608 TRUE
19 character_set_client latin1 latin1 latin1 latin1 TRUE latin1 latin1 latin1 latin1 TRUE
20 character_set_connection latin1 latin1 latin1 latin1 TRUE latin1 latin1 latin1 latin1 TRUE
21 character_set_database latin1 latin1 latin1 latin1 TRUE latin1 latin1 latin1 latin1 TRUE
22 character_set_filesystem binary binary binary binary TRUE binary binary binary binary TRUE
23 character_set_results latin1 latin1 latin1 latin1 TRUE latin1 latin1 latin1 latin1 TRUE
24 character_set_server latin1 latin1 latin1 latin1 TRUE latin1 latin1 latin1 latin1 TRUE
25 character_set_system utf8 utf8 utf8 utf8 (N/A) utf8 utf8 utf8 utf8 (N/A)
26 character_sets_dir /usr/share/mysql/charsets/ /rdsdbbin/mysql-5.5.31.R1/share/charsets/ /rdsdbbin/mysql-5.5.31.R1/share/charsets/ /rdsdbbin/mysql-5.5.31.R1/share/charsets/ (N/A) /usr/share/mysql/charsets/ /rdsdbbin/mysql-5.6.12.R1/share/charsets/ /rdsdbbin/mysql-5.6.12.R1/share/charsets/ /rdsdbbin/mysql-5.6.12.R1/share/charsets/ (N/A)
27 collation_connection latin1_swedish_ci latin1_swedish_ci latin1_swedish_ci latin1_swedish_ci TRUE latin1_swedish_ci latin1_swedish_ci latin1_swedish_ci latin1_swedish_ci TRUE
28 collation_database latin1_swedish_ci latin1_swedish_ci latin1_swedish_ci latin1_swedish_ci (N/A) latin1_swedish_ci latin1_swedish_ci latin1_swedish_ci latin1_swedish_ci (N/A)
29 collation_server latin1_swedish_ci latin1_swedish_ci latin1_swedish_ci latin1_swedish_ci TRUE latin1_swedish_ci latin1_swedish_ci latin1_swedish_ci latin1_swedish_ci TRUE
30 completion_type NO_CHAIN NO_CHAIN NO_CHAIN NO_CHAIN TRUE NO_CHAIN NO_CHAIN NO_CHAIN NO_CHAIN TRUE
31 concurrent_insert AUTO AUTO AUTO AUTO TRUE AUTO AUTO AUTO AUTO TRUE
32 connect_timeout 10 10 10 10 TRUE 10 10 10 10 TRUE
33 core_file (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF FALSE
34 datadir /var/lib/mysql/ /rdsdbdata/db/ /rdsdbdata/db/ /rdsdbdata/db/ FALSE /var/lib/mysql/ /rdsdbdata/db/ /rdsdbdata/db/ /rdsdbdata/db/ FALSE
35 date_format %Y-%m-%d %Y-%m-%d %Y-%m-%d %Y-%m-%d (N/A) %Y-%m-%d %Y-%m-%d %Y-%m-%d %Y-%m-%d (N/A)
36 datetime_format %Y-%m-%d %H:%i:%s %Y-%m-%d %H:%i:%s %Y-%m-%d %H:%i:%s %Y-%m-%d %H:%i:%s (N/A) %Y-%m-%d %H:%i:%s %Y-%m-%d %H:%i:%s %Y-%m-%d %H:%i:%s %Y-%m-%d %H:%i:%s (N/A)
37 default_storage_engine InnoDB InnoDB InnoDB InnoDB FALSE InnoDB InnoDB InnoDB InnoDB FALSE
38 default_tmp_storage_engine (N/A) (N/A) (N/A) (N/A) (N/A) InnoDB InnoDB InnoDB InnoDB FALSE
39 default_week_format 0 0 0 0 TRUE 0 0 0 0 TRUE
40 delay_key_write ON ON ON ON TRUE ON ON ON ON TRUE
41 delayed_insert_limit 100 100 100 100 TRUE 100 100 100 100 TRUE
42 delayed_insert_timeout 300 300 300 300 TRUE 300 300 300 300 TRUE
43 delayed_queue_size 1000 1000 1000 1000 TRUE 1000 1000 1000 1000 TRUE
44 disconnect_on_expired_password (N/A) (N/A) (N/A) (N/A) (N/A) ON ON ON ON (N/A)
45 div_precision_increment 4 4 4 4 TRUE 4 4 4 4 TRUE
46 end_markers_in_json (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF TRUE
47 enforce_gtid_consistency (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF TRUE
48 engine_condition_pushdown ON ON ON ON (N/A) (N/A) (N/A) (N/A) (N/A) (N/A)
49 eq_range_index_dive_limit (N/A) (N/A) (N/A) (N/A) (N/A) 10 10 10 10 TRUE
50 event_scheduler OFF OFF OFF OFF TRUE OFF OFF OFF OFF TRUE
51 expire_logs_days 0 0 0 0 (N/A) 0 0 0 0 (N/A)
52 explicit_defaults_for_timestamp (N/A) (N/A) (N/A) (N/A) (N/A) OFF ON ON ON FALSE
53 flush OFF OFF OFF OFF FALSE OFF OFF OFF OFF FALSE
54 flush_time 0 0 0 0 TRUE 0 0 0 0 TRUE
55 foreign_key_checks ON ON ON ON (N/A) ON ON ON ON (N/A)
56 ft_boolean_syntax + -><()~*:""&| + -><()~*:""&| + -><()~*:""&| + -><()~*:""&| FALSE + -><()~*:""&| + -><()~*:""&| + -><()~*:""&| + -><()~*:""&| FALSE
57 ft_max_word_len 84 84 84 84 TRUE 84 84 84 84 TRUE
58 ft_min_word_len 4 4 4 4 TRUE 4 4 4 4 TRUE
59 ft_query_expansion_limit 20 20 20 20 TRUE 20 20 20 20 TRUE
60 ft_stopword_file (built-in) (built-in) (built-in) (built-in) TRUE (built-in) (built-in) (built-in) (built-in) TRUE
61 general_log OFF OFF OFF OFF TRUE OFF OFF OFF OFF TRUE
62 general_log_file /var/lib/mysql/k09sl6.log /rdsdbdata/log/general/mysql-general.log /rdsdbdata/log/general/mysql-general.log /rdsdbdata/log/general/mysql-general.log FALSE /var/lib/mysql/k01sl6.log /rdsdbdata/log/general/mysql-general.log /rdsdbdata/log/general/mysql-general.log /rdsdbdata/log/general/mysql-general.log FALSE
63 group_concat_max_len 1024 1024 1024 1024 TRUE 1024 1024 1024 1024 TRUE
64 gtid_executed (N/A) (N/A) (N/A) (N/A) (N/A)         (N/A)
65 gtid_mode (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF TRUE
66 gtid_owned (N/A) (N/A) (N/A) (N/A) (N/A)         (N/A)
67 gtid_purged (N/A) (N/A) (N/A) (N/A) (N/A)         (N/A)
68 have_compress YES YES YES YES (N/A) YES YES YES YES (N/A)
69 have_crypt YES YES YES YES (N/A) YES YES YES YES (N/A)
70 have_csv YES YES YES YES (N/A) (N/A) (N/A) (N/A) (N/A) (N/A)
71 have_dynamic_loading YES YES YES YES (N/A) YES YES YES YES (N/A)
72 have_geometry YES YES YES YES (N/A) YES YES YES YES (N/A)
73 have_innodb YES YES YES YES (N/A) (N/A) (N/A) (N/A) (N/A) (N/A)
74 have_ndbcluster NO NO NO NO (N/A) (N/A) (N/A) (N/A) (N/A) (N/A)
75 have_openssl DISABLED YES YES YES (N/A) DISABLED YES YES YES (N/A)
76 have_partitioning YES YES YES YES (N/A) (N/A) (N/A) (N/A) (N/A) (N/A)
77 have_profiling YES YES YES YES (N/A) YES YES YES YES (N/A)
78 have_query_cache YES YES YES YES (N/A) YES YES YES YES (N/A)
79 have_rtree_keys YES YES YES YES (N/A) YES YES YES YES (N/A)
80 have_ssl DISABLED YES YES YES (N/A) DISABLED YES YES YES (N/A)
81 have_symlink YES YES YES YES (N/A) YES YES YES YES (N/A)
82 host_cache_size (N/A) (N/A) (N/A) (N/A) (N/A) 279 160 249 160 TRUE
83 hostname k09sl6 ip-10-120-73-153 ip-10-160-95-215 ip-10-120-61-247 (N/A) k01sl6 ip-10-122-42-105 ip-10-152-174-240 ip-10-122-25-183 (N/A)
84 ignore_builtin_innodb OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
85 ignore_db_dirs (N/A) (N/A) (N/A) (N/A) (N/A)         (N/A)
86 init_connect         TRUE         TRUE
87 init_file         (N/A)         (N/A)
88 init_slave         (N/A)         (N/A)
89 innodb_adaptive_flushing ON ON ON ON TRUE ON ON ON ON TRUE
90 innodb_adaptive_flushing_lwm (N/A) (N/A) (N/A) (N/A) (N/A) 10 10 10 10 TRUE
91 innodb_adaptive_hash_index ON ON ON ON TRUE ON ON ON ON TRUE
92 innodb_adaptive_max_sleep_delay (N/A) (N/A) (N/A) (N/A) (N/A) 150000 150000 150000 150000 TRUE
93 innodb_additional_mem_pool_size 8388608 2097152 2097152 2097152 TRUE 8388608 8388608 8388608 8388608 (N/A)
94 innodb_api_bk_commit_interval (N/A) (N/A) (N/A) (N/A) (N/A) 5 5 5 5 (N/A)
95 innodb_api_disable_rowlock (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF (N/A)
96 innodb_api_enable_binlog (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF (N/A)
97 innodb_api_enable_mdl (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF (N/A)
98 innodb_api_trx_level (N/A) (N/A) (N/A) (N/A) (N/A) 0 0 0 0 (N/A)
99 innodb_autoextend_increment 8 8 8 8 TRUE 64 64 64 64 TRUE
100 innodb_autoinc_lock_mode 1 1 1 1 TRUE 1 1 1 1 TRUE
101 innodb_buffer_pool_dump_at_shutdown (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF TRUE
102 innodb_buffer_pool_dump_now (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF TRUE
103 innodb_buffer_pool_filename (N/A) (N/A) (N/A) (N/A) (N/A) ib_buffer_pool ib_buffer_pool ib_buffer_pool ib_buffer_pool FALSE
104 innodb_buffer_pool_instances 1 1 1 1 TRUE 8 8 8 8 TRUE
105 innodb_buffer_pool_load_abort (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF TRUE
106 innodb_buffer_pool_load_at_startup (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF TRUE
107 innodb_buffer_pool_load_now (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF TRUE
108 innodb_buffer_pool_size 134217728 326107136 1179648000 326107136 TRUE 134217728 309329920 1145044992 309329920 TRUE
109 innodb_change_buffer_max_size (N/A) (N/A) (N/A) (N/A) (N/A) 25 25 25 25 TRUE
110 innodb_change_buffering all all all all TRUE all all all all TRUE
111 innodb_checksum_algorithm (N/A) (N/A) (N/A) (N/A) (N/A) innodb innodb innodb innodb FALSE
112 innodb_checksums ON ON ON ON (N/A) ON ON ON ON (N/A)
113 innodb_cmp_per_index_enabled (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF TRUE
114 innodb_commit_concurrency 0 0 0 0 TRUE 0 0 0 0 TRUE
115 innodb_compression_failure_threshold_pct (N/A) (N/A) (N/A) (N/A) (N/A) 5 5 5 5 TRUE
116 innodb_compression_level (N/A) (N/A) (N/A) (N/A) (N/A) 6 6 6 6 TRUE
117 innodb_compression_pad_pct_max (N/A) (N/A) (N/A) (N/A) (N/A) 50 50 50 50 TRUE
118 innodb_concurrency_tickets 500 500 500 500 TRUE 5000 5000 5000 5000 TRUE
119 innodb_data_file_path ibdata1:10M:autoextend ibdata1:10M:autoextend ibdata1:10M:autoextend ibdata1:10M:autoextend (N/A) ibdata1:12M:autoextend ibdata1:12M:autoextend ibdata1:12M:autoextend ibdata1:12M:autoextend (N/A)
120 innodb_data_home_dir   /rdsdbdata/db/innodb /rdsdbdata/db/innodb /rdsdbdata/db/innodb FALSE   /rdsdbdata/db/innodb /rdsdbdata/db/innodb /rdsdbdata/db/innodb FALSE
121 innodb_disable_sort_file_cache (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF (N/A)
122 innodb_doublewrite ON ON ON ON (N/A) ON ON ON ON (N/A)
123 innodb_fast_shutdown 1 1 1 1 (N/A) 1 1 1 1 (N/A)
124 innodb_file_format Antelope Antelope Antelope Antelope TRUE Antelope Antelope Antelope Antelope TRUE
125 innodb_file_format_check ON ON ON ON (N/A) ON ON ON ON (N/A)
126 innodb_file_format_max Antelope Antelope Antelope Antelope (N/A) Antelope Antelope Antelope Antelope (N/A)
127 innodb_file_per_table OFF ON ON ON TRUE ON ON ON ON TRUE
128 innodb_flush_log_at_timeout (N/A) (N/A) (N/A) (N/A) (N/A) 1 1 1 1 FALSE
129 innodb_flush_log_at_trx_commit 1 1 1 1 TRUE 1 1 1 1 TRUE
130 innodb_flush_method   O_DIRECT O_DIRECT O_DIRECT FALSE         FALSE
131 innodb_flush_neighbors (N/A) (N/A) (N/A) (N/A) (N/A) 1 1 1 1 FALSE
132 innodb_flushing_avg_loops (N/A) (N/A) (N/A) (N/A) (N/A) 30 30 30 30 FALSE
133 innodb_force_load_corrupted OFF OFF OFF OFF FALSE OFF OFF OFF OFF FALSE
134 innodb_force_recovery 0 0 0 0 (N/A) 0 0 0 0 (N/A)
135 innodb_ft_aux_table (N/A) (N/A) (N/A) (N/A) (N/A)         TRUE
136 innodb_ft_cache_size (N/A) (N/A) (N/A) (N/A) (N/A) 8000000 8000000 8000000 8000000 TRUE
137 innodb_ft_enable_diag_print (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF (N/A)
138 innodb_ft_enable_stopword (N/A) (N/A) (N/A) (N/A) (N/A) ON ON ON ON TRUE
139 innodb_ft_max_token_size (N/A) (N/A) (N/A) (N/A) (N/A) 84 84 84 84 TRUE
140 innodb_ft_min_token_size (N/A) (N/A) (N/A) (N/A) (N/A) 3 3 3 3 TRUE
141 innodb_ft_num_word_optimize (N/A) (N/A) (N/A) (N/A) (N/A) 2000 2000 2000 2000 TRUE
142 innodb_ft_server_stopword_table (N/A) (N/A) (N/A) (N/A) (N/A)         TRUE
143 innodb_ft_sort_pll_degree (N/A) (N/A) (N/A) (N/A) (N/A) 2 2 2 2 TRUE
144 innodb_ft_user_stopword_table (N/A) (N/A) (N/A) (N/A) (N/A)         TRUE
145 innodb_io_capacity 200 200 200 200 TRUE 200 200 200 200 TRUE
146 innodb_io_capacity_max (N/A) (N/A) (N/A) (N/A) (N/A) 2000 2000 2000 2000 TRUE
147 innodb_large_prefix OFF OFF OFF OFF TRUE OFF OFF OFF OFF TRUE
148 innodb_lock_wait_timeout 50 50 50 50 TRUE 50 50 50 50 TRUE
149 innodb_locks_unsafe_for_binlog OFF OFF OFF OFF FALSE OFF OFF OFF OFF (N/A)
150 innodb_log_buffer_size 8388608 8388608 8388608 8388608 TRUE 8388608 8388608 8388608 8388608 TRUE
151 innodb_log_compressed_pages (N/A) (N/A) (N/A) (N/A) (N/A) ON ON ON ON TRUE
152 innodb_log_file_size 5242880 134217728 134217728 134217728 FALSE 50331648 134217728 134217728 134217728 FALSE
153 innodb_log_files_in_group 2 2 2 2 (N/A) 2 2 2 2 (N/A)
154 innodb_log_group_home_dir ./ /rdsdbdata/log/innodb /rdsdbdata/log/innodb /rdsdbdata/log/innodb FALSE ./ /rdsdbdata/log/innodb /rdsdbdata/log/innodb /rdsdbdata/log/innodb FALSE
155 innodb_lru_scan_depth (N/A) (N/A) (N/A) (N/A) (N/A) 1024 1024 1024 1024 TRUE
156 innodb_max_dirty_pages_pct 75 75 75 75 TRUE 75 75 75 75 TRUE
157 innodb_max_dirty_pages_pct_lwm (N/A) (N/A) (N/A) (N/A) (N/A) 0 0 0 0 (N/A)
158 innodb_max_purge_lag 0 0 0 0 TRUE 0 0 0 0 TRUE
159 innodb_max_purge_lag_delay (N/A) (N/A) (N/A) (N/A) (N/A) 0 0 0 0 TRUE
160 innodb_mirrored_log_groups 1 1 1 1 (N/A) 1 1 1 1 (N/A)
161 innodb_monitor_disable (N/A) (N/A) (N/A) (N/A) (N/A)         TRUE
162 innodb_monitor_enable (N/A) (N/A) (N/A) (N/A) (N/A)         TRUE
163 innodb_monitor_reset (N/A) (N/A) (N/A) (N/A) (N/A)         TRUE
164 innodb_monitor_reset_all (N/A) (N/A) (N/A) (N/A) (N/A)         TRUE
165 innodb_old_blocks_pct 37 37 37 37 TRUE 37 37 37 37 TRUE
166 innodb_old_blocks_time 0 0 0 0 TRUE 1000 1000 1000 1000 TRUE
167 innodb_online_alter_log_max_size (N/A) (N/A) (N/A) (N/A) (N/A) 134217728 134217728 134217728 134217728 TRUE
168 innodb_open_files 300 300 300 300 TRUE 2000 2000 2000 2000 TRUE
169 innodb_optimize_fulltext_only (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF FALSE
170 innodb_page_size (N/A) (N/A) (N/A) (N/A) (N/A) 16384 16384 16384 16384 FALSE
171 innodb_print_all_deadlocks OFF OFF OFF OFF (N/A) OFF OFF OFF OFF FALSE
172 innodb_purge_batch_size 20 20 20 20 TRUE 300 300 300 300 TRUE
173 innodb_purge_threads 0 0 0 0 TRUE 1 1 1 1 TRUE
174 innodb_random_read_ahead OFF OFF OFF OFF TRUE OFF OFF OFF OFF TRUE
175 innodb_read_ahead_threshold 56 56 56 56 TRUE 56 56 56 56 TRUE
176 innodb_read_io_threads 4 4 4 4 TRUE 4 4 4 4 TRUE
177 innodb_read_only (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF FALSE
178 innodb_replication_delay 0 0 0 0 TRUE 0 0 0 0 TRUE
179 innodb_rollback_on_timeout OFF OFF OFF OFF TRUE OFF OFF OFF OFF TRUE
180 innodb_rollback_segments 128 128 128 128 (N/A) 128 128 128 128 TRUE
181 innodb_sort_buffer_size (N/A) (N/A) (N/A) (N/A) (N/A) 1048576 1048576 1048576 1048576 TRUE
182 innodb_spin_wait_delay 6 6 6 6 TRUE 6 6 6 6 TRUE
183 innodb_stats_auto_recalc (N/A) (N/A) (N/A) (N/A) (N/A) ON ON ON ON FALSE
184 innodb_stats_method nulls_equal nulls_equal nulls_equal nulls_equal (N/A) nulls_equal nulls_equal nulls_equal nulls_equal TRUE
185 innodb_stats_on_metadata ON ON ON ON TRUE OFF OFF OFF OFF TRUE
186 innodb_stats_persistent (N/A) (N/A) (N/A) (N/A) (N/A) ON ON ON ON FALSE
187 innodb_stats_persistent_sample_pages (N/A) (N/A) (N/A) (N/A) (N/A) 20 20 20 20 TRUE
188 innodb_stats_sample_pages 8 8 8 8 TRUE 8 8 8 8 (N/A)
189 innodb_stats_transient_sample_pages (N/A) (N/A) (N/A) (N/A) (N/A) 8 8 8 8 TRUE
190 innodb_strict_mode OFF OFF OFF OFF TRUE OFF OFF OFF OFF TRUE
191 innodb_support_xa ON ON ON ON TRUE ON ON ON ON FALSE
192 innodb_sync_array_size (N/A) (N/A) (N/A) (N/A) (N/A) 1 1 1 1 TRUE
193 innodb_sync_spin_loops 30 30 30 30 TRUE 30 30 30 30 TRUE
194 innodb_table_locks ON ON ON ON TRUE ON ON ON ON TRUE
195 innodb_thread_concurrency 0 0 0 0 TRUE 0 0 0 0 TRUE
196 innodb_thread_sleep_delay 10000 10000 10000 10000 TRUE 10000 10000 10000 10000 TRUE
197 innodb_undo_directory (N/A) (N/A) (N/A) (N/A) (N/A) . . . . FALSE
198 innodb_undo_logs (N/A) (N/A) (N/A) (N/A) (N/A) 128 128 128 128 TRUE
199 innodb_undo_tablespaces (N/A) (N/A) (N/A) (N/A) (N/A) 0 0 0 0 TRUE
200 innodb_use_native_aio ON ON ON ON TRUE ON ON ON ON TRUE
201 innodb_use_sys_malloc ON ON ON ON TRUE ON ON ON ON (N/A)
202 innodb_version 5.5.31 5.5.31 5.5.31 5.5.31 (N/A) 5.6.12 5.6.12 5.6.12 5.6.12 (N/A)
203 innodb_write_io_threads 4 4 4 4 TRUE 4 4 4 4 TRUE
204 interactive_timeout 28800 28800 28800 28800 TRUE 28800 28800 28800 28800 TRUE
205 join_buffer_size 131072 131072 131072 131072 TRUE 262144 262144 262144 262144 TRUE
206 keep_files_on_create OFF OFF OFF OFF TRUE OFF OFF OFF OFF TRUE
207 key_buffer_size 8388608 16777216 16777216 16777216 TRUE 8388608 16777216 16777216 16777216 TRUE
208 key_cache_age_threshold 300 300 300 300 TRUE 300 300 300 300 TRUE
209 key_cache_block_size 1024 1024 1024 1024 TRUE 1024 1024 1024 1024 TRUE
210 key_cache_division_limit 100 100 100 100 TRUE 100 100 100 100 TRUE
211 large_files_support ON ON ON ON (N/A) ON ON ON ON (N/A)
212 large_page_size 0 0 0 0 (N/A) 0 0 0 0 (N/A)
213 large_pages OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
214 lc_messages en_US en_US en_US en_US (N/A) en_US en_US en_US en_US (N/A)
215 lc_messages_dir /usr/share/mysql/ /rdsdbbin/mysql-5.5.31.R1/share/ /rdsdbbin/mysql-5.5.31.R1/share/ /rdsdbbin/mysql-5.5.31.R1/share/ (N/A) /usr/share/mysql/ /rdsdbbin/mysql-5.6.12.R1/share/ /rdsdbbin/mysql-5.6.12.R1/share/ /rdsdbbin/mysql-5.6.12.R1/share/ (N/A)
216 lc_time_names en_US en_US en_US en_US TRUE en_US en_US en_US en_US TRUE
217 license GPL GPL GPL GPL (N/A) GPL GPL GPL GPL (N/A)
218 local_infile ON ON ON ON TRUE ON ON ON ON TRUE
219 lock_wait_timeout 31536000 31536000 31536000 31536000 TRUE 31536000 31536000 31536000 31536000 TRUE
220 locked_in_memory OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
221 log OFF OFF OFF OFF (N/A) (N/A) (N/A) (N/A) (N/A) (N/A)
222 log_bin OFF ON ON OFF FALSE OFF ON ON OFF FALSE
223 log_bin_basename (N/A) (N/A) (N/A) (N/A) (N/A)   /rdsdbdata/log/binlog/mysql-bin-changelog /rdsdbdata/log/binlog/mysql-bin-changelog   (N/A)
224 log_bin_index (N/A) (N/A) (N/A) (N/A) (N/A)   /rdsdbdata/log/binlog/mysql-bin-changelog.index /rdsdbdata/log/binlog/mysql-bin-changelog.index   (N/A)
225 log_bin_trust_function_creators OFF OFF OFF OFF TRUE OFF OFF OFF OFF TRUE
226 log_bin_use_v1_row_events (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF (N/A)
227 log_error /var/lib/mysql/k09sl6.err /rdsdbdata/log/error/mysql-error.log /rdsdbdata/log/error/mysql-error.log /rdsdbdata/log/error/mysql-error.log FALSE /var/lib/mysql/k01sl6.err /rdsdbdata/log/error/mysql-error.log /rdsdbdata/log/error/mysql-error.log /rdsdbdata/log/error/mysql-error.log FALSE
228 log_output FILE TABLE TABLE TABLE TRUE FILE TABLE TABLE TABLE TRUE
229 log_queries_not_using_indexes OFF OFF OFF OFF TRUE OFF OFF OFF OFF TRUE
230 log_slave_updates OFF OFF OFF OFF TRUE OFF ON ON ON FALSE
231 log_slow_admin_statements (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF (N/A)
232 log_slow_queries OFF OFF OFF OFF (N/A) (N/A) (N/A) (N/A) (N/A) (N/A)
233 log_slow_slave_statements (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF (N/A)
234 log_throttle_queries_not_using_indexes (N/A) (N/A) (N/A) (N/A) (N/A) 0 0 0 0 TRUE
235 log_warnings 1 1 1 1 TRUE 1 1 1 1 TRUE
236 long_query_time 10 10 10 10 TRUE 10 10 10 10 TRUE
237 low_priority_updates OFF OFF OFF OFF TRUE OFF OFF OFF OFF TRUE
238 lower_case_file_system OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
239 lower_case_table_names 0 0 0 0 TRUE 0 0 0 0 TRUE
240 master_info_repository (N/A) (N/A) (N/A) (N/A) (N/A) FILE TABLE TABLE TABLE TRUE
241 master_verify_checksum (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF TRUE
242 max_allowed_packet 1048576 1048576 1048576 1073741824 TRUE 4194304 4194304 4194304 1073741824 TRUE
243 max_binlog_cache_size 1.84467E+19 1.84467E+19 1.84467E+19 1.84467E+19 TRUE 1.84467E+19 1.84467E+19 1.84467E+19 1.84467E+19 TRUE
244 max_binlog_size 1073741824 134217728 134217728 134217728 FALSE 1073741824 134217728 134217728 134217728 FALSE
245 max_binlog_stmt_cache_size 1.84467E+19 1.84467E+19 1.84467E+19 1.84467E+19 (N/A) 1.84467E+19 1.84467E+19 1.84467E+19 1.84467E+19 TRUE
246 max_connect_errors 10 10 10 10 TRUE 100 100 100 100 TRUE
247 max_connections 151 34 125 34 TRUE 151 32 121 32 TRUE
248 max_delayed_threads 20 20 20 20 TRUE 20 20 20 20 TRUE
249 max_error_count 64 64 64 64 TRUE 64 64 64 64 TRUE
250 max_heap_table_size 16777216 16777216 16777216 16777216 TRUE 16777216 16777216 16777216 16777216 TRUE
251 max_insert_delayed_threads 20 20 20 20 TRUE 20 20 20 20 TRUE
252 max_join_size 1.84467E+19 1.84467E+19 1.84467E+19 1.84467E+19 TRUE 1.84467E+19 1.84467E+19 1.84467E+19 1.84467E+19 TRUE
253 max_length_for_sort_data 1024 1024 1024 1024 TRUE 1024 1024 1024 1024 TRUE
254 max_long_data_size 1048576 1048576 1048576 1048576 (N/A) (N/A) (N/A) (N/A) (N/A) (N/A)
255 max_prepared_stmt_count 16382 16382 16382 16382 TRUE 16382 16382 16382 16382 TRUE
256 max_relay_log_size 0 0 0 0 (N/A) 0 0 0 0 (N/A)
257 max_seeks_for_key 1.84467E+19 1.84467E+19 1.84467E+19 1.84467E+19 TRUE 1.84467E+19 1.84467E+19 1.84467E+19 1.84467E+19 TRUE
258 max_sort_length 1024 1024 1024 1024 TRUE 1024 1024 1024 1024 TRUE
259 max_sp_recursion_depth 0 0 0 0 TRUE 0 0 0 0 TRUE
260 max_tmp_tables 32 32 32 32 TRUE 32 32 32 32 TRUE
261 max_user_connections 0 0 0 0 TRUE 0 0 0 0 TRUE
262 max_write_lock_count 1.84467E+19 1.84467E+19 1.84467E+19 1.84467E+19 TRUE 1.84467E+19 1.84467E+19 1.84467E+19 1.84467E+19 TRUE
263 metadata_locks_cache_size 1024 1024 1024 1024 TRUE 1024 1024 1024 1024 TRUE
264 metadata_locks_hash_instances (N/A) (N/A) (N/A) (N/A) (N/A) 8 8 8 8 (N/A)
265 min_examined_row_limit 0 0 0 0 TRUE 0 0 0 0 TRUE
266 multi_range_count 256 256 256 256 (N/A) 256 256 256 256 (N/A)
267 myisam_data_pointer_size 6 6 6 6 TRUE 6 6 6 6 TRUE
268 myisam_max_sort_file_size 9.22337E+18 9.22337E+18 9.22337E+18 9.22337E+18 TRUE 9.22337E+18 9.22337E+18 9.22337E+18 9.22337E+18 TRUE
269 myisam_mmap_size 1.84467E+19 1.84467E+19 1.84467E+19 1.84467E+19 TRUE 1.84467E+19 1.84467E+19 1.84467E+19 1.84467E+19 TRUE
270 myisam_recover_options OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
271 myisam_repair_threads 1 1 1 1 (N/A) 1 1 1 1 (N/A)
272 myisam_sort_buffer_size 8388608 8388608 8388608 8388608 TRUE 8388608 8388608 8388608 8388608 TRUE
273 myisam_stats_method nulls_unequal nulls_unequal nulls_unequal nulls_unequal TRUE nulls_unequal nulls_unequal nulls_unequal nulls_unequal TRUE
274 myisam_use_mmap OFF OFF OFF OFF TRUE OFF OFF OFF OFF TRUE
275 net_buffer_length 16384 16384 16384 16384 TRUE 16384 16384 16384 16384 TRUE
276 net_read_timeout 30 30 30 30 TRUE 30 30 30 30 TRUE
277 net_retry_count 10 10 10 10 TRUE 10 10 10 10 TRUE
278 net_write_timeout 60 60 60 60 TRUE 60 60 60 60 TRUE
279 new OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
280 old OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
281 old_alter_table OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
282 old_passwords OFF OFF OFF OFF TRUE 0 0 0 0 TRUE
283 open_files_limit 1024 65535 65535 65535 (N/A) 5000 5000 5000 5000 (N/A)
284 optimizer_prune_level 1 1 1 1 TRUE 1 1 1 1 TRUE
285 optimizer_search_depth 62 62 62 62 TRUE 62 62 62 62 TRUE
286 optimizer_switch index_merge=on,
index_merge_union=on,
index_merge_sort_union=on,
index_merge_intersection=on,
engine_condition_pushdown=on
index_merge=on,
index_merge_union=on,
index_merge_sort_union=on,
index_merge_intersection=on,
engine_condition_pushdown=on
index_merge=on,
index_merge_union=on,
index_merge_sort_union=on,
index_merge_intersection=on,
engine_condition_pushdown=on
index_merge=on,
index_merge_union=on,
index_merge_sort_union=on,
index_merge_intersection=on,
engine_condition_pushdown=on
TRUE index_merge=on,
index_merge_union=on,
index_merge_sort_union=on,
index_merge_intersection=on,
engine_condition_pushdown=on,
index_condition_pushdown=on,
mrr=on,
mrr_cost_based=on,
block_nested_loop=on,
batched_key_access=off,
materialization=on,
semijoin=on,
loosescan=on,
firstmatch=on,
subquery_materialization_cost_based=on,
use_index_extensions=on
index_merge=on,
index_merge_union=on,
index_merge_sort_union=on,
index_merge_intersection=on,
engine_condition_pushdown=on,
index_condition_pushdown=on,
mrr=on,
mrr_cost_based=on,
block_nested_loop=on,
batched_key_access=off,
materialization=on,
semijoin=on,
loosescan=on,
firstmatch=on,
subquery_materialization_cost_based=on,
use_index_extensions=on
index_merge=on,
index_merge_union=on,
index_merge_sort_union=on,
index_merge_intersection=on,
engine_condition_pushdown=on,
index_condition_pushdown=on,
mrr=on,
mrr_cost_based=on,
block_nested_loop=on,
batched_key_access=off,
materialization=on,
semijoin=on,
loosescan=on,
firstmatch=on,
subquery_materialization_cost_based=on,
use_index_extensions=on
index_merge=on,
index_merge_union=on,
index_merge_sort_union=on,
index_merge_intersection=on,
engine_condition_pushdown=on,
index_condition_pushdown=on,
mrr=on,
mrr_cost_based=on,
block_nested_loop=on,
batched_key_access=off,
materialization=on,
semijoin=on,
loosescan=on,
firstmatch=on,
subquery_materialization_cost_based=on,
use_index_extensions=on
TRUE
287 optimizer_trace (N/A) (N/A) (N/A) (N/A) (N/A) enabled=off,one_line=off enabled=off,one_line=off enabled=off,one_line=off enabled=off,one_line=off TRUE
288 optimizer_trace_features (N/A) (N/A) (N/A) (N/A) (N/A) greedy_search=on,
range_optimizer=on,
dynamic_range=on,
repeated_subselect=on
greedy_search=on,
range_optimizer=on,
dynamic_range=on,
repeated_subselect=on
greedy_search=on,
range_optimizer=on,
dynamic_range=on,
repeated_subselect=on
greedy_search=on,
range_optimizer=on,
dynamic_range=on,
repeated_subselect=on
TRUE
289 optimizer_trace_limit (N/A) (N/A) (N/A) (N/A) (N/A) 1 1 1 1 TRUE
290 optimizer_trace_max_mem_size (N/A) (N/A) (N/A) (N/A) (N/A) 16384 16384 16384 16384 TRUE
291 optimizer_trace_offset (N/A) (N/A) (N/A) (N/A) (N/A) -1 -1 -1 -1 TRUE
292 performance_schema OFF OFF OFF OFF TRUE ON ON ON ON TRUE
293 performance_schema_accounts_size (N/A) (N/A) (N/A) (N/A) (N/A) 100 100 100 100 (N/A)
294 performance_schema_digests_size (N/A) (N/A) (N/A) (N/A) (N/A) 10000 10000 10000 10000 (N/A)
295 performance_schema_events_stages_history_long_size (N/A) (N/A) (N/A) (N/A) (N/A) 10000 10000 10000 10000 (N/A)
296 performance_schema_events_stages_history_size (N/A) (N/A) (N/A) (N/A) (N/A) 10 10 10 10 (N/A)
297 performance_schema_events_statements_history_long_size (N/A) (N/A) (N/A) (N/A) (N/A) 10000 10000 10000 10000 (N/A)
298 performance_schema_events_statements_history_size (N/A) (N/A) (N/A) (N/A) (N/A) 10 10 10 10 (N/A)
299 performance_schema_events_waits_history_long_size 10000 10000 10000 10000 (N/A) 10000 10000 10000 10000 (N/A)
300 performance_schema_events_waits_history_size 10 10 10 10 (N/A) 10 10 10 10 (N/A)
301 performance_schema_hosts_size (N/A) (N/A) (N/A) (N/A) (N/A) 100 100 100 100 (N/A)
302 performance_schema_max_cond_classes 80 80 80 80 (N/A) 80 80 80 80 (N/A)
303 performance_schema_max_cond_instances 1000 1000 1000 1000 (N/A) 3504 3028 3384 3028 (N/A)
304 performance_schema_max_file_classes 50 50 50 50 (N/A) 50 50 50 50 (N/A)
305 performance_schema_max_file_handles 32768 32768 32768 32768 (N/A) 32768 32768 32768 32768 (N/A)
306 performance_schema_max_file_instances 10000 10000 10000 10000 (N/A) 7693 7693 7693 7693 (N/A)
307 performance_schema_max_mutex_classes 200 200 200 200 (N/A) 200 200 200 200 (N/A)
308 performance_schema_max_mutex_instances 1000000 1000000 1000000 1000000 (N/A) 15906 15192 15726 15192 (N/A)
309 performance_schema_max_rwlock_classes 30 30 30 30 (N/A) 30 30 30 30 (N/A)
310 performance_schema_max_rwlock_instances 1000000 1000000 1000000 1000000 (N/A) 9102 8864 9042 8864 (N/A)
311 performance_schema_max_socket_classes (N/A) (N/A) (N/A) (N/A) (N/A) 10 10 10 10 (N/A)
312 performance_schema_max_socket_instances (N/A) (N/A) (N/A) (N/A) (N/A) 322 84 262 84 (N/A)
313 performance_schema_max_stage_classes (N/A) (N/A) (N/A) (N/A) (N/A) 150 150 150 150 (N/A)
314 performance_schema_max_statement_classes (N/A) (N/A) (N/A) (N/A) (N/A) 167 167 167 167 (N/A)
315 performance_schema_max_table_handles 100000 100000 100000 100000 (N/A) 4000 4000 4000 4000 (N/A)
316 performance_schema_max_table_instances 50000 50000 50000 50000 (N/A) 12500 12500 12500 12500 (N/A)
317 performance_schema_max_thread_classes 50 50 50 50 (N/A) 50 50 50 50 (N/A)
318 performance_schema_max_thread_instances 1000 1000 1000 1000 (N/A) 402 164 342 164 (N/A)
319 performance_schema_session_connect_attrs_size (N/A) (N/A) (N/A) (N/A) (N/A) 512 512 512 512 (N/A)
320 performance_schema_setup_actors_size (N/A) (N/A) (N/A) (N/A) (N/A) 100 100 100 100 (N/A)
321 performance_schema_setup_objects_size (N/A) (N/A) (N/A) (N/A) (N/A) 100 100 100 100 (N/A)
322 performance_schema_users_size (N/A) (N/A) (N/A) (N/A) (N/A) 100 100 100 100 (N/A)
323 pid_file /var/lib/mysql/k09sl6.pid /rdsdbdata/log/mysql-3306.pid /rdsdbdata/log/mysql-3306.pid /rdsdbdata/log/mysql-3306.pid FALSE /var/lib/mysql/k01sl6.pid /rdsdbdata/log/mysql-3306.pid /rdsdbdata/log/mysql-3306.pid /rdsdbdata/log/mysql-3306.pid FALSE
324 plugin_dir /usr/lib64/mysql/plugin/ /rdsdbbin/mysql-5.5.31.R1/lib/plugin/ /rdsdbbin/mysql-5.5.31.R1/lib/plugin/ /rdsdbbin/mysql-5.5.31.R1/lib/plugin/ FALSE /usr/lib64/mysql/plugin/ /rdsdbbin/mysql-5.6.12.R1/lib/plugin/ /rdsdbbin/mysql-5.6.12.R1/lib/plugin/ /rdsdbbin/mysql-5.6.12.R1/lib/plugin/ FALSE
325 port 3306 3306 3306 3306 FALSE 3306 3306 3306 3306 FALSE
326 preload_buffer_size 32768 32768 32768 32768 TRUE 32768 32768 32768 32768 TRUE
327 profiling OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
328 profiling_history_size 15 15 15 15 TRUE 15 15 15 15 TRUE
329 protocol_version 10 10 10 10 (N/A) 10 10 10 10 (N/A)
330 query_alloc_block_size 8192 8192 8192 8192 TRUE 8192 8192 8192 8192 TRUE
331 query_cache_limit 1048576 1048576 1048576 1048576 TRUE 1048576 1048576 1048576 1048576 TRUE
332 query_cache_min_res_unit 4096 4096 4096 4096 TRUE 4096 4096 4096 4096 TRUE
333 query_cache_size 0 0 0 0 TRUE 1048576 1048576 1048576 1048576 TRUE
334 query_cache_type ON ON ON ON TRUE OFF OFF OFF OFF TRUE
335 query_cache_wlock_invalidate OFF OFF OFF OFF TRUE OFF OFF OFF OFF TRUE
336 query_prealloc_size 8192 8192 8192 8192 TRUE 8192 8192 8192 8192 TRUE
337 range_alloc_block_size 4096 4096 4096 4096 TRUE 4096 4096 4096 4096 TRUE
338 read_buffer_size 131072 262144 262144 262144 TRUE 131072 262144 262144 262144 TRUE
339 read_only OFF OFF OFF ON TRUE OFF OFF OFF ON TRUE
340 read_rnd_buffer_size 262144 524288 524288 524288 TRUE 262144 524288 524288 524288 TRUE
341 relay_log   /rdsdbdata/log/relaylog/relaylog /rdsdbdata/log/relaylog/relaylog /rdsdbdata/log/relaylog/relaylog FALSE   /rdsdbdata/log/relaylog/relaylog /rdsdbdata/log/relaylog/relaylog /rdsdbdata/log/relaylog/relaylog FALSE
342 relay_log_basename (N/A) (N/A) (N/A) (N/A) (N/A)   /rdsdbdata/log/relaylog/relaylog /rdsdbdata/log/relaylog/relaylog /rdsdbdata/log/relaylog/relaylog (N/A)
343 relay_log_index         (N/A)   /rdsdbdata/log/relaylog/relaylog.index /rdsdbdata/log/relaylog/relaylog.index /rdsdbdata/log/relaylog/relaylog.index (N/A)
344 relay_log_info_file relay-log.info relay-log.info relay-log.info relay-log.info (N/A) relay-log.info relay-log.info relay-log.info relay-log.info (N/A)
345 relay_log_info_repository (N/A) (N/A) (N/A) (N/A) (N/A) FILE TABLE TABLE TABLE TRUE
346 relay_log_purge ON ON ON ON (N/A) ON ON ON ON (N/A)
347 relay_log_recovery OFF OFF OFF OFF (N/A) OFF ON ON ON FALSE
348 relay_log_space_limit 0 0 0 0 (N/A) 0 0 0 0 (N/A)
349 report_host         (N/A)         (N/A)
350 report_password         (N/A)         (N/A)
351 report_port 3306 3306 3306 3306 (N/A) 3306 3306 3306 3306 (N/A)
352 report_user         (N/A)         (N/A)
353 rpl_recovery_rank 0 0 0 0 (N/A) (N/A) (N/A) (N/A) (N/A) (N/A)
354 secure_auth OFF OFF OFF OFF TRUE ON ON ON ON TRUE
355 secure_file_priv   /tmp/ /tmp/ /tmp/ FALSE   /tmp/ /tmp/ /tmp/ FALSE
356 server_id 0 1813887317 1813887317 1737600700 FALSE 0 1967646648 1967646648 997543495 FALSE
357 server_id_bits (N/A) (N/A) (N/A) (N/A) (N/A) 32 32 32 32 (N/A)
358 server_uuid (N/A) (N/A) (N/A) (N/A) (N/A) e7af688c-e38f-11e2-896c-525400e972b6 ec0eef96-a6e9-11e2-bdf0-0015174ecc8e ec0eef96-a6e9-11e2-bdf0-0015174ecc8e e204e4d1-e391-11e2-8979-22000a7a19b7 (N/A)
359 skip_external_locking ON ON ON ON FALSE ON ON ON ON FALSE
360 skip_name_resolve OFF OFF OFF OFF TRUE OFF OFF OFF OFF TRUE
361 skip_networking OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
362 skip_show_database OFF OFF OFF OFF FALSE OFF OFF OFF OFF FALSE
363 slave_allow_batching (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF (N/A)
364 slave_checkpoint_group (N/A) (N/A) (N/A) (N/A) (N/A) 512 512 512 512 TRUE
365 slave_checkpoint_period (N/A) (N/A) (N/A) (N/A) (N/A) 300 300 300 300 TRUE
366 slave_compressed_protocol OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
367 slave_exec_mode STRICT STRICT STRICT STRICT (N/A) STRICT STRICT STRICT STRICT (N/A)
368 slave_load_tmpdir /tmp /rdsdbdata/tmp /rdsdbdata/tmp /rdsdbdata/tmp (N/A) /tmp /rdsdbdata/tmp /rdsdbdata/tmp /rdsdbdata/tmp (N/A)
369 slave_max_allowed_packet 1073741824 1073741824 1073741824 1073741824 (N/A) 1073741824 1073741824 1073741824 1073741824 (N/A)
370 slave_net_timeout 3600 3600 3600 3600 (N/A) 3600 3600 3600 3600 (N/A)
371 slave_parallel_workers (N/A) (N/A) (N/A) (N/A) (N/A) 0 0 0 0 TRUE
372 slave_pending_jobs_size_max (N/A) (N/A) (N/A) (N/A) (N/A) 16777216 16777216 16777216 16777216 TRUE
373 slave_rows_search_algorithms (N/A) (N/A) (N/A) (N/A) (N/A) TABLE_SCAN,INDEX_SCAN TABLE_SCAN,INDEX_SCAN TABLE_SCAN,INDEX_SCAN TABLE_SCAN,INDEX_SCAN (N/A)
374 slave_skip_errors OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
375 slave_sql_verify_checksum (N/A) (N/A) (N/A) (N/A) (N/A) ON ON ON ON TRUE
376 slave_transaction_retries 10 10 10 10 (N/A) 10 10 10 10 (N/A)
377 slave_type_conversions         (N/A)         (N/A)
378 slow_launch_time 2 2 2 2 TRUE 2 2 2 2 TRUE
379 slow_query_log OFF OFF OFF OFF TRUE OFF OFF OFF OFF TRUE
380 slow_query_log_file /var/lib/mysql/k09sl6-slow.log /rdsdbdata/log/slowquery/mysql-slowquery.log /rdsdbdata/log/slowquery/mysql-slowquery.log /rdsdbdata/log/slowquery/mysql-slowquery.log FALSE /var/lib/mysql/k01sl6-slow.log /rdsdbdata/log/slowquery/mysql-slowquery.log /rdsdbdata/log/slowquery/mysql-slowquery.log /rdsdbdata/log/slowquery/mysql-slowquery.log FALSE
381 socket /var/lib/mysql/mysql.sock /tmp/mysql.sock /tmp/mysql.sock /tmp/mysql.sock FALSE /var/lib/mysql/mysql.sock /tmp/mysql.sock /tmp/mysql.sock /tmp/mysql.sock FALSE
382 sort_buffer_size 2097152 2097152 2097152 2097152 TRUE 262144 262144 262144 262144 TRUE
383 sql_auto_is_null OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
384 sql_big_selects ON ON ON ON (N/A) ON ON ON ON (N/A)
385 sql_big_tables OFF OFF OFF OFF (N/A) (N/A) (N/A) (N/A) (N/A) (N/A)
386 sql_buffer_result OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
387 sql_log_bin ON ON ON ON (N/A) ON ON ON ON (N/A)
388 sql_log_off OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
389 sql_low_priority_updates OFF OFF OFF OFF (N/A) (N/A) (N/A) (N/A) (N/A) (N/A)
390 sql_max_join_size 1.84467E+19 1.84467E+19 1.84467E+19 1.84467E+19 (N/A) (N/A) (N/A) (N/A) (N/A) (N/A)
391 sql_mode         TRUE NO_ENGINE_SUBSTITUTION NO_ENGINE_SUBSTITUTION NO_ENGINE_SUBSTITUTION NO_ENGINE_SUBSTITUTION TRUE
392 sql_notes ON ON ON ON (N/A) ON ON ON ON (N/A)
393 sql_quote_show_create ON ON ON ON (N/A) ON ON ON ON (N/A)
394 sql_safe_updates OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
395 sql_select_limit 1.84467E+19 1.84467E+19 1.84467E+19 1.84467E+19 TRUE 1.84467E+19 1.84467E+19 1.84467E+19 1.84467E+19 TRUE
396 sql_slave_skip_counter 0 0 0 0 (N/A) 0 0 0 0 (N/A)
397 sql_warnings OFF OFF OFF OFF (N/A) OFF OFF OFF OFF (N/A)
398 ssl_ca   /rdsdbdata/rds-metadata/ca-cert.pem /rdsdbdata/rds-metadata/ca-cert.pem /rdsdbdata/rds-metadata/ca-cert.pem (N/A)   /rdsdbdata/rds-metadata/ca-cert.pem /rdsdbdata/rds-metadata/ca-cert.pem /rdsdbdata/rds-metadata/ca-cert.pem (N/A)
399 ssl_capath         (N/A)         (N/A)
400 ssl_cert   /rdsdbdata/rds-metadata/server-cert.pem /rdsdbdata/rds-metadata/server-cert.pem /rdsdbdata/rds-metadata/server-cert.pem (N/A)   /rdsdbdata/rds-metadata/server-cert.pem /rdsdbdata/rds-metadata/server-cert.pem /rdsdbdata/rds-metadata/server-cert.pem (N/A)
401 ssl_cipher   EXP1024-RC4-SHA:EXP1024-DES-CBC-SHA:AES256-SHA:AES128-SHA:DES-CBC3-SHA:DES-CBC-SHA:EXP-DES-CBC-SHA:EXP-RC2-CBC-MD5:RC4-SHA:RC4-MD5:EXP-RC4-MD5:NULL-SHA:NULL-MD5:DES-CBC3-MD5:DES-CBC-MD5:EXP-RC2-CBC-MD5:RC2-CBC-MD5:EXP-RC4-MD5:RC4-MD5:KRB5-DES-CBC3-MD5:KRB5-DES-CBC3-SHA:ADH-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:EDH-DSS-DES-CBC3-SHA:ADH-AES256-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES256-SHA:ADH-AES128-SHA:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA:EXP-KRB5-RC4-MD5:EXP-KRB5-RC2-CBC-MD5:EXP-KRB5-DES-CBC-MD5:KRB5-RC4-MD5:KRB5-DES-CBC-MD5:ADH-RC4-MD5:EXP-ADH-RC4-MD5:DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-DES-CBC-SHA:EXP-KRB5-RC4-SHA:EXP-KRB5-RC2-CBC-SHA:EXP-KRB5-DES-CBC-SHA:KRB5-RC4-SHA:KRB5-DES-CBC-SHA:ADH-DES-CBC-SHA:EXP-ADH-DES-CBC-SHA:EDH-RSA-DES-CBC-SHA:EXP-EDH-RSA-DES-CBC-SHA:EDH-DSS-DES-CBC-SHA:EXP-EDH-DSS-DES-CBC-SHA EXP1024-RC4-SHA:EXP1024-DES-CBC-SHA:AES256-SHA:AES128-SHA:DES-CBC3-SHA:DES-CBC-SHA:EXP-DES-CBC-SHA:EXP-RC2-CBC-MD5:RC4-SHA:RC4-MD5:EXP-RC4-MD5:NULL-SHA:NULL-MD5:DES-CBC3-MD5:DES-CBC-MD5:EXP-RC2-CBC-MD5:RC2-CBC-MD5:EXP-RC4-MD5:RC4-MD5:KRB5-DES-CBC3-MD5:KRB5-DES-CBC3-SHA:ADH-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:EDH-DSS-DES-CBC3-SHA:ADH-AES256-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES256-SHA:ADH-AES128-SHA:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA:EXP-KRB5-RC4-MD5:EXP-KRB5-RC2-CBC-MD5:EXP-KRB5-DES-CBC-MD5:KRB5-RC4-MD5:KRB5-DES-CBC-MD5:ADH-RC4-MD5:EXP-ADH-RC4-MD5:DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-DES-CBC-SHA:EXP-KRB5-RC4-SHA:EXP-KRB5-RC2-CBC-SHA:EXP-KRB5-DES-CBC-SHA:KRB5-RC4-SHA:KRB5-DES-CBC-SHA:ADH-DES-CBC-SHA:EXP-ADH-DES-CBC-SHA:EDH-RSA-DES-CBC-SHA:EXP-EDH-RSA-DES-CBC-SHA:EDH-DSS-DES-CBC-SHA:EXP-EDH-DSS-DES-CBC-SHA EXP1024-RC4-SHA:EXP1024-DES-CBC-SHA:AES256-SHA:AES128-SHA:DES-CBC3-SHA:DES-CBC-SHA:EXP-DES-CBC-SHA:EXP-RC2-CBC-MD5:RC4-SHA:RC4-MD5:EXP-RC4-MD5:NULL-SHA:NULL-MD5:DES-CBC3-MD5:DES-CBC-MD5:EXP-RC2-CBC-MD5:RC2-CBC-MD5:EXP-RC4-MD5:RC4-MD5:KRB5-DES-CBC3-MD5:KRB5-DES-CBC3-SHA:ADH-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:EDH-DSS-DES-CBC3-SHA:ADH-AES256-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES256-SHA:ADH-AES128-SHA:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA:EXP-KRB5-RC4-MD5:EXP-KRB5-RC2-CBC-MD5:EXP-KRB5-DES-CBC-MD5:KRB5-RC4-MD5:KRB5-DES-CBC-MD5:ADH-RC4-MD5:EXP-ADH-RC4-MD5:DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-DES-CBC-SHA:EXP-KRB5-RC4-SHA:EXP-KRB5-RC2-CBC-SHA:EXP-KRB5-DES-CBC-SHA:KRB5-RC4-SHA:KRB5-DES-CBC-SHA:ADH-DES-CBC-SHA:EXP-ADH-DES-CBC-SHA:EDH-RSA-DES-CBC-SHA:EXP-EDH-RSA-DES-CBC-SHA:EDH-DSS-DES-CBC-SHA:EXP-EDH-DSS-DES-CBC-SHA (N/A)   EXP1024-RC4-SHA:EXP1024-DES-CBC-SHA:AES256-SHA:AES128-SHA:DES-CBC3-SHA:DES-CBC-SHA:EXP-DES-CBC-SHA:EXP-RC2-CBC-MD5:RC4-SHA:RC4-MD5:EXP-RC4-MD5:NULL-SHA:NULL-MD5:DES-CBC3-MD5:DES-CBC-MD5:EXP-RC2-CBC-MD5:RC2-CBC-MD5:EXP-RC4-MD5:RC4-MD5:KRB5-DES-CBC3-MD5:KRB5-DES-CBC3-SHA:ADH-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:EDH-DSS-DES-CBC3-SHA:ADH-AES256-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES256-SHA:ADH-AES128-SHA:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA:EXP-KRB5-RC4-MD5:EXP-KRB5-RC2-CBC-MD5:EXP-KRB5-DES-CBC-MD5:KRB5-RC4-MD5:KRB5-DES-CBC-MD5:ADH-RC4-MD5:EXP-ADH-RC4-MD5:DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-DES-CBC-SHA:EXP-KRB5-RC4-SHA:EXP-KRB5-RC2-CBC-SHA:EXP-KRB5-DES-CBC-SHA:KRB5-RC4-SHA:KRB5-DES-CBC-SHA:ADH-DES-CBC-SHA:EXP-ADH-DES-CBC-SHA:EDH-RSA-DES-CBC-SHA:EXP-EDH-RSA-DES-CBC-SHA:EDH-DSS-DES-CBC-SHA:EXP-EDH-DSS-DES-CBC-SHA EXP1024-RC4-SHA:EXP1024-DES-CBC-SHA:AES256-SHA:AES128-SHA:DES-CBC3-SHA:DES-CBC-SHA:EXP-DES-CBC-SHA:EXP-RC2-CBC-MD5:RC4-SHA:RC4-MD5:EXP-RC4-MD5:NULL-SHA:NULL-MD5:DES-CBC3-MD5:DES-CBC-MD5:EXP-RC2-CBC-MD5:RC2-CBC-MD5:EXP-RC4-MD5:RC4-MD5:KRB5-DES-CBC3-MD5:KRB5-DES-CBC3-SHA:ADH-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:EDH-DSS-DES-CBC3-SHA:ADH-AES256-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES256-SHA:ADH-AES128-SHA:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA:EXP-KRB5-RC4-MD5:EXP-KRB5-RC2-CBC-MD5:EXP-KRB5-DES-CBC-MD5:KRB5-RC4-MD5:KRB5-DES-CBC-MD5:ADH-RC4-MD5:EXP-ADH-RC4-MD5:DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-DES-CBC-SHA:EXP-KRB5-RC4-SHA:EXP-KRB5-RC2-CBC-SHA:EXP-KRB5-DES-CBC-SHA:KRB5-RC4-SHA:KRB5-DES-CBC-SHA:ADH-DES-CBC-SHA:EXP-ADH-DES-CBC-SHA:EDH-RSA-DES-CBC-SHA:EXP-EDH-RSA-DES-CBC-SHA:EDH-DSS-DES-CBC-SHA:EXP-EDH-DSS-DES-CBC-SHA EXP1024-RC4-SHA:EXP1024-DES-CBC-SHA:AES256-SHA:AES128-SHA:DES-CBC3-SHA:DES-CBC-SHA:EXP-DES-CBC-SHA:EXP-RC2-CBC-MD5:RC4-SHA:RC4-MD5:EXP-RC4-MD5:NULL-SHA:NULL-MD5:DES-CBC3-MD5:DES-CBC-MD5:EXP-RC2-CBC-MD5:RC2-CBC-MD5:EXP-RC4-MD5:RC4-MD5:KRB5-DES-CBC3-MD5:KRB5-DES-CBC3-SHA:ADH-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:EDH-DSS-DES-CBC3-SHA:ADH-AES256-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES256-SHA:ADH-AES128-SHA:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA:EXP-KRB5-RC4-MD5:EXP-KRB5-RC2-CBC-MD5:EXP-KRB5-DES-CBC-MD5:KRB5-RC4-MD5:KRB5-DES-CBC-MD5:ADH-RC4-MD5:EXP-ADH-RC4-MD5:DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-DES-CBC-SHA:EXP-KRB5-RC4-SHA:EXP-KRB5-RC2-CBC-SHA:EXP-KRB5-DES-CBC-SHA:KRB5-RC4-SHA:KRB5-DES-CBC-SHA:ADH-DES-CBC-SHA:EXP-ADH-DES-CBC-SHA:EDH-RSA-DES-CBC-SHA:EXP-EDH-RSA-DES-CBC-SHA:EDH-DSS-DES-CBC-SHA:EXP-EDH-DSS-DES-CBC-SHA (N/A)
402 ssl_crl (N/A) (N/A) (N/A) (N/A) (N/A)         (N/A)
403 ssl_crlpath (N/A) (N/A) (N/A) (N/A) (N/A)         (N/A)
404 ssl_key   /rdsdbdata/rds-metadata/server-key.pem /rdsdbdata/rds-metadata/server-key.pem /rdsdbdata/rds-metadata/server-key.pem (N/A)   /rdsdbdata/rds-metadata/server-key.pem /rdsdbdata/rds-metadata/server-key.pem /rdsdbdata/rds-metadata/server-key.pem (N/A)
405 storage_engine InnoDB InnoDB InnoDB InnoDB (N/A) InnoDB InnoDB InnoDB InnoDB (N/A)
406 stored_program_cache 256 256 256 256 (N/A) 256 256 256 256 TRUE
407 sync_binlog 0 0 0 0 TRUE 0 1 1 1 FALSE
408 sync_frm ON ON ON ON TRUE ON ON ON ON TRUE
409 sync_master_info 0 0 0 0 (N/A) 10000 10000 10000 10000 TRUE
410 sync_relay_log 0 0 0 0 (N/A) 10000 10000 10000 10000 TRUE
411 sync_relay_log_info 0 0 0 0 (N/A) 10000 10000 10000 10000 TRUE
412 system_time_zone JST UTC UTC UTC (N/A) JST UTC UTC UTC (N/A)
413 table_definition_cache 400 400 400 400 TRUE 1400 1400 1400 1400 TRUE
414 table_open_cache 400 400 400 400 TRUE 2000 2000 2000 2000 TRUE
415 table_open_cache_instances (N/A) (N/A) (N/A) (N/A) (N/A) 1 16 16 16 TRUE
416 thread_cache_size 0 0 0 0 TRUE 9 8 9 8 TRUE
417 thread_concurrency 10 10 10 10 (N/A) 10 10 10 10 (N/A)
418 thread_handling one-thread-per-connection one-thread-per-connection one-thread-per-connection one-thread-per-connection (N/A) one-thread-per-connection one-thread-per-connection one-thread-per-connection one-thread-per-connection (N/A)
419 thread_stack 262144 262144 262144 262144 TRUE 262144 262144 262144 262144 TRUE
420 time_format %H:%i:%s %H:%i:%s %H:%i:%s %H:%i:%s (N/A) %H:%i:%s %H:%i:%s %H:%i:%s %H:%i:%s (N/A)
421 time_zone SYSTEM UTC UTC UTC (N/A) SYSTEM UTC UTC UTC (N/A)
422 timed_mutexes OFF OFF OFF OFF TRUE OFF OFF OFF OFF TRUE
423 tmp_table_size 16777216 16777216 16777216 16777216 TRUE 16777216 16777216 16777216 16777216 TRUE
424 tmpdir /tmp /rdsdbdata/tmp /rdsdbdata/tmp /rdsdbdata/tmp FALSE /tmp /rdsdbdata/tmp /rdsdbdata/tmp /rdsdbdata/tmp FALSE
425 transaction_alloc_block_size 8192 8192 8192 8192 TRUE 8192 8192 8192 8192 TRUE
426 transaction_prealloc_size 4096 4096 4096 4096 TRUE 4096 4096 4096 4096 TRUE
427 tx_isolation REPEATABLE-READ REPEATABLE-READ REPEATABLE-READ REPEATABLE-READ TRUE REPEATABLE-READ REPEATABLE-READ REPEATABLE-READ REPEATABLE-READ TRUE
428 tx_read_only (N/A) (N/A) (N/A) (N/A) (N/A) OFF OFF OFF OFF (N/A)
429 unique_checks ON ON ON ON (N/A) ON ON ON ON (N/A)
430 updatable_views_with_limit YES YES YES YES TRUE YES YES YES YES TRUE
431 version 5.5.31 5.5.31-log 5.5.31-log 5.5.31 (N/A) 5.6.12 5.6.12-log 5.6.12-log 5.6.12 (N/A)
432 version_comment MySQL Community Server (GPL) Source distribution Source distribution Source distribution (N/A) MySQL Community Server (GPL) MySQL Community Server (GPL) MySQL Community Server (GPL) MySQL Community Server (GPL) (N/A)
433 version_compile_machine x86_64 x86_64 x86_64 x86_64 (N/A) x86_64 x86_64 x86_64 x86_64 (N/A)
434 version_compile_os Linux Linux Linux Linux (N/A) Linux Linux Linux Linux (N/A)
435 wait_timeout 28800 28800 28800 28800 TRUE 28800 28800 28800 28800 TRUE