Skip to content

Instantly share code, notes, and snippets.

@dgitman

dgitman/AWS RDS ETL Parameter Group

Last active August 29, 2015 14:09
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 dgitman/bc2aab5e203398128b6c to your computer and use it in GitHub Desktop.
Save dgitman/bc2aab5e203398128b6c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
AWS RDS ETL Parameter Group
aws rds reset-db-parameter-group --db-parameter-group-name=etl --reset-all-parameters
aws rds modify-db-parameter-group --db-parameter-group-name=etl \
--parameters="ParameterName=character_set_server, ParameterValue=utf8, ApplyMethod=immediate" \
--parameters="ParameterName=collation_server, ParameterValue=utf8_general_ci, ApplyMethod=immediate" \
--parameters="ParameterName=slow_query_log, ParameterValue=1, ApplyMethod=immediate" \
--parameters="ParameterName=log_queries_not_using_indexes, ParameterValue=1, ApplyMethod=immediate" \
--parameters="ParameterName=max_allowed_packet, ParameterValue=67108864, ApplyMethod=immediate" \
--parameters="ParameterName=log_bin_trust_function_creators, ParameterValue=1, ApplyMethod=immediate" \
--parameters="ParameterName=tmp_table_size, ParameterValue={DBInstanceClassMemory/16}, ApplyMethod=immediate" \
--parameters="ParameterName=max_heap_table_size, ParameterValue={DBInstanceClassMemory/16}, ApplyMethod=immediate" \
--parameters="ParameterName=query_cache_type, ParameterValue=1, ApplyMethod=immediate" \
--parameters="ParameterName=query_cache_size, ParameterValue=512000000, ApplyMethod=immediate" \
--parameters="ParameterName=query_cache_limit, ParameterValue=2097152, ApplyMethod=immediate" \
--parameters="ParameterName=table_open_cache, ParameterValue=4000, ApplyMethod=immediate" \
--parameters="ParameterName=join_buffer_size, ParameterValue={DBInstanceClassMemory/64}, ApplyMethod=immediate" \
--parameters="ParameterName=thread_cache_size, ParameterValue={DBInstanceClassMemory/12582880}, ApplyMethod=immediate" \
--parameters="ParameterName=sort_buffer_size, ParameterValue={DBInstanceClassMemory/64}, ApplyMethod=immediate" \
--parameters="ParameterName=innodb_flush_log_at_trx_commit, ParameterValue=0, ApplyMethod=immediate" \
--parameters="ParameterName=innodb_support_xa, ParameterValue=0, ApplyMethod=immediate" \
--parameters="ParameterName=innodb_log_file_size--parameters="ParameterName=536870912, ApplyMethod=pending-reboot"\
--parameters="ParameterName=sync_binlog, --parameters="ParameterName=0, ApplyMethod=immediate"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment