======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 1082 RUN DATE: 2012-01-21T13:33:09.263165 SERVER: drizzled VERSION: staging REVISION: 2494 COMMENT: 2494: Mark Atwood 2012-01-20 [merge] merge lp:~daniel-nichter/drizzle/fix-bug-916567
========================================================================================================================= TRENDING OVER LAST 5 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 31.00 +3.13% 1.00 31.00 33.00 32.00 0.63 innodb alter_table_drop 25.00 -0.81% -0.20 23.00 26.00 24.80 0.98 innodb connect 2.00 +9.09% 0.20 2.00 3.00 2.20 0.40 innodb connect+select_1_row 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb connect+select_simple 3.00 -7.14% -0.20 2.00 3.00 2.80 0.40 innodb count 17.00 -1.19% -0.20 14.00 18.00 16.80 1.47 innodb count_distinct 7.00 -0.00% 0.00 6.00 8.00 7.00 0.63 innodb count_distinct_2 17.00 -19.72% -2.80 12.00 17.00 14.20 2.04 innodb count_distinct_big 25.00 -5.04% -1.20 20.00 25.00 23.80 1.94 innodb count_distinct_group 16.00 -6.67% -1.00 14.00 16.00 15.00 0.63 innodb count_distinct_group_on_key 11.00 -7.84% -0.80 9.00 11.00 10.20 0.75 innodb count_distinct_group_on_key_parts 15.00 -5.63% -0.80 13.00 15.00 14.20 0.75 innodb count_distinct_key_prefix 6.00 -25.00% -1.20 4.00 6.00 4.80 0.75 innodb count_group_on_key_parts 11.00 +3.51% 0.40 11.00 12.00 11.40 0.49 innodb count_on_key 98.00 -1.87% -1.80 94.00 98.00 96.20 1.33 innodb create+drop 33.00 +2.37% 0.80 33.00 35.00 33.80 0.75 innodb create_index 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb create_key+drop 35.00 -11.46% -3.60 30.00 35.00 31.40 1.85 innodb create_MANY_tables 21.00 +2.78% 0.60 20.00 24.00 21.60 1.36 innodb delete_all_many_keys 1123.00 -25.08% -225.20 801.00 1123.00 897.80 118.50 innodb delete_autocommit 4.00 -5.26% -0.20 3.00 4.00 3.80 0.40 innodb delete_big 0.00 +100.00% 0.40 0.00 1.00 0.40 0.49 innodb delete_big_many_keys 1122.00 -25.06% -224.80 801.00 1122.00 897.20 118.18 innodb delete_commit 2.00 -11.11% -0.20 1.00 2.00 1.80 0.40 innodb delete_key 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb delete_range 8.00 -0.00% 0.00 8.00 8.00 8.00 0.00 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 21.00 -8.25% -1.60 18.00 21.00 19.40 1.02 innodb insert 115.00 -0.88% -1.00 112.00 115.00 114.00 1.10 innodb insert_autocommit 4.00 -17.65% -0.60 3.00 4.00 3.40 0.49 innodb insert_commit 2.00 -11.11% -0.20 1.00 2.00 1.80 0.40 innodb insert_duplicates 20.00 -0.00% 0.00 19.00 21.00 20.00 0.63 innodb insert_key 281.00 +0.35% 1.00 280.00 283.00 282.00 1.26 innodb insert_many_fields 5.00 +7.41% 0.40 5.00 6.00 5.40 0.49 innodb insert_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb insert_select_1_key 5.00 -4.17% -0.20 4.00 5.00 4.80 0.40 innodb insert_select_2_keys 7.00 -2.94% -0.20 6.00 7.00 6.80 0.40 innodb min_max 8.00 +4.76% 0.40 7.00 9.00 8.40 0.80 innodb min_max_on_key 25.00 -0.81% -0.20 24.00 25.00 24.80 0.40 innodb multiple_value_insert 5.00 +7.41% 0.40 5.00 6.00 5.40 0.49 innodb once_prepared_select 29.00 +0.68% 0.20 29.00 30.00 29.20 0.40 innodb order_by_big 13.00 +2.99% 0.40 13.00 14.00 13.40 0.49 innodb order_by_big_key 14.00 +5.41% 0.80 13.00 16.00 14.80 1.17 innodb order_by_big_key2 13.00 -6.56% -0.80 12.00 13.00 12.20 0.40 innodb order_by_big_key_desc 13.00 +8.45% 1.20 13.00 16.00 14.20 1.17 innodb order_by_big_key_diff 11.00 +6.78% 0.80 11.00 13.00 11.80 0.75 innodb order_by_big_key_prefix 13.00 -3.17% -0.40 12.00 13.00 12.60 0.49 innodb order_by_key2_diff 1.00 +16.67% 0.20 1.00 2.00 1.20 0.40 innodb order_by_key_prefix 1.00 -25.00% -0.20 0.00 1.00 0.80 0.40 innodb order_by_range 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb outer_join 23.00 -9.52% -2.00 17.00 24.00 21.00 2.61 innodb outer_join_found 23.00 -12.75% -2.60 17.00 23.00 20.40 2.42 innodb outer_join_not_found 20.00 -12.36% -2.20 15.00 21.00 17.80 2.32 innodb outer_join_on_key 14.00 -4.48% -0.60 11.00 15.00 13.40 1.62 innodb prepared_select 37.00 +0.54% 0.20 37.00 38.00 37.20 0.40 innodb select_1_row 3.00 +11.76% 0.40 3.00 4.00 3.40 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 -5.26% -0.20 3.00 4.00 3.80 0.40 innodb select_big 12.00 +9.09% 1.20 12.00 14.00 13.20 0.98 innodb select_big_str 2.00 -42.86% -0.60 1.00 2.00 1.40 0.49 innodb select_cache 63.00 +3.67% 2.40 61.00 79.00 65.40 6.86 innodb select_cache2 71.00 -1.43% -1.00 62.00 88.00 70.00 9.53 innodb select_column+column 3.00 +21.05% 0.80 3.00 4.00 3.80 0.40 innodb select_diff_key 1.00 -66.67% -0.40 0.00 1.00 0.60 0.49 innodb select_distinct 4.00 +4.76% 0.20 4.00 5.00 4.20 0.40 innodb select_group 19.00 +1.04% 0.20 18.00 20.00 19.20 0.75 innodb select_group_when_MANY_tables 12.00 -0.00% 0.00 11.00 13.00 12.00 0.63 innodb select_join 1.00 -25.00% -0.20 0.00 1.00 0.80 0.40 innodb select_key 65.00 -0.93% -0.60 64.00 65.00 64.40 0.49 innodb select_key2 71.00 +0.84% 0.60 71.00 72.00 71.60 0.49 innodb select_key2_return_key 69.00 +0.29% 0.20 68.00 71.00 69.20 0.98 innodb select_key2_return_prim 70.00 -0.29% -0.20 69.00 70.00 69.80 0.40 innodb select_key_prefix 71.00 +0.56% 0.40 70.00 72.00 71.40 0.80 innodb select_key_prefix_join 5.00 -0.00% 0.00 5.00 5.00 5.00 0.00 innodb select_key_return_key 64.00 -0.00% 0.00 63.00 65.00 64.00 0.63 innodb select_many_fields 13.00 +1.52% 0.20 13.00 14.00 13.20 0.40 innodb select_range 46.00 -6.98% -3.00 41.00 46.00 43.00 1.79 innodb select_range_key2 10.00 -4.17% -0.40 9.00 10.00 9.60 0.49 innodb select_range_prefix 8.00 +9.09% 0.80 8.00 10.00 8.80 0.75 innodb select_simple 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb select_simple_cache 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb select_simple_join 1.00 -25.00% -0.20 0.00 1.00 0.80 0.40 innodb update_autocommit 3.00 +11.76% 0.40 3.00 4.00 3.40 0.49 innodb update_big 56.00 +4.11% 2.40 56.00 61.00 58.40 1.74 innodb update_commit 2.00 +9.09% 0.20 2.00 3.00 2.20 0.40 innodb update_of_key 23.00 -5.50% -1.20 21.00 23.00 21.80 0.75 innodb update_of_key_big 20.00 -1.01% -0.20 19.00 20.00 19.80 0.40 innodb update_of_primary_key_many_keys 1281.00 +0.44% 5.60 1260.00 1320.00 1286.60 21.76 innodb update_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_with_key 122.00 -2.18% -2.60 118.00 122.00 119.40 1.50 innodb update_with_key_prefix 43.00 +0.46% 0.20 42.00 45.00 43.20 0.98 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 31.00 +2.97% 0.95 30.00 33.00 31.95 0.74 innodb alter_table_drop 25.00 -0.60% -0.15 23.00 26.00 24.85 0.79 innodb connect 2.00 +4.76% 0.10 2.00 3.00 2.10 0.30 innodb connect+select_1_row 3.00 -5.26% -0.15 2.00 3.00 2.85 0.36 innodb connect+select_simple 3.00 -11.11% -0.30 2.00 3.00 2.70 0.46 innodb count 17.00 -5.26% -0.85 13.00 19.00 16.15 2.03 innodb count_distinct 7.00 +0.71% 0.05 6.00 8.00 7.05 0.74 innodb count_distinct_2 17.00 -21.43% -3.00 12.00 17.00 14.00 1.41 innodb count_distinct_big 25.00 -8.46% -1.95 20.00 26.00 23.05 2.18 innodb count_distinct_group 16.00 -6.67% -1.00 12.00 18.00 15.00 1.10 innodb count_distinct_group_on_key 11.00 -11.11% -1.10 8.00 12.00 9.90 0.99 innodb count_distinct_group_on_key_parts 15.00 -10.29% -1.40 11.00 15.00 13.60 1.20 innodb count_distinct_key_prefix 6.00 -18.81% -0.95 4.00 6.00 5.05 0.67 innodb count_group_on_key_parts 11.00 -0.46% -0.05 10.00 12.00 10.95 0.67 innodb count_on_key 98.00 -2.51% -2.40 91.00 104.00 95.60 3.10 innodb create+drop 33.00 +1.64% 0.55 32.00 35.00 33.55 0.74 innodb create_index 3.00 +3.23% 0.10 3.00 4.00 3.10 0.30 innodb create_key+drop 35.00 -10.06% -3.20 30.00 35.00 31.80 1.54 innodb create_MANY_tables 21.00 +1.87% 0.40 20.00 24.00 21.40 0.92 innodb delete_all_many_keys 1123.00 -24.40% -220.25 749.00 1123.00 902.75 111.16 innodb delete_autocommit 4.00 -8.11% -0.30 3.00 4.00 3.70 0.46 innodb delete_big 0.00 +100.00% 0.15 0.00 1.00 0.15 0.36 innodb delete_big_many_keys 1122.00 -24.36% -219.80 749.00 1122.00 902.20 110.93 innodb delete_commit 2.00 -5.26% -0.10 1.00 2.00 1.90 0.30 innodb delete_key 3.00 -3.45% -0.10 2.00 3.00 2.90 0.30 innodb delete_range 8.00 -1.27% -0.10 7.00 9.00 7.90 0.54 innodb delete_rollback 2.00 +4.76% 0.10 2.00 3.00 2.10 0.30 innodb drop_index 3.00 -0.00% 0.00 2.00 4.00 3.00 0.45 innodb drop_table 0.00 +100.00% 0.05 0.00 1.00 0.05 0.22 innodb drop_table_when_MANY_tables 21.00 -8.81% -1.70 18.00 21.00 19.30 0.90 innodb insert 115.00 -0.79% -0.90 112.00 116.00 114.10 1.04 innodb insert_autocommit 4.00 -21.21% -0.70 3.00 4.00 3.30 0.46 innodb insert_commit 2.00 -11.11% -0.20 1.00 2.00 1.80 0.40 innodb insert_duplicates 20.00 -1.52% -0.30 19.00 21.00 19.70 0.56 innodb insert_key 281.00 +1.82% 5.20 271.00 297.00 286.20 6.38 innodb insert_many_fields 5.00 +9.91% 0.55 5.00 6.00 5.55 0.50 innodb insert_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb insert_select_1_key 5.00 -4.17% -0.20 3.00 6.00 4.80 0.68 innodb insert_select_2_keys 7.00 -8.53% -0.55 6.00 7.00 6.45 0.50 innodb min_max 8.00 +2.44% 0.20 7.00 9.00 8.20 0.93 innodb min_max_on_key 25.00 -0.60% -0.15 24.00 26.00 24.85 0.73 innodb multiple_value_insert 5.00 +9.91% 0.55 5.00 6.00 5.55 0.50 innodb once_prepared_select 29.00 +0.85% 0.25 29.00 30.00 29.25 0.43 innodb order_by_big 13.00 +5.45% 0.75 12.00 16.00 13.75 1.04 innodb order_by_big_key 14.00 +2.78% 0.40 12.00 16.00 14.40 1.32 innodb order_by_big_key2 13.00 -4.00% -0.50 11.00 14.00 12.50 0.87 innodb order_by_big_key_desc 13.00 +12.75% 1.90 13.00 16.00 14.90 1.04 innodb order_by_big_key_diff 11.00 +12.35% 1.55 11.00 14.00 12.55 0.97 innodb order_by_big_key_prefix 13.00 -0.39% -0.05 11.00 14.00 12.95 0.92 innodb order_by_key2_diff 1.00 +20.00% 0.25 1.00 2.00 1.25 0.43 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 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb outer_join 23.00 -3.84% -0.85 17.00 26.00 22.15 2.80 innodb outer_join_found 23.00 -9.79% -2.05 17.00 24.00 20.95 2.50 innodb outer_join_not_found 20.00 -5.82% -1.10 15.00 22.00 18.90 2.61 innodb outer_join_on_key 14.00 -1.82% -0.25 11.00 16.00 13.75 1.67 innodb prepared_select 37.00 +0.67% 0.25 36.00 38.00 37.25 0.54 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 -8.11% -0.30 3.00 4.00 3.70 0.46 innodb select_2_rows 4.00 -6.67% -0.25 3.00 4.00 3.75 0.43 innodb select_big 12.00 +7.34% 0.95 11.00 14.00 12.95 1.07 innodb select_big_str 2.00 -37.93% -0.55 1.00 2.00 1.45 0.50 innodb select_cache 63.00 +1.49% 0.95 54.00 79.00 63.95 5.32 innodb select_cache2 71.00 -6.05% -4.05 60.00 88.00 66.95 5.69 innodb select_column+column 3.00 +21.05% 0.80 3.00 4.00 3.80 0.40 innodb select_diff_key 1.00 -300.00% -0.75 0.00 1.00 0.25 0.43 innodb select_distinct 4.00 +13.04% 0.60 4.00 5.00 4.60 0.49 innodb select_group 19.00 -6.74% -1.20 15.00 20.00 17.80 1.47 innodb select_group_when_MANY_tables 12.00 +0.83% 0.10 11.00 14.00 12.10 0.70 innodb select_join 1.00 -33.33% -0.25 0.00 1.00 0.75 0.43 innodb select_key 65.00 -0.54% -0.35 63.00 67.00 64.65 0.85 innodb select_key2 71.00 +0.70% 0.50 70.00 74.00 71.50 0.92 innodb select_key2_return_key 69.00 -0.07% -0.05 68.00 71.00 68.95 0.92 innodb select_key2_return_prim 70.00 -0.36% -0.25 69.00 72.00 69.75 0.83 innodb select_key_prefix 71.00 +0.21% 0.15 70.00 73.00 71.15 0.85 innodb select_key_prefix_join 5.00 +10.71% 0.60 5.00 7.00 5.60 0.66 innodb select_key_return_key 64.00 -0.55% -0.35 63.00 66.00 63.65 0.79 innodb select_many_fields 13.00 +2.99% 0.40 13.00 17.00 13.40 0.92 innodb select_range 46.00 -7.23% -3.10 39.00 49.00 42.90 2.59 innodb select_range_key2 10.00 -4.17% -0.40 9.00 11.00 9.60 0.58 innodb select_range_prefix 8.00 +12.57% 1.15 8.00 10.00 9.15 0.65 innodb select_simple 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb select_simple_cache 2.00 +6.98% 0.15 2.00 3.00 2.15 0.36 innodb select_simple_join 1.00 -33.33% -0.25 0.00 1.00 0.75 0.43 innodb update_autocommit 3.00 +10.45% 0.35 3.00 4.00 3.35 0.48 innodb update_big 56.00 +3.70% 2.15 56.00 61.00 58.15 1.46 innodb update_commit 2.00 +2.44% 0.05 2.00 3.00 2.05 0.22 innodb update_of_key 23.00 -2.22% -0.50 21.00 25.00 22.50 0.97 innodb update_of_key_big 20.00 -4.99% -0.95 17.00 21.00 19.05 0.97 innodb update_of_primary_key_many_keys 1281.00 +0.87% 11.25 1173.00 1452.00 1292.25 49.66 innodb update_rollback 2.00 +2.44% 0.05 2.00 3.00 2.05 0.22 innodb update_with_key 122.00 -1.84% -2.20 116.00 122.00 119.80 1.50 innodb update_with_key_prefix 43.00 -0.23% -0.10 40.00 46.00 42.90 1.41 innodb wisc_benchmark 3.00 -15.38% -0.40 2.00 3.00 2.60 0.49 ========================================================================================================================= TRENDING OVER ALL runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 31.00 -36.91% -8.36 11.00 61.00 22.64 10.12 innodb alter_table_drop 25.00 -30.06% -5.78 10.00 57.00 19.22 6.75 innodb connect 2.00 +4.86% 0.10 1.00 3.00 2.10 0.42 innodb connect+select_1_row 3.00 -9.68% -0.26 2.00 5.00 2.74 0.45 innodb connect+select_simple 3.00 -25.84% -0.62 1.00 3.00 2.38 0.49 innodb count 17.00 -7.77% -1.23 12.00 193.00 15.77 8.19 innodb count_distinct 7.00 -5.75% -0.38 5.00 50.00 6.62 2.13 innodb count_distinct_2 17.00 -28.07% -3.73 11.00 63.00 13.27 2.79 innodb count_distinct_big 25.00 -13.21% -2.92 5.00 67.00 22.08 2.91 innodb count_distinct_group 16.00 -19.90% -2.66 10.00 68.00 13.34 2.93 innodb count_distinct_group_on_key 11.00 -15.24% -1.45 7.00 69.00 9.55 2.82 innodb count_distinct_group_on_key_parts 15.00 -20.47% -2.55 9.00 72.00 12.45 2.97 innodb count_distinct_key_prefix 6.00 -16.39% -0.85 3.00 52.00 5.15 2.22 innodb count_group_on_key_parts 11.00 -8.50% -0.86 7.00 72.00 10.14 2.95 innodb count_on_key 98.00 -12.26% -10.70 68.00 107.00 87.30 7.58 innodb create+drop 33.00 -1.40% -0.46 18.00 75.00 32.54 10.99 innodb create_index 3.00 -2.89% -0.08 1.00 8.00 2.92 1.07 innodb create_key+drop 35.00 -22.07% -6.33 21.00 50.00 28.67 4.71 innodb create_MANY_tables 21.00 +34.65% 11.13 14.00 121.00 32.13 16.48 innodb create_table 0.00 +100.00% 0.10 0.00 3.00 0.10 0.34 innodb delete_all_many_keys 1123.00 -119.55% -611.50 212.00 1888.00 511.50 358.59 innodb delete_autocommit 4.00 -15.35% -0.53 2.00 14.00 3.47 0.72 innodb delete_big 0.00 +100.00% 0.31 0.00 3.00 0.31 0.47 innodb delete_big_many_keys 1122.00 -117.26% -605.56 212.00 2293.00 516.44 370.19 innodb delete_commit 2.00 -27.79% -0.43 1.00 5.00 1.57 0.52 innodb delete_key 3.00 +0.82% 0.02 2.00 35.00 3.02 1.39 innodb delete_range 8.00 +3.78% 0.31 5.00 23.00 8.31 3.00 innodb delete_rollback 2.00 -11.89% -0.21 1.00 12.00 1.79 0.86 innodb drop_index 3.00 -1.37% -0.04 1.00 9.00 2.96 1.23 innodb drop_table 0.00 +100.00% 0.04 0.00 2.00 0.04 0.22 innodb drop_table_when_MANY_tables 21.00 -7.88% -1.53 11.00 90.00 19.47 6.97 innodb insert 115.00 -6.84% -7.37 3.00 343.00 107.63 13.69 innodb insert_autocommit 4.00 -32.33% -0.98 2.00 99.00 3.02 3.07 innodb insert_commit 2.00 -38.32% -0.55 1.00 3.00 1.45 0.50 innodb insert_duplicates 20.00 -24.90% -3.99 11.00 21.00 16.01 2.80 innodb insert_key 281.00 +6.23% 18.68 142.00 700.00 299.68 98.64 innodb insert_many_fields 5.00 +11.14% 0.63 3.00 17.00 5.63 1.65 innodb insert_rollback 2.00 -16.48% -0.28 1.00 3.00 1.72 0.51 innodb insert_select_1_key 5.00 -28.64% -1.11 2.00 10.00 3.89 0.91 innodb insert_select_2_keys 7.00 -14.71% -0.90 4.00 16.00 6.10 1.95 innodb min_max 8.00 -1.90% -0.15 6.00 110.00 7.85 4.22 innodb min_max_on_key 25.00 -18.31% -3.87 14.00 37.00 21.13 3.20 innodb multiple_value_insert 5.00 +9.69% 0.54 2.00 50.00 5.54 3.98 innodb once_prepared_select 29.00 -16.45% -4.10 18.00 32.00 24.90 3.71 innodb order_by_big 13.00 +8.97% 1.28 12.00 31.00 14.28 1.47 innodb order_by_big_key 14.00 -4.30% -0.58 11.00 32.00 13.42 1.64 innodb order_by_big_key2 13.00 -5.76% -0.71 10.00 33.00 12.29 1.49 innodb order_by_big_key_desc 13.00 +5.18% 0.71 11.00 32.00 13.71 1.69 innodb order_by_big_key_diff 11.00 +10.76% 1.33 10.00 31.00 12.33 1.45 innodb order_by_big_key_prefix 13.00 -4.05% -0.51 10.00 32.00 12.49 1.49 innodb order_by_key2_diff 1.00 +28.50% 0.40 1.00 3.00 1.40 0.49 innodb order_by_key_prefix 1.00 -24.35% -0.20 0.00 2.00 0.80 0.40 innodb order_by_range 1.00 -18.49% -0.16 0.00 2.00 0.84 0.37 innodb outer_join 23.00 -16.56% -3.27 15.00 61.00 19.73 3.70 innodb outer_join_found 23.00 -20.47% -3.91 14.00 58.00 19.09 3.53 innodb outer_join_not_found 20.00 -18.74% -3.16 12.00 46.00 16.84 3.20 innodb outer_join_on_key 14.00 -6.83% -0.89 10.00 59.00 13.11 2.69 innodb prepared_select 37.00 -15.15% -4.87 22.00 40.00 32.13 4.62 innodb select_1_row 3.00 -1.54% -0.05 2.00 4.00 2.95 0.71 innodb select_1_row_cache 4.00 -42.88% -1.20 2.00 4.00 2.80 0.72 innodb select_2_rows 4.00 -33.82% -1.01 2.00 4.00 2.99 0.73 innodb select_big 12.00 +1.96% 0.24 0.00 31.00 12.24 1.50 innodb select_big_str 2.00 -67.35% -0.80 0.00 2.00 1.20 0.40 innodb select_cache 63.00 -4.47% -2.69 49.00 79.00 60.31 5.67 innodb select_cache2 71.00 -16.81% -10.22 49.00 88.00 60.78 6.35 innodb select_column+column 3.00 +1.56% 0.05 2.00 4.00 3.05 0.74 innodb select_diff_key 1.00 -347.11% -0.78 0.00 1.00 0.22 0.42 innodb select_distinct 4.00 +6.73% 0.29 3.00 8.00 4.29 0.55 innodb select_group 19.00 -16.07% -2.63 4.00 136.00 16.37 5.06 innodb select_group_when_MANY_tables 12.00 -22.18% -2.18 3.00 49.00 9.82 8.79 innodb select_join 1.00 -68.84% -0.41 0.00 1.00 0.59 0.49 innodb select_key 65.00 -19.56% -10.64 40.00 67.00 54.36 7.94 innodb select_key2 71.00 -16.26% -9.93 45.00 75.00 61.07 8.65 innodb select_key2_return_key 69.00 -18.10% -10.58 42.00 71.00 58.42 8.51 innodb select_key2_return_prim 70.00 -18.27% -10.82 42.00 72.00 59.18 8.63 innodb select_key_prefix 71.00 -17.59% -10.62 44.00 75.00 60.38 8.73 innodb select_key_prefix_join 5.00 -4.15% -0.20 3.00 10.00 4.80 0.66 innodb select_key_return_key 64.00 -19.91% -10.63 38.00 66.00 53.37 7.93 innodb select_many_fields 13.00 +11.59% 1.70 11.00 19.00 14.70 1.77 innodb select_range 46.00 +1.26% 0.59 38.00 76.00 46.59 4.06 innodb select_range_key2 10.00 -18.41% -1.55 6.00 11.00 8.45 1.09 innodb select_range_prefix 8.00 +0.46% 0.04 5.00 10.00 8.04 1.16 innodb select_simple 2.00 -17.21% -0.29 1.00 3.00 1.71 0.50 innodb select_simple_cache 2.00 -23.08% -0.38 1.00 3.00 1.63 0.51 innodb select_simple_join 1.00 -49.11% -0.33 0.00 3.00 0.67 0.48 innodb update_autocommit 3.00 +10.49% 0.35 2.00 16.00 3.35 0.96 innodb update_big 56.00 -7.52% -3.92 31.00 195.00 52.08 22.80 innodb update_commit 2.00 -23.41% -0.38 1.00 10.00 1.62 0.69 innodb update_of_key 23.00 +3.94% 0.94 18.00 100.00 23.94 5.76 innodb update_of_key_big 20.00 +26.66% 7.27 15.00 75.00 27.27 10.69 innodb update_of_primary_key_many_keys 1281.00 -2.35% -29.36 647.00 6065.00 1251.64 870.06 innodb update_rollback 2.00 -10.90% -0.20 1.00 31.00 1.80 1.76 innodb update_with_key 122.00 -9.60% -10.68 90.00 598.00 111.32 19.58 innodb update_with_key_prefix 43.00 -7.03% -2.83 33.00 202.00 40.17 6.49 innodb wisc_benchmark 3.00 -20.60% -0.51 2.00 5.00 2.49 0.52 ========================================================================================================================= FULL REVISION COMMENTARY: 2491.1.1: Daniel Nichter 2012-01-14 Remove invalid semicolon from end of while(). _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
