At file:///Users/hakan/work/monty_program/mariadb-tools/
------------------------------------------------------------
revno: 25
revision-id: hakan@askmonty.org-20100309233127-vgj4q029apf0un2x
parent: hakan@askmonty.org-20100309220617-3ti82bv9tvlvx5w6
committer: Hakan Kuecuekyilmaz
branch nick: mariadb-tools
timestamp: Wed 2010-03-10 00:31:27 +0100
message:
Added status information about warm up and actual run.
=== modified file 'sysbench/conf/lu0012.inc'
--- a/sysbench/conf/lu0012.inc 2010-03-09 22:05:59 +0000
+++ b/sysbench/conf/lu0012.inc 2010-03-09 23:31:27 +0000
@@ -22,7 +22,7 @@
# System statistic binaries.
IOSTAT='/usr/bin/iostat'
IOSTAT_DEVICE='/dev/sda'
-# For CPU utilization statistics
+# For CPU utilization statistics.
MPSTAT='/usr/bin/mpstat'
# Directories.
=== modified file 'sysbench/conf/perro.inc'
--- a/sysbench/conf/perro.inc 2010-03-09 22:05:59 +0000
+++ b/sysbench/conf/perro.inc 2010-03-09 23:31:27 +0000
@@ -22,7 +22,7 @@
# System statistic binaries.
IOSTAT='/usr/bin/iostat'
IOSTAT_DEVICE='/dev/sda'
-# For CPU utilization statistics
+# For CPU utilization statistics.
MPSTAT='/usr/bin/mpstat'
# Other binaries.
=== modified file 'sysbench/conf/work.inc'
--- a/sysbench/conf/work.inc 2010-03-09 22:05:59 +0000
+++ b/sysbench/conf/work.inc 2010-03-09 23:31:27 +0000
@@ -22,7 +22,7 @@
# System statistic binaries.
IOSTAT='/usr/bin/iostat'
IOSTAT_DEVICE='/dev/sda'
-# For CPU utilization statistics
+# For CPU utilization statistics.
MPSTAT='/usr/bin/mpstat'
# Other binaries.
=== modified file 'sysbench/run-sysbench-myisam.sh'
--- a/sysbench/run-sysbench-myisam.sh 2010-03-09 22:03:48 +0000
+++ b/sysbench/run-sysbench-myisam.sh 2010-03-09 23:31:27 +0000
@@ -271,6 +271,9 @@
#
echo $MYSQL_OPTIONS > ${RESULT_DIR}/${TODAY}/${PRODUCT}/mysqld_options.txt
echo $SYSBENCH_OPTIONS > ${RESULT_DIR}/${TODAY}/${PRODUCT}/sysbench_options.txt
+echo '' >> ${RESULT_DIR}/${TODAY}/${PRODUCT}/sysbench_options.txt
+echo "Warm up time is: $WARM_UP_TIME" >> ${RESULT_DIR}/${TODAY}/${PRODUCT}/sysbench_options.txt
+echo "Run time is: $RUN_TIME" >> ${RESULT_DIR}/${TODAY}/${PRODUCT}/sysbench_options.txt
for SYSBENCH_TEST in $SYSBENCH_TESTS
do
@@ -325,8 +328,12 @@
start_mysqld
sync
+ echo "[$(date "+%Y-%m-%d %H:%M:%S")] Starting warm up of $WARM_UP_TIME seconds."
$SYSBENCH $SYSBENCH_OPTIONS_WARM_UP run
sync
+ echo "[$(date "+%Y-%m-%d %H:%M:%S")] Finnished warm up."
+
+ echo "[$(date "+%Y-%m-%d %H:%M:%S")] Starting actual sysbench run."
$SYSBENCH $SYSBENCH_OPTIONS_RUN run > ${THIS_RESULT_DIR}/result${k}.txt 2>&1
grep "write requests:" ${THIS_RESULT_DIR}/result${k}.txt | awk '{ print $4 }' | sed -e 's/(//' >> ${THIS_RESULT_DIR}/results.txt
=== modified file 'sysbench/run-sysbench.sh'
--- a/sysbench/run-sysbench.sh 2010-03-09 22:03:48 +0000
+++ b/sysbench/run-sysbench.sh 2010-03-09 23:31:27 +0000
@@ -267,6 +267,9 @@
#
echo $MYSQL_OPTIONS > ${RESULT_DIR}/${TODAY}/${PRODUCT}/mysqld_options.txt
echo $SYSBENCH_OPTIONS > ${RESULT_DIR}/${TODAY}/${PRODUCT}/sysbench_options.txt
+echo '' >> ${RESULT_DIR}/${TODAY}/${PRODUCT}/sysbench_options.txt
+echo "Warm up time is: $WARM_UP_TIME" >> ${RESULT_DIR}/${TODAY}/${PRODUCT}/sysbench_options.txt
+echo "Run time is: $RUN_TIME" >> ${RESULT_DIR}/${TODAY}/${PRODUCT}/sysbench_options.txt
for SYSBENCH_TEST in $SYSBENCH_TESTS
do
@@ -321,8 +324,12 @@
start_mysqld
sync
+ echo "[$(date "+%Y-%m-%d %H:%M:%S")] Starting warm up of $WARM_UP_TIME seconds."
$SYSBENCH $SYSBENCH_OPTIONS_WARM_UP run
sync
+ echo "[$(date "+%Y-%m-%d %H:%M:%S")] Finnished warm up."
+
+ echo "[$(date "+%Y-%m-%d %H:%M:%S")] Starting actual sysbench run."
$SYSBENCH $SYSBENCH_OPTIONS_RUN run > ${THIS_RESULT_DIR}/result${k}.txt 2>&1
grep "write requests:" ${THIS_RESULT_DIR}/result${k}.txt | awk '{ print $4 }' | sed -e 's/(//' >> ${THIS_RESULT_DIR}/results.txt
