mysqlslap result at 2014/06/02 case1

my.cnf

[mysqld_multi]
mysqld=/usr/bin/mysqld_safe
mysqladmin=/usr/bin/mysqladmin
log=/var/log/mysql/mysqld_multi.log


[mysqld]
user=mysql
character-set-server=utf8
long_query_time=1

skip-character-set-client-handshake
skip-name-resolve

sync-binlog=1

relay-log=relay-bin.nnnnnn
relay_log_purge=0
#relay_log_info_repository=TABLE
relay_log_recovery=ON

event_scheduler=on

slow_query_log

innodb_file_per_table

key_buffer_size                = 128M
max_allowed_packet             = 1M
table_open_cache               = 1024
sort_buffer_size               = 2M
net_buffer_length              = 8K
read_buffer_size               = 2M
read_rnd_buffer_size           = 8M
myisam_sort_buffer_size        = 16M
query_cache_size               = 128M
thread_cache_size              = 100
max_connections                = 400

binlog_format                  = mixed
expire_logs_days               = 2

# innodb
innodb_buffer_pool_size        = 5120M
innodb_log_file_size           = 256M
innodb_log_buffer_size         = 16M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout       = 5
innodb_file_format             = Barracuda
innodb_flush_method            = O_DIRECT
innodb_read_io_threads         = 4
innodb_write_io_threads        = 4


[mysqld1]
server-id=1
socket=/fio1/mysql/mysql.sock
pid-file=/fio1/mysql/mysql.pid
datadir=/fio1/mysql/
tmpdir=/fio1/tmp/
port=3310
slow_query_log_file=/fio1/mysql/slow.log
log-error=/fio1/mysql/mysql.log
innodb_log_group_home_dir=/hdd1/fio1logs/
innodb_data_home_dir=/hdd1/fio1logs/
log-bin=/hdd1/fio1logs/mysqld-bin

[mysqld2]
server-id=2
socket=/fio2/mysql/mysql.sock
pid-file=/fio2/mysql/mysql.pid
datadir=/fio2/mysql/
tmpdir=/fio2/tmp/
port=3320
slow_query_log_file=/fio2/mysql/slow.log
log-error=/fio2/mysql/mysql.log
innodb_log_group_home_dir=/hdd2/fio2logs/
innodb_data_home_dir=/hdd2/fio2logs/
log-bin=/hdd2/fio2logs/mysqld-bin

[mysqld3]
server-id=3
socket=/hdd1/mysql/mysql.sock
pid-file=/hdd1/mysql/mysql.pid
datadir=/hdd1/mysql/
tmpdir=/hdd1/tmp/
port=3330
slow_query_log_file=/hdd1/mysql/slow.log
log-error=/hdd1/mysql/mysql.log
innodb_log_group_home_dir=/fio1/hdd1logs/
innodb_data_home_dir=/fio1/hdd1logs/
log-bin=/fio1/hdd1logs/mysqld-bin

[mysqld4]
server-id=4
socket=/hdd2/mysql/mysql.sock
pid-file=/hdd2/mysql/mysql.pid
datadir=/hdd2/mysql/
tmpdir=/hdd2/tmp/
port=3340
slow_query_log_file=/hdd2/mysql/slow.log
log-error=/hdd2/mysql/mysql.log
innodb_log_group_home_dir=/fio1/hdd2logs/
innodb_data_home_dir=/fio1/hdd2logs/
log-bin=/fio1/hdd2logs/mysqld-bin

mysqlslap.sh

#!/bin/bash

