>>http://dev.mysql.com/doc/refman/5.0/en/mysql-benchmarks.html
>>===MySql Benchmark===
You can use mysql bench to benchmark mysql on centos 4 or 5 and red hat rhel 4 or 5 

==Install==
%%
# yum install mysql-bench
%%

==Run==
%%
# cd /usr/share/sql-bench
# perl run-all-tests --server=mysql
%%

==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/"
}}

==Results from Server==
P4 Dual Core
%%
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
%%

==Results from Desktops==
P4 HT
%%
TOTALS                              4051.00  544.14  842.15 1386.29 3425950
%%
P4
%%
TOTALS                              4571.00  663.39  932.90 1596.29 3425950
%%

----
REFERRERS
{{backlinks}}