FsseInfo: MySql Benchmark

Revision [643]

Last edited on 2008-06-20 15:43:36 by FsseInfo

Additions:

TOTALS 4571.00 663.39 932.90 1596.29 3425950

Revision [642]

Edited on 2008-06-20 15:37:09 by FsseInfo

Additions:

==Results from Server==
P4 Dual Core
==Results from Desktops==
P4 HT
TOTALS 4051.00 544.14 842.15 1386.29 3425950
P4
TOTALS 4051.00 544.14 842.15 1386.29 3425950

Deletions:

~~==Results==~~

Revision [641]

Edited on 2008-06-20 15:05:09 by FsseInfo

No Differences

Revision [640]

Edited on 2008-06-20 15:04:15 by FsseInfo

Additions:

==Watch CPU==
{{
image title="xinit" alt="xinit" url="http://farm4.static.flickr.com/3058/2594655637_3dd5ea4e12_m.jpg" link="http://www.flickr.com/photos/osde-info/2594655637/"
}}

Revision [639]

Edited on 2008-06-20 14:59:28 by FsseInfo

Additions:

==Results==
All 9 test executed successfully
Totals per operation:
Operation seconds usr sys cpu tests
alter_table_add 8.00 0.01 0.01 0.02 100
alter_table_drop 7.00 0.00 0.02 0.02 91
connect 5.00 1.57 1.32 2.89 10000
connect+select_1_row 7.00 1.83 1.69 3.52 10000
connect+select_simple 6.00 1.72 1.62 3.34 10000
count 6.00 0.02 0.01 0.03 100
count_distinct 6.00 0.09 0.17 0.26 1000
...
update_of_key 14.00 0.24 0.89 1.13 50000
update_of_key_big 10.00 0.00 0.02 0.02 501
update_of_primary_key_many_keys 11.00 0.02 0.01 0.03 256
update_with_key 66.00 1.55 5.12 6.67 300000
update_with_key_prefix 19.00 1.73 2.82 4.55 100000
wisc_benchmark 7.00 1.08 4.66 5.74 114
TOTALS 1573.00 193.80 226.64 420.44 3425950

Revision [638]

Edited on 2008-06-20 14:32:10 by FsseInfo

Additions:

>>http://dev.mysql.com/doc/refman/5.0/en/mysql-benchmarks.html
>>===MySql Benchmark===

Deletions:

~~===MySql Benchmark===~~

Revision [637]

Edited on 2008-06-20 14:31:32 by FsseInfo

Additions:

You can use mysql bench to benchmark mysql on centos 4 or 5 and red hat rhel 4 or 5
# cd /usr/share/sql-bench
# perl run-all-tests --server=mysql
----
REFERRERS
{{backlinks}}

Deletions:

$ cd /usr/share/sql-bench
$ perl run-all-tests --user root --password password

Revision [479]

The oldest known version of this page was created on 2008-04-26 21:48:51 by FsseInfo