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, 283 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 - SQL load 60% PLEASE HELP ME [ ]
 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
Korben-Dallas
Nuke Soldier
Nuke Soldier


Joined: Oct 18, 2003
Posts: 10


PostPosted: Thu Apr 22, 2004 9:43 am Reply with quoteBack to top

i go this letter from my webhost today

Quote:
We found your site is loading the MySql database heavily and that made the server crashed over 5 times in the past 48hrs. We got many complaints from other customers host in the same server. We think hosting your site at a shared hosting environment is not a good idea due to the phpnuke consumes so many server resources


and i have don all i can to de activating things i dont need

they turned me backon but with a connection limit in the database
23 users in 10 mintes made he database seize
#1226 - User ******* has exceeded the 'max_connections' resource (current value: 450)

what can i do here?

phpnuke 8.0
phpbb2 2.0.8 upgrade

attachmod 239

Baord Message XL

yellow card mod

newest google tap

forum news advance / with blocks for nuke please

QuickReply mod and pm quickreply

5 recent post block for forums

phpmyadmin installed to BB admin

forum FAvorites addon

online offline mod

staff page

and site_map

antispham

scrolling forums block userinfo block
nuke center blocks AND nuke centerbolcks4

what is the issue?


Last edited by Korben-Dallas on Thu Apr 22, 2004 10:42 am; edited 1 time in total
Find all posts by Korben-DallasView user's profileSend private message
Korben-Dallas
Nuke Soldier
Nuke Soldier


Joined: Oct 18, 2003
Posts: 10


PostPosted: Thu Apr 22, 2004 10:41 am Reply with quoteBack to top

also i have almost 20,000 members with around 30 - 40,000 hits er day and average around 65 new members daily
Find all posts by Korben-DallasView user's profileSend private message
IACOJ
Major
Major


Joined: Jan 15, 2003
Posts: 1269

Location: USA

PostPosted: Thu Apr 22, 2004 11:16 am Reply with quoteBack to top

Hi Korben-Dallas,

You need at least a semi-dedicated server. It will buy you some time before you have to move to dedicated.

If you want something to compare to what you currently have, there is a link to our host on the lower left corner of the screen, and if you click on "hosting" after the new page opens, it will list two packages, one of which is semi-ded.
Find all posts by IACOJView user's profileSend private message
Evaders99
Site Admin
Site Admin


Joined: Aug 17, 2003
Posts: 12482


PostPosted: Thu Apr 22, 2004 3:43 pm Reply with quoteBack to top

Try setting persistant database connections and use the speedup mainfile.php changes.

Search the forums.

_________________
Helping those that help themselves
Read FIRST or DIE!

"Fighting is terrible, but not as terrible as losing the will to fight."
Star Wars Rebellion Network - Need Help? Evaders Squadron Coding
Find all posts by Evaders99View user's profileSend private messageVisit poster's websiteAIM Address
desa80
Nuke Soldier
Nuke Soldier


Joined: Oct 17, 2003
Posts: 23


PostPosted: Wed Nov 17, 2004 9:58 am Reply with quoteBack to top

Evaders99 wrote:
Try setting persistant database connections and use the speedup mainfile.php changes.

Search the forums.

I have the same problem - " Bad QA3:User 'mydomaincom' has exceeded the 'max_questions' resource (current value: 90000) "
I set the persistant connections but the problem still appears and what are the speedup mainfile.php changes
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.202 Seconds - 440 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::