You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 492 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - What is the acceptable MySQL max_questions supported? [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
zeroem
Nuke Soldier
Nuke Soldier


Joined: Mar 23, 2004
Posts: 14


PostPosted: Mon Apr 12, 2004 11:11 pm Reply with quoteBack to top

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
Find all posts by zeroemView user's profileSend private message
djmaze
Captain
Captain


Joined: Nov 29, 2003
Posts: 566

Location: Netherlands

PostPosted: Tue Apr 13, 2004 2:06 am Reply with quoteBack to top

Did you modify db/db.php to make persistent database connection ?
Find all posts by djmazeView user's profileSend private messageVisit poster's website
zeroem
Nuke Soldier
Nuke Soldier


Joined: Mar 23, 2004
Posts: 14


PostPosted: Tue Apr 13, 2004 11:09 pm Reply with quoteBack to top

I didn't know about this. I go check it out now. Thanks! Smile
Find all posts by zeroemView user's profileSend private message
zeroem
Nuke Soldier
Nuke Soldier


Joined: Mar 23, 2004
Posts: 14


PostPosted: Tue Apr 13, 2004 11:28 pm Reply with quoteBack to top

I've enabled it. Thanks.
I'll see how it is performing. Thanks a billion!! Very Happy
Find all posts by zeroemView user's profileSend private message
zeroem
Nuke Soldier
Nuke Soldier


Joined: Mar 23, 2004
Posts: 14


PostPosted: Wed Apr 14, 2004 1:03 am Reply with quoteBack to top

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
Find all posts by zeroemView user's profileSend private message
zeroem
Nuke Soldier
Nuke Soldier


Joined: Mar 23, 2004
Posts: 14


PostPosted: Wed Apr 14, 2004 2:21 am Reply with quoteBack to top

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?
Find all posts by zeroemView user's profileSend private message
InchWorm
Nuke Soldier
Nuke Soldier


Joined: Feb 26, 2004
Posts: 31


PostPosted: Mon Apr 26, 2004 9:38 am Reply with quoteBack to top

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?
Find all posts by InchWormView user's profileSend private message
djmaze
Captain
Captain


Joined: Nov 29, 2003
Posts: 566

Location: Netherlands

PostPosted: Mon Apr 26, 2004 11:26 am Reply with quoteBack to top

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

_________________
Famous people never give their signature Rolling Eyes
http://www.cpgnuke.com <- back online thanks to dedicatednow.com
Don't ask me to be admin on your site please Exclamation
Find all posts by djmazeView user's profileSend private messageVisit poster's website
Steve_Lillico
Nuke Soldier
Nuke Soldier


Joined: Feb 27, 2004
Posts: 27


PostPosted: Tue May 11, 2004 7:24 pm Reply with quoteBack to top

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
Find all posts by Steve_LillicoView user's profileSend private messageVisit poster's website
desa80
Nuke Soldier
Nuke Soldier


Joined: Oct 17, 2003
Posts: 23


PostPosted: Mon Oct 04, 2004 11:27 pm Reply with quoteBack to top

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?
Find all posts by desa80View user's profileSend private message
desa80
Nuke Soldier
Nuke Soldier


Joined: Oct 17, 2003
Posts: 23


PostPosted: Tue Oct 05, 2004 11:31 am Reply with quoteBack to top

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!
Find all posts by desa80View user's profileSend private message
desa80
Nuke Soldier
Nuke Soldier


Joined: Oct 17, 2003
Posts: 23


PostPosted: Wed Oct 06, 2004 10:24 am Reply with quoteBack to top

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!
Find all posts by desa80View user's profileSend private message
hhg
Sergeant
Sergeant


Joined: Jan 18, 2004
Posts: 132


PostPosted: Thu Oct 07, 2004 8:26 am Reply with quoteBack to top

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

Justin
Find all posts by hhgView user's profileSend private messageSend e-mailVisit poster's website
desa80
Nuke Soldier
Nuke Soldier


Joined: Oct 17, 2003
Posts: 23


PostPosted: Mon Oct 18, 2004 9:26 am Reply with quoteBack to top

hhg wrote:
I recommend www.trusted-host.com for you.

Justin

Thanks but why what is there sql quires limit fot 1 hour?
Find all posts by desa80View user's profileSend private message
Donovan
Nuke Soldier
Nuke Soldier


Joined: Sep 22, 2003
Posts: 21

Location: Maryland

PostPosted: Thu Nov 11, 2004 6:48 am Reply with quoteBack to top

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[] = ""
Find all posts by DonovanView user's profileSend private messageVisit poster's website
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.051 Seconds - 294 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::