Skip to content

Instantly share code, notes, and snippets.

@magnetikonline

magnetikonline/README.md

Created May 26, 2014 04:56
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save magnetikonline/01d9542a4d9e90472839 to your computer and use it in GitHub Desktop.
Save magnetikonline/01d9542a4d9e90472839 to your computer and use it in GitHub Desktop.
Download ZIP
AWS RDS MySQL parameter group tweaks.
Raw
README.md

AWS RDS MySQL parameter group tweaks

Parameter Value AWS default
character_set_server utf8
collation_server utf8_general_ci
default_storage_engine InnoDB InnoDB
innodb_buffer_pool_size {DBInstanceClassMemory*7/10} {DBInstanceClassMemory*3/4}
innodb_log_file_size 134217728 134217728
max_allowed_packet 4194304
max_connections 160 {DBInstanceClassMemory/12582880}
query_cache_limit 1048576
query_cache_size 33554432
query_cache_type 1
table_open_cache_instances 16 16
table_open_cache 2000
thread_cache_size 64
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment