======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 895 RUN DATE: 2011-02-14T02:19:19.993649 SERVER: drizzled VERSION: staging REVISION: 2167 COMMENT: 2167: Brian Aker 2011-02-13 [merge] Merge in the last of the header fixes.
========================================================================================================================= TRENDING OVER LAST 5 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 32.00 +0.62% 0.20 32.00 33.00 32.20 0.40 innodb alter_table_drop 25.00 -5.93% -1.40 23.00 25.00 23.60 0.80 innodb connect 2.00 +9.09% 0.20 2.00 3.00 2.20 0.40 innodb connect+select_1_row 3.00 -7.14% -0.20 2.00 3.00 2.80 0.40 innodb connect+select_simple 2.00 +9.09% 0.20 2.00 3.00 2.20 0.40 innodb count 18.00 -16.88% -2.60 13.00 18.00 15.40 2.15 innodb count_distinct 7.00 -0.00% 0.00 6.00 8.00 7.00 0.63 innodb count_distinct_2 16.00 -14.29% -2.00 13.00 16.00 14.00 1.26 innodb count_distinct_big 24.00 -6.19% -1.40 21.00 24.00 22.60 1.02 innodb count_distinct_group 15.00 -5.63% -0.80 11.00 15.00 14.20 1.60 innodb count_distinct_group_on_key 11.00 +11.29% 1.40 9.00 17.00 12.40 3.44 innodb count_distinct_group_on_key_parts 13.00 +2.99% 0.40 11.00 15.00 13.40 1.36 innodb count_distinct_key_prefix 5.00 -0.00% 0.00 4.00 6.00 5.00 0.63 innodb count_group_on_key_parts 11.00 +1.79% 0.20 11.00 12.00 11.20 0.40 innodb count_on_key 96.00 -0.84% -0.80 91.00 97.00 95.20 2.14 innodb create+drop 32.00 -0.63% -0.20 30.00 33.00 31.80 1.17 innodb create_index 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb create_key+drop 29.00 +1.36% 0.40 29.00 30.00 29.40 0.49 innodb create_MANY_tables 20.00 -1.01% -0.20 19.00 21.00 19.80 0.75 innodb create_table 0.00 +100.00% 0.20 0.00 1.00 0.20 0.40 innodb delete_all_many_keys 640.00 +0.47% 3.00 614.00 705.00 643.00 32.17 innodb delete_autocommit 4.00 -0.00% 0.00 4.00 4.00 4.00 0.00 innodb delete_big 0.00 +100.00% 0.40 0.00 1.00 0.40 0.49 innodb delete_big_many_keys 639.00 +0.44% 2.80 613.00 704.00 641.80 32.25 innodb delete_commit 1.00 +37.50% 0.60 1.00 2.00 1.60 0.49 innodb delete_key 2.00 +28.57% 0.80 2.00 3.00 2.80 0.40 innodb delete_range 8.00 +2.44% 0.20 7.00 9.00 8.20 0.75 innodb delete_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb drop_index 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb drop_table_when_MANY_tables 16.00 -1.27% -0.20 15.00 17.00 15.80 0.75 innodb insert 114.00 -0.53% -0.60 112.00 114.00 113.40 0.80 innodb insert_autocommit 3.00 +6.25% 0.20 3.00 4.00 3.20 0.40 innodb insert_commit 2.00 -11.11% -0.20 1.00 2.00 1.80 0.40 innodb insert_duplicates 18.00 +5.26% 1.00 18.00 20.00 19.00 0.89 innodb insert_key 276.00 +0.50% 1.40 269.00 299.00 277.40 11.04 innodb insert_many_fields 5.00 +10.71% 0.60 5.00 6.00 5.60 0.49 innodb insert_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb insert_select_1_key 4.00 +4.76% 0.20 4.00 5.00 4.20 0.40 innodb insert_select_2_keys 6.00 -0.00% 0.00 4.00 7.00 6.00 1.10 innodb min_max 9.00 -18.42% -1.40 6.00 9.00 7.60 1.20 innodb min_max_on_key 24.00 +0.83% 0.20 24.00 25.00 24.20 0.40 innodb multiple_value_insert 7.00 +2.78% 0.20 7.00 8.00 7.20 0.40 innodb once_prepared_select 30.00 -2.74% -0.80 29.00 30.00 29.20 0.40 innodb order_by_big 15.00 -4.17% -0.60 13.00 15.00 14.40 0.80 innodb order_by_big_key 14.00 +9.09% 1.40 14.00 17.00 15.40 1.20 innodb order_by_big_key2 14.00 -6.06% -0.80 13.00 14.00 13.20 0.40 innodb order_by_big_key_desc 15.00 +3.85% 0.60 15.00 16.00 15.60 0.49 innodb order_by_big_key_diff 14.00 -7.69% -1.00 12.00 14.00 13.00 0.89 innodb order_by_big_key_prefix 14.00 -0.00% 0.00 14.00 14.00 14.00 0.00 innodb order_by_key2_diff 2.00 -25.00% -0.40 1.00 2.00 1.60 0.49 innodb order_by_key_prefix 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb order_by_range 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb outer_join 25.00 -15.74% -3.40 17.00 25.00 21.60 3.77 innodb outer_join_found 25.00 -20.19% -4.20 17.00 25.00 20.80 3.25 innodb outer_join_not_found 22.00 -25.00% -4.40 14.00 22.00 17.60 3.26 innodb outer_join_on_key 17.00 -19.72% -2.80 11.00 17.00 14.20 2.64 innodb prepared_select 37.00 -0.00% 0.00 37.00 37.00 37.00 0.00 innodb select_1_row 4.00 -5.26% -0.20 3.00 4.00 3.80 0.40 innodb select_1_row_cache 3.00 +6.25% 0.20 3.00 4.00 3.20 0.40 innodb select_2_rows 4.00 -5.26% -0.20 3.00 4.00 3.80 0.40 innodb select_big 14.00 -1.45% -0.20 13.00 15.00 13.80 0.75 innodb select_big_str 1.00 +16.67% 0.20 1.00 2.00 1.20 0.40 innodb select_cache 63.00 +3.37% 2.20 63.00 71.00 65.20 2.93 innodb select_cache2 63.00 +1.25% 0.80 62.00 65.00 63.80 1.17 innodb select_column+column 4.00 -5.26% -0.20 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 -4.17% -0.20 4.00 5.00 4.80 0.40 innodb select_group 18.00 -2.27% -0.40 15.00 19.00 17.60 1.36 innodb select_group_when_MANY_tables 12.00 +1.64% 0.20 12.00 13.00 12.20 0.40 innodb select_join 1.00 -150.00% -0.60 0.00 1.00 0.40 0.49 innodb select_key 64.00 -0.63% -0.40 63.00 64.00 63.60 0.49 innodb select_key2 72.00 -1.98% -1.40 70.00 72.00 70.60 0.80 innodb select_key2_return_key 68.00 +0.29% 0.20 68.00 69.00 68.20 0.40 innodb select_key2_return_prim 70.00 -1.16% -0.80 69.00 70.00 69.20 0.40 innodb select_key_prefix 70.00 +0.57% 0.40 70.00 71.00 70.40 0.49 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.00% 0.00 63.00 63.00 63.00 0.00 innodb select_many_fields 14.00 -4.48% -0.60 13.00 14.00 13.40 0.49 innodb select_range 42.00 +0.47% 0.20 39.00 49.00 42.20 3.66 innodb select_range_key2 10.00 -4.17% -0.40 9.00 10.00 9.60 0.49 innodb select_range_prefix 9.00 -2.27% -0.20 8.00 10.00 8.80 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 0.00 +100.00% 0.60 0.00 1.00 0.60 0.49 innodb update_autocommit 4.00 -17.65% -0.60 3.00 4.00 3.40 0.49 innodb update_big 59.00 -0.34% -0.20 57.00 60.00 58.80 0.98 innodb update_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_of_key 23.00 -3.60% -0.80 21.00 24.00 22.20 1.17 innodb update_of_key_big 29.00 +16.18% 5.60 29.00 38.00 34.60 3.07 innodb update_of_primary_key_many_keys 1334.00 +0.37% 5.00 1299.00 1442.00 1339.00 53.06 innodb update_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_with_key 124.00 -0.00% 0.00 121.00 127.00 124.00 1.90 innodb update_with_key_prefix 43.00 +1.38% 0.60 41.00 46.00 43.60 1.74 innodb wisc_benchmark 3.00 -15.38% -0.40 2.00 3.00 2.60 0.49 ========================================================================================================================= TRENDING OVER LAST 20 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 32.00 +1.39% 0.45 31.00 34.00 32.45 0.67 innodb alter_table_drop 25.00 -3.31% -0.80 23.00 25.00 24.20 0.75 innodb connect 2.00 +6.98% 0.15 2.00 3.00 2.15 0.36 innodb connect+select_1_row 3.00 -3.45% -0.10 2.00 3.00 2.90 0.30 innodb connect+select_simple 2.00 +24.53% 0.65 2.00 3.00 2.65 0.48 innodb count 18.00 -17.26% -2.65 13.00 18.00 15.35 1.82 innodb count_distinct 7.00 -6.87% -0.45 6.00 8.00 6.55 0.67 innodb count_distinct_2 16.00 -15.52% -2.15 12.00 16.00 13.85 1.15 innodb count_distinct_big 24.00 -5.73% -1.30 20.00 25.00 22.70 1.71 innodb count_distinct_group 15.00 -4.53% -0.65 11.00 16.00 14.35 1.15 innodb count_distinct_group_on_key 11.00 -4.76% -0.50 8.00 17.00 10.50 2.18 innodb count_distinct_group_on_key_parts 13.00 +2.62% 0.35 11.00 15.00 13.35 0.85 innodb count_distinct_key_prefix 5.00 +3.85% 0.20 4.00 6.00 5.20 0.60 innodb count_group_on_key_parts 11.00 -0.00% 0.00 10.00 12.00 11.00 0.45 innodb count_on_key 96.00 -2.13% -2.00 91.00 97.00 94.00 1.82 innodb create+drop 32.00 -0.63% -0.20 30.00 34.00 31.80 1.25 innodb create_index 3.00 +3.23% 0.10 2.00 4.00 3.10 0.44 innodb create_key+drop 29.00 +0.17% 0.05 28.00 30.00 29.05 0.74 innodb create_MANY_tables 20.00 +2.91% 0.60 19.00 22.00 20.60 0.80 innodb create_table 0.00 +100.00% 0.15 0.00 1.00 0.15 0.36 innodb delete_all_many_keys 640.00 +3.45% 22.85 569.00 738.00 662.85 45.08 innodb delete_autocommit 4.00 -11.11% -0.40 3.00 4.00 3.60 0.49 innodb delete_big 0.00 +100.00% 0.55 0.00 1.00 0.55 0.50 innodb delete_big_many_keys 639.00 +3.46% 22.90 569.00 737.00 661.90 44.97 innodb delete_commit 1.00 +45.95% 0.85 1.00 2.00 1.85 0.36 innodb delete_key 2.00 +28.57% 0.80 2.00 4.00 2.80 0.51 innodb delete_range 8.00 +6.43% 0.55 7.00 10.00 8.55 0.74 innodb delete_rollback 2.00 +9.09% 0.20 2.00 3.00 2.20 0.40 innodb drop_index 3.00 +6.25% 0.20 3.00 4.00 3.20 0.40 innodb drop_table_when_MANY_tables 16.00 +0.93% 0.15 15.00 17.00 16.15 0.65 innodb insert 114.00 +0.18% 0.20 112.00 116.00 114.20 1.08 innodb insert_autocommit 3.00 +6.25% 0.20 3.00 4.00 3.20 0.40 innodb insert_commit 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb insert_duplicates 18.00 +5.76% 1.10 18.00 20.00 19.10 0.54 innodb insert_key 276.00 +2.97% 8.45 266.00 304.00 284.45 12.21 innodb insert_many_fields 5.00 +12.28% 0.70 5.00 6.00 5.70 0.46 innodb insert_rollback 2.00 -5.26% -0.10 1.00 2.00 1.90 0.30 innodb insert_select_1_key 4.00 +1.23% 0.05 3.00 5.00 4.05 0.50 innodb insert_select_2_keys 6.00 +4.76% 0.30 4.00 8.00 6.30 0.84 innodb min_max 9.00 -16.13% -1.25 6.00 9.00 7.75 0.94 innodb min_max_on_key 24.00 +1.64% 0.40 24.00 25.00 24.40 0.49 innodb multiple_value_insert 7.00 -5.26% -0.35 5.00 8.00 6.65 0.79 innodb once_prepared_select 30.00 -2.74% -0.80 29.00 30.00 29.20 0.40 innodb order_by_big 15.00 -4.90% -0.70 13.00 16.00 14.30 1.05 innodb order_by_big_key 14.00 +4.44% 0.65 13.00 17.00 14.65 1.06 innodb order_by_big_key2 14.00 -7.69% -1.00 12.00 14.00 13.00 0.63 innodb order_by_big_key_desc 15.00 +1.32% 0.20 14.00 16.00 15.20 0.68 innodb order_by_big_key_diff 14.00 -7.28% -0.95 12.00 14.00 13.05 0.80 innodb order_by_big_key_prefix 14.00 -3.70% -0.50 12.00 15.00 13.50 0.81 innodb order_by_key2_diff 2.00 -29.03% -0.45 1.00 2.00 1.55 0.50 innodb order_by_key_prefix 1.00 -17.65% -0.15 0.00 1.00 0.85 0.36 innodb order_by_range 1.00 -11.11% -0.10 0.00 1.00 0.90 0.30 innodb outer_join 25.00 -14.94% -3.25 17.00 25.00 21.75 3.19 innodb outer_join_found 25.00 -18.76% -3.95 16.00 25.00 21.05 3.26 innodb outer_join_not_found 22.00 -19.57% -3.60 14.00 22.00 18.40 2.92 innodb outer_join_on_key 17.00 -17.24% -2.50 11.00 18.00 14.50 2.31 innodb prepared_select 37.00 +0.40% 0.15 37.00 38.00 37.15 0.36 innodb select_1_row 4.00 -11.11% -0.40 3.00 4.00 3.60 0.49 innodb select_1_row_cache 3.00 +11.76% 0.40 3.00 4.00 3.40 0.49 innodb select_2_rows 4.00 -9.59% -0.35 3.00 4.00 3.65 0.48 innodb select_big 14.00 -5.66% -0.75 12.00 15.00 13.25 0.89 innodb select_big_str 1.00 +23.08% 0.30 1.00 2.00 1.30 0.46 innodb select_cache 63.00 -0.48% -0.30 57.00 71.00 62.70 3.27 innodb select_cache2 63.00 -0.24% -0.15 60.00 67.00 62.85 1.96 innodb select_column+column 4.00 -5.26% -0.20 3.00 4.00 3.80 0.40 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 18.00 -4.05% -0.70 15.00 19.00 17.30 1.49 innodb select_group_when_MANY_tables 12.00 +1.64% 0.20 11.00 14.00 12.20 0.81 innodb select_join 1.00 -42.86% -0.30 0.00 1.00 0.70 0.46 innodb select_key 64.00 -0.71% -0.45 63.00 65.00 63.55 0.59 innodb select_key2 72.00 -1.41% -1.00 70.00 73.00 71.00 0.95 innodb select_key2_return_key 68.00 +0.51% 0.35 67.00 70.00 68.35 0.79 innodb select_key2_return_prim 70.00 -1.08% -0.75 68.00 71.00 69.25 0.89 innodb select_key_prefix 70.00 +0.85% 0.60 69.00 72.00 70.60 0.73 innodb select_key_prefix_join 5.00 +4.76% 0.25 5.00 6.00 5.25 0.43 innodb select_key_return_key 63.00 -0.08% -0.05 62.00 65.00 62.95 0.74 innodb select_many_fields 14.00 -6.06% -0.80 13.00 14.00 13.20 0.40 innodb select_range 42.00 +0.24% 0.10 39.00 49.00 42.10 2.34 innodb select_range_key2 10.00 -5.26% -0.50 9.00 10.00 9.50 0.50 innodb select_range_prefix 9.00 +2.17% 0.20 8.00 10.00 9.20 0.68 innodb select_simple 2.00 +2.44% 0.05 2.00 3.00 2.05 0.22 innodb select_simple_cache 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb select_simple_join 0.00 +100.00% 0.65 0.00 1.00 0.65 0.48 innodb update_autocommit 4.00 -9.59% -0.35 3.00 4.00 3.65 0.48 innodb update_big 59.00 +1.09% 0.65 56.00 64.00 59.65 2.13 innodb update_commit 2.00 -2.56% -0.05 1.00 2.00 1.95 0.22 innodb update_of_key 23.00 -2.91% -0.65 21.00 25.00 22.35 1.24 innodb update_of_key_big 29.00 +19.78% 7.15 29.00 47.00 36.15 4.17 innodb update_of_primary_key_many_keys 1334.00 +2.04% 27.80 1203.00 1482.00 1361.80 79.19 innodb update_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_with_key 124.00 -1.35% -1.65 117.00 127.00 122.35 2.71 innodb update_with_key_prefix 43.00 +3.04% 1.35 40.00 50.00 44.35 2.55 innodb wisc_benchmark 3.00 -20.00% -0.50 2.00 3.00 2.50 0.50 ========================================================================================================================= TRENDING OVER ALL runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 32.00 -55.61% -11.44 11.00 61.00 20.56 10.01 innodb alter_table_drop 25.00 -37.62% -6.83 10.00 57.00 18.17 7.01 innodb connect 2.00 +3.78% 0.08 1.00 3.00 2.08 0.42 innodb connect+select_1_row 3.00 -11.46% -0.31 2.00 5.00 2.69 0.48 innodb connect+select_simple 2.00 +14.21% 0.33 1.00 3.00 2.33 0.48 innodb count 18.00 -14.26% -2.25 12.00 193.00 15.75 8.99 innodb count_distinct 7.00 -6.66% -0.44 5.00 50.00 6.56 2.31 innodb count_distinct_2 16.00 -21.60% -2.84 11.00 63.00 13.16 3.00 innodb count_distinct_big 24.00 -9.55% -2.09 5.00 67.00 21.91 3.05 innodb count_distinct_group 15.00 -14.53% -1.90 10.00 68.00 13.10 3.14 innodb count_distinct_group_on_key 11.00 -16.09% -1.52 7.00 69.00 9.48 3.07 innodb count_distinct_group_on_key_parts 13.00 -5.88% -0.72 9.00 72.00 12.28 3.20 innodb count_distinct_key_prefix 5.00 +2.29% 0.12 3.00 52.00 5.12 2.43 innodb count_group_on_key_parts 11.00 -10.68% -1.06 7.00 72.00 9.94 3.21 innodb count_on_key 96.00 -12.08% -10.35 68.00 107.00 85.65 7.31 innodb create+drop 32.00 +1.27% 0.41 18.00 75.00 32.41 12.13 innodb create_index 3.00 -4.46% -0.13 1.00 8.00 2.87 1.16 innodb create_key+drop 29.00 -3.32% -0.93 21.00 50.00 28.07 4.96 innodb create_MANY_tables 20.00 +42.20% 14.60 14.00 121.00 34.60 17.22 innodb create_table 0.00 +100.00% 0.11 0.00 3.00 0.11 0.37 innodb delete_all_many_keys 640.00 -40.33% -183.92 212.00 1888.00 456.08 370.31 innodb delete_autocommit 4.00 -16.46% -0.57 2.00 14.00 3.43 0.75 innodb delete_big 0.00 +100.00% 0.28 0.00 3.00 0.28 0.46 innodb delete_big_many_keys 639.00 -38.16% -176.48 212.00 2293.00 462.52 385.03 innodb delete_commit 1.00 +33.23% 0.50 1.00 5.00 1.50 0.53 innodb delete_key 2.00 +34.83% 1.07 2.00 35.00 3.07 1.52 innodb delete_range 8.00 +3.41% 0.28 5.00 23.00 8.28 3.30 innodb delete_rollback 2.00 -16.09% -0.28 1.00 12.00 1.72 0.93 innodb drop_index 3.00 -1.81% -0.05 1.00 9.00 2.95 1.34 innodb drop_table 0.00 +100.00% 0.05 0.00 2.00 0.05 0.23 innodb drop_table_when_MANY_tables 16.00 +18.47% 3.63 11.00 90.00 19.63 7.67 innodb insert 114.00 -7.14% -7.60 3.00 343.00 106.40 14.82 innodb insert_autocommit 3.00 -0.36% -0.01 2.00 99.00 2.99 3.38 innodb insert_commit 2.00 -47.24% -0.64 1.00 3.00 1.36 0.49 innodb insert_duplicates 18.00 -17.60% -2.69 11.00 21.00 15.31 2.59 innodb insert_key 276.00 +9.26% 28.18 142.00 700.00 304.18 109.36 innodb insert_many_fields 5.00 +10.63% 0.59 3.00 17.00 5.59 1.80 innodb insert_rollback 2.00 -21.20% -0.35 1.00 3.00 1.65 0.53 innodb insert_select_1_key 4.00 -5.80% -0.22 2.00 10.00 3.78 0.90 innodb insert_select_2_keys 6.00 +1.14% 0.07 4.00 16.00 6.07 2.13 innodb min_max 9.00 -15.06% -1.18 6.00 110.00 7.82 4.63 innodb min_max_on_key 24.00 -17.84% -3.63 14.00 37.00 20.37 3.03 innodb multiple_value_insert 7.00 -29.31% -1.59 2.00 50.00 5.41 4.37 innodb once_prepared_select 30.00 -25.04% -6.01 18.00 32.00 23.99 3.49 innodb order_by_big 15.00 -4.90% -0.70 12.00 31.00 14.30 1.54 innodb order_by_big_key 14.00 -5.86% -0.77 11.00 32.00 13.23 1.63 innodb order_by_big_key2 14.00 -15.17% -1.84 10.00 33.00 12.16 1.55 innodb order_by_big_key_desc 15.00 -11.67% -1.57 11.00 32.00 13.43 1.67 innodb order_by_big_key_diff 14.00 -14.82% -1.81 10.00 31.00 12.19 1.51 innodb order_by_big_key_prefix 14.00 -13.22% -1.64 10.00 32.00 12.36 1.58 innodb order_by_key2_diff 2.00 -43.10% -0.60 1.00 3.00 1.40 0.49 innodb order_by_key_prefix 1.00 -26.92% -0.21 0.00 2.00 0.79 0.41 innodb order_by_range 1.00 -20.97% -0.17 0.00 2.00 0.83 0.38 innodb outer_join 25.00 -30.02% -5.77 15.00 61.00 19.23 3.73 innodb outer_join_found 25.00 -33.95% -6.34 14.00 58.00 18.66 3.58 innodb outer_join_not_found 22.00 -34.60% -5.66 12.00 46.00 16.34 3.16 innodb outer_join_on_key 17.00 -32.51% -4.17 10.00 59.00 12.83 2.79 innodb prepared_select 37.00 -19.14% -5.94 22.00 40.00 31.06 4.42 innodb select_1_row 4.00 -41.55% -1.17 2.00 4.00 2.83 0.69 innodb select_1_row_cache 3.00 -13.60% -0.36 2.00 4.00 2.64 0.67 innodb select_2_rows 4.00 -40.59% -1.15 2.00 4.00 2.85 0.69 innodb select_big 14.00 -15.41% -1.87 0.00 31.00 12.13 1.56 innodb select_big_str 1.00 +13.17% 0.15 0.00 2.00 1.15 0.36 innodb select_cache 63.00 -5.96% -3.54 49.00 77.00 59.46 5.63 innodb select_cache2 63.00 -5.22% -3.13 49.00 75.00 59.88 6.36 innodb select_column+column 4.00 -38.41% -1.11 2.00 4.00 2.89 0.70 innodb select_diff_key 0.00 +100.00% 0.22 0.00 1.00 0.22 0.41 innodb select_distinct 5.00 -18.31% -0.77 3.00 8.00 4.23 0.54 innodb select_group 18.00 -10.83% -1.76 4.00 136.00 16.24 5.54 innodb select_group_when_MANY_tables 12.00 -28.35% -2.65 3.00 49.00 9.35 9.64 innodb select_join 1.00 -73.01% -0.42 0.00 1.00 0.58 0.49 innodb select_key 64.00 -22.47% -11.74 40.00 66.00 52.26 7.22 innodb select_key2 72.00 -22.18% -13.07 45.00 75.00 58.93 8.10 innodb select_key2_return_key 68.00 -20.88% -11.75 42.00 70.00 56.25 7.88 innodb select_key2_return_prim 70.00 -22.78% -12.99 42.00 72.00 57.01 8.03 innodb select_key_prefix 70.00 -20.34% -11.83 44.00 75.00 58.17 8.10 innodb select_key_prefix_join 5.00 -6.30% -0.30 3.00 10.00 4.70 0.66 innodb select_key_return_key 63.00 -22.84% -11.71 38.00 65.00 51.29 7.23 innodb select_many_fields 14.00 +6.79% 1.02 11.00 19.00 15.02 1.79 innodb select_range 42.00 +11.16% 5.27 39.00 76.00 47.27 3.91 innodb select_range_key2 10.00 -21.88% -1.80 6.00 11.00 8.20 1.03 innodb select_range_prefix 9.00 -15.78% -1.23 5.00 10.00 7.77 1.08 innodb select_simple 2.00 -22.70% -0.37 1.00 3.00 1.63 0.51 innodb select_simple_cache 2.00 -30.34% -0.47 1.00 3.00 1.53 0.52 innodb select_simple_join 0.00 +100.00% 0.65 0.00 3.00 0.65 0.49 innodb update_autocommit 4.00 -20.67% -0.69 2.00 16.00 3.31 1.03 innodb update_big 59.00 -16.53% -8.37 31.00 195.00 50.63 24.93 innodb update_commit 2.00 -29.47% -0.46 1.00 10.00 1.54 0.74 innodb update_of_key 23.00 +5.39% 1.31 18.00 100.00 24.31 6.29 innodb update_of_key_big 29.00 -7.08% -1.92 15.00 75.00 27.08 11.03 innodb update_of_primary_key_many_keys 1334.00 -8.06% -99.52 647.00 6065.00 1234.48 985.52 innodb update_rollback 2.00 -14.64% -0.26 1.00 31.00 1.74 1.94 innodb update_with_key 124.00 -13.40% -14.66 90.00 598.00 109.34 21.08 innodb update_with_key_prefix 43.00 -9.12% -3.59 33.00 202.00 39.41 6.87 innodb wisc_benchmark 3.00 -21.35% -0.53 2.00 5.00 2.47 0.53 ========================================================================================================================= FULL REVISION COMMENTARY: 2154.2.24: Brian Aker 2011-02-13 Merge in all changes for current_session, etc. 2154.2.23: Brian Aker 2011-02-12 Remove dependency from session of error handler 2154.2.22: Brian Aker 2011-02-12 Shift CopyField out to its own file. 2154.2.21: Brian Aker 2011-02-12 sort includes 2154.2.20: Brian Aker 2011-02-12 Merge in bits for header cleanup. 2154.2.19: Brian Aker 2011-02-12 Remove need for current_session in include. 2154.2.18: Brian Aker 2011-02-12 Merge in all changes for include files. 2154.2.17: Brian Aker 2011-02-12 Additional removal of session _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
