Typically, you run the test suite either from within a source tree
(after MySQL has been built), or on a host where the MySQL server
distribution has been installed. (If you find that the test suite is
not included in your distribution, look for a similar distribution
-test in the name and install that as
To run tests, your current working directory should be the
mysql-test directory of your source tree or
installed distribution. In a source distribution,
mysql-test is under the root of the source
tree. In a binary distribution, the location of
mysql-test depends on the distribution layout.
The program that runs the test suite,
mysql-test-run.pl, will figure out whether you
are in a source tree or an installed directory tree.
To run the test suite, change location into your
mysql-test directory and invoke the
mysql-test-run.pl accepts options on the command line. For example:
./mysql-test-run.pl --force --suite=binlog
By default, mysql-test-run.pl exits if a test
--force causes execution to continue
regardless of test case failure.
For a full list of the supported options, see Section 5.3, “mysql-test-run.pl — Run MySQL Test Suite”.
To run one or more specific test cases, name them on the
mysql-test-run.pl command line. Test case files
have names like
test_name is the name of the test
case, but each name given on the command line should be the test
case name, not the full test case file name. The following command
runs the test case named
rpl_abcd, which has a
test file of
To run a family of test cases for which the names share a common
prefix, use the
For example, the following command runs the events tests (test cases
that have names beginning with
To run a specific named testsuite with all the test cases in it, use
For example, the following command runs the replication tests
located in the
mysql-test-run.pl starts the MySQL server, sets up the environment for calling the mysqltest program, and invokes mysqltest to run the test case. For each test case to be run, mysqltest handles operations such as reading input from the test case file, creating server connections, and sending SQL statements to servers.
The language used in test case files is a mix of commands that the mysqltest program understands and SQL statements. Input that mysqltest doesn't understand is assumed to consist of SQL statements to be sent to the database server. This makes the test case language familiar to those that know how to write SQL and powerful enough to add the control needed to write test cases.
You need not start a MySQL server first before running tests. Instead, the mysql-test-run.pl program will start the server or servers as needed. Any servers started for the test run use ports in the range from 13000 by default.