What is the acceptable MySQL max_questions supported?

Nuke Soldier Joined: Mar 23, 2004 Posts: 14

Quote:

MySQL Error: User '(my db user)' has exceeded the 'max_questions' resource (current value: 50000)

My nuke v7.2 patched & bbtonuke 2.0.8 site crashes every hour with only 3 users, isn't it pathetic?

1) What's nuke minimum requirement for max_questions in order to have a reasonable operation?

2) Any recommendable webhost for me?

3) What grade of hosting is good for small business?

4) What grade of hosting is good for a nuke portal site?

I guess the "speed freaks" forum should be full of elite nukers. I sincerely thank you guys for any help.

Lastly, 3 people used up 50000 queries? Isn't it ridiculous or something? Did I misconfigure something to screw it up? or the server's lying? Embarassed

-zeroem

Posted: Tue Apr 13, 2004 2:06 am

Did you modify db/db.php to make persistent database connection ?

Nuke Soldier Joined: Mar 23, 2004 Posts: 14

I didn't know about this. I go check it out now. Thanks! Smile

Nuke Soldier Joined: Mar 23, 2004 Posts: 14

I've enabled it. Thanks.
I'll see how it is performing. Thanks a billion!! Very Happy

Nuke Soldier Joined: Mar 23, 2004 Posts: 14

The site still crashes (db maxed out) with persistent connection enabled.

What should I do? I've also deactivated many modules. It still max out the 50000/hour limit. Is 50000 high or low? Please help.

-zeroem

Nuke Soldier Joined: Mar 23, 2004 Posts: 14

Site crashed again.

But then I realize the the old "sql_layer.php" might also need to be modified to use "mysql_pconnect()".

I also have Gallery too, Therefore I also modified it to use "mysql_pconnect()".

Hope this works, any advice?

Nuke Soldier Joined: Feb 26, 2004 Posts: 31

Mine was at 50 and I got the same errors so they bumped it up to 100 and I got the error message again. They said 100 was as high as they could set it. Hope that helps with the whets high question.

I have a supped question. What do I modify in my db.php to enable a persistent connection?

Posted: Mon Apr 26, 2004 11:26 am

Setup a test website with CPG-Nuke and test if you still have the trouble.

CPG-Nuke uses less SQL Questions by "merging" the queries

Nuke Soldier Joined: Feb 27, 2004 Posts: 27

I was having these errors with Ipowerweb and they have informed me they were fixing the problem, but I changed hosts with the same files and alls well now.

However there is a work around as follows:

1. Create 2 or three users for your database.
2. Create 2 or 3 config.php files with the different users.
3. When the site goes down ftp another config.php with a different user file and it will return.

Steve
http://www.talk-back.ca

Nuke Soldier Joined: Oct 17, 2003 Posts: 23

I have the same problem, before some days everything was ok, but now this error message appears:
" Bad QA3:User 'mydomainusercom' has exceeded the 'max_questions' resource (current value: 90000) "

My php-nuke is 6.5 and my forum module is standar version that comes with php nuke 6.5 any fix out?

Nuke Soldier Joined: Oct 17, 2003 Posts: 23

djmaze wrote:

Did you modify db/db.php to make persistent database connection ?

what to add or edit in db.php to make persistnet database connection?

----
I have the same problem before 2 days my site began to show this error message "Bad QA3:User 'mydomaincomuser' has exceeded the 'max_questions' resource (current value: 90000)" and no content from my php nuke 6.5. When i go to phpmyadmin at first it doesn't allow me to do anything because it is showing the same error but i optimize the db and it works, but after some time the same thing happen ERROR. I don't know from where the hell 90 000 mysql quires will come from. Do you have any suggestion? Please help!

Nuke Soldier Joined: Oct 17, 2003 Posts: 23

the error: "QA3:User 'mydomaincom' has exceeded the 'max_questions' resource (current value: 90000)"

