======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 1019 RUN DATE: 2011-04-25T17:02:41.895827 SERVER: drizzled VERSION: elliott-staging REVISION: 2244 COMMENT: 2244: Brian Aker 2011-04-10 Fix for bug 755201
========================================================================================================================= 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 33.00 32.20 0.75 innodb alter_table_drop 23.00 +1.71% 0.40 23.00 25.00 23.40 0.80 innodb connect 2.00 +16.67% 0.40 2.00 3.00 2.40 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 3.00 -15.38% -0.40 2.00 3.00 2.60 0.49 innodb count 15.00 -2.74% -0.40 13.00 17.00 14.60 1.36 innodb count_distinct 6.00 +6.25% 0.40 6.00 7.00 6.40 0.49 innodb count_distinct_2 13.00 +1.52% 0.20 12.00 16.00 13.20 1.47 innodb count_distinct_big 21.00 +1.87% 0.40 20.00 24.00 21.40 1.36 innodb count_distinct_group 15.00 -0.00% 0.00 14.00 16.00 15.00 0.63 innodb count_distinct_group_on_key 11.00 -14.58% -1.40 9.00 11.00 9.60 0.80 innodb count_distinct_group_on_key_parts 14.00 -6.06% -0.80 12.00 14.00 13.20 0.98 innodb count_distinct_key_prefix 5.00 +7.41% 0.40 5.00 6.00 5.40 0.49 innodb count_group_on_key_parts 12.00 -9.09% -1.00 10.00 12.00 11.00 0.63 innodb count_on_key 93.00 +1.90% 1.80 93.00 96.00 94.80 0.98 innodb create+drop 34.00 +1.16% 0.40 34.00 35.00 34.40 0.49 innodb create_index 3.00 +6.25% 0.20 3.00 4.00 3.20 0.40 innodb create_key+drop 32.00 -2.56% -0.80 30.00 32.00 31.20 0.98 innodb create_MANY_tables 20.00 -0.00% 0.00 19.00 21.00 20.00 0.63 innodb delete_all_many_keys 627.00 +2.09% 13.40 625.00 668.00 640.40 16.38 innodb delete_autocommit 3.00 +16.67% 0.60 3.00 5.00 3.60 0.80 innodb delete_big 1.00 -150.00% -0.60 0.00 1.00 0.40 0.49 innodb delete_big_many_keys 626.00 +2.13% 13.60 624.00 667.00 639.60 16.28 innodb delete_commit 2.00 -11.11% -0.20 1.00 2.00 1.80 0.40 innodb delete_key 3.00 -7.14% -0.20 2.00 3.00 2.80 0.40 innodb delete_range 8.00 +4.76% 0.40 8.00 9.00 8.40 0.49 innodb delete_rollback 2.00 +9.09% 0.20 2.00 3.00 2.20 0.40 innodb drop_index 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb drop_table_when_MANY_tables 18.00 +2.17% 0.40 18.00 20.00 18.40 0.80 innodb insert 113.00 +1.22% 1.40 113.00 116.00 114.40 1.36 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 19.00 -0.00% 0.00 19.00 19.00 19.00 0.00 innodb insert_key 276.00 -0.29% -0.80 270.00 278.00 275.20 2.79 innodb insert_many_fields 6.00 -0.00% 0.00 6.00 6.00 6.00 0.00 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 4.00 3.60 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 -18.42% -1.40 7.00 9.00 7.60 0.80 innodb min_max_on_key 24.00 +3.23% 0.80 24.00 25.00 24.80 0.40 innodb multiple_value_insert 6.00 +3.23% 0.20 6.00 7.00 6.20 0.40 innodb once_prepared_select 29.00 -0.00% 0.00 29.00 29.00 29.00 0.00 innodb order_by_big 16.00 -6.67% -1.00 13.00 16.00 15.00 1.10 innodb order_by_big_key 16.00 -6.67% -1.00 13.00 16.00 15.00 1.10 innodb order_by_big_key2 13.00 -3.17% -0.40 12.00 13.00 12.60 0.49 innodb order_by_big_key_desc 17.00 -11.84% -1.80 14.00 17.00 15.20 1.17 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 -6.06% -0.80 12.00 14.00 13.20 0.75 innodb order_by_key2_diff 2.00 -42.86% -0.60 1.00 2.00 1.40 0.49 innodb order_by_key_prefix 0.00 +100.00% 0.80 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 24.00 -8.11% -1.80 17.00 25.00 22.20 2.79 innodb outer_join_found 22.00 -5.77% -1.20 16.00 23.00 20.80 2.48 innodb outer_join_not_found 21.00 -9.38% -1.80 15.00 21.00 19.20 2.23 innodb outer_join_on_key 17.00 -14.86% -2.20 11.00 17.00 14.80 2.04 innodb prepared_select 38.00 -1.60% -0.60 37.00 38.00 37.40 0.49 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 15.00 -19.05% -2.40 12.00 15.00 12.60 1.20 innodb select_big_str 1.00 +28.57% 0.40 1.00 2.00 1.40 0.49 innodb select_cache 60.00 +5.06% 3.20 60.00 68.00 63.20 2.64 innodb select_cache2 63.00 +0.94% 0.60 59.00 68.00 63.60 2.94 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 5.00 -4.17% -0.20 4.00 5.00 4.80 0.40 innodb select_group 20.00 -17.65% -3.00 15.00 20.00 17.00 1.79 innodb select_group_when_MANY_tables 12.00 -3.45% -0.40 11.00 12.00 11.60 0.49 innodb select_join 0.00 +100.00% 0.80 0.00 1.00 0.80 0.40 innodb select_key 65.00 -0.31% -0.20 64.00 65.00 64.80 0.40 innodb select_key2 71.00 +0.28% 0.20 70.00 72.00 71.20 0.75 innodb select_key2_return_key 69.00 -0.00% 0.00 68.00 70.00 69.00 0.63 innodb select_key2_return_prim 69.00 +0.86% 0.60 69.00 70.00 69.60 0.49 innodb select_key_prefix 71.00 -0.28% -0.20 69.00 72.00 70.80 0.98 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.63% -0.40 63.00 64.00 63.60 0.49 innodb select_many_fields 14.00 -4.48% -0.60 13.00 14.00 13.40 0.49 innodb select_range 42.00 +3.23% 1.40 40.00 46.00 43.40 2.33 innodb select_range_key2 10.00 -2.04% -0.20 9.00 10.00 9.80 0.40 innodb select_range_prefix 9.00 +4.26% 0.40 9.00 10.00 9.40 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 -150.00% -0.60 0.00 1.00 0.40 0.49 innodb update_autocommit 4.00 -5.26% -0.20 3.00 4.00 3.80 0.40 innodb update_big 60.00 -2.04% -1.20 58.00 60.00 58.80 0.75 innodb update_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_of_key 23.00 +0.86% 0.20 22.00 25.00 23.20 1.17 innodb update_of_key_big 33.00 +7.82% 2.80 33.00 38.00 35.80 1.72 innodb update_of_primary_key_many_keys 1322.00 -0.32% -4.20 1284.00 1337.00 1317.80 18.68 innodb update_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_with_key 122.00 +0.81% 1.00 121.00 125.00 123.00 1.67 innodb update_with_key_prefix 49.00 -7.93% -3.60 40.00 49.00 45.40 3.14 innodb wisc_benchmark 2.00 +16.67% 0.40 2.00 3.00 2.40 0.49 ========================================================================================================================= TRENDING OVER LAST 20 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 32.00 -16.89% -4.63 13.00 33.00 27.38 8.32 innodb alter_table_drop 23.00 -7.60% -1.63 15.00 25.00 21.38 3.74 innodb connect 2.00 +5.88% 0.13 1.00 3.00 2.13 0.60 innodb connect+select_1_row 3.00 -9.09% -0.25 2.00 3.00 2.75 0.43 innodb connect+select_simple 3.00 -20.00% -0.50 2.00 3.00 2.50 0.50 innodb count 15.00 +0.83% 0.13 13.00 18.00 15.13 1.83 innodb count_distinct 6.00 +4.00% 0.25 6.00 7.00 6.25 0.43 innodb count_distinct_2 13.00 -4.00% -0.50 11.00 16.00 12.50 1.50 innodb count_distinct_big 21.00 +4.00% 0.88 20.00 25.00 21.88 1.76 innodb count_distinct_group 15.00 -7.14% -1.00 11.00 16.00 14.00 1.80 innodb count_distinct_group_on_key 11.00 -18.92% -1.75 8.00 11.00 9.25 0.83 innodb count_distinct_group_on_key_parts 14.00 -14.29% -1.75 10.00 14.00 12.25 1.48 innodb count_distinct_key_prefix 5.00 +2.44% 0.13 4.00 6.00 5.13 0.60 innodb count_group_on_key_parts 12.00 -10.34% -1.13 10.00 12.00 10.88 0.78 innodb count_on_key 93.00 -0.54% -0.50 85.00 96.00 92.50 4.42 innodb create+drop 34.00 -4.62% -1.50 24.00 35.00 32.50 3.43 innodb create_index 3.00 +4.00% 0.13 2.00 4.00 3.13 0.60 innodb create_key+drop 32.00 -6.67% -2.00 26.00 32.00 30.00 2.18 innodb create_MANY_tables 20.00 +6.43% 1.38 19.00 28.00 21.38 2.64 innodb delete_all_many_keys 627.00 -16.08% -86.88 220.00 668.00 540.13 174.32 innodb delete_autocommit 3.00 +17.24% 0.63 3.00 5.00 3.63 0.70 innodb delete_big 1.00 -166.67% -0.63 0.00 1.00 0.38 0.48 innodb delete_big_many_keys 626.00 -16.06% -86.63 220.00 667.00 539.38 174.16 innodb delete_commit 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb delete_key 3.00 -4.35% -0.13 2.00 3.00 2.88 0.33 innodb delete_range 8.00 -3.23% -0.25 6.00 9.00 7.75 1.09 innodb delete_rollback 2.00 -0.00% 0.00 1.00 3.00 2.00 0.50 innodb drop_index 3.00 -9.09% -0.25 2.00 3.00 2.75 0.43 innodb drop_table_when_MANY_tables 18.00 -2.13% -0.38 14.00 20.00 17.63 1.73 innodb insert 113.00 -0.00% 0.00 106.00 116.00 113.00 3.28 innodb insert_autocommit 3.00 +7.69% 0.25 3.00 4.00 3.25 0.43 innodb insert_commit 2.00 -23.08% -0.38 1.00 2.00 1.63 0.48 innodb insert_duplicates 19.00 -7.80% -1.38 13.00 19.00 17.63 2.39 innodb insert_key 276.00 -10.62% -26.50 162.00 278.00 249.50 45.08 innodb insert_many_fields 6.00 -2.13% -0.13 5.00 6.00 5.88 0.33 innodb insert_rollback 2.00 -6.67% -0.13 1.00 2.00 1.88 0.33 innodb insert_select_1_key 4.00 -10.34% -0.38 3.00 5.00 3.63 0.70 innodb insert_select_2_keys 6.00 -4.35% -0.25 4.00 7.00 5.75 0.97 innodb min_max 9.00 -16.13% -1.25 7.00 9.00 7.75 0.83 innodb min_max_on_key 24.00 -2.13% -0.50 19.00 25.00 23.50 2.35 innodb multiple_value_insert 6.00 -14.29% -0.75 3.00 7.00 5.25 1.39 innodb once_prepared_select 29.00 -4.98% -1.38 22.00 29.00 27.63 2.34 innodb order_by_big 16.00 -13.27% -1.88 12.00 16.00 14.13 1.45 innodb order_by_big_key 16.00 -15.32% -2.13 12.00 16.00 13.88 1.69 innodb order_by_big_key2 13.00 -8.33% -1.00 11.00 13.00 12.00 0.87 innodb order_by_big_key_desc 17.00 -18.26% -2.63 12.00 17.00 14.38 1.49 innodb order_by_big_key_diff 14.00 -14.29% -1.75 10.00 14.00 12.25 1.30 innodb order_by_big_key_prefix 14.00 -10.89% -1.38 11.00 14.00 12.63 0.99 innodb order_by_key2_diff 2.00 -45.45% -0.63 1.00 2.00 1.38 0.48 innodb order_by_key_prefix 0.00 +100.00% 0.88 0.00 1.00 0.88 0.33 innodb order_by_range 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb outer_join 24.00 -17.79% -3.63 15.00 25.00 20.38 3.39 innodb outer_join_found 22.00 -12.10% -2.38 16.00 23.00 19.63 2.60 innodb outer_join_not_found 21.00 -17.48% -3.13 14.00 21.00 17.88 2.57 innodb outer_join_on_key 17.00 -21.43% -3.00 11.00 17.00 14.00 1.94 innodb prepared_select 38.00 -7.04% -2.50 27.00 38.00 35.50 3.54 innodb select_1_row 4.00 -14.29% -0.50 2.00 4.00 3.50 0.71 innodb select_1_row_cache 3.00 +4.00% 0.13 2.00 4.00 3.13 0.60 innodb select_2_rows 4.00 -18.52% -0.63 2.00 4.00 3.38 0.70 innodb select_big 15.00 -21.21% -2.63 11.00 15.00 12.38 1.32 innodb select_big_str 1.00 +27.27% 0.38 1.00 2.00 1.38 0.48 innodb select_cache 60.00 +1.64% 1.00 53.00 68.00 61.00 5.15 innodb select_cache2 63.00 -1.82% -1.13 52.00 71.00 61.88 6.13 innodb select_column+column 4.00 -6.67% -0.25 3.00 4.00 3.75 0.43 innodb select_diff_key 0.00 +100.00% 0.13 0.00 1.00 0.13 0.33 innodb select_distinct 5.00 -5.26% -0.25 4.00 5.00 4.75 0.43 innodb select_group 20.00 -15.11% -2.63 15.00 20.00 17.38 1.49 innodb select_group_when_MANY_tables 12.00 -23.08% -2.25 4.00 12.00 9.75 3.07 innodb select_join 0.00 +100.00% 0.63 0.00 1.00 0.63 0.48 innodb select_key 65.00 -6.12% -3.75 51.00 65.00 61.25 5.93 innodb select_key2 71.00 -3.65% -2.50 55.00 72.00 68.50 5.41 innodb select_key2_return_key 69.00 -4.74% -3.13 54.00 70.00 65.88 5.37 innodb select_key2_return_prim 69.00 -3.18% -2.13 55.00 70.00 66.88 4.99 innodb select_key_prefix 71.00 -6.17% -4.13 55.00 72.00 66.88 6.62 innodb select_key_prefix_join 5.00 -5.26% -0.25 4.00 5.00 4.75 0.43 innodb select_key_return_key 64.00 -6.89% -4.13 49.00 64.00 59.88 6.03 innodb select_many_fields 14.00 -0.00% 0.00 13.00 17.00 14.00 1.32 innodb select_range 42.00 +4.55% 2.00 40.00 46.00 44.00 2.00 innodb select_range_key2 10.00 -6.67% -0.63 8.00 10.00 9.38 0.86 innodb select_range_prefix 9.00 -1.41% -0.13 7.00 10.00 8.88 0.93 innodb select_simple 2.00 -0.00% 0.00 1.00 3.00 2.00 0.50 innodb select_simple_cache 2.00 -6.67% -0.13 1.00 2.00 1.88 0.33 innodb select_simple_join 1.00 -100.00% -0.50 0.00 1.00 0.50 0.50 innodb update_autocommit 4.00 -10.34% -0.38 3.00 4.00 3.63 0.48 innodb update_big 60.00 -12.94% -6.88 35.00 60.00 53.13 10.20 innodb update_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_of_key 23.00 -0.00% 0.00 21.00 25.00 23.00 1.22 innodb update_of_key_big 33.00 -6.88% -2.13 18.00 38.00 30.88 7.25 innodb update_of_primary_key_many_keys 1322.00 -12.24% -144.13 699.00 1337.00 1177.88 244.91 innodb update_rollback 2.00 -6.67% -0.13 1.00 2.00 1.88 0.33 innodb update_with_key 122.00 -2.74% -3.25 107.00 125.00 118.75 6.70 innodb update_with_key_prefix 49.00 -12.97% -5.63 36.00 49.00 43.38 4.27 innodb wisc_benchmark 2.00 +15.79% 0.38 2.00 3.00 2.38 0.48 ========================================================================================================================= TRENDING OVER ALL runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 32.00 -16.89% -4.63 13.00 33.00 27.38 8.32 innodb alter_table_drop 23.00 -7.60% -1.63 15.00 25.00 21.38 3.74 innodb connect 2.00 +5.88% 0.13 1.00 3.00 2.13 0.60 innodb connect+select_1_row 3.00 -9.09% -0.25 2.00 3.00 2.75 0.43 innodb connect+select_simple 3.00 -20.00% -0.50 2.00 3.00 2.50 0.50 innodb count 15.00 +0.83% 0.13 13.00 18.00 15.13 1.83 innodb count_distinct 6.00 +4.00% 0.25 6.00 7.00 6.25 0.43 innodb count_distinct_2 13.00 -4.00% -0.50 11.00 16.00 12.50 1.50 innodb count_distinct_big 21.00 +4.00% 0.88 20.00 25.00 21.88 1.76 innodb count_distinct_group 15.00 -7.14% -1.00 11.00 16.00 14.00 1.80 innodb count_distinct_group_on_key 11.00 -18.92% -1.75 8.00 11.00 9.25 0.83 innodb count_distinct_group_on_key_parts 14.00 -14.29% -1.75 10.00 14.00 12.25 1.48 innodb count_distinct_key_prefix 5.00 +2.44% 0.13 4.00 6.00 5.13 0.60 innodb count_group_on_key_parts 12.00 -10.34% -1.13 10.00 12.00 10.88 0.78 innodb count_on_key 93.00 -0.54% -0.50 85.00 96.00 92.50 4.42 innodb create+drop 34.00 -4.62% -1.50 24.00 35.00 32.50 3.43 innodb create_index 3.00 +4.00% 0.13 2.00 4.00 3.13 0.60 innodb create_key+drop 32.00 -6.67% -2.00 26.00 32.00 30.00 2.18 innodb create_MANY_tables 20.00 +6.43% 1.38 19.00 28.00 21.38 2.64 innodb delete_all_many_keys 627.00 -16.08% -86.88 220.00 668.00 540.13 174.32 innodb delete_autocommit 3.00 +17.24% 0.63 3.00 5.00 3.63 0.70 innodb delete_big 1.00 -166.67% -0.63 0.00 1.00 0.38 0.48 innodb delete_big_many_keys 626.00 -16.06% -86.63 220.00 667.00 539.38 174.16 innodb delete_commit 2.00 -14.29% -0.25 1.00 2.00 1.75 0.43 innodb delete_key 3.00 -4.35% -0.13 2.00 3.00 2.88 0.33 innodb delete_range 8.00 -3.23% -0.25 6.00 9.00 7.75 1.09 innodb delete_rollback 2.00 -0.00% 0.00 1.00 3.00 2.00 0.50 innodb drop_index 3.00 -9.09% -0.25 2.00 3.00 2.75 0.43 innodb drop_table_when_MANY_tables 18.00 -2.13% -0.38 14.00 20.00 17.63 1.73 innodb insert 113.00 -0.00% 0.00 106.00 116.00 113.00 3.28 innodb insert_autocommit 3.00 +7.69% 0.25 3.00 4.00 3.25 0.43 innodb insert_commit 2.00 -23.08% -0.38 1.00 2.00 1.63 0.48 innodb insert_duplicates 19.00 -7.80% -1.38 13.00 19.00 17.63 2.39 innodb insert_key 276.00 -10.62% -26.50 162.00 278.00 249.50 45.08 innodb insert_many_fields 6.00 -2.13% -0.13 5.00 6.00 5.88 0.33 innodb insert_rollback 2.00 -6.67% -0.13 1.00 2.00 1.88 0.33 innodb insert_select_1_key 4.00 -10.34% -0.38 3.00 5.00 3.63 0.70 innodb insert_select_2_keys 6.00 -4.35% -0.25 4.00 7.00 5.75 0.97 innodb min_max 9.00 -16.13% -1.25 7.00 9.00 7.75 0.83 innodb min_max_on_key 24.00 -2.13% -0.50 19.00 25.00 23.50 2.35 innodb multiple_value_insert 6.00 -14.29% -0.75 3.00 7.00 5.25 1.39 innodb once_prepared_select 29.00 -4.98% -1.38 22.00 29.00 27.63 2.34 innodb order_by_big 16.00 -13.27% -1.88 12.00 16.00 14.13 1.45 innodb order_by_big_key 16.00 -15.32% -2.13 12.00 16.00 13.88 1.69 innodb order_by_big_key2 13.00 -8.33% -1.00 11.00 13.00 12.00 0.87 innodb order_by_big_key_desc 17.00 -18.26% -2.63 12.00 17.00 14.38 1.49 innodb order_by_big_key_diff 14.00 -14.29% -1.75 10.00 14.00 12.25 1.30 innodb order_by_big_key_prefix 14.00 -10.89% -1.38 11.00 14.00 12.63 0.99 innodb order_by_key2_diff 2.00 -45.45% -0.63 1.00 2.00 1.38 0.48 innodb order_by_key_prefix 0.00 +100.00% 0.88 0.00 1.00 0.88 0.33 innodb order_by_range 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb outer_join 24.00 -17.79% -3.63 15.00 25.00 20.38 3.39 innodb outer_join_found 22.00 -12.10% -2.38 16.00 23.00 19.63 2.60 innodb outer_join_not_found 21.00 -17.48% -3.13 14.00 21.00 17.88 2.57 innodb outer_join_on_key 17.00 -21.43% -3.00 11.00 17.00 14.00 1.94 innodb prepared_select 38.00 -7.04% -2.50 27.00 38.00 35.50 3.54 innodb select_1_row 4.00 -14.29% -0.50 2.00 4.00 3.50 0.71 innodb select_1_row_cache 3.00 +4.00% 0.13 2.00 4.00 3.13 0.60 innodb select_2_rows 4.00 -18.52% -0.63 2.00 4.00 3.38 0.70 innodb select_big 15.00 -21.21% -2.63 11.00 15.00 12.38 1.32 innodb select_big_str 1.00 +27.27% 0.38 1.00 2.00 1.38 0.48 innodb select_cache 60.00 +1.64% 1.00 53.00 68.00 61.00 5.15 innodb select_cache2 63.00 -1.82% -1.13 52.00 71.00 61.88 6.13 innodb select_column+column 4.00 -6.67% -0.25 3.00 4.00 3.75 0.43 innodb select_diff_key 0.00 +100.00% 0.13 0.00 1.00 0.13 0.33 innodb select_distinct 5.00 -5.26% -0.25 4.00 5.00 4.75 0.43 innodb select_group 20.00 -15.11% -2.63 15.00 20.00 17.38 1.49 innodb select_group_when_MANY_tables 12.00 -23.08% -2.25 4.00 12.00 9.75 3.07 innodb select_join 0.00 +100.00% 0.63 0.00 1.00 0.63 0.48 innodb select_key 65.00 -6.12% -3.75 51.00 65.00 61.25 5.93 innodb select_key2 71.00 -3.65% -2.50 55.00 72.00 68.50 5.41 innodb select_key2_return_key 69.00 -4.74% -3.13 54.00 70.00 65.88 5.37 innodb select_key2_return_prim 69.00 -3.18% -2.13 55.00 70.00 66.88 4.99 innodb select_key_prefix 71.00 -6.17% -4.13 55.00 72.00 66.88 6.62 innodb select_key_prefix_join 5.00 -5.26% -0.25 4.00 5.00 4.75 0.43 innodb select_key_return_key 64.00 -6.89% -4.13 49.00 64.00 59.88 6.03 innodb select_many_fields 14.00 -0.00% 0.00 13.00 17.00 14.00 1.32 innodb select_range 42.00 +4.55% 2.00 40.00 46.00 44.00 2.00 innodb select_range_key2 10.00 -6.67% -0.63 8.00 10.00 9.38 0.86 innodb select_range_prefix 9.00 -1.41% -0.13 7.00 10.00 8.88 0.93 innodb select_simple 2.00 -0.00% 0.00 1.00 3.00 2.00 0.50 innodb select_simple_cache 2.00 -6.67% -0.13 1.00 2.00 1.88 0.33 innodb select_simple_join 1.00 -100.00% -0.50 0.00 1.00 0.50 0.50 innodb update_autocommit 4.00 -10.34% -0.38 3.00 4.00 3.63 0.48 innodb update_big 60.00 -12.94% -6.88 35.00 60.00 53.13 10.20 innodb update_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_of_key 23.00 -0.00% 0.00 21.00 25.00 23.00 1.22 innodb update_of_key_big 33.00 -6.88% -2.13 18.00 38.00 30.88 7.25 innodb update_of_primary_key_many_keys 1322.00 -12.24% -144.13 699.00 1337.00 1177.88 244.91 innodb update_rollback 2.00 -6.67% -0.13 1.00 2.00 1.88 0.33 innodb update_with_key 122.00 -2.74% -3.25 107.00 125.00 118.75 6.70 innodb update_with_key_prefix 49.00 -12.97% -5.63 36.00 49.00 43.38 4.27 innodb wisc_benchmark 2.00 +15.79% 0.38 2.00 3.00 2.38 0.48 ========================================================================================================================= _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
