======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 898 RUN DATE: 2011-02-15T14:04:53.363459 SERVER: drizzled VERSION: staging REVISION: 2171 COMMENT: 2171: Brian Aker 2011-02-15 [merge] Merge datetime tree.
========================================================================================================================= TRENDING OVER LAST 5 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 34.00 -4.94% -1.60 32.00 34.00 32.40 0.80 innodb alter_table_drop 24.00 -0.00% 0.00 23.00 25.00 24.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 -7.14% -0.20 2.00 3.00 2.80 0.40 innodb connect+select_simple 3.00 -15.38% -0.40 2.00 3.00 2.60 0.49 innodb count 18.00 -11.11% -1.80 14.00 18.00 16.20 1.83 innodb count_distinct 7.00 -0.00% 0.00 7.00 7.00 7.00 0.00 innodb count_distinct_2 14.00 +2.78% 0.40 12.00 16.00 14.40 1.36 innodb count_distinct_big 24.00 -7.14% -1.60 21.00 24.00 22.40 1.36 innodb count_distinct_group 15.00 -5.63% -0.80 12.00 15.00 14.20 1.17 innodb count_distinct_group_on_key 9.00 +21.05% 2.40 9.00 17.00 11.40 2.94 innodb count_distinct_group_on_key_parts 14.00 -4.48% -0.60 11.00 15.00 13.40 1.36 innodb count_distinct_key_prefix 7.00 -25.00% -1.40 5.00 7.00 5.60 0.80 innodb count_group_on_key_parts 11.00 -0.00% 0.00 11.00 11.00 11.00 0.00 innodb count_on_key 93.00 -0.00% 0.00 91.00 96.00 93.00 1.67 innodb create+drop 32.00 -1.27% -0.40 31.00 32.00 31.60 0.49 innodb create_index 4.00 -25.00% -0.80 3.00 4.00 3.20 0.40 innodb create_key+drop 29.00 +3.33% 1.00 29.00 32.00 30.00 1.10 innodb create_MANY_tables 21.00 -2.94% -0.60 20.00 21.00 20.40 0.49 innodb create_table 0.00 +100.00% 0.20 0.00 1.00 0.20 0.40 innodb delete_all_many_keys 716.00 -10.49% -68.00 624.00 716.00 648.00 34.59 innodb delete_autocommit 3.00 +11.76% 0.40 3.00 4.00 3.40 0.49 innodb delete_big 0.00 +100.00% 0.20 0.00 1.00 0.20 0.40 innodb delete_big_many_keys 715.00 -10.48% -67.80 623.00 715.00 647.20 34.53 innodb delete_commit 2.00 -25.00% -0.40 1.00 2.00 1.60 0.49 innodb delete_key 3.00 -7.14% -0.20 2.00 3.00 2.80 0.40 innodb delete_range 9.00 -7.14% -0.60 7.00 9.00 8.40 0.80 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 17.00 -4.94% -0.80 16.00 17.00 16.20 0.40 innodb insert 114.00 +0.35% 0.40 114.00 115.00 114.40 0.49 innodb insert_autocommit 3.00 +11.76% 0.40 3.00 4.00 3.40 0.49 innodb insert_commit 2.00 -25.00% -0.40 1.00 2.00 1.60 0.49 innodb insert_duplicates 19.00 -1.06% -0.20 18.00 19.00 18.80 0.40 innodb insert_key 297.00 -6.53% -18.20 272.00 297.00 278.80 9.20 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 3.00 +11.76% 0.40 3.00 4.00 3.40 0.49 innodb insert_select_2_keys 6.00 +6.25% 0.40 6.00 7.00 6.40 0.49 innodb min_max 9.00 -9.76% -0.80 7.00 9.00 8.20 0.98 innodb min_max_on_key 25.00 -1.63% -0.40 24.00 26.00 24.60 0.80 innodb multiple_value_insert 7.00 -2.94% -0.20 6.00 8.00 6.80 0.75 innodb once_prepared_select 29.00 +1.36% 0.40 29.00 30.00 29.40 0.49 innodb order_by_big 16.00 -6.67% -1.00 13.00 16.00 15.00 1.10 innodb order_by_big_key 15.00 -5.63% -0.80 12.00 16.00 14.20 1.33 innodb order_by_big_key2 14.00 -6.06% -0.80 12.00 14.00 13.20 0.75 innodb order_by_big_key_desc 16.00 -5.26% -0.80 14.00 16.00 15.20 0.75 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 14.00 -2.94% -0.40 12.00 14.00 13.60 0.80 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 -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 19.00 +14.41% 3.20 17.00 26.00 22.20 3.54 innodb outer_join_found 18.00 +16.67% 3.60 17.00 25.00 21.60 3.44 innodb outer_join_not_found 18.00 +7.22% 1.40 14.00 22.00 19.40 3.07 innodb outer_join_on_key 13.00 +12.16% 1.80 11.00 17.00 14.80 2.40 innodb prepared_select 37.00 +1.07% 0.40 37.00 38.00 37.40 0.49 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 -17.65% -0.60 3.00 4.00 3.40 0.49 innodb select_2_rows 3.00 +16.67% 0.60 3.00 4.00 3.60 0.49 innodb select_big 12.00 +9.09% 1.20 12.00 15.00 13.20 1.17 innodb select_big_str 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb select_cache 68.00 -2.41% -1.60 63.00 70.00 66.40 2.58 innodb select_cache2 69.00 -7.81% -5.00 62.00 69.00 64.00 2.61 innodb select_column+column 4.00 -0.00% 0.00 4.00 4.00 4.00 0.00 innodb select_diff_key 0.00 +100.00% 0.20 0.00 1.00 0.20 0.40 innodb select_distinct 4.00 +9.09% 0.40 4.00 5.00 4.40 0.49 innodb select_group 15.00 +7.41% 1.20 15.00 18.00 16.20 1.47 innodb select_group_when_MANY_tables 13.00 -10.17% -1.20 11.00 13.00 11.80 0.75 innodb select_join 1.00 -66.67% -0.40 0.00 1.00 0.60 0.49 innodb select_key 64.00 +0.31% 0.20 63.00 66.00 64.20 0.98 innodb select_key2 72.00 -0.56% -0.40 70.00 73.00 71.60 1.02 innodb select_key2_return_key 68.00 +0.87% 0.60 68.00 71.00 68.60 1.20 innodb select_key2_return_prim 69.00 +1.15% 0.80 69.00 71.00 69.80 0.75 innodb select_key_prefix 71.00 +0.28% 0.20 70.00 73.00 71.20 0.98 innodb select_key_prefix_join 5.00 +3.85% 0.20 5.00 6.00 5.20 0.40 innodb select_key_return_key 62.00 +1.59% 1.00 62.00 64.00 63.00 0.63 innodb select_many_fields 13.00 +2.99% 0.40 13.00 14.00 13.40 0.49 innodb select_range 40.00 +3.38% 1.40 39.00 45.00 41.40 2.06 innodb select_range_key2 9.00 +8.16% 0.80 9.00 10.00 9.80 0.40 innodb select_range_prefix 10.00 -11.11% -1.00 8.00 10.00 9.00 0.63 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 -25.00% -0.20 0.00 1.00 0.80 0.40 innodb update_autocommit 4.00 -0.00% 0.00 4.00 4.00 4.00 0.00 innodb update_big 61.00 -3.39% -2.00 57.00 61.00 59.00 1.26 innodb update_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_of_key 22.00 +1.79% 0.40 21.00 24.00 22.40 1.02 innodb update_of_key_big 37.00 -4.52% -1.60 29.00 38.00 35.40 3.26 innodb update_of_primary_key_many_keys 1457.00 -8.63% -115.80 1297.00 1457.00 1341.20 59.36 innodb update_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_with_key 122.00 +0.65% 0.80 122.00 124.00 122.80 0.98 innodb update_with_key_prefix 48.00 -10.09% -4.40 41.00 48.00 43.60 2.33 innodb wisc_benchmark 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 ========================================================================================================================= TRENDING OVER LAST 20 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 34.00 -4.62% -1.50 32.00 34.00 32.50 0.67 innodb alter_table_drop 24.00 -0.00% 0.00 23.00 25.00 24.00 0.71 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 3.00 -11.11% -0.30 2.00 3.00 2.70 0.46 innodb count 18.00 -17.26% -2.65 13.00 18.00 15.35 1.82 innodb count_distinct 7.00 -4.48% -0.30 6.00 8.00 6.70 0.64 innodb count_distinct_2 14.00 -1.08% -0.15 12.00 16.00 13.85 1.24 innodb count_distinct_big 24.00 -6.67% -1.50 20.00 25.00 22.50 1.53 innodb count_distinct_group 15.00 -4.53% -0.65 11.00 16.00 14.35 1.24 innodb count_distinct_group_on_key 9.00 +13.46% 1.40 8.00 17.00 10.40 2.20 innodb count_distinct_group_on_key_parts 14.00 -5.26% -0.70 11.00 15.00 13.30 1.05 innodb count_distinct_key_prefix 7.00 -32.08% -1.70 4.00 7.00 5.30 0.71 innodb count_group_on_key_parts 11.00 -0.46% -0.05 10.00 12.00 10.95 0.38 innodb count_on_key 93.00 +0.80% 0.75 91.00 97.00 93.75 1.73 innodb create+drop 32.00 -0.31% -0.10 30.00 34.00 31.90 1.18 innodb create_index 4.00 -26.98% -0.85 2.00 4.00 3.15 0.48 innodb create_key+drop 29.00 +0.85% 0.25 28.00 32.00 29.25 0.94 innodb create_MANY_tables 21.00 -2.44% -0.50 19.00 22.00 20.50 0.74 innodb create_table 0.00 +100.00% 0.20 0.00 1.00 0.20 0.40 innodb delete_all_many_keys 716.00 -7.95% -52.70 569.00 738.00 663.30 47.42 innodb delete_autocommit 3.00 +13.04% 0.45 3.00 4.00 3.45 0.50 innodb delete_big 0.00 +100.00% 0.45 0.00 1.00 0.45 0.50 innodb delete_big_many_keys 715.00 -7.95% -52.65 569.00 737.00 662.35 47.30 innodb delete_commit 2.00 -8.11% -0.15 1.00 2.00 1.85 0.36 innodb delete_key 3.00 -7.14% -0.20 2.00 3.00 2.80 0.40 innodb delete_range 9.00 -4.05% -0.35 7.00 10.00 8.65 0.73 innodb delete_rollback 2.00 +6.98% 0.15 2.00 3.00 2.15 0.36 innodb drop_index 3.00 +6.25% 0.20 3.00 4.00 3.20 0.40 innodb drop_table_when_MANY_tables 17.00 -5.59% -0.90 15.00 17.00 16.10 0.62 innodb insert 114.00 +0.22% 0.25 112.00 116.00 114.25 0.99 innodb insert_autocommit 3.00 +7.69% 0.25 3.00 4.00 3.25 0.43 innodb insert_commit 2.00 -11.11% -0.20 1.00 2.00 1.80 0.40 innodb insert_duplicates 19.00 +0.52% 0.10 18.00 20.00 19.10 0.54 innodb insert_key 297.00 -4.39% -12.50 266.00 304.00 284.50 12.75 innodb insert_many_fields 5.00 +13.04% 0.75 5.00 6.00 5.75 0.43 innodb insert_rollback 2.00 -2.56% -0.05 1.00 2.00 1.95 0.22 innodb insert_select_1_key 3.00 +23.08% 0.90 3.00 5.00 3.90 0.62 innodb insert_select_2_keys 6.00 +5.51% 0.35 4.00 8.00 6.35 0.85 innodb min_max 9.00 -15.38% -1.20 6.00 9.00 7.80 0.98 innodb min_max_on_key 25.00 -2.25% -0.55 24.00 26.00 24.45 0.59 innodb multiple_value_insert 7.00 -5.26% -0.35 5.00 8.00 6.65 0.79 innodb once_prepared_select 29.00 +0.85% 0.25 29.00 30.00 29.25 0.43 innodb order_by_big 16.00 -11.11% -1.60 13.00 16.00 14.40 1.16 innodb order_by_big_key 15.00 -3.09% -0.45 12.00 17.00 14.55 1.24 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 16.00 -4.58% -0.70 14.00 16.00 15.30 0.64 innodb order_by_big_key_diff 13.00 +0.76% 0.10 12.00 14.00 13.10 0.77 innodb order_by_big_key_prefix 14.00 -2.94% -0.40 12.00 15.00 13.60 0.73 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 -17.65% -0.15 0.00 1.00 0.85 0.36 innodb order_by_range 1.00 -5.26% -0.05 0.00 1.00 0.95 0.22 innodb outer_join 19.00 +13.83% 3.05 17.00 26.00 22.05 3.22 innodb outer_join_found 18.00 +15.29% 3.25 16.00 25.00 21.25 3.21 innodb outer_join_not_found 18.00 +4.00% 0.75 14.00 22.00 18.75 2.91 innodb outer_join_on_key 13.00 +11.26% 1.65 11.00 18.00 14.65 2.24 innodb prepared_select 37.00 +0.40% 0.15 37.00 38.00 37.15 0.36 innodb select_1_row 3.00 +15.49% 0.55 3.00 4.00 3.55 0.50 innodb select_1_row_cache 4.00 -15.94% -0.55 3.00 4.00 3.45 0.50 innodb select_2_rows 3.00 +16.67% 0.60 3.00 4.00 3.60 0.49 innodb select_big 12.00 +7.69% 1.00 12.00 15.00 13.00 0.89 innodb select_big_str 1.00 +16.67% 0.20 1.00 2.00 1.20 0.40 innodb select_cache 68.00 -7.34% -4.65 57.00 71.00 63.35 3.82 innodb select_cache2 69.00 -9.35% -5.90 60.00 69.00 63.10 2.34 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.30 0.00 1.00 0.30 0.46 innodb select_distinct 4.00 +13.04% 0.60 4.00 5.00 4.60 0.49 innodb select_group 15.00 +12.02% 2.05 15.00 19.00 17.05 1.47 innodb select_group_when_MANY_tables 13.00 -6.12% -0.75 11.00 14.00 12.25 0.83 innodb select_join 1.00 -42.86% -0.30 0.00 1.00 0.70 0.46 innodb select_key 64.00 -0.55% -0.35 63.00 66.00 63.65 0.73 innodb select_key2 72.00 -1.34% -0.95 70.00 73.00 71.05 1.02 innodb select_key2_return_key 68.00 +0.58% 0.40 67.00 71.00 68.40 0.92 innodb select_key2_return_prim 69.00 +0.36% 0.25 68.00 71.00 69.25 0.89 innodb select_key_prefix 71.00 -0.42% -0.30 69.00 73.00 70.70 0.84 innodb select_key_prefix_join 5.00 +2.91% 0.15 5.00 6.00 5.15 0.36 innodb select_key_return_key 62.00 +1.43% 0.90 62.00 64.00 62.90 0.62 innodb select_many_fields 13.00 +1.89% 0.25 13.00 14.00 13.25 0.43 innodb select_range 40.00 +4.88% 2.05 39.00 49.00 42.05 2.44 innodb select_range_key2 9.00 +5.76% 0.55 9.00 10.00 9.55 0.50 innodb select_range_prefix 10.00 -8.70% -0.80 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 1.00 -42.86% -0.30 0.00 1.00 0.70 0.46 innodb update_autocommit 4.00 -8.11% -0.30 3.00 4.00 3.70 0.46 innodb update_big 61.00 -2.69% -1.60 56.00 64.00 59.40 2.15 innodb update_commit 2.00 -2.56% -0.05 1.00 2.00 1.95 0.22 innodb update_of_key 22.00 +0.68% 0.15 21.00 24.00 22.15 1.06 innodb update_of_key_big 37.00 -3.64% -1.30 29.00 47.00 35.70 3.77 innodb update_of_primary_key_many_keys 1457.00 -6.79% -92.65 1203.00 1482.00 1364.35 82.16 innodb update_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_with_key 122.00 +0.16% 0.20 117.00 127.00 122.20 2.56 innodb update_with_key_prefix 48.00 -8.60% -3.80 40.00 50.00 44.20 2.48 innodb wisc_benchmark 3.00 -13.21% -0.35 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 34.00 -64.98% -13.39 11.00 61.00 20.61 10.02 innodb alter_table_drop 24.00 -31.97% -5.81 10.00 57.00 18.19 7.00 innodb connect 2.00 +3.77% 0.08 1.00 3.00 2.08 0.42 innodb connect+select_1_row 3.00 -11.41% -0.31 2.00 5.00 2.69 0.48 innodb connect+select_simple 3.00 -28.55% -0.67 1.00 3.00 2.33 0.48 innodb count 18.00 -14.24% -2.24 12.00 193.00 15.76 8.98 innodb count_distinct 7.00 -6.63% -0.44 5.00 50.00 6.56 2.31 innodb count_distinct_2 14.00 -6.39% -0.84 11.00 63.00 13.16 2.99 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.51% -1.90 10.00 68.00 13.10 3.13 innodb count_distinct_group_on_key 9.00 +5.03% 0.48 7.00 69.00 9.48 3.07 innodb count_distinct_group_on_key_parts 14.00 -13.99% -1.72 9.00 72.00 12.28 3.20 innodb count_distinct_key_prefix 7.00 -36.70% -1.88 3.00 52.00 5.12 2.43 innodb count_group_on_key_parts 11.00 -10.64% -1.06 7.00 72.00 9.94 3.20 innodb count_on_key 93.00 -8.54% -7.32 68.00 107.00 85.68 7.31 innodb create+drop 32.00 +1.26% 0.41 18.00 75.00 32.41 12.11 innodb create_index 4.00 -39.20% -1.13 1.00 8.00 2.87 1.15 innodb create_key+drop 29.00 -3.29% -0.92 21.00 50.00 28.08 4.96 innodb create_MANY_tables 21.00 +39.23% 13.55 14.00 121.00 34.55 17.21 innodb create_table 0.00 +100.00% 0.11 0.00 3.00 0.11 0.37 innodb delete_all_many_keys 716.00 -56.73% -259.15 212.00 1888.00 456.85 369.83 innodb delete_autocommit 3.00 +12.61% 0.43 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 715.00 -54.34% -251.74 212.00 2293.00 463.26 384.50 innodb delete_commit 2.00 -33.39% -0.50 1.00 5.00 1.50 0.53 innodb delete_key 3.00 +2.24% 0.07 2.00 35.00 3.07 1.52 innodb delete_range 9.00 -8.63% -0.71 5.00 23.00 8.29 3.29 innodb delete_rollback 2.00 -16.03% -0.28 1.00 12.00 1.72 0.93 innodb drop_index 3.00 -1.76% -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 17.00 +13.32% 2.61 11.00 90.00 19.61 7.66 innodb insert 114.00 -7.11% -7.57 3.00 343.00 106.43 14.80 innodb insert_autocommit 3.00 -0.28% -0.01 2.00 99.00 2.99 3.38 innodb insert_commit 2.00 -47.25% -0.64 1.00 3.00 1.36 0.49 innodb insert_duplicates 19.00 -24.02% -3.68 11.00 21.00 15.32 2.60 innodb insert_key 297.00 +2.33% 7.09 142.00 700.00 304.09 109.16 innodb insert_many_fields 5.00 +10.64% 0.60 3.00 17.00 5.60 1.80 innodb insert_rollback 2.00 -21.11% -0.35 1.00 3.00 1.65 0.53 innodb insert_select_1_key 3.00 +20.59% 0.78 2.00 10.00 3.78 0.90 innodb insert_select_2_keys 6.00 +1.15% 0.07 4.00 16.00 6.07 2.13 innodb min_max 9.00 -15.04% -1.18 6.00 110.00 7.82 4.63 innodb min_max_on_key 25.00 -22.65% -4.62 14.00 37.00 20.38 3.03 innodb multiple_value_insert 7.00 -29.23% -1.58 2.00 50.00 5.42 4.36 innodb once_prepared_select 29.00 -20.77% -4.99 18.00 32.00 24.01 3.49 innodb order_by_big 16.00 -11.87% -1.70 12.00 31.00 14.30 1.54 innodb order_by_big_key 15.00 -13.38% -1.77 11.00 32.00 13.23 1.63 innodb order_by_big_key2 14.00 -15.14% -1.84 10.00 33.00 12.16 1.55 innodb order_by_big_key_desc 16.00 -19.06% -2.56 11.00 32.00 13.44 1.67 innodb order_by_big_key_diff 13.00 -6.61% -0.81 10.00 31.00 12.19 1.51 innodb order_by_big_key_prefix 14.00 -13.19% -1.63 10.00 32.00 12.37 1.58 innodb order_by_key2_diff 1.00 +28.44% 0.40 1.00 3.00 1.40 0.49 innodb order_by_key_prefix 1.00 -26.99% -0.21 0.00 2.00 0.79 0.41 innodb order_by_range 1.00 -20.88% -0.17 0.00 2.00 0.83 0.38 innodb outer_join 19.00 +1.26% 0.24 15.00 61.00 19.24 3.73 innodb outer_join_found 18.00 +3.62% 0.68 14.00 58.00 18.68 3.59 innodb outer_join_not_found 18.00 -10.03% -1.64 12.00 46.00 16.36 3.17 innodb outer_join_on_key 13.00 -1.26% -0.16 10.00 59.00 12.84 2.79 innodb prepared_select 37.00 -19.04% -5.92 22.00 40.00 31.08 4.43 innodb select_1_row 3.00 -6.09% -0.17 2.00 4.00 2.83 0.69 innodb select_1_row_cache 4.00 -51.25% -1.36 2.00 4.00 2.64 0.67 innodb select_2_rows 3.00 -5.37% -0.15 2.00 4.00 2.85 0.69 innodb select_big 12.00 +1.08% 0.13 0.00 31.00 12.13 1.56 innodb select_big_str 1.00 +13.12% 0.15 0.00 2.00 1.15 0.36 innodb select_cache 68.00 -14.31% -8.51 49.00 77.00 59.49 5.64 innodb select_cache2 69.00 -15.20% -9.11 49.00 75.00 59.89 6.36 innodb select_column+column 4.00 -38.22% -1.11 2.00 4.00 2.89 0.71 innodb select_diff_key 0.00 +100.00% 0.22 0.00 1.00 0.22 0.41 innodb select_distinct 4.00 +5.36% 0.23 3.00 8.00 4.23 0.54 innodb select_group 15.00 +7.63% 1.24 4.00 136.00 16.24 5.53 innodb select_group_when_MANY_tables 13.00 -38.92% -3.64 3.00 49.00 9.36 9.62 innodb select_join 1.00 -72.92% -0.42 0.00 1.00 0.58 0.49 innodb select_key 64.00 -22.36% -11.70 40.00 66.00 52.30 7.24 innodb select_key2 72.00 -22.08% -13.02 45.00 75.00 58.98 8.12 innodb select_key2_return_key 68.00 -20.78% -11.70 42.00 71.00 56.30 7.90 innodb select_key2_return_prim 69.00 -20.92% -11.94 42.00 72.00 57.06 8.05 innodb select_key_prefix 71.00 -21.96% -12.78 44.00 75.00 58.22 8.12 innodb select_key_prefix_join 5.00 -6.27% -0.30 3.00 10.00 4.70 0.66 innodb select_key_return_key 62.00 -20.79% -10.67 38.00 65.00 51.33 7.25 innodb select_many_fields 13.00 +13.41% 2.01 11.00 19.00 15.01 1.79 innodb select_range 40.00 +15.35% 7.26 39.00 76.00 47.26 3.91 innodb select_range_key2 9.00 -9.62% -0.79 6.00 11.00 8.21 1.03 innodb select_range_prefix 10.00 -28.55% -2.22 5.00 10.00 7.78 1.09 innodb select_simple 2.00 -22.60% -0.37 1.00 3.00 1.63 0.51 innodb select_simple_cache 2.00 -30.20% -0.46 1.00 3.00 1.54 0.52 innodb select_simple_join 1.00 -53.99% -0.35 0.00 3.00 0.65 0.48 innodb update_autocommit 4.00 -20.58% -0.68 2.00 16.00 3.32 1.02 innodb update_big 61.00 -20.40% -10.34 31.00 195.00 50.66 24.89 innodb update_commit 2.00 -29.33% -0.45 1.00 10.00 1.55 0.74 innodb update_of_key 22.00 +9.49% 2.31 18.00 100.00 24.31 6.28 innodb update_of_key_big 37.00 -36.43% -9.88 15.00 75.00 27.12 11.03 innodb update_of_primary_key_many_keys 1457.00 -17.97% -221.94 647.00 6065.00 1235.06 983.24 innodb update_rollback 2.00 -14.58% -0.25 1.00 31.00 1.75 1.93 innodb update_with_key 122.00 -11.53% -12.61 90.00 598.00 109.39 21.05 innodb update_with_key_prefix 48.00 -21.75% -8.57 33.00 202.00 39.43 6.86 innodb wisc_benchmark 3.00 -21.26% -0.53 2.00 5.00 2.47 0.53 ========================================================================================================================= FULL REVISION COMMENTARY: 2167.3.2: Brian Aker 2011-02-14 Make use of isDateTime 2167.3.1: Brian Aker 2011-02-14 Fix issues where int display length may be too small, and fix collation _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
