======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 778 RUN DATE: 2010-12-31T03:00:54.428094 SERVER: drizzled VERSION: staging REVISION: 2044 COMMENT: 2044: Brian Aker 2010-12-30 [merge] Partial update to the time code.
========================================================================================================================= TRENDING OVER LAST 5 runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 39.00 +2.50% 1.00 37.00 44.00 40.00 2.61 innodb alter_table_drop 35.00 -4.17% -1.40 31.00 36.00 33.60 1.85 innodb connect 2.00 +9.09% 0.20 2.00 3.00 2.20 0.40 innodb connect+select_1_row 2.00 +28.57% 0.80 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 +12.16% 1.80 13.00 17.00 14.80 1.83 innodb count_distinct 8.00 -14.29% -1.00 6.00 8.00 7.00 0.89 innodb count_distinct_2 12.00 +9.09% 1.20 12.00 15.00 13.20 1.17 innodb count_distinct_big 21.00 +5.41% 1.20 20.00 25.00 22.20 1.94 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 8.00 12.00 9.80 1.33 innodb count_distinct_group_on_key_parts 14.00 +1.41% 0.20 14.00 15.00 14.20 0.40 innodb count_distinct_key_prefix 6.00 -7.14% -0.40 4.00 6.00 5.60 0.80 innodb count_group_on_key_parts 10.00 +7.41% 0.80 10.00 12.00 10.80 0.75 innodb count_on_key 92.00 -0.00% 0.00 91.00 93.00 92.00 0.63 innodb create+drop 66.00 -3.45% -2.20 60.00 69.00 63.80 3.49 innodb create_index 4.00 +28.57% 1.60 4.00 7.00 5.60 1.02 innodb create_key+drop 42.00 -4.48% -1.80 39.00 42.00 40.20 0.98 innodb create_MANY_tables 61.00 -7.39% -4.20 50.00 61.00 56.80 3.92 innodb delete_all_many_keys 1409.00 +1.85% 26.60 1406.00 1473.00 1435.60 25.17 innodb delete_autocommit 4.00 +28.57% 1.60 3.00 14.00 5.60 4.22 innodb delete_big 1.00 +28.57% 0.40 1.00 3.00 1.40 0.80 innodb delete_big_many_keys 1407.00 +1.84% 26.40 1403.00 1471.00 1433.40 25.41 innodb delete_commit 2.00 -0.00% 0.00 2.00 2.00 2.00 0.00 innodb delete_key 3.00 +21.05% 0.80 3.00 5.00 3.80 0.98 innodb delete_range 17.00 +4.49% 0.80 15.00 20.00 17.80 1.72 innodb delete_rollback 2.00 +23.08% 0.60 2.00 3.00 2.60 0.49 innodb drop_index 8.00 -25.00% -1.60 5.00 8.00 6.40 1.36 innodb drop_table 0.00 +100.00% 0.60 0.00 2.00 0.60 0.80 innodb drop_table_when_MANY_tables 42.00 -11.11% -4.20 32.00 42.00 37.80 3.71 innodb insert 123.00 -1.82% -2.20 115.00 124.00 120.80 3.66 innodb insert_autocommit 4.00 -17.65% -0.60 3.00 4.00 3.40 0.49 innodb insert_commit 1.00 +37.50% 0.60 1.00 2.00 1.60 0.49 innodb insert_duplicates 18.00 +5.26% 1.00 18.00 20.00 19.00 0.63 innodb insert_key 791.00 -4.11% -31.20 729.00 791.00 759.80 26.13 innodb insert_many_fields 9.00 -9.76% -0.80 6.00 10.00 8.20 1.33 innodb insert_rollback 2.00 +16.67% 0.40 2.00 3.00 2.40 0.49 innodb insert_select_1_key 5.00 -13.64% -0.60 3.00 5.00 4.40 0.80 innodb insert_select_2_keys 13.00 -10.17% -1.20 10.00 13.00 11.80 1.17 innodb min_max 7.00 +7.89% 0.60 7.00 9.00 7.60 0.80 innodb min_max_on_key 24.00 +0.83% 0.20 23.00 25.00 24.20 0.75 innodb multiple_value_insert 12.00 +6.25% 0.80 12.00 14.00 12.80 0.75 innodb once_prepared_select 29.00 +0.68% 0.20 28.00 30.00 29.20 0.75 innodb order_by_big 13.00 +13.33% 2.00 13.00 16.00 15.00 1.10 innodb order_by_big_key 12.00 +10.45% 1.40 12.00 15.00 13.40 1.20 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 +8.45% 1.20 13.00 15.00 14.20 0.75 innodb order_by_big_key_diff 12.00 +6.25% 0.80 12.00 14.00 12.80 0.75 innodb order_by_big_key_prefix 12.00 +9.09% 1.20 12.00 14.00 13.20 0.75 innodb order_by_key2_diff 2.00 -66.67% -0.80 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 22.00 -5.77% -1.20 18.00 24.00 20.80 2.40 innodb outer_join_found 22.00 -8.91% -1.80 17.00 22.00 20.20 2.23 innodb outer_join_not_found 20.00 -11.11% -2.00 15.00 21.00 18.00 2.28 innodb outer_join_on_key 15.00 -7.14% -1.00 12.00 16.00 14.00 1.41 innodb prepared_select 37.00 +1.07% 0.40 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 +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 +4.76% 0.60 11.00 14.00 12.60 1.02 innodb select_big_str 1.00 +16.67% 0.20 1.00 2.00 1.20 0.40 innodb select_cache 61.00 +0.33% 0.20 58.00 67.00 61.20 3.31 innodb select_cache2 61.00 +3.79% 2.40 59.00 71.00 63.40 4.13 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.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 19.00 -14.46% -2.40 15.00 19.00 16.60 1.62 innodb select_group_when_MANY_tables 42.00 -4.48% -1.80 38.00 42.00 40.20 1.83 innodb select_join 1.00 -66.67% -0.40 0.00 1.00 0.60 0.49 innodb select_key 62.00 +2.52% 1.60 62.00 64.00 63.60 0.80 innodb select_key2 70.00 +1.41% 1.00 70.00 72.00 71.00 0.89 innodb select_key2_return_key 67.00 +1.18% 0.80 67.00 69.00 67.80 0.75 innodb select_key2_return_prim 67.00 +2.62% 1.80 67.00 70.00 68.80 0.98 innodb select_key_prefix 69.00 +2.27% 1.60 69.00 72.00 70.60 1.20 innodb select_key_prefix_join 6.00 -11.11% -0.60 5.00 6.00 5.40 0.49 innodb select_key_return_key 62.00 +0.96% 0.60 62.00 63.00 62.60 0.49 innodb select_many_fields 14.00 -7.69% -1.00 12.00 14.00 13.00 0.63 innodb select_range 42.00 -0.96% -0.40 40.00 45.00 41.60 1.85 innodb select_range_key2 10.00 -2.04% -0.20 9.00 10.00 9.80 0.40 innodb select_range_prefix 9.00 -0.00% 0.00 8.00 10.00 9.00 0.63 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 +4.76% 0.20 4.00 5.00 4.20 0.40 innodb update_big 149.00 -3.47% -5.00 131.00 152.00 144.00 8.79 innodb update_commit 2.00 -11.11% -0.20 1.00 2.00 1.80 0.40 innodb update_of_key 23.00 -0.88% -0.20 22.00 24.00 22.80 0.75 innodb update_of_key_big 50.00 -3.73% -1.80 44.00 51.00 48.20 2.48 innodb update_of_primary_key_many_keys 3048.00 +0.73% 22.40 3032.00 3130.00 3070.40 38.93 innodb update_rollback 2.00 +16.67% 0.40 2.00 4.00 2.40 0.80 innodb update_with_key 130.00 +1.81% 2.40 120.00 141.00 132.40 7.28 innodb update_with_key_prefix 46.00 -0.88% -0.40 43.00 47.00 45.60 1.36 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 39.00 -10.64% -3.75 18.00 50.00 35.25 7.99 innodb alter_table_drop 35.00 -18.64% -5.50 15.00 45.00 29.50 7.32 innodb connect 2.00 +4.76% 0.10 2.00 3.00 2.10 0.30 innodb connect+select_1_row 2.00 +32.20% 0.95 2.00 3.00 2.95 0.22 innodb connect+select_simple 3.00 -9.09% -0.25 2.00 3.00 2.75 0.43 innodb count 13.00 +17.98% 2.85 13.00 18.00 15.85 1.98 innodb count_distinct 8.00 -15.11% -1.05 6.00 8.00 6.95 0.86 innodb count_distinct_2 12.00 +10.45% 1.40 12.00 16.00 13.40 1.36 innodb count_distinct_big 21.00 +6.04% 1.35 19.00 25.00 22.35 2.06 innodb count_distinct_group 14.00 +4.44% 0.65 13.00 16.00 14.65 0.79 innodb count_distinct_group_on_key 9.00 +10.00% 1.00 8.00 12.00 10.00 1.34 innodb count_distinct_group_on_key_parts 14.00 -1.45% -0.20 12.00 15.00 13.80 0.98 innodb count_distinct_key_prefix 6.00 -12.15% -0.65 4.00 7.00 5.35 0.79 innodb count_group_on_key_parts 10.00 +9.50% 1.05 10.00 12.00 11.05 0.59 innodb count_on_key 92.00 +2.02% 1.90 90.00 97.00 93.90 1.89 innodb create+drop 66.00 -21.32% -11.60 34.00 71.00 54.40 11.10 innodb create_index 4.00 +20.79% 1.05 3.00 7.00 5.05 1.12 innodb create_key+drop 42.00 -18.31% -6.50 28.00 43.00 35.50 5.07 innodb create_MANY_tables 61.00 -27.75% -13.25 25.00 64.00 47.75 11.15 innodb create_table 0.00 +100.00% 0.20 0.00 2.00 0.20 0.51 innodb delete_all_many_keys 1409.00 -48.39% -459.45 301.00 1884.00 949.55 528.66 innodb delete_autocommit 4.00 +13.98% 0.65 3.00 14.00 4.65 2.59 innodb delete_big 1.00 -5.26% -0.05 0.00 3.00 0.95 0.67 innodb delete_big_many_keys 1407.00 -48.38% -458.75 301.00 1881.00 948.25 527.84 innodb delete_commit 2.00 +6.98% 0.15 1.00 5.00 2.15 0.73 innodb delete_key 3.00 +13.04% 0.45 2.00 5.00 3.45 0.92 innodb delete_range 17.00 -16.44% -2.40 8.00 22.00 14.60 3.89 innodb delete_rollback 2.00 +16.67% 0.40 2.00 3.00 2.40 0.49 innodb drop_index 8.00 -53.85% -2.80 2.00 9.00 5.20 1.78 innodb drop_table 0.00 +100.00% 0.20 0.00 2.00 0.20 0.51 innodb drop_table_when_MANY_tables 42.00 -43.34% -12.70 17.00 42.00 29.30 8.31 innodb insert 123.00 -4.81% -5.65 110.00 129.00 117.35 5.53 innodb insert_autocommit 4.00 -21.21% -0.70 3.00 4.00 3.30 0.46 innodb insert_commit 1.00 +39.39% 0.65 1.00 2.00 1.65 0.48 innodb insert_duplicates 18.00 +6.98% 1.35 18.00 21.00 19.35 0.73 innodb insert_key 791.00 -47.22% -253.70 227.00 876.00 537.30 225.99 innodb insert_many_fields 9.00 -16.13% -1.25 6.00 10.00 7.75 1.13 innodb insert_rollback 2.00 +11.11% 0.25 2.00 3.00 2.25 0.43 innodb insert_select_1_key 5.00 -21.95% -0.90 3.00 6.00 4.10 0.94 innodb insert_select_2_keys 13.00 -32.65% -3.20 6.00 13.00 9.80 2.36 innodb min_max 7.00 +11.95% 0.95 6.00 9.00 7.95 1.07 innodb min_max_on_key 24.00 +1.84% 0.45 23.00 25.00 24.45 0.59 innodb multiple_value_insert 12.00 -35.59% -3.15 3.00 16.00 8.85 4.34 innodb once_prepared_select 29.00 +1.36% 0.40 28.00 30.00 29.40 0.58 innodb order_by_big 13.00 +9.72% 1.40 12.00 16.00 14.40 1.43 innodb order_by_big_key 12.00 +7.34% 0.95 11.00 15.00 12.95 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.47% 0.90 12.00 15.00 13.90 1.14 innodb order_by_big_key_diff 12.00 +0.83% 0.10 10.00 14.00 12.10 1.26 innodb order_by_big_key_prefix 12.00 +5.14% 0.65 11.00 14.00 12.65 1.06 innodb order_by_key2_diff 2.00 -33.33% -0.50 1.00 2.00 1.50 0.50 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 -11.11% -0.10 0.00 1.00 0.90 0.30 innodb outer_join 22.00 -0.69% -0.15 17.00 25.00 21.85 2.41 innodb outer_join_found 22.00 -4.76% -1.00 17.00 24.00 21.00 2.35 innodb outer_join_not_found 20.00 -6.38% -1.20 15.00 22.00 18.80 2.23 innodb outer_join_on_key 15.00 -2.39% -0.35 11.00 17.00 14.65 1.77 innodb prepared_select 37.00 +0.94% 0.35 36.00 38.00 37.35 0.57 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 +9.09% 0.30 3.00 4.00 3.30 0.46 innodb select_2_rows 4.00 -2.56% -0.10 3.00 4.00 3.90 0.30 innodb select_big 12.00 +2.04% 0.25 11.00 14.00 12.25 1.13 innodb select_big_str 1.00 +13.04% 0.15 1.00 2.00 1.15 0.36 innodb select_cache 61.00 +2.09% 1.30 57.00 71.00 62.30 3.33 innodb select_cache2 61.00 +5.13% 3.30 58.00 71.00 64.30 3.78 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.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 19.00 -14.11% -2.35 15.00 20.00 16.65 1.65 innodb select_group_when_MANY_tables 42.00 -32.91% -10.40 16.00 46.00 31.60 9.16 innodb select_join 1.00 -42.86% -0.30 0.00 1.00 0.70 0.46 innodb select_key 62.00 +3.20% 2.05 62.00 66.00 64.05 0.97 innodb select_key2 70.00 +1.48% 1.05 69.00 73.00 71.05 1.07 innodb select_key2_return_key 67.00 +1.40% 0.95 66.00 70.00 67.95 0.92 innodb select_key2_return_prim 67.00 +2.69% 1.85 67.00 71.00 68.85 1.01 innodb select_key_prefix 69.00 +2.20% 1.55 69.00 72.00 70.55 1.02 innodb select_key_prefix_join 6.00 -17.65% -0.90 5.00 6.00 5.10 0.30 innodb select_key_return_key 62.00 +1.27% 0.80 62.00 65.00 62.80 0.81 innodb select_many_fields 14.00 -7.28% -0.95 11.00 14.00 13.05 0.67 innodb select_range 42.00 +0.47% 0.20 39.00 46.00 42.20 2.04 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.70 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 -0.00% 0.00 3.00 7.00 4.00 0.84 innodb update_big 149.00 -25.42% -30.20 55.00 195.00 118.80 35.76 innodb update_commit 2.00 -8.11% -0.15 1.00 2.00 1.85 0.36 innodb update_of_key 23.00 -4.31% -0.95 20.00 24.00 22.05 1.02 innodb update_of_key_big 50.00 -13.12% -5.80 26.00 56.00 44.20 7.58 innodb update_of_primary_key_many_keys 3048.00 -47.74% -984.95 770.00 3761.00 2063.05 1,049.92 innodb update_rollback 2.00 +11.11% 0.25 2.00 4.00 2.25 0.54 innodb update_with_key 130.00 -3.54% -4.45 114.00 141.00 125.55 7.97 innodb update_with_key_prefix 46.00 -3.84% -1.70 40.00 49.00 44.30 2.57 innodb wisc_benchmark 2.00 +23.08% 0.60 2.00 4.00 2.60 0.66 ========================================================================================================================= TRENDING OVER ALL runs Engine Test Time % Diff from Avg Diff Min Max Avg STD ========================================================================================================================= innodb alter_table_add 39.00 -109.46% -20.38 11.00 61.00 18.62 9.41 innodb alter_table_drop 35.00 -103.64% -17.81 10.00 57.00 17.19 7.05 innodb connect 2.00 +2.33% 0.05 1.00 3.00 2.05 0.41 innodb connect+select_1_row 2.00 +24.74% 0.66 2.00 5.00 2.66 0.49 innodb connect+select_simple 3.00 -30.64% -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.66 innodb count_distinct 8.00 -22.93% -1.49 5.00 50.00 6.51 2.47 innodb count_distinct_2 12.00 +7.97% 1.04 11.00 63.00 13.04 3.17 innodb count_distinct_big 21.00 +3.47% 0.75 5.00 67.00 21.75 3.19 innodb count_distinct_group 14.00 -9.35% -1.20 10.00 68.00 12.80 3.21 innodb count_distinct_group_on_key 9.00 +4.08% 0.38 7.00 69.00 9.38 3.25 innodb count_distinct_group_on_key_parts 14.00 -16.23% -1.95 9.00 72.00 12.05 3.29 innodb count_distinct_key_prefix 6.00 -18.43% -0.93 3.00 52.00 5.07 2.60 innodb count_group_on_key_parts 10.00 -2.75% -0.27 7.00 72.00 9.73 3.40 innodb count_on_key 92.00 -9.14% -7.70 68.00 203.00 84.30 8.01 innodb create+drop 66.00 -102.27% -33.37 18.00 81.00 32.63 13.44 innodb create_index 4.00 -42.26% -1.19 1.00 8.00 2.81 1.20 innodb create_key+drop 42.00 -51.45% -14.27 21.00 50.00 27.73 5.05 innodb create_MANY_tables 61.00 -67.00% -24.47 14.00 121.00 36.53 17.48 innodb create_table 0.00 +100.00% 0.12 0.00 3.00 0.12 0.38 innodb delete_all_many_keys 1409.00 -226.22% -977.09 212.00 2293.00 431.91 405.71 innodb delete_autocommit 4.00 -17.72% -0.60 2.00 14.00 3.40 0.78 innodb delete_big 1.00 -290.66% -0.74 0.00 3.00 0.26 0.45 innodb delete_big_many_keys 1407.00 -225.91% -975.28 212.00 2293.00 431.72 405.43 innodb delete_commit 2.00 -38.19% -0.55 1.00 5.00 1.45 0.53 innodb delete_key 3.00 +3.31% 0.10 2.00 35.00 3.10 1.63 innodb delete_range 17.00 -106.93% -8.78 5.00 23.00 8.22 3.49 innodb delete_rollback 2.00 -24.63% -0.40 1.00 4.00 1.60 0.60 innodb drop_index 8.00 -174.90% -5.09 1.00 9.00 2.91 1.42 innodb drop_table 0.00 +100.00% 0.05 0.00 2.00 0.05 0.23 innodb drop_table_when_MANY_tables 42.00 -113.39% -22.32 11.00 49.00 19.68 6.72 innodb insert 123.00 -17.03% -17.90 3.00 343.00 105.10 15.55 innodb insert_autocommit 4.00 -36.01% -1.06 2.00 99.00 2.94 3.64 innodb insert_commit 1.00 +22.63% 0.29 1.00 3.00 1.29 0.46 innodb insert_duplicates 18.00 -22.61% -3.32 11.00 21.00 14.68 2.23 innodb insert_key 791.00 -127.87% -443.87 142.00 959.00 347.13 174.70 innodb insert_many_fields 9.00 -61.78% -3.44 3.00 17.00 5.56 1.93 innodb insert_rollback 2.00 -25.40% -0.41 1.00 3.00 1.59 0.54 innodb insert_select_1_key 5.00 -33.31% -1.25 2.00 10.00 3.75 0.92 innodb insert_select_2_keys 13.00 -116.51% -7.00 4.00 16.00 6.00 2.24 innodb min_max 7.00 +10.40% 0.81 6.00 110.00 7.81 4.97 innodb min_max_on_key 24.00 -21.85% -4.30 14.00 37.00 19.70 2.71 innodb multiple_value_insert 12.00 -129.40% -6.77 2.00 50.00 5.23 4.66 innodb once_prepared_select 29.00 -25.30% -5.86 18.00 32.00 23.14 2.98 innodb order_by_big 13.00 +8.86% 1.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.61 innodb order_by_big_key2 11.00 +8.45% 1.02 10.00 33.00 12.02 1.59 innodb order_by_big_key_desc 13.00 +1.01% 0.13 11.00 32.00 13.13 1.55 innodb order_by_big_key_diff 12.00 +0.29% 0.04 10.00 31.00 12.04 1.54 innodb order_by_big_key_prefix 12.00 +1.57% 0.19 10.00 32.00 12.19 1.61 innodb order_by_key2_diff 2.00 -42.14% -0.59 1.00 3.00 1.41 0.50 innodb order_by_key_prefix 1.00 -28.86% -0.22 0.00 2.00 0.78 0.42 innodb order_by_range 1.00 -24.34% -0.20 0.00 2.00 0.80 0.40 innodb outer_join 22.00 -17.09% -3.21 15.00 61.00 18.79 3.70 innodb outer_join_found 22.00 -20.46% -3.74 14.00 58.00 18.26 3.56 innodb outer_join_not_found 20.00 -25.43% -4.05 12.00 46.00 15.95 3.10 innodb outer_join_on_key 15.00 -19.76% -2.47 10.00 59.00 12.53 2.80 innodb prepared_select 37.00 -23.06% -6.93 22.00 40.00 30.07 3.95 innodb select_1_row 4.00 -48.41% -1.30 2.00 4.00 2.70 0.62 innodb select_1_row_cache 3.00 -19.13% -0.48 2.00 4.00 2.52 0.61 innodb select_2_rows 4.00 -47.64% -1.29 2.00 4.00 2.71 0.62 innodb select_big 12.00 -0.14% -0.02 0.00 31.00 11.98 1.58 innodb select_big_str 1.00 +11.07% 0.12 0.00 2.00 1.12 0.33 innodb select_cache 61.00 -1.06% -0.64 49.00 676.00 60.36 29.71 innodb select_cache2 61.00 -0.17% -0.10 49.00 677.00 60.90 31.35 innodb select_column+column 4.00 -45.60% -1.25 2.00 4.00 2.75 0.63 innodb select_diff_key 0.00 +100.00% 0.20 0.00 1.00 0.20 0.40 innodb select_distinct 4.00 +4.33% 0.18 3.00 8.00 4.18 0.54 innodb select_group 19.00 -18.11% -2.91 4.00 136.00 16.09 5.93 innodb select_group_when_MANY_tables 42.00 -386.56% -33.37 3.00 47.00 8.63 9.80 innodb select_join 1.00 -77.56% -0.44 0.00 1.00 0.56 0.50 innodb select_key 62.00 -22.99% -11.59 40.00 66.00 50.41 5.99 innodb select_key2 70.00 -22.79% -12.99 45.00 75.00 57.01 7.04 innodb select_key2_return_key 67.00 -23.35% -12.68 42.00 70.00 54.32 6.71 innodb select_key2_return_prim 67.00 -21.68% -11.94 42.00 72.00 55.06 6.89 innodb select_key_prefix 69.00 -22.83% -12.82 44.00 75.00 56.18 6.90 innodb select_key_prefix_join 6.00 -29.69% -1.37 3.00 10.00 4.63 0.66 innodb select_key_return_key 62.00 -25.41% -12.56 38.00 65.00 49.44 6.01 innodb select_many_fields 14.00 +8.60% 1.32 11.00 19.00 15.32 1.75 innodb select_range 42.00 +12.46% 5.98 39.00 76.00 47.98 3.63 innodb select_range_key2 10.00 -25.09% -2.01 6.00 10.00 7.99 0.93 innodb select_range_prefix 9.00 -19.33% -1.46 5.00 10.00 7.54 0.96 innodb select_simple 2.00 -27.60% -0.43 1.00 3.00 1.57 0.53 innodb select_simple_cache 2.00 -37.19% -0.54 1.00 3.00 1.46 0.51 innodb select_simple_join 1.00 -57.87% -0.37 0.00 3.00 0.63 0.49 innodb update_autocommit 4.00 -25.51% -0.81 2.00 7.00 3.19 0.53 innodb update_big 149.00 -205.76% -100.27 31.00 195.00 48.73 25.80 innodb update_commit 2.00 -38.46% -0.56 1.00 3.00 1.44 0.50 innodb update_of_key 23.00 +6.53% 1.61 18.00 100.00 24.61 6.72 innodb update_of_key_big 50.00 -95.72% -24.45 15.00 75.00 25.55 10.96 innodb update_of_primary_key_many_keys 3048.00 -151.72% -1837.13 647.00 6065.00 1210.87 1,081.91 innodb update_rollback 2.00 -29.39% -0.45 1.00 4.00 1.55 0.58 innodb update_with_key 130.00 -21.18% -22.72 90.00 598.00 107.28 22.01 innodb update_with_key_prefix 46.00 -18.96% -7.33 33.00 202.00 38.67 7.08 innodb wisc_benchmark 2.00 +18.37% 0.45 2.00 5.00 2.45 0.53 ========================================================================================================================= FULL REVISION COMMENTARY: 2040.4.3: Brian Aker 2010-12-30 Scale down the calls to universal_time(). 2040.4.2: Brian Aker 2010-12-30 First pass on removing some of the calls currently to boost::posix_time. (we 2040.4.1: Brian Aker 2010-12-30 Update to time and field. _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
