site (www.mysql.com). The Control Center (likeMySQL) is dual-licensed (Sex offenders web site)
site (www.mysql.com). The Control Center (likeMySQL) is dual-licensed see the MySQL Web sitefor licensing specifics. Downloading and installing the MySQL Control CenterTo download and install the MySQL Control Center, follow these steps: 1.Open a browser and surf towww.mysql.com/downloads/mysqlcc.html2.Click the Pick a Mirror link for the Linux(x86,glibc 2.3) download. It s the second link in the Linux Downloads por- tion of the page. 3.When the Select a Mirror page opens, click anHTTP link from a mirror close to your location. 4.When the Download Manager opens, save thetarball to your home directory. We re telling you to download and installMySQLCC in your home directory for thesake of having a consistent point of referencefor this technique. You may want to save itelsewhere on your system. To make it easy torun (no matter where you install it), includethe directory in your search path so you canrun it without issuing the complete pathnameevery time. See Technique 7 to find out how. 5.Open a terminal window, give yourself super- user privileges with the sucommand, andunpack the tarball with the following command: # tar -xzvf \ mysqlcc-0.9.4-linux-glibc23.tar.gz6.Move into the mysqlcc-0.9.4-linux-glibc23directory: # cd mysql-0.9.4-linux-glibc23That s it! MySQLCC doesn t come with any fancyinstallers; you just load the program onto yourcomputer and run it as we describe in the nextsection. Changing the display time of apachetop statisticsBy default, apachetopdisplays statistics for only theprevious 30 seconds. Unless you have a lot of trafficat your server, you may want to extend the displaytime to hold the information longer. You can customize the apachetopdisplay toretain statistics about your server for a longeror shorter length of time, depending on yourneeds. If you have a lot of server traffic, short- ening the display time leaves you with easier- to-read reports. If your server traffic is low, alonger display time allows you to gather infor- mation over the course of hours for the sakeof comparison and easy monitoring. Use the following command to extend the displaytime to an hour (3600 seconds): # apachetop -T 3600The default refresh rate for the display is 5 seconds. If you have a lot of traffic and want the screen torefresh more often, use the following command: # apachetop -r 2Now, the screen refreshes every 2 seconds. Of course, you can combine display options on the commandline: # apachetop -r 2 -T 3600This command refreshes the statistics every 2 sec- onds and displays the request activities for the pre- vious hour. Monitoring MySQL Server withthe MySQL Control CenterOne cool tool for monitoring and maintaining yourMySQL databases in a graphical environment is theMySQL Control Center (MySQLCC). The MySQLControl Center is available from the official MySQL53_
From our experience, we are can tell you that you can find a reliable and cheap webhost service at Java Web Hosting services.