simultaneous MySQL connections question

Avatar
  • Answered
I have a client who offers online classes. Is there a limit to the number of simultaneous MySQL connections on my Inmotion Hosting Virtual Hosting reseller account?
Avatar
Scott
Hello, Yes, our servers do have a limit to the number of simultaneous MySQL connections. The default limit is 30. This is not able to be changed on a shared server, but can be altered on VPS and Dedicated servers with root access. To change this for VPS/Dedicated servers: 1) log into SSH 2) move to /etc directory 3) edit the my.cnf file using nano or vim. 4) alter the line "max_user_connections=30" by changing the 30 to whatever you need. 5) save and close the file Note that the recommended upper limit for VPS is 30, while dedicated can go up to 60 or more depending on RAM. This does not mean that only 30 people can connect to the site at a time, like a class, but rather that the MySQL database cannot take more than 30 simultaneous transactions. These transactions are normally very fast, so hitting 30 at the same time is usually fairly difficult. If you do not have root access, you can Contact Live Support for them to alter that for you. Kindest Regards, Scott M