[MariaDB]: YCSB Benchmarking
[ root @ http://dbversity.com : /mariadb ] ll -lhtr
total 388M
drwxr-xr-x 8 uucp 143 4.0K Mar 18 2014 jdk1.8.0_05
-rw-r–r– 1 sm70768 mongod 152M Jun 26 2014 jdk-8u5-linux-x64.gz
-rw-r–r– 1 sm70768 mongod 95M Jun 27 2014 ycsb-0.1.4.tar.gz
-rw-r–r– 1 sm70768 mongod 142M Aug 11 07:33 mariadb-galera-10.0.20-linux-x86_64.tar.gz
lrwxrwxrwx 1 root root 35 Sep 7 05:31 mysql -> mariadb-galera-10.0.20-linux-x86_64
drwxrwxr-x 12 1021 1004 4.0K Sep 7 07:46 mariadb-galera-10.0.20-linux-x86_64
drwxr-xr-x 17 root root 4.0K Sep 9 06:34 ycsb-0.1.4
[ root @ http://dbversity.com : /mariadb ]
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4 ] ll -lhtr
total 4.1M
-rw-r–r– 1 attivioid 20 479 Feb 18 2012 NOTICE.txt
-rw-r–r– 1 attivioid 20 7.9K Feb 18 2012 LICENSE.txt
drwxrwxrwx 2 attivioid 20 4.0K Feb 22 2012 workloads
-rw-r–r– 1 attivioid 20 2.3K Feb 23 2012 CHANGELOG
drwxrwxrwx 2 attivioid 20 4.0K Feb 24 2012 bin
-rw-r–r– 1 attivioid 20 952 Feb 24 2012 README
drwxr-xr-x 4 root root 4.0K Mar 17 05:21 mysql-connector-java-5.1.35
drwxr-xr-x 3 root root 4.0K Sep 9 05:17 core
drwxr-xr-x 4 root root 4.0K Sep 9 05:17 hbase-binding
drwxr-xr-x 3 root root 4.0K Sep 9 05:17 cassandra-binding
drwxr-xr-x 4 root root 4.0K Sep 9 05:17 gemfire-binding
drwxr-xr-x 4 root root 4.0K Sep 9 05:17 infinispan-binding
drwxr-xr-x 4 root root 4.0K Sep 9 05:17 jdbc-binding
drwxr-xr-x 3 root root 4.0K Sep 9 05:17 mapkeeper-binding
drwxr-xr-x 3 root root 4.0K Sep 9 05:17 mongodb-binding
drwxr-xr-x 4 root root 4.0K Sep 9 05:17 nosqldb-binding
drwxr-xr-x 3 root root 4.0K Sep 9 05:17 redis-binding
drwxr-xr-x 4 root root 4.0K Sep 9 05:17 voldemort-binding
-rw-r–r– 1 root root 363 Sep 9 05:57 inittable.sql
-rw-r–r– 1 root root 4.0M Sep 9 06:21 mysql-connector-java-5.1.35.zip
-rw-r–r– 1 root root 1.4K Sep 9 06:34 ycsb_script.sh
drwxr-xr-x 2 root root 4.0K Sep 9 19:48 logs
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4 ]
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4 ] cat inittable.sql
use ycsb;
DROP TABLE usertable;
CREATE TABLE usertable (YCSB_KEY varchar(255) PRIMARY KEY,
FIELD1 varchar(255), FIELD2 varchar(255),
FIELD3 varchar(255), FIELD4 varchar(255),
FIELD5 varchar(255), FIELD6 varchar(255),
FIELD7 varchar(255), FIELD8 varchar(255),
FIELD9 varchar(255), FIELD10 varchar(255));
set global autocommit=ON;
exit
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4 ]
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4 ] cat ycsb_script.sh
export YCSBHOME=/mariadb/ycsb-0.1.4
mysql -D ycsb < $YCSBHOME/inittable.sql
cd /mariadb/ycsb-0.1.4/logs
if [ -z “${host}” ]; then host=`hostname -s`; fi
host=`echo $host | sed ‘s/\-/_/g’`
if [ -z “${tag}” ]; then LOGSUFFIX=`date +”%y%m%d%H%M”`; else LOGSUFFIX=${tag}; fi
mysql -D ycsb < $YCSBHOME/inittable.sql
### To Load the workload data#####
${YCSBHOME}/bin/ycsb load jdbc -P ${YCSBHOME}/workloads/workloada -P ${YCSBHOME}/jdbc-binding/conf/db.properties -p recordcount=1000000 -p operationcount=1000000 -p readallfields=true -p hotspotdatafraction=1 -p insertorder=ordered -threads 50
for th in 50 35 25 10
do
for wl in a b c d f
do
echo “Results for $th thread – workload $wl are … ” >> ${YCSBHOME}/logs/$th\_thread_$wl\_workload_logs.txt
echo ” Workload $wl with $th thread started … “
DTSTART=`date +”%y/%m/%d %H:%M:%S”`
${YCSBHOME}/bin/ycsb run jdbc -s -P ${YCSBHOME}/workloads/workload$wl -P ${YCSBHOME}/jdbc-binding/conf/db.properties -p recordcount=1000000 -p operationcount=1000000 -p readallfields=true -p hotspotdatafraction=1 -p insertorder=ordered -threads $th >> ${YCSBHOME}/logs/ycsb-${host}-${wl}-run-${th}-${LOGSUFFIX}.log 2>&1
DTEND=`date +”%y/%m/%d %H:%M:%S”`
echo ” Workload $wl with $th thread completed … “
echo “ycsbrun,${host},${wl},${DTSTART},${DTEND},${LOGSUFFIX},${th}” >> ${YCSBHOME}/logs/ycsbtest.log
done
done
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4 ]
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4 ] cd logs/
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4/logs ]
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4/logs ] ll -lhtr
total 26M
-rw-r–r– 1 root root 44 Sep 9 09:17 50_thread_a_workload_logs.txt
-rw-r–r– 1 root root 99K Sep 9 10:40 ycsb-vm_7d85_546b-a-run-50-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 10:40 50_thread_b_workload_logs.txt
-rw-r–r– 1 root root 44K Sep 9 10:49 ycsb-vm_7d85_546b-b-run-50-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 10:49 50_thread_c_workload_logs.txt
-rw-r–r– 1 root root 21K Sep 9 10:50 ycsb-vm_7d85_546b-c-run-50-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 10:50 50_thread_d_workload_logs.txt
-rw-r–r– 1 root root 44K Sep 9 10:58 ycsb-vm_7d85_546b-d-run-50-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 10:58 50_thread_f_workload_logs.txt
-rw-r–r– 1 root root 149K Sep 9 12:21 ycsb-vm_7d85_546b-f-run-50-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 12:21 35_thread_a_workload_logs.txt
-rw-r–r– 1 root root 97K Sep 9 13:44 ycsb-vm_7d85_546b-a-run-35-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 13:44 35_thread_b_workload_logs.txt
-rw-r–r– 1 root root 43K Sep 9 13:52 ycsb-vm_7d85_546b-b-run-35-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 13:52 35_thread_c_workload_logs.txt
-rw-r–r– 1 root root 20K Sep 9 13:53 ycsb-vm_7d85_546b-c-run-35-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 13:53 35_thread_d_workload_logs.txt
-rw-r–r– 1 root root 8.1M Sep 9 13:54 ycsb-vm_7d85_546b-d-run-35-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 13:54 35_thread_f_workload_logs.txt
-rw-r–r– 1 root root 147K Sep 9 15:17 ycsb-vm_7d85_546b-f-run-35-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 15:17 25_thread_a_workload_logs.txt
-rw-r–r– 1 root root 96K Sep 9 16:39 ycsb-vm_7d85_546b-a-run-25-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 16:39 25_thread_b_workload_logs.txt
-rw-r–r– 1 root root 42K Sep 9 16:48 ycsb-vm_7d85_546b-b-run-25-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 16:48 25_thread_c_workload_logs.txt
-rw-r–r– 1 root root 19K Sep 9 16:49 ycsb-vm_7d85_546b-c-run-25-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 16:49 25_thread_d_workload_logs.txt
-rw-r–r– 1 root root 8.1M Sep 9 16:50 ycsb-vm_7d85_546b-d-run-25-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 16:50 25_thread_f_workload_logs.txt
-rw-r–r– 1 root root 146K Sep 9 18:12 ycsb-vm_7d85_546b-f-run-25-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 18:12 10_thread_a_workload_logs.txt
-rw-r–r– 1 root root 97K Sep 9 19:37 ycsb-vm_7d85_546b-a-run-10-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 19:37 10_thread_b_workload_logs.txt
-rw-r–r– 1 root root 41K Sep 9 19:46 ycsb-vm_7d85_546b-b-run-10-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 19:46 10_thread_c_workload_logs.txt
-rw-r–r– 1 root root 18K Sep 9 19:47 ycsb-vm_7d85_546b-c-run-10-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 19:47 10_thread_d_workload_logs.txt
-rw-r–r– 1 root root 8.2M Sep 9 19:48 ycsb-vm_7d85_546b-d-run-10-1509090635.log
-rw-r–r– 1 root root 44 Sep 9 19:48 10_thread_f_workload_logs.txt
-rw-r–r– 1 root root 146K Sep 9 21:12 ycsb-vm_7d85_546b-f-run-10-1509090635.log
-rw-r–r– 1 root root 1.5K Sep 9 21:12 ycsbtest.log
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4/logs ]
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4/logs ]
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4/logs ] mkdir old_logs
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4/logs ]
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4/logs ] mv * old_logs/
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4/logs ]
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4/logs ]
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4/logs ]
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4/logs ] ll -lhtr
total 4.0K
drwxr-xr-x 2 root root 4.0K Sep 10 03:23 old_logs
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4/logs ]
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4/logs ]
[ root @ http://dbversity.com : /mariadb/ycsb-0.1.4/logs ]
output
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ] grep “RunTime(ms)” *.log
ycsb-dbversity-a-run-10-1509140827.log:[OVERALL], RunTime(ms), 5024253.0
ycsb-dbversity-a-run-25-1509140827.log:[OVERALL], RunTime(ms), 4997542.0
ycsb-dbversity-a-run-35-1509140827.log:[OVERALL], RunTime(ms), 4969834.0
ycsb-dbversity-a-run-50-1509140827.log:[OVERALL], RunTime(ms), 4993553.0
ycsb-dbversity-b-run-10-1509140827.log:[OVERALL], RunTime(ms), 503673.0
ycsb-dbversity-b-run-25-1509140827.log:[OVERALL], RunTime(ms), 510433.0
ycsb-dbversity-b-run-35-1509140827.log:[OVERALL], RunTime(ms), 498347.0
ycsb-dbversity-b-run-50-1509140827.log:[OVERALL], RunTime(ms), 501286.0
ycsb-dbversity-c-run-10-1509140827.log:[OVERALL], RunTime(ms), 68716.0
ycsb-dbversity-c-run-25-1509140827.log:[OVERALL], RunTime(ms), 69257.0
ycsb-dbversity-c-run-35-1509140827.log:[OVERALL], RunTime(ms), 66119.0
ycsb-dbversity-c-run-50-1509140827.log:[OVERALL], RunTime(ms), 63279.0
ycsb-dbversity-d-run-10-1509140827.log:[OVERALL], RunTime(ms), 51729.0
ycsb-dbversity-d-run-25-1509140827.log:[OVERALL], RunTime(ms), 55984.0
ycsb-dbversity-d-run-35-1509140827.log:[OVERALL], RunTime(ms), 54470.0
ycsb-dbversity-d-run-50-1509140827.log:[OVERALL], RunTime(ms), 488607.0
ycsb-dbversity-f-run-10-1509140827.log:[OVERALL], RunTime(ms), 3206004.0
ycsb-dbversity-f-run-25-1509140827.log:[OVERALL], RunTime(ms), 5172777.0
ycsb-dbversity-f-run-35-1509140827.log:[OVERALL], RunTime(ms), 4957732.0
ycsb-dbversity-f-run-50-1509140827.log:[OVERALL], RunTime(ms), 4983570.0
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ] grep “Throughput(ops/sec)” *.log
ycsb-dbversity-a-run-10-1509140827.log:[OVERALL], Throughput(ops/sec), 199.03456294895977
ycsb-dbversity-a-run-25-1509140827.log:[OVERALL], Throughput(ops/sec), 200.09836835788474
ycsb-dbversity-a-run-35-1509140827.log:[OVERALL], Throughput(ops/sec), 201.21094587867523
ycsb-dbversity-a-run-50-1509140827.log:[OVERALL], Throughput(ops/sec), 200.25821293976452
ycsb-dbversity-b-run-10-1509140827.log:[OVERALL], Throughput(ops/sec), 1985.4151403787776
ycsb-dbversity-b-run-25-1509140827.log:[OVERALL], Throughput(ops/sec), 1959.1209815979767
ycsb-dbversity-b-run-35-1509140827.log:[OVERALL], Throughput(ops/sec), 2006.6038322694828
ycsb-dbversity-b-run-50-1509140827.log:[OVERALL], Throughput(ops/sec), 1994.8691964267903
ycsb-dbversity-c-run-10-1509140827.log:[OVERALL], Throughput(ops/sec), 14552.651493102043
ycsb-dbversity-c-run-25-1509140827.log:[OVERALL], Throughput(ops/sec), 14438.973677750986
ycsb-dbversity-c-run-35-1509140827.log:[OVERALL], Throughput(ops/sec), 15124.018814561623
ycsb-dbversity-c-run-50-1509140827.log:[OVERALL], Throughput(ops/sec), 15803.031021349894
ycsb-dbversity-d-run-10-1509140827.log:[OVERALL], Throughput(ops/sec), 19331.516170813276
ycsb-dbversity-d-run-25-1509140827.log:[OVERALL], Throughput(ops/sec), 17862.246356101743
ycsb-dbversity-d-run-35-1509140827.log:[OVERALL], Throughput(ops/sec), 18358.45419496971
ycsb-dbversity-d-run-50-1509140827.log:[OVERALL], Throughput(ops/sec), 2046.6346163685744
ycsb-dbversity-f-run-10-1509140827.log:[OVERALL], Throughput(ops/sec), 311.9147699129508
ycsb-dbversity-f-run-25-1509140827.log:[OVERALL], Throughput(ops/sec), 193.31975841989708
ycsb-dbversity-f-run-35-1509140827.log:[OVERALL], Throughput(ops/sec), 201.70210894820454
ycsb-dbversity-f-run-50-1509140827.log:[OVERALL], Throughput(ops/sec), 200.65936667890688
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ] cat ycsbtest.log
ycsbrun,dbversity,a,15/09/14 11:10:16,15/09/14 12:33:30,1509140827,50
ycsbrun,dbversity,b,15/09/14 12:33:30,15/09/14 12:41:51,1509140827,50
ycsbrun,dbversity,c,15/09/14 12:41:51,15/09/14 12:42:55,1509140827,50
ycsbrun,dbversity,d,15/09/14 12:42:55,15/09/14 12:51:04,1509140827,50
ycsbrun,dbversity,f,15/09/14 12:51:04,15/09/14 14:14:08,1509140827,50
ycsbrun,dbversity,a,15/09/14 14:14:08,15/09/14 15:36:58,1509140827,35
ycsbrun,dbversity,b,15/09/14 15:36:58,15/09/14 15:45:16,1509140827,35
ycsbrun,dbversity,c,15/09/14 15:45:16,15/09/14 15:46:23,1509140827,35
ycsbrun,dbversity,d,15/09/14 15:46:23,15/09/14 15:47:17,1509140827,35
ycsbrun,dbversity,f,15/09/14 15:47:17,15/09/14 17:09:55,1509140827,35
ycsbrun,dbversity,a,15/09/14 17:09:55,15/09/14 18:33:13,1509140827,25
ycsbrun,dbversity,b,15/09/14 18:33:13,15/09/14 18:41:44,1509140827,25
ycsbrun,dbversity,c,15/09/14 18:41:44,15/09/14 18:42:53,1509140827,25
ycsbrun,dbversity,d,15/09/14 18:42:53,15/09/14 18:43:50,1509140827,25
ycsbrun,dbversity,f,15/09/14 18:43:50,15/09/14 20:10:03,1509140827,25
ycsbrun,dbversity,a,15/09/14 20:10:03,15/09/14 21:33:47,1509140827,10
ycsbrun,dbversity,b,15/09/14 21:33:47,15/09/14 21:42:11,1509140827,10
ycsbrun,dbversity,c,15/09/14 21:42:11,15/09/14 21:43:20,1509140827,10
ycsbrun,dbversity,d,15/09/14 21:43:20,15/09/14 21:44:12,1509140827,10
ycsbrun,dbversity,f,15/09/14 21:44:12,15/09/14 22:37:38,1509140827,10
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ] ll -lhtr
total 98M
drwxr-xr-x 2 root root 4.0K Sep 10 03:23 old_logs
-rw-r–r– 1 root root 44 Sep 14 11:10 50_thread_a_workload_logs.txt
-rw-r–r– 1 root root 99K Sep 14 12:33 ycsb-dbversity-a-run-50-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 12:33 50_thread_b_workload_logs.txt
-rw-r–r– 1 root root 44K Sep 14 12:41 ycsb-dbversity-b-run-50-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 12:41 50_thread_c_workload_logs.txt
-rw-r–r– 1 root root 21K Sep 14 12:42 ycsb-dbversity-c-run-50-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 12:42 50_thread_d_workload_logs.txt
-rw-r–r– 1 root root 43K Sep 14 12:51 ycsb-dbversity-d-run-50-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 12:51 50_thread_f_workload_logs.txt
-rw-r–r– 1 root root 149K Sep 14 14:14 ycsb-dbversity-f-run-50-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 14:14 35_thread_a_workload_logs.txt
-rw-r–r– 1 root root 98K Sep 14 15:36 ycsb-dbversity-a-run-35-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 15:36 35_thread_b_workload_logs.txt
-rw-r–r– 1 root root 43K Sep 14 15:45 ycsb-dbversity-b-run-35-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 15:45 35_thread_c_workload_logs.txt
-rw-r–r– 1 root root 20K Sep 14 15:46 ycsb-dbversity-c-run-35-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 15:46 35_thread_d_workload_logs.txt
-rw-r–r– 1 root root 8.2M Sep 14 15:47 ycsb-dbversity-d-run-35-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 15:47 35_thread_f_workload_logs.txt
-rw-r–r– 1 root root 147K Sep 14 17:09 ycsb-dbversity-f-run-35-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 17:09 25_thread_a_workload_logs.txt
-rw-r–r– 1 root root 97K Sep 14 18:33 ycsb-dbversity-a-run-25-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 18:33 25_thread_b_workload_logs.txt
-rw-r–r– 1 root root 42K Sep 14 18:41 ycsb-dbversity-b-run-25-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 18:41 25_thread_c_workload_logs.txt
-rw-r–r– 1 root root 19K Sep 14 18:42 ycsb-dbversity-c-run-25-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 18:42 25_thread_d_workload_logs.txt
-rw-r–r– 1 root root 8.2M Sep 14 18:43 ycsb-dbversity-d-run-25-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 18:43 25_thread_f_workload_logs.txt
-rw-r–r– 1 root root 150K Sep 14 20:10 ycsb-dbversity-f-run-25-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 20:10 10_thread_a_workload_logs.txt
-rw-r–r– 1 root root 96K Sep 14 21:33 ycsb-dbversity-a-run-10-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 21:33 10_thread_b_workload_logs.txt
-rw-r–r– 1 root root 41K Sep 14 21:42 ycsb-dbversity-b-run-10-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 21:42 10_thread_c_workload_logs.txt
-rw-r–r– 1 root root 18K Sep 14 21:43 ycsb-dbversity-c-run-10-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 21:43 10_thread_d_workload_logs.txt
-rw-r–r– 1 root root 8.1M Sep 14 21:44 ycsb-dbversity-d-run-10-1509140827.log
-rw-r–r– 1 root root 44 Sep 14 21:44 10_thread_f_workload_logs.txt
-rw-r–r– 1 root root 72M Sep 14 22:37 ycsb-dbversity-f-run-10-1509140827.log
-rw-r–r– 1 root root 1.5K Sep 14 22:37 ycsbtest.log
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ] grep “operations” *.log | grep “current ops/sec” | grep “a-run-” | egrep “1000000|999[0-9][0-9][0-9]”
ycsb-dbversity-a-run-10-1509140827.log: 5024 sec: 1000000 operations; 38.11 current ops/sec; [READ AverageLatency(us)=285.68] [UPDATE AverageLatency(us)=47023.94]
ycsb-dbversity-a-run-25-1509140827.log: 4997 sec: 1000000 operations; 150.16 current ops/sec; [READ AverageLatency(us)=294.06] [UPDATE AverageLatency(us)=83977.58]
ycsb-dbversity-a-run-35-1509140827.log: 4969 sec: 999985 operations; 163.39 current ops/sec; [READ AverageLatency(us)=288.05] [UPDATE AverageLatency(us)=67215.89]
ycsb-dbversity-a-run-50-1509140827.log: 4993 sec: 1000000 operations; 52.51 current ops/sec; [READ AverageLatency(us)=282.12] [UPDATE AverageLatency(us)=47749.3]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ] grep “operations” *.log | grep “current ops/sec” | grep “b-run-” | egrep “1000000|999[0-9][0-9][0-9]”
ycsb-dbversity-b-run-10-1509140827.log: 503 sec: 1000000 operations; 422.32 current ops/sec; [READ AverageLatency(us)=226.31] [UPDATE AverageLatency(us)=47096.44]
ycsb-dbversity-b-run-25-1509140827.log: 510 sec: 1000000 operations; 332.44 current ops/sec; [READ AverageLatency(us)=208.84] [UPDATE AverageLatency(us)=45894.12]
ycsb-dbversity-b-run-35-1509140827.log: 498 sec: 999985 operations; 1500.84 current ops/sec; [READ AverageLatency(us)=467.85] [UPDATE AverageLatency(us)=122453.07]
ycsb-dbversity-b-run-50-1509140827.log: 501 sec: 1000000 operations; 802.6 current ops/sec; [READ AverageLatency(us)=248.56] [UPDATE AverageLatency(us)=50164.17]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ] grep “operations” *.log | grep “current ops/sec” | grep “c-run-” | egrep “1000000|999[0-9][0-9][0-9]”
ycsb-dbversity-c-run-10-1509140827.log: 68 sec: 1000000 operations; 14654.93 current ops/sec; [READ AverageLatency(us)=634.48]
ycsb-dbversity-c-run-25-1509140827.log: 69 sec: 1000000 operations; 14822.62 current ops/sec; [READ AverageLatency(us)=1586.65]
ycsb-dbversity-c-run-35-1509140827.log: 66 sec: 999985 operations; 15553.82 current ops/sec; [READ AverageLatency(us)=2083.99]
ycsb-dbversity-c-run-50-1509140827.log: 63 sec: 1000000 operations; 16048.46 current ops/sec; [READ AverageLatency(us)=2651.03]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ] grep “operations” *.log | grep “current ops/sec” | grep “d-run-” | egrep “1000000|999[0-9][0-9][0-9]”
ycsb-dbversity-d-run-10-1509140827.log: 51 sec: 1000000 operations; 19208.36 current ops/sec; [READ AverageLatency(us)=421.45] [INSERT AverageLatency(us)=491.99]
ycsb-dbversity-d-run-25-1509140827.log: 55 sec: 1000000 operations; 14282.25 current ops/sec; [READ AverageLatency(us)=1169.93] [INSERT AverageLatency(us)=2691.9]
ycsb-dbversity-d-run-35-1509140827.log: 54 sec: 999985 operations; 19955.46 current ops/sec; [READ AverageLatency(us)=1604.62] [INSERT AverageLatency(us)=2019.52]
ycsb-dbversity-d-run-50-1509140827.log: 488 sec: 1000000 operations; 1877.44 current ops/sec; [READ AverageLatency(us)=201.06] [INSERT AverageLatency(us)=175834.39]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ] grep “operations” *.log | grep “current ops/sec” | grep “e-run-” | egrep “1000000|999[0-9][0-9][0-9]”
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ] grep “operations” *.log | grep “current ops/sec” | grep “f-run-” | egrep “1000000|999[0-9][0-9][0-9]”
ycsb-dbversity-f-run-10-1509140827.log: 3206 sec: 1000000 operations; 20003.89 current ops/sec; [READ AverageLatency(us)=261.13] [READ-MODIFY-WRITE AverageLatency(us)=0.53] [UPDATE AverageLatency(us)=227.27]
ycsb-dbversity-f-run-25-1509140827.log: 5172 sec: 1000000 operations; 67.19 current ops/sec; [READ AverageLatency(us)=284.25] [READ-MODIFY-WRITE AverageLatency(us)=47.92] [UPDATE AverageLatency(us)=47604.16]
ycsb-dbversity-f-run-35-1509140827.log: 4957 sec: 999985 operations; 94.34 current ops/sec; [READ AverageLatency(us)=261.85] [READ-MODIFY-WRITE AverageLatency(us)=51.62] [UPDATE AverageLatency(us)=51399.37]
ycsb-dbversity-f-run-50-1509140827.log: 4983 sec: 1000000 operations; 62.2 current ops/sec; [READ AverageLatency(us)=275.93] [READ-MODIFY-WRITE AverageLatency(us)=49.66] [UPDATE AverageLatency(us)=49345.98]
[ root @ dbversity : /mariadb/ycsb-0.1.4/logs ]