======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 726 RUN DATE: 2010-12-09T01:04:06.306198 SERVER: drizzled VERSION: staging REVISION: 1990 COMMENT: 1990: Brian Aker 2010-12-08 Fixed table issue (I was not removing some tables after the test was done).
========================================================================================================================= TRENDING OVER LAST 5 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 36.00 -1.69% -0.60 15.00 49.00 35.40 11.50 innodb alter_table_drop 34.00 -21.43% -6.00 13.00 35.00 28.00 8.00 innodb connect 2.00 +9.09% 0.20 2.00 3.00 2.20 0.40 innodb connect+select_1_row 3.00 -15.38% -0.40 2.00 3.00 2.60 0.49 innodb connect+select_simple 3.00 -25.00% -0.60 2.00 3.00 2.40 0.49 innodb count 14.00 +9.09% 1.40 14.00 18.00 15.40 1.74 innodb count_distinct 7.00 -2.94% -0.20 5.00 8.00 6.80 1.17 innodb count_distinct_2 13.00 +9.72% 1.40 13.00 17.00 14.40 1.50 innodb count_distinct_big 20.00 +8.26% 1.80 20.00 24.00 21.80 1.83 innodb count_distinct_group 14.00 +2.78% 0.40 14.00 15.00 14.40 0.49 innodb count_distinct_group_on_key 9.00 +8.16% 0.80 9.00 11.00 9.80 0.75 innodb count_distinct_group_on_key_parts 12.00 +10.45% 1.40 12.00 15.00 13.40 1.02 innodb count_distinct_key_prefix 5.00 +3.85% 0.20 5.00 6.00 5.20 0.40 innodb count_group_on_key_parts 10.00 +3.85% 0.40 10.00 12.00 10.40 0.80 innodb count_on_key 89.00 +2.84% 2.60 89.00 96.00 91.60 2.58 innodb create+drop 70.00 -20.69% -12.00 26.00 81.00 58.00 19.61 innodb create_index 6.00 -30.43% -1.40 2.00 6.00 4.60 1.50 innodb create_key+drop 41.00 -8.47% -3.20 28.00 43.00 37.80 5.64 innodb create_MANY_tables 63.00 -31.80% -15.20 16.00 63.00 47.80 16.41 innodb delete_all_many_keys 1391.00 -30.51% -325.20 295.00 1838.00 1065.80 632.89 innodb delete_autocommit 4.00 -17.65% -0.60 3.00 4.00 3.40 0.49 innodb delete_big 1.00 -66.67% -0.40 0.00 1.00 0.60 0.49 innodb delete_big_many_keys 1390.00 -30.54% -325.20 295.00 1835.00 1064.80 631.92 innodb delete_commit 1.00 +37.50% 0.60 1.00 2.00 1.60 0.49 innodb delete_key 3.00 +11.76% 0.40 3.00 5.00 3.40 0.80 innodb delete_range 19.00 -23.38% -3.60 6.00 20.00 15.40 5.31 innodb delete_rollback 3.00 -15.38% -0.40 2.00 3.00 2.60 0.49 innodb drop_index 4.00 +4.76% 0.20 3.00 6.00 4.20 1.17 innodb drop_table 1.00 -400.00% -0.80 0.00 1.00 0.20 0.40 innodb drop_table_when_MANY_tables 39.00 -30.87% -9.20 15.00 39.00 29.80 8.52 innodb insert 121.00 +25.22% 40.80 112.00 343.00 161.80 90.67 innodb insert_autocommit 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb insert_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb insert_duplicates 19.00 +1.04% 0.20 19.00 20.00 19.20 0.40 innodb insert_key 770.00 -28.76% -172.00 172.00 959.00 598.00 306.47 innodb insert_many_fields 10.00 +7.41% 0.80 5.00 15.00 10.80 3.82 innodb insert_rollback 3.00 -36.36% -0.80 2.00 3.00 2.20 0.40 innodb insert_select_1_key 4.00 +4.76% 0.20 3.00 6.00 4.20 0.98 innodb insert_select_2_keys 13.00 -27.45% -2.80 6.00 13.00 10.20 2.71 innodb min_max 6.00 +21.05% 1.60 6.00 9.00 7.60 1.20 innodb min_max_on_key 25.00 -0.00% 0.00 25.00 25.00 25.00 0.00 innodb multiple_value_insert 14.00 +26.32% 5.00 3.00 50.00 19.00 17.27 innodb once_prepared_select 29.00 +3.33% 1.00 29.00 31.00 30.00 0.63 innodb order_by_big 16.00 -1.27% -0.20 15.00 16.00 15.80 0.40 innodb order_by_big_key 12.00 +9.09% 1.20 12.00 15.00 13.20 1.17 innodb order_by_big_key2 11.00 +12.70% 1.60 11.00 13.00 12.60 0.80 innodb order_by_big_key_desc 13.00 +2.99% 0.40 11.00 15.00 13.40 1.36 innodb order_by_big_key_diff 11.00 +12.70% 1.60 11.00 13.00 12.60 0.80 innodb order_by_big_key_prefix 12.00 +6.25% 0.80 11.00 14.00 12.80 1.17 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 24.00 -2.56% -0.60 23.00 24.00 23.40 0.49 innodb outer_join_found 23.00 -0.88% -0.20 22.00 24.00 22.80 0.75 innodb outer_join_not_found 21.00 -6.06% -1.20 19.00 21.00 19.80 0.75 innodb outer_join_on_key 16.00 -1.27% -0.20 15.00 16.00 15.80 0.40 innodb prepared_select 38.00 -0.00% 0.00 37.00 39.00 38.00 0.89 innodb select_1_row 3.00 +21.05% 0.80 3.00 4.00 3.80 0.40 innodb select_1_row_cache 4.00 -17.65% -0.60 3.00 4.00 3.40 0.49 innodb select_2_rows 4.00 -5.26% -0.20 3.00 4.00 3.80 0.40 innodb select_big 11.00 +9.84% 1.20 11.00 14.00 12.20 1.17 innodb select_big_str 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb select_cache 57.00 +5.94% 3.60 57.00 67.00 60.60 3.38 innodb select_cache2 61.00 -3.39% -2.00 55.00 61.00 59.00 2.28 innodb select_column+column 4.00 -0.00% 0.00 4.00 4.00 4.00 0.00 innodb select_diff_key 1.00 -150.00% -0.60 0.00 1.00 0.40 0.49 innodb select_distinct 4.00 +4.76% 0.20 4.00 5.00 4.20 0.40 innodb select_group 14.00 +18.60% 3.20 14.00 19.00 17.20 1.72 innodb select_group_when_MANY_tables 41.00 -32.26% -10.00 7.00 47.00 31.00 14.37 innodb select_join 1.00 -66.67% -0.40 0.00 1.00 0.60 0.49 innodb select_key 64.00 +0.62% 0.40 64.00 65.00 64.40 0.49 innodb select_key2 71.00 +1.11% 0.80 71.00 74.00 71.80 1.17 innodb select_key2_return_key 67.00 +1.76% 1.20 67.00 70.00 68.20 1.17 innodb select_key2_return_prim 69.00 +0.86% 0.60 69.00 71.00 69.60 0.80 innodb select_key_prefix 70.00 +2.23% 1.60 70.00 74.00 71.60 1.62 innodb select_key_prefix_join 5.00 -4.17% -0.20 4.00 5.00 4.80 0.40 innodb select_key_return_key 61.00 +2.87% 1.80 61.00 64.00 62.80 0.98 innodb select_many_fields 14.00 +2.78% 0.40 13.00 17.00 14.40 1.36 innodb select_range 52.00 -1.96% -1.00 49.00 52.00 51.00 1.10 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 +16.67% 0.40 2.00 3.00 2.40 0.49 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 -11.11% -0.40 3.00 4.00 3.60 0.49 innodb update_big 160.00 -29.87% -36.80 41.00 169.00 123.20 46.92 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.41 innodb update_of_key_big 46.00 -2.68% -1.20 31.00 51.00 44.80 7.33 innodb update_of_primary_key_many_keys 3058.00 -33.65% -770.00 705.00 3842.00 2288.00 1,292.90 innodb update_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_with_key 136.00 -8.45% -10.60 109.00 136.00 125.40 9.33 innodb update_with_key_prefix 49.00 -9.87% -4.40 40.00 49.00 44.60 3.01 innodb wisc_benchmark 3.00 -7.14% -0.20 2.00 3.00 2.80 0.40 ========================================================================================================================= TRENDING OVER LAST 20 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 36.00 -2.86% -1.00 14.00 51.00 35.00 9.13 innodb alter_table_drop 34.00 -18.47% -5.30 13.00 45.00 28.70 7.61 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 2.00 5.00 3.00 0.55 innodb connect+select_simple 3.00 -20.00% -0.50 2.00 3.00 2.50 0.50 innodb count 14.00 +10.54% 1.65 13.00 19.00 15.65 1.82 innodb count_distinct 7.00 -6.06% -0.40 5.00 8.00 6.60 0.86 innodb count_distinct_2 13.00 +0.38% 0.05 12.00 17.00 13.05 1.53 innodb count_distinct_big 20.00 +9.30% 2.05 19.00 25.00 22.05 2.06 innodb count_distinct_group 14.00 +0.71% 0.10 12.00 16.00 14.10 1.14 innodb count_distinct_group_on_key 9.00 +2.70% 0.25 8.00 11.00 9.25 0.99 innodb count_distinct_group_on_key_parts 12.00 +5.88% 0.75 11.00 15.00 12.75 1.18 innodb count_distinct_key_prefix 5.00 +4.76% 0.25 4.00 7.00 5.25 0.77 innodb count_group_on_key_parts 10.00 +4.76% 0.50 10.00 12.00 10.50 0.59 innodb count_on_key 89.00 +5.42% 5.10 88.00 100.00 94.10 3.08 innodb create+drop 70.00 -25.45% -14.20 26.00 81.00 55.80 14.51 innodb create_index 6.00 -42.86% -1.80 2.00 7.00 4.20 1.54 innodb create_key+drop 41.00 -9.63% -3.60 28.00 50.00 37.40 6.82 innodb create_MANY_tables 63.00 -15.49% -8.45 16.00 78.00 54.55 16.41 innodb create_table 0.00 +100.00% 0.05 0.00 1.00 0.05 0.22 innodb delete_all_many_keys 1391.00 -37.69% -380.75 295.00 1838.00 1010.25 517.28 innodb delete_autocommit 4.00 -14.29% -0.50 3.00 4.00 3.50 0.50 innodb delete_big 1.00 -566.67% -0.85 0.00 1.00 0.15 0.36 innodb delete_big_many_keys 1390.00 -37.77% -381.10 295.00 1835.00 1008.90 516.47 innodb delete_commit 1.00 +42.86% 0.75 1.00 2.00 1.75 0.43 innodb delete_key 3.00 +15.49% 0.55 3.00 5.00 3.55 0.74 innodb delete_range 19.00 -39.19% -5.35 6.00 21.00 13.65 4.28 innodb delete_rollback 3.00 -25.00% -0.60 2.00 4.00 2.40 0.58 innodb drop_index 4.00 +13.98% 0.65 2.00 9.00 4.65 1.62 innodb drop_table 1.00 -566.67% -0.85 0.00 1.00 0.15 0.36 innodb drop_table_when_MANY_tables 39.00 -32.43% -9.55 14.00 43.00 29.45 9.01 innodb insert 121.00 +11.55% 15.80 110.00 343.00 136.80 50.94 innodb insert_autocommit 3.00 +4.76% 0.15 3.00 4.00 3.15 0.36 innodb insert_commit 2.00 -2.56% -0.05 1.00 2.00 1.95 0.22 innodb insert_duplicates 19.00 +2.81% 0.55 18.00 21.00 19.55 0.80 innodb insert_key 770.00 -32.37% -188.30 172.00 959.00 581.70 248.62 innodb insert_many_fields 10.00 -2.56% -0.25 5.00 17.00 9.75 3.46 innodb insert_rollback 3.00 -39.53% -0.85 2.00 3.00 2.15 0.36 innodb insert_select_1_key 4.00 +16.67% 0.80 3.00 10.00 4.80 1.72 innodb insert_select_2_keys 13.00 -37.57% -3.55 6.00 14.00 9.45 2.42 innodb min_max 6.00 +23.08% 1.80 6.00 10.00 7.80 1.29 innodb min_max_on_key 25.00 -0.60% -0.15 24.00 26.00 24.85 0.48 innodb multiple_value_insert 14.00 +15.92% 2.65 3.00 50.00 16.65 13.22 innodb once_prepared_select 29.00 +4.29% 1.30 29.00 31.00 30.30 0.56 innodb order_by_big 16.00 -8.11% -1.20 12.00 16.00 14.80 1.25 innodb order_by_big_key 12.00 +9.09% 1.20 12.00 15.00 13.20 1.03 innodb order_by_big_key2 11.00 +10.93% 1.35 11.00 14.00 12.35 1.01 innodb order_by_big_key_desc 13.00 +4.76% 0.65 11.00 15.00 13.65 1.15 innodb order_by_big_key_diff 11.00 +10.20% 1.25 10.00 13.00 12.25 1.04 innodb order_by_big_key_prefix 12.00 +4.38% 0.55 11.00 14.00 12.55 1.07 innodb order_by_key2_diff 1.00 +25.93% 0.35 1.00 2.00 1.35 0.48 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 24.00 -8.11% -1.80 18.00 27.00 22.20 2.56 innodb outer_join_found 23.00 -6.24% -1.35 18.00 26.00 21.65 2.39 innodb outer_join_not_found 21.00 -12.60% -2.35 15.00 22.00 18.65 2.15 innodb outer_join_on_key 16.00 -10.73% -1.55 12.00 16.00 14.45 1.53 innodb prepared_select 38.00 +0.13% 0.05 37.00 40.00 38.05 0.92 innodb select_1_row 3.00 +20.00% 0.75 3.00 4.00 3.75 0.43 innodb select_1_row_cache 4.00 -15.94% -0.55 3.00 4.00 3.45 0.50 innodb select_2_rows 4.00 -6.67% -0.25 3.00 4.00 3.75 0.43 innodb select_big 11.00 +11.65% 1.45 11.00 14.00 12.45 1.16 innodb select_big_str 1.00 +16.67% 0.20 1.00 2.00 1.20 0.40 innodb select_cache 57.00 +9.09% 5.70 57.00 71.00 62.70 3.96 innodb select_cache2 61.00 +0.65% 0.40 55.00 72.00 61.40 4.45 innodb select_column+column 4.00 -2.56% -0.10 3.00 4.00 3.90 0.30 innodb select_diff_key 1.00 -185.71% -0.65 0.00 1.00 0.35 0.48 innodb select_distinct 4.00 +6.98% 0.30 4.00 5.00 4.30 0.46 innodb select_group 14.00 +15.41% 2.55 14.00 19.00 16.55 1.69 innodb select_group_when_MANY_tables 41.00 -64.66% -16.10 7.00 47.00 24.90 10.05 innodb select_join 1.00 -66.67% -0.40 0.00 1.00 0.60 0.49 innodb select_key 64.00 +0.93% 0.60 64.00 66.00 64.60 0.58 innodb select_key2 71.00 +1.39% 1.00 70.00 74.00 72.00 0.89 innodb select_key2_return_key 67.00 +2.05% 1.40 67.00 70.00 68.40 0.97 innodb select_key2_return_prim 69.00 +0.58% 0.40 68.00 72.00 69.40 1.02 innodb select_key_prefix 70.00 +2.30% 1.65 70.00 74.00 71.65 1.01 innodb select_key_prefix_join 5.00 -3.09% -0.15 4.00 5.00 4.85 0.36 innodb select_key_return_key 61.00 +3.71% 2.35 61.00 65.00 63.35 0.79 innodb select_many_fields 14.00 +2.10% 0.30 13.00 18.00 14.30 1.42 innodb select_range 52.00 -8.90% -4.25 43.00 52.00 47.75 3.22 innodb select_range_key2 10.00 -3.63% -0.35 9.00 10.00 9.65 0.48 innodb select_range_prefix 8.00 +11.11% 1.00 8.00 10.00 9.00 0.63 innodb select_simple 2.00 +6.98% 0.15 2.00 3.00 2.15 0.36 innodb select_simple_cache 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb select_simple_join 1.00 -66.67% -0.40 0.00 1.00 0.60 0.49 innodb update_autocommit 4.00 -3.90% -0.15 3.00 5.00 3.85 0.65 innodb update_big 160.00 -65.46% -63.30 41.00 169.00 96.70 39.60 innodb update_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_of_key 23.00 +1.29% 0.30 21.00 28.00 23.30 1.98 innodb update_of_key_big 46.00 -6.98% -3.00 31.00 51.00 43.00 5.28 innodb update_of_primary_key_many_keys 3058.00 -37.83% -839.30 686.00 3842.00 2218.70 1,066.92 innodb update_rollback 2.00 +14.89% 0.35 2.00 4.00 2.35 0.65 innodb update_with_key 136.00 -10.08% -12.45 109.00 136.00 123.55 7.83 innodb update_with_key_prefix 49.00 -10.61% -4.70 40.00 49.00 44.30 2.85 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 36.00 -107.58% -18.66 11.00 61.00 17.34 8.23 innodb alter_table_drop 34.00 -108.18% -17.67 10.00 57.00 16.33 6.30 innodb connect 2.00 +1.93% 0.04 1.00 3.00 2.04 0.41 innodb connect+select_1_row 3.00 -13.53% -0.36 2.00 5.00 2.64 0.50 innodb connect+select_simple 3.00 -31.65% -0.72 1.00 3.00 2.28 0.46 innodb count 14.00 +10.88% 1.71 12.00 193.00 15.71 10.02 innodb count_distinct 7.00 -7.88% -0.51 5.00 50.00 6.49 2.55 innodb count_distinct_2 13.00 +0.05% 0.01 11.00 63.00 13.01 3.27 innodb count_distinct_big 20.00 +7.86% 1.71 5.00 67.00 21.71 3.26 innodb count_distinct_group 14.00 -10.53% -1.33 10.00 68.00 12.67 3.28 innodb count_distinct_group_on_key 9.00 +3.73% 0.35 7.00 69.00 9.35 3.36 innodb count_distinct_group_on_key_parts 12.00 -0.53% -0.06 9.00 72.00 11.94 3.38 innodb count_distinct_key_prefix 5.00 +0.99% 0.05 3.00 52.00 5.05 2.70 innodb count_group_on_key_parts 10.00 -3.86% -0.37 7.00 72.00 9.63 3.51 innodb count_on_key 89.00 -6.49% -5.42 68.00 203.00 83.58 7.85 innodb create+drop 70.00 -125.34% -38.94 18.00 81.00 31.06 12.27 innodb create_index 6.00 -125.13% -3.33 1.00 8.00 2.67 1.06 innodb create_key+drop 41.00 -50.73% -13.80 21.00 50.00 27.20 4.67 innodb create_MANY_tables 63.00 -76.16% -27.24 14.00 121.00 35.76 17.64 innodb create_table 0.00 +100.00% 0.11 0.00 3.00 0.11 0.36 innodb delete_all_many_keys 1391.00 -252.72% -996.64 212.00 2293.00 394.36 371.46 innodb delete_autocommit 4.00 -19.87% -0.66 2.00 6.00 3.34 0.59 innodb delete_big 1.00 -351.37% -0.78 0.00 1.00 0.22 0.42 innodb delete_big_many_keys 1390.00 -252.57% -995.75 212.00 2293.00 394.25 371.32 innodb delete_commit 1.00 +28.45% 0.40 1.00 3.00 1.40 0.49 innodb delete_key 3.00 +2.47% 0.08 2.00 35.00 3.08 1.67 innodb delete_range 19.00 -145.91% -11.27 5.00 23.00 7.73 2.92 innodb delete_rollback 3.00 -94.97% -1.46 1.00 4.00 1.54 0.55 innodb drop_index 4.00 -45.61% -1.25 1.00 9.00 2.75 1.27 innodb drop_table 1.00 -2257.16% -0.96 0.00 2.00 0.04 0.22 innodb drop_table_when_MANY_tables 39.00 -105.38% -20.01 11.00 49.00 18.99 6.07 innodb insert 121.00 -16.17% -16.84 3.00 343.00 104.16 15.69 innodb insert_autocommit 3.00 -3.24% -0.09 2.00 99.00 2.91 3.77 innodb insert_commit 2.00 -57.66% -0.73 1.00 3.00 1.27 0.45 innodb insert_duplicates 19.00 -32.69% -4.68 11.00 21.00 14.32 1.88 innodb insert_key 770.00 -130.44% -435.86 142.00 959.00 334.14 163.68 innodb insert_many_fields 10.00 -85.03% -4.60 3.00 17.00 5.40 1.86 innodb insert_rollback 3.00 -93.63% -1.45 1.00 3.00 1.55 0.52 innodb insert_select_1_key 4.00 -7.30% -0.27 2.00 10.00 3.73 0.92 innodb insert_select_2_keys 13.00 -127.20% -7.28 4.00 16.00 5.72 1.96 innodb min_max 6.00 +23.15% 1.81 6.00 110.00 7.81 5.16 innodb min_max_on_key 25.00 -29.38% -5.68 14.00 37.00 19.32 2.45 innodb multiple_value_insert 14.00 -181.03% -9.02 2.00 50.00 4.98 4.60 innodb once_prepared_select 29.00 -28.07% -6.36 18.00 32.00 22.64 2.49 innodb order_by_big 16.00 -12.05% -1.72 12.00 31.00 14.28 1.61 innodb order_by_big_key 12.00 +8.09% 1.06 11.00 32.00 13.06 1.63 innodb order_by_big_key2 11.00 +8.55% 1.03 10.00 33.00 12.03 1.62 innodb order_by_big_key_desc 13.00 +0.75% 0.10 11.00 32.00 13.10 1.57 innodb order_by_big_key_diff 11.00 +8.74% 1.05 10.00 31.00 12.05 1.56 innodb order_by_big_key_prefix 12.00 +1.51% 0.18 10.00 32.00 12.18 1.64 innodb order_by_key2_diff 1.00 +28.40% 0.40 1.00 3.00 1.40 0.50 innodb order_by_key_prefix 1.00 -29.78% -0.23 0.00 2.00 0.77 0.43 innodb order_by_range 1.00 -26.05% -0.21 0.00 2.00 0.79 0.41 innodb outer_join 24.00 -29.45% -5.46 15.00 61.00 18.54 3.68 innodb outer_join_found 23.00 -27.53% -4.97 14.00 58.00 18.03 3.55 innodb outer_join_not_found 21.00 -33.60% -5.28 12.00 46.00 15.72 3.06 innodb outer_join_on_key 16.00 -29.56% -3.65 10.00 59.00 12.35 2.80 innodb prepared_select 38.00 -28.88% -8.52 22.00 40.00 29.48 3.49 innodb select_1_row 3.00 -14.78% -0.39 2.00 4.00 2.61 0.56 innodb select_1_row_cache 4.00 -63.87% -1.56 2.00 4.00 2.44 0.54 innodb select_2_rows 4.00 -52.34% -1.37 2.00 4.00 2.63 0.55 innodb select_big 11.00 +8.14% 0.97 0.00 31.00 11.97 1.61 innodb select_big_str 1.00 +9.99% 0.11 0.00 2.00 1.11 0.32 innodb select_cache 57.00 +5.38% 3.24 49.00 676.00 60.24 30.84 innodb select_cache2 61.00 -0.46% -0.28 49.00 677.00 60.72 32.54 innodb select_column+column 4.00 -50.09% -1.33 2.00 4.00 2.67 0.57 innodb select_diff_key 1.00 -391.05% -0.80 0.00 1.00 0.20 0.40 innodb select_distinct 4.00 +4.17% 0.17 3.00 8.00 4.17 0.54 innodb select_group 14.00 +12.75% 2.05 4.00 136.00 16.05 6.14 innodb select_group_when_MANY_tables 41.00 -490.70% -34.06 3.00 47.00 6.94 7.58 innodb select_join 1.00 -81.32% -0.45 0.00 1.00 0.55 0.50 innodb select_key 64.00 -29.77% -14.68 40.00 66.00 49.32 4.73 innodb select_key2 71.00 -27.07% -15.12 45.00 75.00 55.88 6.00 innodb select_key2_return_key 67.00 -25.87% -13.77 42.00 70.00 53.23 5.69 innodb select_key2_return_prim 69.00 -27.89% -15.05 42.00 72.00 53.95 5.86 innodb select_key_prefix 70.00 -27.24% -14.98 44.00 75.00 55.02 5.74 innodb select_key_prefix_join 5.00 -8.73% -0.40 3.00 10.00 4.60 0.67 innodb select_key_return_key 61.00 -26.10% -12.63 38.00 65.00 48.37 4.84 innodb select_many_fields 14.00 +9.35% 1.44 11.00 19.00 15.44 1.73 innodb select_range 52.00 -7.72% -3.73 42.00 76.00 48.27 3.47 innodb select_range_key2 10.00 -27.05% -2.13 6.00 10.00 7.87 0.84 innodb select_range_prefix 8.00 -8.00% -0.59 5.00 10.00 7.41 0.84 innodb select_simple 2.00 -31.34% -0.48 1.00 3.00 1.52 0.51 innodb select_simple_cache 2.00 -42.09% -0.59 1.00 3.00 1.41 0.49 innodb select_simple_join 1.00 -61.37% -0.38 0.00 3.00 0.62 0.49 innodb update_autocommit 4.00 -27.10% -0.85 2.00 5.00 3.15 0.48 innodb update_big 160.00 -268.02% -116.52 31.00 169.00 43.48 15.91 innodb update_commit 2.00 -42.03% -0.59 1.00 3.00 1.41 0.49 innodb update_of_key 23.00 +7.32% 1.82 18.00 100.00 24.82 6.93 innodb update_of_key_big 46.00 -90.87% -21.90 15.00 75.00 24.10 9.82 innodb update_of_primary_key_many_keys 3058.00 -170.49% -1927.48 660.00 6065.00 1130.52 1,056.87 innodb update_rollback 2.00 -34.08% -0.51 1.00 4.00 1.49 0.55 innodb update_with_key 136.00 -28.39% -30.07 90.00 598.00 105.93 22.19 innodb update_with_key_prefix 49.00 -28.06% -10.74 33.00 202.00 38.26 7.15 innodb wisc_benchmark 3.00 -23.41% -0.57 2.00 4.00 2.43 0.51 ========================================================================================================================= _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
