======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 972 RUN DATE: 2011-03-23T20:54:27.675257 SERVER: drizzled VERSION: staging REVISION: 2249 COMMENT: 2249: Lee Bieber 2011-03-23 [merge] Merge Patrick - Shortens socket file path length
========================================================================================================================= 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 31.00 34.00 32.20 0.98 innodb alter_table_drop 23.00 -0.00% 0.00 22.00 24.00 23.00 0.63 innodb connect 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 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 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb count 17.00 -13.33% -2.00 13.00 17.00 15.00 1.67 innodb count_distinct 8.00 -8.11% -0.60 7.00 8.00 7.40 0.49 innodb count_distinct_2 13.00 +2.99% 0.40 11.00 16.00 13.40 1.85 innodb count_distinct_big 24.00 -7.14% -1.60 21.00 25.00 22.40 1.74 innodb count_distinct_group 16.00 -9.59% -1.40 13.00 16.00 14.60 1.02 innodb count_distinct_group_on_key 11.00 -7.84% -0.80 9.00 12.00 10.20 1.17 innodb count_distinct_group_on_key_parts 14.00 -2.94% -0.40 11.00 15.00 13.60 1.36 innodb count_distinct_key_prefix 5.00 +10.71% 0.60 5.00 6.00 5.60 0.49 innodb count_group_on_key_parts 11.00 -7.84% -0.80 10.00 11.00 10.20 0.40 innodb count_on_key 96.00 -2.13% -2.00 91.00 96.00 94.00 2.10 innodb create+drop 34.00 -3.03% -1.00 32.00 34.00 33.00 0.89 innodb create_index 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb create_key+drop 30.00 +1.96% 0.60 30.00 31.00 30.60 0.49 innodb create_MANY_tables 20.00 +8.26% 1.80 20.00 24.00 21.80 1.60 innodb delete_all_many_keys 647.00 -1.41% -9.00 582.00 705.00 638.00 41.36 innodb delete_autocommit 5.00 -25.00% -1.00 3.00 5.00 4.00 0.63 innodb delete_big 1.00 -66.67% -0.40 0.00 1.00 0.60 0.49 innodb delete_big_many_keys 646.00 -1.41% -9.00 581.00 704.00 637.00 41.36 innodb delete_commit 2.00 -11.11% -0.20 1.00 2.00 1.80 0.40 innodb delete_key 3.00 -15.38% -0.40 2.00 3.00 2.60 0.49 innodb delete_range 8.00 +4.76% 0.40 8.00 9.00 8.40 0.49 innodb delete_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb drop_index 4.00 -25.00% -0.80 3.00 4.00 3.20 0.40 innodb drop_table_when_MANY_tables 18.00 +4.26% 0.80 17.00 21.00 18.80 1.33 innodb insert 113.00 +1.22% 1.40 113.00 116.00 114.40 1.02 innodb insert_autocommit 3.00 +6.25% 0.20 3.00 4.00 3.20 0.40 innodb insert_commit 2.00 -25.00% -0.40 1.00 2.00 1.60 0.49 innodb insert_duplicates 19.00 +1.04% 0.20 19.00 20.00 19.20 0.40 innodb insert_key 272.00 +2.23% 6.20 267.00 296.00 278.20 9.83 innodb insert_many_fields 7.00 -12.90% -0.80 6.00 7.00 6.20 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 -11.11% -0.40 3.00 5.00 3.60 0.80 innodb insert_select_2_keys 6.00 +3.23% 0.20 5.00 7.00 6.20 0.75 innodb min_max 8.00 -2.56% -0.20 7.00 9.00 7.80 0.75 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 -9.38% -0.60 6.00 7.00 6.40 0.49 innodb once_prepared_select 28.00 +4.11% 1.20 28.00 30.00 29.20 0.75 innodb order_by_big 13.00 +5.80% 0.80 13.00 15.00 13.80 0.98 innodb order_by_big_key 15.00 -10.29% -1.40 13.00 15.00 13.60 0.80 innodb order_by_big_key2 12.00 +4.76% 0.60 11.00 14.00 12.60 1.20 innodb order_by_big_key_desc 15.00 -10.29% -1.40 13.00 15.00 13.60 0.80 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 -9.38% -1.20 12.00 14.00 12.80 0.98 innodb order_by_key2_diff 2.00 -42.86% -0.60 1.00 2.00 1.40 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 0.00 +100.00% 0.80 0.00 1.00 0.80 0.40 innodb outer_join 24.00 -14.29% -3.00 18.00 24.00 21.00 2.19 innodb outer_join_found 22.00 -10.00% -2.00 17.00 22.00 20.00 2.10 innodb outer_join_not_found 21.00 -12.90% -2.40 16.00 21.00 18.60 1.85 innodb outer_join_on_key 15.00 -10.29% -1.40 12.00 15.00 13.60 1.36 innodb prepared_select 37.00 -0.00% 0.00 37.00 37.00 37.00 0.00 innodb select_1_row 4.00 -0.00% 0.00 4.00 4.00 4.00 0.00 innodb select_1_row_cache 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb select_2_rows 4.00 -0.00% 0.00 4.00 4.00 4.00 0.00 innodb select_big 14.00 -14.75% -1.80 11.00 14.00 12.20 1.17 innodb select_big_str 1.00 +28.57% 0.40 1.00 2.00 1.40 0.49 innodb select_cache 65.00 -3.17% -2.00 61.00 65.00 63.00 1.67 innodb select_cache2 64.00 -0.31% -0.20 60.00 66.00 63.80 2.04 innodb select_column+column 4.00 -5.26% -0.20 3.00 4.00 3.80 0.40 innodb select_distinct 4.00 +13.04% 0.60 4.00 5.00 4.60 0.49 innodb select_group 19.00 -5.56% -1.00 16.00 19.00 18.00 1.10 innodb select_group_when_MANY_tables 12.00 -5.26% -0.60 10.00 12.00 11.40 0.80 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 63.00 65.00 64.20 0.75 innodb select_key2 71.00 +0.28% 0.20 71.00 72.00 71.20 0.40 innodb select_key2_return_key 68.00 +0.58% 0.40 67.00 70.00 68.40 1.02 innodb select_key2_return_prim 69.00 +0.58% 0.40 69.00 70.00 69.40 0.49 innodb select_key_prefix 70.00 +1.13% 0.80 70.00 72.00 70.80 0.75 innodb select_key_prefix_join 5.00 +10.71% 0.60 5.00 6.00 5.60 0.49 innodb select_key_return_key 63.00 +0.32% 0.20 63.00 64.00 63.20 0.40 innodb select_many_fields 13.00 +1.52% 0.20 13.00 14.00 13.20 0.40 innodb select_range 46.00 -5.02% -2.20 39.00 47.00 43.80 3.19 innodb select_range_key2 10.00 -6.38% -0.60 9.00 10.00 9.40 0.49 innodb select_range_prefix 9.00 +6.25% 0.60 9.00 10.00 9.60 0.49 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 59.00 +0.67% 0.40 56.00 62.00 59.40 2.06 innodb update_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_of_key 22.00 -1.85% -0.40 21.00 22.00 21.60 0.49 innodb update_of_key_big 35.00 +1.13% 0.40 30.00 39.00 35.40 3.01 innodb update_of_primary_key_many_keys 1324.00 +0.42% 5.60 1232.00 1469.00 1329.60 77.79 innodb update_rollback 2.00 +9.09% 0.20 2.00 3.00 2.20 0.40 innodb update_with_key 123.00 -0.00% 0.00 121.00 127.00 123.00 2.10 innodb update_with_key_prefix 46.00 -3.60% -1.60 42.00 46.00 44.40 1.36 innodb wisc_benchmark 2.00 +23.08% 0.60 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 +0.62% 0.20 26.00 34.00 32.20 1.94 innodb alter_table_drop 23.00 +1.92% 0.45 22.00 25.00 23.45 0.80 innodb connect 2.00 +6.98% 0.15 2.00 3.00 2.15 0.36 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 -11.11% -0.30 2.00 3.00 2.70 0.46 innodb count 17.00 -11.48% -1.75 13.00 19.00 15.25 1.87 innodb count_distinct 8.00 -17.65% -1.20 6.00 8.00 6.80 0.75 innodb count_distinct_2 13.00 +4.41% 0.60 11.00 16.00 13.60 1.28 innodb count_distinct_big 24.00 -5.73% -1.30 21.00 25.00 22.70 1.82 innodb count_distinct_group 16.00 -9.59% -1.40 11.00 16.00 14.60 1.16 innodb count_distinct_group_on_key 11.00 -12.24% -1.20 8.00 12.00 9.80 1.03 innodb count_distinct_group_on_key_parts 14.00 -5.26% -0.70 11.00 15.00 13.30 1.19 innodb count_distinct_key_prefix 5.00 +8.26% 0.45 4.00 6.00 5.45 0.67 innodb count_group_on_key_parts 11.00 -1.38% -0.15 10.00 12.00 10.85 0.65 innodb count_on_key 96.00 -2.35% -2.20 91.00 97.00 93.80 1.91 innodb create+drop 34.00 -2.72% -0.90 31.00 35.00 33.10 0.99 innodb create_index 3.00 +4.76% 0.15 3.00 4.00 3.15 0.36 innodb create_key+drop 30.00 +3.69% 1.15 30.00 34.00 31.15 1.01 innodb create_MANY_tables 20.00 +5.66% 1.20 19.00 24.00 21.20 1.36 innodb delete_all_many_keys 647.00 -1.23% -7.85 582.00 705.00 639.15 24.77 innodb delete_autocommit 5.00 -38.89% -1.40 3.00 5.00 3.60 0.58 innodb delete_big 1.00 -150.00% -0.60 0.00 1.00 0.40 0.49 innodb delete_big_many_keys 646.00 -1.19% -7.60 581.00 704.00 638.40 24.75 innodb delete_commit 2.00 -8.11% -0.15 1.00 2.00 1.85 0.36 innodb delete_key 3.00 -9.09% -0.25 2.00 4.00 2.75 0.54 innodb delete_range 8.00 +4.76% 0.40 7.00 10.00 8.40 0.66 innodb delete_rollback 2.00 +4.76% 0.10 2.00 3.00 2.10 0.30 innodb drop_index 4.00 -33.33% -1.00 2.00 4.00 3.00 0.45 innodb drop_table_when_MANY_tables 18.00 +3.23% 0.60 17.00 21.00 18.60 0.97 innodb insert 113.00 +0.62% 0.70 111.00 116.00 113.70 1.27 innodb insert_autocommit 3.00 +4.76% 0.15 3.00 4.00 3.15 0.36 innodb insert_commit 2.00 -5.26% -0.10 1.00 2.00 1.90 0.30 innodb insert_duplicates 19.00 +1.04% 0.20 19.00 20.00 19.20 0.40 innodb insert_key 272.00 +2.35% 6.55 267.00 296.00 278.55 7.33 innodb insert_many_fields 7.00 -18.64% -1.10 5.00 7.00 5.90 0.44 innodb insert_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb insert_select_1_key 4.00 -2.56% -0.10 3.00 5.00 3.90 0.70 innodb insert_select_2_keys 6.00 +2.44% 0.15 5.00 8.00 6.15 0.73 innodb min_max 8.00 -5.96% -0.45 6.00 10.00 7.55 0.97 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 -6.06% -0.40 6.00 7.00 6.60 0.49 innodb once_prepared_select 28.00 +3.61% 1.05 28.00 31.00 29.05 0.74 innodb order_by_big 13.00 +6.47% 0.90 13.00 16.00 13.90 1.14 innodb order_by_big_key 15.00 -6.76% -0.95 12.00 16.00 14.05 1.47 innodb order_by_big_key2 12.00 +3.61% 0.45 11.00 14.00 12.45 0.86 innodb order_by_big_key_desc 15.00 -1.35% -0.20 13.00 16.00 14.80 1.21 innodb order_by_big_key_diff 14.00 -7.69% -1.00 11.00 14.00 13.00 0.84 innodb order_by_big_key_prefix 14.00 -9.80% -1.25 12.00 14.00 12.75 0.89 innodb order_by_key2_diff 2.00 -42.86% -0.60 1.00 2.00 1.40 0.49 innodb order_by_key_prefix 1.00 -17.65% -0.15 0.00 1.00 0.85 0.36 innodb order_by_range 0.00 +100.00% 0.85 0.00 1.00 0.85 0.36 innodb outer_join 24.00 -7.87% -1.75 18.00 26.00 22.25 2.70 innodb outer_join_found 22.00 -3.29% -0.70 17.00 26.00 21.30 2.78 innodb outer_join_not_found 21.00 -8.53% -1.65 16.00 23.00 19.35 2.20 innodb outer_join_on_key 15.00 -0.00% 0.00 12.00 18.00 15.00 2.12 innodb prepared_select 37.00 +0.40% 0.15 37.00 39.00 37.15 0.48 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 -8.11% -0.30 3.00 4.00 3.70 0.46 innodb select_big 14.00 -11.55% -1.45 11.00 14.00 12.55 1.07 innodb select_big_str 1.00 +20.00% 0.25 1.00 2.00 1.25 0.43 innodb select_cache 65.00 -3.42% -2.15 58.00 71.00 62.85 3.12 innodb select_cache2 64.00 +0.47% 0.30 58.00 71.00 64.30 3.07 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.20 0.00 1.00 0.20 0.40 innodb select_distinct 4.00 +12.09% 0.55 4.00 5.00 4.55 0.50 innodb select_group 19.00 -12.76% -2.15 15.00 19.00 16.85 1.39 innodb select_group_when_MANY_tables 12.00 -1.27% -0.15 10.00 14.00 11.85 0.91 innodb select_join 1.00 -81.82% -0.45 0.00 1.00 0.55 0.50 innodb select_key 64.00 -0.08% -0.05 63.00 65.00 63.95 0.59 innodb select_key2 71.00 -0.00% 0.00 70.00 72.00 71.00 0.63 innodb select_key2_return_key 68.00 +0.37% 0.25 67.00 70.00 68.25 0.83 innodb select_key2_return_prim 69.00 +0.14% 0.10 68.00 71.00 69.10 0.77 innodb select_key_prefix 70.00 +0.85% 0.60 69.00 72.00 70.60 0.80 innodb select_key_prefix_join 5.00 +5.66% 0.30 5.00 6.00 5.30 0.46 innodb select_key_return_key 63.00 -0.32% -0.20 61.00 64.00 62.80 0.75 innodb select_many_fields 13.00 +1.52% 0.20 13.00 14.00 13.20 0.40 innodb select_range 46.00 -6.36% -2.75 39.00 47.00 43.25 3.00 innodb select_range_key2 10.00 -5.82% -0.55 9.00 10.00 9.45 0.50 innodb select_range_prefix 9.00 +4.26% 0.40 8.00 10.00 9.40 0.58 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 1.00 -33.33% -0.25 0.00 1.00 0.75 0.43 innodb update_autocommit 3.00 +14.29% 0.50 3.00 4.00 3.50 0.50 innodb update_big 59.00 -0.34% -0.20 56.00 62.00 58.80 1.60 innodb update_commit 2.00 -0.00% 0.00 1.00 3.00 2.00 0.32 innodb update_of_key 22.00 +0.23% 0.05 21.00 24.00 22.05 0.80 innodb update_of_key_big 35.00 +3.85% 1.40 29.00 46.00 36.40 4.93 innodb update_of_primary_key_many_keys 1324.00 +0.54% 7.15 1232.00 1469.00 1331.15 49.11 innodb update_rollback 2.00 +6.98% 0.15 2.00 3.00 2.15 0.36 innodb update_with_key 123.00 -1.61% -1.95 116.00 127.00 121.05 2.97 innodb update_with_key_prefix 46.00 -4.55% -2.00 40.00 47.00 44.00 1.90 innodb wisc_benchmark 2.00 +24.53% 0.65 2.00 3.00 2.65 0.48 ========================================================================================================================= TRENDING OVER ALL runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 32.00 -48.31% -10.42 11.00 61.00 21.58 10.15 innodb alter_table_drop 23.00 -23.40% -4.36 10.00 57.00 18.64 6.89 innodb connect 2.00 +4.09% 0.09 1.00 3.00 2.09 0.42 innodb connect+select_1_row 3.00 -10.62% -0.29 2.00 5.00 2.71 0.47 innodb connect+select_simple 3.00 -27.06% -0.64 1.00 3.00 2.36 0.49 innodb count 17.00 -7.97% -1.26 12.00 193.00 15.74 8.62 innodb count_distinct 8.00 -21.65% -1.42 5.00 50.00 6.58 2.23 innodb count_distinct_2 13.00 +1.64% 0.22 11.00 63.00 13.22 2.90 innodb count_distinct_big 24.00 -9.23% -2.03 5.00 67.00 21.97 2.98 innodb count_distinct_group 16.00 -21.07% -2.78 10.00 68.00 13.22 3.04 innodb count_distinct_group_on_key 11.00 -15.71% -1.49 7.00 69.00 9.51 2.96 innodb count_distinct_group_on_key_parts 14.00 -13.18% -1.63 9.00 72.00 12.37 3.09 innodb count_distinct_key_prefix 5.00 +2.70% 0.14 3.00 52.00 5.14 2.33 innodb count_group_on_key_parts 11.00 -9.77% -0.98 7.00 72.00 10.02 3.08 innodb count_on_key 96.00 -11.21% -9.67 68.00 107.00 86.33 7.38 innodb create+drop 34.00 -4.71% -1.53 18.00 75.00 32.47 11.61 innodb create_index 3.00 -3.36% -0.10 1.00 8.00 2.90 1.12 innodb create_key+drop 30.00 -5.87% -1.66 21.00 50.00 28.34 4.84 innodb create_MANY_tables 20.00 +40.21% 13.45 14.00 121.00 33.45 16.92 innodb create_table 0.00 +100.00% 0.10 0.00 3.00 0.10 0.36 innodb delete_all_many_keys 647.00 -36.83% -174.17 212.00 1888.00 472.83 357.81 innodb delete_autocommit 5.00 -44.83% -1.55 2.00 14.00 3.45 0.74 innodb delete_big 1.00 -231.62% -0.70 0.00 3.00 0.30 0.47 innodb delete_big_many_keys 646.00 -34.98% -167.43 212.00 2293.00 478.57 371.46 innodb delete_commit 2.00 -30.91% -0.47 1.00 5.00 1.53 0.53 innodb delete_key 3.00 +1.31% 0.04 2.00 35.00 3.04 1.47 innodb delete_range 8.00 +3.88% 0.32 5.00 23.00 8.32 3.16 innodb delete_rollback 2.00 -13.89% -0.24 1.00 12.00 1.76 0.90 innodb drop_index 4.00 -35.48% -1.05 1.00 9.00 2.95 1.29 innodb drop_table 0.00 +100.00% 0.05 0.00 2.00 0.05 0.23 innodb drop_table_when_MANY_tables 18.00 +7.84% 1.53 11.00 90.00 19.53 7.36 innodb insert 113.00 -5.59% -5.98 3.00 343.00 107.02 14.33 innodb insert_autocommit 3.00 +0.18% 0.01 2.00 99.00 3.01 3.24 innodb insert_commit 2.00 -42.72% -0.60 1.00 3.00 1.40 0.50 innodb insert_duplicates 19.00 -21.56% -3.37 11.00 21.00 15.63 2.70 innodb insert_key 272.00 +9.92% 29.94 142.00 700.00 301.94 104.47 innodb insert_many_fields 7.00 -24.58% -1.38 3.00 17.00 5.62 1.73 innodb insert_rollback 2.00 -18.76% -0.32 1.00 3.00 1.68 0.53 innodb insert_select_1_key 4.00 -5.66% -0.21 2.00 10.00 3.79 0.88 innodb insert_select_2_keys 6.00 +1.26% 0.08 4.00 16.00 6.08 2.05 innodb min_max 8.00 -2.26% -0.18 6.00 110.00 7.82 4.44 innodb min_max_on_key 24.00 -15.83% -3.28 14.00 37.00 20.72 3.13 innodb multiple_value_insert 7.00 -27.21% -1.50 2.00 50.00 5.50 4.19 innodb once_prepared_select 28.00 -14.63% -3.57 18.00 32.00 24.43 3.63 innodb order_by_big 13.00 +9.14% 1.31 12.00 31.00 14.31 1.52 innodb order_by_big_key 15.00 -12.63% -1.68 11.00 32.00 13.32 1.64 innodb order_by_big_key2 12.00 +1.83% 0.22 10.00 33.00 12.22 1.53 innodb order_by_big_key_desc 15.00 -10.60% -1.44 11.00 32.00 13.56 1.69 innodb order_by_big_key_diff 14.00 -14.18% -1.74 10.00 31.00 12.26 1.49 innodb order_by_big_key_prefix 14.00 -12.67% -1.57 10.00 32.00 12.43 1.54 innodb order_by_key2_diff 2.00 -43.24% -0.60 1.00 3.00 1.40 0.49 innodb order_by_key_prefix 1.00 -25.84% -0.21 0.00 2.00 0.79 0.41 innodb order_by_range 0.00 +100.00% 0.83 0.00 2.00 0.83 0.38 innodb outer_join 24.00 -23.40% -4.55 15.00 61.00 19.45 3.72 innodb outer_join_found 22.00 -16.65% -3.14 14.00 58.00 18.86 3.57 innodb outer_join_not_found 21.00 -26.67% -4.42 12.00 46.00 16.58 3.19 innodb outer_join_on_key 15.00 -15.54% -2.02 10.00 59.00 12.98 2.76 innodb prepared_select 37.00 -17.18% -5.42 22.00 40.00 31.58 4.56 innodb select_1_row 4.00 -38.82% -1.12 2.00 4.00 2.88 0.70 innodb select_1_row_cache 3.00 -10.48% -0.28 2.00 4.00 2.72 0.70 innodb select_2_rows 4.00 -37.39% -1.09 2.00 4.00 2.91 0.71 innodb select_big 14.00 -14.95% -1.82 0.00 31.00 12.18 1.53 innodb select_big_str 1.00 +14.57% 0.17 0.00 2.00 1.17 0.38 innodb select_cache 65.00 -8.71% -5.21 49.00 77.00 59.79 5.59 innodb select_cache2 64.00 -6.38% -3.84 49.00 75.00 60.16 6.23 innodb select_column+column 4.00 -35.13% -1.04 2.00 4.00 2.96 0.72 innodb select_diff_key 0.00 +100.00% 0.22 0.00 1.00 0.22 0.41 innodb select_distinct 4.00 +5.91% 0.25 3.00 8.00 4.25 0.55 innodb select_group 19.00 -16.71% -2.72 4.00 136.00 16.28 5.32 innodb select_group_when_MANY_tables 12.00 -25.33% -2.43 3.00 49.00 9.57 9.26 innodb select_join 1.00 -73.99% -0.43 0.00 1.00 0.57 0.49 innodb select_key 64.00 -20.21% -10.76 40.00 66.00 53.24 7.63 innodb select_key2 71.00 -18.45% -11.06 45.00 75.00 59.94 8.44 innodb select_key2_return_key 68.00 -18.73% -10.73 42.00 71.00 57.27 8.25 innodb select_key2_return_prim 69.00 -18.89% -10.96 42.00 72.00 58.04 8.40 innodb select_key_prefix 70.00 -18.21% -10.78 44.00 75.00 59.22 8.49 innodb select_key_prefix_join 5.00 -5.52% -0.26 3.00 10.00 4.74 0.65 innodb select_key_return_key 63.00 -20.54% -10.74 38.00 65.00 52.26 7.63 innodb select_many_fields 13.00 +12.55% 1.87 11.00 19.00 14.87 1.79 innodb select_range 46.00 +1.82% 0.85 38.00 76.00 46.85 4.07 innodb select_range_key2 10.00 -20.28% -1.69 6.00 11.00 8.31 1.06 innodb select_range_prefix 9.00 -13.94% -1.10 5.00 10.00 7.90 1.13 innodb select_simple 2.00 -20.24% -0.34 1.00 3.00 1.66 0.51 innodb select_simple_cache 2.00 -27.00% -0.43 1.00 3.00 1.57 0.51 innodb select_simple_join 1.00 -50.25% -0.33 0.00 3.00 0.67 0.48 innodb update_autocommit 3.00 +10.28% 0.34 2.00 16.00 3.34 1.00 innodb update_big 59.00 -14.93% -7.66 31.00 195.00 51.34 23.97 innodb update_commit 2.00 -26.60% -0.42 1.00 10.00 1.58 0.72 innodb update_of_key 22.00 +8.87% 2.14 18.00 100.00 24.14 6.05 innodb update_of_key_big 35.00 -25.73% -7.16 15.00 75.00 27.84 10.90 innodb update_of_primary_key_many_keys 1324.00 -6.29% -78.40 647.00 6065.00 1245.60 931.90 innodb update_rollback 2.00 -12.68% -0.23 1.00 31.00 1.77 1.86 innodb update_with_key 123.00 -11.45% -12.64 90.00 598.00 110.36 20.46 innodb update_with_key_prefix 46.00 -15.48% -6.17 33.00 202.00 39.83 6.75 innodb wisc_benchmark 2.00 +19.28% 0.48 2.00 5.00 2.48 0.53 ========================================================================================================================= FULL REVISION COMMENTARY: 2247.2.1: patrick crews 2011-03-23 Shorten path names to allow us to run on freebsd w/o hitting unix socket file length limit _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
