471,092 Members | 1,566 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.


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).

http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-mytop-ftopict156809.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=524835
Jul 20 '05 #1
0 1137

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Kerberos | last post: by
2 posts views Thread by Sam | last post: by
2 posts views Thread by joerg pfeffer | last post: by
4 posts views Thread by christine.nguyen | last post: by
reply views Thread by Gerald Vogt | last post: by
2 posts views Thread by Jerald Fijerald | last post: by
1 post views Thread by Tony Johansson | last post: by
4 posts views Thread by DaveL | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.