rendered paste bodyBenchmark DBD suite: 2.15
Date of test: 2008-04-15 7:22:34
Running tests on: Linux 2.6.9-42.0.8.ELsmp x86_64
Arguments:
Comments:
Limits from:
Server version: MySQL 5.0.27 log/
Optimization: None
Hardware:
alter-table: Total time: 45 wallclock secs ( 0.07 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.09 CPU)
ATIS: Total time: 22 wallclock secs ( 4.66 usr 0.85 sys + 0.00 cusr 0.00 csys = 5.51 CPU)
big-tables: Total time: 13 wallclock secs ( 4.47 usr 1.40 sys + 0.00 cusr 0.00 csys = 5.87 CPU)
connect: Total time: 76 wallclock secs (26.85 usr 16.25 sys + 0.00 cusr 0.00 csys = 43.10 CPU)
create: Warning: Can't execute create. Check the file 'output/create-mysql-Linux_2.6.9_42.0.8.ELsmp_x86_64'
Failed (output/create-mysql-Linux_2.6.9_42.0.8.ELsmp_x86_64)
insert:
Total time: 904 wallclock secs (284.97 usr 66.71 sys + 0.00 cusr 0.00 csys = 351.68 CPU)
select: Total time: 361 wallclock secs (28.29 usr 4.79 sys + 0.00 cusr 0.00 csys = 33.08 CPU)
transactions: Test skipped because the database doesn't support transactions
wisconsin: Total time: 6 wallclock secs ( 1.82 usr 0.75 sys + 0.00 cusr 0.00 csys = 2.57 CPU)
Of 9 tests, 1 tests didn't work
Totals per operation:
Operation seconds usr sys cpu tests
alter_table_add 20.00 0.01 0.00 0.01 100
alter_table_drop 17.00 0.02 0.00 0.02 91
connect 5.00 3.48 0.88 4.36 10000
connect+select_1_row 7.00 3.66 1.15 4.81 10000
connect+select_simple 6.00 3.51 1.07 4.58 10000
count 13.00 0.03 0.00 0.03 100
count_distinct 11.00 0.17 0.04 0.21 1000
count_distinct_2 16.00 0.20 0.01 0.21 1000
count_distinct_big 42.00 3.84 0.55 4.39 120
count_distinct_group 13.00 0.58 0.07 0.65 1000
count_distinct_group_on_key 14.00 0.17 0.04 0.21 1000
count_distinct_group_on_key_parts 13.00 0.51 0.06 0.57 1000
count_distinct_key_prefix 10.00 0.15 0.01 0.16 1000
count_group_on_key_parts 17.00 0.64 0.07 0.71 1000
count_on_key 133.00 6.25 1.16 7.41 50100
create_index 3.00 0.00 0.00 0.00 8
create_table 0.00 0.00 0.00 0.00 31
delete_all_many_keys 63.00 0.01 0.00 0.01 1
delete_big 0.00 0.00 0.00 0.00 1
delete_big_many_keys 63.00 0.01 0.00 0.01 128
delete_key 1.00 0.22 0.17 0.39 10000
delete_range 4.00 0.00 0.00 0.00 12
drop_index 5.00 0.01 0.00 0.01 8
drop_table 0.00 0.00 0.00 0.00 28
insert 40.00 6.94 5.97 12.91 350768
insert_duplicates 10.00 1.84 1.76 3.60 100000
insert_key 68.00 3.60 1.82 5.42 100000
insert_many_fields 3.00 0.13 0.04 0.17 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 9.00 0.02 0.00 0.02 60
min_max_on_key 17.00 9.75 1.72 11.47 85000
multiple_value_insert 2.00 0.23 0.03 0.26 100000
once_prepared_select 17.00 5.76 2.44 8.20 100000
order_by_big 18.00 11.29 1.70 12.99 10
order_by_big_key 15.00 12.04 1.81 13.85 10
order_by_big_key2 13.00 11.27 1.74 13.01 10
order_by_big_key_desc 15.00 12.00 1.78 13.78 10
order_by_big_key_diff 17.00 11.35 1.59 12.94 10
order_by_big_key_prefix 13.00 11.10 1.74 12.84 10
order_by_key2_diff 2.00 1.01 0.13 1.14 500
order_by_key_prefix 1.00 0.57 0.06 0.63 500
order_by_range 2.00 0.68 0.08 0.76 500
outer_join 19.00 0.00 0.00 0.00 10
outer_join_found 18.00 0.00 0.01 0.01 10
outer_join_not_found 20.00 0.01 0.00 0.01 500
outer_join_on_key 18.00 0.00 0.00 0.00 10
prepared_select 24.00 12.03 2.47 14.50 100000
select_1_row 10.00 2.41 2.05 4.46 100000
select_1_row_cache 9.00 2.57 2.09 4.66 100000
select_2_rows 11.00 2.97 2.29 5.26 100000
select_big 15.00 11.82 1.69 13.51 80
select_big_str 4.00 1.65 0.69 2.34 10000
select_cache 39.00 1.40 0.23 1.63 10000
select_cache2 39.00 1.22 0.21 1.43 10000
select_column+column 11.00 2.40 2.10 4.50 100000
select_diff_key 0.00 0.06 0.02 0.08 500
select_distinct 7.00 0.84 0.12 0.96 800
select_group 20.00 0.71 0.10 0.81 2911
select_join 1.00 0.28 0.04 0.32 100
select_key 47.00 26.27 5.07 31.34 200000
select_key2 49.00 25.59 5.17 30.76 200000
select_key2_return_key 43.00 23.25 4.68 27.93 200000
select_key2_return_prim 46.00 24.40 4.96 29.36 200000
select_key_prefix 48.00 25.06 5.23 30.29 200000
select_key_prefix_join 6.00 2.21 0.35 2.56 100
select_key_return_key 43.00 23.88 4.64 28.52 200000
select_many_fields 9.00 4.34 1.36 5.70 2000
select_range 45.00 4.80 0.70 5.50 410
select_range_key2 6.00 2.48 0.38 2.86 25010
select_range_prefix 7.00 2.76 0.46 3.22 25010
select_simple 7.00 2.21 2.00 4.21 100000
select_simple_cache 6.00 1.99 1.93 3.92 100000
select_simple_join 1.00 0.39 0.07 0.46 500
update_big 12.00 0.00 0.00 0.00 10
update_of_key 7.00 1.18 0.99 2.17 50000
update_of_key_big 8.00 0.01 0.02 0.03 501
update_of_primary_key_many_keys 12.00 0.01 0.01 0.02 256
update_with_key 36.00 6.85 5.93 12.78 300000
update_with_key_prefix 13.00 3.74 2.07 5.81 100000
wisc_benchmark 2.00 1.21 0.21 1.42 114
TOTALS 1461.00 346.05 90.03 436.08 3375950