A little preface: I just recently switched over to Simple Machines from SimpleBoard using the Mambo Bridge. After much fanfare, everything works great with one exception. After awhile I am getting the following error:
User 'dbuser_name' has exceeded the 'max_questions' resource (current value: 50000)
A little research told me that I was exceeding the server side query limit which is set at 50,000 per hour. I'm no expert, but it seems to me that 50,000 queries an hour is a little excessive.
I'm wondering if anybody else has had this issue in the past and has figured out a work around. I'm not certain if it's board specific or bridge specific either. Any help would be appreciated!
-Jeff
Lainaus käyttäjältä: Shobalk - helmikuu 01, 2005, 10:13:37 IP
A little research told me that I was exceeding the server side query limit which is set at 50,000 per hour. I'm no expert, but it seems to me that 50,000 queries an hour is a little excessive.
Yes, but that depends on a few things...
If someone knows or suspects you have this option enabled (by default it is disabled), it's an easy way to DDoS your server.
If you have 100 people using the forum at any given time, each with let's say 12 queries per view... clicking every say 20 seconds on average... 5 times a minute, 300 per hour times 100 people is 30000... times 12 is 360,000 queries per hour. Easily WAY above your limit, but that's very heavy usage.
This site gets about 15 queries per second. That's more than your maximum, at about 54,000 per hour.
Yet... the load averages are fine. Measuring the number of queries is a poor way to approximate server load or performance.
How many users do you have online most of the time? How many posts? Can't be that many if you only recently started.
-[Unknown]
Lainaus käyttäjältä: [Unknown] - helmikuu 01, 2005, 10:21:12 IP
How many users do you have online most of the time? How many posts? Can't be that many if you only recently started.
-[Unknown]
Not nearly enough to warrent 50k queries I'd think. I'd say 10 users at any given time is the max for this time of year (it's a fantasy football site). I'm not using queries to measure performace really; I'm using it to determine whether or not I can run the board :). My current host is dead set on the 50k limit.
There are about 10-20 posts as of right now. Most of my time has been spent plunking around in the admin console, which admittedly, has been an awful lot.
Then... strange. 10 users online is hardly enough to cause that many queries per second/hour.
Can you ask your host for more information? You can get the queries per second by issuing mysqladmin stat, but I think that's global to the server.
Do you know how many queries Mambo uses per page view? This never happened while you were using Simpleboard?
-[Unknown]
Lainaus käyttäjältä: [Unknown] - helmikuu 01, 2005, 10:48:13 IP
Can you ask your host for more information? You can get the queries per second by issuing mysqladmin stat, but I think that's global to the server.
Do you know how many queries Mambo uses per page view? This never happened while you were using Simpleboard?
-[Unknown]
I certainly can ask my host for more information. We're currently on shared hosting, so I do not have ssh access to the server anyhow.
Mambo queries can vary wildly depending on what a component a user is in, but I never had the problem before.
We're switiching to a dedicated server soonish, so we'll be able to set the question limit ourselves. I'll report back if I find out anything. Thanks for your help.
As a workaround for the moment, I've got Mambo and Simple Machines running under two seperate database user accounts. Hopefully that will work for the time being.
Lainaus käyttäjältä: Shobalk - helmikuu 01, 2005, 11:32:20 IP
As a workaround for the moment, I've got Mambo and Simple Machines running under two seperate database user accounts. Hopefully that will work for the time being.
That sounds like a good way to resolve it.
As for being able to set it yourself; as far as I can remember, this is a relatively uncommon setting most people *don't* use, and when it's set to 0 it's "unlimited". That's what we have it at here.
-[Unknown]