YCSB Benchmarks on Amazon RDS Oracle

July 14, 2015 · by dbversity · in Oracle DB

[root@ip-10-0-0-67 ycsb-0.1.4]# ll -lhtr
total 16M
-rw-r–r–. 1 501 games 479 Feb 18 2012 NOTICE.txt
-rw-r–r–. 1 501 games 7.9K Feb 18 2012 LICENSE.txt
drwxrwxrwx. 2 501 games 102 Feb 22 2012 workloads
-rw-r–r–. 1 501 games 2.3K Feb 23 2012 CHANGELOG
drwxrwxrwx. 2 501 games 31 Feb 24 2012 bin
-rw-r–r–. 1 501 games 952 Feb 24 2012 README
drwxr-xr-x. 3 root root 16 Jul 7 06:47 core
drwxr-xr-x. 3 root root 29 Jul 7 06:47 mapkeeper-binding
-rw-r–r–. 1 root root 1.6K Jul 8 01:33 ycsb_script.sh
-rw-r–r–. 1 root root 950K Jul 8 01:36 mysql-connector-java-5.1.36-bin.jar
-rw-r–r–. 1 root root 311 Jul 8 06:22 inittable.sql_bkp_mysql
-rw-r–r–. 1 root root 691 Jul 8 06:25 inittable.sql
-rw-r–r–. 1 root root 6.7M Jul 8 09:26 jdbc-binding-0.1.4.jar
-rw-r–r–. 1 root root 3.3M Jul 8 09:59 ojdbc7.jar
drwxr-xr-x. 4 root root 86 Jul 8 10:07 jdbc-binding
-rw-r–r–. 1 root root 2.7M Jul 13 06:43 ojdbc6.jar
-rw-r–r–. 1 root root 2.0M Jul 13 06:43 ojdbc5.jar
-rwxrwxrwx. 1 root root 3.2K Jul 13 07:13 ycsbloop.sh
-rw-r–r–. 1 root root 3.0K Jul 13 09:48 new_ycsbloop.sh
-rw-r–r–. 1 root root 146 Jul 13 10:03 ycsbtest.log
-rwxrwxrwx. 1 root root 1.6K Jul 13 10:04 oracle_ycsb_loop.sh
drwxr-xr-x. 5 root root 63 Jul 14 02:07 logs
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]# ll -lhtr jdbc-binding/
total 4.2M
-rw-r–r–. 1 root root 3.3M Jul 8 10:07 ojdbc7.jar
-rw-r–r–. 1 root root 950K Jul 8 10:07 mysql-connector-java-5.1.36-bin.jar
drwxr-xr-x. 2 root root 4.0K Jul 13 06:42 lib
drwxrwxrwx. 2 501 games 46 Jul 13 06:54 conf
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]# ll -lhtr jdbc-binding/lib/
total 16M
-rw-r–r–. 1 501 games 6.7M Feb 24 2012 jdbc-binding-0.1.4.jar
-rw-r–r–. 1 root root 3.3M Jul 8 10:06 ojdbc7.jar
-rw-r–r–. 1 root root 950K Jul 8 10:06 mysql-connector-java-5.1.36-bin.jar
-rw-r–r–. 1 root root 2.0M Jul 13 06:42 ojdbc5.jar
-rw-r–r–. 1 root root 2.7M Jul 13 06:42 ojdbc6.jar
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]# ll -lhtr jdbc-binding/conf/
total 8.0K
-rw-r–r–. 1 501 games 158 Feb 18 2012 h2.properties
-rw-r–r–. 1 501 games 228 Jul 13 06:54 db.properties
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]# cat jdbc-binding/conf/db.properties
# Properties file that contains database connection information.

jdbc.driver=oracle.jdbc.OracleDriver
db.url=jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
db.user=oracledb
db.passwd=oracledb
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]# pwd
/home/ec2-user/ycsb-0.1.4
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]# sqlplus oracledb/oracledb@//oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521/oracledb

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 14 02:19:58 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.4.0 – 64bit Production

