Question

how many connections can handle managed MySQL database ??

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

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

I am getting this error. My DB is down now. Shall I restart the mysql cloud?

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: max_connections 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 max_connections is set to 226.

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

Regards DigitalOcean Support