======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 599 RUN DATE: 2010-10-27T18:00:21.938367 SERVER: drizzled VERSION: staging REVISION: 1885 COMMENT: 1885: Brian Aker 2010-10-27 [merge] Merge in additions to IS for FK
========================================================================================================================= TRENDING OVER LAST 5 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 19.00 +22.76% 5.60 19.00 33.00 24.60 5.39 innodb alter_table_drop 12.00 +34.07% 6.20 12.00 24.00 18.20 4.75 innodb connect 3.00 -15.38% -0.40 2.00 3.00 2.60 0.49 innodb connect+select_1_row 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb connect+select_simple 2.00 +16.67% 0.40 2.00 3.00 2.40 0.49 innodb count 13.00 +12.16% 1.80 13.00 18.00 14.80 2.23 innodb count_distinct 6.00 -0.00% 0.00 6.00 6.00 6.00 0.00 innodb count_distinct_2 11.00 +1.79% 0.20 11.00 12.00 11.20 0.40 innodb count_distinct_big 20.00 +3.85% 0.80 20.00 24.00 20.80 1.60 innodb count_distinct_group 10.00 +15.25% 1.80 10.00 14.00 11.80 1.47 innodb count_distinct_group_on_key 9.00 -2.27% -0.20 8.00 10.00 8.80 0.75 innodb count_distinct_group_on_key_parts 10.00 +10.71% 1.20 10.00 13.00 11.20 1.47 innodb count_distinct_key_prefix 4.00 +4.76% 0.20 4.00 5.00 4.20 0.40 innodb count_group_on_key_parts 8.00 +16.67% 1.60 8.00 10.00 9.60 0.80 innodb count_on_key 85.00 +0.70% 0.60 80.00 90.00 85.60 3.26 innodb create+drop 29.00 +21.62% 8.00 29.00 41.00 37.00 4.38 innodb create_index 2.00 +23.08% 0.60 2.00 3.00 2.60 0.49 innodb create_key+drop 27.00 +8.78% 2.60 27.00 31.00 29.60 1.36 innodb create_MANY_tables 39.00 +37.90% 23.80 39.00 72.00 62.80 12.12 innodb create_table 0.00 NULL 0.00 0.00 0.00 0.00 0.00 innodb delete_all_many_keys 312.00 +9.62% 33.20 312.00 438.00 345.20 47.57 innodb delete_autocommit 3.00 +6.25% 0.20 3.00 4.00 3.20 0.40 innodb delete_big 1.00 -150.00% -0.60 0.00 1.00 0.40 0.49 innodb delete_big_many_keys 312.00 +9.62% 33.20 312.00 438.00 345.20 47.57 innodb delete_commit 2.00 -42.86% -0.60 1.00 2.00 1.40 0.49 innodb delete_key 3.00 +21.05% 0.80 3.00 4.00 3.80 0.40 innodb delete_range 7.00 +10.26% 0.80 5.00 11.00 7.80 1.94 innodb delete_rollback 2.00 -66.67% -0.80 1.00 2.00 1.20 0.40 innodb drop_index 4.00 -33.33% -1.00 2.00 4.00 3.00 0.89 innodb drop_table 0.00 NULL 0.00 0.00 0.00 0.00 0.00 innodb drop_table_when_MANY_tables 20.00 +12.28% 2.80 20.00 24.00 22.80 1.47 innodb insert 103.00 -0.39% -0.40 101.00 104.00 102.60 1.02 innodb insert_autocommit 3.00 -7.14% -0.20 2.00 3.00 2.80 0.40 innodb insert_commit 1.00 +16.67% 0.20 1.00 2.00 1.20 0.40 innodb insert_duplicates 15.00 -4.17% -0.60 14.00 15.00 14.40 0.49 innodb insert_key 184.00 +30.25% 79.80 184.00 292.00 263.80 40.44 innodb insert_many_fields 8.00 +2.44% 0.20 7.00 10.00 8.20 0.98 innodb insert_rollback 2.00 -25.00% -0.40 1.00 2.00 1.60 0.49 innodb insert_select_1_key 3.00 +16.67% 0.60 3.00 5.00 3.60 0.80 innodb insert_select_2_keys 5.00 +10.71% 0.60 5.00 6.00 5.60 0.49 innodb min_max 6.00 +14.29% 1.00 6.00 8.00 7.00 0.89 innodb min_max_on_key 16.00 +12.09% 2.20 16.00 20.00 18.20 1.47 innodb multiple_value_insert 3.00 +31.82% 1.40 3.00 6.00 4.40 1.02 innodb once_prepared_select 23.00 -0.00% 0.00 22.00 24.00 23.00 0.89 innodb order_by_big 12.00 +11.76% 1.60 12.00 15.00 13.60 1.20 innodb order_by_big_key 11.00 +11.29% 1.40 11.00 14.00 12.40 1.36 innodb order_by_big_key2 10.00 +10.71% 1.20 10.00 13.00 11.20 1.47 innodb order_by_big_key_desc 12.00 +6.25% 0.80 12.00 14.00 12.80 0.98 innodb order_by_big_key_diff 10.00 +12.28% 1.40 10.00 13.00 11.40 1.36 innodb order_by_big_key_prefix 12.00 +3.23% 0.40 11.00 14.00 12.40 1.02 innodb order_by_key2_diff 1.00 +28.57% 0.40 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 1.00 -66.67% -0.40 0.00 1.00 0.60 0.49 innodb outer_join 18.00 +6.25% 1.20 18.00 21.00 19.20 1.47 innodb outer_join_found 17.00 +8.60% 1.60 17.00 21.00 18.60 1.62 innodb outer_join_not_found 14.00 +11.39% 1.80 14.00 18.00 15.80 1.47 innodb outer_join_on_key 13.00 +1.52% 0.20 12.00 15.00 13.20 0.98 innodb prepared_select 32.00 -0.00% 0.00 31.00 33.00 32.00 0.63 innodb select_1_row 3.00 -15.38% -0.40 2.00 3.00 2.60 0.49 innodb select_1_row_cache 3.00 -7.14% -0.20 2.00 3.00 2.80 0.40 innodb select_2_rows 2.00 +16.67% 0.40 2.00 3.00 2.40 0.49 innodb select_big 10.00 +15.25% 1.80 10.00 13.00 11.80 1.17 innodb select_big_str 1.00 +16.67% 0.20 1.00 2.00 1.20 0.40 innodb select_cache 53.00 +4.33% 2.40 53.00 63.00 55.40 3.83 innodb select_cache2 51.00 +9.25% 5.20 51.00 64.00 56.20 5.00 innodb select_column+column 3.00 -7.14% -0.20 2.00 3.00 2.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 +4.76% 0.20 4.00 5.00 4.20 0.40 innodb select_group 17.00 -4.94% -0.80 15.00 17.00 16.20 0.98 innodb select_group_when_MANY_tables 4.00 +16.67% 0.80 4.00 5.00 4.80 0.40 innodb select_join 1.00 -150.00% -0.60 0.00 1.00 0.40 0.49 innodb select_key 50.00 +1.96% 1.00 49.00 52.00 51.00 1.26 innodb select_key2 58.00 +3.65% 2.20 58.00 62.00 60.20 1.47 innodb select_key2_return_key 58.00 +1.02% 0.60 57.00 60.00 58.60 1.20 innodb select_key2_return_prim 59.00 -0.34% -0.20 56.00 60.00 58.80 1.47 innodb select_key_prefix 62.00 -1.97% -1.20 59.00 62.00 60.80 1.17 innodb select_key_prefix_join 5.00 -4.17% -0.20 4.00 5.00 4.80 0.40 innodb select_key_return_key 47.00 -0.00% 0.00 44.00 55.00 47.00 4.15 innodb select_many_fields 13.00 -1.56% -0.20 12.00 13.00 12.80 0.40 innodb select_range 47.00 -1.29% -0.60 44.00 49.00 46.40 1.62 innodb select_range_key2 8.00 -0.00% 0.00 7.00 9.00 8.00 0.89 innodb select_range_prefix 9.00 -7.14% -0.60 8.00 9.00 8.40 0.49 innodb select_simple 2.00 -25.00% -0.40 1.00 2.00 1.60 0.49 innodb select_simple_cache 1.00 +28.57% 0.40 1.00 2.00 1.40 0.49 innodb select_simple_join 0.00 +100.00% 1.00 0.00 3.00 1.00 1.10 innodb TOTALS 3141.00 +9.20% 318.20 3141.00 3934.00 3459.20 260.68 innodb update_autocommit 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb update_big 36.00 +22.75% 10.60 36.00 62.00 46.60 9.02 innodb update_commit 1.00 +44.44% 0.80 1.00 2.00 1.80 0.40 innodb update_of_key 23.00 +4.17% 1.00 23.00 25.00 24.00 0.89 innodb update_of_key_big 23.00 -0.88% -0.20 21.00 24.00 22.80 0.98 innodb update_of_primary_key_many_keys 830.00 +7.68% 69.00 830.00 1095.00 899.00 99.00 innodb update_rollback 1.00 +37.50% 0.60 1.00 2.00 1.60 0.49 innodb update_with_key 101.00 +4.90% 5.20 101.00 109.00 106.20 3.19 innodb update_with_key_prefix 36.00 +3.74% 1.40 36.00 39.00 37.40 1.02 innodb wisc_benchmark 2.00 +9.09% 0.20 2.00 3.00 2.20 0.40 ========================================================================================================================= TRENDING OVER LAST 20 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 19.00 +10.44% 2.21 12.00 33.00 21.21 6.99 innodb alter_table_drop 12.00 +29.11% 4.93 11.00 24.00 16.93 4.22 innodb connect 3.00 -23.53% -0.57 2.00 3.00 2.43 0.49 innodb connect+select_1_row 3.00 -7.69% -0.21 2.00 3.00 2.79 0.41 innodb connect+select_simple 2.00 +20.00% 0.50 2.00 3.00 2.50 0.50 innodb count 13.00 +11.65% 1.71 13.00 18.00 14.71 1.91 innodb count_distinct 6.00 +4.55% 0.29 5.00 7.00 6.29 0.59 innodb count_distinct_2 11.00 +13.48% 1.71 11.00 16.00 12.71 1.94 innodb count_distinct_big 20.00 +3.78% 0.79 19.00 24.00 20.79 1.61 innodb count_distinct_group 10.00 +21.35% 2.71 10.00 15.00 12.71 1.53 innodb count_distinct_group_on_key 9.00 +1.56% 0.14 8.00 11.00 9.14 1.19 innodb count_distinct_group_on_key_parts 10.00 +15.66% 1.86 10.00 14.00 11.86 1.51 innodb count_distinct_key_prefix 4.00 +15.15% 0.71 4.00 6.00 4.71 0.88 innodb count_group_on_key_parts 8.00 +20.57% 2.07 8.00 12.00 10.07 0.96 innodb count_on_key 85.00 +1.49% 1.29 80.00 92.00 86.29 3.08 innodb create+drop 29.00 +18.47% 6.57 28.00 41.00 35.57 4.75 innodb create_index 2.00 +24.32% 0.64 1.00 5.00 2.64 0.97 innodb create_key+drop 27.00 +5.03% 1.43 26.00 31.00 28.43 1.50 innodb create_MANY_tables 39.00 +21.78% 10.86 27.00 72.00 49.86 15.33 innodb create_table 0.00 NULL 0.00 0.00 0.00 0.00 0.00 innodb delete_all_many_keys 312.00 +3.68% 11.93 299.00 438.00 323.93 34.74 innodb delete_autocommit 3.00 +4.55% 0.14 3.00 4.00 3.14 0.35 innodb delete_big 1.00 -600.00% -0.86 0.00 1.00 0.14 0.35 innodb delete_big_many_keys 312.00 +3.68% 11.93 299.00 438.00 323.93 34.74 innodb delete_commit 2.00 -33.33% -0.50 1.00 2.00 1.50 0.50 innodb delete_key 3.00 +12.50% 0.43 3.00 4.00 3.43 0.49 innodb delete_range 7.00 -6.52% -0.43 5.00 11.00 6.57 1.50 innodb delete_rollback 2.00 -40.00% -0.57 1.00 2.00 1.43 0.49 innodb drop_index 4.00 -47.37% -1.29 2.00 4.00 2.71 0.80 innodb drop_table 0.00 +100.00% 0.14 0.00 1.00 0.14 0.35 innodb drop_table_when_MANY_tables 20.00 -3.32% -0.64 14.00 24.00 19.36 3.54 innodb insert 103.00 +0.96% 1.00 100.00 113.00 104.00 3.76 innodb insert_autocommit 3.00 -7.69% -0.21 2.00 3.00 2.79 0.41 innodb insert_commit 1.00 +17.65% 0.21 1.00 2.00 1.21 0.41 innodb insert_duplicates 15.00 -4.48% -0.64 14.00 15.00 14.36 0.48 innodb insert_key 184.00 +24.74% 60.50 184.00 292.00 244.50 32.55 innodb insert_many_fields 8.00 -24.44% -1.57 4.00 10.00 6.43 1.64 innodb insert_rollback 2.00 -27.27% -0.43 1.00 2.00 1.57 0.49 innodb insert_select_1_key 3.00 +16.00% 0.57 3.00 5.00 3.57 0.73 innodb insert_select_2_keys 5.00 +2.78% 0.14 4.00 6.00 5.14 0.74 innodb min_max 6.00 +15.15% 1.07 6.00 8.00 7.07 0.88 innodb min_max_on_key 16.00 +15.15% 2.86 16.00 21.00 18.86 1.30 innodb multiple_value_insert 3.00 +22.22% 0.86 2.00 6.00 3.86 0.91 innodb once_prepared_select 23.00 +1.53% 0.36 22.00 24.00 23.36 0.81 innodb order_by_big 12.00 +15.58% 2.21 12.00 16.00 14.21 1.26 innodb order_by_big_key 11.00 +13.97% 1.79 11.00 14.00 12.79 1.26 innodb order_by_big_key2 10.00 +15.15% 1.79 10.00 13.00 11.79 1.26 innodb order_by_big_key_desc 12.00 +7.69% 1.00 12.00 15.00 13.00 1.13 innodb order_by_big_key_diff 10.00 +15.15% 1.79 10.00 13.00 11.79 1.15 innodb order_by_big_key_prefix 12.00 +2.33% 0.29 11.00 14.00 12.29 1.16 innodb order_by_key2_diff 1.00 +33.33% 0.50 1.00 2.00 1.50 0.50 innodb order_by_key_prefix 1.00 -16.67% -0.14 0.00 1.00 0.86 0.35 innodb order_by_range 1.00 -40.00% -0.29 0.00 1.00 0.71 0.45 innodb outer_join 18.00 +4.91% 0.93 16.00 21.00 18.93 2.05 innodb outer_join_found 17.00 +8.11% 1.50 16.00 21.00 18.50 2.03 innodb outer_join_not_found 14.00 +10.91% 1.71 13.00 18.00 15.71 1.83 innodb outer_join_on_key 13.00 -2.25% -0.29 10.00 15.00 12.71 1.48 innodb prepared_select 32.00 +0.44% 0.14 31.00 33.00 32.14 0.74 innodb select_1_row 3.00 -10.53% -0.29 2.00 3.00 2.71 0.45 innodb select_1_row_cache 3.00 -16.67% -0.43 2.00 3.00 2.57 0.49 innodb select_2_rows 2.00 +28.21% 0.79 2.00 3.00 2.79 0.41 innodb select_big 10.00 +18.13% 2.21 10.00 13.00 12.21 0.94 innodb select_big_str 1.00 +12.50% 0.14 1.00 2.00 1.14 0.35 innodb select_cache 53.00 +10.06% 5.93 52.00 69.00 58.93 6.13 innodb select_cache2 51.00 +14.70% 8.79 51.00 70.00 59.79 6.82 innodb select_column+column 3.00 -10.53% -0.29 2.00 3.00 2.71 0.45 innodb select_diff_key 0.00 +100.00% 0.21 0.00 1.00 0.21 0.41 innodb select_distinct 4.00 +3.45% 0.14 4.00 5.00 4.14 0.35 innodb select_group 17.00 -7.69% -1.21 13.00 19.00 15.79 1.42 innodb select_group_when_MANY_tables 4.00 +13.85% 0.64 4.00 6.00 4.64 0.61 innodb select_join 1.00 -75.00% -0.43 0.00 1.00 0.57 0.49 innodb select_key 50.00 -1.16% -0.57 47.00 52.00 49.43 1.80 innodb select_key2 58.00 +4.92% 3.00 58.00 63.00 61.00 1.31 innodb select_key2_return_key 58.00 +0.85% 0.50 56.00 60.00 58.50 1.24 innodb select_key2_return_prim 59.00 +1.20% 0.71 56.00 61.00 59.71 1.33 innodb select_key_prefix 62.00 -1.40% -0.86 59.00 63.00 61.14 1.25 innodb select_key_prefix_join 5.00 -6.06% -0.29 4.00 5.00 4.71 0.45 innodb select_key_return_key 47.00 -0.00% 0.00 44.00 55.00 47.00 2.85 innodb select_many_fields 13.00 -1.68% -0.21 12.00 13.00 12.79 0.41 innodb select_range 47.00 -0.61% -0.29 44.00 53.00 46.71 2.94 innodb select_range_key2 8.00 +5.08% 0.43 7.00 9.00 8.43 0.73 innodb select_range_prefix 9.00 -10.53% -0.86 7.00 9.00 8.14 0.64 innodb select_simple 2.00 -33.33% -0.50 1.00 2.00 1.50 0.50 innodb select_simple_cache 1.00 +30.00% 0.43 1.00 2.00 1.43 0.49 innodb select_simple_join 0.00 +100.00% 0.71 0.00 3.00 0.71 0.80 innodb TOTALS 3141.00 +5.99% 200.14 3141.00 3934.00 3341.14 203.76 innodb update_autocommit 3.00 +2.33% 0.07 3.00 4.00 3.07 0.26 innodb update_big 36.00 +17.11% 7.43 33.00 62.00 43.43 8.72 innodb update_commit 1.00 +36.36% 0.57 1.00 2.00 1.57 0.49 innodb update_of_key 23.00 +5.29% 1.29 21.00 28.00 24.29 1.94 innodb update_of_key_big 23.00 -7.33% -1.57 17.00 28.00 21.43 3.06 innodb update_of_primary_key_many_keys 830.00 +3.54% 30.50 810.00 1095.00 860.50 69.46 innodb update_rollback 1.00 +39.13% 0.64 1.00 2.00 1.64 0.48 innodb update_with_key 101.00 +3.68% 3.86 101.00 110.00 104.86 2.97 innodb update_with_key_prefix 36.00 +2.70% 1.00 36.00 39.00 37.00 0.76 innodb wisc_benchmark 2.00 +15.15% 0.36 2.00 3.00 2.36 0.48 ========================================================================================================================= TRENDING OVER ALL runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 19.00 -56.09% -6.83 11.00 14.00 12.17 0.87 innodb alter_table_drop 12.00 -5.14% -0.59 10.00 14.00 11.41 1.07 innodb connect 3.00 -77.55% -1.31 1.00 2.00 1.69 0.46 innodb connect+select_1_row 3.00 -27.94% -0.66 2.00 3.00 2.34 0.48 innodb connect+select_simple 2.00 -1.75% -0.03 1.00 2.00 1.97 0.18 innodb count 13.00 +13.33% 2.00 13.00 18.00 15.00 1.76 innodb count_distinct 6.00 +1.14% 0.07 5.00 8.00 6.07 0.83 innodb count_distinct_2 11.00 +9.37% 1.14 11.00 16.00 12.14 1.38 innodb count_distinct_big 20.00 +6.30% 1.34 18.00 25.00 21.34 1.97 innodb count_distinct_group 10.00 +20.98% 2.66 11.00 14.00 12.66 0.84 innodb count_distinct_group_on_key 9.00 -1.16% -0.10 8.00 11.00 8.90 1.12 innodb count_distinct_group_on_key_parts 10.00 +14.96% 1.76 10.00 15.00 11.76 1.36 innodb count_distinct_key_prefix 4.00 +15.33% 0.72 4.00 6.00 4.72 0.69 innodb count_group_on_key_parts 8.00 +1.69% 0.14 7.00 10.00 8.14 0.78 innodb count_on_key 85.00 -10.04% -7.76 73.00 83.00 77.24 2.25 innodb create+drop 29.00 -48.59% -9.48 19.00 21.00 19.52 0.56 innodb create_index 2.00 -5.45% -0.10 1.00 3.00 1.90 0.48 innodb create_key+drop 27.00 -19.72% -4.45 21.00 23.00 22.55 0.56 innodb create_MANY_tables 39.00 -128.48% -21.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 312.00 -4.97% -14.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 1.00 -262.50% -0.72 0.00 1.00 0.28 0.45 innodb delete_big_many_keys 312.00 -5.00% -14.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 3.00 -22.54% -0.55 2.00 3.00 2.45 0.50 innodb delete_range 7.00 -0.50% -0.03 6.00 8.00 6.97 0.56 innodb delete_rollback 2.00 -52.63% -0.69 1.00 2.00 1.31 0.46 innodb drop_index 4.00 -103.51% -2.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 20.00 -48.34% -6.52 12.00 15.00 13.48 0.62 innodb insert 103.00 -13.57% -12.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 15.00 -16.94% -2.17 12.00 14.00 12.83 0.53 innodb insert_key 184.00 +36.03% 103.62 189.00 345.00 287.62 32.94 innodb insert_many_fields 8.00 -96.61% -3.93 3.00 5.00 4.07 0.36 innodb insert_rollback 2.00 -41.46% -0.59 1.00 2.00 1.41 0.49 innodb insert_select_1_key 3.00 +12.12% 0.41 3.00 4.00 3.41 0.49 innodb insert_select_2_keys 5.00 +3.33% 0.17 4.00 6.00 5.17 0.59 innodb min_max 6.00 +21.62% 1.66 6.00 9.00 7.66 1.03 innodb min_max_on_key 16.00 +5.11% 0.86 14.00 20.00 16.86 1.28 innodb multiple_value_insert 3.00 +33.59% 1.52 3.00 5.00 4.52 0.56 innodb once_prepared_select 23.00 -9.70% -2.03 20.00 22.00 20.97 0.61 innodb order_by_big 12.00 +15.12% 2.14 12.00 15.00 14.14 0.94 innodb order_by_big_key 11.00 +11.39% 1.41 11.00 14.00 12.41 1.19 innodb order_by_big_key2 10.00 +12.91% 1.48 10.00 13.00 11.48 0.97 innodb order_by_big_key_desc 12.00 +6.95% 0.90 12.00 14.00 12.90 0.92 innodb order_by_big_key_diff 10.00 +13.69% 1.59 10.00 13.00 11.59 0.85 innodb order_by_big_key_prefix 12.00 -0.29% -0.03 11.00 13.00 11.97 0.85 innodb order_by_key2_diff 1.00 +14.71% 0.17 1.00 2.00 1.17 0.38 innodb order_by_key_prefix 1.00 -61.11% -0.38 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 18.00 -3.78% -0.66 15.00 21.00 17.34 2.06 innodb outer_join_found 17.00 -0.82% -0.14 14.00 21.00 16.86 2.19 innodb outer_join_not_found 14.00 +6.67% 1.00 13.00 18.00 15.00 1.49 innodb outer_join_on_key 13.00 -8.65% -1.03 10.00 15.00 11.97 1.50 innodb prepared_select 32.00 -23.73% -6.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 3.00 -45.00% -0.93 2.00 3.00 2.07 0.25 innodb select_2_rows 2.00 +9.38% 0.21 2.00 3.00 2.21 0.41 innodb select_big 10.00 +13.95% 1.62 10.00 13.00 11.62 1.00 innodb select_big_str 1.00 +9.62% 0.11 0.00 2.00 1.11 0.31 innodb select_cache 53.00 +7.96% 4.59 51.00 71.00 57.59 5.41 innodb select_cache2 51.00 +10.31% 5.86 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 17.00 -11.79% -1.79 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 50.00 -12.32% -5.48 40.00 50.00 44.52 2.50 innodb select_key2 58.00 -17.70% -8.72 46.00 54.00 49.28 2.41 innodb select_key2_return_key 58.00 -23.59% -11.07 42.00 51.00 46.93 2.32 innodb select_key2_return_prim 59.00 -21.87% -10.59 43.00 55.00 48.41 2.92 innodb select_key_prefix 62.00 -22.06% -11.21 45.00 57.00 50.79 3.46 innodb select_key_prefix_join 5.00 -19.83% -0.83 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 13.00 +20.96% 3.45 15.00 17.00 16.45 0.62 innodb select_range 47.00 +3.81% 1.86 47.00 57.00 48.86 1.66 innodb select_range_key2 8.00 -10.48% -0.76 6.00 8.00 7.24 0.57 innodb select_range_prefix 9.00 -28.57% -2.00 6.00 8.00 7.00 0.64 innodb select_simple 2.00 -38.10% -0.55 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 0.00 +100.00% 0.72 0.00 1.00 0.72 0.45 innodb TOTALS 3141.00 -214.10% -2141.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 36.00 +0.10% 0.03 31.00 40.00 36.03 2.48 innodb update_commit 1.00 +25.64% 0.34 1.00 2.00 1.34 0.48 innodb update_of_key 23.00 -19.32% -3.72 19.00 20.00 19.28 0.45 innodb update_of_key_big 23.00 -25.61% -4.69 16.00 20.00 18.31 1.18 innodb update_of_primary_key_many_keys 830.00 -8.73% -66.67 661.00 799.00 763.33 39.70 innodb update_rollback 1.00 +29.27% 0.41 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 36.00 -2.15% -0.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 ========================================================================================================================= FULL REVISION COMMENTARY: 1861.4.9: Brian Aker 2010-10-27 [merge] Merge with trunk. 1861.4.8: Brian Aker 2010-10-22 Adds in a portion of the ref constraints table. 1861.4.7: Brian Aker 2010-10-21 Cleanup schema from DD to have similar style (and use the generator correctly) 1861.4.6: Brian Aker 2010-10-21 Switched columns to use AllFields. 1861.4.5: Brian Aker 2010-10-21 Fix IS to use straight generator. 1861.4.4: Brian Aker 2010-10-20 Cleanup display code around DD/IS _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
