Skip to content

Instantly share code, notes, and snippets.

@return1

return1/gist:e957dbbe01218bcad677

Forked from douglasjarquin/gist:2208690
Created October 20, 2015 12:42
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 return1/e957dbbe01218bcad677 to your computer and use it in GitHub Desktop.
Save return1/e957dbbe01218bcad677 to your computer and use it in GitHub Desktop.
Download ZIP
Amazon RDS Performance Tuning Settings
Raw
gistfile1.sh
rds-modify-db-parameter-group {param-group-name} \
--parameters="name=character_set_server, value=utf8, method=pending-reboot" \
--parameters="name=collation_server, value=utf8_general_ci, method=pending-reboot" \
--parameters="name=tmp_table_size, value={DBInstanceClassMemory/16}, method=pending-reboot" \
--parameters="name=max_heap_table_size, value={DBInstanceClassMemory/16}, method=pending-reboot" \
--parameters="name=query_cache_type, value=1, method=pending-reboot" \
--parameters="name=query_cache_size, value=131072, method=pending-reboot" \
--parameters="name=table_open_cache, value=2500, method=pending-reboot" \
--parameters="name=join_buffer_size, value={DBInstanceClassMemory/64}, method=pending-reboot" \
--parameters="name=thread_cache_size, value={DBInstanceClassMemory/12582880}, method=pending-reboot" \
--parameters="name=sort_buffer_size, value={DBInstanceClassMemory/64}, method=pending-reboot" \
--parameters="name=innodb_flush_log_at_trx_commit, value=0, method=pending-reboot" \
--parameters="name=innodb_additional_mem_pool_size, value={DBInstanceClassMemory/64}, method=pending-reboot" \
--parameters="name=innodb_max_dirty_pages_pct, value=90, method=pending-reboot" \
--parameters="name=max_allowed_packet, value=33554432, method=pending-reboot" \
--parameters="name=tx_isolation, value=READ-COMMITTED, method=pending-reboot"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment