======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 591 RUN DATE: 2010-10-25T15:37:58.177014 SERVER: drizzled VERSION: staging REVISION: 1879 COMMENT: 1879: Brian Aker 2010-10-25 Stick to static cast.
========================================================================================================================= TRENDING OVER LAST 5 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 32.00 -20.00% -5.33 14.00 34.00 26.67 8.99 innodb alter_table_drop 21.00 -8.62% -1.67 14.00 23.00 19.33 3.86 innodb connect 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb connect+select_1_row 2.00 +25.00% 0.67 2.00 3.00 2.67 0.47 innodb connect+select_simple 3.00 -28.57% -0.67 2.00 3.00 2.33 0.47 innodb count 17.00 -6.25% -1.00 14.00 17.00 16.00 1.41 innodb count_distinct 7.00 -0.00% 0.00 7.00 7.00 7.00 0.00 innodb count_distinct_2 15.00 +2.17% 0.33 15.00 16.00 15.33 0.47 innodb count_distinct_big 23.00 -2.99% -0.67 21.00 23.00 22.33 0.94 innodb count_distinct_group 13.00 +9.30% 1.33 13.00 15.00 14.33 0.94 innodb count_distinct_group_on_key 11.00 -0.00% 0.00 11.00 11.00 11.00 0.00 innodb count_distinct_group_on_key_parts 13.00 -0.00% 0.00 13.00 13.00 13.00 0.00 innodb count_distinct_key_prefix 6.00 +5.26% 0.33 6.00 7.00 6.33 0.47 innodb count_group_on_key_parts 10.00 -3.45% -0.33 9.00 10.00 9.67 0.47 innodb count_on_key 87.00 +4.04% 3.67 87.00 93.00 90.67 2.62 innodb create+drop 40.00 +9.77% 4.33 28.00 65.00 44.33 15.41 innodb create_index 3.00 +25.00% 1.00 3.00 5.00 4.00 0.82 innodb create_key+drop 28.00 +15.15% 5.00 27.00 44.00 33.00 7.79 innodb create_MANY_tables 62.00 +5.10% 3.33 31.00 103.00 65.33 29.49 innodb create_table 0.00 NULL 0.00 0.00 0.00 0.00 0.00 innodb delete_all_many_keys 334.00 +62.58% 558.67 299.00 2045.00 892.67 814.95 innodb delete_autocommit 3.00 +25.00% 1.00 3.00 6.00 4.00 1.41 innodb delete_big 0.00 NULL 0.00 0.00 0.00 0.00 0.00 innodb delete_big_many_keys 334.00 +62.58% 558.67 299.00 2045.00 892.67 814.95 innodb delete_commit 2.00 -20.00% -0.33 1.00 2.00 1.67 0.47 innodb delete_key 4.00 +20.00% 1.00 3.00 8.00 5.00 2.16 innodb delete_range 6.00 +10.00% 0.67 6.00 8.00 6.67 0.94 innodb delete_rollback 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb drop_index 3.00 -0.00% 0.00 2.00 4.00 3.00 0.82 innodb drop_table 0.00 +100.00% 0.33 0.00 1.00 0.33 0.47 innodb drop_table_when_MANY_tables 22.00 +9.59% 2.33 15.00 36.00 24.33 8.73 innodb insert 102.00 +12.57% 14.67 101.00 147.00 116.67 21.45 innodb insert_autocommit 3.00 -12.50% -0.33 2.00 3.00 2.67 0.47 innodb insert_commit 1.00 +40.00% 0.67 1.00 2.00 1.67 0.47 innodb insert_duplicates 14.00 +4.55% 0.67 14.00 16.00 14.67 0.94 innodb insert_key 267.00 +43.35% 204.33 230.00 917.00 471.33 315.50 innodb insert_many_fields 7.00 -0.00% 0.00 5.00 9.00 7.00 1.63 innodb insert_rollback 1.00 +25.00% 0.33 1.00 2.00 1.33 0.47 innodb insert_select_1_key 4.00 -0.00% 0.00 3.00 5.00 4.00 0.82 innodb insert_select_2_keys 6.00 +14.29% 1.00 4.00 11.00 7.00 2.94 innodb min_max 8.00 -4.35% -0.33 7.00 8.00 7.67 0.47 innodb min_max_on_key 19.00 -1.79% -0.33 18.00 19.00 18.67 0.47 innodb multiple_value_insert 4.00 +53.85% 4.67 4.00 18.00 8.67 6.60 innodb once_prepared_select 22.00 +5.71% 1.33 22.00 24.00 23.33 0.94 innodb order_by_big 16.00 -14.29% -2.00 13.00 16.00 14.00 1.41 innodb order_by_big_key 14.00 -13.51% -1.67 11.00 14.00 12.33 1.25 innodb order_by_big_key2 13.00 -11.43% -1.33 11.00 13.00 11.67 0.94 innodb order_by_big_key_desc 15.00 -12.50% -1.67 12.00 15.00 13.33 1.25 innodb order_by_big_key_diff 13.00 -11.43% -1.33 11.00 13.00 11.67 0.94 innodb order_by_big_key_prefix 13.00 -8.33% -1.00 11.00 13.00 12.00 0.82 innodb order_by_key2_diff 2.00 -20.00% -0.33 1.00 2.00 1.67 0.47 innodb order_by_key_prefix 0.00 +100.00% 0.67 0.00 1.00 0.67 0.47 innodb order_by_range 1.00 -50.00% -0.33 0.00 1.00 0.67 0.47 innodb outer_join 16.00 +12.73% 2.33 16.00 23.00 18.33 3.30 innodb outer_join_found 16.00 +11.11% 2.00 16.00 22.00 18.00 2.83 innodb outer_join_not_found 13.00 +13.33% 2.00 13.00 19.00 15.00 2.83 innodb outer_join_on_key 11.00 +8.33% 1.00 11.00 14.00 12.00 1.41 innodb prepared_select 33.00 -1.02% -0.33 32.00 33.00 32.67 0.47 innodb select_1_row 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb select_1_row_cache 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb select_2_rows 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb select_big 13.00 -11.43% -1.33 11.00 13.00 11.67 0.94 innodb select_big_str 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb select_cache 66.00 -2.06% -1.33 59.00 69.00 64.67 4.19 innodb select_cache2 65.00 +2.50% 1.67 65.00 70.00 66.67 2.36 innodb select_column+column 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb select_diff_key 0.00 NULL 0.00 0.00 0.00 0.00 0.00 innodb select_distinct 4.00 -0.00% 0.00 4.00 4.00 4.00 0.00 innodb select_group 15.00 +6.25% 1.00 15.00 18.00 16.00 1.41 innodb select_group_when_MANY_tables 4.00 +14.29% 0.67 4.00 6.00 4.67 0.94 innodb select_join 1.00 -200.00% -0.67 0.00 1.00 0.33 0.47 innodb select_key 47.00 +5.37% 2.67 47.00 52.00 49.67 2.05 innodb select_key2 63.00 -3.85% -2.33 59.00 63.00 60.67 1.70 innodb select_key2_return_key 60.00 -1.12% -0.67 59.00 60.00 59.33 0.47 innodb select_key2_return_prim 61.00 -1.67% -1.00 59.00 61.00 60.00 0.82 innodb select_key_prefix 60.00 +2.17% 1.33 60.00 62.00 61.33 0.94 innodb select_key_prefix_join 4.00 +14.29% 0.67 4.00 5.00 4.67 0.47 innodb select_key_return_key 47.00 +5.37% 2.67 47.00 53.00 49.67 2.49 innodb select_many_fields 12.00 +7.69% 1.00 12.00 14.00 13.00 0.82 innodb select_range 53.00 -7.43% -3.67 44.00 53.00 49.33 3.86 innodb select_range_key2 9.00 -3.85% -0.33 8.00 9.00 8.67 0.47 innodb select_range_prefix 8.00 +4.00% 0.33 8.00 9.00 8.33 0.47 innodb select_simple 1.00 +40.00% 0.67 1.00 2.00 1.67 0.47 innodb select_simple_cache 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb select_simple_join 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb TOTALS 3493.00 +37.20% 2069.00 3193.00 9999.99 5562.00 3140.52 innodb update_autocommit 3.00 +10.00% 0.33 3.00 4.00 3.33 0.47 innodb update_big 59.00 -18.00% -9.00 33.00 59.00 50.00 12.03 innodb update_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_of_key 25.00 +31.19% 11.33 25.00 57.00 36.33 14.64 innodb update_of_key_big 28.00 +2.33% 0.67 17.00 41.00 28.67 9.81 innodb update_of_primary_key_many_keys 889.00 +62.89% 1506.33 810.00 5487.00 2395.33 2186.38 innodb update_rollback 2.00 +14.29% 0.33 2.00 3.00 2.33 0.47 innodb update_with_key 101.00 +12.43% 14.33 101.00 143.00 115.33 19.57 innodb update_with_key_prefix 37.00 +11.90% 5.00 37.00 52.00 42.00 7.07 innodb wisc_benchmark 2.00 +25.00% 0.67 2.00 3.00 2.67 0.47 ========================================================================================================================= TRENDING OVER LAST 20 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 32.00 -74.79% -13.69 12.00 34.00 18.31 7.15 innodb alter_table_drop 21.00 -31.88% -5.08 11.00 23.00 15.92 3.20 innodb connect 2.00 +10.34% 0.23 2.00 3.00 2.23 0.42 innodb connect+select_1_row 2.00 +29.73% 0.85 2.00 3.00 2.85 0.36 innodb connect+select_simple 3.00 -21.88% -0.54 2.00 3.00 2.46 0.50 innodb count 17.00 -13.92% -2.08 13.00 18.00 14.92 1.90 innodb count_distinct 7.00 -12.35% -0.77 5.00 7.00 6.23 0.70 innodb count_distinct_2 15.00 -15.38% -2.00 11.00 16.00 13.00 1.84 innodb count_distinct_big 23.00 -7.55% -1.62 19.00 24.00 21.38 1.69 innodb count_distinct_group 13.00 -1.20% -0.15 11.00 15.00 12.85 1.46 innodb count_distinct_group_on_key 11.00 -21.19% -1.92 8.00 11.00 9.08 1.33 innodb count_distinct_group_on_key_parts 13.00 -11.18% -1.31 10.00 14.00 11.69 1.32 innodb count_distinct_key_prefix 6.00 -20.00% -1.00 4.00 7.00 5.00 0.96 innodb count_group_on_key_parts 10.00 +0.76% 0.08 9.00 12.00 10.08 0.83 innodb count_on_key 87.00 +1.82% 1.62 82.00 95.00 88.62 3.65 innodb create+drop 40.00 -12.31% -4.38 26.00 65.00 35.62 9.74 innodb create_index 3.00 -21.88% -0.54 1.00 5.00 2.46 1.15 innodb create_key+drop 28.00 +3.70% 1.08 27.00 44.00 29.08 4.38 innodb create_MANY_tables 62.00 -47.35% -19.92 21.00 103.00 42.08 21.16 innodb create_table 0.00 NULL 0.00 0.00 0.00 0.00 0.00 innodb delete_all_many_keys 334.00 +24.47% 108.23 299.00 2045.00 442.23 462.80 innodb delete_autocommit 3.00 +9.30% 0.31 3.00 6.00 3.31 0.82 innodb delete_big 0.00 +100.00% 0.08 0.00 1.00 0.08 0.27 innodb delete_big_many_keys 334.00 +24.47% 108.23 299.00 2045.00 442.23 462.80 innodb delete_commit 2.00 -30.00% -0.46 1.00 2.00 1.54 0.50 innodb delete_key 4.00 -18.18% -0.62 2.00 8.00 3.38 1.39 innodb delete_range 6.00 +3.70% 0.23 5.00 8.00 6.23 0.70 innodb delete_rollback 1.00 +35.00% 0.54 1.00 2.00 1.54 0.50 innodb drop_index 3.00 -21.88% -0.54 2.00 4.00 2.46 0.63 innodb drop_table 0.00 +100.00% 0.15 0.00 1.00 0.15 0.36 innodb drop_table_when_MANY_tables 22.00 -25.99% -4.54 12.00 36.00 17.46 5.90 innodb insert 102.00 +6.95% 7.62 100.00 147.00 109.62 11.55 innodb insert_autocommit 3.00 -5.41% -0.15 2.00 3.00 2.85 0.36 innodb insert_commit 1.00 +18.75% 0.23 1.00 2.00 1.23 0.42 innodb insert_duplicates 14.00 +2.67% 0.38 13.00 16.00 14.38 0.74 innodb insert_key 267.00 +0.49% 1.31 159.00 917.00 268.31 189.76 innodb insert_many_fields 7.00 -21.33% -1.23 4.00 9.00 5.77 1.37 innodb insert_rollback 1.00 +35.00% 0.54 1.00 2.00 1.54 0.50 innodb insert_select_1_key 4.00 -13.04% -0.46 3.00 5.00 3.54 0.75 innodb insert_select_2_keys 6.00 -20.00% -1.00 4.00 11.00 5.00 1.84 innodb min_max 8.00 -5.05% -0.38 6.00 9.00 7.62 1.00 innodb min_max_on_key 19.00 +0.40% 0.08 18.00 21.00 19.08 0.83 innodb multiple_value_insert 4.00 +11.86% 0.54 3.00 18.00 4.54 3.91 innodb once_prepared_select 22.00 +8.33% 2.00 22.00 25.00 24.00 0.68 innodb order_by_big 16.00 -11.83% -1.69 13.00 16.00 14.31 1.26 innodb order_by_big_key 14.00 -8.33% -1.08 11.00 15.00 12.92 1.21 innodb order_by_big_key2 13.00 -9.03% -1.08 11.00 13.00 11.92 1.00 innodb order_by_big_key_desc 15.00 -13.37% -1.77 12.00 15.00 13.23 1.25 innodb order_by_big_key_diff 13.00 -8.33% -1.00 11.00 13.00 12.00 0.96 innodb order_by_big_key_prefix 13.00 -4.97% -0.62 11.00 14.00 12.38 1.08 innodb order_by_key2_diff 2.00 -30.00% -0.46 1.00 2.00 1.54 0.50 innodb order_by_key_prefix 0.00 +100.00% 0.92 0.00 1.00 0.92 0.27 innodb order_by_range 1.00 -44.44% -0.31 0.00 1.00 0.69 0.46 innodb outer_join 16.00 +16.47% 3.15 16.00 23.00 19.15 2.63 innodb outer_join_found 16.00 +14.05% 2.62 16.00 22.00 18.62 2.37 innodb outer_join_not_found 13.00 +18.75% 3.00 13.00 19.00 16.00 2.15 innodb outer_join_on_key 11.00 +14.37% 1.85 11.00 15.00 12.85 1.56 innodb prepared_select 33.00 -3.37% -1.08 30.00 34.00 31.92 1.27 innodb select_1_row 3.00 -8.33% -0.23 2.00 3.00 2.77 0.42 innodb select_1_row_cache 2.00 +16.13% 0.38 2.00 3.00 2.38 0.49 innodb select_2_rows 3.00 -8.33% -0.23 2.00 3.00 2.77 0.42 innodb select_big 13.00 -9.03% -1.08 11.00 13.00 11.92 0.83 innodb select_big_str 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb select_cache 66.00 -10.71% -6.38 52.00 69.00 59.62 5.75 innodb select_cache2 65.00 -3.30% -2.08 52.00 70.00 62.92 5.18 innodb select_column+column 3.00 -2.63% -0.08 2.00 3.00 2.92 0.27 innodb select_diff_key 0.00 +100.00% 0.08 0.00 1.00 0.08 0.27 innodb select_distinct 4.00 +1.89% 0.08 4.00 5.00 4.08 0.27 innodb select_group 15.00 +3.94% 0.62 14.00 18.00 15.62 1.21 innodb select_group_when_MANY_tables 4.00 +17.46% 0.85 4.00 6.00 4.85 0.86 innodb select_join 1.00 -44.44% -0.31 0.00 1.00 0.69 0.46 innodb select_key 47.00 +4.98% 2.46 46.00 55.00 49.46 2.53 innodb select_key2 63.00 -2.76% -1.69 59.00 63.00 61.31 1.26 innodb select_key2_return_key 60.00 -2.23% -1.31 56.00 60.00 58.69 1.07 innodb select_key2_return_prim 61.00 -1.02% -0.62 59.00 61.00 60.38 0.74 innodb select_key_prefix 60.00 +2.38% 1.46 59.00 63.00 61.46 1.39 innodb select_key_prefix_join 4.00 +11.86% 0.54 4.00 5.00 4.54 0.50 innodb select_key_return_key 47.00 +4.08% 2.00 45.00 54.00 49.00 2.63 innodb select_many_fields 12.00 +7.69% 1.00 12.00 15.00 13.00 0.78 innodb select_range 53.00 -11.13% -5.31 43.00 53.00 47.69 3.69 innodb select_range_key2 9.00 -4.46% -0.38 8.00 9.00 8.62 0.49 innodb select_range_prefix 8.00 +0.95% 0.08 7.00 9.00 8.08 0.62 innodb select_simple 1.00 +35.00% 0.54 1.00 2.00 1.54 0.50 innodb select_simple_cache 1.00 +27.78% 0.38 1.00 2.00 1.38 0.49 innodb select_simple_join 1.00 -62.50% -0.38 0.00 1.00 0.62 0.49 innodb TOTALS 3493.00 +6.85% 257.00 3091.00 9999.99 3750.00 1806.99 innodb update_autocommit 3.00 +7.14% 0.23 3.00 4.00 3.23 0.42 innodb update_big 59.00 -46.37% -18.69 33.00 59.00 40.31 7.99 innodb update_commit 2.00 -36.84% -0.54 1.00 2.00 1.46 0.50 innodb update_of_key 25.00 +6.88% 1.85 20.00 57.00 26.85 9.02 innodb update_of_key_big 28.00 -31.88% -6.77 15.00 41.00 21.23 6.51 innodb update_of_primary_key_many_keys 889.00 +25.37% 302.23 803.00 5487.00 1191.23 1240.41 innodb update_rollback 2.00 -13.04% -0.23 1.00 3.00 1.77 0.58 innodb update_with_key 101.00 +4.09% 4.31 100.00 143.00 105.31 11.03 innodb update_with_key_prefix 37.00 +1.64% 0.62 36.00 52.00 37.62 4.18 innodb wisc_benchmark 2.00 +16.13% 0.38 2.00 3.00 2.38 0.49 ========================================================================================================================= TRENDING OVER ALL runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 32.00 -162.89% -19.83 11.00 14.00 12.17 0.87 innodb alter_table_drop 21.00 -83.99% -9.59 10.00 14.00 11.41 1.07 innodb connect 2.00 -18.37% -0.31 1.00 2.00 1.69 0.46 innodb connect+select_1_row 2.00 +14.71% 0.34 2.00 3.00 2.34 0.48 innodb connect+select_simple 3.00 -52.63% -1.03 1.00 2.00 1.97 0.18 innodb count 17.00 -13.33% -2.00 13.00 18.00 15.00 1.76 innodb count_distinct 7.00 -15.34% -0.93 5.00 8.00 6.07 0.83 innodb count_distinct_2 15.00 -23.58% -2.86 11.00 16.00 12.14 1.38 innodb count_distinct_big 23.00 -7.75% -1.66 18.00 25.00 21.34 1.97 innodb count_distinct_group 13.00 -2.72% -0.34 11.00 14.00 12.66 0.84 innodb count_distinct_group_on_key 11.00 -23.64% -2.10 8.00 11.00 8.90 1.12 innodb count_distinct_group_on_key_parts 13.00 -10.56% -1.24 10.00 15.00 11.76 1.36 innodb count_distinct_key_prefix 6.00 -27.01% -1.28 4.00 6.00 4.72 0.69 innodb count_group_on_key_parts 10.00 -22.88% -1.86 7.00 10.00 8.14 0.78 innodb count_on_key 87.00 -12.63% -9.76 73.00 83.00 77.24 2.25 innodb create+drop 40.00 -104.95% -20.48 19.00 21.00 19.52 0.56 innodb create_index 3.00 -58.18% -1.10 1.00 3.00 1.90 0.48 innodb create_key+drop 28.00 -24.16% -5.45 21.00 23.00 22.55 0.56 innodb create_MANY_tables 62.00 -263.23% -44.93 14.00 20.00 17.07 1.70 innodb create_table 0.00 +100.00% 0.07 0.00 1.00 0.07 0.25 innodb delete_all_many_keys 334.00 -12.37% -36.76 239.00 345.00 297.24 21.38 innodb delete_autocommit 3.00 -6.10% -0.17 2.00 3.00 2.83 0.38 innodb delete_big 0.00 +100.00% 0.28 0.00 1.00 0.28 0.45 innodb delete_big_many_keys 334.00 -12.41% -36.86 239.00 345.00 297.14 21.37 innodb delete_commit 2.00 -48.72% -0.66 1.00 2.00 1.34 0.48 innodb delete_key 4.00 -63.38% -1.55 2.00 3.00 2.45 0.50 innodb delete_range 6.00 +13.86% 0.97 6.00 8.00 6.97 0.56 innodb delete_rollback 1.00 +23.68% 0.31 1.00 2.00 1.31 0.46 innodb drop_index 3.00 -52.63% -1.03 1.00 3.00 1.97 0.32 innodb drop_table 0.00 NULL 0.00 0.00 0.00 0.00 0.00 innodb drop_table_when_MANY_tables 22.00 -63.17% -8.52 12.00 15.00 13.48 0.62 innodb insert 102.00 -12.47% -11.31 88.00 93.00 90.69 1.37 innodb insert_autocommit 3.00 -16.00% -0.41 2.00 3.00 2.59 0.49 innodb insert_commit 1.00 +9.37% 0.10 1.00 2.00 1.10 0.30 innodb insert_duplicates 14.00 -9.14% -1.17 12.00 14.00 12.83 0.53 innodb insert_key 267.00 +7.17% 20.62 189.00 345.00 287.62 32.94 innodb insert_many_fields 7.00 -72.03% -2.93 3.00 5.00 4.07 0.36 innodb insert_rollback 1.00 +29.27% 0.41 1.00 2.00 1.41 0.49 innodb insert_select_1_key 4.00 -17.17% -0.59 3.00 4.00 3.41 0.49 innodb insert_select_2_keys 6.00 -16.00% -0.83 4.00 6.00 5.17 0.59 innodb min_max 8.00 -4.50% -0.34 6.00 9.00 7.66 1.03 innodb min_max_on_key 19.00 -12.68% -2.14 14.00 20.00 16.86 1.28 innodb multiple_value_insert 4.00 +11.45% 0.52 3.00 5.00 4.52 0.56 innodb once_prepared_select 22.00 -4.93% -1.03 20.00 22.00 20.97 0.61 innodb order_by_big 16.00 -13.17% -1.86 12.00 15.00 14.14 0.94 innodb order_by_big_key 14.00 -12.78% -1.59 11.00 14.00 12.41 1.19 innodb order_by_big_key2 13.00 -13.21% -1.52 10.00 13.00 11.48 0.97 innodb order_by_big_key_desc 15.00 -16.31% -2.10 12.00 14.00 12.90 0.92 innodb order_by_big_key_diff 13.00 -12.20% -1.41 10.00 13.00 11.59 0.85 innodb order_by_big_key_prefix 13.00 -8.65% -1.03 11.00 13.00 11.97 0.85 innodb order_by_key2_diff 2.00 -70.59% -0.83 1.00 2.00 1.17 0.38 innodb order_by_key_prefix 0.00 +100.00% 0.62 0.00 1.00 0.62 0.49 innodb order_by_range 1.00 -38.10% -0.28 0.00 1.00 0.72 0.45 innodb outer_join 16.00 +7.75% 1.34 15.00 21.00 17.34 2.06 innodb outer_join_found 16.00 +5.11% 0.86 14.00 21.00 16.86 2.19 innodb outer_join_not_found 13.00 +13.33% 2.00 13.00 18.00 15.00 1.49 innodb outer_join_on_key 11.00 +8.07% 0.97 10.00 15.00 11.97 1.50 innodb prepared_select 33.00 -27.60% -7.14 22.00 29.00 25.86 2.10 innodb select_1_row 3.00 -22.54% -0.55 2.00 3.00 2.45 0.50 innodb select_1_row_cache 2.00 +3.33% 0.07 2.00 3.00 2.07 0.25 innodb select_2_rows 3.00 -35.94% -0.79 2.00 3.00 2.21 0.41 innodb select_big 13.00 -11.87% -1.38 10.00 13.00 11.62 1.00 innodb select_big_str 1.00 +9.42% 0.10 0.00 2.00 1.10 0.31 innodb select_cache 66.00 -14.61% -8.41 51.00 71.00 57.59 5.41 innodb select_cache2 65.00 -14.31% -8.14 51.00 68.00 56.86 4.88 innodb select_column+column 3.00 -12.99% -0.34 2.00 3.00 2.66 0.48 innodb select_diff_key 0.00 +100.00% 0.17 0.00 1.00 0.17 0.38 innodb select_distinct 4.00 -1.75% -0.07 3.00 5.00 3.93 0.36 innodb select_group 15.00 +1.36% 0.21 13.00 18.00 15.21 1.47 innodb select_group_when_MANY_tables 4.00 -0.00% 0.00 3.00 5.00 4.00 0.37 innodb select_join 1.00 -107.14% -0.52 0.00 1.00 0.48 0.50 innodb select_key 47.00 -5.58% -2.48 40.00 50.00 44.52 2.50 innodb select_key2 63.00 -27.85% -13.72 46.00 54.00 49.28 2.41 innodb select_key2_return_key 60.00 -27.85% -13.07 42.00 51.00 46.93 2.32 innodb select_key2_return_prim 61.00 -26.00% -12.59 43.00 55.00 48.41 2.92 innodb select_key_prefix 60.00 -18.13% -9.21 45.00 57.00 50.79 3.46 innodb select_key_prefix_join 4.00 +4.13% 0.17 4.00 5.00 4.17 0.38 innodb select_key_return_key 47.00 -7.83% -3.41 39.00 49.00 43.59 2.65 innodb select_many_fields 12.00 +27.04% 4.45 15.00 17.00 16.45 0.62 innodb select_range 53.00 -8.47% -4.14 47.00 57.00 48.86 1.66 innodb select_range_key2 9.00 -24.29% -1.76 6.00 8.00 7.24 0.57 innodb select_range_prefix 8.00 -14.29% -1.00 6.00 8.00 7.00 0.64 innodb select_simple 1.00 +30.95% 0.45 1.00 2.00 1.45 0.50 innodb select_simple_cache 1.00 +12.12% 0.14 1.00 2.00 1.14 0.34 innodb select_simple_join 1.00 -38.10% -0.28 0.00 1.00 0.72 0.45 innodb TOTALS 3493.00 -249.30% -2493.01 999.99 999.99 999.99 0.00 innodb update_autocommit 3.00 -7.41% -0.21 2.00 3.00 2.79 0.41 innodb update_big 59.00 -63.73% -22.97 31.00 40.00 36.03 2.48 innodb update_commit 2.00 -48.72% -0.66 1.00 2.00 1.34 0.48 innodb update_of_key 25.00 -29.70% -5.72 19.00 20.00 19.28 0.45 innodb update_of_key_big 28.00 -52.92% -9.69 16.00 20.00 18.31 1.18 innodb update_of_primary_key_many_keys 889.00 -16.46% -125.67 661.00 799.00 763.33 39.70 innodb update_rollback 2.00 -41.46% -0.59 1.00 2.00 1.41 0.49 innodb update_with_key 101.00 -10.07% -9.24 90.00 93.00 91.76 0.97 innodb update_with_key_prefix 37.00 -4.99% -1.76 34.00 36.00 35.24 0.57 innodb wisc_benchmark 2.00 +14.71% 0.34 2.00 3.00 2.34 0.48 ========================================================================================================================= _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