rm -f result/*

DSTAT_LOG="result/mysqlslap_dstat.csv"

dstat -tclmdrn --output $DSTAT_LOG 3 &
PID=`echo $!`

for DIR in "fio1" "fio2" "hdd1" "hdd2"
do
	MYSQLSLAP_LOG="result/${DIR}_mysqlslap.log"
	CONCURRENCY=10
	ITERATIONS=2
	NUMBER_OF_QUERIES=500000
	TYPE="write"

	sync
	echo 3 >  /proc/sys/vm/drop_caches
	sync
	
	echo "########################################################################################################" >> $MYSQLSLAP_LOG
	echo "### `date '+%Y%m%d%H%M%S'` ${DIR} / ITERATIONS:${ITERATIONS} / TYPE:${TYPE}"                              >> $MYSQLSLAP_LOG
	echo "########################################################################################################" >> $MYSQLSLAP_LOG

	mysqlslap \
	--user=sbtestuser \
	--password=sbtestpass \
	--create-schema=sbtest \
	--socket=/${DIR}/mysql/mysql.sock \
	--concurrency=${CONCURRENCY} \
	--iterations=${ITERATIONS} \
	--engine=innodb \
	--auto-generate-sql \
	--auto-generate-sql-load-type=${TYPE} \
	--number-of-queries=${NUMBER_OF_QUERIES} \
	>> $MYSQLSLAP_LOG

	echo ""
done

kill $PID

mysqlslap_dstat.csv

"Dstat 0.7.0 CSV output"
"Author:","Dag Wieers <dag@wieers.com>",,,,"URL:","http://dag.wieers.com/home-made/dstat/"
"Host:","mysql-test01.hq.ecnavi.info",,,,"User:","root"
"Cmdline:","dstat -tclmdrn --output result/mysqlslap_dstat.csv 3",,,,"Date:","03 Jun 2014 03:01:20 JST"

"system","total cpu usage",,,,,,"load avg",,,"memory usage",,,,"dsk/total",,"io/total",,"net/total",
"date/time","usr","sys","idl","wai","hiq","siq","1m","5m","15m","used","buff","cach","free","read","writ","read","writ","recv","send"
03-06 03:01:20,1.102,0.419,98.150,0.313,0.003,0.013,3.040,3.220,2.910,25653850112.0,3559424.0,21987328.0,5858013184.0,577129.368,2652417.251,33.554,170.568,0.0,0.0
03-06 03:01:23,12.014,10.585,72.041,4.332,0.0,1.027,3.040,3.220,2.910,25652236288.0,59777024.0,39059456.0,5786337280.0,3020117.333,70914048.0,717.333,12586.667,387.333,786.667
03-06 03:01:26,13.361,11.232,70.335,3.850,0.045,1.178,3.120,3.230,2.920,25652170752.0,96821248.0,56942592.0,5731475456.0,3260416.0,72489642.667,795.667,13855.333,219.333,491.333
03-06 03:01:29,13.988,11.861,68.945,4.120,0.045,1.041,3.120,3.230,2.920,25653100544.0,117374976.0,75964416.0,5690970112.0,3396949.333,71649962.667,829.333,14335.0,730.333,725.333
03-06 03:01:32,14.344,12.341,67.987,4.144,0.046,1.138,3.190,3.240,2.920,25654095872.0,127602688.0,98254848.0,5657456640.0,4214784.0,73805824.0,876.0,14988.667,925.333,1060.667
03-06 03:01:35,14.409,11.947,68.399,4.104,0.0,1.140,3.250,3.250,2.930,25653338112.0,133013504.0,117854208.0,5633204224.0,3492522.667,76879189.333,851.333,14970.333,1347.333,1095.333
03-06 03:01:38,14.668,12.443,67.484,4.042,0.045,1.317,3.250,3.250,2.930,25653948416.0,135524352.0,138342400.0,5609594880.0,3574442.667,77630122.667,872.667,15271.333,686.0,741.333
03-06 03:01:41,15.163,12.093,67.155,4.306,0.046,1.237,3.230,3.250,2.930,25653358592.0,136876032.0,159547392.0,5587628032.0,3644074.667,78453418.667,890.0,15542.667,990.667,884.667
03-06 03:01:44,14.135,11.886,68.793,3.947,0.046,1.193,3.230,3.250,2.930,25654673408.0,137568256.0,179634176.0,5565534208.0,3523925.333,76275712.0,860.0,15056.0,1559.333,1120.667
03-06 03:01:47,15.0,12.591,66.773,4.273,0.045,1.318,3.530,3.310,2.950,25655648256.0,137965568.0,199483392.0,5544312832.0,3581269.333,80220160.0,874.333,15429.0,1022.0,845.333
03-06 03:01:50,15.937,12.144,66.591,4.108,0.045,1.174,3.650,3.340,2.960,25656885248.0,138227712.0,219189248.0,5523107840.0,3604480.0,80173738.667,880.333,15492.667,556.0,770.0
03-06 03:01:53,17.159,12.814,64.427,4.256,0.045,1.299,3.650,3.340,2.960,25657237504.0,138452992.0,240697344.0,5501022208.0,3750570.667,80054954.667,915.333,16042.333,630.0,725.333
03-06 03:01:56,16.570,12.327,65.297,4.466,0.0,1.340,3.760,3.370,2.970,25657749504.0,138612736.0,261611520.0,5479436288.0,3660458.667,78655488.0,893.667,15753.333,587.333,725.333
03-06 03:01:59,15.064,13.141,66.392,4.029,0.046,1.328,3.760,3.370,2.970,25658019840.0,138715136.0,282816512.0,5457858560.0,3736917.333,82134357.333,912.333,16085.667,366.667,491.333
03-06 03:02:02,15.062,13.008,66.910,3.971,0.046,1.004,3.780,3.380,2.980,25658503168.0,138801152.0,304340992.0,5435764736.0,3680938.667,78796117.333,898.667,15795.667,216.333,491.333
03-06 03:02:05,15.423,13.194,65.878,4.368,0.0,1.137,3.880,3.400,2.990,25659240448.0,138952704.0,324808704.0,5414408192.0,3682304.0,83339946.667,899.333,15889.333,738.333,796.333
03-06 03:02:08,15.857,13.107,65.857,3.941,0.046,1.192,3.880,3.400,2.990,25659199488.0,139051008.0,346718208.0,5392441344.0,3806549.333,80906922.667,929.0,16315.0,1860.667,1713.0
03-06 03:02:11,15.241,12.921,66.742,3.913,0.0,1.183,3.890,3.410,2.990,25660039168.0,139198464.0,367443968.0,5370728448.0,3656362.667,83786410.667,892.667,15784.0,396.0,512.667
03-06 03:02:14,14.975,12.654,66.955,4.142,0.046,1.229,3.890,3.410,2.990,25659830272.0,139337728.0,389218304.0,5349023744.0,3630421.333,82098858.667,886.333,15590.0,425.0,491.333
03-06 03:02:17,14.502,12.666,67.600,4.084,0.0,1.147,3.970,3.440,3.010,25662558208.0,139452416.0,408199168.0,5327200256.0,3629056.0,82407424.0,886.0,15507.0,506.667,491.333
03-06 03:02:20,14.790,12.483,67.028,4.387,0.045,1.266,4.140,3.480,3.020,25660116992.0,140279808.0,429146112.0,5307867136.0,3848874.667,80288426.667,876.0,15537.0,1578.0,1478.667
03-06 03:02:23,14.240,12.506,67.412,4.747,0.046,1.050,4.140,3.480,3.020,25660137472.0,141328384.0,453124096.0,5282820096.0,4975274.667,80132778.667,912.667,15118.333,1266.667,4661.333
03-06 03:02:26,14.756,12.380,67.931,3.792,0.0,1.142,4.290,3.520,3.040,25661681664.0,141410304.0,472965120.0,5261352960.0,3608576.0,79492437.333,881.333,15401.667,155.333,491.333
03-06 03:02:29,13.176,11.222,70.604,3.907,0.045,1.045,4.290,3.520,3.040,25661624320.0,141475840.0,491368448.0,5242941440.0,3295914.667,72312149.333,804.667,14063.667,334.667,491.333
03-06 03:02:32,13.315,11.263,70.588,3.739,0.046,1.049,4.260,3.530,3.040,25661878272.0,141598720.0,510029824.0,5223903232.0,3334144.0,74582698.667,813.667,14184.333,502.667,491.333
03-06 03:02:35,15.027,12.659,67.350,3.825,0.0,1.138,4.320,3.560,3.050,25661812736.0,141680640.0,531599360.0,5202317312.0,3641344.0,80767658.667,889.333,15551.667,321.333,491.333
03-06 03:02:38,15.014,12.648,67.106,3.958,0.045,1.228,4.320,3.560,3.050,25662554112.0,141819904.0,552169472.0,5180866560.0,3635882.667,83060053.333,887.667,15552.333,278.667,491.333
03-06 03:02:41,14.357,12.306,68.186,4.057,0.0,1.094,4.460,3.600,3.070,25663987712.0,141934592.0,570937344.0,5160550400.0,3545770.667,78716928.0,865.667,15159.667,497.333,514.667
03-06 03:02:44,14.938,12.746,67.017,4.066,0.046,1.188,4.460,3.600,3.070,25663041536.0,142041088.0,593489920.0,5138837504.0,3664554.667,81327445.333,894.667,15729.667,605.333,491.333
03-06 03:02:47,14.410,12.483,68.013,3.809,0.0,1.285,4.580,3.640,3.080,25664663552.0,142139392.0,612610048.0,5117997056.0,3618133.333,81113088.0,883.333,15450.333,361.0,491.333
03-06 03:02:50,13.810,12.078,68.687,4.376,0.046,1.003,4.530,3.640,3.090,25664475136.0,142270464.0,632729600.0,5097934848.0,3450197.333,77553664.0,842.0,14794.0,313.333,491.333
03-06 03:02:53,14.975,12.198,67.683,3.778,0.046,1.320,4.530,3.640,3.090,25666121728.0,142372864.0,653066240.0,5075849216.0,3608576.0,80285696.0,881.333,15407.0,334.667,491.333
03-06 03:02:56,14.279,12.096,68.713,3.729,0.0,1.182,4.570,3.660,3.100,25665474560.0,142536704.0,673230848.0,5056167936.0,3504810.667,77989205.333,855.667,14912.667,459.667,491.333
03-06 03:02:59,14.526,12.705,67.486,4.098,0.046,1.138,4.570,3.660,3.100,25665609728.0,142626816.0,693948416.0,5035225088.0,3604480.0,78964053.333,880.0,15337.333,198.0,491.333
03-06 03:03:02,14.487,12.164,68.155,3.964,0.046,1.185,4.600,3.690,3.110,25667465216.0,142757888.0,713801728.0,5013385216.0,3552597.333,80545109.333,867.0,15140.0,377.333,491.333
03-06 03:03:05,14.442,12.066,68.510,3.885,0.0,1.097,4.640,3.710,3.120,25668407296.0,142848000.0,733483008.0,4992671744.0,3518464.0,77284693.333,859.0,15052.333,379.667,796.333
03-06 03:03:08,14.596,12.653,67.781,3.841,0.045,1.085,4.640,3.710,3.120,25667911680.0,142995456.0,754020352.0,4972482560.0,3528021.333,79680853.333,861.333,15211.333,1775.333,1638.333
03-06 03:03:11,15.070,12.392,67.499,3.813,0.045,1.180,4.500,3.700,3.120,25668186112.0,143101952.0,774717440.0,4951404544.0,3581269.333,80901461.333,874.333,15388.0,634.667,512.667
03-06 03:03:14,15.074,12.822,66.636,4.090,0.046,1.333,4.500,3.700,3.120,25669677056.0,143249408.0,795672576.0,4928811008.0,3732821.333,83051861.333,911.333,15961.333,300.0,491.333
03-06 03:03:17,14.906,12.209,67.718,3.932,0.0,1.235,4.540,3.720,3.130,25669259264.0,143388672.0,816259072.0,4908503040.0,3614037.333,81715200.0,882.333,15454.333,304.667,491.333
03-06 03:03:20,12.834,12.032,70.455,3.654,0.045,0.980,4.420,3.700,3.130,25642602496.0,569344.0,19779584.0,5874458624.0,3203072.0,69994154.667,757.0,13465.333,421.333,491.333
03-06 03:03:23,25.996,14.885,53.836,4.025,0.042,1.216,4.420,3.700,3.130,25644871680.0,1888256.0,49082368.0,5841567744.0,5856426.667,57099605.333,1179.0,12975.667,368.0,591.333
03-06 03:03:26,29.130,16.563,49.438,3.412,0.0,1.457,4.310,3.690,3.120,25645690880.0,1896448.0,78721024.0,5811101696.0,5279744.0,57563648.0,1289.333,14335.667,134.0,491.333
03-06 03:03:29,28.392,16.868,49.603,3.466,0.0,1.670,4.310,3.690,3.120,25646489600.0,1896448.0,108396544.0,5780627456.0,5259264.0,57497429.333,1284.0,14350.667,176.667,491.333
03-06 03:03:32,28.625,16.681,49.539,3.562,0.042,1.551,4.120,3.660,3.120,25647247360.0,1904640.0,138088448.0,5750169600.0,5287936.0,59356672.0,1290.667,14460.0,588.667,491.333
03-06 03:03:35,28.893,16.570,49.584,3.497,0.042,1.415,3.950,3.640,3.110,25647341568.0,1904640.0,167706624.0,5720457216.0,5253802.667,58913280.0,1282.667,14375.0,289.333,491.333
03-06 03:03:38,28.285,16.562,50.188,3.463,0.042,1.460,3.950,3.640,3.110,25648427008.0,1912832.0,197586944.0,5689483264.0,5216938.667,58491392.0,1273.667,14134.0,428.0,491.333
03-06 03:03:41,28.846,16.848,49.415,3.470,0.0,1.421,3.950,3.640,3.120,25649631232.0,1912832.0,227237888.0,5658628096.0,5308416.0,59445248.0,1296.333,14442.0,364.0,491.333
03-06 03:03:44,29.012,16.674,49.437,3.418,0.042,1.417,3.950,3.640,3.120,25650593792.0,1921024.0,257122304.0,5627772928.0,5286570.667,60212053.333,1291.0,14402.667,612.0,491.333
03-06 03:03:47,28.679,16.931,49.373,3.470,0.042,1.505,3.800,3.620,3.110,25651953664.0,1921024.0,286887936.0,5596647424.0,5264725.333,59152554.667,1284.667,14341.667,712.667,554.0
03-06 03:03:50,27.724,15.699,51.524,3.633,0.0,1.420,3.800,3.620,3.110,25650724864.0,1941504.0,316538880.0,5568204800.0,5221034.667,59331754.667,1236.333,13745.333,724.667,688.0
03-06 03:03:53,29.248,16.452,49.065,3.573,0.042,1.620,3.810,3.620,3.110,25650683904.0,1949696.0,346013696.0,5538762752.0,5267456.0,60500309.333,1285.333,14367.333,1096.0,1195.333
03-06 03:03:56,28.727,16.785,49.186,3.841,0.0,1.461,3.590,3.580,3.100,25653182464.0,2244608.0,376995840.0,5504987136.0,5981525.333,62792192.0,1294.333,14369.0,1772.0,1702.667
03-06 03:03:59,28.838,16.598,49.336,3.568,0.083,1.577,3.590,3.580,3.100,25653817344.0,2244608.0,406454272.0,5474893824.0,5215573.333,61401088.0,1273.333,14309.667,795.333,843.333
03-06 03:04:02,28.441,15.672,50.871,3.400,0.041,1.575,3.460,3.550,3.100,25654480896.0,2252800.0,434814976.0,5445861376.0,5067264.0,62190592.0,1237.667,14082.667,699.333,848.667
03-06 03:04:05,28.465,16.971,49.627,3.402,0.0,1.535,3.460,3.550,3.100,25656008704.0,2252800.0,464396288.0,5414752256.0,5256533.333,58632192.0,1283.333,14230.0,1116.333,2333.0
03-06 03:04:08,28.907,16.464,49.686,3.435,0.0,1.508,3.340,3.530,3.090,25656475648.0,2260992.0,494395392.0,5384278016.0,5311146.667,59380906.667,1297.0,14435.333,2001.333,1814.333
03-06 03:04:11,28.326,16.618,50.063,3.525,0.042,1.427,3.160,3.480,3.080,25656336384.0,2260992.0,523866112.0,5354946560.0,5242880.0,59883008.0,1280.0,14295.667,364.0,512.667
03-06 03:04:14,27.002,15.807,52.285,3.438,0.0,1.468,3.160,3.480,3.080,25657143296.0,2269184.0,552493056.0,5325504512.0,5009408.0,56264362.667,1223.0,13624.667,498.0,491.333
03-06 03:04:17,29.038,16.976,48.864,3.428,0.083,1.611,2.900,3.430,3.060,25658433536.0,2269184.0,581668864.0,5295038464.0,5287936.0,60149418.667,1291.0,14434.0,374.667,491.333
03-06 03:04:20,28.405,16.368,50.354,3.457,0.0,1.416,2.900,3.430,3.060,25659211776.0,2277376.0,610848768.0,5265072128.0,5182805.333,57607168.0,1265.333,14072.667,176.667,491.333
03-06 03:04:23,28.934,16.486,49.459,3.539,0.083,1.499,2.910,3.420,3.060,25660583936.0,2277376.0,640331776.0,5234216960.0,5242880.0,61266432.0,1280.0,14341.667,374.667,491.333
03-06 03:04:26,28.571,16.451,50.062,3.499,0.0,1.416,2.760,3.380,3.050,25661259776.0,2285568.0,669376512.0,5204488192.0,5166421.333,59216554.667,1261.0,14107.0,568.0,491.333
03-06 03:04:29,29.287,16.653,49.089,3.480,0.041,1.450,2.760,3.380,3.050,25661284352.0,2285568.0,699826176.0,5174013952.0,5274282.667,61455360.0,1288.0,14353.333,240.667,491.333
03-06 03:04:32,28.440,16.813,49.770,3.513,0.0,1.464,2.860,3.390,3.060,25662926848.0,2293760.0,729014272.0,5143175168.0,5261994.667,60376746.667,1284.667,14317.333,326.0,491.333
03-06 03:04:35,28.905,16.410,49.646,3.457,0.042,1.541,2.860,3.390,3.060,25663352832.0,2293760.0,758300672.0,5113462784.0,5221034.667,62725461.333,1274.667,14378.333,364.0,491.333
03-06 03:04:38,28.745,16.611,49.498,3.598,0.042,1.506,2.710,3.350,3.040,25664512000.0,2301952.0,787980288.0,5082615808.0,5264725.333,62144000.0,1285.333,14385.0,562.0,491.333
03-06 03:04:41,29.315,17.011,48.844,3.427,0.041,1.363,2.730,3.340,3.040,25665622016.0,2301952.0,817598464.0,5051887616.0,5293397.333,61555541.333,1292.333,14421.0,342.667,491.333
03-06 03:04:44,16.079,13.371,62.640,6.879,0.086,0.946,2.730,3.340,3.040,25644814336.0,39440384.0,32493568.0,5820661760.0,4202496.0,68218538.667,829.0,12066.0,463.667,591.333
03-06 03:04:47,16.769,15.845,56.558,9.507,0.264,1.056,2.670,3.320,3.040,25648087040.0,91648000.0,53215232.0,5744459776.0,3768320.0,83895637.333,920.333,15377.667,513.333,491.333
03-06 03:04:50,15.670,14.821,58.080,10.268,0.268,0.893,2.670,3.320,3.040,25648627712.0,115306496.0,74727424.0,5698748416.0,3645440.0,82106197.333,889.667,15043.0,605.667,514.667
03-06 03:04:53,16.175,15.371,57.328,9.696,0.268,1.162,2.700,3.310,3.040,25650241536.0,126787584.0,95780864.0,5664600064.0,3777877.333,85123072.0,922.667,15548.667,262.0,491.333
03-06 03:04:56,16.469,15.148,57.552,9.643,0.264,0.925,2.720,3.310,3.040,25650155520.0,131612672.0,116682752.0,5638959104.0,3670016.0,83415040.0,895.667,15065.0,334.667,491.333
03-06 03:04:59,15.975,15.573,57.207,9.817,0.268,1.160,2.720,3.310,3.040,25650933760.0,133976064.0,138555392.0,5613944832.0,3766954.667,86322517.333,920.0,15628.667,507.333,491.333
03-06 03:05:02,15.977,14.701,57.702,10.255,0.264,1.100,2.820,3.320,3.040,25651609600.0,134860800.0,158961664.0,5591977984.0,3594922.667,81716565.333,877.667,14762.0,230.0,491.333
03-06 03:05:05,15.378,14.141,58.948,9.987,0.265,1.281,2.820,3.320,3.040,25651871744.0,135233536.0,179175424.0,5571129344.0,3506176.0,81549994.667,855.667,14458.667,673.667,796.333
03-06 03:05:08,16.347,15.768,56.793,9.666,0.223,1.203,2.920,3.330,3.050,25652723712.0,135503872.0,200908800.0,5548273664.0,3816106.667,87052288.0,932.0,15711.333,2135.0,1750.333
03-06 03:05:11,15.892,15.228,57.857,9.739,0.266,1.018,3.080,3.360,3.060,25652977664.0,135634944.0,222490624.0,5526306816.0,3668650.667,84596053.333,895.333,15130.667,385.333,512.667
03-06 03:05:14,16.556,15.535,56.680,9.854,0.266,1.110,3.080,3.360,3.060,25654087680.0,135790592.0,243183616.0,5504348160.0,3781973.333,87348565.333,923.667,15688.333,394.0,491.333
03-06 03:05:17,16.041,15.416,57.239,9.875,0.313,1.117,3.160,3.370,3.060,25655115776.0,135901184.0,264630272.0,5481762816.0,3783338.667,88201898.667,923.333,15618.0,112.667,491.333
03-06 03:05:20,16.526,15.501,56.927,9.800,0.223,1.024,3.160,3.370,3.060,25654710272.0,136069120.0,286072832.0,5460557824.0,3787434.667,88980650.667,925.0,15680.667,198.0,491.333
03-06 03:05:23,16.622,15.782,56.587,9.726,0.221,1.061,3.060,3.350,3.060,25656098816.0,136171520.0,306929664.0,5438210048.0,3780608.0,86787413.333,922.667,15645.0,257.333,491.333
03-06 03:05:26,16.393,16.039,56.491,9.747,0.222,1.108,3.140,3.360,3.060,25656401920.0,136331264.0,328577024.0,5416099840.0,3766954.667,89381546.667,919.667,15611.333,176.667,491.333
03-06 03:05:29,16.785,15.589,56.422,9.699,0.221,1.284,3.140,3.360,3.060,25657057280.0,136413184.0,350314496.0,5393625088.0,3806549.333,87253504.0,929.667,15751.0,473.667,491.333
03-06 03:05:32,15.717,14.614,58.278,9.978,0.221,1.192,3.290,3.380,3.070,25657442304.0,136556544.0,370982912.0,5372428288.0,3563520.0,86290432.0,869.667,14849.667,219.333,491.333
03-06 03:05:35,15.965,14.430,58.509,9.781,0.219,1.096,3.290,3.380,3.070,25658560512.0,136654848.0,390082560.0,5352112128.0,3530752.0,81971882.667,862.333,14643.333,385.333,491.333
03-06 03:05:38,16.452,15.829,56.781,9.782,0.178,0.978,3.260,3.380,3.070,25659408384.0,136949760.0,411279360.0,5329772544.0,3822933.333,89512618.667,922.667,15634.0,353.333,491.333
03-06 03:05:41,15.239,14.708,58.613,10.115,0.309,1.016,3.320,3.390,3.080,25660121088.0,137379840.0,431661056.0,5308248064.0,3521194.667,85643264.0,859.333,15093.0,342.667,491.333
03-06 03:05:44,16.310,15.508,57.219,9.581,0.267,1.114,3.320,3.390,3.080,25660870656.0,137437184.0,453328896.0,5285773312.0,3810645.333,86071978.667,930.667,15664.667,356.0,491.333
03-06 03:05:47,16.253,15.988,56.599,9.655,0.221,1.284,3.380,3.400,3.080,25661943808.0,137502720.0,474808320.0,5263155200.0,3788800.0,86312277.333,924.667,15624.0,436.667,491.333
03-06 03:05:50,15.364,14.570,58.720,10.155,0.221,0.971,3.380,3.400,3.080,25661186048.0,137551872.0,495071232.0,5243600896.0,3558058.667,80680789.333,869.0,14609.0,155.333,736.667
03-06 03:05:53,16.028,15.004,57.792,9.751,0.223,1.202,3.510,3.420,3.090,25661030400.0,137596928.0,516378624.0,5222404096.0,3720533.333,83782314.667,908.0,15278.667,219.333,491.333
03-06 03:05:56,15.931,14.740,58.076,9.929,0.177,1.147,3.630,3.450,3.100,25661894656.0,137703424.0,536350720.0,5201461248.0,3631786.667,83734528.0,886.667,14990.0,542.667,1118.0
03-06 03:05:59,16.401,14.450,57.092,10.683,0.310,1.064,3.630,3.450,3.100,25662263296.0,137809920.0,556826624.0,5180510208.0,3661824.0,83295402.667,894.0,15066.667,155.333,491.333
03-06 03:06:02,16.851,15.480,56.745,9.730,0.133,1.061,3.740,3.470,3.110,25663016960.0,137883648.0,578220032.0,5158289408.0,3775146.667,86637226.667,921.667,15544.333,176.667,491.333
03-06 03:06:05,16.058,15.266,57.501,9.943,0.220,1.012,3.740,3.470,3.110,25663475712.0,138014720.0,598851584.0,5137068032.0,3588096.0,84368042.667,876.0,14987.0,497.0,796.333
03-06 03:06:08,15.871,14.677,57.162,10.964,0.265,1.061,3.840,3.500,3.120,25664921600.0,138096640.0,619417600.0,5114974208.0,3592192.0,83821909.333,877.333,14820.333,2165.667,1659.667
03-06 03:06:11,16.232,15.480,57.054,9.951,0.177,1.106,3.850,3.510,3.120,25665085440.0,138211328.0,640217088.0,5093896192.0,3697322.667,86313642.667,902.333,15389.333,530.0,512.667
03-06 03:06:14,16.079,14.758,57.401,10.396,0.264,1.101,3.850,3.510,3.120,25665449984.0,138301440.0,660705280.0,5072953344.0,3605845.333,82683221.333,880.667,14880.0,543.333,491.333
03-06 03:06:17,15.972,15.350,57.187,9.894,0.266,1.331,3.860,3.520,3.130,25666392064.0,138416128.0,681607168.0,5050994688.0,3712341.333,87418197.333,906.333,15380.0,240.667,491.333
03-06 03:06:20,15.456,14.880,58.282,10.097,0.221,1.063,3.860,3.520,3.130,25666605056.0,138502144.0,702005248.0,5030297600.0,3573077.333,82221738.667,872.333,14796.333,374.667,491.333
03-06 03:06:23,16.696,14.964,57.060,9.902,0.222,1.155,3.950,3.540,3.140,25667588096.0,138625024.0,722993152.0,5008203776.0,3749205.333,86930773.333,915.0,15506.667,278.667,491.333
03-06 03:06:26,16.305,15.374,56.890,10.058,0.310,1.063,4.040,3.560,3.150,25667842048.0,138764288.0,743948288.0,4986855424.0,3679573.333,87347200.0,898.333,15364.0,228.0,491.333
03-06 03:06:29,16.343,15.548,56.979,9.806,0.265,1.060,4.040,3.560,3.150,25669226496.0,138903552.0,764772352.0,4964507648.0,3694592.0,87699456.0,902.0,15325.667,249.333,491.333
03-06 03:06:32,16.336,15.497,56.909,9.801,0.265,1.192,4.030,3.570,3.150,25668980736.0,139018240.0,785719296.0,4943691776.0,3702784.0,85748394.667,904.0,15355.0,418.667,491.333
03-06 03:06:35,15.552,14.577,58.485,10.191,0.222,0.975,4.030,3.570,3.150,25670053888.0,139157504.0,805838848.0,4922359808.0,3538944.0,83532458.667,864.0,14618.333,353.333,491.333
03-06 03:06:38,14.896,14.495,59.938,9.337,0.222,1.112,4.110,3.590,3.160,25664380928.0,274432.0,401166336.0,5471588352.0,3406506.667,82563413.333,831.667,14478.667,351.333,491.333
03-06 03:06:41,13.798,13.620,62.023,9.272,0.266,1.020,4.020,3.580,3.160,25646587904.0,67477504.0,40296448.0,5783048192.0,4203861.333,79412224.0,819.0,13498.0,282.667,591.333
03-06 03:06:44,16.490,15.119,57.206,9.770,0.309,1.105,4.020,3.580,3.160,25648918528.0,103800832.0,60940288.0,5723750400.0,3685034.667,82871637.333,899.333,15137.667,198.0,491.333
03-06 03:06:47,16.468,15.408,56.998,9.801,0.265,1.060,3.940,3.570,3.160,25649979392.0,120852480.0,81698816.0,5684879360.0,3705514.667,82894336.0,905.0,15235.667,342.667,491.333
03-06 03:06:50,16.304,14.971,57.663,9.773,0.222,1.066,3.940,3.570,3.160,25651683328.0,128364544.0,102576128.0,5654786048.0,3687765.333,82836992.0,900.0,15135.667,283.333,491.333
03-06 03:06:53,16.418,15.540,56.936,9.658,0.263,1.185,3.860,3.560,3.160,25651363840.0,131690496.0,124067840.0,5630287872.0,3683669.333,84165802.667,899.667,15257.667,484.0,491.333
03-06 03:06:56,15.822,15.467,57.422,9.911,0.356,1.022,3.790,3.550,3.160,25652330496.0,133394432.0,145133568.0,5606551552.0,3694592.0,85300224.0,902.0,15268.333,301.667,491.333
03-06 03:06:59,16.267,15.289,57.200,9.867,0.267,1.111,3.790,3.550,3.160,25652396032.0,134234112.0,166068224.0,5584711680.0,3723264.0,84748458.667,909.0,15386.667,647.0,514.667
03-06 03:07:02,16.044,15.200,57.422,9.911,0.356,1.067,3.730,3.550,3.160,25652695040.0,134647808.0,186941440.0,5563125760.0,3695957.333,84535125.333,902.0,15254.0,219.333,491.333
03-06 03:07:05,16.071,14.746,57.748,10.022,0.309,1.104,3.730,3.550,3.160,25654063104.0,134774784.0,207429632.0,5541142528.0,3581269.333,83937109.333,874.667,14762.0,465.0,796.333
03-06 03:07:08,15.255,14.900,58.137,10.466,0.310,0.931,3.670,3.540,3.160,25654214656.0,134848512.0,227393536.0,5520953344.0,3548501.333,82195626.667,866.333,14710.667,1668.667,1691.667
03-06 03:07:11,15.466,14.148,58.524,10.633,0.220,1.011,3.700,3.540,3.160,25655164928.0,134852608.0,246882304.0,5500510208.0,3454293.333,79380992.0,843.0,14285.0,394.0,512.667
03-06 03:07:14,16.193,14.996,57.453,9.894,0.355,1.109,3.700,3.540,3.160,25656008704.0,134873088.0,267976704.0,5478551552.0,3667285.333,86640981.333,895.667,15159.333,415.333,491.333
03-06 03:07:17,16.674,15.042,57.124,9.925,0.265,0.970,3.720,3.550,3.170,25656279040.0,134889472.0,288759808.0,5457481728.0,3675477.333,83962709.333,897.0,15186.0,326.0,491.333
03-06 03:07:20,16.600,15.143,56.865,9.978,0.265,1.148,3.720,3.550,3.170,25657212928.0,134901760.0,309780480.0,5435514880.0,3690496.0,88172202.667,901.333,15336.667,176.667,491.333
03-06 03:07:23,16.201,15.357,57.257,9.765,0.266,1.154,3.660,3.540,3.160,25657712640.0,135053312.0,330715136.0,5413928960.0,3769685.333,85815466.667,910.0,15336.667,479.333,491.333
03-06 03:07:26,16.052,15.340,57.092,10.049,0.311,1.156,3.610,3.530,3.160,25658245120.0,135061504.0,351776768.0,5392326656.0,3675477.333,88478549.333,897.0,15342.0,313.333,491.333
03-06 03:07:29,16.050,15.158,57.601,9.897,0.267,1.025,3.610,3.530,3.160,25658429440.0,135065600.0,372793344.0,5371121664.0,3693226.667,87115776.0,901.667,15263.0,198.0,491.333
03-06 03:07:32,15.748,14.645,58.139,10.190,0.221,1.059,3.640,3.540,3.170,25659191296.0,135073792.0,392839168.0,5350305792.0,3526656.0,84147712.0,861.0,14704.0,313.333,491.333
03-06 03:07:35,16.110,14.731,57.810,9.969,0.267,1.113,3.640,3.540,3.170,25660088320.0,135073792.0,413401088.0,5328846848.0,3654997.333,86150314.667,892.667,15101.667,236.0,491.333
03-06 03:07:38,15.022,14.978,58.711,9.822,0.311,1.156,3.590,3.530,3.170,25659187200.0,135081984.0,433586176.0,5309554688.0,3560789.333,87499605.333,869.333,15033.667,566.0,491.333
03-06 03:07:41,16.089,15.067,57.556,9.956,0.222,1.111,3.620,3.540,3.170,25658908672.0,135081984.0,454672384.0,5288747008.0,3693226.667,83605504.0,901.333,15206.0,522.0,491.333
03-06 03:07:44,16.490,15.075,57.206,9.814,0.265,1.149,3.620,3.540,3.170,25660223488.0,135090176.0,475570176.0,5266526208.0,3700053.333,83498325.333,903.333,15189.0,283.333,491.333
03-06 03:07:47,15.734,15.249,57.867,9.872,0.264,1.014,3.570,3.530,3.170,25659805696.0,135090176.0,495812608.0,5246701568.0,3596288.0,81207978.667,878.0,14811.333,479.333,491.333
03-06 03:07:50,15.820,15.285,57.620,9.893,0.267,1.114,3.570,3.530,3.170,25660813312.0,135098368.0,517017600.0,5224480768.0,3713706.667,84644181.333,907.0,15196.333,430.667,491.333
03-06 03:07:53,16.113,15.139,57.415,9.872,0.266,1.195,3.530,3.520,3.170,25660502016.0,135098368.0,537890816.0,5203918848.0,3675477.333,82744490.667,897.0,15183.333,514.0,491.333
03-06 03:07:56,16.373,15.493,56.998,9.771,0.308,1.056,3.480,3.510,3.170,25661698048.0,135106560.0,558772224.0,5181833216.0,3683669.333,84207104.0,899.333,15164.0,488.0,525.333
03-06 03:07:59,16.475,15.371,57.200,9.717,0.221,1.016,3.480,3.510,3.170,25662083072.0,135106560.0,579592192.0,5160628224.0,3685034.667,86279168.0,899.667,15241.333,481.0,491.333
03-06 03:08:02,16.087,15.152,57.308,10.071,0.223,1.159,3.440,3.500,3.170,25662656512.0,135114752.0,600596480.0,5139042304.0,3700053.333,84910592.0,903.333,15376.333,438.667,491.333
03-06 03:08:05,16.469,15.148,57.023,10.040,0.264,1.057,3.440,3.500,3.170,25663295488.0,135114752.0,621305856.0,5117693952.0,3622229.333,84163072.0,884.667,15005.0,655.0,796.333
03-06 03:08:08,16.261,15.153,57.333,9.969,0.310,0.975,3.410,3.490,3.170,25663676416.0,135122944.0,642121728.0,5096488960.0,3671381.333,85938688.0,896.0,15146.0,1976.667,1643.667
03-06 03:08:11,16.755,15.075,56.852,9.947,0.265,1.105,3.380,3.480,3.170,25664602112.0,135127040.0,663158784.0,5074522112.0,3724629.333,85192021.333,909.333,15341.333,385.333,512.667
03-06 03:08:14,16.696,15.022,56.828,9.956,0.308,1.189,3.380,3.480,3.170,25664499712.0,135135232.0,684068864.0,5053706240.0,3667285.333,88052053.333,895.333,15279.333,1080.667,491.333
03-06 03:08:17,16.273,14.712,57.557,10.031,0.267,1.159,3.430,3.490,3.170,25665282048.0,135135232.0,704991232.0,5032001536.0,3686400.0,85055829.333,900.333,15279.667,633.333,491.333
03-06 03:08:20,16.755,14.894,57.137,9.929,0.222,1.064,3.430,3.490,3.170,25666920448.0,135143424.0,725946368.0,5009399808.0,3713706.667,88356352.0,906.333,15366.333,462.667,491.333
03-06 03:08:23,15.930,15.083,57.519,9.951,0.312,1.205,3.390,3.480,3.170,25666240512.0,135143424.0,746815488.0,4989210624.0,3702784.0,84962816.0,904.333,15281.667,554.0,491.333
03-06 03:08:26,16.089,15.244,57.244,10.0,0.356,1.067,3.440,3.490,3.170,25667936256.0,135151616.0,767856640.0,4966465536.0,3656362.667,88591018.667,892.333,15244.0,347.333,491.333
03-06 03:08:29,16.267,15.200,57.467,9.867,0.222,0.978,3.440,3.490,3.170,25668173824.0,135151616.0,788697088.0,4945387520.0,3694592.0,85156693.333,902.333,15266.333,658.667,491.333
03-06 03:08:32,16.489,14.933,57.156,10.0,0.267,1.156,3.480,3.500,3.180,25669816320.0,135159808.0,809766912.0,4922667008.0,3717802.667,88128170.667,907.333,15408.667,206.667,491.333

result.txt

########################################################################################################
### 20140603030120 fio1 / ITERATIONS:2 / TYPE:write
########################################################################################################
Benchmark
	Running for engine innodb
	Average number of seconds to run all queries: 59.786 seconds
	Minimum number of seconds to run all queries: 59.590 seconds
	Maximum number of seconds to run all queries: 59.982 seconds
	Number of clients running queries: 10
	Average number of queries per client: 50000

########################################################################################################
### 20140603030320 fio2 / ITERATIONS:2 / TYPE:write
########################################################################################################
Benchmark
	Running for engine innodb
	Average number of seconds to run all queries: 40.766 seconds
	Minimum number of seconds to run all queries: 40.725 seconds
	Maximum number of seconds to run all queries: 40.807 seconds
	Number of clients running queries: 10
	Average number of queries per client: 50000

########################################################################################################
### 20140603030442 hdd1 / ITERATIONS:2 / TYPE:write
########################################################################################################
Benchmark
	Running for engine innodb
	Average number of seconds to run all queries: 57.627 seconds
	Minimum number of seconds to run all queries: 57.350 seconds
	Maximum number of seconds to run all queries: 57.904 seconds
	Number of clients running queries: 10
	Average number of queries per client: 50000

########################################################################################################
### 20140603030638 hdd2 / ITERATIONS:2 / TYPE:write
########################################################################################################
Benchmark
	Running for engine innodb
	Average number of seconds to run all queries: 58.018 seconds
	Minimum number of seconds to run all queries: 57.861 seconds
	Maximum number of seconds to run all queries: 58.175 seconds
	Number of clients running queries: 10
	Average number of queries per client: 50000