rendered paste bodyBenchmark DBD suite: 2.15
Date of test: 2009-04-06 14:33:11
Running tests on: FreeBSD 7.2-PRERELEASE amd64
Arguments:
Comments:
Limits from:
Server version: MySQL 5.1.33 log
Optimization: None
Hardware:
alter-table: Total time: 20 wallclock secs ( 0.05 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.07 CPU)
ATIS: Total time: 13 wallclock secs ( 2.16 usr 0.24 sys + 0.00 cusr 0.00 csys = 2.41 CPU)
big-tables: Total time: 13 wallclock secs ( 4.50 usr 0.23 sys + 0.00 cusr 0.00 csys = 4.73 CPU)
connect: Total time: 77 wallclock secs (22.43 usr 12.31 sys + 0.00 cusr 0.00 csys = 34.74 CPU)
create: Total time: 113 wallclock secs ( 2.21 usr 1.06 sys + 0.00 cusr 0.00 csys = 3.27 CPU)
insert: Total time: 1083 wallclock secs (182.53 usr 39.30 sys + 0.00 cusr 0.00 csys = 221.83 CPU)
select: Total time: 326 wallclock secs (16.54 usr 2.61 sys + 0.00 cusr 0.00 csys = 19.15 CPU)
transactions: Test skipped because the database doesn't support transactions
wisconsin: Total time: 6 wallclock secs ( 1.22 usr 0.50 sys + 0.00 cusr 0.00 csys = 1.72 CPU)
All 9 test executed successfully
Totals per operation:
Operation seconds usr sys cpu tests
alter_table_add 9.00 0.02 0.01 0.02 100
alter_table_drop 9.00 0.02 0.00 0.02 91
connect 6.00 3.18 0.97 4.15 10000
connect+select_1_row 8.00 4.00 0.91 4.91 10000
connect+select_simple 7.00 3.63 0.93 4.56 10000
count 4.00 0.02 0.01 0.02 100
count_distinct 11.00 0.11 0.02 0.13 1000
count_distinct_2 17.00 0.11 0.03 0.14 1000
count_distinct_big 19.00 1.80 0.04 1.84 120
count_distinct_group 10.00 0.27 0.03 0.30 1000
count_distinct_group_on_key 12.00 0.13 0.02 0.16 1000
count_distinct_group_on_key_parts 10.00 0.24 0.05 0.30 1000
count_distinct_key_prefix 5.00 0.09 0.03 0.12 1000
count_group_on_key_parts 17.00 0.25 0.02 0.27 1000
count_on_key 101.00 4.01 0.84 4.85 50100
create+drop 31.00 0.67 0.30 0.97 10000
create_MANY_tables 41.00 0.52 0.16 0.68 10000
create_index 1.00 0.00 0.00 0.00 8
create_key+drop 37.00 0.77 0.34 1.11 10000
create_table 0.00 0.00 0.00 0.00 31
delete_all_many_keys 190.00 0.01 0.00 0.01 1
delete_big 0.00 0.00 0.00 0.00 1
delete_big_many_keys 190.00 0.01 0.00 0.01 128
delete_key 2.00 0.10 0.13 0.23 10000
delete_range 5.00 0.01 0.00 0.01 12
drop_index 1.00 0.00 0.00 0.00 8
drop_table 0.00 0.00 0.00 0.00 28
drop_table_when_MANY_tables 1.00 0.10 0.13 0.23 10000
insert 38.00 4.17 3.90 8.07 350768
insert_duplicates 8.00 1.46 1.45 2.91 100000
insert_key 182.00 3.26 1.23 4.49 100000
insert_many_fields 3.00 0.10 0.04 0.13 2000
insert_select_1_key 2.00 0.00 0.00 0.00 1
insert_select_2_keys 3.00 0.00 0.00 0.00 1
min_max 6.00 0.01 0.00 0.01 60
min_max_on_key 13.00 6.42 1.30 7.72 85000
multiple_value_insert 2.00 0.25 0.01 0.26 100000
once_prepared_select 16.00 3.23 1.38 4.61 100000
order_by_big 10.00 5.41 0.18 5.59 10
order_by_big_key 10.00 6.27 0.27 6.53 10
order_by_big_key2 7.00 5.48 0.13 5.61 10
order_by_big_key_desc 10.00 6.25 0.20 6.45 10
order_by_big_key_diff 9.00 5.41 0.17 5.59 10
order_by_big_key_prefix 9.00 5.47 0.20 5.66 10
order_by_key2_diff 2.00 0.55 0.00 0.55 500
order_by_key_prefix 1.00 0.24 0.02 0.27 500
order_by_range 1.00 0.26 0.02 0.28 500
outer_join 23.00 0.00 0.00 0.00 10
outer_join_found 23.00 0.01 0.00 0.01 10
outer_join_not_found 17.00 0.00 0.00 0.00 500
outer_join_on_key 17.00 0.00 0.00 0.00 10
prepared_select 22.00 7.67 1.66 9.34 100000
select_1_row 10.00 1.93 1.48 3.41 100000
select_1_row_cache 9.00 1.73 1.31 3.04 100000
select_2_rows 11.00 2.01 1.45 3.46 100000
select_big 8.00 5.42 0.20 5.62 80
select_big_str 5.00 1.52 1.24 2.77 10000
select_cache 42.00 0.82 0.11 0.93 10000
select_cache2 43.00 0.78 0.17 0.95 10000
select_column+column 10.00 1.52 1.41 2.93 100000
select_diff_key 0.00 0.05 0.01 0.06 500
select_distinct 3.00 0.43 0.03 0.46 800
select_group 18.00 0.40 0.05 0.45 2911
select_group_when_MANY_tables 3.00 0.16 0.12 0.27 10000
select_join 1.00 0.12 0.00 0.12 100
select_key 42.00 18.67 3.48 22.15 200000
select_key2 45.00 18.50 3.51 22.01 200000
select_key2_return_key 40.00 17.12 3.55 20.66 200000
select_key2_return_prim 42.00 17.28 3.64 20.92 200000
select_key_prefix 48.00 18.94 3.85 22.79 200000
select_key_prefix_join 3.00 0.90 0.04 0.94 100
select_key_return_key 38.00 17.38 3.39 20.77 200000
select_many_fields 10.00 4.41 0.20 4.60 2000
select_range 55.00 2.46 0.05 2.51 410
select_range_key2 7.00 1.90 0.27 2.18 25010
select_range_prefix 8.00 2.02 0.24 2.26 25010
select_simple 6.00 1.44 1.37 2.80 100000
select_simple_cache 5.00 1.47 1.23 2.70 100000
select_simple_join 1.00 0.14 0.02 0.16 500
update_big 16.00 0.00 0.00 0.00 10
update_of_key 8.00 0.63 0.56 1.20 50000
update_of_key_big 11.00 0.01 0.00 0.01 501
update_of_primary_key_many_keys 37.00 0.02 0.01 0.02 256
update_with_key 40.00 3.42 3.97 7.39 300000
update_with_key_prefix 15.00 2.58 1.89 4.47 100000
wisc_benchmark 2.00 0.88 0.17 1.05 114
TOTALS 1820.00 229.05 56.15 285.18 3425950