SQL>
SQL> exit
Disconnected from Oracle Database 11g Release 11.2.0.4.0 – 64bit Production
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]# cat inittable.sql
DROP TABLE usertable;

CREATE TABLE usertable (YCSB_KEY NVARCHAR2(255) PRIMARY KEY,
FIELD1 NVARCHAR2(255), FIELD2 NVARCHAR2(255),
FIELD3 NVARCHAR2(255), FIELD4 NVARCHAR2(255),
FIELD5 NVARCHAR2(255), FIELD6 NVARCHAR2(255),
FIELD7 NVARCHAR2(255), FIELD8 NVARCHAR2(255),
FIELD9 NVARCHAR2(255), FIELD10 NVARCHAR2(255));

SET AUTOCOMMIT ON;
EXIT;
#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));

#exit
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]# ll -lhtr
total 16M
-rw-r–r–. 1 501 games 479 Feb 18 2012 NOTICE.txt
-rw-r–r–. 1 501 games 7.9K Feb 18 2012 LICENSE.txt
drwxrwxrwx. 2 501 games 102 Feb 22 2012 workloads
-rw-r–r–. 1 501 games 2.3K Feb 23 2012 CHANGELOG
drwxrwxrwx. 2 501 games 31 Feb 24 2012 bin
-rw-r–r–. 1 501 games 952 Feb 24 2012 README
drwxr-xr-x. 3 root root 16 Jul 7 06:47 core
drwxr-xr-x. 3 root root 29 Jul 7 06:47 mapkeeper-binding
-rw-r–r–. 1 root root 1.6K Jul 8 01:33 ycsb_script.sh
-rw-r–r–. 1 root root 950K Jul 8 01:36 mysql-connector-java-5.1.36-bin.jar
-rw-r–r–. 1 root root 311 Jul 8 06:22 inittable.sql_bkp_mysql
-rw-r–r–. 1 root root 691 Jul 8 06:25 inittable.sql
-rw-r–r–. 1 root root 6.7M Jul 8 09:26 jdbc-binding-0.1.4.jar
-rw-r–r–. 1 root root 3.3M Jul 8 09:59 ojdbc7.jar
drwxr-xr-x. 4 root root 86 Jul 8 10:07 jdbc-binding
-rw-r–r–. 1 root root 2.7M Jul 13 06:43 ojdbc6.jar
-rw-r–r–. 1 root root 2.0M Jul 13 06:43 ojdbc5.jar
-rwxrwxrwx. 1 root root 3.2K Jul 13 07:13 ycsbloop.sh
-rw-r–r–. 1 root root 3.0K Jul 13 09:48 new_ycsbloop.sh
-rw-r–r–. 1 root root 146 Jul 13 10:03 ycsbtest.log
-rw-r–r–. 1 root root 1.6K Jul 13 10:04 ~
-rwxrwxrwx. 1 root root 1.6K Jul 13 10:04 oracle_ycsb_loop.sh
drwxr-xr-x. 5 root root 63 Jul 14 02:07 logs
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]# cat oracle_ycsb_loop.sh
export ORACLE_HOME=/home/ec2-user/ycsb-0.1.4
export YCSBHOME=/home/ec2-user/ycsb-0.1.4
sqlplus oracledb/oracledb@//oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521/oracledb @$YCSBHOME/inittable.sql

cd /home/ec2-user/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

