I am new to InnoDB and database performance/tweaking.
I am running five websites and estimate about 5k to 10k concurrent users (within a 3 min timeframe).
Hardware of my new server:
32 CPUs AMD
128 GB DDR4 ECC
480 GB NVMe SSD
With MySQL 8 and default installation (I used Serverpilot), the speed was not faster than the 4 vCPUs with 16 GB RAM I had before.
But then I found the recommended server settings for InnoDB (manually, not using the variable innodb_dedicated_server
) which I used like this:
max_connections = 500
innodb_buffer_pool_size = 64G
innodb_log_file_size = 2G
innodb_log_files_in_group = 48
I am not sure about the max_connections
, though.
The other values are based on the 128 GB RAM that the server has.
Can some experienced developer confirm that all settings are more or less correct. It will also help other newbies in this field, especially with regard to the new MySQL 8.