[MySQL]: YCSB with MySQL
[user@myhostname ~]$
[user@myhostname ~]$ sudo su
[sudo] password for user:
[Lab root @ myhostname /mysql]# tar -zxvf MySQL-5.6.19-1.el6.x86_64.rpm-bundle.tar.gz
MySQL-embedded-5.6.19-1.el6.x86_64.rpm
MySQL-devel-5.6.19-1.el6.x86_64.rpm
MySQL-client-5.6.19-1.el6.x86_64.rpm
MySQL-shared-compat-5.6.19-1.el6.x86_64.rpm
MySQL-server-5.6.19-1.el6.x86_64.rpm
MySQL-shared-5.6.19-1.el6.x86_64.rpm
MySQL-test-5.6.19-1.el6.x86_64.rpm
[Lab root @ myhostname /mysql]
[Lab root @ myhostname /mysql]# ll -lhtr
total 415M
-rw-r–r– 1 user user 207M Jul 17 2014 MySQL-5.6.19-1.el6.x86_64.rpm-bundle.tar.gz
-rw-r–r– 1 7155 wheel 18M May 8 2014 MySQL-client-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 3.3M May 8 2014 MySQL-devel-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 82M May 8 2014 MySQL-embedded-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 53M May 8 2014 MySQL-server-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 1.9M May 8 2014 MySQL-shared-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 3.8M May 8 2014 MySQL-shared-compat-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 48M May 8 2014 MySQL-test-5.6.19-1.el6.x86_64.rpm
[Lab root @ myhostname /mysql]#
[Lab root @ myhostname /mysql]#
[Lab root @ myhostname /mysql]#
[Lab root @ myhostname /mysql]#
[Lab root @ myhostname /mysql]# rpm -ivh MySQL-*.rpm
Preparing… ########################################### [100%]
1:MySQL-devel ########################################### [ 14%]
2:MySQL-client ########################################### [ 29%]
3:MySQL-test ########################################### [ 43%]
4:MySQL-embedded ########################################### [ 57%]
5:MySQL-shared-compat ########################################### [ 71%]
6:MySQL-shared ########################################### [ 86%]
7:MySQL-server ########################################### [100%]
2015-05-18 07:22:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).
2015-05-18 07:22:59 30897 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-18 07:22:59 30897 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-18 07:22:59 30897 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-05-18 07:22:59 30897 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-18 07:22:59 30897 [Note] InnoDB: Using Linux native AIO
2015-05-18 07:22:59 30897 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-18 07:22:59 30897 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-18 07:22:59 30897 [Note] InnoDB: Completed initialization of buffer pool
2015-05-18 07:22:59 30897 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2015-05-18 07:22:59 30897 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2015-05-18 07:22:59 30897 [Note] InnoDB: Database physically writes the file full: wait…
2015-05-18 07:23:00 30897 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2015-05-18 07:23:00 30897 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2015-05-18 07:23:01 30897 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2015-05-18 07:23:01 30897 [Warning] InnoDB: New log files created, LSN=45781
2015-05-18 07:23:01 30897 [Note] InnoDB: Doublewrite buffer not found: creating new
2015-05-18 07:23:01 30897 [Note] InnoDB: Doublewrite buffer created
2015-05-18 07:23:01 30897 [Note] InnoDB: 128 rollback segment(s) are active.
2015-05-18 07:23:01 30897 [Warning] InnoDB: Creating foreign key constraint system tables.
2015-05-18 07:23:01 30897 [Note] InnoDB: Foreign key constraint system tables created
2015-05-18 07:23:01 30897 [Note] InnoDB: Creating tablespace and datafile system tables.
2015-05-18 07:23:01 30897 [Note] InnoDB: Tablespace and datafile system tables created.
2015-05-18 07:23:01 30897 [Note] InnoDB: Waiting for purge to start
2015-05-18 07:23:01 30897 [Note] InnoDB: 5.6.19 started; log sequence number 0
A random root password has been set. You will find it in ‘/root/.mysql_secret’.
2015-05-18 07:23:02 30897 [Note] Binlog end
2015-05-18 07:23:02 30897 [Note] InnoDB: FTS optimize thread exiting.
2015-05-18 07:23:02 30897 [Note] InnoDB: Starting shutdown…
2015-05-18 07:23:03 30897 [Note] InnoDB: Shutdown completed; log sequence number 1625977
2015-05-18 07:23:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).
2015-05-18 07:23:03 30921 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-18 07:23:03 30921 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-18 07:23:03 30921 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-05-18 07:23:03 30921 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-18 07:23:03 30921 [Note] InnoDB: Using Linux native AIO
2015-05-18 07:23:03 30921 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-18 07:23:03 30921 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-18 07:23:03 30921 [Note] InnoDB: Completed initialization of buffer pool
2015-05-18 07:23:03 30921 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-18 07:23:03 30921 [Note] InnoDB: 128 rollback segment(s) are active.
2015-05-18 07:23:03 30921 [Note] InnoDB: Waiting for purge to start
2015-05-18 07:23:03 30921 [Note] InnoDB: 5.6.19 started; log sequence number 1625977
2015-05-18 07:23:03 30921 [Note] Binlog end
2015-05-18 07:23:03 30921 [Note] InnoDB: FTS optimize thread exiting.
2015-05-18 07:23:03 30921 [Note] InnoDB: Starting shutdown…
2015-05-18 07:23:05 30921 [Note] InnoDB: Shutdown completed; log sequence number 1625987
A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !
You will find that password in ‘/root/.mysql_secret’.
You must change that password on your first connect,
no other statement but ‘SET PASSWORD’ will be accepted.
See the manual for the semantics of the ‘password expired’ flag.
Also, the account for the anonymous user has been removed.
In addition, you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test database.
This is strongly recommended for production servers.
See the manual for more instructions.
Please report any problems at http://bugs.mysql.com/
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
New default config file was created as /usr/my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings
[Lab root @ myhostname /mysql]
[ root @ myhostname : /tmp ] service mysql status
ERROR! MySQL is not running
[ root @ myhostname : /tmp ]
[ root @ myhostname : /tmp ] service mysql start
Starting MySQL. SUCCESS!
[ root @ myhostname : /tmp ]
[ root @ myhostname : /tmp ] cat /root/.mysql_secret
# The random password set for the root user at Mon May 18 07:23:02 2015 (local time): SgzC9rfZHEb5UJZE
[ root @ myhostname : /tmp ]
[ root @ myhostname : /tmp ] /usr/bin/mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we’ll need the current
password for the root user. If you’ve just installed MySQL, and
you haven’t set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on…
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
You already have a root password set, so you can safely answer ‘n’.
Change the root password? [Y/n] Y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
… Success!
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
… Success!
Normally, root should only be allowed to connect from ‘localhost’. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] n
… skipping.
By default, MySQL comes with a database named ‘test’ that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] n
… skipping.
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] Y
… Success!
All done! If you’ve completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
Cleaning up…
[ root @ myhostname : /tmp ]
[ root @ myhostname : /tmp ]
[ root @ myhostname : /tmp ] mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.6.19 MySQL Community Server (GPL)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql>
mysql>
mysql>
mysql> show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| mysql |
| performance_schema |
| test |
+——————–+
4 rows in set (0.00 sec)
mysql>
mysql> create database testdata;
Query OK, 1 row affected (0.00 sec)
mysql>
mysql> show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| test_db |
| mysql |
| performance_schema |
| test |
+——————–+
5 rows in set (0.00 sec)
mysql>
[ root @ myhostname : /mysql ] mv /tmp/YCSB-master.zip /tmp/jdk-8u5-linux-x64.gz /tmp/ycsb-0.1.4.tar.gz .
[ root @ myhostname : /mysql ] ll -lhtr
total 662M
-rw-r–r– 1 7155 wheel 18M May 8 2014 MySQL-client-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 3.3M May 8 2014 MySQL-devel-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 82M May 8 2014 MySQL-embedded-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 53M May 8 2014 MySQL-server-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 1.9M May 8 2014 MySQL-shared-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 3.8M May 8 2014 MySQL-shared-compat-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 48M May 8 2014 MySQL-test-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 user user 373K Jun 25 2014 YCSB-master.zip
-rw-r–r– 1 user user 152M Jun 26 2014 jdk-8u5-linux-x64.gz
-rw-r–r– 1 user user 95M Jun 27 2014 ycsb-0.1.4.tar.gz
-rw-r–r– 1 user user 207M Jul 17 2014 MySQL-5.6.19-1.el6.x86_64.rpm-bundle.tar.gz
[ root @ myhostname : /mysql ]
[ root @ myhostname : /mysql ]
[ root @ myhostname : /mysql ] ll -lhtr /tmp/
total 247M
-rw-r–r– 1 user user 373K Jun 25 2014 YCSB-master.zip
-rw-r–r– 1 user user 152M Jun 26 2014 jdk-8u5-linux-x64.gz
-rw-r–r– 1 user user 95M Jun 27 2014 ycsb-0.1.4.tar.gz
drwx—— 2 root root 4.0K May 5 17:27 ssh-server-g3
drwx—— 2 user user 4.0K May 18 06:47 ssh-user
-rw-r–r– 1 user user 5.7K May 18 06:47 mysql-community-release-el6-5.noarch.rpm
[ root @ myhostname : /mysql ]
[ root @ myhostname : /mysql ]
[ root @ myhostname : /mysql ] mv /tmp/YCSB-master.zip /tmp/jdk-8u5-linux-x64.gz /tmp/ycsb-0.1.4.tar.gz .
[ root @ myhostname : /mysql ] ll -lhtr
total 662M
-rw-r–r– 1 7155 wheel 18M May 8 2014 MySQL-client-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 3.3M May 8 2014 MySQL-devel-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 82M May 8 2014 MySQL-embedded-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 53M May 8 2014 MySQL-server-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 1.9M May 8 2014 MySQL-shared-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 3.8M May 8 2014 MySQL-shared-compat-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 48M May 8 2014 MySQL-test-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 user user 373K Jun 25 2014 YCSB-master.zip
-rw-r–r– 1 user user 152M Jun 26 2014 jdk-8u5-linux-x64.gz
-rw-r–r– 1 user user 95M Jun 27 2014 ycsb-0.1.4.tar.gz
-rw-r–r– 1 user user 207M Jul 17 2014 MySQL-5.6.19-1.el6.x86_64.rpm-bundle.tar.gz
[ root @ myhostname : /mysql ]
[ root @ myhostname : /mysql ]
[ root @ myhostname : /mysql ]
[ root @ myhostname : /mysql ]
[ root @ myhostname : /mysql ]
[ root @ myhostname : /mysql ] tar -zxvf ycsb-0.1.4.tar.gz
ycsb-0.1.4/CHANGELOG
ycsb-0.1.4/LICENSE.txt
ycsb-0.1.4/NOTICE.txt
ycsb-0.1.4/README
ycsb-0.1.4/bin/
ycsb-0.1.4/bin/ycsb
ycsb-0.1.4/bin/ycsb.sh
ycsb-0.1.4/workloads/
ycsb-0.1.4/workloads/workloada
ycsb-0.1.4/workloads/workloadb
———
[ root @ myhostname : /mysql ]
[ root @ myhostname : /mysql ]
[ root @ myhostname : /mysql ] ll -lhtr
total 662M
-rw-r–r– 1 7155 wheel 18M May 8 2014 MySQL-client-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 3.3M May 8 2014 MySQL-devel-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 82M May 8 2014 MySQL-embedded-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 53M May 8 2014 MySQL-server-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 1.9M May 8 2014 MySQL-shared-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 3.8M May 8 2014 MySQL-shared-compat-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 7155 wheel 48M May 8 2014 MySQL-test-5.6.19-1.el6.x86_64.rpm
-rw-r–r– 1 user user 373K Jun 25 2014 YCSB-master.zip
-rw-r–r– 1 user user 152M Jun 26 2014 jdk-8u5-linux-x64.gz
-rw-r–r– 1 user user 95M Jun 27 2014 ycsb-0.1.4.tar.gz
-rw-r–r– 1 user user 207M Jul 17 2014 MySQL-5.6.19-1.el6.x86_64.rpm-bundle.tar.gz
drwxr-xr-x 15 root root 4.0K May 18 08:30 ycsb-0.1.4
[ root @ myhostname : /mysql ]
[ root @ myhostname : /mysql ]
[ root @ myhostname : /mysql ] tar -zxvf jdk-8u5-linux-x64.gz
jdk1.8.0_05/
jdk1.8.0_05/javafx-src.zip
jdk1.8.0_05/bin/
[ root @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/ycsb-0.1.4 ] ll -lhtr
total 1.4M
-rw-r–r– 1 ml48275 20 479 Feb 18 2012 NOTICE.txt
-rw-r–r– 1 ml48275 20 7.9K Feb 18 2012 LICENSE.txt
drwxrwxrwx 2 ml48275 20 4.0K Feb 22 2012 workloads
-rw-r–r– 1 ml48275 20 2.3K Feb 23 2012 CHANGELOG
drwxrwxrwx 2 ml48275 20 4.0K Feb 24 2012 bin
-rw-r–r– 1 ml48275 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 8 uucp 143 4.0K Apr 10 14:53 jdk1.7.0_79
drwxr-xr-x 3 root root 4.0K May 18 08:30 core
drwxr-xr-x 4 root root 4.0K May 18 08:30 jdbc-binding
-rw-r–r– 1 root root 946K May 18 09:11 mysql-connector-java-5.1.35-bin.jar
-rw-r–r– 1 root root 373K May 18 09:51 YCSB-master.zip
-rwxrwxrwx 1 root root 3.4K May 18 11:46 ycsbloop.sh
drwxr-xr-x 2 root root 4.0K May 18 12:18 oldlogs
-rw-r–r– 1 root root 1.5K May 18 12:34 ycsb_script.sh
-rw-r–r– 1 root root 350 May 18 12:38 inittable.sql
-rw-r–r– 1 root root 1.5K May 19 03:40 ycsb_script_e.sh
drwxr-xr-x 4 root root 4.0K May 19 05:53 logs
[ root @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/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 @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/ycsb-0.1.4 ] cat ~/.bashrc
# .bashrc
# User specific aliases and functions
alias rm=’rm -i’
alias cp=’cp -i’
alias mv=’mv -i’
# Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi
export PS1=”[ \u @ \h : \w ] “
export PS1=”[ \u @ \h : \w ] “
export YCSBHOME=/mysql/ycsb-0.1.4
export MYSQL_HOME=/var/lib/mysql/
export EDITOR=vi
export CLASSPATH=/var/lib/mysql/mysql-connector-java-5.1.35-bin.jar
export JAVA_HOME=/mysql/ycsb-0.1.4/jdk1.7.0_79
export PATH=$PATH:$JAVA_HOME/bin
[ root @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/ycsb-0.1.4 ] cat jdbc-binding/conf/db.properties
# Properties file that contains database connection information.
# Properties file that contains database connection information.
jdbc.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://myhostname.nam.nsroot.net:3306/ycsb
db.user=root
db.passwd=MyPassCode
[ root @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/ycsb-0.1.4 ] cat ycsb_script.sh
export YCSBHOME=/mysql/ycsb-0.1.4
mysql -h `hostname` -u root -p’MyPassCode’ -D ycsb < $YCSBHOME/inittable.sql
cd /mysql/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 -h `hostname` -u root -p’MyPassCode’ -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 @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/ycsb-0.1.4 ] ll -lhtr logs/
total 287M
-rw-r–r– 1 root root 113K May 18 12:45 ycsb-12d6_dl585g7_VM02-a-run-50-1505181234.log
-rw-r–r– 1 root root 110K May 18 12:46 ycsb-12d6_dl585g7_VM02-b-run-50-1505181234.log
-rw-r–r– 1 root root 92K May 18 12:48 ycsb-12d6_dl585g7_VM02-c-run-50-1505181234.log
-rw-r–r– 1 root root 110K May 18 12:49 ycsb-12d6_dl585g7_VM02-d-run-50-1505181234.log
-rw-r–r– 1 root root 141K May 18 12:54 ycsb-12d6_dl585g7_VM02-f-run-50-1505181234.log
-rw-r–r– 1 root root 111K May 18 12:59 ycsb-12d6_dl585g7_VM02-a-run-35-1505181234.log
-rw-r–r– 1 root root 109K May 18 13:00 ycsb-12d6_dl585g7_VM02-b-run-35-1505181234.log
-rw-r–r– 1 root root 91K May 18 13:02 ycsb-12d6_dl585g7_VM02-c-run-35-1505181234.log
-rw-r–r– 1 root root 8.2M May 18 13:03 ycsb-12d6_dl585g7_VM02-d-run-35-1505181234.log
-rw-r–r– 1 root root 140K May 18 13:08 ycsb-12d6_dl585g7_VM02-f-run-35-1505181234.log
-rw-r–r– 1 root root 110K May 18 13:14 ycsb-12d6_dl585g7_VM02-a-run-25-1505181234.log
-rw-r–r– 1 root root 108K May 18 13:15 ycsb-12d6_dl585g7_VM02-b-run-25-1505181234.log
-rw-r–r– 1 root root 90K May 18 13:17 ycsb-12d6_dl585g7_VM02-c-run-25-1505181234.log
-rw-r–r– 1 root root 8.3M May 18 13:18 ycsb-12d6_dl585g7_VM02-d-run-25-1505181234.log
-rw-r–r– 1 root root 140K May 18 13:24 ycsb-12d6_dl585g7_VM02-f-run-25-1505181234.log
-rw-r–r– 1 root root 112K May 18 13:33 ycsb-12d6_dl585g7_VM02-a-run-10-1505181234.log
-rw-r–r– 1 root root 106K May 18 13:35 ycsb-12d6_dl585g7_VM02-b-run-10-1505181234.log
-rw-r–r– 1 root root 88K May 18 13:37 ycsb-12d6_dl585g7_VM02-c-run-10-1505181234.log
-rw-r–r– 1 root root 8.2M May 18 13:38 ycsb-12d6_dl585g7_VM02-d-run-10-1505181234.log
-rw-r–r– 1 root root 142K May 18 13:47 ycsb-12d6_dl585g7_VM02-f-run-10-1505181234.log
drwxr-xr-x 2 root root 4.0K May 19 03:40 logs_bkp
-rw-r–r– 1 root root 97M May 19 03:49 ycsb-12d6_dl585g7_VM02-e-run-50-1505190341.log
-rw-r–r– 1 root root 95M May 19 03:51 ycsb-12d6_dl585g7_VM02-e-run-35-1505190341.log
-rw-r–r– 1 root root 58M May 19 03:58 ycsb-12d6_dl585g7_VM02-e-run-25-1505190341.log
-rw-r–r– 1 root root 11M May 19 04:04 ycsb-12d6_dl585g7_VM02-e-run-10-1505190341.log
-rw-r–r– 1 root root 1.9K May 19 04:04 ycsbtest.log
drwxr-xr-x 2 root root 4.0K May 19 05:53 txts
[ root @ myhostname : /mysql/ycsb-0.1.4 ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ] grep “operations” *.log | grep “current ops/sec” | grep “a-run-35” | tail
ycsb-12d6_dl585g7_VM02-a-run-35-1505181234.log: 200 sec: 694829 operations; 3422.36 current ops/sec; [UPDATE AverageLatency(us)=18529.18] [READ AverageLatency(us)=1663.73]
ycsb-12d6_dl585g7_VM02-a-run-35-1505181234.log: 210 sec: 730052 operations; 3521.95 current ops/sec; [UPDATE AverageLatency(us)=18170.86] [READ AverageLatency(us)=1738.31]
ycsb-12d6_dl585g7_VM02-a-run-35-1505181234.log: 220 sec: 765735 operations; 3568.3 current ops/sec; [UPDATE AverageLatency(us)=18094.17] [READ AverageLatency(us)=1588.98]
ycsb-12d6_dl585g7_VM02-a-run-35-1505181234.log: 230 sec: 801272 operations; 3553.34 current ops/sec; [UPDATE AverageLatency(us)=17863.38] [READ AverageLatency(us)=1908.95]
ycsb-12d6_dl585g7_VM02-a-run-35-1505181234.log: 240 sec: 837081 operations; 3580.54 current ops/sec; [UPDATE AverageLatency(us)=17679.93] [READ AverageLatency(us)=1810.96]
ycsb-12d6_dl585g7_VM02-a-run-35-1505181234.log: 250 sec: 872092 operations; 3500.75 current ops/sec; [UPDATE AverageLatency(us)=17988.85] [READ AverageLatency(us)=1995.85]
ycsb-12d6_dl585g7_VM02-a-run-35-1505181234.log: 260 sec: 907733 operations; 3564.1 current ops/sec; [UPDATE AverageLatency(us)=17768.31] [READ AverageLatency(us)=1904.13]
ycsb-12d6_dl585g7_VM02-a-run-35-1505181234.log: 270 sec: 943005 operations; 3526.85 current ops/sec; [UPDATE AverageLatency(us)=17847.01] [READ AverageLatency(us)=1965.88]
ycsb-12d6_dl585g7_VM02-a-run-35-1505181234.log: 280 sec: 978806 operations; 3579.74 current ops/sec; [UPDATE AverageLatency(us)=17711.96] [READ AverageLatency(us)=1947.42]
ycsb-12d6_dl585g7_VM02-a-run-35-1505181234.log: 287 sec: 999985 operations; 2992.65 current ops/sec; [UPDATE AverageLatency(us)=16428.55] [READ AverageLatency(us)=1901.98]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ] grep “operations” *.log | grep “current ops/sec” | grep “b-run-35” | tail
ycsb-12d6_dl585g7_VM02-b-run-35-1505181234.log: 20 sec: 163011 operations; 10115.68 current ops/sec; [UPDATE AverageLatency(us)=23043.84] [READ AverageLatency(us)=2402.35]
ycsb-12d6_dl585g7_VM02-b-run-35-1505181234.log: 30 sec: 267036 operations; 10401.46 current ops/sec; [UPDATE AverageLatency(us)=23001.98] [READ AverageLatency(us)=2297.99]
ycsb-12d6_dl585g7_VM02-b-run-35-1505181234.log: 40 sec: 372506 operations; 10545.95 current ops/sec; [UPDATE AverageLatency(us)=22430.08] [READ AverageLatency(us)=2307.05]
ycsb-12d6_dl585g7_VM02-b-run-35-1505181234.log: 50 sec: 477232 operations; 10471.55 current ops/sec; [UPDATE AverageLatency(us)=22447.42] [READ AverageLatency(us)=2350.66]
ycsb-12d6_dl585g7_VM02-b-run-35-1505181234.log: 60 sec: 583232 operations; 10600 current ops/sec; [UPDATE AverageLatency(us)=22086.43] [READ AverageLatency(us)=2318.66]
ycsb-12d6_dl585g7_VM02-b-run-35-1505181234.log: 70 sec: 691840 operations; 10859.71 current ops/sec; [UPDATE AverageLatency(us)=22704.77] [READ AverageLatency(us)=2195.81]
ycsb-12d6_dl585g7_VM02-b-run-35-1505181234.log: 80 sec: 799924 operations; 10807.32 current ops/sec; [UPDATE AverageLatency(us)=23322.33] [READ AverageLatency(us)=2185.14]
ycsb-12d6_dl585g7_VM02-b-run-35-1505181234.log: 90 sec: 908562 operations; 10863.8 current ops/sec; [UPDATE AverageLatency(us)=22152.79] [READ AverageLatency(us)=2224.11]
ycsb-12d6_dl585g7_VM02-b-run-35-1505181234.log: 100 sec: 998434 operations; 8986.3 current ops/sec; [UPDATE AverageLatency(us)=20073.01] [READ AverageLatency(us)=2430.22]
ycsb-12d6_dl585g7_VM02-b-run-35-1505181234.log: 100 sec: 999985 operations; 5187.29 current ops/sec; [UPDATE AverageLatency(us)=8716.97] [READ AverageLatency(us)=388.61]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ] grep “operations” *.log | grep “current ops/sec” | grep “c-run-35” | tail
ycsb-12d6_dl585g7_VM02-c-run-35-1505181234.log: 10 sec: 61645 operations; 6134.44 current ops/sec; [READ AverageLatency(us)=5178.33]
ycsb-12d6_dl585g7_VM02-c-run-35-1505181234.log: 20 sec: 179356 operations; 11768.75 current ops/sec; [READ AverageLatency(us)=2959.48]
ycsb-12d6_dl585g7_VM02-c-run-35-1505181234.log: 30 sec: 319132 operations; 13977.6 current ops/sec; [READ AverageLatency(us)=2498.82]
ycsb-12d6_dl585g7_VM02-c-run-35-1505181234.log: 40 sec: 459048 operations; 13990.2 current ops/sec; [READ AverageLatency(us)=2497.07]
ycsb-12d6_dl585g7_VM02-c-run-35-1505181234.log: 50 sec: 598102 operations; 13904.01 current ops/sec; [READ AverageLatency(us)=2511.92]
ycsb-12d6_dl585g7_VM02-c-run-35-1505181234.log: 60 sec: 737137 operations; 13903.5 current ops/sec; [READ AverageLatency(us)=2513.01]
ycsb-12d6_dl585g7_VM02-c-run-35-1505181234.log: 70 sec: 875921 operations; 13877.01 current ops/sec; [READ AverageLatency(us)=2516.84]
ycsb-12d6_dl585g7_VM02-c-run-35-1505181234.log: 79 sec: 999985 operations; 13742.14 current ops/sec; [READ AverageLatency(us)=2429.87]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ] grep “operations” *.log | grep “current ops/sec” | grep “d-run-35” | tail
ycsb-12d6_dl585g7_VM02-d-run-35-1505181234.log: 10 sec: 57378 operations; 5718.93 current ops/sec; [INSERT AverageLatency(us)=14470.98] [READ AverageLatency(us)=5123.04]
ycsb-12d6_dl585g7_VM02-d-run-35-1505181234.log: 20 sec: 176802 operations; 11940.01 current ops/sec; [INSERT AverageLatency(us)=4815.61] [READ AverageLatency(us)=2805.07]
ycsb-12d6_dl585g7_VM02-d-run-35-1505181234.log: 30 sec: 323781 operations; 14697.9 current ops/sec; [INSERT AverageLatency(us)=3634.17] [READ AverageLatency(us)=2309.26]
ycsb-12d6_dl585g7_VM02-d-run-35-1505181234.log: 40 sec: 487334 operations; 16353.66 current ops/sec; [INSERT AverageLatency(us)=3147.43] [READ AverageLatency(us)=2082.65]
ycsb-12d6_dl585g7_VM02-d-run-35-1505181234.log: 50 sec: 653086 operations; 16575.2 current ops/sec; [INSERT AverageLatency(us)=3096.93] [READ AverageLatency(us)=2055.08]
ycsb-12d6_dl585g7_VM02-d-run-35-1505181234.log: 60 sec: 818153 operations; 16505.05 current ops/sec; [INSERT AverageLatency(us)=3061.57] [READ AverageLatency(us)=2065.05]
ycsb-12d6_dl585g7_VM02-d-run-35-1505181234.log: 70 sec: 983269 operations; 16511.6 current ops/sec; [INSERT AverageLatency(us)=3309.07] [READ AverageLatency(us)=2035.83]
ycsb-12d6_dl585g7_VM02-d-run-35-1505181234.log: 71 sec: 999985 operations; 16308.29 current ops/sec; [INSERT AverageLatency(us)=2238.69] [READ AverageLatency(us)=1539.71]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ] grep “operations” *.log | grep “current ops/sec” | grep “e-run-35” | tail
^C
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ] grep “operations” *.log | grep “current ops/sec” | grep “f-run-35” | tail
ycsb-12d6_dl585g7_VM02-f-run-35-1505181234.log: 230 sec: 737348 operations; 3230.2 current ops/sec; [UPDATE AverageLatency(us)=17928.39] [READ-MODIFY-WRITE AverageLatency(us)=19.84] [READ AverageLatency(us)=1910.66]
ycsb-12d6_dl585g7_VM02-f-run-35-1505181234.log: 240 sec: 768872 operations; 3152.08 current ops/sec; [UPDATE AverageLatency(us)=18077.01] [READ-MODIFY-WRITE AverageLatency(us)=20.06] [READ AverageLatency(us)=1981.62]
ycsb-12d6_dl585g7_VM02-f-run-35-1505181234.log: 250 sec: 800902 operations; 3202.68 current ops/sec; [UPDATE AverageLatency(us)=18182.24] [READ-MODIFY-WRITE AverageLatency(us)=19.99] [READ AverageLatency(us)=1801.71]
ycsb-12d6_dl585g7_VM02-f-run-35-1505181234.log: 260 sec: 833095 operations; 3218.98 current ops/sec; [UPDATE AverageLatency(us)=18051.25] [READ-MODIFY-WRITE AverageLatency(us)=19.9] [READ AverageLatency(us)=1907.92]
ycsb-12d6_dl585g7_VM02-f-run-35-1505181234.log: 270 sec: 865761 operations; 3266.27 current ops/sec; [UPDATE AverageLatency(us)=17581.21] [READ-MODIFY-WRITE AverageLatency(us)=19.57] [READ AverageLatency(us)=1909.43]
ycsb-12d6_dl585g7_VM02-f-run-35-1505181234.log: 280 sec: 897489 operations; 3172.8 current ops/sec; [UPDATE AverageLatency(us)=18006.1] [READ-MODIFY-WRITE AverageLatency(us)=19.94] [READ AverageLatency(us)=1967.88]
ycsb-12d6_dl585g7_VM02-f-run-35-1505181234.log: 290 sec: 929793 operations; 3230.08 current ops/sec; [UPDATE AverageLatency(us)=17649.36] [READ-MODIFY-WRITE AverageLatency(us)=19.74] [READ AverageLatency(us)=2098.22]
ycsb-12d6_dl585g7_VM02-f-run-35-1505181234.log: 300 sec: 962712 operations; 3291.57 current ops/sec; [UPDATE AverageLatency(us)=17310.02] [READ-MODIFY-WRITE AverageLatency(us)=19.33] [READ AverageLatency(us)=2051.67]
ycsb-12d6_dl585g7_VM02-f-run-35-1505181234.log: 310 sec: 994366 operations; 3165.4 current ops/sec; [UPDATE AverageLatency(us)=17238.35] [READ-MODIFY-WRITE AverageLatency(us)=19.43] [READ AverageLatency(us)=2197.26]
ycsb-12d6_dl585g7_VM02-f-run-35-1505181234.log: 312 sec: 999985 operations; 1916.44 current ops/sec; [UPDATE AverageLatency(us)=13496.66] [READ-MODIFY-WRITE AverageLatency(us)=14.39] [READ AverageLatency(us)=857.83]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ] cat ycsbtest.log
ycsbrun,12d6_dl585g7_VM02,a,15/05/18 12:39:48,15/05/18 12:45:01,1505181234,50
ycsbrun,12d6_dl585g7_VM02,b,15/05/18 12:45:01,15/05/18 12:46:43,1505181234,50
ycsbrun,12d6_dl585g7_VM02,c,15/05/18 12:46:43,15/05/18 12:48:02,1505181234,50
ycsbrun,12d6_dl585g7_VM02,d,15/05/18 12:48:02,15/05/18 12:49:20,1505181234,50
ycsbrun,12d6_dl585g7_VM02,f,15/05/18 12:49:20,15/05/18 12:54:24,1505181234,50
ycsbrun,12d6_dl585g7_VM02,a,15/05/18 12:54:24,15/05/18 12:59:12,1505181234,35
ycsbrun,12d6_dl585g7_VM02,b,15/05/18 12:59:12,15/05/18 13:00:53,1505181234,35
ycsbrun,12d6_dl585g7_VM02,c,15/05/18 13:00:53,15/05/18 13:02:13,1505181234,35
ycsbrun,12d6_dl585g7_VM02,d,15/05/18 13:02:13,15/05/18 13:03:25,1505181234,35
ycsbrun,12d6_dl585g7_VM02,f,15/05/18 13:03:25,15/05/18 13:08:39,1505181234,35
ycsbrun,12d6_dl585g7_VM02,a,15/05/18 13:08:39,15/05/18 13:14:09,1505181234,25
ycsbrun,12d6_dl585g7_VM02,b,15/05/18 13:14:09,15/05/18 13:15:52,1505181234,25
ycsbrun,12d6_dl585g7_VM02,c,15/05/18 13:15:52,15/05/18 13:17:11,1505181234,25
ycsbrun,12d6_dl585g7_VM02,d,15/05/18 13:17:11,15/05/18 13:18:22,1505181234,25
ycsbrun,12d6_dl585g7_VM02,f,15/05/18 13:18:22,15/05/18 13:24:18,1505181234,25
ycsbrun,12d6_dl585g7_VM02,a,15/05/18 13:24:18,15/05/18 13:33:32,1505181234,10
ycsbrun,12d6_dl585g7_VM02,b,15/05/18 13:33:32,15/05/18 13:35:46,1505181234,10
ycsbrun,12d6_dl585g7_VM02,c,15/05/18 13:35:46,15/05/18 13:37:05,1505181234,10
ycsbrun,12d6_dl585g7_VM02,d,15/05/18 13:37:05,15/05/18 13:38:13,1505181234,10
ycsbrun,12d6_dl585g7_VM02,f,15/05/18 13:38:13,15/05/18 13:47:50,1505181234,10
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ] grep “Throughput(ops/sec)” *.log
ycsb-12d6_dl585g7_VM02-a-run-10-1505181234.log:[OVERALL], Throughput(ops/sec), 1806.364907387671
ycsb-12d6_dl585g7_VM02-a-run-25-1505181234.log:[OVERALL], Throughput(ops/sec), 3036.3389040031093
ycsb-12d6_dl585g7_VM02-a-run-35-1505181234.log:[OVERALL], Throughput(ops/sec), 3482.8241948460395
ycsb-12d6_dl585g7_VM02-a-run-50-1505181234.log:[OVERALL], Throughput(ops/sec), 3200.747694661473
ycsb-12d6_dl585g7_VM02-b-run-10-1505181234.log:[OVERALL], Throughput(ops/sec), 7524.284628638932
ycsb-12d6_dl585g7_VM02-b-run-25-1505181234.log:[OVERALL], Throughput(ops/sec), 9821.253191907288
ycsb-12d6_dl585g7_VM02-b-run-35-1505181234.log:[OVERALL], Throughput(ops/sec), 9962.589913722677
ycsb-12d6_dl585g7_VM02-b-run-50-1505181234.log:[OVERALL], Throughput(ops/sec), 9896.091044037605
ycsb-12d6_dl585g7_VM02-c-run-10-1505181234.log:[OVERALL], Throughput(ops/sec), 12754.776663860615
ycsb-12d6_dl585g7_VM02-c-run-25-1505181234.log:[OVERALL], Throughput(ops/sec), 12681.504026377528
ycsb-12d6_dl585g7_VM02-c-run-35-1505181234.log:[OVERALL], Throughput(ops/sec), 12645.23267577137
ycsb-12d6_dl585g7_VM02-c-run-50-1505181234.log:[OVERALL], Throughput(ops/sec), 12868.853513840451
ycsb-12d6_dl585g7_VM02-d-run-10-1505181234.log:[OVERALL], Throughput(ops/sec), 14962.444264895114
ycsb-12d6_dl585g7_VM02-d-run-25-1505181234.log:[OVERALL], Throughput(ops/sec), 14399.05542196432
ycsb-12d6_dl585g7_VM02-d-run-35-1505181234.log:[OVERALL], Throughput(ops/sec), 14072.007542709183
ycsb-12d6_dl585g7_VM02-d-run-50-1505181234.log:[OVERALL], Throughput(ops/sec), 12961.25879745441
ycsb-12d6_dl585g7_VM02-f-run-10-1505181234.log:[OVERALL], Throughput(ops/sec), 1737.2391101166381
ycsb-12d6_dl585g7_VM02-f-run-25-1505181234.log:[OVERALL], Throughput(ops/sec), 2815.426283693614
ycsb-12d6_dl585g7_VM02-f-run-35-1505181234.log:[OVERALL], Throughput(ops/sec), 3194.972954148255
ycsb-12d6_dl585g7_VM02-f-run-50-1505181234.log:[OVERALL], Throughput(ops/sec), 3296.9134296471643
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ] grep “RunTime(ms)” *.log
ycsb-12d6_dl585g7_VM02-a-run-10-1505181234.log:[OVERALL], RunTime(ms), 553598.0
ycsb-12d6_dl585g7_VM02-a-run-25-1505181234.log:[OVERALL], RunTime(ms), 329344.0
ycsb-12d6_dl585g7_VM02-a-run-35-1505181234.log:[OVERALL], RunTime(ms), 287119.0
ycsb-12d6_dl585g7_VM02-a-run-50-1505181234.log:[OVERALL], RunTime(ms), 312427.0
ycsb-12d6_dl585g7_VM02-b-run-10-1505181234.log:[OVERALL], RunTime(ms), 132903.0
ycsb-12d6_dl585g7_VM02-b-run-25-1505181234.log:[OVERALL], RunTime(ms), 101820.0
ycsb-12d6_dl585g7_VM02-b-run-35-1505181234.log:[OVERALL], RunTime(ms), 100374.0
ycsb-12d6_dl585g7_VM02-b-run-50-1505181234.log:[OVERALL], RunTime(ms), 101050.0
ycsb-12d6_dl585g7_VM02-c-run-10-1505181234.log:[OVERALL], RunTime(ms), 78402.0
ycsb-12d6_dl585g7_VM02-c-run-25-1505181234.log:[OVERALL], RunTime(ms), 78855.0
ycsb-12d6_dl585g7_VM02-c-run-35-1505181234.log:[OVERALL], RunTime(ms), 79080.0
ycsb-12d6_dl585g7_VM02-c-run-50-1505181234.log:[OVERALL], RunTime(ms), 77707.0
ycsb-12d6_dl585g7_VM02-d-run-10-1505181234.log:[OVERALL], RunTime(ms), 66834.0
ycsb-12d6_dl585g7_VM02-d-run-25-1505181234.log:[OVERALL], RunTime(ms), 69449.0
ycsb-12d6_dl585g7_VM02-d-run-35-1505181234.log:[OVERALL], RunTime(ms), 71062.0
ycsb-12d6_dl585g7_VM02-d-run-50-1505181234.log:[OVERALL], RunTime(ms), 77153.0
ycsb-12d6_dl585g7_VM02-f-run-10-1505181234.log:[OVERALL], RunTime(ms), 575626.0
ycsb-12d6_dl585g7_VM02-f-run-25-1505181234.log:[OVERALL], RunTime(ms), 355186.0
ycsb-12d6_dl585g7_VM02-f-run-35-1505181234.log:[OVERALL], RunTime(ms), 312987.0
ycsb-12d6_dl585g7_VM02-f-run-50-1505181234.log:[OVERALL], RunTime(ms), 303314.0
[ root @ myhostname : /mysql/ycsb-0.1.4/logs ]
grep “operations” *.log | grep “current ops/sec” | grep “a-run-35” | tail
grep “operations” *.log | grep “current ops/sec” | grep “b-run-35” | tail
grep “operations” *.log | grep “current ops/sec” | grep “c-run-35” | tail
grep “operations” *.log | grep “current ops/sec” | grep “d-run-35” | tail
grep “operations” *.log | grep “current ops/sec” | grep “e-run-35” | tail
grep “operations” *.log | grep “current ops/sec” | grep “f-run-35” | tail
grep “Throughput(ops/sec)” *.log
grep “RunTime(ms)” *.log
cat ycsbtest.log
[root@ip-10-0-0-67 logs]# grep “operations” *.log | grep “current ops/sec” | grep “a-run-35” | tail
ycsb–a-run-35-1507080139.log: 100 sec: 555914 operations; 5536.7 current ops/sec; [READ AverageLatency(us)=1352.38] [UPDATE AverageLatency(us)=11285.78]
ycsb–a-run-35-1507080139.log: 110 sec: 613024 operations; 5710.43 current ops/sec; [READ AverageLatency(us)=1344.79] [UPDATE AverageLatency(us)=10966.32]
ycsb–a-run-35-1507080139.log: 120 sec: 668828 operations; 5580.4 current ops/sec; [READ AverageLatency(us)=1374.18] [UPDATE AverageLatency(us)=11082.58]
ycsb–a-run-35-1507080139.log: 130 sec: 725163 operations; 5632.94 current ops/sec; [READ AverageLatency(us)=1404.29] [UPDATE AverageLatency(us)=11095.06]
ycsb–a-run-35-1507080139.log: 140 sec: 780676 operations; 5550.74 current ops/sec; [READ AverageLatency(us)=1404.36] [UPDATE AverageLatency(us)=11265.99]
ycsb–a-run-35-1507080139.log: 150 sec: 836211 operations; 5553.5 current ops/sec; [READ AverageLatency(us)=1362.88] [UPDATE AverageLatency(us)=11289.38]
ycsb–a-run-35-1507080139.log: 160 sec: 891332 operations; 5511.55 current ops/sec; [READ AverageLatency(us)=1358.75] [UPDATE AverageLatency(us)=11307.39]
ycsb–a-run-35-1507080139.log: 170 sec: 946341 operations; 5500.9 current ops/sec; [READ AverageLatency(us)=1361.83] [UPDATE AverageLatency(us)=11355.45]
ycsb–a-run-35-1507080139.log: 180 sec: 998931 operations; 5258.47 current ops/sec; [READ AverageLatency(us)=1302.93] [UPDATE AverageLatency(us)=10984.87]
ycsb–a-run-35-1507080139.log: 180 sec: 999985 operations; 1347.83 current ops/sec; [READ AverageLatency(us)=726.76] [UPDATE AverageLatency(us)=5037.86]
[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]# grep “operations” *.log | grep “current ops/sec” | grep “b-run-35” | tail
ycsb–b-run-35-1507080139.log: 10 sec: 97756 operations; 9746.36 current ops/sec; [READ AverageLatency(us)=2819.52] [UPDATE AverageLatency(us)=13709.07]
ycsb–b-run-35-1507080139.log: 20 sec: 248802 operations; 15101.58 current ops/sec; [READ AverageLatency(us)=1664.23] [UPDATE AverageLatency(us)=14775.72]
ycsb–b-run-35-1507080139.log: 30 sec: 405569 operations; 15676.7 current ops/sec; [READ AverageLatency(us)=1599.94] [UPDATE AverageLatency(us)=14172.73]
ycsb–b-run-35-1507080139.log: 40 sec: 563218 operations; 15763.32 current ops/sec; [READ AverageLatency(us)=1579.21] [UPDATE AverageLatency(us)=14357.36]
ycsb–b-run-35-1507080139.log: 50 sec: 721299 operations; 15808.1 current ops/sec; [READ AverageLatency(us)=1575.14] [UPDATE AverageLatency(us)=14528.29]
ycsb–b-run-35-1507080139.log: 60 sec: 878911 operations; 15759.62 current ops/sec; [READ AverageLatency(us)=1584.24] [UPDATE AverageLatency(us)=14144.4]
ycsb–b-run-35-1507080139.log: 68 sec: 999985 operations; 15134.25 current ops/sec; [READ AverageLatency(us)=1553.46] [UPDATE AverageLatency(us)=13914.25]
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]# grep “operations” *.log | grep “current ops/sec” | grep “c-run-35” | tail
ycsb–c-run-35-1507080139.log: 10 sec: 107208 operations; 10687.67 current ops/sec; [READ AverageLatency(us)=2525.11]
ycsb–c-run-35-1507080139.log: 20 sec: 309707 operations; 20245.85 current ops/sec; [READ AverageLatency(us)=1726.35]
ycsb–c-run-35-1507080139.log: 30 sec: 513269 operations; 20356.2 current ops/sec; [READ AverageLatency(us)=1717.25]
ycsb–c-run-35-1507080139.log: 40 sec: 717092 operations; 20382.3 current ops/sec; [READ AverageLatency(us)=1714.52]
ycsb–c-run-35-1507080139.log: 50 sec: 917031 operations; 19991.9 current ops/sec; [READ AverageLatency(us)=1748.26]
ycsb–c-run-35-1507080139.log: 54 sec: 999985 operations; 19727.47 current ops/sec; [READ AverageLatency(us)=1731.87]
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]# grep “operations” *.log | grep “current ops/sec” | grep “d-run-35” | tail
ycsb–d-run-35-1507080139.log: 10 sec: 80072 operations; 7976.89 current ops/sec; [READ AverageLatency(us)=3706.75] [INSERT AverageLatency(us)=11410.37]
ycsb–d-run-35-1507080139.log: 20 sec: 254841 operations; 17475.15 current ops/sec; [READ AverageLatency(us)=1891.67] [INSERT AverageLatency(us)=4060.17]
ycsb–d-run-35-1507080139.log: 30 sec: 439721 operations; 18486.15 current ops/sec; [READ AverageLatency(us)=1788.62] [INSERT AverageLatency(us)=3850.47]
ycsb–d-run-35-1507080139.log: 40 sec: 632175 operations; 19245.4 current ops/sec; [READ AverageLatency(us)=1718.42] [INSERT AverageLatency(us)=3684.64]
ycsb–d-run-35-1507080139.log: 50 sec: 822037 operations; 18984.3 current ops/sec; [READ AverageLatency(us)=1740.6] [INSERT AverageLatency(us)=3729.23]
ycsb–d-run-35-1507080139.log: 59 sec: 999985 operations; 18089.66 current ops/sec; [READ AverageLatency(us)=1735.27] [INSERT AverageLatency(us)=3914.32]
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]# grep “operations” *.log | grep “current ops/sec” | grep “e-run-35” | tail
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]# grep “operations” *.log | grep “current ops/sec” | grep “f-run-35” | tail
ycsb–f-run-35-1507080139.log: 120 sec: 586592 operations; 4997 current ops/sec; [READ AverageLatency(us)=1483.51] [READ-MODIFY-WRITE AverageLatency(us)=12.53] [UPDATE AverageLatency(us)=11043.96]
ycsb–f-run-35-1507080139.log: 130 sec: 634570 operations; 4797.8 current ops/sec; [READ AverageLatency(us)=1602.56] [READ-MODIFY-WRITE AverageLatency(us)=13.01] [UPDATE AverageLatency(us)=11407.6]
ycsb–f-run-35-1507080139.log: 140 sec: 685508 operations; 5093.29 current ops/sec; [READ AverageLatency(us)=1468.91] [READ-MODIFY-WRITE AverageLatency(us)=12.28] [UPDATE AverageLatency(us)=10812.53]
ycsb–f-run-35-1507080139.log: 150 sec: 734703 operations; 4919.5 current ops/sec; [READ AverageLatency(us)=1515.05] [READ-MODIFY-WRITE AverageLatency(us)=12.73] [UPDATE AverageLatency(us)=11203.18]
ycsb–f-run-35-1507080139.log: 160 sec: 785585 operations; 5087.69 current ops/sec; [READ AverageLatency(us)=1459.07] [READ-MODIFY-WRITE AverageLatency(us)=12.34] [UPDATE AverageLatency(us)=10881.99]
ycsb–f-run-35-1507080139.log: 170 sec: 836663 operations; 5107.8 current ops/sec; [READ AverageLatency(us)=1459.99] [READ-MODIFY-WRITE AverageLatency(us)=12.23] [UPDATE AverageLatency(us)=10768.7]
ycsb–f-run-35-1507080139.log: 180 sec: 887276 operations; 5060.79 current ops/sec; [READ AverageLatency(us)=1470.91] [READ-MODIFY-WRITE AverageLatency(us)=12.3] [UPDATE AverageLatency(us)=10824.47]
ycsb–f-run-35-1507080139.log: 190 sec: 936431 operations; 4915.5 current ops/sec; [READ AverageLatency(us)=1550.9] [READ-MODIFY-WRITE AverageLatency(us)=12.74] [UPDATE AverageLatency(us)=11190.36]
ycsb–f-run-35-1507080139.log: 200 sec: 986648 operations; 5021.2 current ops/sec; [READ AverageLatency(us)=1450.44] [READ-MODIFY-WRITE AverageLatency(us)=12.52] [UPDATE AverageLatency(us)=11067.31]
ycsb–f-run-35-1507080139.log: 203 sec: 999985 operations; 3776.05 current ops/sec; [READ AverageLatency(us)=1268.84] [READ-MODIFY-WRITE AverageLatency(us)=11.09] [UPDATE AverageLatency(us)=9827.36]
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]# grep “Throughput(ops/sec)” *.log
ycsb–a-run-10-1507080139.log:[OVERALL], Throughput(ops/sec), 2894.2219752486135
ycsb–a-run-25-1507080139.log:[OVERALL], Throughput(ops/sec), 4752.219286406752
ycsb–a-run-35-1507080139.log:[OVERALL], Throughput(ops/sec), 5530.462242967912
ycsb–a-run-50-1507080139.log:[OVERALL], Throughput(ops/sec), 6421.411554687951
ycsb–b-run-10-1507080139.log:[OVERALL], Throughput(ops/sec), 8913.84766234345
ycsb–b-run-25-1507080139.log:[OVERALL], Throughput(ops/sec), 13407.881152541464
ycsb–b-run-35-1507080139.log:[OVERALL], Throughput(ops/sec), 14699.392905966573
ycsb–b-run-50-1507080139.log:[OVERALL], Throughput(ops/sec), 15618.654921438167
ycsb–c-run-10-1507080139.log:[OVERALL], Throughput(ops/sec), 11830.259437589466
ycsb–c-run-25-1507080139.log:[OVERALL], Throughput(ops/sec), 18725.890416089285
ycsb–c-run-35-1507080139.log:[OVERALL], Throughput(ops/sec), 18437.661331956635
ycsb–c-run-50-1507080139.log:[OVERALL], Throughput(ops/sec), 18724.137285374578
ycsb–d-run-10-1507080139.log:[OVERALL], Throughput(ops/sec), 10902.27203349178
ycsb–d-run-25-1507080139.log:[OVERALL], Throughput(ops/sec), 16805.02806439687
ycsb–d-run-35-1507080139.log:[OVERALL], Throughput(ops/sec), 16700.93192598036
ycsb–d-run-50-1507080139.log:[OVERALL], Throughput(ops/sec), 16459.008838487745
ycsb–f-run-10-1507080139.log:[OVERALL], Throughput(ops/sec), 2510.87838058388
ycsb–f-run-25-1507080139.log:[OVERALL], Throughput(ops/sec), 4162.46950991084
ycsb–f-run-35-1507080139.log:[OVERALL], Throughput(ops/sec), 4912.362144769484
ycsb–f-run-50-1507080139.log:[OVERALL], Throughput(ops/sec), 5654.541444961521
[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]# grep “RunTime(ms)” *.log
ycsb–a-run-10-1507080139.log:[OVERALL], RunTime(ms), 345516.0
ycsb–a-run-25-1507080139.log:[OVERALL], RunTime(ms), 210428.0
ycsb–a-run-35-1507080139.log:[OVERALL], RunTime(ms), 180814.0
ycsb–a-run-50-1507080139.log:[OVERALL], RunTime(ms), 155729.0
ycsb–b-run-10-1507080139.log:[OVERALL], RunTime(ms), 112185.0
ycsb–b-run-25-1507080139.log:[OVERALL], RunTime(ms), 74583.0
ycsb–b-run-35-1507080139.log:[OVERALL], RunTime(ms), 68029.0
ycsb–b-run-50-1507080139.log:[OVERALL], RunTime(ms), 64026.0
ycsb–c-run-10-1507080139.log:[OVERALL], RunTime(ms), 84529.0
ycsb–c-run-25-1507080139.log:[OVERALL], RunTime(ms), 53402.0
ycsb–c-run-35-1507080139.log:[OVERALL], RunTime(ms), 54236.0
ycsb–c-run-50-1507080139.log:[OVERALL], RunTime(ms), 53407.0
ycsb–d-run-10-1507080139.log:[OVERALL], RunTime(ms), 91724.0
ycsb–d-run-25-1507080139.log:[OVERALL], RunTime(ms), 59506.0
ycsb–d-run-35-1507080139.log:[OVERALL], RunTime(ms), 59876.0
ycsb–d-run-50-1507080139.log:[OVERALL], RunTime(ms), 60757.0
ycsb–f-run-10-1507080139.log:[OVERALL], RunTime(ms), 398267.0
ycsb–f-run-25-1507080139.log:[OVERALL], RunTime(ms), 240242.0
ycsb–f-run-35-1507080139.log:[OVERALL], RunTime(ms), 203565.0
ycsb–f-run-50-1507080139.log:[OVERALL], RunTime(ms), 176849.0
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]# cat ycsbtest.log
ycsbrun,,a,15/07/08 01:44:20,15/07/08 01:46:56,1507080139,50
ycsbrun,,b,15/07/08 01:46:56,15/07/08 01:48:00,1507080139,50
ycsbrun,,c,15/07/08 01:48:00,15/07/08 01:48:54,1507080139,50
ycsbrun,,d,15/07/08 01:48:54,15/07/08 01:49:55,1507080139,50
ycsbrun,,f,15/07/08 01:49:55,15/07/08 01:52:52,1507080139,50
ycsbrun,,a,15/07/08 01:52:52,15/07/08 01:55:53,1507080139,35
ycsbrun,,b,15/07/08 01:55:53,15/07/08 01:57:01,1507080139,35
ycsbrun,,c,15/07/08 01:57:01,15/07/08 01:57:55,1507080139,35
ycsbrun,,d,15/07/08 01:57:55,15/07/08 01:58:55,1507080139,35
ycsbrun,,f,15/07/08 01:58:55,15/07/08 02:02:19,1507080139,35
ycsbrun,,a,15/07/08 02:02:19,15/07/08 02:05:50,1507080139,25
ycsbrun,,b,15/07/08 02:05:50,15/07/08 02:07:04,1507080139,25
ycsbrun,,c,15/07/08 02:07:04,15/07/08 02:07:58,1507080139,25
ycsbrun,,d,15/07/08 02:07:58,15/07/08 02:08:58,1507080139,25
ycsbrun,,f,15/07/08 02:08:58,15/07/08 02:12:58,1507080139,25
ycsbrun,,a,15/07/08 02:12:58,15/07/08 02:18:44,1507080139,10
ycsbrun,,b,15/07/08 02:18:44,15/07/08 02:20:36,1507080139,10
ycsbrun,,c,15/07/08 02:20:36,15/07/08 02:22:01,1507080139,10
ycsbrun,,d,15/07/08 02:22:01,15/07/08 02:23:33,1507080139,10
ycsbrun,,f,15/07/08 02:23:33,15/07/08 02:30:11,1507080139,10
[root@ip-10-0-0-67 logs]#
[root@ip-10-0-0-67 logs]#