sqlplus oracledb/oracledb@//oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521/oracledb @$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@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]# ll -lhtr logs/actual_oracle_logs/
total 24M
-rw-r–r–. 1 root root 46 Jul 13 10:10 50_thread_a_workload_logs.txt
-rw-r–r–. 1 root root 60K Jul 13 10:12 ycsb–a-run-50-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:12 50_thread_b_workload_logs.txt
-rw-r–r–. 1 root root 59K Jul 13 10:14 ycsb–b-run-50-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:14 50_thread_c_workload_logs.txt
-rw-r–r–. 1 root root 42K Jul 13 10:16 ycsb–c-run-50-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:16 50_thread_d_workload_logs.txt
-rw-r–r–. 1 root root 59K Jul 13 10:17 ycsb–d-run-50-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:17 50_thread_f_workload_logs.txt
-rw-r–r–. 1 root root 89K Jul 13 10:20 ycsb–f-run-50-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:20 35_thread_a_workload_logs.txt
-rw-r–r–. 1 root root 58K Jul 13 10:23 ycsb–a-run-35-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:23 35_thread_b_workload_logs.txt
-rw-r–r–. 1 root root 57K Jul 13 10:24 ycsb–b-run-35-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:24 35_thread_c_workload_logs.txt
-rw-r–r–. 1 root root 40K Jul 13 10:26 ycsb–c-run-35-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:26 35_thread_d_workload_logs.txt
-rw-r–r–. 1 root root 7.7M Jul 13 10:28 ycsb–d-run-35-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:28 35_thread_f_workload_logs.txt
-rw-r–r–. 1 root root 87K Jul 13 10:31 ycsb–f-run-35-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:31 25_thread_a_workload_logs.txt
-rw-r–r–. 1 root root 57K Jul 13 10:34 ycsb–a-run-25-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:34 25_thread_b_workload_logs.txt
-rw-r–r–. 1 root root 56K Jul 13 10:36 ycsb–b-run-25-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:36 25_thread_c_workload_logs.txt
-rw-r–r–. 1 root root 39K Jul 13 10:37 ycsb–c-run-25-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:37 25_thread_d_workload_logs.txt
-rw-r–r–. 1 root root 7.7M Jul 13 10:39 ycsb–d-run-25-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:39 25_thread_f_workload_logs.txt
-rw-r–r–. 1 root root 86K Jul 13 10:43 ycsb–f-run-25-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:43 10_thread_a_workload_logs.txt
-rw-r–r–. 1 root root 57K Jul 13 10:48 ycsb–a-run-10-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:48 10_thread_b_workload_logs.txt
-rw-r–r–. 1 root root 54K Jul 13 10:50 ycsb–b-run-10-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:50 10_thread_c_workload_logs.txt
-rw-r–r–. 1 root root 37K Jul 13 10:52 ycsb–c-run-10-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:52 10_thread_d_workload_logs.txt
-rw-r–r–. 1 root root 7.6M Jul 13 10:56 ycsb–d-run-10-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:56 10_thread_f_workload_logs.txt
-rw-r–r–. 1 root root 87K Jul 13 11:02 ycsb–f-run-10-1507131005.log
-rw-r–r–. 1 root root 1.2K Jul 13 11:02 ycsbtest.log
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]# cat oracle_ycsb_loop.sh
export ORACLE_HOME=/home/ec2-user/ycsb-0.1.4
export YCSBHOME=/home/ec2-user/ycsb-0.1.4

cd /home/ec2-user/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

### To Load the workload data#####

for th in 50 35 25 10
do

for wl in a b c d f
do

sqlplus oracledb/oracledb@//oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521/oracledb @$YCSBHOME/inittable.sql

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”`

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@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]# sqlplus oracledb/oracledb@//oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521/oracledb @$YCSBHOME/inittable.sql

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 14 02:25:57 2015

Disconnected from Oracle Database 11g Release 11.2.0.4.0 – 64bit Production
[root@ip-10-0-0-67 ycsb-0.1.4]#

[root@ip-10-0-0-67 ycsb-0.1.4]# sh -x oracle_ycsb_loop.sh
+ export ORACLE_HOME=/home/ec2-user/ycsb-0.1.4
+ ORACLE_HOME=/home/ec2-user/ycsb-0.1.4
+ export YCSBHOME=/home/ec2-user/ycsb-0.1.4
+ YCSBHOME=/home/ec2-user/ycsb-0.1.4
+ cd /home/ec2-user/ycsb-0.1.4/logs
+ ‘[‘ -z ” ‘]’
++ hostname -s
+ host=ip-10-0-0-67
oracle_ycsb_loop.sh: command substitution: line 7: unexpected EOF while looking for matching `”
oracle_ycsb_loop.sh: command substitution: line 8: syntax error: unexpected end of file
+ host=
+ ‘[‘ -z ” ‘]’
++ date +%y%m%d%H%M
+ LOGSUFFIX=1507140226
+ for th in 50 35 25 10
+ for wl in a b c d f
+ sqlplus oracledb/oracledb@//oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521/oracledb @/home/ec2-user/ycsb-0.1.4/inittable.sql

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 14 02:26:35 2015

