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 optimum level so that the server does not crash when one of the user site is hit with lots of traffic.

If you are getting "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.

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

Related Articles

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...

I have X GB traffic/bandwidth, and have not used all, why is my site creating load and being asked to upgrade?

Server load and bandwidth are two entirely different things. Server load refers to the amount of...

I uploaded a new script to my cgi-bin but I am being told "File Not Found," or "No Such File or Directory."

This is a common easily overlooked mistake thats easily corrected. Your script was probably...

Im having trouble sending email, what could the problem be?

If you are having trouble sending email, it is probably due to the auth scheme needed to allow...

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....