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 <hakan@askmonty.org> 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