1
.\" Title: \fBmysql\-test\-run.pl\fR
3
.\" Generator: DocBook XSL Stylesheets v1.70.1 <http://docbook.sf.net/>
2
.\" Title: \fBmysql-test-run.pl\fR
3
.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4
.\" Generator: DocBook XSL Stylesheets v1.75.1 <http://docbook.sf.net/>
5
6
.\" Manual: MySQL Database System
8
.TH "\fBMYSQL\-TEST\-RUN.PL" "1" "03/27/2009" "MySQL" "MySQL Database System"
10
.TH "\FBMYSQL\-TEST\-RUN\" "1" "07/14/2009" "MySQL" "MySQL Database System"
11
.\" -----------------------------------------------------------------
12
.\" * set default formatting
13
.\" -----------------------------------------------------------------
9
14
.\" disable hyphenation
11
16
.\" disable justification (adjust text to left margin only)
18
.\" -----------------------------------------------------------------
19
.\" * MAIN CONTENT STARTS HERE *
20
.\" -----------------------------------------------------------------
14
mysql\-test\-run.pl \- run MySQL test suite
23
mysql-test-run.pl \- run MySQL test suite
17
\fBmysql\-test\-run.pl [\fR\fB\fIoptions\fR\fR\fB]\fR
25
.HP \w'\fBmysql\-test\-run\&.pl\ [\fR\fB\fIoptions\fR\fR\fB]\fR\ 'u
26
\fBmysql\-test\-run\&.pl [\fR\fB\fIoptions\fR\fR\fB]\fR
21
\fBmysql\-test\-run.pl\fR
22
Perl script is the main application used to run the MySQL test suite. It invokes
30
\fBmysql\-test\-run\&.pl\fR
31
Perl script is the main application used to run the MySQL test suite\&. It invokes
24
to run individual test cases. (Prior to MySQL 4.1, a similar shell script,
25
\fBmysql\-test\-run\fR, can be used instead.)
33
to run individual test cases\&. (Prior to MySQL 4\&.1, a similar shell script,
34
\fBmysql\-test\-run\fR, can be used instead\&.)
28
\fBmysql\-test\-run.pl\fR
37
\fBmysql\-test\-run\&.pl\fR
31
40
directory like this:
35
shell> \fBmysql\-test\-run.pl [\fR\fB\fIoptions\fR\fR\fB] [\fR\fB\fItest_name\fR\fR\fB] ...\fR
46
shell> \fBmysql\-test\-run\&.pl [\fR\fB\fIoptions\fR\fR\fB] [\fR\fB\fItest_name\fR\fR\fB] \&.\&.\&.\fR
41
argument names a test case. The test case file that corresponds to the test name is
42
\fIt/\fR\fI\fItest_name\fR\fR\fI.test\fR.
54
argument names a test case\&. The test case file that corresponds to the test name is
55
t/\fItest_name\fR\&.test\&.
47
\fBmysql\-test\-run.pl\fR
48
runs the named test case. With no
60
\fBmysql\-test\-run\&.pl\fR
61
runs the named test case\&. With no
51
\fBmysql\-test\-run.pl\fR
64
\fBmysql\-test\-run\&.pl\fR
58
71
If no suffix is given for the test name, a suffix of
60
is assumed. Any leading path name is ignored. These commands are equivalent:
73
is assumed\&. Any leading path name is ignored\&. These commands are equivalent:
64
shell> \fBmysql\-test\-run.pl mytest\fR
65
shell> \fBmysql\-test\-run.pl mytest.test\fR
66
shell> \fBmysql\-test\-run.pl t/mytest.test\fR
79
shell> \fBmysql\-test\-run\&.pl mytest\fR
80
shell> \fBmysql\-test\-run\&.pl mytest\&.test\fR
81
shell> \fBmysql\-test\-run\&.pl t/mytest\&.test\fR
70
As of MySQL 5.1.23, a suite name can be given as part of the test name. That is, the syntax for naming a test is:
87
As of MySQL 5\&.1\&.23, a suite name can be given as part of the test name\&. That is, the syntax for naming a test is:
74
[\fIsuite_name\fR.]\fItest_name\fR[.\fIsuffix\fR]
93
[\fIsuite_name\fR\&.]\fItest_name\fR[\&.\fIsuffix\fR]
78
99
If a suite name is given,
79
\fBmysql\-test\-run.pl\fR
80
looks in that suite for the test. With no suite name,
81
\fBmysql\-test\-run.pl\fR
82
looks in the default list of suites for a match and runs the test in any suites where it finds the test. Suppose that the default suite list is
100
\fBmysql\-test\-run\&.pl\fR
101
looks in that suite for the test\&. With no suite name,
102
\fBmysql\-test\-run\&.pl\fR
103
looks in the default list of suites for a match and runs the test in any suites where it finds the test\&. Suppose that the default suite list is
85
106
rpl, and that a test
91
suites. With an argument of
112
suites\&. With an argument of
95
\fBmysql\-test\-run.pl\fR
116
\fBmysql\-test\-run\&.pl\fR
104
125
To run a family of test cases for which the names share a common prefix, use the
105
126
\fB\-\-do\-test=\fR\fB\fIprefix\fR\fR
127
option\&. For example,
107
128
\fB\-\-do\-test=rpl\fR
108
129
runs the replication tests (test cases that have names beginning with
110
131
\fB\-\-skip\-test\fR
111
has the opposite effect of skipping test cases for which the names share a common prefix.
132
has the opposite effect of skipping test cases for which the names share a common prefix\&.
113
As of MySQL 5.0.54/5.1.23/6.0.5, the argument for the
134
As of MySQL 5\&.0\&.54/5\&.1\&.23/6\&.0\&.5, the argument for the
114
135
\fB\-\-do\-test\fR
116
137
\fB\-\-skip\-test\fR
117
options allows more flexible specification of which tests to perform or skip. If the argument contains a pattern metacharacter other than a lone period, it is interpreted as a Perl regular expression and applies to test names that match the pattern. If the argument contains a lone period or does not contain any pattern metacharacters, it is interpreted the same way as previously and matches test names that begin with the argument value. For example,
138
options allows more flexible specification of which tests to perform or skip\&. If the argument contains a pattern metacharacter other than a lone period, it is interpreted as a Perl regular expression and applies to test names that match the pattern\&. If the argument contains a lone period or does not contain any pattern metacharacters, it is interpreted the same way as previously and matches test names that begin with the argument value\&. For example,
118
139
\fB\-\-do\-test=testa\fR
119
140
matches tests that begin with
121
\fB\-\-do\-test=main.testa\fR
142
\fB\-\-do\-test=main\&.testa\fR
122
143
matches tests in the
124
145
test suite that begin with
126
\fB\-\-do\-test=main.*testa\fR
147
\fB\-\-do\-test=main\&.*testa\fR
127
148
matches test names that contain
131
with anything in between. In the latter case, the pattern match is not anchored to the beginning of the test name, so it also matches names such as
152
with anything in between\&. In the latter case, the pattern match is not anchored to the beginning of the test name, so it also matches names such as
134
155
To perform setup prior to running tests,
135
\fBmysql\-test\-run.pl\fR
156
\fBmysql\-test\-run\&.pl\fR
377
\fB\-\-ps\-protocol\fR).
549
\fB\-\-ps\-protocol\fR)\&.
560
.\" mysql-test-run.pl: ddd option
561
.\" ddd option: mysql-test-run.pl
579
.\" mysql-test-run.pl: debug option
580
.\" debug option: mysql-test-run.pl
391
Dump trace output for all clients and servers.
583
Dump trace output for all clients and servers\&.
594
.\" mysql-test-run.pl: debugger option
595
.\" debugger option: mysql-test-run.pl
394
596
\fB\-\-debugger\fR
398
using the named debugger.
600
using the named debugger\&.
611
.\" mysql-test-run.pl: debug-sync-timeout option
612
.\" debug-sync-timeout option: mysql-test-run.pl
401
613
\fB\-\-debug\-sync\-timeout=\fR\fB\fIN\fR\fR
403
Controls whether the Debug Sync facility for testing and debugging is enabled. The option value is a timeout in seconds. The default value is 300. A value of 0 disables Debug Sync. The value of this option also becomes the default timeout for individual synchronization points.
615
Controls whether the Debug Sync facility for testing and debugging is enabled\&. The option value is a timeout in seconds\&. The default value is 300\&. A value of 0 disables Debug Sync\&. The value of this option also becomes the default timeout for individual synchronization points\&.
405
\fBmysql\-test\-run.pl\fR
617
\fBmysql\-test\-run\&.pl\fR
407
619
\fB\-\-loose\-debug\-sync\-timeout=\fR\fB\fIN\fR\fR
411
623
prefix is used so that
413
does not fail if Debug Sync is not compiled in.
625
does not fail if Debug Sync is not compiled in\&.
415
627
For information about using the Debug Sync facility for testing, see
416
Section\ 4.14, \(lqThread Synchronization in Test Cases\(rq.
418
This option was added in MySQL 6.0.6.
628
Section\ \&4.14, \(lqThread Synchronization in Test Cases\(rq\&.
630
This option was added in MySQL 6\&.0\&.6\&.
641
.\" mysql-test-run.pl: do-test option
642
.\" do-test option: mysql-test-run.pl
421
643
\fB\-\-do\-test=\fR\fB\fIprefix\fR\fR
423
645
Run all test cases having a name that begins with the given
425
value. This option provides a convenient way to run a family of similarly named tests.
647
value\&. This option provides a convenient way to run a family of similarly named tests\&.
427
As of MySQL 5.0.54/5.1.23/6.0.5, the argument for the
649
As of MySQL 5\&.0\&.54/5\&.1\&.23/6\&.0\&.5, the argument for the
428
650
\fB\-\-do\-test\fR
429
option allows more flexible specification of which tests to perform. If the argument contains a pattern metacharacter other than a lone period, it is interpreted as a Perl regular expression and applies to test names that match the pattern. If the argument contains a lone period or does not contain any pattern metacharacters, it is interpreted the same way as previously and matches test names that begin with the argument value. For example,
651
option allows more flexible specification of which tests to perform\&. If the argument contains a pattern metacharacter other than a lone period, it is interpreted as a Perl regular expression and applies to test names that match the pattern\&. If the argument contains a lone period or does not contain any pattern metacharacters, it is interpreted the same way as previously and matches test names that begin with the argument value\&. For example,
430
652
\fB\-\-do\-test=testa\fR
431
653
matches tests that begin with
433
\fB\-\-do\-test=main.testa\fR
655
\fB\-\-do\-test=main\&.testa\fR
434
656
matches tests in the
436
658
test suite that begin with
438
\fB\-\-do\-test=main.*testa\fR
660
\fB\-\-do\-test=main\&.*testa\fR
439
661
matches test names that contain
443
with anything in between. In the latter case, the pattern match is not anchored to the beginning of the test name, so it also matches names such as
665
with anything in between\&. In the latter case, the pattern match is not anchored to the beginning of the test name, so it also matches names such as
677
.\" mysql-test-run.pl: embedded-server option
678
.\" embedded-server option: mysql-test-run.pl
447
679
\fB\-\-embedded\-server\fR
451
built with the embedded server.
683
built with the embedded server\&.
694
.\" mysql-test-run.pl: experimental option
695
.\" experimental option: mysql-test-run.pl
454
696
\fB\-\-experimental=\fR\fB\fIfile_name\fR\fR
456
698
Specify a file that contains a list of test cases that should be displayed with the
460
if they fail. This option was added in MySQL 5.1.33/6.0.11.
702
if they fail\&. This option was added in MySQL 5\&.1\&.33/6\&.0\&.11\&.
713
.\" mysql-test-run.pl: extern option
714
.\" extern option: mysql-test-run.pl
465
Use an already running server.
717
Use an already running server\&.
467
719
Note: If a test case has an
469
file that requires the server to be restarted with specific options, the file will not be used. The test case likely will fail as a result.
721
file that requires the server to be restarted with specific options, the file will not be used\&. The test case likely will fail as a result\&.
732
.\" mysql-test-run.pl: fast option
733
.\" fast option: mysql-test-run.pl
474
Do not clean up from earlier test runs.
736
Do not clean up from earlier test runs\&.
747
.\" mysql-test-run.pl: force option
748
.\" force option: mysql-test-run.pl
480
\fBmysql\-test\-run.pl\fR
481
exits if a test case fails.
752
\fBmysql\-test\-run\&.pl\fR
753
exits if a test case fails\&.
483
causes execution to continue regardless of test case failure.
755
causes execution to continue regardless of test case failure\&.
766
.\" mysql-test-run.pl: gcov option
767
.\" gcov option: mysql-test-run.pl
488
770
Run tests with the
772
test coverage tool\&.
783
.\" mysql-test-run.pl: gdb option
784
.\" gdb option: mysql-test-run.pl
802
.\" mysql-test-run.pl: gprof option
803
.\" gprof option: mysql-test-run.pl
504
806
Run tests with the
819
.\" mysql-test-run.pl: im-mysqld1-port option
820
.\" im-mysqld1-port option: mysql-test-run.pl
509
821
\fB\-\-im\-mysqld1\-port\fR
511
823
TCP/IP port number to use for the first
512
\fBmysqld\fR, controlled by Instance Manager.
824
\fBmysqld\fR, controlled by Instance Manager\&.
835
.\" mysql-test-run.pl: im-mysqld2-port option
836
.\" im-mysqld2-port option: mysql-test-run.pl
515
837
\fB\-\-im\-mysqld2\-port\fR
517
839
TCP/IP port number to use for the second
518
\fBmysqld\fR, controlled by Instance Manager.
840
\fBmysqld\fR, controlled by Instance Manager\&.
851
.\" mysql-test-run.pl: im-port option
852
.\" im-port option: mysql-test-run.pl
521
853
\fB\-\-im\-port\fR
523
855
TCP/IP port number to use for
524
\fBmysqld\fR, controlled by Instance Manager.
856
\fBmysqld\fR, controlled by Instance Manager\&.
867
.\" mysql-test-run.pl: log-warnings option
868
.\" log-warnings option: mysql-test-run.pl
527
869
\fB\-\-log\-warnings\fR
530
872
\fB\-\-log\-warnings\fR
885
.\" mysql-test-run.pl: manual-debug option
886
.\" manual-debug option: mysql-test-run.pl
535
887
\fB\-\-manual\-debug\fR
537
Use a server that has already been started by the user in a debugger.
889
Use a server that has already been started by the user in a debugger\&.
900
.\" mysql-test-run.pl: manual-gdb option
901
.\" manual-gdb option: mysql-test-run.pl
540
902
\fB\-\-manual\-gdb\fR
542
904
Use a server that has already been started by the user in the
917
.\" mysql-test-run.pl: master-binary option
918
.\" master-binary option: mysql-test-run.pl
547
919
\fB\-\-master\-binary=\fR\fB\fIpath\fR\fR
549
921
Specify the path of the
551
binary to use for master servers.
923
binary to use for master servers\&.
934
.\" mysql-test-run.pl: master_port option
935
.\" master_port option: mysql-test-run.pl
554
936
\fB\-\-master_port=\fR\fB\fIport_num\fR\fR
556
Specify the TCP/IP port number for the first master server to use. Observe that the option name has an underscore and not a dash.
938
Specify the TCP/IP port number for the first master server to use\&. Observe that the option name has an underscore and not a dash\&.
949
.\" mysql-test-run.pl: mem option
950
.\" mem option: mysql-test-run.pl
561
Run the test suite in memory, using tmpfs or ramdisk. This can decrease test times significantly.
562
\fBmysql\-test\-run.pl\fR
953
Run the test suite in memory, using tmpfs or ramdisk\&. This can decrease test times significantly\&.
954
\fBmysql\-test\-run\&.pl\fR
563
955
attempts to find a suitable location using a built\-in list of standard locations for tmpfs and puts the
565
directory there. This option also affects placement of temporary files, which are created in
957
directory there\&. This option also affects placement of temporary files, which are created in
568
960
The default list includes
569
\fI/dev/shm\fR. You can also enable this option by setting the environment variable
570
MTR_MEM[=\fIdir_name\fR]. If
961
/dev/shm\&. You can also enable this option by setting the environment variable
962
MTR_MEM[=\fIdir_name\fR]\&. If
572
is given, it is added to the beginning of the list of locations to search, so it takes precedence over any built\-in locations.
574
This option was added in MySQL 4.1.22, 5.0.30, and 5.1.13.
964
is given, it is added to the beginning of the list of locations to search, so it takes precedence over any built\-in locations\&.
966
This option was added in MySQL 4\&.1\&.22, 5\&.0\&.30, and 5\&.1\&.13\&.
977
.\" mysql-test-run.pl: mysqld option
978
.\" mysqld option: mysql-test-run.pl
577
979
\fB\-\-mysqld=\fR\fB\fIvalue\fR\fR
579
981
Extra options to pass to
580
\fBmysqld\fR. The value should consist of one or more comma\-separated
982
\fBmysqld\fR\&. The value should consist of one or more comma\-separated
583
Section\ 4.9, \(lqPassing Options from \fBmysql\-test\-run.pl\fR to \fBmysqld\fR or \fBmysqltest\fR\(rq.
985
Section\ \&4.9, \(lqPassing Options from mysql-test-run.pl to mysqld or mysqltest\(rq\&.
996
.\" mysql-test-run.pl: mysqltest option
997
.\" mysqltest option: mysql-test-run.pl
586
998
\fB\-\-mysqltest=\fR\fB\fIvalue\fR\fR
588
1000
Extra options to pass to
589
\fBmysqltest\fR. The value should consist of one or more comma\-separated
1001
\fBmysqltest\fR\&. The value should consist of one or more comma\-separated
592
Section\ 4.9, \(lqPassing Options from \fBmysql\-test\-run.pl\fR to \fBmysqld\fR or \fBmysqltest\fR\(rq. This option was added in MySQL 6.0.6.
1004
Section\ \&4.9, \(lqPassing Options from mysql-test-run.pl to mysqld or mysqltest\(rq\&. This option was added in MySQL 6\&.0\&.6\&.
1009
\h'-04'\(bu\h'+03'\c
1015
.\" mysql-test-run.pl: ndb-connectstring option
1016
.\" ndb-connectstring option: mysql-test-run.pl
595
1017
\fB\-\-ndb\-connectstring=\fR\fB\fIstr\fR\fR
598
1020
\fB\-\-ndb\-connectstring=\fR\fB\fIstr\fR\fR
599
to the master MySQL server. This option also prevents
600
\fBmysql\-test\-run.pl\fR
601
from starting a cluster. It is assumed that there is already a cluster running to which the server can connect with the given connectstring.
1021
to the master MySQL server\&. This option also prevents
1022
\fBmysql\-test\-run\&.pl\fR
1023
from starting a cluster\&. It is assumed that there is already a cluster running to which the server can connect with the given connectstring\&.
1028
\h'-04'\(bu\h'+03'\c
1034
.\" mysql-test-run.pl: ndb-connectstring-slave option
1035
.\" ndb-connectstring-slave option: mysql-test-run.pl
604
1036
\fB\-\-ndb\-connectstring\-slave=\fR\fB\fIstr\fR\fR
607
1039
\fB\-\-ndb\-connectstring=\fR\fB\fIstr\fR\fR
608
to slave MySQL servers. This option also prevents
609
\fBmysql\-test\-run.pl\fR
610
from starting a cluster. It is assumed that there is already a cluster running to which the server can connect with the given connectstring.
1040
to slave MySQL servers\&. This option also prevents
1041
\fBmysql\-test\-run\&.pl\fR
1042
from starting a cluster\&. It is assumed that there is already a cluster running to which the server can connect with the given connectstring\&.
1047
\h'-04'\(bu\h'+03'\c
1053
.\" mysql-test-run.pl: ndb-extra-test option
1054
.\" ndb-extra-test option: mysql-test-run.pl
613
1055
\fB\-\-ndb\-extra\-test\fR
1062
\h'-04'\(bu\h'+03'\c
1068
.\" mysql-test-run.pl: ndbcluster-port option
1069
.\" ndbcluster-port option: mysql-test-run.pl
1070
.\" mysql-test-run.pl: ndbcluster_port option
1071
.\" ndbcluster_port option: mysql-test-run.pl
618
1072
\fB\-\-ndbcluster\-port=\fR\fB\fIport_num\fR\fR,
619
1073
\fB\-\-ndbcluster_port=\fR\fB\fIport_num\fR\fR
621
Specify the TCP/IP port number that NDB Cluster should use.
1075
Specify the TCP/IP port number that NDB Cluster should use\&.
1080
\h'-04'\(bu\h'+03'\c
1086
.\" mysql-test-run.pl: ndbcluster-port-slave option
1087
.\" ndbcluster-port-slave option: mysql-test-run.pl
624
1088
\fB\-\-ndbcluster\-port\-slave=\fR\fB\fIport_num\fR\fR
626
Specify the TCP/IP port number that the slave NDB Cluster should use.
1090
Specify the TCP/IP port number that the slave NDB Cluster should use\&.
1095
\h'-04'\(bu\h'+03'\c
1101
.\" mysql-test-run.pl: netware option
1102
.\" netware option: mysql-test-run.pl
629
1103
\fB\-\-netware\fR
633
with options needed on NetWare.
1107
with options needed on NetWare\&.
1112
\h'-04'\(bu\h'+03'\c
1118
.\" mysql-test-run.pl: notimer option
1119
.\" notimer option: mysql-test-run.pl
636
1120
\fB\-\-notimer\fR
640
not to generate a timing file.
643
\fB\-\-ps\-protocol\fR
646
\fB\-\-ps\-protocol\fR
656
\fBmysqltest\fR. This option requires a specific test case to be named on the command line.
1124
not to generate a timing file\&.
1129
\h'-04'\(bu\h'+03'\c
1135
.\" mysql-test-run.pl: ps-protocol option
1136
.\" ps-protocol option: mysql-test-run.pl
1137
\fB\-\-ps\-protocol\fR
1140
\fB\-\-ps\-protocol\fR
1147
\h'-04'\(bu\h'+03'\c
1153
.\" mysql-test-run.pl: record option
1154
.\" record option: mysql-test-run.pl
1160
\fBmysqltest\fR\&. This option requires a specific test case to be named on the command line\&.
1165
\h'-04'\(bu\h'+03'\c
1171
.\" mysql-test-run.pl: reorder option
1172
.\" reorder option: mysql-test-run.pl
659
1173
\fB\-\-reorder\fR
661
Reorder tests to minimize the number of server restarts needed.
1175
Reorder tests to minimize the number of server restarts needed\&.
1180
\h'-04'\(bu\h'+03'\c
1186
.\" mysql-test-run.pl: report-features option
1187
.\" report-features option: mysql-test-run.pl
664
1188
\fB\-\-report\-features\fR
666
1190
Display the output of
669
SHOW VARIABLES. This can be used to verify that binaries are built with all required features.
671
This option was added in MySQL 4.1.23, 5.0.30, and 5.1.14.
1193
SHOW VARIABLES\&. This can be used to verify that binaries are built with all required features\&.
1195
This option was added in MySQL 4\&.1\&.23, 5\&.0\&.30, and 5\&.1\&.14\&.
1200
\h'-04'\(bu\h'+03'\c
1206
.\" mysql-test-run.pl: script-debug option
1207
.\" script-debug option: mysql-test-run.pl
674
1208
\fB\-\-script\-debug\fR
676
1210
Enable debug output for
677
\fBmysql\-test\-run.pl\fR
1211
\fBmysql\-test\-run\&.pl\fR
1217
\h'-04'\(bu\h'+03'\c
1223
.\" mysql-test-run.pl: skip-im option
1224
.\" skip-im option: mysql-test-run.pl
681
1225
\fB\-\-skip\-im\fR
683
Do not start Instance Manager; skip Instance Manager test cases.
1227
Do not start Instance Manager; skip Instance Manager test cases\&.
1232
\h'-04'\(bu\h'+03'\c
1238
.\" mysql-test-run.pl: skip-master-binlog option
1239
.\" skip-master-binlog option: mysql-test-run.pl
686
1240
\fB\-\-skip\-master\-binlog\fR
688
Do not enable master server binary logging.
1242
Do not enable master server binary logging\&.
1247
\h'-04'\(bu\h'+03'\c
1253
.\" mysql-test-run.pl: skip-ndbcluster option
1254
.\" skip-ndbcluster option: mysql-test-run.pl
691
1255
\fB\-\-skip\-ndbcluster\fR,
1256
.\" mysql-test-run.pl: skip-ndb option
1257
.\" skip-ndb option: mysql-test-run.pl
692
1258
\fB\-\-skip\-ndb\fR
694
Do not start NDB Cluster; skip Cluster test cases.
1260
Do not start NDB Cluster; skip Cluster test cases\&.
1265
\h'-04'\(bu\h'+03'\c
1271
.\" mysql-test-run.pl: skip-ndbcluster-slave option
1272
.\" skip-ndbcluster-slave option: mysql-test-run.pl
697
1273
\fB\-\-skip\-ndbcluster\-slave\fR,
1274
.\" mysql-test-run.pl: skip-ndb-slave option
1275
.\" skip-ndb-slave option: mysql-test-run.pl
698
1276
\fB\-\-skip\-ndb\-slave\fR
700
Do not start an NDB Cluster slave.
1278
Do not start an NDB Cluster slave\&.
1283
\h'-04'\(bu\h'+03'\c
1289
.\" mysql-test-run.pl: skip-rpl option
1290
.\" skip-rpl option: mysql-test-run.pl
703
1291
\fB\-\-skip\-rpl\fR
705
Skip replication test cases.
1293
Skip replication test cases\&.
1298
\h'-04'\(bu\h'+03'\c
1304
.\" mysql-test-run.pl: skip-slave-binlog option
1305
.\" skip-slave-binlog option: mysql-test-run.pl
708
1306
\fB\-\-skip\-slave\-binlog\fR
710
Do not enable master server binary logging.
1308
Do not enable master server binary logging\&.
1313
\h'-04'\(bu\h'+03'\c
1319
.\" mysql-test-run.pl: skip-ssl option
1320
.\" skip-ssl option: mysql-test-run.pl
713
1321
\fB\-\-skip\-ssl\fR
717
with support for SSL connections.
1325
with support for SSL connections\&.
1330
\h'-04'\(bu\h'+03'\c
1336
.\" mysql-test-run.pl: skip-test option
1337
.\" skip-test option: mysql-test-run.pl
720
1338
\fB\-\-skip\-test=\fR\fB\fIregex\fR\fR
722
Specify a regular expression to be applied to test case names. Cases with names that match the expression are skipped. tests to skip.
1340
Specify a regular expression to be applied to test case names\&. Cases with names that match the expression are skipped\&. tests to skip\&.
724
As of MySQL 5.0.54/5.1.23/6.0.5, the argument for the
1342
As of MySQL 5\&.0\&.54/5\&.1\&.23/6\&.0\&.5, the argument for the
725
1343
\fB\-\-skip\-test\fR
726
option allows more flexible specification of which tests to skip. If the argument contains a pattern metacharacter other than a lone period, it is interpreted as a Perl regular expression and applies to test names that match the pattern. See the description of the
1344
option allows more flexible specification of which tests to skip\&. If the argument contains a pattern metacharacter other than a lone period, it is interpreted as a Perl regular expression and applies to test names that match the pattern\&. See the description of the
727
1345
\fB\-\-do\-test\fR
1346
option for details\&.
1351
\h'-04'\(bu\h'+03'\c
731
1357
\fB\-\-skip\-*\fR
733
1359
\fB\-\-skip\-*\fR
734
1360
options not otherwise recognized by
735
\fBmysql\-test\-run.pl\fR
736
are passed to the master server.
1361
\fBmysql\-test\-run\&.pl\fR
1362
are passed to the master server\&.
1367
\h'-04'\(bu\h'+03'\c
1373
.\" mysql-test-run.pl: slave-binary option
1374
.\" slave-binary option: mysql-test-run.pl
739
1375
\fB\-\-slave\-binary=\fR\fB\fIpath\fR\fR
741
1377
Specify the path of the
743
binary to use for slave servers.
1379
binary to use for slave servers\&.
1384
\h'-04'\(bu\h'+03'\c
1390
.\" mysql-test-run.pl: slave_port option
1391
.\" slave_port option: mysql-test-run.pl
746
1392
\fB\-\-slave_port=\fR\fB\fIport_num\fR\fR
748
Specify the TCP/IP port number for the first master server to use. Observe that the option name has an underscore and not a dash.
1394
Specify the TCP/IP port number for the first master server to use\&. Observe that the option name has an underscore and not a dash\&.
1399
\h'-04'\(bu\h'+03'\c
1405
.\" mysql-test-run.pl: sleep option
1406
.\" sleep option: mysql-test-run.pl
751
1407
\fB\-\-sleep=\fR\fB\fIN\fR\fR
754
1410
\fB\-\-sleep=\fR\fB\fIN\fR\fR
1417
\h'-04'\(bu\h'+03'\c
1423
.\" mysql-test-run.pl: small-bench option
1424
.\" small-bench option: mysql-test-run.pl
759
1425
\fB\-\-small\-bench\fR
761
1427
Run the benchmarks with the
762
1428
\fB\-\-small\-tests\fR
764
1430
\fB\-\-small\-tables\fR
1436
\h'-04'\(bu\h'+03'\c
1442
.\" mysql-test-run.pl: socket option
1443
.\" socket option: mysql-test-run.pl
768
1444
\fB\-\-socket=\fR\fB\fIfile_name\fR\fR
770
1446
For connections to
771
localhost, the Unix socket file to use, or, on Windows, the name of the named pipe to use.
1447
localhost, the Unix socket file to use, or, on Windows, the name of the named pipe to use\&.
1452
\h'-04'\(bu\h'+03'\c
1458
.\" mysql-test-run.pl: sp-protocol option
1459
.\" sp-protocol option: mysql-test-run.pl
774
1460
\fB\-\-sp\-protocol\fR
777
1463
\fB\-\-sp\-protocol\fR
1470
\h'-04'\(bu\h'+03'\c
1476
.\" mysql-test-run.pl: ssl option
1477
.\" ssl option: mysql-test-run.pl
785
\fBmysql\-test\-run.pl\fR
1481
\fBmysql\-test\-run\&.pl\fR
786
1482
is started with the
788
option, it sets up a secure conection for all test cases. In this case, if
1484
option, it sets up a secure conection for all test cases\&. In this case, if
790
1486
does not support SSL,
791
\fBmysql\-test\-run.pl\fR
1487
\fBmysql\-test\-run\&.pl\fR
792
1488
exits with an error message:
793
Couldn't find support for SSL
1489
Couldn\'t find support for SSL
1494
\h'-04'\(bu\h'+03'\c
1500
.\" mysql-test-run.pl: start option
1501
.\" start option: mysql-test-run.pl
798
Initialize and start servers with the startup settings for the first specified test case. For example:
1504
Initialize and start servers with the startup settings for the first specified test case\&. For example:
802
1510
shell> \fBcd mysql\-test\fR
803
shell> \fB./mysql\-test\-run.pl \-\-start alias &\fR
1511
shell> \fB\&./mysql\-test\-run\&.pl \-\-start alias &\fR
806
This option was added in MySQL 5.1.32/6.0.11.
1517
This option was added in MySQL 5\&.1\&.32/6\&.0\&.11\&.
1522
\h'-04'\(bu\h'+03'\c
1528
.\" mysql-test-run.pl: start-and-exit option
1529
.\" start-and-exit option: mysql-test-run.pl
809
1530
\fB\-\-start\-and\-exit\fR
811
Initialize and start servers with the startup settings for the specified test case or cases, if any, and then exit. You can use this option to start a server to which you can connect later. For example, after building a source distribution you can start a server and connect to it with the
1532
Initialize and start servers with the startup settings for the specified test case or cases, if any, and then exit\&. You can use this option to start a server to which you can connect later\&. For example, after building a source distribution you can start a server and connect to it with the
813
1534
client like this:
817
1540
shell> \fBcd mysql\-test\fR
818
shell> \fB./mysql\-test\-run.pl \-\-start\-and\-exit\fR
819
shell> \fB../mysql \-S ./var/tmp/master.sock \-h localhost \-u root\fR
1541
shell> \fB\&./mysql\-test\-run\&.pl \-\-start\-and\-exit\fR
1542
shell> \fB\&.\&./mysql \-S \&./var/tmp/master\&.sock \-h localhost \-u root\fR
1551
\h'-04'\(bu\h'+03'\c
1557
.\" mysql-test-run.pl: start-dirty option
1558
.\" start-dirty option: mysql-test-run.pl
824
1559
\fB\-\-start\-dirty\fR
826
Start servers (without initialization) for the specified test case or cases, if any, and then exit. You can then manually run the test cases.
1561
Start servers (without initialization) for the specified test case or cases, if any, and then exit\&. You can then manually run the test cases\&.
1566
\h'-04'\(bu\h'+03'\c
1572
.\" mysql-test-run.pl: start-from option
1573
.\" start-from option: mysql-test-run.pl
829
1574
\fB\-\-start\-from=\fR\fB\fItest_name\fR\fR
831
\fBmysql\-test\-run.pl\fR
1576
\fBmysql\-test\-run\&.pl\fR
832
1577
sorts the list of names of the test cases to be run, and then begins with
1583
\h'-04'\(bu\h'+03'\c
1589
.\" mysql-test-run.pl: strace-client option
1590
.\" strace-client option: mysql-test-run.pl
836
1591
\fB\-\-strace\-client\fR
1601
\h'-04'\(bu\h'+03'\c
1607
.\" mysql-test-run.pl: stress option
1608
.\" stress option: mysql-test-run.pl
844
1609
\fB\-\-stress\fR
846
Run the stress test. The other
1611
Run the stress test\&. The other
847
1612
\fB\-\-stress\-\fR\fB\fIxxx\fR\fR
848
options apply in this case.
1613
options apply in this case\&.
1618
\h'-04'\(bu\h'+03'\c
1624
.\" mysql-test-run.pl: stress-init-file option
1625
.\" stress-init-file option: mysql-test-run.pl
851
1626
\fB\-\-stress\-init\-file=\fR\fB\fIfile_name\fR\fR
854
is the location of the file that contains the list of tests. The default file is
855
\fIstress_init.txt\fR
856
in the test suite directory.
1629
is the location of the file that contains the list of tests\&. The default file is
1631
in the test suite directory\&.
1636
\h'-04'\(bu\h'+03'\c
1642
.\" mysql-test-run.pl: stress-loop-count option
1643
.\" stress-loop-count option: mysql-test-run.pl
859
1644
\fB\-\-stress\-loop\-count=\fR\fB\fIN\fR\fR
861
In sequential stress\-test mode, the number of loops to execute before exiting.
1646
In sequential stress\-test mode, the number of loops to execute before exiting\&.
1651
\h'-04'\(bu\h'+03'\c
1657
.\" mysql-test-run.pl: stress-mode option
1658
.\" stress-mode option: mysql-test-run.pl
864
1659
\fB\-\-stress\-mode=\fR\fB\fImode\fR\fR
866
This option indicates the test order in stress\-test mode. The
1661
This option indicates the test order in stress\-test mode\&. The
870
1665
to select tests in random order or
872
to run tests in each thread in the order specified in the test list file. The default mode is
1667
to run tests in each thread in the order specified in the test list file\&. The default mode is
1673
\h'-04'\(bu\h'+03'\c
1679
.\" mysql-test-run.pl: stress-suite option
1680
.\" stress-suite option: mysql-test-run.pl
876
1681
\fB\-\-stress\-suite=\fR\fB\fIsuite_name\fR\fR
878
The name of the test suite to use for stress testing. The default suite name is
1683
The name of the test suite to use for stress testing\&. The default suite name is
880
1685
(the regular test suite located in the
1692
\h'-04'\(bu\h'+03'\c
1698
.\" mysql-test-run.pl: stress-test-count option
1699
.\" stress-test-count option: mysql-test-run.pl
885
1700
\fB\-\-stress\-test\-count=\fR\fB\fIN\fR\fR
887
For stress testing, the number of tests to execute before exiting.
1702
For stress testing, the number of tests to execute before exiting\&.
1707
\h'-04'\(bu\h'+03'\c
1713
.\" mysql-test-run.pl: stress-test-duration option
1714
.\" stress-test-duration option: mysql-test-run.pl
890
1715
\fB\-\-stress\-test\-duration=\fR\fB\fIN\fR\fR
892
For stress testing, the duration of stress testing in seconds.
1717
For stress testing, the duration of stress testing in seconds\&.
1722
\h'-04'\(bu\h'+03'\c
1728
.\" mysql-test-run.pl: stress-test-file option
1729
.\" stress-test-file option: mysql-test-run.pl
895
1730
\fB\-\-stress\-test\-file=\fR\fB\fIfile_name\fR\fR
897
The file that contains the list of tests to use in stress testing. The tests should be named without the
899
extension. The default file is
900
\fIstress_tests.txt\fR
901
in the test suite directory.
1732
The file that contains the list of tests to use in stress testing\&. The tests should be named without the
1734
extension\&. The default file is
1736
in the test suite directory\&.
1741
\h'-04'\(bu\h'+03'\c
1747
.\" mysql-test-run.pl: stress-threads option
1748
.\" stress-threads option: mysql-test-run.pl
904
1749
\fB\-\-stress\-threads=\fR\fB\fIN\fR\fR
906
The number of threads to use in stress testing. The default is 5.
1751
The number of threads to use in stress testing\&. The default is 5\&.
1756
\h'-04'\(bu\h'+03'\c
1762
.\" mysql-test-run.pl: suite option
1763
.\" suite option: mysql-test-run.pl
909
1764
\fB\-\-suite=\fR\fB\fIsuite_name\fR\fR
911
Run the named test suite. The default name is
1766
Run the named test suite\&. The default name is
913
1768
(the regular test suite located in the
1775
\h'-04'\(bu\h'+03'\c
1781
.\" mysql-test-run.pl: suite-timeout option
1782
.\" suite-timeout option: mysql-test-run.pl
918
1783
\fB\-\-suite\-timeout=\fR\fB\fIminutes\fR\fR
920
Specify the maximum test suite runtime.
1785
Specify the maximum test suite runtime\&.
1790
\h'-04'\(bu\h'+03'\c
1796
.\" mysql-test-run.pl: testcase-timeout option
1797
.\" testcase-timeout option: mysql-test-run.pl
923
1798
\fB\-\-testcase\-timeout\fR
925
Specify the maximum test case runtime.
1800
Specify the maximum test case runtime\&.
1805
\h'-04'\(bu\h'+03'\c
1811
.\" mysql-test-run.pl: timer option
1812
.\" timer option: mysql-test-run.pl
932
to generate a timing file. The default file is named
933
\fI./var/log/timer\fR.
1817
to generate a timing file\&. The default file is named
1818
\&./var/log/timer\&.
1823
\h'-04'\(bu\h'+03'\c
1829
.\" mysql-test-run.pl: tmpdir option
1830
.\" tmpdir option: mysql-test-run.pl
936
1831
\fB\-\-tmpdir=\fR\fB\fIpath\fR\fR
938
The directory where temporary file are stored. The default location is
1833
The directory where temporary file are stored\&. The default location is
1839
\h'-04'\(bu\h'+03'\c
1845
.\" mysql-test-run.pl: unified-diff option
1846
.\" unified-diff option: mysql-test-run.pl
942
1847
\fB\-\-unified\-diff\fR,
945
Use unified diff format when presenting differences between expected and actual test case results.
1850
Use unified diff format when presenting differences between expected and actual test case results\&.
1855
\h'-04'\(bu\h'+03'\c
1861
.\" mysql-test-run.pl: use-old-data option
1862
.\" use-old-data option: mysql-test-run.pl
948
1863
\fB\-\-use\-old\-data\fR
950
Do not install the test databases. (Use existing ones.)
1865
Do not install the test databases\&. (Use existing ones\&.)
1870
\h'-04'\(bu\h'+03'\c
1876
.\" mysql-test-run.pl: user-test option
1877
.\" user-test option: mysql-test-run.pl
953
1878
\fB\-\-user\-test=\fR\fB\fIval\fR\fR
1885
\h'-04'\(bu\h'+03'\c
1891
.\" mysql-test-run.pl: user option
1892
.\" user option: mysql-test-run.pl
958
1893
\fB\-\-user=\fR\fB\fIuser_name\fR\fR
960
The MySQL user name to use when connecting to the server.
1895
The MySQL user name to use when connecting to the server\&.
1900
\h'-04'\(bu\h'+03'\c
1906
.\" mysql-test-run.pl: valgrind option
1907
.\" valgrind option: mysql-test-run.pl
963
1908
\fB\-\-valgrind\fR