DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(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