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 |