Sample Header Ad - 728x90

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