| 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 |
-
-
Save hflamboauto1/ff672cf2ecca73cb940e7f6bcafd8eb0 to your computer and use it in GitHub Desktop.
AWS RDS MySQL parameter group tweaks.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment