Mysqlslap stress testing tool

Mysqlslap is a mysql testing tool started with mysql 5.1.4.
 

[Root @ www.bkjia.com ~] # Mysqlslap -- help
Mysqlslap Ver 1.0 Distrib 5.5.31, for Linux (x86_64)
Copyright (c) 2005,201 3, Oracle and/or its affiliates. All rights reserved.
 
Oracle is a registered trademark of Oracle Corporation and/or its
Affiliates. Other names may be trademarks of their respective
Owners.
 
Run a query multiple times against the server.
 
Usage: mysqlslap [OPTIONS]
 
Default options are read from the following files in the given order:
/Etc/my. cnf/etc/mysql/my. cnf/usr/local/mysql/etc/my. cnf ~ /. My. cnf
The following groups are read: mysqlslap client
The following options may be given as the first argument:
-- Print-defaults Print the program argument list and exit.
-- No-defaults Don't read default options from any option file.
-- Defaults-file = # Only read default options from the given file #.
-- Defaults-extra-file = # Read this file after the global files are read.
-?, -- Help Display this help and exit.
-A, -- auto-generate-SQL
Generate SQL where not supplied by file or command line.
-- Auto-generate-SQL-add-autoincrement
Add an AUTO_INCREMENT column to auto-generated tables.
-- Auto-generate-SQL-execute-number = #
Set this number to generate a set number of queries
Run.
-- Auto-generate-SQL-guid-primary
Add GUID based primary keys to auto-generated tables.
-- Auto-generate-SQL-load-type = name
Specify test load type: mixed, update, write, key, or
Read; default is mixed.
-- Auto-generate-SQL-secondary-indexes = #
Number of secondary indexes to add to auto-generated
Tables.
-- Auto-generate-SQL-unique-query-number = #
Number of unique queries to generate for automatic tests.
-- Auto-generate-SQL-unique-write-number = #
Number of unique queries to generate
Auto-generate-SQL-write-number.
-- Auto-generate-SQL-write-number = #
Number of row inserts to perform for each thread (default
Is 100 ).
-- Commit = # Commit records every X number of statements.
-C, -- compress Use compression in server/client protocol.
-C, -- concurrency = name
Number of clients to simulate for query to run.
-- Create = name File or string to use create tables.
-- Create-schema = name
Schema to run tests in.
-- Csv [= name] Generate CSV output to named file or to stdout if no file
Is named.
-#, -- Debug [= #] This is a non-debug version. Catch this and exit.
-- Debug-check memory and open file usage at exit.
-T, -- debug-info Print some debug info at exit.
-- Default-auth = name Default authentication client-side plugin to use.
-F, -- delimiter = name
Delimiter to use in SQL statements supplied in file or
Command line.
-- Detach = # Detach (close and reopen) connections after X number
Requests.
-- Enable-cleartext-plugin
Enable/disable the clear text authentication plugin.
-E, -- engine = name Storage engine to use for creating the table.
-H, -- host = name Connect to host.
-I, -- iterations = # Number of times to run the tests.
-- No-drop Do not drop the schema after the test.
-X, -- number-char-cols = name
Number of VARCHAR columns to create in table if
Specifying -- auto-generate-SQL.
-Y, -- number-int-cols = name
Number of INT columns to create in table if specifying
-- Auto-generate-SQL.
-- Number-of-queries = #
Limit each client to this number of queries (this is not
Exact ).
-- Only-print Do not connect to the databases, but instead print out
What wocould have been done.
-P, -- password [= name]
Password to use when connecting to server. If password is
Not given it's asked from the tty.
-- Plugin-dir = name Directory for client-side plugins.
-P, -- port = # Port number to use for connection.
-- Post-query = name Query to run or file containing query to execute after
Tests have completed.
-- Post-system = name system () string to execute after tests have completed.
-- Pre-query = name Query to run or file containing query to execute before
Running tests.
-- Pre-system = name system () string to execute before running tests.
-- Protocol = name The protocol to use for connection (tcp, socket, pipe,
Memory ).
-Q, -- query = name Query to run or file containing query to run.
-S, -- silent Run program in silent mode-no output.
-S, -- socket = name The socket file to use for connection.
-U, -- user = name User for login if not current user.
-V, -- verbose More verbose output; you can use this multiple times
Get even more verbose output.
-V, -- version Output version information and exit.