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, 66 guest(s) and 1 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - Recommendation: mytop [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

Recommendation: mytop
 
Post new topic  Reply to topicprinter-friendly view Nuke Cops Forum Index » Speed Freaks
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: Mon Oct 04, 2004 8:51 pm Reply with quoteBack to top
If you have access to root, and are running heavy loads on your mysql (e.g. running a forum), then I recommend that you download mytop and run it on your server. mytop is like Linux "top" command, but it shows you the current mysql queries, time they are taking to run, etc.

I discoverd quite a few dreaded "table scans" using this tool. My server is running x5 faster as a result of some simple fixes (i.e. adding proper index).

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


Joined: Jan 18, 2004
Posts: 129
PostPosted: Thu Oct 07, 2004 8:37 am Reply with quoteBack to top
where can I get mytop? thx.

Justin

_________________
Image
Find all posts by hhgView user's profileSend private messageSend e-mailVisit poster's websiteYahoo MessengerMSN Messenger
steven111
Lieutenant
Lieutenant


Joined: Dec 30, 2003
Posts: 283
PostPosted: Thu Oct 07, 2004 10:44 am Reply with quoteBack to top
hhg wrote:
where can I get mytop? thx.

Justin


You could try typing it into google Smile here it is: http://jeremy.zawodny.com/mysql/mytop/

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


Joined: Jan 18, 2004
Posts: 129
PostPosted: Thu Oct 07, 2004 5:14 pm Reply with quoteBack to top
k thx

_________________
Image
Find all posts by hhgView user's profileSend private messageSend e-mailVisit poster's websiteYahoo MessengerMSN Messenger
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view Nuke Cops Forum Index » Speed Freaks
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
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.212 Seconds - 176 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::