Sysbench tool Use

--------------the required package--------------

    Automake    Libtool    sysbench-1.0.zip    

--------------Installation--------------

#yum Install Automake libtool#mkdir/usr/local/sysbench-p#cd/usr/local/sysbench#unzip SYSBENCH-1.0.ZIP#CD Sysbench-1.0#./autogen.sh#./configure#make && make Install
#export Ld_library_path=/usr/local/mysql/lib

--------------View the Help document--------------

--View the overall help document #sysbench  --help--Check the Help documentation for the CPU #sysbench--test=cpu help--View the Help documentation for the IO test #sysbench--test=fileio help-- View the help document for test memory #sysbench--test=memory help--See the Help document for the test thread #sysbench--test=threads assist

--------------the steps of the test--------------

    Prepare            --Generate test data required    run                --perform performance test    cleanup            --Clear test data

--------------Global Parameters--------------

#sysbench-General (important)    --num-threads=n                -Specifies the number of threads to use for the test and the default is 1    --max-requests                 -The maximum number of requests. The default is 10000, and 0 means no limit    --max-time=n                -The maximum execution time, in seconds. The default is 0, no limit    --report-interval              --Specifies how many seconds per second The result is printed on the screen    --test=string                --Specify the test type        FileIO        CPU        Memory        threads        mutex--log option    --verbosity=n        --log level, default to 3,5=debug,0= contains only important information

--------------Test IO Parameters--------------

 --io related parameters--file-num=n--Specify how many files the test generates--FILE-BLOCK-SIZE=N --Specify the size of the test block (usually test MySQL default to 16k[16384], or 8k[8192])--file-total-size=size--Specify the total file size of the test build (file-total-size/fi        le-num= number of files)--file-test-mode=string--Specify the mode of test disk IO seqwr--Sequential write SEQREWR--sequential Read and write SEQRD--Sequential read RNDRD--Random Read RNDWR--Random write RNDRW--random Read and write--file-io-mode=s TRING--File operation mode {sync (synchronous), async (async), Fastmmap (Fast map map), Slowmmap (slow map)}.                The default is sync--file-extra-flags--using an extra flag to open the file (sync,dsync,direct), MySQL is usually--file-fsync-freq=n by direct mode --Executes the frequency of Fsync (), the default is 100,0 to not use--file-fsync-all=[on/off]--Once the write operation executes once Fsync (), the default is off--file-fsyn C-end=[on/off]--executes fsync at the end of the test. The default is on--file-merged-requests=n--if possible, the maximum number of IO requests to merge (0– means not merging). The default is 0--file-rw-ratio=n--read and write ratio when testing. The default is 1.5  

--An IO random reading test sample

--Create 10G file, divide into 4, test 16K block size, use direct mode to read, test 600 seconds (10 minutes), enable 64 threads, output a result every 3 seconds #sysbench--test=fileio--file-num=4-- file-block-size=16384--file-total-size=10g--FILE-TEST-MODE=RNDRD--file-extra-flags=direct--max-requests=0-- max-time=600--num-threads=64--report-interval=3  prepare  #sysbench--test=fileio--file-num=4-- file-block-size=16384--file-total-size=10g--FILE-TEST-MODE=RNDRD--file-extra-flags=direct--max-requests=0-- max-time=600--num-threads=64--report-interval=3 run#sysbench--test=fileio--file-num=4--file-block-size=16384-- file-total-size=10g--file-test-mode=rndrd--file-extra-flags=direct--max-requests=0--max-time=600--num-threads= --report-interval=3 cleanup

Sysbench tool Use