「mysqlslap」

  LINUX MANUAL PAGES

主题:MySQL负载模拟工具mysqlslap的使用介绍。

参考文献

支持的选项

Format Description Introduced Deprecated
–auto-generate-sql Generate SQL statements automatically when they are not supplied in files or using command options
–auto-generate-sql-add-autoincrement Add AUTO_INCREMENT column to automatically generated tables
–auto-generate-sql-execute-number Specify how many queries to generate automatically
–auto-generate-sql-guid-primary Add a GUID-based primary key to automatically generated tables
–auto-generate-sql-load-type Specify the test load type
–auto-generate-sql-secondary-indexes Specify how many secondary indexes to add to automatically generated tables
–auto-generate-sql-unique-query-number How many different queries to generate for automatic tests.
–auto-generate-sql-unique-write-number How many different queries to generate for –auto-generate-sql-write-number
–auto-generate-sql-write-number How many row inserts to perform on each thread
–commit How many statements to execute before committing.
–compress Compress all information sent between client and server
–concurrency Number of clients to simulate when issuing the SELECT statement
–create File or string containing the statement to use for creating the table
–create-schema Schema in which to run the tests
–csv Generate output in comma-separated values format
–debug Write debugging log
–debug-check Print debugging information when program exits
–debug-info Print debugging information, memory, and CPU statistics when program exits
–default-auth Authentication plugin to use
–defaults-extra-file Read named option file in addition to usual option files
–defaults-file Read only named option file
–defaults-group-suffix Option group suffix value
–delimiter Delimiter to use in SQL statements
–detach Detach (close and reopen) each connection after each N statements
–enable-cleartext-plugin Enable cleartext authentication plugin
–engine Storage engine to use for creating the table
–help Display help message and exit
–host Connect to MySQL server on given host
–iterations Number of times to run the tests
–login-path Read login path options from .mylogin.cnf
–no-defaults Read no option files
–no-drop Do not drop any schema created during the test run
–number-char-cols Number of VARCHAR columns to use if –auto-generate-sql is specified
–number-int-cols Number of INT columns to use if –auto-generate-sql is specified
–number-of-queries Limit each client to approximately this number of queries
–only-print Do not connect to databases. mysqlslap only prints what it would have done
–password Password to use when connecting to server
–pipe On Windows, connect to server using named pipe
–plugin-dir Directory where plugins are installed
–port TCP/IP port number to use for connection
–post-query File or string containing the statement to execute after the tests have completed
–post-system String to execute using system() after the tests have completed
–pre-query File or string containing the statement to execute before running the tests
–pre-system String to execute using system() before running the tests
–print-defaults Print default options
–protocol Connection protocol to use
–query File or string containing the SELECT statement to use for retrieving data
–secure-auth Do not send passwords to server in old (pre-4.1) format 5.7.4 5.7.5
–shared-memory-base-name The name of shared memory to use for shared-memory connections
–silent Silent mode
–socket For connections to localhost, the Unix socket file to use
–sql-mode Set SQL mode for client session 5.7.5
–ssl Enable secure connection
–ssl-ca Path of file that contains list of trusted SSL CAs
–ssl-capath Path of directory that contains trusted SSL CA certificates in PEM format
–ssl-cert Path of file that contains X509 certificate in PEM format
–ssl-cipher List of permitted ciphers to use for connection encryption
–ssl-crl Path of file that contains certificate revocation lists
–ssl-crlpath Path of directory that contains certificate revocation list files
–ssl-key Path of file that contains X509 key in PEM format
–ssl-mode Security state of connection to server 5.7.11
–ssl-verify-server-cert Verify server certificate Common Name value against host name used when connecting to server
–tls-version Protocols permitted for secure connections 5.7.10
–user MySQL user name to use when connecting to server
–verbose Verbose mode
–version Display version information and exit
Format Description Introduced Deprecated
l