How many SQL queries are allowed on shared/SDX (max_user_connections)? Which dedicated server can fit my needs for it? Print

  • 0

There is no hard and fast rule. It all depends on your queries. One bad query can take down the whole server and hang the MySQL server. So, being a shared server, we have setup the limits at an optimum level so that the server does not crash when one of the user sites is hit with lots of traffic. 

If you are getting a "too many connections" MySQL error, then either you are hitting the limits or your code is not closing open MySQL connections before opening new ones.

The only person(s) who can tell you how many queries will make your site work fine is the developer of the code you are using. They should do a stress test and see how many queries will require how much system resources (CPU, RAM). Depending on that result, we can help you with identifying which dedicated server will fit your needs. Otherwise, it is just a hit and trial exercise.

Was this answer helpful?

« Back