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 |