how many concurrent connections can handle 2 GB RAM managed MySQL database ??

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer

Hi there

Thanks for reaching out to DigitalOcean Support.

I understand you want to know about how many concurrent connections MySQL managed database with 2GB RAM can handle.

MySQL nodes can have up to 75 simultaneous connections per gigabyte of usable memory, rounded down to the nearest gigabyte. Usable memory is the total memory on the node minus approximately 350 MB of overhead for the operating system and management.

For 2 GB RAM, available backend connection limit is 150

The below link has information on the number of Available Backend Connection with the corresponding plan sizes:

https://www.digitalocean.com/docs/databases/mysql/#mysql-limits

Plan Size Available Backend Connections
1 GB RAM 75
2 GB RAM 150
4 GB RAM 225
8 GB RAM 525
16 GB RAM 1,050
32 GB RAM 2,175
64 GB RAM 4,425

You can also check from our Cloud Control Panel; click –> Databases –> Insight tab, on right view the connection limit under the connection status.

Note: maxconnections is set to one connection higher to accommodate a system process that does not count against the node’s connection limit. For example, a 4 GB node has roughly 3.6 GB of usable memory. It can have up to 3 * 75 = 225 connections and its maxconnections is set to 226.

Please let us know if you have additional questions/concerns.

Regards
DigitalOcean Support

Submit an Answer