Chapter 11 . (Windows 2003 server web) Server Configurations 295 Caution Running
Chapter 11 . Server Configurations 295 Caution Running the testing suite can cause performance problems on the MySQL server. I recommend against running the testing suite during peak usage or in a production environment. Currently the tests are not multithreaded; they open one connection at a time to the MySQL server. This does limit the ability of the tests to truly simulate a real- world environment where multiple users or threads frequently use the database simultaneously. In future versions, MySQL AB will add to the testing suite to run multiple threads. If the tests are taking an incredibly long time and you think something may have gone wrong, you can check the progress of the tests with a couple commands on the MySQL server. Running the SHOW PROCESSLIST statement or mysqladminprocesslist command will a single thread running for the tests, as shown in Figure 11-4. Note the different values in the Info field as the testing suite runs INSERT statements. Figure 11-4: The mysqladmin processlist shows the progress of the testing suite, in this instance the INSERT tests. Because the tests simulate so many different applications and implementations, if you know you re going to have an INSERT-heavy application, you can limit the testing to just the INSERTtest. Then, by tweaking variables to improve INSERT performance and rerunning the test, you can see whether you get a noticeable performance improvement from the new settings.
Please visit our professional web hosting services to find out about cheap and reliable webhost service that will surely answer all your demands.