======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 784 RUN DATE: 2011-01-03T20:46:20.079728 SERVER: drizzled VERSION: staging REVISION: 2052 COMMENT: 2052: Brian Aker 2011-01-03 Fix additional member of trans services to handle identifier.
========================================================================================================================= TRENDING OVER LAST 5 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 33.00 +2.37% 0.80 25.00 43.00 33.80 5.71 innodb alter_table_drop 25.00 -5.93% -1.40 16.00 31.00 23.60 4.84 innodb connect 3.00 -25.00% -0.60 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 2.00 +23.08% 0.60 2.00 3.00 2.60 0.49 innodb count 18.00 -13.92% -2.20 13.00 18.00 15.80 2.32 innodb count_distinct 6.00 +9.09% 0.60 6.00 7.00 6.60 0.49 innodb count_distinct_2 13.00 -1.56% -0.20 11.00 15.00 12.80 1.33 innodb count_distinct_big 24.00 -5.26% -1.20 21.00 24.00 22.80 1.47 innodb count_distinct_group 16.00 -9.59% -1.40 13.00 16.00 14.60 1.02 innodb count_distinct_group_on_key 9.00 +13.46% 1.40 9.00 11.00 10.40 0.80 innodb count_distinct_group_on_key_parts 12.00 +14.29% 2.00 12.00 15.00 14.00 1.10 innodb count_distinct_key_prefix 5.00 -0.00% 0.00 4.00 6.00 5.00 0.63 innodb count_group_on_key_parts 11.00 +1.79% 0.20 10.00 12.00 11.20 0.75 innodb count_on_key 95.00 +1.86% 1.80 92.00 106.00 96.80 4.87 innodb create+drop 32.00 +25.23% 10.80 32.00 65.00 42.80 11.91 innodb create_index 4.00 +4.76% 0.20 2.00 8.00 4.20 2.04 innodb create_key+drop 30.00 +3.85% 1.20 29.00 36.00 31.20 2.48 innodb create_MANY_tables 22.00 +32.93% 10.80 21.00 49.00 32.80 10.55 innodb delete_all_many_keys 614.00 +1.85% 11.60 319.00 1198.00 625.60 314.01 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 613.00 +1.92% 12.00 319.00 1197.00 625.00 313.64 innodb delete_commit 2.00 -11.11% -0.20 1.00 2.00 1.80 0.40 innodb delete_key 3.00 -0.00% 0.00 2.00 4.00 3.00 0.63 innodb delete_range 8.00 +28.57% 3.20 8.00 16.00 11.20 3.25 innodb delete_rollback 3.00 -36.36% -0.80 2.00 3.00 2.20 0.40 innodb drop_index 3.00 +16.67% 0.60 2.00 5.00 3.60 1.20 innodb drop_table_when_MANY_tables 18.00 +7.22% 1.40 17.00 24.00 19.40 2.42 innodb insert 114.00 +0.52% 0.60 110.00 122.00 114.60 4.27 innodb insert_autocommit 3.00 -0.00% 0.00 3.00 3.00 3.00 0.00 innodb insert_commit 2.00 -11.11% -0.20 1.00 2.00 1.80 0.40 innodb insert_duplicates 19.00 +2.06% 0.40 19.00 20.00 19.40 0.49 innodb insert_key 274.00 +21.44% 74.80 271.00 639.00 348.80 145.14 innodb insert_many_fields 6.00 +11.76% 0.80 6.00 8.00 6.80 0.75 innodb insert_rollback 2.00 +9.09% 0.20 2.00 3.00 2.20 0.40 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 +16.67% 1.20 6.00 9.00 7.20 1.17 innodb min_max 9.00 -12.50% -1.00 7.00 9.00 8.00 0.89 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 3.00 11.00 6.40 2.80 innodb once_prepared_select 29.00 +0.68% 0.20 29.00 30.00 29.20 0.40 innodb order_by_big 13.00 +10.96% 1.60 13.00 16.00 14.60 1.02 innodb order_by_big_key 14.00 +1.41% 0.20 12.00 15.00 14.20 1.17 innodb order_by_big_key2 14.00 -7.69% -1.00 11.00 14.00 13.00 1.10 innodb order_by_big_key_desc 16.00 -5.26% -0.80 13.00 17.00 15.20 1.33 innodb order_by_big_key_diff 12.00 +4.76% 0.60 11.00 14.00 12.60 1.02 innodb order_by_big_key_prefix 14.00 -4.48% -0.60 12.00 14.00 13.40 0.80 innodb order_by_key2_diff 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 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 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb outer_join 18.00 +11.76% 2.40 18.00 22.00 20.40 1.96 innodb outer_join_found 19.00 +5.00% 1.00 17.00 22.00 20.00 1.79 innodb outer_join_not_found 15.00 +13.79% 2.40 15.00 20.00 17.40 2.06 innodb outer_join_on_key 12.00 +10.45% 1.40 12.00 15.00 13.40 1.20 innodb prepared_select 37.00 -0.00% 0.00 36.00 38.00 37.00 0.63 innodb select_1_row 4.00 -17.65% -0.60 3.00 4.00 3.40 0.49 innodb select_1_row_cache 3.00 +16.67% 0.60 3.00 4.00 3.60 0.49 innodb select_2_rows 4.00 -17.65% -0.60 3.00 4.00 3.40 0.49 innodb select_big 12.00 +4.76% 0.60 11.00 14.00 12.60 1.02 innodb select_big_str 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb select_cache 64.00 -0.31% -0.20 58.00 70.00 63.80 3.92 innodb select_cache2 66.00 -2.17% -1.40 60.00 67.00 64.60 2.50 innodb select_column+column 4.00 -0.00% 0.00 4.00 4.00 4.00 0.00 innodb select_diff_key 1.00 -400.00% -0.80 0.00 1.00 0.20 0.40 innodb select_distinct 5.00 -8.70% -0.40 4.00 5.00 4.60 0.49 innodb select_group 18.00 -4.65% -0.80 15.00 18.00 17.20 1.17 innodb select_group_when_MANY_tables 11.00 +48.60% 10.40 11.00 39.00 21.40 10.13 innodb select_join 0.00 +100.00% 0.40 0.00 1.00 0.40 0.49 innodb select_key 64.00 -0.63% -0.40 62.00 65.00 63.60 1.02 innodb select_key2 71.00 -0.57% -0.40 69.00 72.00 70.60 1.02 innodb select_key2_return_key 68.00 -0.29% -0.20 67.00 69.00 67.80 0.75 innodb select_key2_return_prim 68.00 +0.58% 0.40 67.00 70.00 68.40 1.02 innodb select_key_prefix 70.00 +0.28% 0.20 69.00 72.00 70.20 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 63.00 -1.29% -0.80 61.00 64.00 62.20 1.17 innodb select_many_fields 13.00 -3.17% -0.40 12.00 13.00 12.60 0.49 innodb select_range 41.00 +3.76% 1.60 39.00 46.00 42.60 2.58 innodb select_range_key2 9.00 +4.26% 0.40 9.00 10.00 9.40 0.49 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 -25.00% -0.20 0.00 1.00 0.80 0.40 innodb update_autocommit 4.00 -5.26% -0.20 3.00 4.00 3.80 0.40 innodb update_big 56.00 +28.75% 22.60 56.00 120.00 78.60 23.23 innodb update_commit 1.00 +44.44% 0.80 1.00 2.00 1.80 0.40 innodb update_of_key 22.00 -0.00% 0.00 21.00 23.00 22.00 0.63 innodb update_of_key_big 38.00 -0.53% -0.20 31.00 42.00 37.80 3.87 innodb update_of_primary_key_many_keys 1303.00 +5.11% 70.20 798.00 2604.00 1373.20 650.77 innodb update_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_with_key 125.00 -1.96% -2.40 116.00 127.00 122.60 4.03 innodb update_with_key_prefix 48.00 -8.11% -3.60 42.00 48.00 44.40 2.24 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 33.00 +8.84% 3.20 18.00 50.00 36.20 6.98 innodb alter_table_drop 25.00 +15.82% 4.70 15.00 45.00 29.70 6.91 innodb connect 3.00 -33.33% -0.75 2.00 3.00 2.25 0.43 innodb connect+select_1_row 3.00 -1.69% -0.05 2.00 3.00 2.95 0.22 innodb connect+select_simple 2.00 +24.53% 0.65 2.00 3.00 2.65 0.48 innodb count 18.00 -13.92% -2.20 13.00 18.00 15.80 2.04 innodb count_distinct 6.00 +13.04% 0.90 6.00 8.00 6.90 0.83 innodb count_distinct_2 13.00 +0.38% 0.05 11.00 15.00 13.05 1.20 innodb count_distinct_big 24.00 -7.62% -1.70 19.00 25.00 22.30 1.82 innodb count_distinct_group 16.00 -9.59% -1.40 13.00 16.00 14.60 0.80 innodb count_distinct_group_on_key 9.00 +11.76% 1.20 8.00 12.00 10.20 1.21 innodb count_distinct_group_on_key_parts 12.00 +13.04% 1.80 12.00 15.00 13.80 1.03 innodb count_distinct_key_prefix 5.00 +4.76% 0.25 4.00 6.00 5.25 0.77 innodb count_group_on_key_parts 11.00 +0.90% 0.10 10.00 12.00 11.10 0.70 innodb count_on_key 95.00 -1.01% -0.95 90.00 106.00 94.05 3.20 innodb create+drop 32.00 +41.39% 22.60 32.00 71.00 54.60 12.80 innodb create_index 4.00 +20.00% 1.00 2.00 8.00 5.00 1.34 innodb create_key+drop 30.00 +15.61% 5.55 28.00 43.00 35.55 5.09 innodb create_MANY_tables 22.00 +53.49% 25.30 21.00 64.00 47.30 13.35 innodb create_table 0.00 +100.00% 0.05 0.00 1.00 0.05 0.22 innodb delete_all_many_keys 614.00 +38.81% 389.45 318.00 1884.00 1003.45 501.04 innodb delete_autocommit 3.00 +32.58% 1.45 3.00 14.00 4.45 2.56 innodb delete_big 0.00 +100.00% 0.85 0.00 3.00 0.85 0.73 innodb delete_big_many_keys 613.00 +38.83% 389.10 318.00 1881.00 1002.10 500.27 innodb delete_commit 2.00 -2.56% -0.05 1.00 3.00 1.95 0.38 innodb delete_key 3.00 +15.49% 0.55 2.00 5.00 3.55 0.97 innodb delete_range 8.00 +46.49% 6.95 8.00 22.00 14.95 4.22 innodb delete_rollback 3.00 -27.66% -0.65 2.00 3.00 2.35 0.48 innodb drop_index 3.00 +42.31% 2.20 2.00 9.00 5.20 1.86 innodb drop_table 0.00 +100.00% 0.25 0.00 2.00 0.25 0.62 innodb drop_table_when_MANY_tables 18.00 +38.25% 11.15 17.00 42.00 29.15 9.05 innodb insert 114.00 +3.43% 4.05 110.00 129.00 118.05 5.34 innodb insert_autocommit 3.00 +7.69% 0.25 3.00 4.00 3.25 0.43 innodb insert_commit 2.00 -21.21% -0.35 1.00 2.00 1.65 0.48 innodb insert_duplicates 19.00 +2.06% 0.40 18.00 21.00 19.40 0.73 innodb insert_key 274.00 +50.27% 277.00 227.00 876.00 551.00 231.75 innodb insert_many_fields 6.00 +21.05% 1.60 6.00 10.00 7.60 1.16 innodb insert_rollback 2.00 +13.04% 0.30 2.00 3.00 2.30 0.46 innodb insert_select_1_key 4.00 +5.88% 0.25 3.00 6.00 4.25 0.94 innodb insert_select_2_keys 6.00 +38.78% 3.80 6.00 13.00 9.80 2.42 innodb min_max 9.00 -14.65% -1.15 6.00 9.00 7.85 1.15 innodb min_max_on_key 24.00 +1.23% 0.30 23.00 25.00 24.30 0.56 innodb multiple_value_insert 7.00 +25.53% 2.40 3.00 16.00 9.40 4.00 innodb once_prepared_select 29.00 +1.02% 0.30 28.00 30.00 29.30 0.56 innodb order_by_big 13.00 +8.45% 1.20 12.00 16.00 14.20 1.40 innodb order_by_big_key 14.00 -4.87% -0.65 11.00 15.00 13.35 1.28 innodb order_by_big_key2 14.00 -14.75% -1.80 10.00 14.00 12.20 1.25 innodb order_by_big_key_desc 16.00 -13.07% -1.85 12.00 17.00 14.15 1.31 innodb order_by_big_key_diff 12.00 +0.83% 0.10 10.00 14.00 12.10 1.14 innodb order_by_big_key_prefix 14.00 -9.80% -1.25 11.00 14.00 12.75 1.04 innodb order_by_key2_diff 1.00 +23.08% 0.30 1.00 2.00 1.30 0.46 innodb order_by_key_prefix 1.00 -5.26% -0.05 0.00 1.00 0.95 0.22 innodb order_by_range 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb outer_join 18.00 +16.08% 3.45 17.00 25.00 21.45 2.46 innodb outer_join_found 19.00 +8.65% 1.80 17.00 27.00 20.80 2.56 innodb outer_join_not_found 15.00 +18.26% 3.35 15.00 22.00 18.35 2.24 innodb outer_join_on_key 12.00 +15.79% 2.25 12.00 17.00 14.25 1.58 innodb prepared_select 37.00 +0.40% 0.15 36.00 38.00 37.15 0.57 innodb select_1_row 4.00 -9.59% -0.35 3.00 4.00 3.65 0.48 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 -5.26% -0.20 3.00 4.00 3.80 0.40 innodb select_big 12.00 +2.83% 0.35 11.00 14.00 12.35 1.11 innodb select_big_str 1.00 +13.04% 0.15 1.00 2.00 1.15 0.36 innodb select_cache 64.00 -1.35% -0.85 57.00 71.00 63.15 3.86 innodb select_cache2 66.00 -2.09% -1.35 58.00 71.00 64.65 3.82 innodb select_column+column 4.00 -3.90% -0.15 3.00 4.00 3.85 0.36 innodb select_diff_key 1.00 -400.00% -0.80 0.00 1.00 0.20 0.40 innodb select_distinct 5.00 -11.11% -0.50 4.00 5.00 4.50 0.50 innodb select_group 18.00 -7.78% -1.30 15.00 19.00 16.70 1.42 innodb select_group_when_MANY_tables 11.00 +65.35% 20.75 11.00 46.00 31.75 10.61 innodb select_join 0.00 +100.00% 0.60 0.00 1.00 0.60 0.49 innodb select_key 64.00 -0.39% -0.25 62.00 65.00 63.75 0.89 innodb select_key2 71.00 -0.28% -0.20 69.00 72.00 70.80 1.08 innodb select_key2_return_key 68.00 -0.37% -0.25 66.00 69.00 67.75 0.77 innodb select_key2_return_prim 68.00 +1.02% 0.70 67.00 70.00 68.70 1.00 innodb select_key_prefix 70.00 +0.43% 0.30 69.00 72.00 70.30 1.00 innodb select_key_prefix_join 5.00 +2.91% 0.15 5.00 6.00 5.15 0.36 innodb select_key_return_key 63.00 -0.88% -0.55 61.00 64.00 62.45 0.80 innodb select_many_fields 13.00 -1.17% -0.15 11.00 14.00 12.85 0.65 innodb select_range 41.00 +3.87% 1.65 39.00 46.00 42.65 2.15 innodb select_range_key2 9.00 +6.25% 0.60 9.00 10.00 9.60 0.49 innodb select_range_prefix 9.00 +2.17% 0.20 8.00 10.00 9.20 0.60 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 4.00 +1.23% 0.05 3.00 7.00 4.05 0.80 innodb update_big 56.00 +52.50% 61.90 56.00 195.00 117.90 37.85 innodb update_commit 1.00 +47.37% 0.90 1.00 2.00 1.90 0.30 innodb update_of_key 22.00 +1.12% 0.25 21.00 24.00 22.25 0.70 innodb update_of_key_big 38.00 +14.22% 6.30 26.00 56.00 44.30 7.52 innodb update_of_primary_key_many_keys 1303.00 +39.75% 859.65 770.00 3761.00 2162.65 1,013.74 innodb update_rollback 2.00 +9.09% 0.20 2.00 4.00 2.20 0.51 innodb update_with_key 125.00 +1.46% 1.85 116.00 141.00 126.85 7.50 innodb update_with_key_prefix 48.00 -7.62% -3.40 40.00 49.00 44.60 2.52 innodb wisc_benchmark 3.00 -9.09% -0.25 2.00 4.00 2.75 0.62 ========================================================================================================================= TRENDING OVER ALL runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 33.00 -75.97% -14.25 11.00 61.00 18.75 9.49 innodb alter_table_drop 25.00 -44.87% -7.74 10.00 57.00 17.26 7.08 innodb connect 3.00 -46.23% -0.95 1.00 3.00 2.05 0.41 innodb connect+select_1_row 3.00 -12.77% -0.34 2.00 5.00 2.66 0.49 innodb connect+select_simple 2.00 +12.97% 0.30 1.00 3.00 2.30 0.47 innodb count 18.00 -14.48% -2.28 12.00 193.00 15.72 9.62 innodb count_distinct 6.00 +7.82% 0.51 5.00 50.00 6.51 2.46 innodb count_distinct_2 13.00 +0.28% 0.04 11.00 63.00 13.04 3.16 innodb count_distinct_big 24.00 -10.28% -2.24 5.00 67.00 21.76 3.18 innodb count_distinct_group 16.00 -24.82% -3.18 10.00 68.00 12.82 3.20 innodb count_distinct_group_on_key 9.00 +4.14% 0.39 7.00 69.00 9.39 3.24 innodb count_distinct_group_on_key_parts 12.00 +0.49% 0.06 9.00 72.00 12.06 3.28 innodb count_distinct_key_prefix 5.00 +1.32% 0.07 3.00 52.00 5.07 2.59 innodb count_group_on_key_parts 11.00 -12.88% -1.26 7.00 72.00 9.74 3.39 innodb count_on_key 95.00 -12.56% -10.60 68.00 203.00 84.40 8.06 innodb create+drop 32.00 +2.29% 0.75 18.00 81.00 32.75 13.51 innodb create_index 4.00 -41.62% -1.18 1.00 8.00 2.82 1.22 innodb create_key+drop 30.00 -8.01% -2.23 21.00 50.00 27.77 5.06 innodb create_MANY_tables 22.00 +39.79% 14.54 14.00 121.00 36.54 17.46 innodb create_table 0.00 +100.00% 0.11 0.00 3.00 0.11 0.38 innodb delete_all_many_keys 614.00 -41.21% -179.18 212.00 2293.00 434.82 406.98 innodb delete_autocommit 3.00 +11.70% 0.40 2.00 14.00 3.40 0.78 innodb delete_big 0.00 +100.00% 0.26 0.00 3.00 0.26 0.45 innodb delete_big_many_keys 613.00 -41.04% -178.39 212.00 2293.00 434.61 406.70 innodb delete_commit 2.00 -37.88% -0.55 1.00 5.00 1.45 0.53 innodb delete_key 3.00 +3.37% 0.10 2.00 35.00 3.10 1.62 innodb delete_range 8.00 +3.08% 0.25 5.00 23.00 8.25 3.53 innodb delete_rollback 3.00 -86.40% -1.39 1.00 4.00 1.61 0.60 innodb drop_index 3.00 -2.72% -0.08 1.00 9.00 2.92 1.43 innodb drop_table 0.00 +100.00% 0.05 0.00 2.00 0.05 0.24 innodb drop_table_when_MANY_tables 18.00 +8.68% 1.71 11.00 49.00 19.71 6.74 innodb insert 114.00 -8.37% -8.81 3.00 343.00 105.19 15.52 innodb insert_autocommit 3.00 -1.99% -0.06 2.00 99.00 2.94 3.62 innodb insert_commit 2.00 -54.19% -0.70 1.00 3.00 1.30 0.47 innodb insert_duplicates 19.00 -29.07% -4.28 11.00 21.00 14.72 2.26 innodb insert_key 274.00 +21.21% 73.77 142.00 959.00 347.77 175.17 innodb insert_many_fields 6.00 -7.65% -0.43 3.00 17.00 5.57 1.92 innodb insert_rollback 2.00 -24.91% -0.40 1.00 3.00 1.60 0.55 innodb insert_select_1_key 4.00 -6.63% -0.25 2.00 10.00 3.75 0.92 innodb insert_select_2_keys 6.00 +0.37% 0.02 4.00 16.00 6.02 2.25 innodb min_max 9.00 -15.22% -1.19 6.00 110.00 7.81 4.95 innodb min_max_on_key 24.00 -21.61% -4.26 14.00 37.00 19.74 2.73 innodb multiple_value_insert 7.00 -33.33% -1.75 2.00 50.00 5.25 4.66 innodb once_prepared_select 29.00 -25.03% -5.81 18.00 32.00 23.19 3.02 innodb order_by_big 13.00 +8.86% 1.26 12.00 31.00 14.26 1.59 innodb order_by_big_key 14.00 -7.30% -0.95 11.00 32.00 13.05 1.60 innodb order_by_big_key2 14.00 -16.46% -1.98 10.00 33.00 12.02 1.59 innodb order_by_big_key_desc 16.00 -21.70% -2.85 11.00 32.00 13.15 1.56 innodb order_by_big_key_diff 12.00 +0.31% 0.04 10.00 31.00 12.04 1.53 innodb order_by_big_key_prefix 14.00 -14.76% -1.80 10.00 32.00 12.20 1.61 innodb order_by_key2_diff 1.00 +28.76% 0.40 1.00 3.00 1.40 0.50 innodb order_by_key_prefix 1.00 -28.55% -0.22 0.00 2.00 0.78 0.42 innodb order_by_range 1.00 -24.09% -0.19 0.00 2.00 0.81 0.40 innodb outer_join 18.00 +4.30% 0.81 15.00 61.00 18.81 3.70 innodb outer_join_found 19.00 -3.89% -0.71 14.00 58.00 18.29 3.57 innodb outer_join_not_found 15.00 +6.04% 0.96 12.00 46.00 15.96 3.10 innodb outer_join_on_key 12.00 +4.28% 0.54 10.00 59.00 12.54 2.79 innodb prepared_select 37.00 -22.82% -6.87 22.00 40.00 30.13 3.99 innodb select_1_row 4.00 -48.04% -1.30 2.00 4.00 2.70 0.63 innodb select_1_row_cache 3.00 -18.74% -0.47 2.00 4.00 2.53 0.61 innodb select_2_rows 4.00 -47.28% -1.28 2.00 4.00 2.72 0.62 innodb select_big 12.00 -0.12% -0.01 0.00 31.00 11.99 1.57 innodb select_big_str 1.00 +10.98% 0.12 0.00 2.00 1.12 0.33 innodb select_cache 64.00 -5.97% -3.61 49.00 676.00 60.39 29.59 innodb select_cache2 66.00 -8.32% -5.07 49.00 677.00 60.93 31.23 innodb select_column+column 4.00 -45.05% -1.24 2.00 4.00 2.76 0.64 innodb select_diff_key 1.00 -404.23% -0.80 0.00 1.00 0.20 0.40 innodb select_distinct 5.00 -19.47% -0.81 3.00 8.00 4.19 0.54 innodb select_group 18.00 -11.82% -1.90 4.00 136.00 16.10 5.90 innodb select_group_when_MANY_tables 11.00 -25.46% -2.23 3.00 47.00 8.77 9.93 innodb select_join 0.00 +100.00% 0.56 0.00 1.00 0.56 0.50 innodb select_key 64.00 -26.68% -13.48 40.00 66.00 50.52 6.09 innodb select_key2 71.00 -24.30% -13.88 45.00 75.00 57.12 7.12 innodb select_key2_return_key 68.00 -24.94% -13.57 42.00 70.00 54.43 6.79 innodb select_key2_return_prim 68.00 -23.24% -12.82 42.00 72.00 55.18 6.97 innodb select_key_prefix 70.00 -24.35% -13.71 44.00 75.00 56.29 6.99 innodb select_key_prefix_join 5.00 -7.97% -0.37 3.00 10.00 4.63 0.66 innodb select_key_return_key 63.00 -27.15% -13.45 38.00 65.00 49.55 6.10 innodb select_many_fields 13.00 +15.01% 2.30 11.00 19.00 15.30 1.76 innodb select_range 41.00 +14.47% 6.94 39.00 76.00 47.94 3.65 innodb select_range_key2 9.00 -12.40% -0.99 6.00 10.00 8.01 0.94 innodb select_range_prefix 9.00 -19.09% -1.44 5.00 10.00 7.56 0.97 innodb select_simple 2.00 -27.30% -0.43 1.00 3.00 1.57 0.52 innodb select_simple_cache 2.00 -36.76% -0.54 1.00 3.00 1.46 0.52 innodb select_simple_join 1.00 -57.46% -0.36 0.00 3.00 0.64 0.49 innodb update_autocommit 4.00 -25.29% -0.81 2.00 7.00 3.19 0.53 innodb update_big 56.00 -14.10% -6.92 31.00 195.00 49.08 26.16 innodb update_commit 1.00 +30.92% 0.45 1.00 3.00 1.45 0.50 innodb update_of_key 22.00 +10.52% 2.59 18.00 100.00 24.59 6.70 innodb update_of_key_big 38.00 -48.03% -12.33 15.00 75.00 25.67 11.01 innodb update_of_primary_key_many_keys 1303.00 -7.16% -87.03 647.00 6065.00 1215.97 1,080.72 innodb update_rollback 2.00 -29.07% -0.45 1.00 4.00 1.55 0.58 innodb update_with_key 125.00 -16.36% -17.58 90.00 598.00 107.42 21.98 innodb update_with_key_prefix 48.00 -23.98% -9.28 33.00 202.00 38.72 7.07 innodb wisc_benchmark 3.00 -22.22% -0.55 2.00 5.00 2.45 0.53 ========================================================================================================================= _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
