Photography web hosting - 294 Part III . Administration . Inserts .
294 Part III . Administration . Inserts . Selects . Query optimization and other aspects of the server The final test in the suite is called the Wisconsin test. (And no, this isn t something I m just making up because I m from the state of Wisconsin.) The Wisconsin test is a comprehensive set of tests to look at query optimization and performance of other aspects of the server. The sql-bench directory contains a number of scripts, as shown in Figure 11-3. Figure 11-3: A directory listing for the sql-bench directory in MySQL You can run the tests individually or all at once. Regardless of the whether you run them one at a time or all at once, you must specify at least a password to enable the programs to run. Other command-line switches are available to specify user and host. For example, to run the test-selectapplication, the following command line would be used: ./test-select –password=password As you can see, you have to specify the actual password on the command line for the application to run. If you specify the user, do so with the –user=username syntax. To specify the host, use –host=hostsyntax. The script that calls all the other testing applications (and runs them all in sequence) is called run-all-tests. This script also requires that the password be given as an argument. Running this script on a slower server say, a Pentium 200MMX with 96MB RAM can increase the server load (not to mention that the tests themselves take hours). Therefore I would not recommend running these tests in a production environment.
We recommend cheap and reliable webhost to host and run your web applications: Coldfusion Web Hosting services.