Knowledge BaseSystem DatabaseRDS Parameters for MySQL

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

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