maria-developers team mailing list archive

[Hakan Kuecuekyilmaz <hakan@xxxxxxxxxxxx>]

At file:///Users/hakan/work/monty_program/mariadb-tools/

------------------------------------------------------------
revno: 28
revision-id: hakan@xxxxxxxxxxxx-20100325014205-kwsruwixwlymz1ti
parent: hakan@xxxxxxxxxxxx-20100310010046-hwv56n4wfn4t4odp
committer: Hakan Kuecuekyilmaz <hakan@xxxxxxxxxxxx>
branch nick: mariadb-tools
timestamp: Thu 2010-03-25 02:42:05 +0100
message:
  Added note about noop IO scheduler for Linux. Refactor variable name.
  For MyISAM related tests added key_cache statistics dump out.

=== modified file 'sysbench/run-sysbench-myisam.sh'
--- a/sysbench/run-sysbench-myisam.sh	2010-03-10 01:00:46 +0000
+++ b/sysbench/run-sysbench-myisam.sh	2010-03-25 01:42:05 +0000
@@ -6,16 +6,20 @@
 #   * Do not run this script with root privileges. We use
 #   killall -9, which can cause severe side effects!
 #   * By bzr pull we mean bzr merge --pull
+#   * For reasonable performance set your IO scheduler to noop or deadline, for
+#   reference please check
+#   http://www.mysqlperformanceblog.com/2009/01/30/linux-schedulers-in-tpcc-like-benchmark/
 #
 # Index sizes for 20 mio rows (--table-size=20000000).
-#   * delete.lua:           313M  sbtest.MYI
-#   * insert.lua:           4.0K  sbtest.MYI
-#   * oltp_complex_ro.lua:  313M  sbtest.MYI
-#   * oltp_complex_rw.lua:  313M  sbtest.MYI
-#   * oltp_simple.lua:      325M  sbtest.MYI
-#   * select.lua:           313M  sbtest.MYI
-#   * update_index.lua:     313M  sbtest.MYI
-#   * update_non_index.lua: 313M  sbtest.MYI
+#   * delete.lua                313M  sbtest.MYI
+#   * insert.lua                4.0K  sbtest.MYI
+#   * oltp_complex_ro.lua       313M  sbtest.MYI
+#   * oltp_complex_rw.lua       313M  sbtest.MYI
+#   * oltp_simple.lua           325M  sbtest.MYI
+#   * select.lua                313M  sbtest.MYI
+#   * select_random_ranges.lua  313M  sbtest.MYI
+#   * update_index.lua          313M  sbtest.MYI
+#   * update_non_index.lua      313M  sbtest.MYI
 #
 # Hakan Kuecuekyilmaz <hakan at askmonty dot org> 2010-02-19.
 #
@@ -60,13 +64,14 @@
 # change these, except you exactly know what you are doing.
 #
 MYSQLADMIN='client/mysqladmin'
+MYSQL='client/mysql'
 
 #
 # Variables.
 #
 MY_SOCKET="/tmp/mysql.sock"
 MYSQLADMIN_OPTIONS="--no-defaults -uroot --socket=$MY_SOCKET"
-MYSQL_OPTIONS="--no-defaults \
+MYSQLD_OPTIONS="--no-defaults \
   --datadir=$DATA_DIR \
   --language=./sql/share/english \
   --key_buffer_size=32M \
@@ -104,6 +109,7 @@
   oltp_complex_rw.lua \
   oltp_simple.lua \
   select.lua \
+  select_random_ranges.lua \
   update_index.lua \
   update_non_index.lua"
 
@@ -240,7 +246,7 @@
 }
 
 function start_mysqld {
-    sql/mysqld $MYSQL_OPTIONS &
+    sql/mysqld $MYSQLD_OPTIONS &
 
     j=0
     STARTED=-1
@@ -269,7 +275,7 @@
 #
 # Write out configurations used for future refernce.
 #
-echo $MYSQL_OPTIONS > ${RESULT_DIR}/${TODAY}/${PRODUCT}/mysqld_options.txt
+echo $MYSQLD_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
@@ -331,6 +337,7 @@
             echo "[$(date "+%Y-%m-%d %H:%M:%S")] Starting warm up of $WARM_UP_TIME seconds."
             $SYSBENCH $SYSBENCH_OPTIONS_WARM_UP run
             sync
+            echo 'FLUSH STATUS' | $MYSQL -uroot
             echo "[$(date "+%Y-%m-%d %H:%M:%S")] Finnished warm up."
 
             echo "[$(date "+%Y-%m-%d %H:%M:%S")] Starting actual sysbench run."
@@ -338,6 +345,8 @@
             
             grep "write requests:" ${THIS_RESULT_DIR}/result${k}.txt | awk '{ print $4 }' | sed -e 's/(//' >> ${THIS_RESULT_DIR}/results.txt
 
+            echo 'SELECT * FROM INFORMATION_SCHEMA.KEY_CACHES' | $MYSQL -uroot > ${THIS_RESULT_DIR}/key_cache_stats{k}.txt
+
             k=$(($k + 1))
         done
         

=== modified file 'sysbench/run-sysbench.sh'
--- a/sysbench/run-sysbench.sh	2010-03-10 00:02:01 +0000
+++ b/sysbench/run-sysbench.sh	2010-03-25 01:42:05 +0000
@@ -6,6 +6,9 @@
 #   * Do not run this script with root privileges. We use
 #   killall -9, which can cause severe side effects!
 #   * By bzr pull we mean bzr merge --pull
+#   * For reasonable performance set your IO scheduler to noop or deadline, for
+#   reference please check
+#   http://www.mysqlperformanceblog.com/2009/01/30/linux-schedulers-in-tpcc-like-benchmark/
 #
 # Hakan Kuecuekyilmaz <hakan at askmonty dot org> 2010-02-19.
 #
@@ -56,7 +59,7 @@
 #
 MY_SOCKET="/tmp/mysql.sock"
 MYSQLADMIN_OPTIONS="--no-defaults -uroot --socket=$MY_SOCKET"
-MYSQL_OPTIONS="--no-defaults \
+MYSQLD_OPTIONS="--no-defaults \
   --datadir=$DATA_DIR \
   --language=./sql/share/english \
   --max_connections=256 \
@@ -236,7 +239,7 @@
 }
 
 function start_mysqld {
-    sql/mysqld $MYSQL_OPTIONS &
+    sql/mysqld $MYSQLD_OPTIONS &
 
     j=0
     STARTED=-1
@@ -265,7 +268,7 @@
 #
 # Write out configurations used for future refernce.
 #
-echo $MYSQL_OPTIONS > ${RESULT_DIR}/${TODAY}/${PRODUCT}/mysqld_options.txt
+echo $MYSQLD_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