paip.mysql性能测试by mysqlslap(三)

uto-generate-sql-load-type=read --engine=innodb --number-of-queries=4000 -

port=3307 -uroot -p

Enter password:

Benchmark

Running for engine innodb

Average number of seconds to run all queries: 1.936 seconds

Minimum number of seconds to run all queries: 1.936 seconds

Maximum number of seconds to run all queries: 1.936 seconds

Number of clients running queries: 1

Average number of queries per client: 4000

-------write 60

"C:\MySQL Server 5.6\bin\mysqlslap.exe" --defaults-file="C:\MySQL Server 5.6\my-default.ini" --concurrency=1 --auto-generate-sql --auto-generate-sql-load-type=write --engine=innodb --number-of-queries=60 --port=3307 -uroot -p

C:\Users\Administrator> "C:\MySQL Server 5.6\bin\mysqlslap.exe" --defaults

e="C:\MySQL Server 5.6\my-default.ini" --concurrency=1 --auto-generate-sql

to-generate-sql-load-type=write --engine=innodb --number-of-queries=60

rt=3307 -uroot -p

Enter password:

Benchmark

Running for engine innodb

Average number of seconds to run all queries: 6.136 seconds

Minimum number of seconds to run all queries: 6.136 seconds

Maximum number of seconds to run all queries: 6.136 seconds

Number of clients running queries: 1

Average number of queries per client: 60