292 Part III . (Web host forum) Administration contained within one
292 Part III . Administration contained within one program aptly titled crash-me, and also in the sql-bench directory. In the next section I ll look at some of the benchmarking applications included with MySQL. Tip Even with the tests and benchmarking, you still need a way to simulate a real- world load on a database server. A program called Super-smack does that job; you can use it to try out various values as you set parameters until you get the ones that work best for your configuration. Super-smack is available for free from MySQL AB. To get Super-smack, go to the Contributed Software section of the MySQL Web site http://www.mysql.com/downloads/contrib.html. . Sample configuration files let you try out different-size implementations. Look for these sample configs in the support-filesdirectory of your MySQL installation. Four sample configuration files are included: my-small.cnf my-medium.cnf my-large.cnf my-hugr.cnf The sample configuration files are covered in detail later in this chapter. MySQL Benchmarking and Testing Included with the MySQL software are applications and scripts for testing the limits and variables of the MySQL server. These tests can help to improve performance by showing obvious bottlenecks on the actual hardware with close to real-world scenarios. Using specific tests you can simulate how your server will be used and see what improvements must be made. I ve had times where running the tests saved me from implementing a server on hardware that couldn t stand up to the load for the application to be run. Requirements for the applications The Benchmark and Crash-me applications use a number of different types of statements and functions. The applications are included with Binary installations of MySQL and MySQL-Max as well as with the MySQL source code. To use the applications from an RPM-based installation, make sure you install the mysql-bench RPM (in addition to the other MySQL RPMs). Additional requirements for the benchmarking and Crash-me applications are as follows: . Perl . Perl-DBI . Msql-Mysql-modules
Please visit our professional web hosting services to find out about cheap and reliable webhost service that will surely answer all your demands.