##################################################################### #################### SQL bench july 2008 ############################ ####################### KIMSUFI08 Benchmark DBD suite: 2.15 Date of test: 2008-07-24 3:09:33 Running tests on: Linux 2.6.24.5-grsec-xxxx-grs-ipv6-32 i686 Arguments: Comments: Limits from: Server version: MySQL 5.0.32 Debian_7etch5 log/ Optimization: None Hardware: alter-table: Total time: 32 wallclock secs ( 0.13 usr 0.03 sys + 0.00 cusr 0.00 csys = 0.16 CPU) ATIS: Total time: 16 wallclock secs ( 5.93 usr 0.67 sys + 0.00 cusr 0.00 csys = 6.60 CPU) big-tables: Total time: 13 wallclock secs ( 5.13 usr 1.31 sys + 0.00 cusr 0.00 csys = 6.44 CPU) connect: Total time: 255 wallclock secs (66.75 usr 16.44 sys + 0.00 cusr 0.00 csys = 83.19 CPU) create: Total time: 229 wallclock secs ( 8.40 usr 1.90 sys + 0.00 cusr 0.00 csys = 10.30 CPU) insert: Total time: 2056 wallclock secs (588.28 usr 82.56 sys + 0.00 cusr 0.00 csys = 670.84 CPU) select: Total time: 154 wallclock secs (43.69 usr 5.43 sys + 0.00 cusr 0.00 csys = 49.12 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 12 wallclock secs ( 3.48 usr 0.78 sys + 0.00 cusr 0.00 csys = 4.26 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 14.00 0.05 0.01 0.06 100 alter_table_drop 14.00 0.01 0.01 0.02 91 connect 12.00 7.02 0.94 7.96 10000 connect+select_1_row 15.00 8.00 1.43 9.43 10000 connect+select_simple 14.00 9.52 1.03 10.55 10000 count 18.00 0.04 0.00 0.04 100 count_distinct 1.00 0.25 0.03 0.28 1000 count_distinct_2 0.00 0.21 0.05 0.26 1000 count_distinct_big 8.00 5.18 0.43 5.61 120 count_distinct_group 1.00 0.76 0.04 0.80 1000 count_distinct_group_on_key 0.00 0.27 0.02 0.29 1000 count_distinct_group_on_key_parts 1.00 0.79 0.09 0.88 1000 count_distinct_key_prefix 0.00 0.24 0.04 0.28 1000 count_group_on_key_parts 1.00 0.70 0.07 0.77 1000 count_on_key 36.00 9.37 1.37 10.74 50100 create+drop 30.00 2.52 0.52 3.04 10000 create_MANY_tables 126.00 1.77 0.32 2.09 10000 create_index 2.00 0.00 0.00 0.00 8 create_key+drop 30.00 2.44 0.57 3.01 10000 create_table 0.00 0.01 0.00 0.01 31 delete_all_many_keys 77.00 0.00 0.01 0.01 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 77.00 0.00 0.01 0.01 128 delete_key 4.00 0.62 0.26 0.88 10000 delete_range 6.00 0.01 0.00 0.01 12 drop_index 2.00 0.00 0.00 0.00 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 3.00 0.63 0.19 0.82 10000 insert 126.00 22.01 6.69 28.70 350768 insert_duplicates 25.00 6.47 1.92 8.39 100000 insert_key 183.00 11.02 2.55 13.57 100000 insert_many_fields 7.00 0.39 0.07 0.46 2000 insert_select_1_key 3.00 0.00 0.00 0.00 1 insert_select_2_keys 3.00 0.00 0.00 0.00 1 min_max 3.00 0.01 0.00 0.01 60 min_max_on_key 30.00 18.22 2.43 20.65 85000 multiple_value_insert 2.00 0.36 0.00 0.36 100000 once_prepared_select 66.00 13.66 2.93 16.59 100000 order_by_big 30.00 14.84 1.53 16.37 10 order_by_big_key 29.00 15.28 1.58 16.86 10 order_by_big_key2 26.00 14.85 1.44 16.29 10 order_by_big_key_desc 22.00 15.14 1.75 16.89 10 order_by_big_key_diff 22.00 14.74 1.65 16.39 10 order_by_big_key_prefix 21.00 14.65 1.34 15.99 10 order_by_key2_diff 3.00 1.39 0.13 1.52 500 order_by_key_prefix 1.00 0.70 0.09 0.79 500 order_by_range 2.00 0.85 0.09 0.94 500 outer_join 3.00 0.00 0.01 0.01 10 outer_join_found 2.00 0.00 0.00 0.00 10 outer_join_not_found 2.00 0.00 0.00 0.00 500 outer_join_on_key 2.00 0.00 0.00 0.00 10 prepared_select 91.00 32.86 3.32 36.18 100000 select_1_row 43.00 7.15 2.16 9.31 100000 select_1_row_cache 8.00 3.67 1.49 5.16 100000 select_2_rows 64.00 8.28 2.42 10.70 100000 select_big 20.00 14.83 1.51 16.34 80 select_big_str 14.00 6.42 1.04 7.46 10000 select_cache 5.00 2.18 0.15 2.33 10000 select_cache2 80.00 2.67 0.32 2.99 10000 select_column+column 48.00 6.75 2.39 9.14 100000 select_diff_key 0.00 0.18 0.02 0.20 500 select_distinct 1.00 1.14 0.12 1.26 800 select_group 4.00 1.03 0.08 1.11 2911 select_group_when_MANY_tables 40.00 1.04 0.30 1.34 10000 select_join 1.00 0.19 0.08 0.27 100 select_key 154.00 57.07 7.00 64.07 200000 select_key2 160.00 58.18 7.24 65.42 200000 select_key2_return_key 161.00 54.65 6.66 61.31 200000 select_key2_return_prim 166.00 56.80 6.89 63.69 200000 select_key_prefix 163.00 58.24 7.28 65.52 200000 select_key_prefix_join 4.00 2.75 0.26 3.01 100 select_key_return_key 156.00 55.88 6.59 62.47 200000 select_many_fields 6.00 4.74 1.24 5.98 2000 select_range 9.00 5.85 0.60 6.45 410 select_range_key2 5.00 4.33 0.55 4.88 25010 select_range_prefix 7.00 4.26 0.52 4.78 25010 select_simple 23.00 5.33 1.81 7.14 100000 select_simple_cache 14.00 4.61 1.73 6.34 100000 select_simple_join 1.00 0.36 0.02 0.38 500 update_big 18.00 0.00 0.00 0.00 10 update_of_key 27.00 3.62 1.20 4.82 50000 update_of_key_big 12.00 0.06 0.00 0.06 501 update_of_primary_key_many_keys 45.00 0.03 0.01 0.04 256 update_with_key 137.00 21.09 6.90 27.99 300000 update_with_key_prefix 42.00 12.13 2.77 14.90 100000 wisc_benchmark 2.00 1.53 0.12 1.65 114 TOTALS 2836.00 714.89 108.43 823.32 3425950 ####################### RPS-1 Benchmark DBD suite: 2.15 Date of test: 2008-07-24 3:09:50 Running tests on: Linux 2.6.24.5-grsec-xxxx-grs-ipv6-32 i686 Arguments: Comments: Limits from: Server version: MySQL 5.0.32 Debian_7etch6 log/ Optimization: None Hardware: alter-table: Total time: 71 wallclock secs ( 0.08 usr 0.01 sys + 0.00 cusr 0.00 csys = 0.09 CPU) ATIS: Total time: 11 wallclock secs ( 6.52 usr 0.99 sys + 0.00 cusr 0.00 csys = 7.51 CPU) big-tables: Total time: 13 wallclock secs ( 5.13 usr 1.61 sys + 0.00 cusr 0.00 csys = 6.74 CPU) connect: Total time: 194 wallclock secs (63.27 usr 16.45 sys + 0.00 cusr 0.00 csys = 79.72 CPU) create: Total time: 2328 wallclock secs ( 8.53 usr 1.70 sys + 0.00 cusr 0.00 csys = 10.23 CPU) insert: Total time: 1821 wallclock secs (559.70 usr 78.84 sys + 0.00 cusr 0.00 csys = 638.54 CPU) select: Total time: 132 wallclock secs (42.73 usr 5.81 sys + 0.00 cusr 0.00 csys = 48.54 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 12 wallclock secs ( 3.41 usr 0.84 sys + 0.00 cusr 0.00 csys = 4.25 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 31.00 0.02 0.00 0.02 100 alter_table_drop 30.00 0.02 0.01 0.03 91 connect 11.00 6.87 1.01 7.88 10000 connect+select_1_row 15.00 8.00 1.36 9.36 10000 connect+select_simple 14.00 8.23 1.23 9.46 10000 count 12.00 0.04 0.01 0.05 100 count_distinct 0.00 0.23 0.04 0.27 1000 count_distinct_2 1.00 0.25 0.01 0.26 1000 count_distinct_big 8.00 5.10 0.54 5.64 120 count_distinct_group 1.00 0.71 0.09 0.80 1000 count_distinct_group_on_key 0.00 0.25 0.02 0.27 1000 count_distinct_group_on_key_parts 1.00 0.73 0.08 0.81 1000 count_distinct_key_prefix 0.00 0.21 0.03 0.24 1000 count_group_on_key_parts 1.00 0.69 0.08 0.77 1000 count_on_key 27.00 9.87 1.45 11.32 50100 create+drop 739.00 2.43 0.45 2.88 10000 create_MANY_tables 815.00 1.79 0.33 2.12 10000 create_index 5.00 0.00 0.00 0.00 8 create_key+drop 738.00 2.52 0.39 2.91 10000 create_table 3.00 0.04 0.00 0.04 31 delete_all_many_keys 130.00 0.03 0.00 0.03 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 130.00 0.03 0.00 0.03 128 delete_key 3.00 0.53 0.17 0.70 10000 delete_range 6.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 drop_table_when_MANY_tables 3.00 0.62 0.21 0.83 10000 insert 96.00 19.34 7.10 26.44 350768 insert_duplicates 23.00 5.38 1.71 7.09 100000 insert_key 168.00 10.80 3.17 13.97 100000 insert_many_fields 7.00 0.38 0.06 0.44 2000 insert_select_1_key 2.00 0.00 0.00 0.00 1 insert_select_2_keys 4.00 0.00 0.00 0.00 1 min_max 3.00 0.02 0.00 0.02 60 min_max_on_key 28.00 16.63 2.30 18.93 85000 multiple_value_insert 2.00 0.30 0.00 0.30 100000 once_prepared_select 55.00 13.31 2.57 15.88 100000 order_by_big 25.00 14.37 1.82 16.19 10 order_by_big_key 21.00 14.79 1.95 16.74 10 order_by_big_key2 19.00 14.35 1.86 16.21 10 order_by_big_key_desc 22.00 14.81 1.93 16.74 10 order_by_big_key_diff 22.00 14.23 2.03 16.26 10 order_by_big_key_prefix 20.00 14.35 1.81 16.16 10 order_by_key2_diff 2.00 1.34 0.17 1.51 500 order_by_key_prefix 1.00 0.79 0.09 0.88 500 order_by_range 2.00 0.79 0.09 0.88 500 outer_join 2.00 0.01 0.00 0.01 10 outer_join_found 3.00 0.00 0.00 0.00 10 outer_join_not_found 2.00 0.00 0.00 0.00 500 outer_join_on_key 2.00 0.00 0.00 0.00 10 prepared_select 73.00 26.05 3.09 29.14 100000 select_1_row 34.00 6.89 2.23 9.12 100000 select_1_row_cache 8.00 3.62 1.38 5.00 100000 select_2_rows 37.00 7.51 2.36 9.87 100000 select_big 19.00 14.40 1.84 16.24 80 select_big_str 15.00 6.99 1.19 8.18 10000 select_cache 2.00 1.87 0.25 2.12 10000 select_cache2 70.00 3.22 0.38 3.60 10000 select_column+column 36.00 6.67 2.42 9.09 100000 select_diff_key 1.00 0.16 0.01 0.17 500 select_distinct 1.00 1.18 0.12 1.30 800 select_group 3.00 1.00 0.14 1.14 2911 select_group_when_MANY_tables 33.00 1.17 0.32 1.49 10000 select_join 0.00 0.30 0.06 0.36 100 select_key 131.00 55.95 6.21 62.16 200000 select_key2 140.00 56.44 6.23 62.67 200000 select_key2_return_key 135.00 54.63 6.04 60.67 200000 select_key2_return_prim 137.00 55.34 6.01 61.35 200000 select_key_prefix 140.00 56.57 6.57 63.14 200000 select_key_prefix_join 4.00 2.77 0.39 3.16 100 select_key_return_key 126.00 54.67 6.10 60.77 200000 select_many_fields 6.00 4.75 1.55 6.30 2000 select_range 10.00 5.78 0.70 6.48 410 select_range_key2 5.00 4.15 0.45 4.60 25010 select_range_prefix 7.00 4.15 0.43 4.58 25010 select_simple 12.00 4.29 1.58 5.87 100000 select_simple_cache 11.00 4.19 1.69 5.88 100000 select_simple_join 1.00 0.42 0.09 0.51 500 update_big 12.00 0.00 0.00 0.00 10 update_of_key 26.00 2.98 1.08 4.06 50000 update_of_key_big 14.00 0.03 0.02 0.05 501 update_of_primary_key_many_keys 46.00 0.02 0.02 0.04 256 update_with_key 105.00 17.33 5.87 23.20 300000 update_with_key_prefix 38.00 10.52 2.33 12.85 100000 wisc_benchmark 2.00 1.56 0.15 1.71 114 TOTALS 4700.00 682.78 105.47 788.25 3425950