?????????????????????????????????????????ο?????
????3.4 ??????
?????????????????????????д?????
????sysbench --test=memory --memory-block-size=8K --memory-total-size=2G  --num-threads=16 run
????????????????????????????????У?????2G?????????????block???С?8K(??д??K)?? ???????????????????????????????(8030.45MB/sec)???????????io ???????????????????????д????????????д?????????

 

Number of threads: 16
Doing memory operations speed test
Memory block size: 8K
Memory transfer size: 2048M
Memory operations type: write
Memory scope type: global
Threads started!
Done.
Operations performed: 262144 (1027897.89 ops/sec)
2048.00 MB transferred (8030.45 MB/sec)
Test execution summary:
total time: 0.2550s
total number of events: 262144
total time taken by event execution: 3.1911
per-request statistics:
min: 0.00ms
avg: 0.01ms
max: 29.55ms
approx. 95 percentile: 0.00ms
Threads fairness:
events (avg/stddev): 16384.0000/926.14
execution time (avg/stddev): 0.1994/0.02

????3.5 ???IO???????
???????IO(fileio)???????????????????IO?????μ?????????????????????????????????RAID ?????????RAID ?????????а?????????????????????IO?????????IO??????????????InnoDB ??IO?????
??????????????????(Prepare)??Σ????????????????????????????????????????????? ???????е??????????????????У???????? ????????????????2????????????IO??????????????????????????????????????????
????sysbench --test=fileio --file-total-size=40G prepare
???????????????????????′??????????????????????(run)??ν??????д??Щ??????в???? ???????????(run)??Σ????????IO ?????в??????????
????seqwr ???д??
????seqrewr ?????д
????seqrd ?????
????rndrd ??????
????rndwr ???д??
????rndrw ????????/д
????????????????????I/O????????/д????????
????sysbench --test=fileio --file-total-size=40G --file-test-mode=rndrw
????--init-rng=on --max-time=300 --max-requests=0 run

????simple ?? --oltp-read-only ??????
????simple??????complex???????read-only????????select??????? simple ???????????select????????complex ???У???????????read-only ?????--oltp-read-only=on?????????????SQL????磺
????SELECT SUM(K) FROM sbtest WHERE id BETWEEN N and M
????SELECT DISTINCT c FROM sbtest WHERE id BETWEEN N and M ORDER BY c
???????????е?洢????
???????????е?洢???????????sysbench??????洢??????????????
?????????????
???????
????sysbench --test=oltp --mysql-table-engine=tnt --mysql-engine-trx=yes
????--oltp-table-size=100000 --mysql-user=root --mysql-db=test
????--mysql-socket=/data/ntse/lmx/sysbench/var/mysqld.sock
????prepare
????????
????sysbench --test=oltp --mysql-table-engine=tnt --mysql-engine-trx=yes
????--oltp-table-size=100000 --mysql-user=root --mysql-db=test
????--mysql-socket=/data/ntse/lmx/sysbench/var/mysqld.sock
????--oltp-test-mode=complex --num-threads=16 --max-time=720
????--max-requests=0 run
???????
????sysbench --test=oltp --mysql-table-engine=tnt --mysql-engine-trx=yes
????--oltp-table-size=100000 --mysql-user=root --mysql-db=test
????--mysql-socket=/data/ntse/lmx/sysbench/var/mysqld.sock
????clean
????4. sysbench 0.5