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, 160 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 - nuke speed [ ]
 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
steven111
Lieutenant
Lieutenant


Joined: Dec 30, 2003
Posts: 283


PostPosted: Thu Jun 24, 2004 9:44 am Reply with quoteBack to top

djmaze, I am glad you found this thread Very Happy

Yes, the above two are the biggies. There may be some more, but I have not found them yet either.

_________________
ezClassifieds|Forums:Auto,Mac,Job,Win,HW
Find all posts by steven111View user's profileSend private messageVisit poster's website
COOPVETS
Nuke Soldier
Nuke Soldier


Joined: Mar 05, 2004
Posts: 20


PostPosted: Tue Jun 29, 2004 7:48 am Reply with quoteBack to top

Question: Is there a script anywhere that I could run on our shared server to inspect/review problems with our database?

I have indexed the suggested tables herein this message - and it makes little if any difference. I know its the database, I just don't know where or what to do about it. (noob here)

We used to have generation times of 0.221 - now we're hitting 59.129 almost daily and it is really annoying my user base. Only difference between then and now; our hosts server crashed and lost our main database file - they replaced it from a daily backup. Since then - it has been aweful.

Any words of wisdom would be appreciated.

Note: I have also installed the mainfile hacks and it worked great. I have no problem reading instructions when they are plain and simple. But this database thing is gonna be the death of me, I swear... gesh.

CV Forever!
Find all posts by COOPVETSView user's profileSend private messageSend e-mailVisit poster's website
steven111
Lieutenant
Lieutenant


Joined: Dec 30, 2003
Posts: 283


PostPosted: Tue Jun 29, 2004 9:14 am Reply with quoteBack to top

COOPVETS wrote:
Question: Is there a script anywhere that I could run on our shared server to inspect/review problems with our database?

I have indexed the suggested tables herein this message - and it makes little if any difference. I know its the database, I just don't know where or what to do about it. (noob here)

We used to have generation times of 0.221 - now we're hitting 59.129 almost daily and it is really annoying my user base. Only difference between then and now; our hosts server crashed and lost our main database file - they replaced it from a daily backup. Since then - it has been aweful.

Any words of wisdom would be appreciated.

Note: I have also installed the mainfile hacks and it worked great. I have no problem reading instructions when they are plain and simple. But this database thing is gonna be the death of me, I swear... gesh.

CV Forever!


59 seconds, emm......

You are not running any RSS feed- and if you are, it is cached? This could be a BIG source of the problem.


Go to unix shell (if you have access), and do a top, and see if anything is bumping up too much (iowait specially if it is approaching 100%).

Make sure all your tables are optimized. Go to phpmyadmin and in "structure" see if any tables need optimization. Optimize them.

If nothing works, pm me your url and I'lll take a look.

_________________
ezClassifieds|Forums:Auto,Mac,Job,Win,HW
Find all posts by steven111View user's profileSend private messageVisit poster's website
COOPVETS
Nuke Soldier
Nuke Soldier


Joined: Mar 05, 2004
Posts: 20


PostPosted: Tue Jun 29, 2004 9:43 am Reply with quoteBack to top

Nope... no RSS Feed here. Our tables are optimized daily and our generation times are now being sporatic for our users.

We are not permitted shell access on a shared server; standard CPanel access and PhpMyAdmin access is what we get.

If it would help any, I can PM you the dump from SHOW VARIABLES for our database.

Thanks for any assist.


CV Forever!
Find all posts by COOPVETSView user's profileSend private messageSend e-mailVisit poster's website
prekill
Nuke Soldier
Nuke Soldier


Joined: Sep 16, 2004
Posts: 28


PostPosted: Fri Dec 22, 2006 9:20 am Reply with quoteBack to top

umm ok I read everything.

now, I have big forums and a topic takes up to 6 sec to load.
my phpnuke 7.6 patch with all mainfile speed up is working very fast, about 0.19 sec a page.

only forum lag a bit. how can I index a filed? please explain as I have no clue on doing so.

thank you!
Find all posts by prekillView 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.036 Seconds - 66 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::