(mysql.info) mysql-benchmarks
Info Catalog
(mysql.info) internal-use
(mysql.info) optimize-overview
(mysql.info) custom-benchmarks
7.1.4 The MySQL Benchmark Suite
-------------------------------
This benchmark suite is meant to tell any user what operations a given
SQL implementation performs well or poorly. You can get a good idea for
how the benchmarks work by looking at the code and results in the
`sql-bench' directory in any MySQL source distribution.
Note that this benchmark is single-threaded, so it measures the minimum
time for the operations performed. We plan to add multi-threaded tests
to the benchmark suite in the future.
To use the benchmark suite, the following requirements must be
satisfied:
* The benchmark suite is provided with MySQL source distributions.
You can either download a released distribution from
`http://dev.mysql.com/downloads/', or use the current development
source tree. (See installing-source-tree.)
* The benchmark scripts are written in Perl and use the Perl DBI
module to access database servers, so DBI must be installed. You
also need the server-specific DBD drivers for each of the servers
you want to test. For example, to test MySQL, PostgreSQL, and DB2,
you must have the `DBD::mysql', `DBD::Pg', and `DBD::DB2' modules
installed. See perl-support.
After you obtain a MySQL source distribution, you can find the
benchmark suite located in its `sql-bench' directory. To run the
benchmark tests, build MySQL, and then change location into the
`sql-bench' directory and execute the `run-all-tests' script:
shell> cd sql-bench
shell> perl run-all-tests --server=SERVER_NAME
SERVER_NAME should be the name of one of the supported servers. To get
a list of all options and supported servers, invoke this command:
shell> perl run-all-tests --help
The `crash-me' script also is located in the `sql-bench' directory.
`crash-me' tries to determine what features a database system supports
and what its capabilities and limitations are by actually running
queries. For example, it determines:
* What data types are supported
* How many indexes are supported
* What functions are supported
* How big a query can be
* How big a `VARCHAR' column can be
You can find the results from `crash-me' for many different database
servers at `http://dev.mysql.com/tech-resources/crash-me.php'. For
more information about benchmark results, visit
`http://dev.mysql.com/tech-resources/benchmarks/'.
Info Catalog
(mysql.info) internal-use
(mysql.info) optimize-overview
(mysql.info) custom-benchmarks
automatically generated byinfo2html