Optimize the number of connections of the connection pool and MySQL
2
votes
1
answer
1862
views
We are using Oracle Cloud's Ampere A1 instance consisting of 4 OCPUs (equivalent to 4 vCPUs) and 24GB of usable memory on Oracle Linux 7.9.
On the server is running an java game server and a web server, both are used with MySQL 5.x. With the game server written in Java, we are using proxool , targeting up to 250 concurrent users. And with web server (currently using Apache) can be up to 1000 concurrent users.
If based on the formula :
connections = ((core_count * 2) + effective_spindle_count)
But the boot volume that the instance uses is now no longer HDD, so the value of the parameter
effective_spindle_count
is still a mystery on SSD.
So with the properties maximum-connection-count
, minimum-connection-count
, simultaneous-build-throttle
, prototype-count
which formula should be used? And what is the recommended value of these properties?
This is the current my.cnf configuration. Based on the above information and current configuration files, what is the calculation formula and the recommended value for the max_connections
system variable?
Asked by Tần Quảng
(23 rep)
Nov 26, 2022, 01:50 AM
Last activity: Nov 26, 2022, 03:09 AM
Last activity: Nov 26, 2022, 03:09 AM