Here is all information regarding Magento 2.3 recommendations for MySQL configuration:
PARAMETER | DEFAULT | DESCRIPTION |
---|---|---|
innodb_buffer_pool_instances |
8 |
On AWS, it's linked to this (so no changes): "The number of regions that the InnoDB buffer pool is divided into" |
innodb_buffer_pool_size |
128MB |
On AWS, already configured to: {DBInstanceClassMemory*3/4} |
max_connections |
150 |
On AWS, already configured to:{DBInstanceClassMemory/12582880} |
innodb_thread_concurrency |
0 | On AWS, already configured to: 2 * (NumCPUs + NumDisks) On AWS, from 0 to 1000, dynamic. "The number of threads that can enter innodb concurrently" |
query_cache_type |
0-2 |
This parameter is static. "For query results either don't cache (=OFF), cache except for NO_CACHE (=ON), or only CACHE (=DEMAND)" |
query_cache_size |
0-9223372036854774784 |
This parameter is dynamic. "The amount of memory allocated for caching query results." |
query_cache_limit |
0-18446744073709547520 |
This parameter is dynamic. "Don't cache results that are larger than this number of bytes." |