paip.mysql性能测试by mysqlslap(二)
per client: 1000
-------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
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 2.498 seconds
Minimum number of seconds to run all queries: 2.498 seconds
Maximum number of seconds to run all queries: 2.498 seconds
Number of clients running queries: 1
Average number of queries per client: 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=read --engine=innodb --number-of-queries=4000 --port=3307 -uroot -p
------------read 4000
C:\Users\Administrator> "C:\MySQL Server 5.6\bin\mysqlslap.exe" --defaults-f
le="C:\MySQL Server 5.6\my-default.ini" --concurrency=1 --auto-generate-sql --
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: 2.014 seconds
Minimum number of seconds to run all queries: 2.014 seconds
Maximum number of seconds to run all queries: 2.014 seconds
Number of clients running queries: 1
Average number of queries per client: 4000
----------read 2800
C:\Users\Administrator> "C:\MySQL Server 5.6\bin\mysqlslap.exe" --defaults-f
le="C:\MySQL Server 5.6\my-default.ini" --concurrency=1 --auto-generate-sql --
uto-generate-sql-load-type=read --engine=innodb --number-of-queries=2800 -
port=3307 -uroot -p
Enter password:
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 1.780 seconds
Minimum number of seconds to run all queries: 1.780 seconds
Maximum number of seconds to run all queries: 1.780 seconds
Number of clients running queries: 1
Average number of queries per client: 2800
/////////////// Error when connecting to server: 1040 Too many connections
show VARIABLES like '%max_connections%'
mysql默认的连接为151个，最大10万...
///////////tf
"f:\MySQL Server 5.6sec\bin\mysqld.exe" --defaults-file="c:\MySQL Server 5.6\my-default.ini"
C:\Users\Administrator> "C:\MySQL Server 5.6\bin\mysqlslap.exe" --defaults-f
le="C:\MySQL Server 5.6\my-default.ini" --concurrency=1 --auto-generate-sql --
uto-generate-sql-load-type=read --engine=innodb --number-of-queries=2800 -
port=3307 -uroot -p
Enter password:
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 1.780 seconds
Minimum number of seconds to run all queries: 1.780 seconds
Maximum number of seconds to run all queries: 1.780 seconds
Number of clients running queries: 1
Average number of queries per client: 2800
--------read 4000
C:\Users\Administrator> "C:\MySQL Server 5.6\bin\mysqlslap.exe" --defaults-f
le="C:\MySQL Server 5.6\my-defa