Maximum MySQL connections at once

Connect with other users about what to run on your webhosting (and how to run it) here.
Post Reply
dandsk
A regular
A regular
Posts: 33
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Sat Mar 29, 2014 6:15 pm

Maximum MySQL connections at once

Post by dandsk »

What exactly does this term mean stated in the TOS?

+ Have open more than 20 remote (non-local) connections to the MySQL server per remote IP address

Does it mean 20 remote IP addresses are able to make connections with each MySQL database per second, or what? I'm asking this because the servers I run are continuously relying on MySQL to serve data to and back from the server, and I haven't noticed any errors coming from the MySQL server stating "overloaded" or something similar.

Thanks.
User avatar
Edge100x
Founder
Founder
Posts: 13121
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: Maximum MySQL connections at once

Post by Edge100x »

This means that only 20 connections can be open at a time from each remote IP address. If you have software which opens a connection and then closes it, then it will not be holding it open for very long.
dandsk
A regular
A regular
Posts: 33
Joined: Sat Mar 29, 2014 6:15 pm

Re: Maximum MySQL connections at once

Post by dandsk »

I feel stupid. Just realized that it's 20 connections PER remote IP, not 20 total.

Thanks for the answer.
Post Reply