项目地址 (目前已迁移至)

执行autogen.sh, 可能会提示缺少automake 和libtoolize  ,自行yum install automake  libtool 即可

之后./configure

之后make 即可...  make完之后会在源码目录的sysbench下生成一个sysbench二进制文件

直接执行即可看到相关的参数信息..

A:

CPU 性能测试 / CPU performance test

./sysbench --test=cpu  --num-threads=2  --cpu-max-prime=20000   run

sysbench 0.5:  multi-threaded system evaluation benchmark

Running the test with following options:

Threads started!

Threads fairness:

cpu测试主要是进行素数的加法运算，在上面的例子中，指定了最大的素数为 20000，自己可以根据机器cpu的性能来适当调整数值。

其中 --num-threads The total number of worker threads to create

默认为1, 一般设置为CPU核数(线程数)即可,设置过大也不会对性能带来影响

• cpu options:
    --cpu-max-prime=N      upper limit for primes generator [10000]

线程(thread)测试  / Threads subsystem performance test

测试线程调度器的性能。对于高负载情况下测试线程调度器的行为非常有用。

多核性能，线程调度 线程并发执行，循环响应信号量花费的时间

./sysbench --test=threads --num-threads=2 run

sysbench 0.5:  multi-threaded system evaluation benchmark

Running the test with following options:

Threads fairness:

threads options:

  --thread-yields=N      number of yields to do per request [1000]

  --thread-locks=N       number of locks per thread [8]

互斥锁(mutex) /Mutex performance test

方式是模拟所有线程在同一时刻并发运行，并都短暂请求互斥锁。

./sysbench --test=mutex --num-threads=2 --mutex-locks=1000000 run

sysbench 0.5:  multi-threaded system evaluation benchmark

Running the test with following options:

Threads fairness:

mutex options:

  --mutex-num=N        total size of mutex array [4096]

  --mutex-locks=N      number of mutex locks to do per thread [50000]

  --mutex-loops=N      number of empty loops to do inside mutex lock [10000]

内存测试 / Memory functions speed test

sysbench --test=memory --memory-block-size=8K --memory-total-size=2G  --num-threads=2 run

sysbench 0.5:  multi-threaded system evaluation benchmark

Running the test with following options:

Operations performed: 262144 (743947.40 ops/sec)

2048.00 MB transferred (5812.09 MB/sec)

Threads fairness:

memory options:

  --memory-block-size=SIZE    size of memory block for test [1K]

  --memory-total-size=SIZE    total size of data to transfer [100G]

  --memory-scope=STRING       memory access scope {global,local} [global]

  --memory-hugetlb=[on|off]   allocate memory from HugeTLB pool [off]

  --memory-oper=STRING        type of memory operations {read, write, none} [write]

  --memory-access-mode=STRING memory access mode {seq,rnd} [seq]

文件IO基准测试 / File I/O test

测试系统在不同IO负载下的IOPS性能

准备工作(创建测试文件)

sysbench --test=fileio --num-threads=2 --file-total-size=4G --file-test-mode=rndrw prepare

测试

sysbench --test=fileio --num-threads=2 --file-total-size=4G --file-test-mode=rndrw run

清理测试文件

sysbench --test=fileio --num-threads=2 --file-total-size=4G --file-test-mode=rndrw cleanup

./sysbench --test=fileio --num-threads=2 --file-total-size=4G --file-test-mode=rndrw run

Running the test with following options:

Operations performed:  5999 reads, 4001 writes, 12800 Other = 22800 Total

General statistics:

Threads fairness:

