Related

Product Now Available: Managed MySQL Databases Product
Install MySQL on New Droplet Question Question
How can I solve error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" Question Question

Question

How many concurrent MySql connections do you allow?

Posted March 27, 2015 9.4k 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

Add a comment
ondigit
By:
ondigit

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.

×
3 answers
ryanpq March 27, 2015

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.

Reply Report
ondigit March 27, 2015

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

Reply Report
  • Viko March 27, 2015

    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.

    Reply Report
ZoomAdmin July 9, 2018

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!

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help