Now I optimized my db so the site run ok and I turn the debuggin mode on and this messages showed:
at the top: "SQL query: select bposition from nuke_blocks where active='1' ORDER BY bposition ASC"

at the top of left blocks: "SQL query: select bid, bkey, title, content, url, blockfile, view from nuke_blocks where bposition='l' AND active='1' ORDER BY weight ASC"

at top of right blocks: "SQL query: select bid, bkey, title, content, url, blockfile, view from nuke_blocks where bposition='r' AND active='1' ORDER BY weight ASC"

at the top of center blocks(above the friendfinder random members block):
"SQL query: SELECT COUNT(id) AS total FROM nuke_user_profile1 where photo='1' and approved='1'
SQL query: SELECT ffusername, photopath FROM nuke_user_profile1 where photo='1' and approved='1' LIMIT 643, 5
SQL query: SELECT user_id from nuke_users where username='lida'
SQL query: SELECT user_id from nuke_users where username='zdraveca'
SQL query: SELECT user_id from nuke_users where username='nikki38'
SQL query: SELECT user_id from nuke_users where username='diadora78'
SQL query: SELECT user_id from nuke_users where username='georgi_fil'"

at the bottom of center blocks:
"SQL query: select bid, bkey, title, content, url, blockfile, view from nuke_blocks where bposition='c' AND active='1' ORDER BY weight ASC"

I use PROXIMA theme is it possible the theme to be some reason?
help please!

Sergeant Joined: Jan 18, 2004 Posts: 132

I recommend www.trusted-host.com for you.

Justin

Nuke Soldier Joined: Oct 17, 2003 Posts: 23

hhg wrote:

I recommend www.trusted-host.com for you.

Justin

Thanks but why what is there sql quires limit fot 1 hour?

Posted: Thu Nov 11, 2004 6:48 am

I get this error whenever I get around 30 on the board at one time. My host has their limit set to 50,000 and they said "change your code to be more efficient". Here is the fix for this but I havn't been able to get it to work yet.

Quote:

(host) currently limits users to 72,000 SELECT queries, per hour, per user. Once you have used up your quota, you will begin to receive "max_questions" errors until the end of the hour, and your quota is reset. Please note, this limit only applies to SELECT queries, and not INSERT queries. There has been no official word on whether UPDATE queries are affected.

Most users will never notice this limitation, however there are some programs out there that are very unconservative with their queries. Forums (AKA: bulletin boards, message boards) such as phpbb and CMS's (Content Management Systems) such as phpnuke are typically the greatest offenders due the large number of queries and the rapid click through rate.

To compensate for this limitation, you can set up 2 additional users (for a total of 3 users), and spread out your queries among them. This will give you a total of 216K SELECT queries. To set this up, you must complete 5 steps.

1) Log in to ops and go to packages > MySQL. Add users until you have 3, making sure that each user has the exact same password.

2) Locate where the database information is stored. Often it will be in a file called config.php, base.php, include.php or common.php. You should find the name, the user name, password, and server for your database.

3) Once you have found the file, you will see the variables defined in one of two fashions.
A regular variable will look like this: $db_user = "user_name";
Defined variables will look like this: define("db_user", "user_name");

4) Add the following lines of code immediately after the line you commented out.

$db_user_array[] = ""; //enter 1st user name
$db_user_array[] = ""; //enter 2nd user name
$db_user_array[] = ""; //enter 3rd user name

5) Depending on whether your script uses regular variables, or defined variables, enter one of the following lines after everything else we just added. Make sure you change "db_user" into whatever the correct name should be (see the line that you commented out).

//regular variable
$db_user = $db_user_array[ rand( 0, ( sizeof($db_user_array) -1 ) ) ];

//defined variable
define( "db_user", $db_user_array[ rand( 0, ( sizeof($db_user_array) -1 ) ) ] );

If you end up needing to remove one of your database user names in order to allow someone else to use your database, or if Powweb changes their number of users, updating the rotation script is as simple as adding or removing users from the list (eg: $db_user_array[] = ""