paip.
mysql性能测试报告home right
环境:xpsp3 ,mysql5.6.12
硬盘信息:
序列号 : WD-WMAV29469153
容量 : 160.0 gB (149.0 GB)
缓存大小 : 8192 KB
大的文件速度
8192 KB 96839 KB/秒 WR速度
随机速度IOPS
512 bytes 60 IOPS
16 毫秒 0.029 MB/秒
4 KB 56 IOPS 17 毫秒 0.220 MB/秒
64 KB 58 IOPS 17 毫秒 3.637 MB/秒
///////////测试 write 60 sql
"D:\MySQL56\bin\mysqlslap.exe" --concurrency=1 --auto-generate-sql --auto-generate-sql-load-type=write --engine=innodb --number-of-queries=60 --port=3306 -uroot -p
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 0.063 seconds
Minimum number of seconds to run all queries: 0.063 seconds
Maximum number of seconds to run all queries: 0.063 seconds
Number of clients running queries: 1
Average number of queries per client: 60
"D:\MySQL56\bin\mysqlslap.exe" --concurrency=1 --auto-generate-sql --auto-generate-sql-load-type=write --engine=innodb --number-of-queries=600 --port=3306 -uroot -p
Enter password:
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 0.578 seconds
Minimum number of seconds to run all queries: 0.578 seconds
Maximum number of seconds to run all queries: 0.578 seconds
Number of clients running queries: 1
Average number of queries per client: 600
"D:\MySQL56\bin\mysqlslap.exe" --concurrency=1 --auto-generate-sql --auto-generate-sql-load-type=write --engine=innodb --number-of-queries=1000 --port=3306 -uroot -p
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 1.953 seconds
Minimum number of seconds to run all queries: 1.953 seconds
Maximum number of seconds to run all queries: 1.953 seconds
Number of clients running queries: 1
Average number of queries per client: 1000
"D:\MySQL56\bin\mysqlslap.exe" --concurrency=1 --auto-generate-sql --auto-generate-sql-load-type=write --engine=innodb --number-of-queries=100 --port=3306 -uroot -p
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 0.094 seco
Minimum number of seconds to run all queries: 0.094 seco
Maximum number of seconds to run all queries: 0.094 seco
Number of clients running queries: 1
Average number of queries per client: 100
///////////////////测试读速度
"D:\MySQL56\bin\mysqlslap.exe" --concurrency=1 --auto-generate-sql --auto-generate-sql-load-type=read --engine=innodb --number-of-queries=5000 --port=3306 -uroot -p
Enter password:
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 5.890 seconds
Minimum number of seconds to run all queries: 5.890 seconds
Maximum number of seconds to run all queries: 5.890 seconds
Number of clients running queries: 1
Average number of queries per client: 5000
"D:\MySQL56\bin\mysqlslap.exe" --concurrency=1 --auto-generate-sql --auto-generate-sql-load-type=read --engine=innodb --number-of-queries=2800 --port=3306 -uroot -p
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 3.734 seconds
Minimum number of s