======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 781 RUN DATE: 2011-01-02T00:00:54.848805 SERVER: drizzled VERSION: staging REVISION: 2047 COMMENT: 2047: Brian Aker 2011-01-01 [merge] MErge in Andrew's patch for a mysql bug
========================================================================================================================= TRENDING OVER LAST 5 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 34.00 +11.92% 4.60 34.00 43.00 38.60 2.87 innodb alter_table_drop 22.00 +30.82% 9.80 22.00 36.00 31.80 5.19 innodb connect 2.00 +16.67% 0.40 2.00 3.00 2.40 0.49 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 13.00 +10.96% 1.60 13.00 17.00 14.60 1.96 innodb count_distinct 7.00 +5.41% 0.40 7.00 8.00 7.40 0.49 innodb count_distinct_2 15.00 -15.38% -2.00 11.00 15.00 13.00 1.67 innodb count_distinct_big 21.00 +4.55% 1.00 21.00 24.00 22.00 1.26 innodb count_distinct_group 13.00 +7.14% 1.00 13.00 15.00 14.00 0.63 innodb count_distinct_group_on_key 11.00 -5.77% -0.60 9.00 12.00 10.40 1.20 innodb count_distinct_group_on_key_parts 14.00 -2.94% -0.40 12.00 14.00 13.60 0.80 innodb count_distinct_key_prefix 4.00 +28.57% 1.60 4.00 6.00 5.60 0.80 innodb count_group_on_key_parts 11.00 -1.85% -0.20 10.00 12.00 10.80 0.75 innodb count_on_key 92.00 +0.65% 0.60 92.00 94.00 92.60 0.80 innodb create+drop 41.00 +31.89% 19.20 41.00 69.00 60.20 10.03 innodb create_index 4.00 +28.57% 1.60 4.00 8.00 5.60 1.62 innodb create_key+drop 30.00 +20.63% 7.80 30.00 42.00 37.80 4.40 innodb create_MANY_tables 33.00 +37.02% 19.40 33.00 64.00 52.40 10.98 innodb delete_all_many_keys 359.00 +69.46% 816.60 359.00 1473.00 1175.60 419.44 innodb delete_autocommit 4.00 -17.65% -0.60 3.00 4.00 3.40 0.49 innodb delete_big 0.00 +100.00% 0.60 0.00 1.00 0.60 0.49 innodb delete_big_many_keys 359.00 +69.43% 815.20 359.00 1471.00 1174.20 418.67 innodb delete_commit 1.00 +44.44% 0.80 1.00 2.00 1.80 0.40 innodb delete_key 3.00 +16.67% 0.60 3.00 5.00 3.60 0.80 innodb delete_range 14.00 +19.54% 3.40 14.00 21.00 17.40 2.42 innodb delete_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb drop_index 5.00 +19.35% 1.20 5.00 8.00 6.20 1.17 innodb drop_table 0.00 +100.00% 0.60 0.00 2.00 0.60 0.80 innodb drop_table_when_MANY_tables 19.00 +42.77% 14.20 19.00 42.00 33.20 9.70 innodb insert 110.00 +6.94% 8.20 110.00 123.00 118.20 4.96 innodb insert_autocommit 3.00 +6.25% 0.20 3.00 4.00 3.20 0.40 innodb insert_commit 1.00 +37.50% 0.60 1.00 2.00 1.60 0.49 innodb insert_duplicates 19.00 +1.04% 0.20 18.00 20.00 19.20 0.75 innodb insert_key 271.00 +58.63% 384.00 271.00 791.00 655.00 200.54 innodb insert_many_fields 7.00 +14.63% 1.20 7.00 10.00 8.20 1.17 innodb insert_rollback 2.00 +16.67% 0.40 2.00 3.00 2.40 0.49 innodb insert_select_1_key 3.00 +31.82% 1.40 3.00 5.00 4.40 0.80 innodb insert_select_2_keys 9.00 +13.46% 1.40 7.00 13.00 10.40 2.33 innodb min_max 7.00 +2.78% 0.20 6.00 9.00 7.20 0.98 innodb min_max_on_key 24.00 +0.83% 0.20 24.00 25.00 24.20 0.40 innodb multiple_value_insert 4.00 +61.54% 6.40 4.00 13.00 10.40 3.26 innodb once_prepared_select 29.00 -0.00% 0.00 29.00 29.00 29.00 0.00 innodb order_by_big 14.00 -0.00% 0.00 13.00 15.00 14.00 0.89 innodb order_by_big_key 12.00 +9.09% 1.20 12.00 15.00 13.20 1.47 innodb order_by_big_key2 11.00 +6.78% 0.80 11.00 13.00 11.80 0.98 innodb order_by_big_key_desc 13.00 +4.41% 0.60 13.00 15.00 13.60 0.80 innodb order_by_big_key_diff 11.00 +9.84% 1.20 11.00 14.00 12.20 1.17 innodb order_by_big_key_prefix 12.00 +4.76% 0.60 12.00 14.00 12.60 0.80 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 -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 +14.29% 3.00 18.00 25.00 21.00 2.68 innodb outer_join_found 17.00 +19.81% 4.20 17.00 27.00 21.20 3.54 innodb outer_join_not_found 15.00 +17.58% 3.20 15.00 22.00 18.20 2.56 innodb outer_join_on_key 12.00 +14.29% 2.00 12.00 16.00 14.00 1.41 innodb prepared_select 36.00 +2.70% 1.00 36.00 38.00 37.00 0.63 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 11.00 +8.33% 1.00 11.00 13.00 12.00 0.89 innodb select_big_str 1.00 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb select_cache 58.00 +7.94% 5.00 58.00 67.00 63.00 3.52 innodb select_cache2 64.00 +0.93% 0.60 60.00 71.00 64.60 4.03 innodb select_column+column 4.00 -0.00% 0.00 4.00 4.00 4.00 0.00 innodb select_distinct 5.00 -8.70% -0.40 4.00 5.00 4.60 0.49 innodb select_group 15.00 +14.77% 2.60 15.00 19.00 17.60 1.36 innodb select_group_when_MANY_tables 21.00 +42.31% 15.40 21.00 42.00 36.40 7.86 innodb select_join 0.00 +100.00% 0.40 0.00 1.00 0.40 0.49 innodb select_key 62.00 +1.59% 1.00 62.00 64.00 63.00 0.89 innodb select_key2 69.00 +2.27% 1.60 69.00 72.00 70.60 1.02 innodb select_key2_return_key 67.00 +0.59% 0.40 67.00 69.00 67.40 0.80 innodb select_key2_return_prim 67.00 +1.76% 1.20 67.00 69.00 68.20 0.98 innodb select_key_prefix 69.00 +1.43% 1.00 69.00 72.00 70.00 1.10 innodb select_key_prefix_join 5.00 +10.71% 0.60 5.00 6.00 5.60 0.49 innodb select_key_return_key 61.00 +1.29% 0.80 61.00 63.00 61.80 0.75 innodb select_many_fields 12.00 +6.25% 0.80 12.00 14.00 12.80 0.75 innodb select_range 45.00 -2.74% -1.20 41.00 46.00 43.80 1.94 innodb select_range_key2 10.00 -0.00% 0.00 10.00 10.00 10.00 0.00 innodb select_range_prefix 9.00 +2.17% 0.20 9.00 10.00 9.20 0.40 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 -0.00% 0.00 1.00 1.00 1.00 0.00 innodb update_autocommit 4.00 -0.00% 0.00 4.00 4.00 4.00 0.00 innodb update_big 81.00 +36.32% 46.20 81.00 150.00 127.20 25.53 innodb update_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_of_key 21.00 +6.25% 1.40 21.00 23.00 22.40 0.80 innodb update_of_key_big 41.00 +12.02% 5.60 41.00 53.00 46.60 4.59 innodb update_of_primary_key_many_keys 862.00 +66.09% 1679.80 862.00 3130.00 2541.80 860.41 innodb update_rollback 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb update_with_key 116.00 +7.50% 9.40 116.00 134.00 125.40 6.56 innodb update_with_key_prefix 42.00 +4.98% 2.20 42.00 46.00 44.20 1.47 innodb wisc_benchmark 3.00 -7.14% -0.20 2.00 4.00 2.80 0.75 ========================================================================================================================= TRENDING OVER LAST 20 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 34.00 +8.11% 3.00 18.00 50.00 37.00 6.73 innodb alter_table_drop 22.00 +28.80% 8.90 15.00 45.00 30.90 5.92 innodb connect 2.00 +6.98% 0.15 2.00 3.00 2.15 0.36 innodb connect+select_1_row 3.00 -1.69% -0.05 2.00 3.00 2.95 0.22 innodb connect+select_simple 3.00 -11.11% -0.30 2.00 3.00 2.70 0.46 innodb count 13.00 +17.46% 2.75 13.00 18.00 15.75 2.00 innodb count_distinct 7.00 -0.00% 0.00 6.00 8.00 7.00 0.84 innodb count_distinct_2 15.00 -13.64% -1.80 11.00 16.00 13.20 1.36 innodb count_distinct_big 21.00 +5.83% 1.30 19.00 25.00 22.30 1.93 innodb count_distinct_group 13.00 +10.03% 1.45 13.00 16.00 14.45 0.80 innodb count_distinct_group_on_key 11.00 -7.84% -0.80 8.00 12.00 10.20 1.29 innodb count_distinct_group_on_key_parts 14.00 -1.45% -0.20 12.00 15.00 13.80 0.93 innodb count_distinct_key_prefix 4.00 +24.53% 1.30 4.00 6.00 5.30 0.78 innodb count_group_on_key_parts 11.00 -0.00% 0.00 10.00 12.00 11.00 0.63 innodb count_on_key 92.00 +1.55% 1.45 90.00 97.00 93.45 1.72 innodb create+drop 41.00 +27.82% 15.80 34.00 71.00 56.80 10.49 innodb create_index 4.00 +22.33% 1.15 3.00 8.00 5.15 1.15 innodb create_key+drop 30.00 +17.24% 6.25 28.00 43.00 36.25 4.89 innodb create_MANY_tables 33.00 +33.67% 16.75 27.00 64.00 49.75 10.21 innodb create_table 0.00 +100.00% 0.10 0.00 1.00 0.10 0.30 innodb delete_all_many_keys 359.00 +65.25% 674.10 318.00 1884.00 1033.10 511.31 innodb delete_autocommit 4.00 +10.11% 0.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 359.00 +65.20% 672.70 318.00 1881.00 1031.70 510.55 innodb delete_commit 1.00 +52.38% 1.10 1.00 5.00 2.10 0.77 innodb delete_key 3.00 +17.81% 0.65 2.00 5.00 3.65 0.91 innodb delete_range 14.00 +10.54% 1.65 9.00 22.00 15.65 3.51 innodb delete_rollback 2.00 +16.67% 0.40 2.00 3.00 2.40 0.49 innodb drop_index 5.00 +10.71% 0.60 2.00 9.00 5.60 1.53 innodb drop_table 0.00 +100.00% 0.25 0.00 2.00 0.25 0.62 innodb drop_table_when_MANY_tables 19.00 +37.50% 11.40 18.00 42.00 30.40 8.19 innodb insert 110.00 +6.86% 8.10 110.00 129.00 118.10 5.39 innodb insert_autocommit 3.00 +9.09% 0.30 3.00 4.00 3.30 0.46 innodb insert_commit 1.00 +37.50% 0.60 1.00 2.00 1.60 0.49 innodb insert_duplicates 19.00 +2.31% 0.45 18.00 21.00 19.45 0.74 innodb insert_key 271.00 +52.73% 302.35 227.00 876.00 573.35 220.34 innodb insert_many_fields 7.00 +10.83% 0.85 6.00 10.00 7.85 1.06 innodb insert_rollback 2.00 +13.04% 0.30 2.00 3.00 2.30 0.46 innodb insert_select_1_key 3.00 +29.41% 1.25 3.00 6.00 4.25 0.94 innodb insert_select_2_keys 9.00 +10.45% 1.05 6.00 13.00 10.05 2.18 innodb min_max 7.00 +11.39% 0.90 6.00 9.00 7.90 1.18 innodb min_max_on_key 24.00 +1.44% 0.35 23.00 25.00 24.35 0.57 innodb multiple_value_insert 4.00 +58.33% 5.60 3.00 16.00 9.60 4.12 innodb once_prepared_select 29.00 +1.02% 0.30 28.00 30.00 29.30 0.56 innodb order_by_big 14.00 +2.44% 0.35 12.00 16.00 14.35 1.42 innodb order_by_big_key 12.00 +8.05% 1.05 11.00 15.00 13.05 1.24 innodb order_by_big_key2 11.00 +9.47% 1.15 10.00 14.00 12.15 1.19 innodb order_by_big_key_desc 13.00 +6.81% 0.95 12.00 15.00 13.95 1.07 innodb order_by_big_key_diff 11.00 +9.47% 1.15 10.00 14.00 12.15 1.19 innodb order_by_big_key_prefix 12.00 +5.14% 0.65 11.00 14.00 12.65 0.96 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 -5.26% -0.05 0.00 1.00 0.95 0.22 innodb order_by_range 1.00 -5.26% -0.05 0.00 1.00 0.95 0.22 innodb outer_join 18.00 +17.62% 3.85 17.00 25.00 21.85 2.41 innodb outer_join_found 17.00 +19.62% 4.15 17.00 27.00 21.15 2.61 innodb outer_join_not_found 15.00 +20.00% 3.75 15.00 22.00 18.75 2.23 innodb outer_join_on_key 12.00 +17.81% 2.60 12.00 17.00 14.60 1.62 innodb prepared_select 36.00 +3.23% 1.20 36.00 38.00 37.20 0.60 innodb select_1_row 3.00 +18.92% 0.70 3.00 4.00 3.70 0.46 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 +21.05% 0.80 3.00 4.00 3.80 0.40 innodb select_big 11.00 +9.84% 1.20 11.00 14.00 12.20 1.08 innodb select_big_str 1.00 +13.04% 0.15 1.00 2.00 1.15 0.36 innodb select_cache 58.00 +7.05% 4.40 57.00 71.00 62.40 3.58 innodb select_cache2 64.00 +0.78% 0.50 58.00 71.00 64.50 3.79 innodb select_column+column 4.00 -3.90% -0.15 3.00 4.00 3.85 0.36 innodb select_diff_key 0.00 +100.00% 0.15 0.00 1.00 0.15 0.36 innodb select_distinct 5.00 -11.11% -0.50 4.00 5.00 4.50 0.50 innodb select_group 15.00 +10.45% 1.75 15.00 20.00 16.75 1.58 innodb select_group_when_MANY_tables 21.00 +37.41% 12.55 18.00 46.00 33.55 8.42 innodb select_join 0.00 +100.00% 0.60 0.00 1.00 0.60 0.49 innodb select_key 62.00 +2.82% 1.80 62.00 65.00 63.80 0.93 innodb select_key2 69.00 +2.61% 1.85 69.00 72.00 70.85 1.06 innodb select_key2_return_key 67.00 +1.03% 0.70 66.00 69.00 67.70 0.78 innodb select_key2_return_prim 67.00 +2.40% 1.65 67.00 70.00 68.65 0.96 innodb select_key_prefix 69.00 +1.85% 1.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 61.00 +2.32% 1.45 61.00 64.00 62.45 0.80 innodb select_many_fields 12.00 +6.61% 0.85 11.00 14.00 12.85 0.65 innodb select_range 45.00 -4.53% -1.95 40.00 46.00 43.05 1.99 innodb select_range_key2 10.00 -4.17% -0.40 9.00 10.00 9.60 0.49 innodb select_range_prefix 9.00 +2.70% 0.25 8.00 10.00 9.25 0.62 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 -17.65% -0.15 0.00 1.00 0.85 0.36 innodb update_autocommit 4.00 -0.00% 0.00 3.00 7.00 4.00 0.84 innodb update_big 81.00 +34.86% 43.35 57.00 195.00 124.35 31.75 innodb update_commit 2.00 -5.26% -0.10 1.00 2.00 1.90 0.30 innodb update_of_key 21.00 +5.83% 1.30 21.00 24.00 22.30 0.84 innodb update_of_key_big 41.00 +9.59% 4.35 26.00 56.00 45.35 6.66 innodb update_of_primary_key_many_keys 862.00 +61.33% 1366.85 770.00 3761.00 2228.85 1,019.78 innodb update_rollback 2.00 +9.09% 0.20 2.00 4.00 2.20 0.51 innodb update_with_key 116.00 +8.52% 10.80 116.00 141.00 126.80 7.67 innodb update_with_key_prefix 42.00 +5.72% 2.55 40.00 49.00 44.55 2.50 innodb wisc_benchmark 3.00 -7.14% -0.20 2.00 4.00 2.80 0.68 ========================================================================================================================= TRENDING OVER ALL runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 34.00 -81.78% -15.30 11.00 61.00 18.70 9.48 innodb alter_table_drop 22.00 -27.63% -4.76 10.00 57.00 17.24 7.09 innodb connect 2.00 +2.39% 0.05 1.00 3.00 2.05 0.41 innodb connect+select_1_row 3.00 -12.84% -0.34 2.00 5.00 2.66 0.49 innodb connect+select_simple 3.00 -30.55% -0.70 1.00 3.00 2.30 0.47 innodb count 13.00 +17.31% 2.72 12.00 193.00 15.72 9.64 innodb count_distinct 7.00 -7.53% -0.49 5.00 50.00 6.51 2.47 innodb count_distinct_2 15.00 -15.05% -1.96 11.00 63.00 13.04 3.17 innodb count_distinct_big 21.00 +3.48% 0.76 5.00 67.00 21.76 3.18 innodb count_distinct_group 13.00 -1.50% -0.19 10.00 68.00 12.81 3.20 innodb count_distinct_group_on_key 11.00 -17.19% -1.61 7.00 69.00 9.39 3.25 innodb count_distinct_group_on_key_parts 14.00 -16.18% -1.95 9.00 72.00 12.05 3.29 innodb count_distinct_key_prefix 4.00 +21.06% 1.07 3.00 52.00 5.07 2.60 innodb count_group_on_key_parts 11.00 -12.97% -1.26 7.00 72.00 9.74 3.40 innodb count_on_key 92.00 -9.09% -7.67 68.00 203.00 84.33 8.01 innodb create+drop 41.00 -25.24% -8.26 18.00 81.00 32.74 13.53 innodb create_index 4.00 -41.65% -1.18 1.00 8.00 2.82 1.22 innodb create_key+drop 30.00 -8.05% -2.23 21.00 50.00 27.77 5.07 innodb create_MANY_tables 33.00 +9.78% 3.58 14.00 121.00 36.58 17.48 innodb create_table 0.00 +100.00% 0.11 0.00 3.00 0.11 0.38 innodb delete_all_many_keys 359.00 +17.36% 75.42 212.00 2293.00 434.42 407.72 innodb delete_autocommit 4.00 -17.72% -0.60 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 359.00 +17.32% 75.22 212.00 2293.00 434.22 407.44 innodb delete_commit 1.00 +30.95% 0.45 1.00 5.00 1.45 0.53 innodb delete_key 3.00 +3.43% 0.11 2.00 35.00 3.11 1.62 innodb delete_range 14.00 -69.65% -5.75 5.00 23.00 8.25 3.53 innodb delete_rollback 2.00 -24.50% -0.39 1.00 4.00 1.61 0.59 innodb drop_index 5.00 -71.13% -2.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 19.00 +3.64% 0.72 11.00 49.00 19.72 6.75 innodb insert 110.00 -4.61% -4.84 3.00 343.00 105.16 15.54 innodb insert_autocommit 3.00 -2.00% -0.06 2.00 99.00 2.94 3.63 innodb insert_commit 1.00 +22.73% 0.29 1.00 3.00 1.29 0.46 innodb insert_duplicates 19.00 -29.24% -4.30 11.00 21.00 14.70 2.25 innodb insert_key 271.00 +22.14% 77.07 142.00 959.00 348.07 175.48 innodb insert_many_fields 7.00 -25.66% -1.43 3.00 17.00 5.57 1.92 innodb insert_rollback 2.00 -25.04% -0.40 1.00 3.00 1.60 0.55 innodb insert_select_1_key 3.00 +20.07% 0.75 2.00 10.00 3.75 0.93 innodb insert_select_2_keys 9.00 -49.51% -2.98 4.00 16.00 6.02 2.26 innodb min_max 7.00 +10.38% 0.81 6.00 110.00 7.81 4.96 innodb min_max_on_key 24.00 -21.73% -4.28 14.00 37.00 19.72 2.72 innodb multiple_value_insert 4.00 +23.78% 1.25 2.00 50.00 5.25 4.66 innodb once_prepared_select 29.00 -25.17% -5.83 18.00 32.00 23.17 3.00 innodb order_by_big 14.00 +1.84% 0.26 12.00 31.00 14.26 1.59 innodb order_by_big_key 12.00 +7.98% 1.04 11.00 32.00 13.04 1.60 innodb order_by_big_key2 11.00 +8.44% 1.01 10.00 33.00 12.01 1.59 innodb order_by_big_key_desc 13.00 +1.03% 0.13 11.00 32.00 13.13 1.55 innodb order_by_big_key_diff 11.00 +8.60% 1.04 10.00 31.00 12.04 1.54 innodb order_by_big_key_prefix 12.00 +1.58% 0.19 10.00 32.00 12.19 1.60 innodb order_by_key2_diff 1.00 +28.84% 0.41 1.00 3.00 1.41 0.50 innodb order_by_key_prefix 1.00 -28.70% -0.22 0.00 2.00 0.78 0.42 innodb order_by_range 1.00 -24.22% -0.19 0.00 2.00 0.81 0.40 innodb outer_join 18.00 +4.26% 0.80 15.00 61.00 18.80 3.70 innodb outer_join_found 17.00 +7.00% 1.28 14.00 58.00 18.28 3.58 innodb outer_join_not_found 15.00 +5.99% 0.96 12.00 46.00 15.96 3.10 innodb outer_join_on_key 12.00 +4.24% 0.53 10.00 59.00 12.53 2.80 innodb prepared_select 36.00 -19.62% -5.90 22.00 40.00 30.10 3.97 innodb select_1_row 3.00 -11.20% -0.30 2.00 4.00 2.70 0.62 innodb select_1_row_cache 4.00 -58.54% -1.48 2.00 4.00 2.52 0.61 innodb select_2_rows 3.00 -10.62% -0.29 2.00 4.00 2.71 0.62 innodb select_big 11.00 +8.19% 0.98 0.00 31.00 11.98 1.57 innodb select_big_str 1.00 +11.02% 0.12 0.00 2.00 1.12 0.33 innodb select_cache 58.00 +3.92% 2.37 49.00 676.00 60.37 29.65 innodb select_cache2 64.00 -5.07% -3.09 49.00 677.00 60.91 31.29 innodb select_column+column 4.00 -45.33% -1.25 2.00 4.00 2.75 0.64 innodb select_diff_key 0.00 +100.00% 0.20 0.00 1.00 0.20 0.40 innodb select_distinct 5.00 -19.49% -0.82 3.00 8.00 4.18 0.54 innodb select_group 15.00 +6.78% 1.09 4.00 136.00 16.09 5.91 innodb select_group_when_MANY_tables 21.00 -140.32% -12.26 3.00 47.00 8.74 9.93 innodb select_join 0.00 +100.00% 0.56 0.00 1.00 0.56 0.50 innodb select_key 62.00 -22.86% -11.54 40.00 66.00 50.46 6.03 innodb select_key2 69.00 -20.92% -11.94 45.00 75.00 57.06 7.08 innodb select_key2_return_key 67.00 -23.23% -12.63 42.00 70.00 54.37 6.74 innodb select_key2_return_prim 67.00 -21.55% -11.88 42.00 72.00 55.12 6.93 innodb select_key_prefix 69.00 -22.70% -12.77 44.00 75.00 56.23 6.94 innodb select_key_prefix_join 5.00 -8.01% -0.37 3.00 10.00 4.63 0.66 innodb select_key_return_key 61.00 -23.26% -11.51 38.00 65.00 49.49 6.05 innodb select_many_fields 12.00 +21.59% 3.30 11.00 19.00 15.30 1.75 innodb select_range 45.00 +6.18% 2.97 39.00 76.00 47.97 3.63 innodb select_range_key2 10.00 -24.96% -2.00 6.00 10.00 8.00 0.94 innodb select_range_prefix 9.00 -19.23% -1.45 5.00 10.00 7.55 0.96 innodb select_simple 2.00 -27.45% -0.43 1.00 3.00 1.57 0.53 innodb select_simple_cache 2.00 -36.97% -0.54 1.00 3.00 1.46 0.51 innodb select_simple_join 1.00 -57.49% -0.37 0.00 3.00 0.63 0.49 innodb update_autocommit 4.00 -25.37% -0.81 2.00 7.00 3.19 0.53 innodb update_big 81.00 -65.24% -31.98 31.00 195.00 49.02 26.19 innodb update_commit 2.00 -38.24% -0.55 1.00 3.00 1.45 0.50 innodb update_of_key 21.00 +14.62% 3.60 18.00 100.00 24.60 6.71 innodb update_of_key_big 41.00 -59.97% -15.37 15.00 75.00 25.63 11.02 innodb update_of_primary_key_many_keys 862.00 +29.14% 354.44 647.00 6065.00 1216.44 1,083.66 innodb update_rollback 2.00 -29.23% -0.45 1.00 4.00 1.55 0.58 innodb update_with_key 116.00 -8.05% -8.65 90.00 598.00 107.35 22.00 innodb update_with_key_prefix 42.00 -8.56% -3.31 33.00 202.00 38.69 7.07 innodb wisc_benchmark 3.00 -22.26% -0.55 2.00 5.00 2.45 0.53 ========================================================================================================================= FULL REVISION COMMENTARY: 2044.1.1: Andrew Hutchings 2011-01-01 Backport fix for MySQL bug #52005 _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
