Question

How many concurrent MySql connections do you allow?

  • Posted March 27, 2015
  • MySQL

I am at hostgator.com right now and they have a max of 25+ concurrent connections mysql/cgi per account, if you go over your account is locked.

Do we have such limits like CPU usage limit and concurrent MySql connections?

Thanks Jinendra

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.

In other words, there is no connection limit, but the more connections you have, the higher your CPU might get and depending on what DO configuration you have for your droplet, if it gets to 100%, you just scale up get more cpu/memory. But don’t worry about it until you actually see 100% cpu, so start with lower plan and upgrade as needed. At some point if, you may also want scaling out, in other words, get multiple droplets, not just 1 and to split your traffic between multiple machines.

so I would say, no, you’ll never need dedicated machine if you can properly scale out your traffic and distribute your load. So DO, like other cloud VM providers can handle any size app.

Cheers, Michael Paltayan ZoomAdmin.com Founder ZoomAdmin makes VM management easier!

Thanks for reply, but it does not answer my question.

How many concurrent MySql connections do you allow, can I set max_connetion 1500 connections ?

Is it possible?

Thanks

Since you receive full root access on your droplets and administer your services we do not place any connection limits on your use of the service.

We do not have implicit limits on CPU use but as your droplet shares physical hardware with other droplets we do ask that you refrain from running processes that keep your CPU at 100% for extended periods of time as this can degrade services for other users.