diff options
Diffstat (limited to '')
| -rw-r--r-- | sql-bench/example | 19 | ||||
| -rwxr-xr-x | sql-bench/example.bat | 7 |
2 files changed, 26 insertions, 0 deletions
diff --git a/sql-bench/example b/sql-bench/example new file mode 100644 index 00000000..29c1d814 --- /dev/null +++ b/sql-bench/example @@ -0,0 +1,19 @@ +#/bin/sh + +hw="2xPentium(R) 3.2 GHz, 1M cache, 4G memory" +optimization="gcc 4.1.2 -m64 -O3 --static" +machine="Linux-x64" + +# InnoDB tests + +./run-all-tests --suffix=-innodb --comments="Engine=InnoDB --innodb_buffer_pool_size=256M --innodb_log_file_size=2000M --innodb_log_buffer_size=16M --innodb_lock_wait_timeout=50 --innodb_flush_log_at_trx_commit=1 --innodb_flush_method=O_DIRECT --innodb_log_files_in_group=1 --skip-innodb-doublewrite" --create-options="ENGINE=InnoDB" --hw="$hw" --optimization="$optimization" --machine="$machine" --log + +./run-all-tests --suffix=_fast-innodb --comments="Engine=InnoDB --innodb_buffer_pool_size=256M --innodb_log_file_size=2000M --innodb_log_buffer_size=16M --innodb_lock_wait_timeout=50 --innodb_flush_log_at_trx_commit=1 --innodb_flush_method=O_DIRECT --innodb_log_files_in_group=1 --skip-innodb-doublewrite" --create-options="ENGINE=InnoDB" --hw="$hw" --optimization="$optimization" --machine="$machine" --fast --log + +# MyISAM tests + +./run-all-tests --suffix=-myisam --comments="Engine=MyISAM key_buffer_size=256M" --create-options="ENGINE=myisam" --hw="$hw" --optimization="$optimization" --machine="$machine" --log + +./run-all-tests --suffix=_fast-myisam --comments="Engine=MyISAM key_buffer_size=256M" --create-options="ENGINE=myisam" --hw="$hw" --optimization="$optimization" --machine="$machine" --fast --log + +compare-results --relative output/RUN-mysql-myisam-* output/RUN-mysql_fast-myisam* output/RUN-mysql* diff --git a/sql-bench/example.bat b/sql-bench/example.bat new file mode 100755 index 00000000..5bc1b458 --- /dev/null +++ b/sql-bench/example.bat @@ -0,0 +1,7 @@ +REM +REM Example use to run test on PC +REM One need only to run 'comapre-results' to view results from old runs + +perl run-all-tests --server mysql --cmp "access,mysql" +perl run-all-tests --server mysql --cmp "access,mysql" --log --use-old-results +perl compare-results --cmp "access,mysql" -rel |