Apache web server tutorial - you press Enter, the mtopdisplay opens, showing the
you press Enter, the mtopdisplay opens, showing the activity on your MySQL server (seeFigure 43-12). Figure 43-12:mtopmonitoring a MySQL Server. Across the top of the display, you see the vital statis- tics on your MySQL server and its activity. The loadaverage, the length of time that the server has beenrunning, and performance indicators are all includedin the statistical information. Type ?while mtopis running to display a list of com- mand options. Here are some of the more usefuloptions: z: Type zand enter a process ID from theprocess list to zoom in on a process. e: Type eand enter a process ID from theprocess list to display the optimizer plan for thequery that is executing. s: Type sand enter the number of secondsbetween screen refreshing. u: Type uand enter a user name to display onlythe server transactions for the named user. q: Type qto quit. If a given query runs for a while, the color progressesfrom white to purple, yellow, and red to indicate thelength of time the query has run. You can use the kInstalling mtopTo install mtop, follow these steps: 1.Open your favorite Web browser and navigate tosourceforge.net/projects/mtop/ 2.Scroll down and click the download link for themost recent mtoprelease. 3.When the download page opens, click the linkto download the most recent tarball. 4.On the mirror page, click the link for the down- load site nearest you. 5.Save the file to your home directory. 6.Open a terminal window and give yourselfsuperuser privileges with the sucommand. 7.Extract the contents of the tarball with the fol- lowing command: # tar -xzvf mtop-0.6.4.tar.gz8.Move into the mtopdirectory: # cd mtop-0.6.49.Now you re ready to compile mtop. Enter thesecommands: # perl Makefile.PL# make# make installmtopis now installed in /usr/local/binand isready to use! Monitoring trafficmtopis a MySQL client application so you must pro- vide a MySQL user name when you run mtop. To startmtop, use the following command: $ ./mtop –dbuser=rootYou can substitute any reasonably privilegeduser for rootin our example.
We would like to recommend you tested and proved virtual web hosting services, which you will surely find to be of great quality.