Disconnected from Oracle Database 11g Release 11.2.0.4.0 – 64bit Production
+ /home/ec2-user/ycsb-0.1.4/bin/ycsb load jdbc -P /home/ec2-user/ycsb-0.1.4/workloads/workloada -P /home/ec2-user/ycsb-0.1.4/jdbc-binding/conf/db.properties -p recordcount=1000000 -p operationcount=1000000 -p readallfields=true -p hotspotdatafraction=1 -p insertorder=ordered -threads 50
java -cp /home/ec2-user/ycsb-0.1.4/mysql-connector-java-5.1.36-bin.jar:/home/ec2-user/ycsb-0.1.4/jdbc-binding-0.1.4.jar:/home/ec2-user/ycsb-0.1.4/ojdbc7.jar:/home/ec2-user/ycsb-0.1.4/ojdbc6.jar:/home/ec2-user/ycsb-0.1.4/ojdbc5.jar:/home/ec2-user/ycsb-0.1.4/core/lib/core-0.1.4.jar:/home/ec2-user/ycsb-0.1.4/jdbc-binding/ojdbc7.jar:/home/ec2-user/ycsb-0.1.4/jdbc-binding/mysql-connector-java-5.1.36-bin.jar:/home/ec2-user/ycsb-0.1.4/jdbc-binding/conf:/home/ec2-user/ycsb-0.1.4/jdbc-binding/lib/jdbc-binding-0.1.4.jar:/home/ec2-user/ycsb-0.1.4/jdbc-binding/lib/ojdbc7.jar:/home/ec2-user/ycsb-0.1.4/jdbc-binding/lib/mysql-connector-java-5.1.36-bin.jar:/home/ec2-user/ycsb-0.1.4/jdbc-binding/lib/ojdbc5.jar:/home/ec2-user/ycsb-0.1.4/jdbc-binding/lib/ojdbc6.jar com.yahoo.ycsb.Client -db com.yahoo.ycsb.db.JdbcDBClient -P /home/ec2-user/ycsb-0.1.4/workloads/workloada -P /home/ec2-user/ycsb-0.1.4/jdbc-binding/conf/db.properties -p recordcount=1000000 -p operationcount=1000000 -p readallfields=true -p hotspotdatafraction=1 -p insertorder=ordered -threads 50 -load
YCSB Client 0.1
Command line: -db com.yahoo.ycsb.db.JdbcDBClient -P /home/ec2-user/ycsb-0.1.4/workloads/workloada -P /home/ec2-user/ycsb-0.1.4/jdbc-binding/conf/db.properties -p recordcount=1000000 -p operationcount=1000000 -p readallfields=true -p hotspotdatafraction=1 -p insertorder=ordered -threads 50 -load
Loading workload…
Starting test.
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
Using 1 shards
——–

