1MYSQL-STRESS-TE(1) MariaDB Database System MYSQL-STRESS-TE(1)
2
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 mysql-stress-test.pl requires a version of Perl that has been built
16 with threads support.
17 Invoke mysql-stress-test.pl like this:
19 shell> mysql-stress-test.pl [options]
21 mysql-stress-test.pl supports the following options:
23 · --help
25 Display a help message and exit.
27 · --abort-on-error=N
29 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 · --check-tests-file
34 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 · --cleanup
40 Force cleanup of the working directory.
42 · --log-error-details
44 Log error details in the global error log file.
46 · --loop-count=N
48 In sequential test mode, the number of loops to execute before
50 exiting.
51 · --mysqltest=path
53 The path name to the mysqltest program.
55 · --server-database=db_name
57 The database to use for the tests. The default is test.
59 · --server-host=host_name
61 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 · --server-logs-dir=path
67 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 · --server-password=password
73 The password to use when connecting to the server.
75 · --server-port=port_num
77 The TCP/IP port number to use for connecting to the server. The
79 default is 3306.
80 · --server-socket=file_name
82 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 · --server-user=user_name
88 The MariaDB user name to use when connecting to the server. The
90 default is root.
91 · --sleep-time=N
93 The delay in seconds between test executions.
95 · --stress-basedir=path
97 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 · --stress-datadir=path
103 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 · --stress-init-file[=path]
109 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 · --stress-mode=mode
116 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 · --stress-suite-basedir=path
123 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 · --stress-tests-file[=file_name]
131 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 · --suite=suite_name
138 Run the named test suite. The default name is main (the regular
140 test suite located in the mysql-test directory).
141 · --test-count=N
143 The number of tests to execute before exiting.
145 · --test-duration=N
147 The duration of stress testing in seconds.
149 · --threads=N
151 The number of threads. The default is 1.
153 · --verbose
155 Verbose mode. Print more information about what the program does.
157
159 Copyright © 2007, 2010, Oracle and/or its affiliates, 2010-2015 MariaDB
160 Foundation
161 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 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 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-1301 USA or see
174 http://www.gnu.org/licenses/.
175
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/).
183MariaDB 10.3 9 May 2017 MYSQL-STRESS-TE(1)