rds-config.sh

#!/bin/bash

aws rds modify-db-parameter-group --db-parameter-group-name mysql56-improved --parameters \
ParameterName=character_set_server,ParameterValue=utf8,ApplyMethod=pending-reboot \
ParameterName=collation_server,ParameterValue=utf8_unicode_ci,ApplyMethod=pending-reboot \
ParameterName=tmp_table_size,ParameterValue={DBInstanceClassMemory/16},ApplyMethod=pending-reboot \
ParameterName=max_heap_table_size,ParameterValue={DBInstanceClassMemory/16},ApplyMethod=pending-reboot \
ParameterName=query_cache_type,ParameterValue=1,ApplyMethod=pending-reboot \
ParameterName=query_cache_size,ParameterValue=131072,ApplyMethod=pending-reboot \
ParameterName=table_open_cache,ParameterValue=2500,ApplyMethod=pending-reboot \
ParameterName=join_buffer_size,ParameterValue={DBInstanceClassMemory/64},ApplyMethod=pending-reboot \
ParameterName=thread_cache_size,ParameterValue={DBInstanceClassMemory/12582880},ApplyMethod=pending-reboot \
ParameterName=sort_buffer_size,ParameterValue={DBInstanceClassMemory/64},ApplyMethod=pending-reboot \
ParameterName=innodb_flush_log_at_trx_commit,ParameterValue=0,ApplyMethod=pending-reboot \
ParameterName=innodb_max_dirty_pages_pct,ParameterValue=90,ApplyMethod=pending-reboot \
ParameterName=max_allowed_packet,ParameterValue=33554432,ApplyMethod=pending-reboot \
ParameterName=tx_isolation,ParameterValue=READ-COMMITTED,ApplyMethod=pending-reboot \
ParameterName=sync_binlog,ParameterValue=0,ApplyMethod=pending-reboot \
ParameterName=sync_master_info,ParameterValue=0,ApplyMethod=pending-reboot \
ParameterName=sync_relay_log,ParameterValue=0,ApplyMethod=pending-reboot \
ParameterName=sync_relay_log_info,ParameterValue=0,ApplyMethod=pending-reboot