MySQL基准测试工具
mysqlslap、sysbench、Super Smack
mysqlslap的使用MySQL官网给出了介绍
Super Smack是服务器压力测试强有力的工具
sysbench是MySQL基准测试工具了
sysbench安装
直接yum安装
测试环境
mysql> SELECT VERSION();+-----------+| VERSION() |+-----------+| 5.1.73 |+-----------+1 row in set (0.00 sec)
1：测试CPU
[root@10-4-5-9 ~]# sysbench --test=cpu --cpu-max-prime=1500 run
2：测试fileio
首先生成文件用于测试（默认生成128个单个16M共2G的文件）
[root@10-4-5-9 ~]# sysbench --test=fileio prepare
读写文件测试
[root@10-4-5-9 ~]# sysbench --test=fileio --file-test-mode=rndrw run
每秒请求数：Requests/sec 1841.10
总体吞吐量：28.767Mb/sec
删除测试数据：
[root@10-4-5-9 ~]# sysbench --test=fileio cleanup
3：测试oltp（主要用来测试多线程事务处理）
首先创建数据库和测试表
mysql> CREATE DATABASE gechong;Query OK, 1 row affected (0.00 sec)mysql> CREATE TABLE test_oltp -> SELECT * FROM mysql.user;ERROR 1046 (3D000): No database selectedmysql> USE gechong;Database changedmysql> CREATE TABLE test_oltp SELECT * FROM mysql.user;Query OK, 3 rows affected (0.01 sec)Records: 3 Duplicates: 0 Warnings: 0
[root@10-4-5-9 ~]# sysbench --test=oltp --oltp-table-size=2000000 --oltp-table-name=test_oltp --mysql-db=gechong --mysql-user=root --msyql-password=gechong prepareUnknown option: --msyql-password.
提示创建失败了。
查看下帮助
sysbench [general-options]... --test=<test-name> [test-options] ... command
General options:
--num-threads=N number of threads to use [1]
--max-requests=N limit for total number of requests [10000] --max-time=N limit for total execution time in seconds [0] --forced-shutdown=STRING amount of time to wait after --max-time before forcing shutdown [off] --thread-stack-size=SIZE size of stack per thread [32K] --init-rng=[on|off] initialize random number generator [off] --test=STRING test to run --debug=[on|off] print more debugging info [off] --validate=[on|off] perform validation checks where possible [off] --help=[on|off] print help and exit --version=[on|off] print version and exit
Compiled-in tests:
fileio - File I/O test cpu - CPU performance test memory - Memory functions speed test threads - Threads subsystem performance test mutex - Mutex performance test oltp - OLTP test
command
prepare/run/cleanup/help/version
查看帮助
[root@10-4-5-9 ~]# sysbench --help=on --test=help