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, 280 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 - Troubles with mysql databases [ ]
 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
migueis
Sergeant
Sergeant


Joined: Apr 16, 2003
Posts: 123


PostPosted: Tue Mar 02, 2004 5:05 pm Reply with quoteBack to top

I'm having big problems with my site.
Frequently it apperar to be down for 30 minutes and then it came up again, I contacted my hosting and the reply was that:

Quote:
Suspecting = site has exceeded mysql limit set to ensure all shared hosting users have a fair share of the server resources.


I don't understand what limit he talks

Quote:
Also see that you are using mysql_pconnect (persistent connection)
This may be causing the problem as connections weren't kill.


And here i don't understand how can i confirm that.

_________________
Life would be so much easier if we just had the source code...
Find all posts by migueisView user's profileSend private messageVisit poster's websiteAIM AddressYahoo MessengerMSN MessengerICQ Number
musox
Sergeant
Sergeant


Joined: Aug 08, 2003
Posts: 119


PostPosted: Tue Mar 02, 2004 5:53 pm Reply with quoteBack to top

PHP-Nuke can request a lot of SQL statements. What is your limit on SQL requests? Also, can you have more than one MySQL user per database? You could set up an array of users to split the requests (if the limits are set on a per user basis vs. a database limit).

_________________
http://musox.com/
Find all posts by musoxView user's profileSend private messageVisit poster's website
desa80
Nuke Soldier
Nuke Soldier


Joined: Oct 17, 2003
Posts: 23


PostPosted: Wed Nov 17, 2004 10:04 am Reply with quoteBack to top

musox wrote:
PHP-Nuke can request a lot of SQL statements. What is your limit on SQL requests? Also, can you have more than one MySQL user per database? You could set up an array of users to split the requests (if the limits are set on a per user basis vs. a database limit).

Oh I get this error
Bad QA3:User 'mydomaincom' has exceeded the 'max_questions' resource (current value: 90000)
Can i get more info - for ex. which file send so many queries or something...?
Find all posts by desa80View user's profileSend private message
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.164 Seconds - 512 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::