前言：前段時(shí)間做服務(wù)器性能壓測(cè)時(shí)验庙，順便也一起做了innodb與tokudb引擎的性能壓測(cè)，測(cè)試方法及測(cè)試結(jié)果如下。
innodb：
[root@localhost bin]# ./mysqlslap -uroot -p –S /tmp/mysql3306.sock --concurrency=100 --iterations=5 --auto-generate-sql --auto-generate-sql-load-type=write --auto-generate-sql-add-autoincrement --engine=innodb --auto-generate-sql-write-number 1000000 --debug-info
Enter password:
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 0.044 seconds
Minimum number of seconds to run all queries: 0.041 seconds
Maximum number of seconds to run all queries: 0.047 seconds
Number of clients running queries: 100
Average number of queries per client: 0
User time 4.80, System time 27.39
Maximum resident set size 71136, Integral resident set size 0
Non-physical pagefaults 93212, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 10018141, Involuntary context switches 121
tokudb：
[root@localhost bin]# ./mysqlslap -uroot -p –S /tmp/mysql3306.sock --concurrency=100 --iterations=5 --auto-generate-sql --auto-generate-sql-load-type=write --auto-generate-sql-add-autoincrement --engine=tokudb --auto-generate-sql-write-number 1000000 --debug-info
Enter password:
Benchmark
Running for engine tokudb
Average number of seconds to run all queries: 0.084 seconds
Minimum number of seconds to run all queries: 0.075 seconds
Maximum number of seconds to run all queries: 0.093 seconds
Number of clients running queries: 100
Average number of queries per client: 0
User time 7.57, System time 39.52
Maximum resident set size 71136, Integral resident set size 0
Non-physical pagefaults 93221, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 10017036, Involuntary context switches 109
測(cè)試結(jié)果讓人大跌眼鏡啊横堡，單條數(shù)據(jù)插入時(shí)間tokudb引擎居然是innodb引擎的將近2倍。但是單從壓縮比來(lái)看冠桃，tokudb引擎確實(shí)要好得多命贴。單表大小tokudb引擎差不多是innodb引擎的1/2。不知道是不是跟ssd有關(guān)腊满，測(cè)試結(jié)果與網(wǎng)上相傳大相徑庭套么，后續(xù)我們換普通機(jī)械硬盤做一次測(cè)試。
