mysqlslap 是从mysql 5.1.4版开始带的一个mysql测试工具。
mysqlslap 是从mysql 5.1.4版开始带的一个mysql测试工具。
[root@  ~]# mysqlslap --help
 mysqlslap  ver 1.0 distrib 5.5.31, for linux (x86_64)
 copyright (c) 2005, 2013, 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 to
                      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 for
                      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      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 of
                      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 would 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 to
                      get even more verbose output.
  -v, --version      output version information and exit.
，