############################################################################ ############### RPS ################## ############################################################################ Totals per operation: Operation seconds usr sys cpu tests --------------------------------------------------------------------------- alter_table_add 52.00 0.03 0.00 0.03 100 alter_table_drop 44.00 0.01 0.00 0.01 91 connect 12.00 6.88 1.01 7.89 10000 connect+select_1_row 15.00 7.94 1.23 9.17 10000 connect+select_simple 13.00 7.32 1.13 8.45 10000 count 9.00 0.04 0.00 0.04 100 count_distinct 0.00 0.17 0.03 0.20 1000 count_distinct_2 1.00 0.19 0.03 0.22 1000 count_distinct_big 8.00 5.90 0.04 5.94 120 count_distinct_group 1.00 0.81 0.02 0.83 1000 count_distinct_group_on_key 0.00 0.27 0.01 0.28 1000 count_distinct_group_on_key_parts 1.00 0.80 0.02 0.82 1000 count_distinct_key_prefix 0.00 0.21 0.02 0.23 1000 count_group_on_key_parts 1.00 0.79 0.01 0.80 1000 count_on_key 27.00 9.61 0.94 10.55 50100 create+drop 759.00 2.48 0.34 2.82 10000 create_MANY_tables 791.00 1.99 0.33 2.32 10000 create_index 7.00 0.00 0.00 0.00 8 create_key+drop 751.00 2.60 0.40 3.00 10000 create_table 3.00 0.01 0.00 0.01 31 delete_all_many_keys 143.00 0.01 0.00 0.01 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 143.00 0.01 0.00 0.01 128 delete_key 6.00 0.65 0.17 0.82 10000 delete_range 7.00 0.00 0.00 0.00 12 drop_index 7.00 0.00 0.00 0.00 8 drop_table 0.00 0.01 0.00 0.01 28 drop_table_when_MANY_tables 3.00 0.62 0.21 0.83 10000 insert 100.00 19.40 6.14 25.54 350768 insert_duplicates 24.00 5.52 1.65 7.17 100000 insert_key 275.00 10.78 2.74 13.52 100000 insert_many_fields 7.00 0.38 0.05 0.43 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.00 0.01 0.01 60 min_max_on_key 26.00 16.35 1.59 17.94 85000 multiple_value_insert 2.00 0.31 0.02 0.33 100000 once_prepared_select 55.00 12.67 2.01 14.68 100000 order_by_big 25.00 17.13 0.16 17.29 10 order_by_big_key 22.00 17.63 0.21 17.84 10 order_by_big_key2 21.00 17.10 0.14 17.24 10 order_by_big_key_desc 22.00 17.76 0.18 17.94 10 order_by_big_key_diff 23.00 17.05 0.18 17.23 10 order_by_big_key_prefix 21.00 17.13 0.10 17.23 10 order_by_key2_diff 2.00 1.61 0.02 1.63 500 order_by_key_prefix 2.00 0.83 0.03 0.86 500 order_by_range 2.00 0.84 0.02 0.86 500 outer_join 2.00 0.00 0.00 0.00 10 outer_join_found 2.00 0.00 0.00 0.00 10 outer_join_not_found 2.00 0.01 0.00 0.01 500 outer_join_on_key 2.00 0.01 0.00 0.01 10 prepared_select 71.00 25.30 2.34 27.64 100000 select_1_row 32.00 7.26 1.71 8.97 100000 select_1_row_cache 7.00 3.22 1.05 4.27 100000 select_2_rows 36.00 7.59 1.81 9.40 100000 select_big 21.00 17.13 0.10 17.23 80 select_big_str 15.00 7.05 1.05 8.10 10000 select_cache 3.00 2.00 0.18 2.18 10000 select_cache2 68.00 2.81 0.30 3.11 10000 select_column+column 36.00 6.84 1.71 8.55 100000 select_diff_key 1.00 0.17 0.01 0.18 500 select_distinct 1.00 1.30 0.04 1.34 800 select_group 4.00 1.05 0.08 1.13 2911 select_group_when_MANY_tables 32.00 1.07 0.24 1.31 10000 select_join 0.00 0.38 0.02 0.40 100 select_key 126.00 54.08 4.84 58.92 200000 select_key2 137.00 55.56 4.87 60.43 200000 select_key2_return_key 131.00 53.38 4.74 58.12 200000 select_key2_return_prim 135.00 54.28 5.20 59.48 200000 select_key_prefix 136.00 54.81 4.78 59.59 200000 select_key_prefix_join 4.00 3.31 0.02 3.33 100 select_key_return_key 122.00 52.69 4.72 57.41 200000 select_many_fields 6.00 4.74 0.33 5.07 2000 select_range 11.00 6.84 0.05 6.89 410 select_range_key2 5.00 3.99 0.32 4.31 25010 select_range_prefix 5.00 4.06 0.26 4.32 25010 select_simple 11.00 3.85 1.25 5.10 100000 select_simple_cache 11.00 3.89 1.26 5.15 100000 select_simple_join 2.00 0.47 0.01 0.48 500 update_big 13.00 0.00 0.00 0.00 10 update_of_key 51.00 3.36 0.89 4.25 50000 update_of_key_big 14.00 0.06 0.01 0.07 501 update_of_primary_key_many_keys 67.00 0.01 0.01 0.02 256 update_with_key 113.00 17.45 5.48 22.93 300000 update_with_key_prefix 40.00 11.17 2.26 13.43 100000 wisc_benchmark 2.00 1.69 0.15 1.84 114 TOTALS 4919.00 694.72 73.28 768.00 3425950 ############################################################################ ############### KIMSUFI ################## ############################################################################ Totals per operation: Operation seconds usr sys cpu tests --------------------------------------------------------------------------- alter_table_add 9.00 0.03 0.01 0.04 100 alter_table_drop 10.00 0.02 0.00 0.02 91 connect 15.00 9.59 1.39 10.98 10000 connect+select_1_row 20.00 10.50 1.78 12.28 10000 connect+select_simple 18.00 10.23 1.62 11.85 10000 count 9.00 0.03 0.02 0.05 100 count_distinct 1.00 0.33 0.02 0.35 1000 count_distinct_2 0.00 0.32 0.02 0.34 1000 count_distinct_big 10.00 8.01 0.11 8.12 120 count_distinct_group 1.00 1.13 0.02 1.15 1000 count_distinct_group_on_key 1.00 0.38 0.03 0.41 1000 count_distinct_group_on_key_parts 1.00 1.13 0.03 1.16 1000 count_distinct_key_prefix 0.00 0.32 0.03 0.35 1000 count_group_on_key_parts 1.00 1.10 0.03 1.13 1000 count_on_key 33.00 13.76 1.42 15.18 50100 create+drop 35.00 3.04 0.55 3.59 10000 create_MANY_tables 84.00 2.00 0.28 2.28 10000 create_index 2.00 0.00 0.00 0.00 8 create_key+drop 34.00 2.93 0.57 3.50 10000 create_table 0.00 0.02 0.00 0.02 31 delete_all_many_keys 83.00 0.01 0.01 0.02 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 83.00 0.01 0.01 0.02 128 delete_key 4.00 1.05 0.22 1.27 10000 delete_range 7.00 0.01 0.00 0.01 12 drop_index 2.00 0.01 0.00 0.01 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 13.00 1.03 0.27 1.30 10000 insert 143.00 30.77 8.69 39.46 350768 insert_duplicates 36.00 9.16 2.20 11.36 100000 insert_key 154.00 13.32 3.07 16.39 100000 insert_many_fields 5.00 0.40 0.07 0.47 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 4.00 0.01 0.00 0.01 60 min_max_on_key 37.00 25.19 2.13 27.32 85000 multiple_value_insert 2.00 0.29 0.02 0.31 100000 once_prepared_select 73.00 17.42 3.00 20.42 100000 order_by_big 32.00 23.07 0.17 23.24 10 order_by_big_key 29.00 23.85 0.28 24.13 10 order_by_big_key2 26.00 23.01 0.17 23.18 10 order_by_big_key_desc 28.00 23.70 0.30 24.00 10 order_by_big_key_diff 29.00 22.99 0.16 23.15 10 order_by_big_key_prefix 28.00 23.21 0.21 23.42 10 order_by_key2_diff 3.00 2.11 0.01 2.12 500 order_by_key_prefix 2.00 1.07 0.03 1.10 500 order_by_range 2.00 1.23 0.03 1.26 500 outer_join 2.00 0.00 0.00 0.00 10 outer_join_found 2.00 0.00 0.00 0.00 10 outer_join_not_found 2.00 0.01 0.00 0.01 500 outer_join_on_key 2.00 0.00 0.00 0.00 10 prepared_select 91.00 31.69 3.41 35.10 100000 select_1_row 47.00 9.63 2.55 12.18 100000 select_1_row_cache 10.00 5.39 1.48 6.87 100000 select_2_rows 52.00 10.69 2.67 13.36 100000 select_big 27.00 23.20 0.20 23.40 80 select_big_str 18.00 8.11 1.69 9.80 10000 select_cache 4.00 2.71 0.27 2.98 10000 select_cache2 66.00 3.68 0.42 4.10 10000 select_column+column 52.00 10.19 2.74 12.93 100000 select_diff_key 0.00 0.20 0.02 0.22 500 select_distinct 2.00 1.76 0.04 1.80 800 select_group 4.00 1.46 0.08 1.54 2911 select_group_when_MANY_tables 30.00 1.06 0.29 1.35 10000 select_join 1.00 0.51 0.01 0.52 100 select_key 162.00 69.27 7.11 76.38 200000 select_key2 173.00 70.10 7.18 77.28 200000 select_key2_return_key 168.00 67.91 7.08 74.99 200000 select_key2_return_prim 171.00 68.34 7.14 75.48 200000 select_key_prefix 173.00 70.19 7.36 77.55 200000 select_key_prefix_join 4.00 4.44 0.02 4.46 100 select_key_return_key 159.00 74.35 7.26 81.61 200000 select_many_fields 6.00 4.25 0.61 4.86 2000 select_range 13.00 8.97 0.12 9.09 410 select_range_key2 6.00 5.56 0.41 5.97 25010 select_range_prefix 9.00 5.56 0.41 5.97 25010 select_simple 19.00 7.48 2.14 9.62 100000 select_simple_cache 19.00 6.90 2.02 8.92 100000 select_simple_join 1.00 0.65 0.02 0.67 500 update_big 10.00 0.00 0.00 0.00 10 update_of_key 33.00 4.89 1.40 6.29 50000 update_of_key_big 17.00 0.04 0.01 0.05 501 update_of_primary_key_many_keys 31.00 0.02 0.00 0.02 256 update_with_key 145.00 25.36 8.17 33.53 300000 update_with_key_prefix 54.00 15.79 3.48 19.27 100000 wisc_benchmark 2.00 1.94 0.08 2.02 114 TOTALS 2902.00 930.09 106.87 1036.96 3425950 ############################################################################ ############### START 100M ################## ############################################################################ Totals per operation: Operation seconds usr sys cpu tests --------------------------------------------------------------------------- alter_table_add 11.00 0.03 0.00 0.03 100 alter_table_drop 11.00 0.02 0.01 0.03 91 connect 5.00 3.87 0.56 4.43 10000 connect+select_1_row 8.00 4.41 0.80 5.21 10000 connect+select_simple 7.00 3.90 0.66 4.56 10000 count 10.00 0.04 0.00 0.04 100 count_distinct 0.00 0.14 0.00 0.14 1000 count_distinct_2 0.00 0.12 0.02 0.14 1000 count_distinct_big 4.00 3.74 0.02 3.76 120 count_distinct_group 1.00 0.49 0.02 0.51 1000 count_distinct_group_on_key 0.00 0.13 0.01 0.14 1000 count_distinct_group_on_key_parts 1.00 0.48 0.04 0.52 1000 count_distinct_key_prefix 0.00 0.13 0.01 0.14 1000 count_group_on_key_parts 1.00 0.49 0.01 0.50 1000 count_on_key 18.00 5.59 0.60 6.19 50100 create+drop 23.00 1.25 0.28 1.53 10000 create_MANY_tables 74.00 1.37 0.31 1.68 10000 create_index 2.00 0.00 0.00 0.00 8 create_key+drop 31.00 1.25 0.29 1.54 10000 create_table 0.00 0.00 0.00 0.00 31 delete_all_many_keys 134.00 0.01 0.00 0.01 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 134.00 0.01 0.00 0.01 128 delete_key 2.00 0.24 0.09 0.33 10000 delete_range 6.00 0.00 0.00 0.00 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 2.00 0.22 0.13 0.35 10000 insert 43.00 8.43 3.62 12.05 350768 insert_duplicates 15.00 3.01 1.26 4.27 100000 insert_key 181.00 5.54 1.08 6.62 100000 insert_many_fields 4.00 0.22 0.06 0.28 2000 insert_select_1_key 2.00 0.00 0.00 0.00 1 insert_select_2_keys 2.00 0.00 0.00 0.00 1 min_max 3.00 0.01 0.01 0.02 60 min_max_on_key 15.00 11.13 1.06 12.19 85000 multiple_value_insert 4.00 0.43 0.00 0.43 100000 once_prepared_select 29.00 8.78 1.21 9.99 100000 order_by_big 15.00 10.72 0.18 10.90 10 order_by_big_key 13.00 11.08 0.25 11.33 10 order_by_big_key2 12.00 10.79 0.13 10.92 10 order_by_big_key_desc 14.00 11.14 0.21 11.35 10 order_by_big_key_diff 14.00 10.90 0.13 11.03 10 order_by_big_key_prefix 17.00 13.56 0.18 13.74 10 order_by_key2_diff 2.00 0.92 0.01 0.93 500 order_by_key_prefix 1.00 0.54 0.00 0.54 500 order_by_range 1.00 0.54 0.02 0.56 500 outer_join 2.00 0.00 0.00 0.00 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 40.00 16.12 1.43 17.55 100000 select_1_row 16.00 3.16 1.29 4.45 100000 select_1_row_cache 5.00 2.42 1.22 3.64 100000 select_2_rows 27.00 4.42 1.26 5.68 100000 select_big 14.00 10.67 0.11 10.78 80 select_big_str 9.00 3.57 1.07 4.64 10000 select_cache 2.00 1.31 0.17 1.48 10000 select_cache2 56.00 1.93 0.20 2.13 10000 select_column+column 16.00 3.48 1.19 4.67 100000 select_diff_key 0.00 0.08 0.02 0.10 500 select_distinct 1.00 0.84 0.02 0.86 800 select_group 3.00 0.64 0.02 0.66 2911 select_group_when_MANY_tables 23.00 1.02 0.28 1.30 10000 select_join 0.00 0.24 0.01 0.25 100 select_key 65.00 31.48 3.07 34.55 200000 select_key2 70.00 34.09 3.10 37.19 200000 select_key2_return_key 66.00 31.63 2.94 34.57 200000 select_key2_return_prim 69.00 32.25 3.06 35.31 200000 select_key_prefix 73.00 34.59 2.99 37.58 200000 select_key_prefix_join 2.00 2.02 0.01 2.03 100 select_key_return_key 63.00 31.50 3.04 34.54 200000 select_many_fields 3.00 2.85 0.23 3.08 2000 select_range 7.00 5.53 0.09 5.62 410 select_range_key2 2.00 2.43 0.15 2.58 25010 select_range_prefix 4.00 2.49 0.18 2.67 25010 select_simple 9.00 2.85 1.17 4.02 100000 select_simple_cache 7.00 2.71 1.09 3.80 100000 select_simple_join 1.00 0.30 0.00 0.30 500 update_big 15.00 0.00 0.00 0.00 10 update_of_key 21.00 1.38 0.61 1.99 50000 update_of_key_big 12.00 0.01 0.01 0.02 501 update_of_primary_key_many_keys 62.00 0.01 0.01 0.02 256 update_with_key 50.00 7.44 3.63 11.07 300000 update_with_key_prefix 15.00 4.73 1.47 6.20 100000 wisc_benchmark 1.00 1.27 0.06 1.33 114 TOTALS 1711.00 417.13 48.47 465.60 3425950