======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 1029 RUN DATE: 2011-06-16T05:34:01.036889 SERVER: drizzled VERSION: staging REVISION: 2337 COMMENT: 2337: Mark Atwood 2011-06-15 [merge] merge lp:~olafvdspek/drizzle/refactor9
========================================================================================================================= TRENDING OVER LAST 5 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 32.00 +1.23% 0.40 31.00 34.00 32.40 1.02 innodb alter_table_drop 24.00 +1.64% 0.40 23.00 26.00 24.40 1.02 innodb connect 2.00 +16.67% 0.40 2.00 3.00 2.40 0.49 innodb connect+select_1_row 3.00 -7.14% -0.20 2.00 3.00 2.80 0.40 innodb connect+select_simple 3.00 -25.00% -0.60 2.00 3.00 2.40 0.49 innodb count 18.00 -7.14% -1.20 14.00 18.00 16.80 1.47 innodb count_distinct 6.00 +18.92% 1.40 6.00 8.00 7.40 0.80 innodb count_distinct_2 16.00 -6.67% -1.00 13.00 16.00 15.00 1.10 innodb count_distinct_big 25.00 -7.76% -1.80 21.00 25.00 23.20 1.83 innodb count_distinct_group 13.00 +5.80% 0.80 12.00 15.00 13.80 1.17 innodb count_distinct_group_on_key 10.00 +3.85% 0.40 9.00 11.00 10.40 0.80 innodb count_distinct_group_on_key_parts 14.00 -9.38% -1.20 11.00 14.00 12.80 1.47 innodb count_distinct_key_prefix 5.00 +7.41% 0.40 5.00 6.00 5.40 0.49 innodb count_group_on_key_parts 11.00 -0.00% 0.00 11.00 11.00 11.00 0.00 innodb count_on_key 96.00 -0.21% -0.20 95.00 96.00 95.80 0.40 innodb create+drop 33.00 -1.85% -0.60 31.00 33.00 32.40 0.80 innodb create_index 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb create_key+drop 32.00 -1.27% -0.40 30.00 33.00 31.60 1.02 innodb create_MANY_tables 20.00 +2.91% 0.60 20.00 21.00 20.60 0.49 innodb delete_all_many_keys 1014.00 -15.78% -138.20 805.00 1014.00 875.80 74.94 innodb delete_autocommit 3.00 +16.67% 0.60 3.00 4.00 3.60 0.49 innodb delete_big 1.00 -25.00% -0.20 0.00 1.00 0.80 0.40 innodb delete_big_many_keys 1013.00 -15.74% -137.80 804.00 1013.00 875.20 74.72 innodb delete_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb delete_key 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb delete_range 8.00 +2.44% 0.20 8.00 9.00 8.20 0.40 innodb delete_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb drop_index 3.00 +6.25% 0.20 3.00 4.00 3.20 0.40 innodb drop_table_when_MANY_tables 19.00 -1.06% -0.20 18.00 20.00 18.80 0.75 innodb insert 112.00 +0.53% 0.60 111.00 114.00 112.60 1.20 innodb insert_autocommit 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb insert_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb insert_duplicates 20.00 -4.17% -0.80 19.00 20.00 19.20 0.40 innodb insert_key 281.00 -0.72% -2.00 277.00 281.00 279.00 1.41 innodb insert_many_fields 5.00 +13.79% 0.80 5.00 6.00 5.80 0.40 innodb insert_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb insert_select_1_key 4.00 +13.04% 0.60 4.00 5.00 4.60 0.49 innodb insert_select_2_keys 7.00 -6.06% -0.40 6.00 7.00 6.60 0.49 innodb min_max 8.00 +2.44% 0.20 6.00 11.00 8.20 1.72 innodb min_max_on_key 24.00 +3.23% 0.80 24.00 26.00 24.80 0.75 innodb multiple_value_insert 5.00 +3.85% 0.20 4.00 6.00 5.20 0.75 innodb once_prepared_select 29.00 +0.68% 0.20 29.00 30.00 29.20 0.40 innodb order_by_big 13.00 +5.80% 0.80 13.00 15.00 13.80 0.75 innodb order_by_big_key 15.00 -5.63% -0.80 13.00 16.00 14.20 1.17 innodb order_by_big_key2 14.00 -2.94% -0.40 13.00 14.00 13.60 0.49 innodb order_by_big_key_desc 15.00 +2.60% 0.40 14.00 16.00 15.40 0.80 innodb order_by_big_key_diff 13.00 -0.00% 0.00 12.00 14.00 13.00 0.63 innodb order_by_big_key_prefix 13.00 +2.99% 0.40 12.00 14.00 13.40 0.80 innodb order_by_key2_diff 2.00 -25.00% -0.40 1.00 2.00 1.60 0.49 innodb order_by_key_prefix 0.00 +100.00% 0.80 0.00 1.00 0.80 0.40 innodb order_by_range 1.00 -25.00% -0.20 0.00 1.00 0.80 0.40 innodb outer_join 24.00 -6.19% -1.40 19.00 24.00 22.60 1.85 innodb outer_join_found 23.00 -5.50% -1.20 18.00 24.00 21.80 2.04 innodb outer_join_not_found 20.00 -4.17% -0.80 16.00 20.00 19.20 1.60 innodb outer_join_on_key 15.00 -1.35% -0.20 13.00 16.00 14.80 0.98 innodb prepared_select 37.00 -0.00% 0.00 36.00 38.00 37.00 0.63 innodb select_1_row 3.00 +16.67% 0.60 3.00 4.00 3.60 0.49 innodb select_1_row_cache 4.00 -5.26% -0.20 3.00 4.00 3.80 0.40 innodb select_2_rows 4.00 -17.65% -0.60 3.00 4.00 3.40 0.49 innodb select_big 14.00 -6.06% -0.80 12.00 15.00 13.20 1.17 innodb select_big_str 2.00 -42.86% -0.60 1.00 2.00 1.40 0.49 innodb select_cache 66.00 +2.08% 1.40 63.00 71.00 67.40 2.73 innodb select_cache2 73.00 -6.10% -4.20 64.00 73.00 68.80 3.82 innodb select_column+column 3.00 +21.05% 0.80 3.00 4.00 3.80 0.40 innodb select_diff_key 0.00 +100.00% 0.40 0.00 1.00 0.40 0.49 innodb select_distinct 5.00 -8.70% -0.40 4.00 5.00 4.60 0.49 innodb select_group 19.00 -4.40% -0.80 16.00 19.00 18.20 1.17 innodb select_group_when_MANY_tables 12.00 -3.45% -0.40 11.00 12.00 11.60 0.49 innodb select_join 1.00 -25.00% -0.20 0.00 1.00 0.80 0.40 innodb select_key 64.00 +0.31% 0.20 64.00 65.00 64.20 0.40 innodb select_key2 71.00 +0.56% 0.40 71.00 72.00 71.40 0.49 innodb select_key2_return_key 68.00 +0.87% 0.60 67.00 70.00 68.60 1.20 innodb select_key2_return_prim 69.00 +0.58% 0.40 68.00 71.00 69.40 1.02 innodb select_key_prefix 70.00 +0.85% 0.60 70.00 72.00 70.60 0.80 innodb select_key_prefix_join 5.00 +3.85% 0.20 5.00 6.00 5.20 0.40 innodb select_key_return_key 63.00 -0.32% -0.20 62.00 64.00 62.80 0.75 innodb select_many_fields 13.00 +2.99% 0.40 13.00 14.00 13.40 0.49 innodb select_range 49.00 -7.93% -3.60 41.00 49.00 45.40 3.67 innodb select_range_key2 9.00 +6.25% 0.60 9.00 10.00 9.60 0.49 innodb select_range_prefix 10.00 -8.70% -0.80 8.00 10.00 9.20 0.75 innodb select_simple 2.00 +9.09% 0.20 2.00 3.00 2.20 0.40 innodb select_simple_cache 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb select_simple_join 1.00 -150.00% -0.60 0.00 1.00 0.40 0.49 innodb update_autocommit 4.00 -17.65% -0.60 3.00 4.00 3.40 0.49 innodb update_big 60.00 -3.09% -1.80 57.00 60.00 58.20 1.47 innodb update_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_of_key 22.00 -0.00% 0.00 22.00 22.00 22.00 0.00 innodb update_of_key_big 19.00 -2.15% -0.40 18.00 19.00 18.60 0.49 innodb update_of_primary_key_many_keys 1253.00 +1.26% 16.00 1252.00 1301.00 1269.00 18.34 innodb update_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_with_key 119.00 +0.50% 0.60 118.00 121.00 119.60 1.20 innodb update_with_key_prefix 42.00 +0.94% 0.40 42.00 43.00 42.40 0.49 innodb wisc_benchmark 2.00 +16.67% 0.40 2.00 3.00 2.40 0.49 ========================================================================================================================= TRENDING OVER LAST 20 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 32.00 +0.47% 0.15 31.00 34.00 32.15 1.01 innodb alter_table_drop 24.00 +0.62% 0.15 23.00 26.00 24.15 0.91 innodb connect 2.00 +11.11% 0.25 2.00 3.00 2.25 0.43 innodb connect+select_1_row 3.00 -3.45% -0.10 2.00 3.00 2.90 0.30 innodb connect+select_simple 3.00 -15.38% -0.40 2.00 3.00 2.60 0.49 innodb count 18.00 -9.76% -1.60 14.00 18.00 16.40 1.71 innodb count_distinct 6.00 +13.67% 0.95 6.00 8.00 6.95 0.86 innodb count_distinct_2 16.00 -12.68% -1.80 12.00 16.00 14.20 1.40 innodb count_distinct_big 25.00 -7.76% -1.80 20.00 25.00 23.20 1.94 innodb count_distinct_group 13.00 +8.45% 1.20 12.00 15.00 14.20 1.12 innodb count_distinct_group_on_key 10.00 -2.56% -0.25 9.00 11.00 9.75 0.89 innodb count_distinct_group_on_key_parts 14.00 -9.80% -1.25 11.00 14.00 12.75 1.13 innodb count_distinct_key_prefix 5.00 +4.76% 0.25 4.00 6.00 5.25 0.62 innodb count_group_on_key_parts 11.00 +2.22% 0.25 11.00 13.00 11.25 0.54 innodb count_on_key 96.00 -0.84% -0.80 91.00 99.00 95.20 1.83 innodb create+drop 33.00 -0.61% -0.20 31.00 35.00 32.80 1.08 innodb create_index 3.00 -0.00% 0.00 2.00 4.00 3.00 0.32 innodb create_key+drop 32.00 -3.73% -1.15 29.00 33.00 30.85 1.19 innodb create_MANY_tables 20.00 +2.20% 0.45 19.00 23.00 20.45 1.07 innodb delete_all_many_keys 1014.00 -12.58% -113.30 640.00 1152.00 900.70 130.24 innodb delete_autocommit 3.00 +14.29% 0.50 3.00 4.00 3.50 0.50 innodb delete_big 1.00 -150.00% -0.60 0.00 1.00 0.40 0.49 innodb delete_big_many_keys 1013.00 -12.54% -112.85 639.00 1151.00 900.15 130.09 innodb delete_commit 2.00 -2.56% -0.05 1.00 2.00 1.95 0.22 innodb delete_key 3.00 -0.00% 0.00 2.00 4.00 3.00 0.32 innodb delete_range 8.00 +0.62% 0.05 7.00 9.00 8.05 0.59 innodb delete_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb drop_index 3.00 +1.64% 0.05 2.00 4.00 3.05 0.50 innodb drop_table_when_MANY_tables 19.00 -1.33% -0.25 18.00 21.00 18.75 0.83 innodb insert 112.00 -0.00% 0.00 110.00 114.00 112.00 1.14 innodb insert_autocommit 3.00 +3.23% 0.10 3.00 4.00 3.10 0.30 innodb insert_commit 2.00 -8.11% -0.15 1.00 2.00 1.85 0.36 innodb insert_duplicates 20.00 -4.17% -0.80 18.00 20.00 19.20 0.51 innodb insert_key 281.00 -0.73% -2.05 264.00 305.00 278.95 9.88 innodb insert_many_fields 5.00 +15.25% 0.90 5.00 7.00 5.90 0.62 innodb insert_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb insert_select_1_key 4.00 +17.53% 0.85 4.00 6.00 4.85 0.48 innodb insert_select_2_keys 7.00 -9.38% -0.60 5.00 7.00 6.40 0.58 innodb min_max 8.00 +4.76% 0.40 6.00 11.00 8.40 1.07 innodb min_max_on_key 24.00 +2.83% 0.70 24.00 26.00 24.70 0.64 innodb multiple_value_insert 5.00 +9.09% 0.50 4.00 7.00 5.50 0.74 innodb once_prepared_select 29.00 +0.17% 0.05 28.00 30.00 29.05 0.38 innodb order_by_big 13.00 +7.80% 1.10 13.00 15.00 14.10 0.89 innodb order_by_big_key 15.00 -5.63% -0.80 12.00 16.00 14.20 1.17 innodb order_by_big_key2 14.00 -3.32% -0.45 12.00 14.00 13.55 0.59 innodb order_by_big_key_desc 15.00 +0.66% 0.10 14.00 16.00 15.10 0.89 innodb order_by_big_key_diff 13.00 -0.78% -0.10 11.00 15.00 12.90 0.89 innodb order_by_big_key_prefix 13.00 +1.52% 0.20 12.00 14.00 13.20 0.75 innodb order_by_key2_diff 2.00 -42.86% -0.60 1.00 2.00 1.40 0.49 innodb order_by_key_prefix 0.00 +100.00% 0.95 0.00 1.00 0.95 0.22 innodb order_by_range 1.00 -11.11% -0.10 0.00 1.00 0.90 0.30 innodb outer_join 24.00 -8.35% -1.85 18.00 24.00 22.15 2.13 innodb outer_join_found 23.00 -9.00% -1.90 16.00 24.00 21.10 2.32 innodb outer_join_not_found 20.00 -3.63% -0.70 16.00 21.00 19.30 1.95 innodb outer_join_on_key 15.00 -4.90% -0.70 11.00 16.00 14.30 1.52 innodb prepared_select 37.00 -0.82% -0.30 36.00 38.00 36.70 0.56 innodb select_1_row 3.00 +17.81% 0.65 3.00 4.00 3.65 0.48 innodb select_1_row_cache 4.00 -14.29% -0.50 3.00 4.00 3.50 0.50 innodb select_2_rows 4.00 -8.11% -0.30 3.00 4.00 3.70 0.46 innodb select_big 14.00 -7.69% -1.00 11.00 15.00 13.00 0.95 innodb select_big_str 2.00 -53.85% -0.70 1.00 2.00 1.30 0.46 innodb select_cache 66.00 -1.62% -1.05 60.00 71.00 64.95 2.82 innodb select_cache2 73.00 -10.61% -7.00 61.00 73.00 66.00 3.63 innodb select_column+column 3.00 +20.00% 0.75 3.00 4.00 3.75 0.43 innodb select_diff_key 0.00 +100.00% 0.35 0.00 1.00 0.35 0.48 innodb select_distinct 5.00 -8.70% -0.40 4.00 5.00 4.60 0.49 innodb select_group 19.00 -10.14% -1.75 15.00 19.00 17.25 1.44 innodb select_group_when_MANY_tables 12.00 -2.56% -0.30 11.00 14.00 11.70 0.78 innodb select_join 1.00 -33.33% -0.25 0.00 1.00 0.75 0.43 innodb select_key 64.00 -0.00% 0.00 63.00 65.00 64.00 0.71 innodb select_key2 71.00 -0.42% -0.30 69.00 72.00 70.70 0.90 innodb select_key2_return_key 68.00 +0.15% 0.10 67.00 70.00 68.10 0.94 innodb select_key2_return_prim 69.00 +0.07% 0.05 68.00 71.00 69.05 0.92 innodb select_key_prefix 70.00 +0.14% 0.10 68.00 72.00 70.10 0.89 innodb select_key_prefix_join 5.00 +3.85% 0.20 5.00 6.00 5.20 0.40 innodb select_key_return_key 63.00 -0.40% -0.25 62.00 64.00 62.75 0.70 innodb select_many_fields 13.00 +1.14% 0.15 12.00 14.00 13.15 0.48 innodb select_range 49.00 -10.99% -4.85 40.00 49.00 44.15 2.99 innodb select_range_key2 9.00 +8.16% 0.80 9.00 11.00 9.80 0.60 innodb select_range_prefix 10.00 -9.29% -0.85 8.00 10.00 9.15 0.65 innodb select_simple 2.00 +4.76% 0.10 2.00 3.00 2.10 0.30 innodb select_simple_cache 2.00 +2.44% 0.05 2.00 3.00 2.05 0.22 innodb select_simple_join 1.00 -42.86% -0.30 0.00 1.00 0.70 0.46 innodb update_autocommit 4.00 -19.40% -0.65 3.00 4.00 3.35 0.48 innodb update_big 60.00 -3.18% -1.85 55.00 61.00 58.15 1.71 innodb update_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_of_key 22.00 +0.90% 0.20 21.00 24.00 22.20 0.68 innodb update_of_key_big 19.00 -0.80% -0.15 18.00 20.00 18.85 0.73 innodb update_of_primary_key_many_keys 1253.00 +1.81% 23.05 1105.00 1458.00 1276.05 72.72 innodb update_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_with_key 119.00 -0.72% -0.85 115.00 121.00 118.15 1.93 innodb update_with_key_prefix 42.00 +0.71% 0.30 41.00 44.00 42.30 1.10 innodb wisc_benchmark 2.00 +18.37% 0.45 2.00 3.00 2.45 0.50 ========================================================================================================================= TRENDING OVER ALL runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 32.00 -44.48% -9.85 11.00 61.00 22.15 10.16 innodb alter_table_drop 24.00 -26.83% -5.08 10.00 57.00 18.92 6.81 innodb connect 2.00 +4.50% 0.09 1.00 3.00 2.09 0.42 innodb connect+select_1_row 3.00 -10.07% -0.27 2.00 5.00 2.73 0.46 innodb connect+select_simple 3.00 -26.38% -0.63 1.00 3.00 2.37 0.49 innodb count 18.00 -14.22% -2.24 12.00 193.00 15.76 8.40 innodb count_distinct 6.00 +9.03% 0.60 5.00 50.00 6.60 2.17 innodb count_distinct_2 16.00 -20.72% -2.75 11.00 63.00 13.25 2.84 innodb count_distinct_big 25.00 -13.46% -2.97 5.00 67.00 22.03 2.94 innodb count_distinct_group 13.00 +2.08% 0.28 10.00 68.00 13.28 2.98 innodb count_distinct_group_on_key 10.00 -5.07% -0.48 7.00 69.00 9.52 2.88 innodb count_distinct_group_on_key_parts 14.00 -12.93% -1.60 9.00 72.00 12.40 3.03 innodb count_distinct_key_prefix 5.00 +2.87% 0.15 3.00 52.00 5.15 2.27 innodb count_group_on_key_parts 11.00 -9.07% -0.92 7.00 72.00 10.08 3.01 innodb count_on_key 96.00 -10.55% -9.16 68.00 107.00 86.84 7.50 innodb create+drop 33.00 -1.53% -0.50 18.00 75.00 32.50 11.29 innodb create_index 3.00 -3.17% -0.09 1.00 8.00 2.91 1.09 innodb create_key+drop 32.00 -12.29% -3.50 21.00 50.00 28.50 4.77 innodb create_MANY_tables 20.00 +38.91% 12.74 14.00 121.00 32.74 16.72 innodb create_table 0.00 +100.00% 0.10 0.00 3.00 0.10 0.35 innodb delete_all_many_keys 1014.00 -106.31% -522.52 212.00 1888.00 491.48 357.95 innodb delete_autocommit 3.00 +13.25% 0.46 2.00 14.00 3.46 0.73 innodb delete_big 1.00 -226.71% -0.69 0.00 3.00 0.31 0.47 innodb delete_big_many_keys 1013.00 -103.91% -516.20 212.00 2293.00 496.80 370.54 innodb delete_commit 2.00 -29.18% -0.45 1.00 5.00 1.55 0.52 innodb delete_key 3.00 +1.11% 0.03 2.00 35.00 3.03 1.43 innodb delete_range 8.00 +3.88% 0.32 5.00 23.00 8.32 3.08 innodb delete_rollback 2.00 -12.77% -0.23 1.00 12.00 1.77 0.88 innodb drop_index 3.00 -1.42% -0.04 1.00 9.00 2.96 1.26 innodb drop_table 0.00 +100.00% 0.04 0.00 2.00 0.04 0.22 innodb drop_table_when_MANY_tables 19.00 +2.48% 0.48 11.00 90.00 19.48 7.16 innodb insert 112.00 -4.35% -4.67 3.00 343.00 107.33 14.00 innodb insert_autocommit 3.00 +0.42% 0.01 2.00 99.00 3.01 3.15 innodb insert_commit 2.00 -40.40% -0.58 1.00 3.00 1.42 0.50 innodb insert_duplicates 20.00 -26.38% -4.17 11.00 21.00 15.83 2.75 innodb insert_key 281.00 +6.52% 19.59 142.00 700.00 300.59 101.49 innodb insert_many_fields 5.00 +11.13% 0.63 3.00 17.00 5.63 1.69 innodb insert_rollback 2.00 -17.63% -0.30 1.00 3.00 1.70 0.52 innodb insert_select_1_key 4.00 -4.41% -0.17 2.00 10.00 3.83 0.89 innodb insert_select_2_keys 7.00 -15.02% -0.91 4.00 16.00 6.09 2.00 innodb min_max 8.00 -2.17% -0.17 6.00 110.00 7.83 4.33 innodb min_max_on_key 24.00 -14.67% -3.07 14.00 37.00 20.93 3.17 innodb multiple_value_insert 5.00 +9.53% 0.53 2.00 50.00 5.53 4.08 innodb once_prepared_select 29.00 -17.53% -4.33 18.00 32.00 24.67 3.68 innodb order_by_big 13.00 +9.07% 1.30 12.00 31.00 14.30 1.49 innodb order_by_big_key 15.00 -12.23% -1.63 11.00 32.00 13.37 1.64 innodb order_by_big_key2 14.00 -14.05% -1.73 10.00 33.00 12.27 1.51 innodb order_by_big_key_desc 15.00 -9.97% -1.36 11.00 32.00 13.64 1.69 innodb order_by_big_key_diff 13.00 -5.70% -0.70 10.00 31.00 12.30 1.47 innodb order_by_big_key_prefix 13.00 -4.33% -0.54 10.00 32.00 12.46 1.51 innodb order_by_key2_diff 2.00 -42.77% -0.60 1.00 3.00 1.40 0.49 innodb order_by_key_prefix 0.00 +100.00% 0.80 0.00 2.00 0.80 0.41 innodb order_by_range 1.00 -19.27% -0.16 0.00 2.00 0.84 0.37 innodb outer_join 24.00 -22.40% -4.39 15.00 61.00 19.61 3.71 innodb outer_join_found 23.00 -21.07% -4.00 14.00 58.00 19.00 3.56 innodb outer_join_not_found 20.00 -19.51% -3.27 12.00 46.00 16.73 3.21 innodb outer_join_on_key 15.00 -14.76% -1.93 10.00 59.00 13.07 2.74 innodb prepared_select 37.00 -16.14% -5.14 22.00 40.00 31.86 4.59 innodb select_1_row 3.00 -2.80% -0.08 2.00 4.00 2.92 0.71 innodb select_1_row_cache 4.00 -45.03% -1.24 2.00 4.00 2.76 0.71 innodb select_2_rows 4.00 -35.61% -1.05 2.00 4.00 2.95 0.72 innodb select_big 14.00 -14.66% -1.79 0.00 31.00 12.21 1.52 innodb select_big_str 2.00 -69.13% -0.82 0.00 2.00 1.18 0.39 innodb select_cache 66.00 -9.94% -5.97 49.00 77.00 60.03 5.58 innodb select_cache2 73.00 -20.80% -12.57 49.00 76.00 60.43 6.23 innodb select_column+column 3.00 +0.17% 0.01 2.00 4.00 3.01 0.74 innodb select_diff_key 0.00 +100.00% 0.22 0.00 1.00 0.22 0.42 innodb select_distinct 5.00 -17.18% -0.73 3.00 8.00 4.27 0.55 innodb select_group 19.00 -16.42% -2.68 4.00 136.00 16.32 5.18 innodb select_group_when_MANY_tables 12.00 -23.74% -2.30 3.00 49.00 9.70 9.02 innodb select_join 1.00 -71.45% -0.42 0.00 1.00 0.58 0.49 innodb select_key 64.00 -18.91% -10.18 40.00 66.00 53.82 7.80 innodb select_key2 71.00 -17.32% -10.48 45.00 75.00 60.52 8.55 innodb select_key2_return_key 68.00 -17.53% -10.14 42.00 71.00 57.86 8.39 innodb select_key2_return_prim 69.00 -17.70% -10.38 42.00 72.00 58.62 8.52 innodb select_key_prefix 70.00 -17.05% -10.20 44.00 75.00 59.80 8.61 innodb select_key_prefix_join 5.00 -4.99% -0.24 3.00 10.00 4.76 0.64 innodb select_key_return_key 63.00 -19.25% -10.17 38.00 65.00 52.83 7.79 innodb select_many_fields 13.00 +12.05% 1.78 11.00 19.00 14.78 1.79 innodb select_range 49.00 -4.84% -2.26 38.00 76.00 46.74 4.06 innodb select_range_key2 9.00 -7.36% -0.62 6.00 11.00 8.38 1.08 innodb select_range_prefix 10.00 -25.44% -2.03 5.00 10.00 7.97 1.15 innodb select_simple 2.00 -18.56% -0.31 1.00 3.00 1.69 0.51 innodb select_simple_cache 2.00 -25.00% -0.40 1.00 3.00 1.60 0.51 innodb select_simple_join 1.00 -48.99% -0.33 0.00 3.00 0.67 0.48 innodb update_autocommit 4.00 -19.36% -0.65 2.00 16.00 3.35 0.98 innodb update_big 60.00 -15.97% -8.26 31.00 195.00 51.74 23.37 innodb update_commit 2.00 -24.95% -0.40 1.00 10.00 1.60 0.71 innodb update_of_key 22.00 +8.46% 2.03 18.00 100.00 24.03 5.90 innodb update_of_key_big 19.00 +31.45% 8.72 15.00 75.00 27.72 10.81 innodb update_of_primary_key_many_keys 1253.00 -0.34% -4.20 647.00 6065.00 1248.80 899.72 innodb update_rollback 2.00 -11.71% -0.21 1.00 31.00 1.79 1.81 innodb update_with_key 119.00 -7.36% -8.16 90.00 598.00 110.84 20.00 innodb update_with_key_prefix 42.00 -4.96% -1.98 33.00 202.00 40.02 6.62 innodb wisc_benchmark 2.00 +19.46% 0.48 2.00 5.00 2.48 0.52 ========================================================================================================================= FULL REVISION COMMENTARY: 2318.4.8: Olaf van der Spek 2011-06-14 Remove malloc NULL check. Just die. 2318.4.7: Olaf van der Spek 2011-06-14 Refactor _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