^Z
[1]+ Stopped sh -x oracle_ycsb_loop.sh
[root@ip-10-0-0-67 ycsb-0.1.4]# bg
[1]+ sh -x oracle_ycsb_loop.sh &
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]# ll -lhtr
total 16M
-rw-r–r–. 1 501 games 479 Feb 18 2012 NOTICE.txt
-rw-r–r–. 1 501 games 7.9K Feb 18 2012 LICENSE.txt
drwxrwxrwx. 2 501 games 102 Feb 22 2012 workloads
-rw-r–r–. 1 501 games 2.3K Feb 23 2012 CHANGELOG
drwxrwxrwx. 2 501 games 31 Feb 24 2012 bin
-rw-r–r–. 1 501 games 952 Feb 24 2012 README
drwxr-xr-x. 3 root root 16 Jul 7 06:47 core
drwxr-xr-x. 3 root root 29 Jul 7 06:47 mapkeeper-binding
-rw-r–r–. 1 root root 1.6K Jul 8 01:33 ycsb_script.sh
-rw-r–r–. 1 root root 950K Jul 8 01:36 mysql-connector-java-5.1.36-bin.jar
-rw-r–r–. 1 root root 311 Jul 8 06:22 inittable.sql_bkp_mysql
-rw-r–r–. 1 root root 691 Jul 8 06:25 inittable.sql
-rw-r–r–. 1 root root 6.7M Jul 8 09:26 jdbc-binding-0.1.4.jar
-rw-r–r–. 1 root root 3.3M Jul 8 09:59 ojdbc7.jar
drwxr-xr-x. 4 root root 86 Jul 8 10:07 jdbc-binding
-rw-r–r–. 1 root root 2.7M Jul 13 06:43 ojdbc6.jar
-rw-r–r–. 1 root root 2.0M Jul 13 06:43 ojdbc5.jar
-rwxrwxrwx. 1 root root 3.2K Jul 13 07:13 ycsbloop.sh
-rw-r–r–. 1 root root 3.0K Jul 13 09:48 new_ycsbloop.sh
-rw-r–r–. 1 root root 146 Jul 13 10:03 ycsbtest.log
-rw-r–r–. 1 root root 1.6K Jul 13 10:04 ~
drwxr-xr-x. 5 root root 63 Jul 14 02:07 logs
-rwxrwxrwx. 1 root root 1.5K Jul 14 02:25 oracle_ycsb_loop.sh
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]#
[root@ip-10-0-0-67 ycsb-0.1.4]# cd logs/
[root@ip-10-0-0-67 logs]# ll -lhtr
total 12K
drwxr-xr-x. 2 root root 4.0K Jul 8 09:49 sublogs
drwxr-xr-x. 2 root root 4.0K Jul 13 09:30 oracle_logs
drwxr-xr-x. 2 root root 4.0K Jul 14 02:07 actual_oracle_logs
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]# ll -lhtr actual_oracle_logs/
total 24M
-rw-r–r–. 1 root root 46 Jul 13 10:10 50_thread_a_workload_logs.txt
-rw-r–r–. 1 root root 60K Jul 13 10:12 ycsb–a-run-50-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:12 50_thread_b_workload_logs.txt
-rw-r–r–. 1 root root 59K Jul 13 10:14 ycsb–b-run-50-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:14 50_thread_c_workload_logs.txt
-rw-r–r–. 1 root root 42K Jul 13 10:16 ycsb–c-run-50-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:16 50_thread_d_workload_logs.txt
-rw-r–r–. 1 root root 59K Jul 13 10:17 ycsb–d-run-50-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:17 50_thread_f_workload_logs.txt
-rw-r–r–. 1 root root 89K Jul 13 10:20 ycsb–f-run-50-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:20 35_thread_a_workload_logs.txt
-rw-r–r–. 1 root root 58K Jul 13 10:23 ycsb–a-run-35-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:23 35_thread_b_workload_logs.txt
-rw-r–r–. 1 root root 57K Jul 13 10:24 ycsb–b-run-35-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:24 35_thread_c_workload_logs.txt
-rw-r–r–. 1 root root 40K Jul 13 10:26 ycsb–c-run-35-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:26 35_thread_d_workload_logs.txt
-rw-r–r–. 1 root root 7.7M Jul 13 10:28 ycsb–d-run-35-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:28 35_thread_f_workload_logs.txt
-rw-r–r–. 1 root root 87K Jul 13 10:31 ycsb–f-run-35-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:31 25_thread_a_workload_logs.txt
-rw-r–r–. 1 root root 57K Jul 13 10:34 ycsb–a-run-25-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:34 25_thread_b_workload_logs.txt
-rw-r–r–. 1 root root 56K Jul 13 10:36 ycsb–b-run-25-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:36 25_thread_c_workload_logs.txt
-rw-r–r–. 1 root root 39K Jul 13 10:37 ycsb–c-run-25-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:37 25_thread_d_workload_logs.txt
-rw-r–r–. 1 root root 7.7M Jul 13 10:39 ycsb–d-run-25-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:39 25_thread_f_workload_logs.txt
-rw-r–r–. 1 root root 86K Jul 13 10:43 ycsb–f-run-25-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:43 10_thread_a_workload_logs.txt
-rw-r–r–. 1 root root 57K Jul 13 10:48 ycsb–a-run-10-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:48 10_thread_b_workload_logs.txt
-rw-r–r–. 1 root root 54K Jul 13 10:50 ycsb–b-run-10-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:50 10_thread_c_workload_logs.txt
-rw-r–r–. 1 root root 37K Jul 13 10:52 ycsb–c-run-10-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:52 10_thread_d_workload_logs.txt
-rw-r–r–. 1 root root 7.6M Jul 13 10:56 ycsb–d-run-10-1507131005.log
-rw-r–r–. 1 root root 46 Jul 13 10:56 10_thread_f_workload_logs.txt
-rw-r–r–. 1 root root 87K Jul 13 11:02 ycsb–f-run-10-1507131005.log
-rw-r–r–. 1 root root 1.2K Jul 13 11:02 ycsbtest.log
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]# cat actual_oracle_logs/ycsbtest.log
ycsbrun,,a,15/07/13 10:10:28,15/07/13 10:12:47,1507131005,50
ycsbrun,,b,15/07/13 10:12:47,15/07/13 10:14:22,1507131005,50
ycsbrun,,c,15/07/13 10:14:22,15/07/13 10:16:01,1507131005,50
ycsbrun,,d,15/07/13 10:16:01,15/07/13 10:17:41,1507131005,50
ycsbrun,,f,15/07/13 10:17:41,15/07/13 10:20:42,1507131005,50
ycsbrun,,a,15/07/13 10:20:42,15/07/13 10:23:19,1507131005,35
ycsbrun,,b,15/07/13 10:23:19,15/07/13 10:24:53,1507131005,35
ycsbrun,,c,15/07/13 10:24:53,15/07/13 10:26:29,1507131005,35
ycsbrun,,d,15/07/13 10:26:29,15/07/13 10:28:21,1507131005,35
ycsbrun,,f,15/07/13 10:28:21,15/07/13 10:31:25,1507131005,35
ycsbrun,,a,15/07/13 10:31:25,15/07/13 10:34:32,1507131005,25
ycsbrun,,b,15/07/13 10:34:32,15/07/13 10:36:08,1507131005,25
ycsbrun,,c,15/07/13 10:36:08,15/07/13 10:37:44,1507131005,25
ycsbrun,,d,15/07/13 10:37:44,15/07/13 10:39:35,1507131005,25
ycsbrun,,f,15/07/13 10:39:35,15/07/13 10:43:02,1507131005,25
ycsbrun,,a,15/07/13 10:43:02,15/07/13 10:48:21,1507131005,10
ycsbrun,,b,15/07/13 10:48:21,15/07/13 10:50:13,1507131005,10
ycsbrun,,c,15/07/13 10:50:13,15/07/13 10:52:19,1507131005,10
ycsbrun,,d,15/07/13 10:52:19,15/07/13 10:56:51,1507131005,10
ycsbrun,,f,15/07/13 10:56:51,15/07/13 11:02:53,1507131005,10
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]# head actual_oracle_logs/ycsb–a-run-10-1507131005.log
YCSB Client 0.1
Command line: -db com.yahoo.ycsb.db.JdbcDBClient -s -P /home/ec2-user/ycsb-0.1.4/workloads/workloada -P /home/ec2-user/ycsb-0.1.4/jdbc-binding/conf/db.properties -p recordcount=1000000 -p operationcount=1000000 -p readallfields=true -p hotspotdatafraction=1 -p insertorder=ordered -threads 10 -t
Loading workload…
Starting test.
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
2015-07-13 10:43:02:966 0 sec: 0 operations;
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
Adding shard node URL: jdbc:oracle:thin:@oracledb.cwns0ftnokao.us-east-1.rds.amazonaws.com:1521:oracledb
[root@ip-10-0-0-67 logs]#

Tags: YCSB Benchmarks on Amazon RDS Oracle

YCSB Benchmarks on Amazon RDS Oracle

Leave a Reply

Categories

Categories