1MYSQL-STRESS-TE(1) MariaDB Database System MYSQL-STRESS-TE(1)
2
3
4
6 mysql-stress-test.pl - server stress test program
7
9 mysql-stress-test.pl [options]
10
12 The mysql-stress-test.pl Perl script performs stress-testing of the
13 MariaDB server.
14
15 mysql-stress-test.pl requires a version of Perl that has been built
16 with threads support.
17
18 Invoke mysql-stress-test.pl like this:
19
20 shell> mysql-stress-test.pl [options]
21
22 mysql-stress-test.pl supports the following options:
23
24 • --help
25
26 Display a help message and exit.
27
28 • --abort-on-error=N
29
30 Causes the program to abort if an error with severity less than or
31 equal to N was encountered. Set to 1 to abort on any error.
32
33 • --check-tests-file
34
35 Periodically check the file that lists the tests to be run. If it
36 has been modified, reread the file. This can be useful if you
37 update the list of tests to be run during a stress test.
38
39 • --cleanup
40
41 Force cleanup of the working directory.
42
43 • --log-error-details
44
45 Log error details in the global error log file.
46
47 • --loop-count=N
48
49 In sequential test mode, the number of loops to execute before
50 exiting.
51
52 • --mysqltest=path
53
54 The path name to the mysqltest program.
55
56 • --server-database=db_name
57
58 The database to use for the tests. The default is test.
59
60 • --server-host=host_name
61
62 The host name of the local host to use for making a TCP/IP
63 connection to the local server. By default, the connection is made
64 to localhost using a Unix socket file.
65
66 • --server-logs-dir=path
67
68 This option is required. path is the directory where all client
69 session logs will be stored. Usually this is the shared directory
70 that is associated with the server used for testing.
71
72 • --server-password=password
73
74 The password to use when connecting to the server.
75
76 • --server-port=port_num
77
78 The TCP/IP port number to use for connecting to the server. The
79 default is 3306.
80
81 • --server-socket=file_name
82
83 For connections to localhost, the Unix socket file to use, or, on
84 Windows, the name of the named pipe to use. The default is
85 /tmp/mysql.sock.
86
87 • --server-user=user_name
88
89 The MariaDB user name to use when connecting to the server. The
90 default is root.
91
92 • --sleep-time=N
93
94 The delay in seconds between test executions.
95
96 • --stress-basedir=path
97
98 This option is required. path is the working directory for the
99 test run. It is used as the temporary location for result tracking
100 during testing.
101
102 • --stress-datadir=path
103
104 The directory of data files to be used during testing. The default
105 location is the data directory under the location given by the
106 --stress-suite-basedir option.
107
108 • --stress-init-file[=path]
109
110 file_name is the location of the file that contains the list of
111 tests to be run once to initialize the database for the testing. If
112 missing, the default file is stress_init.txt in the test suite
113 directory.
114
115 • --stress-mode=mode
116
117 This option indicates the test order in stress-test mode. The mode
118 value is either random to select tests in random order or seq to
119 run tests in each thread in the order specified in the test list
120 file. The default mode is random.
121
122 • --stress-suite-basedir=path
123
124 This option is required. path is the directory that has the t and
125 r subdirectories containing the test case and result files. This
126 directory is also the default location of the stress-test.txt file
127 that contains the list of tests. (A different location can be
128 specified with the --stress-tests-file option.)
129
130 • --stress-tests-file[=file_name]
131
132 Use this option to run the stress tests. file_name is the location
133 of the file that contains the list of tests. If file_name is
134 omitted, the default file is stress-test.txt in the stress suite
135 directory. (See --stress-suite-basedir.)
136
137 • --suite=suite_name
138
139 Run the named test suite. The default name is main (the regular
140 test suite located in the mysql-test directory).
141
142 • --test-count=N
143
144 The number of tests to execute before exiting.
145
146 • --test-duration=N
147
148 The duration of stress testing in seconds.
149
150 • --threads=N
151
152 The number of threads. The default is 1.
153
154 • --verbose
155
156 Verbose mode. Print more information about what the program does.
157
159 Copyright © 2007, 2010, Oracle and/or its affiliates, 2010-2019 MariaDB
160 Foundation
161
162 This documentation is free software; you can redistribute it and/or
163 modify it only under the terms of the GNU General Public License as
164 published by the Free Software Foundation; version 2 of the License.
165
166 This documentation is distributed in the hope that it will be useful,
167 but WITHOUT ANY WARRANTY; without even the implied warranty of
168 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
169 General Public License for more details.
170
171 You should have received a copy of the GNU General Public License along
172 with the program; if not, write to the Free Software Foundation, Inc.,
173 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA or see
174 http://www.gnu.org/licenses/.
175
176
178 For more information, please refer to the MariaDB Knowledge Base,
179 available online at https://mariadb.com/kb/
180
182 MariaDB Foundation (http://www.mariadb.org/).
183
184
185
186MariaDB 10.5 27 June 2019 MYSQL-STRESS-TE(1)