Chapter 11 . Server Configurations 293 All the (Linux web host)

Chapter 11 . Server Configurations 293 All the latest copies of the Perl-DBI and the Msql-Mysql-modules can be found on CPAN, http://www.cpan.org. Perl is normally included with Linux, though you may not have installed it when you installed the operating system. Follow the instructions included with the Perl- DBI for installation of the software. The Msql-Mysql-modules ask some relevant questions during the installation, see Figure 11-2. Figure 11-2: Running Makefile.PL for the Msql-Mysql-modules poses some questions about how you would like to configure the modules. How you answer the questions for installation largely depends on how you intend to use the modules, and whether you have a previous version installed. If you intend to use mSQL through a Perl application, you may want to consider installing the module for that in addition to the MySQL module. In Figure 11-2, I simply select MySQL because I don t plan to use mSQL, via Perl or otherwise, for the examples. Running the tests Once you have the prerequisites installed you can run the Benchmark applications and Crash-me tests. The applications are located in the sql-bench directory in your MySQL server directory. The Benchmarking suite includes various tests for different types of applications to look at different aspects of server performance in particular, how it handles some crucial aspects of database operation: . Big tables . Alteration of tables . Connections . Creation of tables
Go visit our java server pages services for a reliable, lowcost webhost to satisfy all your needs.

Leave a Reply