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

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.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

My site or FTP service seems slow, just stops, or doesn't connect, why is that?

There are various of factors that can contribute to occasional slow download speeds or time-outs....

How do I reach you if there's a problem or if I have questions?

The first thing to do is, of course, to search through this help system! We try very very hard to...

Why do I get an empty directory listing or a goofy welcome page where my website should be?

When you first get set up and your domain becomes active, your URL will most likely bring you to...

Why won't my pictures show up?

There are several reasons your images may not be showing up on your web page. 1. You haven't...

I created a file with a special character and can't delete it, can you help?

Many operating systems have special characters, called 'meta-characters', which carry special...