UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support max_questions resource error

The admin side of my board gives the following error.

has exceeded the 'max_questions' resource

What is this exactly?

Just the admin side?

I think your whole board should give the error, because this happens if your provider set a max# of queries in a set period of time. Say, 100,000 queries an hour, and you exceed that number.

You're right the whole board gives the error.

What should the limit be set to?

Ideally you want to have it at no limit at all, atleast a limit you will never reach.

The mysql error logfiles from ubb show you what the limit is set to now.

But I don't know if your provider agrees with that. Some ask for additional payment for more queries per X time.

That is something you can't set unless you own the Server it's running on or can get your provider to change it. It is a limit set to prevent a single account from sucking up all the resources of a server from too many queries in a short period of time.

Granted it may or may not be an accurate measure of resource usage but none the less you don't have access typically on a website to change the setting.

i never new that :omg:

Then you are a happy camper

I knew what it was because it happened to us

Well, after chatting with my hosting company, they do have a limit and cannot bump it up.

After years of popularizing my board, i'm now seeing limits to it.
Frustrating.

From the ISP: the limit is 50,000 queries at one time.

I thought it was set by day or by the hour.

Is this something that i can fix?

50,000 at ONE TIME??

they musta left something out in their explanation. it seems like a vanilla response from them, where they fail to inform you of what is really the case for (insert reason here)

It is not a one time setting. It is typically per hour

Not much you can do if your host provider won't change it. It's not just your site, it comes from queries aggregated from all sites being hosted on that server running MySQL.

If you had control you could do something like:

update user set max_questions=0;

Which would disable it, but if the host provider did that, then they could easily run into issues where MySQL would hang quite often from over use.

And i thought Database size was the only issue with hosts
I'm learning a a fair bit reading this..

Goes well in my sales speel for my server lol

I highly doubt it's doing 50k queries at one TIME... In fact, I don't believe this is a limitation setting in mysql; i'd be willing to bet it's per hour.

Can anyone recommend a hosting company that does not have a query limit on mysql databases?

I don't think there is one. There needs to be a limit in order to prevent MySQL coming to a halt and all Web sites suffer from it while it does it's queries.

In a way it sort of makes a host provider limit how many busy sites are on the server (though not a good indicator as some providers just don't care how slow your site is regardless of what is causing it)

If you do see this limit pop up then you probably do need to change providers or at least think of a more dedicated solution.

The query limit is ultimately standard accross shared hosts; it makes it so no one user can bogart the resources.

If you're looking for hosting with less restrictions, you could try a VPS from www.webintellects.com as a VPS will not come with any such resource limitations.

Here's the latest from my hosting company:

"You are having the site hosted on a shared server where there are other users hosted on the same box as well. We have to ensure that all the sites are having equal resource utilization opportunity. It is this reason that we have enabled such limitations on the server which cannot be changed."

Looks like i'll have to move, again!

Any suggestions on where to move to?

Well if your site is that big and or that busy you'll probably need to look at some type of VPS or Dedicated Server as it looks like you may be beyond the capacity of most hosted solutions.

If you have a site so large that you've out grown a shared host, the next step is a VPS (Virtual Private Server), which would give your site dedicated resources to use (or abuse) for just your site(s).

For VPS' I'd recommend www.WebIntellects.com, several of us devers have used them for some time.

Danka!