MySQL 8.0 parameters
- Aleksei Melnikov
Common properties
Parameter | Current Value | New Value | Comment |
|---|---|---|---|
character_set_client | <engine_default> |
| Â |
character_set_connection | <engine_default> |
| Â |
character_set_database | <engine_default> |
| Â |
character_set_filesystem | <engine_default> |
| Â |
character_set_results | <engine_default> |
| Â |
character_set_server | <engine_default> |
| Â |
collation_connection | <engine_default> |
| Â |
collation_server | <engine_default> |
| Â |
lower_case_table_names | <engine_default> | 1 | Not working in RDS |
max_allowed_packet | <engine_default> | 268435456 | Depends on maximum file upload setting |
Depending on available CPU and RAM
Property name | 2vcpu 4GB RAM | 2vcpu 8GB RAM | 4vcpu 16GB RAM |
|---|---|---|---|
innodb_buffer_pool_size | {AvailableMemory*3/4} AvailableMemory ≈ 3GB | {AvailableMemory*3/4} AvailableMemory ≈ 6GB | {AvailableMemory*3/4} AvailableMemory ≈ 13GB |
innodb_log_buffer_size | 25165824 | 25165824 | 50331648 |
innodb_log_file_size | 268435456 | 268435456 | 536870912 |
innodb_read_io_threads | <engine_default> | 32 | 64 |
innodb_sort_buffer_size | <engine_default> | 12582912 | 12582912 |
innodb_write_io_threads | <engine_default> | 32 | 64 |
join_buffer_size | <engine_default> | 12582912 | 25165824 |
max_allowed_packet | <engine_default> | 268435456 | 268435456 |
max_heap_table_size | <engine_default> | 268435456 | 536870912 |
read_buffer_size | <engine_default> | 9437184 | 9437184 |
read_rnd_buffer_size | <engine_default> | 12582912 | 12582912 |
sort_buffer_size | <engine_default> | 12582912 | 12582912 |
table_definition_cache | <engine_default> | 8000 | 16000 |
table_open_cache | <engine_default> | 8000 | 16000 |
tmp_table_size | <engine_default> | 268435456 | 536870912 |