1MYSQLSLAP(1) MySQL Database System MYSQLSLAP(1)
2
6 mysqlslap - a load emulation client
7
9 mysqlslap [options]
10
12 mysqlslap is a diagnostic program designed to emulate client load for a
13 MySQL server and to report the timing of each stage. It works as if
14 multiple clients are accessing the server.
15 Invoke mysqlslap like this:
17 shell> mysqlslap [options]
19 Some options such as --create or --query enable you to specify a string
21 containing an SQL statement or a file containing statements. If you
22 specify a file, by default it must contain one statement per line.
23 (That is, the implicit statement delimiter is the newline character.)
24 Use the --delimiter option to specify a different delimiter, which
25 enables you to specify statements that span multiple lines or place
26 multiple statements on a single line. You cannot include comments in a
27 file; mysqlslap does not understand them.
28 mysqlslap runs in three stages:
30 1. Create schema, table, and optionally any stored programs or data to
32 use for the test. This stage uses a single client connection.
33 2. Run the load test. This stage can use many client connections.
35 3. Clean up (disconnect, drop table if specified). This stage uses a
37 single client connection.
38 Examples:
40 Supply your own create and query SQL statements, with 50 clients
42 querying and 200 selects for each (enter the command on a single line):
43 mysqlslap --delimiter=";"
45 --create="CREATE TABLE a (b int);INSERT INTO a VALUES (23)"
46 --query="SELECT * FROM a" --concurrency=50 --iterations=200
47 Let mysqlslap build the query SQL statement with a table of two INT
49 columns and three VARCHAR columns. Use five clients querying 20 times
50 each. Do not create the table or insert the data (that is, use the
51 previous test's schema and data):
52 mysqlslap --concurrency=5 --iterations=20
54 --number-int-cols=2 --number-char-cols=3
55 --auto-generate-sql
56 Tell the program to load the create, insert, and query SQL statements
58 from the specified files, where the create.sql file has multiple table
59 creation statements delimited by ';' and multiple insert statements
60 delimited by ';'. The --query file should contain multiple queries
61 delimited by ';'. Run all the load statements, then run all the queries
62 in the query file with five clients (five times each):
63 mysqlslap --concurrency=5
65 --iterations=5 --query=query.sql --create=create.sql
66 --delimiter=";"
67 mysqlslap supports the following options, which can be specified on the
69 command line or in the [mysqlslap] and [client] groups of an option
70 file. For information about option files used by MySQL programs, see
71 Section 4.2.2.2, “Using Option Files”.
72 · --help, -? Display a help message and exit.
74 · --auto-generate-sql, -a Generate SQL statements automatically when
76 they are not supplied in files or using command options.
77 · --auto-generate-sql-add-autoincrement Add an AUTO_INCREMENT column
79 to automatically generated tables.
80 · --auto-generate-sql-execute-number=N Specify how many queries to
82 generate automatically.
83 · --auto-generate-sql-guid-primary Add a GUID-based primary key to
85 automatically generated tables.
86 · --auto-generate-sql-load-type=type Specify the test load type. The
88 permissible values are read (scan tables), write (insert into
89 tables), key (read primary keys), update (update primary keys), or
90 mixed (half inserts, half scanning selects). The default is mixed.
91 · --auto-generate-sql-secondary-indexes=N Specify how many secondary
93 indexes to add to automatically generated tables. By default, none
94 are added.
95 · --auto-generate-sql-unique-query-number=N How many different
97 queries to generate for automatic tests. For example, if you run a
98 key test that performs 1000 selects, you can use this option with a
99 value of 1000 to run 1000 unique queries, or with a value of 50 to
100 perform 50 different selects. The default is 10.
101 · --auto-generate-sql-unique-write-number=N How many different
103 queries to generate for --auto-generate-sql-write-number. The
104 default is 10.
105 · --auto-generate-sql-write-number=N How many row inserts to perform.
107 The default is 100.
108 · --commit=N How many statements to execute before committing. The
110 default is 0 (no commits are done).
111 · --compress, -C Compress all information sent between the client and
113 the server if possible. See Section 4.2.8, “Connection Compression
114 Control”.
115 As of MySQL 8.0.18, this option is deprecated. Expect it to be
117 removed in a future version of MySQL. See the section called
118 “Configuring Legacy Connection Compression”.
119 · --compression-algorithms=value The permitted compression algorithms
121 for connections to the server. The available algorithms are the
122 same as for the protocol_compression_algorithms system variable.
123 The default value is uncompressed.
124 For more information, see Section 4.2.8, “Connection Compression
126 Control”.
127 This option was added in MySQL 8.0.18.
129 · --concurrency=N, -c N The number of parallel clients to simulate.
131 · --create=value The file or string containing the statement to use
133 for creating the table.
134 · --create-schema=value The schema in which to run the tests.
136 Note
138 If the --auto-generate-sql option is also given, mysqlslap
139 drops the schema at the end of the test run. To avoid this, use
140 the --no-drop option as well.
141 · --csv[=file_name] Generate output in comma-separated values format.
143 The output goes to the named file, or to the standard output if no
144 file is given.
145 · --debug[=debug_options], -# [debug_options] Write a debugging log.
147 A typical debug_options string is d:t:o,file_name. The default is
148 d:t:o,/tmp/mysqlslap.trace.
149 This option is available only if MySQL was built using WITH_DEBUG.
151 MySQL release binaries provided by Oracle are not built using this
152 option.
153 · --debug-check Print some debugging information when the program
155 exits.
156 This option is available only if MySQL was built using WITH_DEBUG.
158 MySQL release binaries provided by Oracle are not built using this
159 option.
160 · --debug-info, -T Print debugging information and memory and CPU
162 usage statistics when the program exits.
163 This option is available only if MySQL was built using WITH_DEBUG.
165 MySQL release binaries provided by Oracle are not built using this
166 option.
167 · --default-auth=plugin A hint about which client-side authentication
169 plugin to use. See Section 6.2.17, “Pluggable Authentication”.
170 · --defaults-extra-file=file_name Read this option file after the
172 global option file but (on Unix) before the user option file. If
173 the file does not exist or is otherwise inaccessible, an error
174 occurs. file_name is interpreted relative to the current directory
175 if given as a relative path name rather than a full path name.
176 For additional information about this and other option-file
178 options, see Section 4.2.2.3, “Command-Line Options that Affect
179 Option-File Handling”.
180 · --defaults-file=file_name Use only the given option file. If the
182 file does not exist or is otherwise inaccessible, an error occurs.
183 file_name is interpreted relative to the current directory if given
184 as a relative path name rather than a full path name.
185 Exception: Even with --defaults-file, client programs read
187 .mylogin.cnf.
188 For additional information about this and other option-file
190 options, see Section 4.2.2.3, “Command-Line Options that Affect
191 Option-File Handling”.
192 · --defaults-group-suffix=str Read not only the usual option groups,
194 but also groups with the usual names and a suffix of str. For
195 example, mysqlslap normally reads the [client] and [mysqlslap]
196 groups. If the --defaults-group-suffix=_other option is given,
197 mysqlslap also reads the [client_other] and [mysqlslap_other]
198 groups.
199 For additional information about this and other option-file
201 options, see Section 4.2.2.3, “Command-Line Options that Affect
202 Option-File Handling”.
203 · --delimiter=str, -F str The delimiter to use in SQL statements
205 supplied in files or using command options.
206 · --detach=N Detach (close and reopen) each connection after each N
208 statements. The default is 0 (connections are not detached).
209 · --enable-cleartext-plugin Enable the mysql_clear_password cleartext
211 authentication plugin. (See Section 6.4.1.4, “Client-Side Cleartext
212 Pluggable Authentication”.)
213 · --engine=engine_name, -e engine_name The storage engine to use for
215 creating tables.
216 · --get-server-public-key Request from the server the RSA public key
218 that it uses for key pair-based password exchange. This option
219 applies to clients that connect to the server using an account that
220 authenticates with the caching_sha2_password authentication plugin.
221 For connections by such accounts, the server does not send the
222 public key to the client unless requested. The option is ignored
223 for accounts that do not authenticate with that plugin. It is also
224 ignored if RSA-based password exchange is not needed, as is the
225 case when the client connects to the server using a secure
226 connection.
227 If --server-public-key-path=file_name is given and specifies a
229 valid public key file, it takes precedence over
230 --get-server-public-key.
231 For information about the caching_sha2_password plugin, see
233 Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”.
234 · --host=host_name, -h host_name Connect to the MySQL server on the
236 given host.
237 · --iterations=N, -i N The number of times to run the tests.
239 · --login-path=name Read options from the named login path in the
241 .mylogin.cnf login path file. A “login path” is an option group
242 containing options that specify which MySQL server to connect to
243 and which account to authenticate as. To create or modify a login
244 path file, use the mysql_config_editor utility. See
245 mysql_config_editor(1).
246 For additional information about this and other option-file
248 options, see Section 4.2.2.3, “Command-Line Options that Affect
249 Option-File Handling”.
250 · --no-drop Prevent mysqlslap from dropping any schema it creates
252 during the test run.
253 · --no-defaults Do not read any option files. If program startup
255 fails due to reading unknown options from an option file,
256 --no-defaults can be used to prevent them from being read.
257 The exception is that the .mylogin.cnf file, if it exists, is read
259 in all cases. This permits passwords to be specified in a safer way
260 than on the command line even when --no-defaults is used.
261 (.mylogin.cnf is created by the mysql_config_editor utility. See
262 mysql_config_editor(1).)
263 For additional information about this and other option-file
265 options, see Section 4.2.2.3, “Command-Line Options that Affect
266 Option-File Handling”.
267 · --number-char-cols=N, -x N The number of VARCHAR columns to use if
269 --auto-generate-sql is specified.
270 · --number-int-cols=N, -y N The number of INT columns to use if
272 --auto-generate-sql is specified.
273 · --number-of-queries=N Limit each client to approximately this many
275 queries. Query counting takes into account the statement delimiter.
276 For example, if you invoke mysqlslap as follows, the ; delimiter is
277 recognized so that each instance of the query string counts as two
278 queries. As a result, 5 rows (not 10) are inserted.
279 shell> mysqlslap --delimiter=";" --number-of-queries=10
281 --query="use test;insert into t values(null)"
282 · --only-print Do not connect to databases. mysqlslap only prints
284 what it would have done.
285 · --password[=password], -p[password] The password of the MySQL
287 account used for connecting to the server. The password value is
288 optional. If not given, mysqlslap prompts for one. If given, there
289 must be no space between --password= or -p and the password
290 following it. If no password option is specified, the default is to
291 send no password.
292 Specifying a password on the command line should be considered
294 insecure. To avoid giving the password on the command line, use an
295 option file. See Section 6.1.2.1, “End-User Guidelines for Password
296 Security”.
297 To explicitly specify that there is no password and that mysqlslap
299 should not prompt for one, use the --skip-password option.
300 · --pipe, -W On Windows, connect to the server using a named pipe.
302 This option applies only if the server was started with the
303 named_pipe system variable enabled to support named-pipe
304 connections. In addition, the user making the connection must be a
305 member of the Windows group specified by the
306 named_pipe_full_access_group system variable.
307 · --plugin-dir=dir_name The directory in which to look for plugins.
309 Specify this option if the --default-auth option is used to specify
310 an authentication plugin but mysqlslap does not find it. See
311 Section 6.2.17, “Pluggable Authentication”.
312 · --port=port_num, -P port_num For TCP/IP connections, the port
314 number to use.
315 · --post-query=value The file or string containing the statement to
317 execute after the tests have completed. This execution is not
318 counted for timing purposes.
319 · --post-system=str The string to execute using system() after the
321 tests have completed. This execution is not counted for timing
322 purposes.
323 · --pre-query=value The file or string containing the statement to
325 execute before running the tests. This execution is not counted for
326 timing purposes.
327 · --pre-system=str The string to execute using system() before
329 running the tests. This execution is not counted for timing
330 purposes.
331 · --print-defaults Print the program name and all options that it
333 gets from option files.
334 For additional information about this and other option-file
336 options, see Section 4.2.2.3, “Command-Line Options that Affect
337 Option-File Handling”.
338 · --protocol={TCP|SOCKET|PIPE|MEMORY} The transport protocol to use
340 for connecting to the server. It is useful when the other
341 connection parameters normally result in use of a protocol other
342 than the one you want. For details on the permissible values, see
343 Section 4.2.7, “Connection Transport Protocols”.
344 · --query=value, -q value The file or string containing the SELECT
346 statement to use for retrieving data.
347 · --server-public-key-path=file_name The path name to a file in PEM
349 format containing a client-side copy of the public key required by
350 the server for RSA key pair-based password exchange. This option
351 applies to clients that authenticate with the sha256_password or
352 caching_sha2_password authentication plugin. This option is ignored
353 for accounts that do not authenticate with one of those plugins. It
354 is also ignored if RSA-based password exchange is not used, as is
355 the case when the client connects to the server using a secure
356 connection.
357 If --server-public-key-path=file_name is given and specifies a
359 valid public key file, it takes precedence over
360 --get-server-public-key.
361 For sha256_password, this option applies only if MySQL was built
363 using OpenSSL.
364 For information about the sha256_password and caching_sha2_password
366 plugins, see Section 6.4.1.3, “SHA-256 Pluggable Authentication”,
367 and Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”.
368 · --shared-memory-base-name=name On Windows, the shared-memory name
370 to use for connections made using shared memory to a local server.
371 The default value is MYSQL. The shared-memory name is
372 case-sensitive.
373 This option applies only if the server was started with the
375 shared_memory system variable enabled to support shared-memory
376 connections.
377 · --silent, -s Silent mode. No output.
379 · --socket=path, -S path For connections to localhost, the Unix
381 socket file to use, or, on Windows, the name of the named pipe to
382 use.
383 On Windows, this option applies only if the server was started with
385 the named_pipe system variable enabled to support named-pipe
386 connections. In addition, the user making the connection must be a
387 member of the Windows group specified by the
388 named_pipe_full_access_group system variable.
389 · --sql-mode=mode Set the SQL mode for the client session.
391 · --ssl* Options that begin with --ssl specify whether to connect to
393 the server using SSL and indicate where to find SSL keys and
394 certificates. See the section called “Command Options for Encrypted
395 Connections”.
396 · --ssl-fips-mode={OFF|ON|STRICT} Controls whether to enable FIPS
398 mode on the client side. The --ssl-fips-mode option differs from
399 other --ssl-xxx options in that it is not used to establish
400 encrypted connections, but rather to affect which cryptographic
401 operations to permit. See Section 6.8, “FIPS Support”.
402 These --ssl-fips-mode values are permitted:
404 · OFF: Disable FIPS mode.
406 · ON: Enable FIPS mode.
408 · STRICT: Enable “strict” FIPS mode.
410 Note
413 If the OpenSSL FIPS Object Module is not available, the only
414 permitted value for --ssl-fips-mode is OFF. In this case,
415 setting --ssl-fips-mode to ON or STRICT causes the client to
416 produce a warning at startup and to operate in non-FIPS mode.
417 · --tls-ciphersuites=ciphersuite_list The permissible ciphersuites
419 for encrypted connections that use TLSv1.3. The value is a list of
420 one or more colon-separated ciphersuite names. The ciphersuites
421 that can be named for this option depend on the SSL library used to
422 compile MySQL. For details, see Section 6.3.2, “Encrypted
423 Connection TLS Protocols and Ciphers”.
424 This option was added in MySQL 8.0.16.
426 · --tls-version=protocol_list The permissible TLS protocols for
428 encrypted connections. The value is a list of one or more
429 comma-separated protocol names. The protocols that can be named for
430 this option depend on the SSL library used to compile MySQL. For
431 details, see Section 6.3.2, “Encrypted Connection TLS Protocols and
432 Ciphers”.
433 · --user=user_name, -u user_name The user name of the MySQL account
435 to use for connecting to the server.
436 · --verbose, -v Verbose mode. Print more information about what the
438 program does. This option can be used multiple times to increase
439 the amount of information.
440 · --version, -V Display version information and exit.
442 · --zstd-compression-level=level The compression level to use for
444 connections to the server that use the zstd compression algorithm.
445 The permitted levels are from 1 to 22, with larger values
446 indicating increasing levels of compression. The default zstd
447 compression level is 3. The compression level setting has no effect
448 on connections that do not use zstd compression.
449 For more information, see Section 4.2.8, “Connection Compression
451 Control”.
452 This option was added in MySQL 8.0.18.
454
456 Copyright © 1997, 2020, Oracle and/or its affiliates.
457 This documentation is free software; you can redistribute it and/or
459 modify it only under the terms of the GNU General Public License as
460 published by the Free Software Foundation; version 2 of the License.
461 This documentation is distributed in the hope that it will be useful,
463 but WITHOUT ANY WARRANTY; without even the implied warranty of
464 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
465 General Public License for more details.
466 You should have received a copy of the GNU General Public License along
468 with the program; if not, write to the Free Software Foundation, Inc.,
469 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see
470 http://www.gnu.org/licenses/.
471
474 For more information, please refer to the MySQL Reference Manual, which
475 may already be installed locally and which is also available online at
476 http://dev.mysql.com/doc/.
477
479 Oracle Corporation (http://dev.mysql.com/).
480MySQL 8.0 11/26/2020 MYSQLSLAP(1)