Skip to content

Instantly share code, notes, and snippets.

@emaildano

emaildano/WordPress RDS Parameter Group Settings

Created February 16, 2016 18:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save emaildano/cb6041e0617c39f8f5e5 to your computer and use it in GitHub Desktop.
Save emaildano/cb6041e0617c39f8f5e5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
WordPress RDS Parameter Group Settings
aws rds describe-db-parameter-groups \
--db-parameter-group-name group_name
aws rds describe-db-parameters --db-parameter-group-name group_name
aws rds modify-db-parameter-group \
--db-parameter-group-name group_name \
--parameters "ParameterName=character_set_server, ParameterValue=utf8mb4, ApplyMethod=pending-reboot" \
--parameters "ParameterName=collation_server, ParameterValue=utf8mb4_general_ci, ApplyMethod=pending-reboot" \
--parameters "ParameterName=tmp_table_size, ParameterValue={DBInstanceClassMemory/16}, ApplyMethod=pending-reboot" \
--parameters "ParameterName=max_heap_table_size, ParameterValue={DBInstanceClassMemory/16}, ApplyMethod=pending-reboot" \
--parameters "ParameterName=query_cache_type, ParameterValue=1, ApplyMethod=pending-reboot" \
--parameters "ParameterName=query_cache_size, ParameterValue={DBInstanceClassMemory/32}, ApplyMethod=pending-reboot" \
--parameters "ParameterName=table_open_cache, ParameterValue=2500, ApplyMethod=pending-reboot" \
--parameters "ParameterName=join_buffer_size, ParameterValue={DBInstanceClassMemory/64}, ApplyMethod=pending-reboot" \
--parameters "ParameterName=thread_cache_size, ParameterValue={DBInstanceClassMemory/12582880}, ApplyMethod=pending-reboot" \
--parameters "ParameterName=sort_buffer_size, ParameterValue={DBInstanceClassMemory/64}, ApplyMethod=pending-reboot" \
--parameters "ParameterName=innodb_flush_log_at_trx_commit, ParameterValue=0, ApplyMethod=pending-reboot" \
--parameters "ParameterName=innodb_max_dirty_pages_pct, ParameterValue=90, ApplyMethod=pending-reboot" \
--parameters "ParameterName=max_allowed_packet, ParameterValue=33554432, ApplyMethod=pending-reboot" \
--parameters "ParameterName=tx_isolation, ParameterValue=READ-COMMITTED, ApplyMethod=pending-reboot" \
--parameters "ParameterName=sync_binlog, ParameterValue=0, ApplyMethod=pending-reboot"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment