MySQL 8.4 parameters
Only one mandatory parameter which must be set and persisted
Property name | 2vcpu 4GB RAM | 2vcpu 8GB RAM | 4vcpu 16GB RAM |
|---|---|---|---|
max_allowed_packet | 120M (default TermWeb limit) you can change it with property | 120M | 120M |
innodb_redo_log_capacity | 512M-1GB | 2G | 3G |
Other values can be used as default values, or you may try to fine tune database with next paramters, there is no 100% match to any use case, and some parameters can be different for your usage:
Property name | 2vcpu 4GB RAM | 2vcpu 8GB RAM | 4vcpu 16GB RAM |
|---|---|---|---|
innodb_buffer_pool_size | {AvailableMemory*3/4} AvailableMemory ≈ 3GB | {AvailableMemory*3/4} AvailableMemory ≈ 6G | {AvailableMemory*3/4} AvailableMemory ≈ 12GB |
innodb_log_buffer_size | 64M | 64M | 128M |
innodb_read_io_threads | <engine_default> | 4 | 8 |
innodb_write_io_threads | <engine_default> | 4 | 8 |
innodb_sort_buffer_size | <engine_default> | 12582912 | 12582912 |
join_buffer_size | <engine_default> | 2M | 4M |
sort_buffer_size | <engine_default> | 2M | 4M |
read_buffer_size | <engine_default> | 1M | 2M |
read_rnd_buffer_size | <engine_default> | 1M | 2M |
tmp_table_size | 128M | 128M | 256M |
max_heap_table_size | 128M | 128M | 256M |
table_open_cache | <engine_default> | 8000 | 16000 |
table_definition_cache | <engine_default> | 8000 | 16000 |
thread_cache_size | 50 | 75 | 100 |