[root@mysrv ~]# mysqlslap –helpmysqlslap Ver 1.0 Distrib 5.1.66, for redhat-linux-gnu (x86_64)Copyright (c) 2005, 2012, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Run a query multiple times against the server.Usage: mysqlslap [OPTIONS]Default options are read from the following files in the given order:/etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf The following groups are read: mysqlslap clientThe following options may be given as the first argument:–print-defaultsPrint the program argument list and exit.–no-defaultsDon'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. -?, –helpDisplay this help and exit. -a, –auto-generate-sqlGenerate SQL where not supplied by file or command line. –auto-generate-sql-add-autoincrementAdd an AUTO_INCREMENT column to auto-generated tables. –auto-generate-sql-execute-number=#Set this number to generate a set number of queries torun. –auto-generate-sql-guid-primaryAdd GUID based primary keys to auto-generated tables. –auto-generate-sql-load-type=nameSpecify test load type: mixed, update, write, key, orread; default is mixed. –auto-generate-sql-secondary-indexes=#Number of secondary indexes to add to auto-generatedtables. –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 forauto-generate-sql-write-number. –auto-generate-sql-write-number=#Number of row inserts to perform for each thread (defaultis 100). –commit=#Commit records every X number of statements. -C, –compressUse compression in server/client protocol. -c, –concurrency=nameNumber of clients to simulate for query to run. –create=nameFile or string to use create tables. –create-schema=nameSchema to run tests in. –csv[=name]Generate CSV output to named file or to stdout if no fileis named. -#, –debug[=#]This is a non-debug version. Catch this and exit. –debug-checkCheck memory and open file usage at exit. -T, –debug-info Print some debug info at exit. -F, –delimiter=nameDelimiter to use in SQL statements supplied in file orcommand line. –detach=#Detach (close and reopen) connections after X number ofrequests. -e, –engine=name Storage engine to use for creating the table. -h, –host=nameConnect to host. -i, –iterations=# Number of times to run the tests. –no-dropDo not drop the schema after the test. -x, –number-char-cols=nameNumber of VARCHAR columns to create in table ifspecifying –auto-generate-sql. -y, –number-int-cols=nameNumber 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 notexact). –only-printDo not connect to the databases, but instead print outwhat would have been done. -p, –password[=name]Password to use when connecting to server. If password isnot given it's asked from the tty. -P, –port=#Port number to use for connection. –post-query=name Query to run or file containing query to execute aftertests 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 beforerunning tests. –pre-system=name system() string to execute before running tests. –protocol=nameThe protocol to use for connection (tcp, socket, pipe,memory). -q, –query=name Query to run or file containing query to run. -s, –silentRun program in silent mode – no output. -S, –socket=name The socket file to use for connection. –sslEnable SSL for connection (automatically enabled withother flags).Disable with –skip-ssl. –ssl-ca=nameCA file in PEM format (check OpenSSL docs, implies–ssl). –ssl-capath=name CA directory (check OpenSSL docs, implies –ssl). –ssl-cert=nameX509 cert in PEM format (implies –ssl). –ssl-cipher=name SSL cipher to use (implies –ssl). –ssl-key=nameX509 key in PEM format (implies –ssl). –ssl-verify-server-certVerify server's "Common Name" in its cert againsthostname used when connecting. This option is disabled bydefault. -u, –user=nameUser for login if not current user. -v, –verboseMore verbose output; you can use this multiple times toget even more verbose output. -V, –versionOutput version information and exit.
案例一：[root@mysrv ~]# mysqlslap -uroot -poracle –concurrency=100 –iterations=1 –auto-generate-sql –auto-generate-sql-load-type=mixed –auto-generate-sql-add-autoincrement –engine=myisam –number-of-queries=10 –debug-info</span></strong>测试信息：Benchmark Running for engine myisam Average number of seconds to run all queries: 0.473 seconds Minimum number of seconds to run all queries: 0.473 seconds Maximum number of seconds to run all queries: 0.473 seconds Number of clients running queries: 100 Average number of queries per client: 0User time 0.04, System time 0.14Maximum resident set size 6732, Integral resident set size 0Non-physical pagefaults 1333, Physical pagefaults 0, Swaps 0Blocks in 0 out 0, Messages in 0 out 0, Signals 0Voluntary context switches 2389, Involuntary context switches 48
备注：本次测试以100个并发线程、测试1次，自动生成SQL测试脚本、读、写、更新混合测试、自增长字段、测试引擎为myisam、共运行10次查询，，输出cpu资源信息
仿佛一支飘荡在水上的华丽咏叹调。
