bitsCN.com
paip.mysql性能测试by mysqlslap
///////////模式
usr/local/mysql/bin/mysqlslap --defaults-file=/etc/my.cnf --concurrency=200 --iterations=1 --number-int-cols=1 --auto-generate-sql --auto-generate-sql-load-type=write --engine=myisam,innodb --number-of-queries=200 -S/tmp/mysql.sock --debug-info -uroot -p123
concurrency 客户端数量
--auto-generate-sql-load-type 代表要测试的是读还是写还是两者混合的（read,write,update,mixed）
--debug-info 代表要额外输出CPU以及内存的相关信息
///////////////////我总结的模式
"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=100 --port=3307 -uroot -p
两个测试auto-generate-sql-load-type=write --number-of-queries=100
测试读能力 read ,5000
/////////获得help
/mysqlslap.exe" --help
C:/Users/Administrator>"C:/MySQL Server 5.6/bin/mysqlslap.exe" --defaults-file
="C:/MySQL Server 5.6/my-default.ini" --concurrency=1000 --auto-generate-sql --
auto-generate-sql-load-type=write --engine=innodb --number-of-queries=1000
--port=3307 -uroot -p
Enter password:
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 2.856 seconds
Minimum number of seconds to run all queries: 2.856 seconds
Maximum number of seconds to run all queries: 2.856 seconds
Number of clients running queries: 1000
Average number of queries per client: 1
Running for engine innodb
Average number of seconds to run all queries: 3.841 seconds
Minimum number of seconds to run all queries: 3.841 seconds
Maximum number of seconds to run all queries: 3.841 seconds
Number of clients running queries: 1000
Average number of queries per client: 1
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 3.560 seconds
Minimum number of seconds to run all queries: 3.560 seconds
Maximum number of seconds to run all queries: 3.560 seconds
Number of clients running queries: 1000
Average number of queries per client: 1
"C:/MySQL Server 5.6/bin/mysqlslap.exe" --defaults-file="C:/MySQL Server 5.6/my-default.ini" --concurrency=100 --auto-generate-sql --auto-generate-sql-load-type=write --engine=innodb --number-of-queries=1000 --port=3307 -uroot -p
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 2.310 seconds
Minimum number of seconds to run all queries: 2.310 seconds
Maximum number of seconds to run all queries: 2.310 seconds
Number of clients running queries: 100
Average number of queries per client: 10
"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=1000 --port=3307 -uroot -p
Running for engine innodb
Average number of seconds to run all queries: 50.210 seconds
Minimum number of seconds to run all queries: 50.210 seconds
Maximum number of seconds to run all queries: 50.210 seconds
Number of clients running queries: 1
Average number of queries 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
基于 Internet 的 Web 技术，完全采用B/S 体系结构的网络办公系统。该系统具有安全性高、功能极为强大、可在广域网中使用也可在局域网中使用、也可以同时在局域网和广域网中使用的特点，全傻瓜式安装，无需作复杂配置，界面采用类似windows资源管理器的设计，结构清晰，条理分明，即使不熟悉电脑的人也可很快掌握全部操作。该系统通过在广域网内的广泛试用验证和经专业技术人员的调试、测试，确认具有很
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-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: 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
bitsCN.com
