1
# This file describes how to run MySQL benchmarks with MySQL
4
# The test was run on a Intel Xeon 2x 550 Mzh machine with 1G memory,
5
# 9G hard disk. The OS is Suse 6.4, with Linux 2.2.14 compiled with SMP
7
# Both the perl client and the database server is run
8
# on the same machine. No other cpu intensive process was used during
13
# First, install MySQL from RPM or compile it according to the
14
# recommendations in the MySQL manual
19
bin/safe_mysqld -O key_buffer=16M &
22
# Now we run the test that can be found in the sql-bench directory in the
23
# MySQL 3.23 source distribution with and without --fast
25
# Note that if you want to make a results that is comparead to some database,
26
# You should add "--cmp=databasename" as an extra option to the test
30
run-all-tests --comment="Intel Xeon, 2x550 Mhz, 1G, key_buffer=16M" $CMP
31
run-all-tests --comment="Intel Xeon, 2x550 Mhz, 1G, key_buffer=16M" --fast $CMP
33
# If you want to store the results in a output/RUN-xxx file, you should
34
# repeate the benchmark with the extra option --log --use-old-result
35
# This will create a the RUN file based of the previous results
38
run-all-tests --comment="Intel Xeon, 2x550 Mhz, 1G, key_buffer=16M" --log --use-old-result $CMP
39
run-all-tests --comment="Intel Xeon, 2x550 Mhz, 1G, key_buffer=16M" --fast --log --use-old-result $CMP