fileio options:

  --file-num=N                  number of files to create [128]

  --file-block-size=N           block size to use in all IO operations [16384]

  --file-total-size=SIZE        total size of files to create [2G]

  --file-test-mode=STRING       test mode {seqwr, seqrewr, seqrd, rndrd, rndwr, rndrw}

  seqwr 顺序写入 seqrewr 顺序重写 seqrd 顺序读取 rndrd 随机读取 rndwr 随机写入 rndrw 混合随机读/写

  --file-io-mode=STRING         file operations mode {sync,async,mmap} [sync]

  --file-extra-flags=STRING     additional flags to use on opening files {sync,dsync,direct} []

  --file-fsync-freq=N           do fsync() after this number of requests (0 - don't use fsync()) [100]

  --file-fsync-all=[on|off]     do fsync() after each write operation [off]

  --file-fsync-end=[on|off]     do fsync() at the end of test [on]

  --file-fsync-mode=STRING      which method to use for synchronization {fsync, fdatasync} [fsync]

  --file-merged-requests=N      merge at most this number of IO requests if possible (0 - don't merge) [0]

  --file-rw-ratio=N             reads/writes ratio for combined test [1.5]

引用网上的一段总结

性能测试【找范围内最大素数{

时间越短越好}】

线程调度【线程并发执行，循环响应信号量花费的时间{越少越好}】

互斥锁【并发线程同时申请互斥锁循环一定次数花费的时间{越少越好}】

内存【以不同块大小传输一定数量的数据吞吐量大小{越大越好}】

IO【不同场景下IOPS{越大越好}】

• MySQL数据库测试

sysbench 0.5通过一系列LUA脚本来替换之前的oltp，来模拟更接近真实的基准测试环境。这些测试脚本包含：insert.lua、oltp.lua、 parallel_prepare.lua、select_random_points.lua、update_index.lua、 delete.lua oltp_simple.lua、select.lua、select_random_ranges.lua、 update_non_index.lua，脚本使用方式基本类似。

sysbench 0.5默认使用sbtest库，但是需要自己手工先创建好，也可以使用--mysql-db指定，其他非默认项指定选项：

1. -mysql-host
2. -mysql-port
3. -mysql-socket
4. -mysql-user
5. -mysql-password
6. -mysql-db
7. -mysql-ssl

• prepare
  生成表并插入数据，可使用parallel_prepare.lua脚本来并行准备数据。

1. –db-driver 服务器类型 mysql | drizzle,默认为mysql
2. –mysql-table-engine 表存数引擎
3. –myisam-max-rows MyISAM表MAX_ROWS选项(用于大表)
4. –oltp-tables-count 生成表数量[sbtest1、sbtest2...]
5. –oltp-table-size 生成表的行数
6. –oltp-secondary ID列生成二级索引而不是主键
7. –oltp-auto-inc 设置ID列是否自增 on | off，默认为on

   注意  -oltp-tables-count 和 –oltp-table-size之类的参数 ,sysbench 参数写错了不会提示出错,会按原参数默认值执行

./sysbench --test=tests/db/oltp.lua --mysql-user=sysbench --oltp-tables-count=10 --oltp-table-size=100000 --mysql-password=sysbench --mysql-host=192.168.200.2 --report-interval=1 --num-threads=16 run

sysbench 0.5:  multi-threaded system evaluation benchmark

Running the test with following options:

Number of threads: 16

Report intermediate results every 1 second(s)

Random number generator seed is 0 and will be ignored

Threads started!

OLTP test statistics:

    queries performed:

        read:                            140000

        write:                           40000

        other:                           20000

        total:                           200000

    transactions:                        10000  (375.41 per sec.)##(这就是大家评测的TPS,即每秒处理的事务数)

    read/write requests:                 180000 (6757.36 per sec.)###(每秒读写次数)

    other operations:                    20000  (750.82 per sec.)

    ignored errors:                      0      (0.00 per sec.)

    reconnects:                          0      (0.00 per sec.)

General statistics:

    total time:                          26.6376s

    total number of events:              10000

    total time taken by event execution: 425.6943s

    response time:

         min:                                 11.18ms

         avg:                                 42.57ms

         max:                                194.44ms

         approx.  95 percentile:              78.24ms

Threads fairness:

    events (avg/stddev):           625.0000/6.95

    execution time (avg/stddev):   26.6059/0.01

    execution time (avg/stddev):   46.9500/0.01

如何避免压测时受到缓存的影响  有2点建议

[root@imysql.com]# sync  -- 将脏数据刷新到磁盘[root@imysql.com]# echo 3 > /proc/sys/vm/drop_caches  -- 清除OS Cache[root@imysql.com]# swapoff -a && swapon -a