How many concurrent MySql connections do you allow?

March 27, 2015 5.3k views
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

3 Answers

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.

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

  • You can set the maximum connections to a value as high as you want, however you should not "exceed" the resources provided by the Droplet. Further, normal scripts will open a connection and then close it and this happens in a really short period of time (let`s say in the milliseconds range). I can think of occasions when you need hundreds or thousands of concurrent connections, but such applications usually require a dedicated server and not a virtualized machine.

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!

Have another answer? Share your knowledge.