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.

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

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

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

Someone is spamming my forms/blog/guestbook, what can I do to stop or report them?

1) Reporting spammer to the source network does not usually help. However, if you really want to...