RDS Parameters for MySQL

The following RDS parameters for MySQL are minimum recommendations only. This is not a one-size fits all, but is a good starting point if deploying Metric Insights in your own Amazon cloud.

Note: the metricinsights parameters below are for a db.m3.large

RDS Parameters for MySQL 5.6

MySQL Parameter Comparison: Default vs. Metric Insights
 
 
 
 
 
Parameter
default.mysql5.6
metricinsights
character_set_client
<engine-default>
utf8
character_set_connection
<engine-default>
utf8
character_set_results
<engine-default>
utf8
character_set_server
<engine-default>
utf8
collation_connection
<engine-default>
utf8_unicode_ci
collation_server
<engine-default>
utf8_unicode_ci
gtid-mode <OFF_PERMISSIVE> OFF (0)
gtid_mode <OFF_PERMISSIVE>
OFF (0)
innodb_buffer_pool_instances
<engine-default>
4
innodb_buffer_pool_size
{DBInstanceClassMemory*3/4} 
2147483648
innodb_flush_log_at_trx_commit
<engine-default>
2
innodb_log_buffer_size
8388608
67108864
innodb_sort_buffer_size
<engine-default>
8000000
join_buffer_size
<engine-default>
16777216
key_buffer_size
16777216
67108864
log_bin_trust_function_creators
<engine-default>
1
max_heap_table_size
<engine-default>
4294967296
query_cache_size
<engine-default>
67108864
query_cache_type
<engine-default>
1
read_buffer_size
262144
2097152
read_rnd_buffer_size
524288
4194304
slow_query_log
<engine-default>
1
sort_buffer_size
<engine-default>
2097152
table_definition_cache
<engine-default>
2048
table_open_cache
<engine-default>
2048
tmp_table_size
<engine-default>
1073741824