how many connections can handle managed MySQL database ??

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

Submit an answer

This textbox defaults to using Markdown to format your answer.

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

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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:

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