======================================================================================= SQLBENCH REPORT ======================================================================================= ENGINE: innodb MACHINE: orisndriz05 RUN ID: 288 RUN DATE: 2010-05-19T20:49:05.837727 SERVER: drizzled VERSION: staging REVISION: 1548 COMMENT: 1548: Brian Aker 2010-05-19 [merge] Merge Patrick
========================================================================================================================= TRENDING OVER LAST 5 runs Engine Test Time % Diff from Avg Diff Norm? Min Max Avg STD ========================================================================================================================= innodb alter_table_add 13.00 +4.41% 0.60 outside norms 13.00 14.00 13.60 0.49 innodb alter_table_drop 15.00 -10.29% -1.40 outside norms 13.00 15.00 13.60 0.80 innodb connect 2.00 -0.00% 0.00 within norms 1.00 3.00 2.00 0.63 innodb connect+select_1_row 2.00 +9.09% 0.20 within norms 2.00 3.00 2.20 0.40 innodb connect+select_simple 3.00 -15.38% -0.40 within norms 2.00 3.00 2.60 0.49 innodb count 13.00 +7.14% 1.00 within norms 13.00 17.00 14.00 1.55 innodb count_distinct 5.00 +19.35% 1.20 outside norms 5.00 7.00 6.20 0.75 innodb count_distinct_2 12.00 +6.25% 0.80 within norms 11.00 15.00 12.80 1.83 innodb count_distinct_big 21.00 -0.00% 0.00 within norms 19.00 24.00 21.00 1.67 innodb count_distinct_group 10.00 +13.79% 1.60 outside norms 10.00 13.00 11.60 1.20 innodb count_distinct_group_on_key 8.00 +11.11% 1.00 within norms 8.00 11.00 9.00 1.26 innodb count_distinct_group_on_key_parts 11.00 +6.78% 0.80 within norms 11.00 13.00 11.80 0.98 innodb count_distinct_key_prefix 5.00 -4.17% -0.20 within norms 4.00 6.00 4.80 0.75 innodb count_group_on_key_parts 10.00 -0.00% 0.00 within norms 9.00 11.00 10.00 0.63 innodb count_on_key 87.00 -3.08% -2.60 within norms 73.00 90.00 84.40 6.18 innodb create+drop 31.00 -9.93% -2.80 outside norms 25.00 31.00 28.20 2.48 innodb create_index 2.00 +44.44% 1.60 within norms 2.00 6.00 3.60 1.62 innodb create_key+drop 25.00 -3.31% -0.80 outside norms 23.00 25.00 24.20 0.75 innodb create_MANY_tables 44.00 +3.51% 1.60 within norms 40.00 54.00 45.60 4.59 innodb create_table 0.00 NULL 0.00 within norms 0.00 0.00 0.00 0.00 innodb delete_all_many_keys 274.00 +3.86% 11.00 outside norms 274.00 298.00 285.00 7.69 innodb delete_autocommit 3.00 +11.76% 0.40 within norms 3.00 4.00 3.40 0.49 innodb delete_big 1.00 -150.00% -0.60 outside norms 0.00 1.00 0.40 0.49 innodb delete_big_many_keys 274.00 +3.86% 11.00 outside norms 274.00 298.00 285.00 7.69 innodb delete_commit 1.00 +16.67% 0.20 within norms 1.00 2.00 1.20 0.40 innodb delete_key 3.00 -7.14% -0.20 within norms 2.00 3.00 2.80 0.40 innodb delete_range 9.00 +4.26% 0.40 within norms 8.00 10.00 9.40 0.80 innodb delete_rollback 1.00 +16.67% 0.20 within norms 1.00 2.00 1.20 0.40 innodb drop_index 2.00 +37.50% 1.20 outside norms 2.00 5.00 3.20 1.17 innodb drop_table 0.00 NULL 0.00 within norms 0.00 0.00 0.00 0.00 innodb drop_table_when_MANY_tables 20.00 +15.97% 3.80 outside norms 20.00 26.00 23.80 2.40 innodb insert 107.00 -2.88% -3.00 outside norms 100.00 107.00 104.00 2.37 innodb insert_autocommit 2.00 +9.09% 0.20 within norms 2.00 3.00 2.20 0.40 innodb insert_commit 2.00 -25.00% -0.40 within norms 1.00 2.00 1.60 0.49 innodb insert_duplicates 12.00 +6.25% 0.80 outside norms 12.00 13.00 12.80 0.40 innodb insert_key 613.00 -7.21% -41.20 within norms 441.00 709.00 571.80 90.64 innodb insert_many_fields 4.00 +4.76% 0.20 within norms 4.00 5.00 4.20 0.40 innodb insert_rollback 2.00 -11.11% -0.20 within norms 1.00 2.00 1.80 0.40 innodb insert_select_1_key 4.00 -0.00% 0.00 within norms 3.00 5.00 4.00 0.63 innodb insert_select_2_keys 5.00 +16.67% 1.00 outside norms 5.00 7.00 6.00 0.63 innodb min_max 7.00 +2.78% 0.20 within norms 7.00 8.00 7.20 0.40 innodb min_max_on_key 18.00 +7.22% 1.40 within norms 18.00 22.00 19.40 1.74 innodb multiple_value_insert 4.00 +13.04% 0.60 within norms 3.00 6.00 4.60 1.02 innodb once_prepared_select 24.00 -11.11% -2.40 outside norms 19.00 24.00 21.60 1.85 innodb order_by_big 13.00 +7.14% 1.00 within norms 13.00 17.00 14.00 1.55 innodb order_by_big_key 11.00 +11.29% 1.40 within norms 11.00 16.00 12.40 1.85 innodb order_by_big_key2 11.00 +5.17% 0.60 within norms 11.00 14.00 11.60 1.20 innodb order_by_big_key_desc 12.00 +6.25% 0.80 within norms 12.00 16.00 12.80 1.60 innodb order_by_big_key_diff 11.00 +8.33% 1.00 within norms 11.00 15.00 12.00 1.55 innodb order_by_big_key_prefix 10.00 +9.09% 1.00 within norms 10.00 14.00 11.00 1.55 innodb order_by_key2_diff 1.00 +44.44% 0.80 outside norms 1.00 2.00 1.80 0.40 innodb order_by_key_prefix 1.00 -25.00% -0.20 within norms 0.00 1.00 0.80 0.40 innodb order_by_range 1.00 -66.67% -0.40 within norms 0.00 1.00 0.60 0.49 innodb outer_join 15.00 +10.71% 1.80 within norms 15.00 19.00 16.80 1.83 innodb outer_join_found 15.00 +10.71% 1.80 within norms 15.00 20.00 16.80 2.23 innodb outer_join_not_found 14.00 +7.89% 1.20 within norms 14.00 18.00 15.20 1.60 innodb outer_join_on_key 11.00 +6.78% 0.80 within norms 11.00 13.00 11.80 0.98 innodb prepared_select 29.00 -6.62% -1.80 within norms 25.00 30.00 27.20 1.94 innodb select_1_row 2.00 +28.57% 0.80 outside norms 2.00 3.00 2.80 0.40 innodb select_1_row_cache 2.00 -0.00% 0.00 within norms 2.00 2.00 2.00 0.00 innodb select_2_rows 3.00 -15.38% -0.40 within norms 2.00 3.00 2.60 0.49 innodb select_big 11.00 +6.78% 0.80 within norms 11.00 14.00 11.80 1.17 innodb select_big_str 1.00 +16.67% 0.20 within norms 1.00 2.00 1.20 0.40 innodb select_cache 65.00 -6.21% -3.80 within norms 51.00 65.00 61.20 5.31 innodb select_cache2 55.00 +8.33% 5.00 within norms 51.00 65.00 60.00 5.87 innodb select_column+column 2.00 +16.67% 0.40 within norms 2.00 3.00 2.40 0.49 innodb select_diff_key 0.00 NULL 0.00 within norms 0.00 0.00 0.00 0.00 innodb select_distinct 4.00 +4.76% 0.20 within norms 3.00 5.00 4.20 0.75 innodb select_group 15.00 -1.35% -0.20 within norms 14.00 16.00 14.80 0.75 innodb select_group_when_MANY_tables 4.00 +9.09% 0.40 within norms 4.00 5.00 4.40 0.49 innodb select_join 0.00 +100.00% 0.20 within norms 0.00 1.00 0.20 0.40 innodb select_key 47.00 +0.42% 0.20 within norms 47.00 48.00 47.20 0.40 innodb select_key2 52.00 -0.00% 0.00 within norms 52.00 52.00 52.00 0.00 innodb select_key2_return_key 50.00 -0.00% 0.00 within norms 50.00 50.00 50.00 0.00 innodb select_key2_return_prim 50.00 +0.79% 0.40 within norms 50.00 51.00 50.40 0.49 innodb select_key_prefix 52.00 -0.39% -0.20 within norms 51.00 52.00 51.80 0.40 innodb select_key_prefix_join 5.00 -4.17% -0.20 within norms 4.00 6.00 4.80 0.75 innodb select_key_return_key 46.00 +1.29% 0.60 outside norms 46.00 47.00 46.60 0.49 innodb select_many_fields 11.00 +22.54% 3.20 outside norms 11.00 17.00 14.20 2.71 innodb select_range 47.00 +8.20% 4.20 outside norms 47.00 54.00 51.20 3.43 innodb select_range_key2 8.00 -8.11% -0.60 outside norms 7.00 8.00 7.40 0.49 innodb select_range_prefix 7.00 -2.94% -0.20 within norms 6.00 8.00 6.80 0.75 innodb select_simple 1.00 +16.67% 0.20 within norms 1.00 2.00 1.20 0.40 innodb select_simple_cache 1.00 +37.50% 0.60 outside norms 1.00 2.00 1.60 0.49 innodb select_simple_join 1.00 -25.00% -0.20 within norms 0.00 1.00 0.80 0.40 innodb update_autocommit 4.00 -17.65% -0.60 outside norms 3.00 4.00 3.40 0.49 innodb update_big 44.00 -8.37% -3.40 outside norms 38.00 44.00 40.60 2.06 innodb update_commit 1.00 +16.67% 0.20 within norms 1.00 2.00 1.20 0.40 innodb update_of_key 31.00 -8.39% -2.40 within norms 20.00 33.00 28.60 4.59 innodb update_of_key_big 24.00 -3.45% -0.80 within norms 20.00 26.00 23.20 2.04 innodb update_of_primary_key_many_keys 759.00 -0.56% -4.20 within norms 730.00 793.00 754.80 22.12 innodb update_rollback 1.00 -0.00% 0.00 within norms 1.00 1.00 1.00 0.00 innodb update_with_key 98.00 +5.22% 5.40 outside norms 98.00 108.00 103.40 3.32 innodb update_with_key_prefix 36.00 +4.76% 1.80 within norms 34.00 40.00 37.80 2.40 innodb wisc_benchmark 2.00 +9.09% 0.20 within norms 2.00 3.00 2.20 0.40 ========================================================================================================================= TRENDING OVER LAST 20 runs Engine Test Time % Diff from Avg Diff Norm? Min Max Avg STD ========================================================================================================================= innodb alter_table_add 13.00 +10.96% 1.60 within norms 13.00 28.00 14.60 3.12 innodb alter_table_drop 15.00 -9.09% -1.25 within norms 12.00 20.00 13.75 1.76 innodb connect 2.00 -0.00% 0.00 within norms 1.00 3.00 2.00 0.32 innodb connect+select_1_row 2.00 +25.93% 0.70 outside norms 2.00 3.00 2.70 0.46 innodb connect+select_simple 3.00 -36.36% -0.80 outside norms 2.00 3.00 2.20 0.40 innodb count 13.00 +16.67% 2.60 outside norms 13.00 20.00 15.60 2.18 innodb count_distinct 5.00 +26.47% 1.80 within norms 5.00 14.00 6.80 1.83 innodb count_distinct_2 12.00 +13.98% 1.95 within norms 11.00 29.00 13.95 3.90 innodb count_distinct_big 21.00 +5.62% 1.25 within norms 19.00 31.00 22.25 2.66 innodb count_distinct_group 10.00 +20.95% 2.65 within norms 10.00 26.00 12.65 3.41 innodb count_distinct_group_on_key 8.00 +21.18% 2.15 within norms 8.00 25.00 10.15 3.60 innodb count_distinct_group_on_key_parts 11.00 +12.00% 1.50 within norms 10.00 26.00 12.50 3.41 innodb count_distinct_key_prefix 5.00 +4.76% 0.25 within norms 4.00 13.00 5.25 1.89 innodb count_group_on_key_parts 10.00 +1.48% 0.15 within norms 7.00 22.00 10.15 2.92 innodb count_on_key 87.00 +4.13% 3.75 within norms 69.00 203.00 90.75 26.87 innodb create+drop 31.00 -18.77% -4.90 outside norms 21.00 31.00 26.10 2.55 innodb create_index 2.00 +38.46% 1.25 within norms 2.00 6.00 3.25 1.34 innodb create_key+drop 25.00 -2.46% -0.60 within norms 23.00 27.00 24.40 0.80 innodb create_MANY_tables 44.00 -13.40% -5.20 within norms 19.00 54.00 38.80 8.57 innodb create_table 0.00 NULL 0.00 within norms 0.00 0.00 0.00 0.00 innodb delete_all_many_keys 274.00 +8.32% 24.85 within norms 259.00 415.00 298.85 34.88 innodb delete_autocommit 3.00 +15.49% 0.55 outside norms 3.00 4.00 3.55 0.50 innodb delete_big 1.00 -300.00% -0.75 outside norms 0.00 1.00 0.25 0.43 innodb delete_big_many_keys 274.00 +8.32% 24.85 within norms 259.00 415.00 298.85 34.88 innodb delete_commit 1.00 +9.09% 0.10 within norms 1.00 2.00 1.10 0.30 innodb delete_key 3.00 -9.09% -0.25 within norms 2.00 4.00 2.75 0.54 innodb delete_range 9.00 -2.86% -0.25 within norms 6.00 11.00 8.75 1.18 innodb delete_rollback 1.00 +23.08% 0.30 within norms 1.00 2.00 1.30 0.46 innodb drop_index 2.00 +28.57% 0.80 within norms 2.00 5.00 2.80 0.98 innodb drop_table 0.00 NULL 0.00 within norms 0.00 0.00 0.00 0.00 innodb drop_table_when_MANY_tables 20.00 +6.76% 1.45 within norms 16.00 26.00 21.45 2.92 innodb insert 107.00 -3.68% -3.80 outside norms 95.00 108.00 103.20 3.63 innodb insert_autocommit 2.00 +72.79% 5.35 within norms 2.00 99.00 7.35 21.03 innodb insert_commit 2.00 -48.15% -0.65 outside norms 1.00 3.00 1.35 0.57 innodb insert_duplicates 12.00 +8.40% 1.10 outside norms 12.00 15.00 13.10 0.89 innodb insert_key 613.00 -29.01% -137.85 outside norms 269.00 709.00 475.15 102.94 innodb insert_many_fields 4.00 +5.88% 0.25 within norms 3.00 6.00 4.25 0.62 innodb insert_rollback 2.00 -33.33% -0.50 within norms 1.00 2.00 1.50 0.50 innodb insert_select_1_key 4.00 +3.61% 0.15 within norms 3.00 6.00 4.15 0.91 innodb insert_select_2_keys 5.00 +20.00% 1.25 within norms 4.00 11.00 6.25 1.51 innodb min_max 7.00 +7.89% 0.60 within norms 6.00 9.00 7.60 0.86 innodb min_max_on_key 18.00 +10.89% 2.20 within norms 18.00 37.00 20.20 4.15 innodb multiple_value_insert 4.00 +14.89% 0.70 within norms 3.00 6.00 4.70 0.90 innodb once_prepared_select 24.00 -14.56% -3.05 outside norms 18.00 25.00 20.95 2.16 innodb order_by_big 13.00 +9.41% 1.35 within norms 12.00 17.00 14.35 1.42 innodb order_by_big_key 11.00 +16.35% 2.15 outside norms 11.00 16.00 13.15 1.65 innodb order_by_big_key2 11.00 +9.47% 1.15 within norms 11.00 14.00 12.15 1.28 innodb order_by_big_key_desc 12.00 +5.88% 0.75 within norms 11.00 16.00 12.75 1.41 innodb order_by_big_key_diff 11.00 +10.57% 1.30 outside norms 11.00 15.00 12.30 1.23 innodb order_by_big_key_prefix 10.00 +14.89% 1.75 outside norms 10.00 14.00 11.75 1.37 innodb order_by_key2_diff 1.00 +33.33% 0.50 within norms 1.00 2.00 1.50 0.50 innodb order_by_key_prefix 1.00 -17.65% -0.15 within norms 0.00 1.00 0.85 0.36 innodb order_by_range 1.00 -53.85% -0.35 within norms 0.00 1.00 0.65 0.48 innodb outer_join 15.00 +17.13% 3.10 outside norms 15.00 22.00 18.10 2.41 innodb outer_join_found 15.00 +15.73% 2.80 outside norms 15.00 21.00 17.80 2.48 innodb outer_join_not_found 14.00 +12.50% 2.00 outside norms 14.00 19.00 16.00 1.95 innodb outer_join_on_key 11.00 +10.93% 1.35 within norms 11.00 15.00 12.35 1.35 innodb prepared_select 29.00 -3.57% -1.00 within norms 24.00 32.00 28.00 2.76 innodb select_1_row 2.00 +13.04% 0.30 within norms 2.00 3.00 2.30 0.46 innodb select_1_row_cache 2.00 +6.98% 0.15 within norms 2.00 3.00 2.15 0.36 innodb select_2_rows 3.00 -25.00% -0.60 outside norms 2.00 3.00 2.40 0.49 innodb select_big 11.00 +9.47% 1.15 within norms 10.00 14.00 12.15 1.15 innodb select_big_str 1.00 +13.04% 0.15 within norms 1.00 2.00 1.15 0.36 innodb select_cache 65.00 -12.65% -7.30 outside norms 50.00 66.00 57.70 6.36 innodb select_cache2 55.00 +4.35% 2.50 within norms 50.00 66.00 57.50 6.58 innodb select_column+column 2.00 +18.37% 0.45 within norms 2.00 3.00 2.45 0.50 innodb select_diff_key 0.00 +100.00% 0.25 within norms 0.00 1.00 0.25 0.43 innodb select_distinct 4.00 +8.05% 0.35 within norms 3.00 5.00 4.35 0.57 innodb select_group 15.00 +3.85% 0.60 within norms 14.00 18.00 15.60 1.24 innodb select_group_when_MANY_tables 4.00 +11.11% 0.50 within norms 4.00 6.00 4.50 0.59 innodb select_join 0.00 +100.00% 0.50 within norms 0.00 1.00 0.50 0.50 innodb select_key 47.00 +1.16% 0.55 within norms 46.00 54.00 47.55 1.56 innodb select_key2 52.00 +1.79% 0.95 within norms 52.00 63.00 52.95 2.38 innodb select_key2_return_key 50.00 -0.00% 0.00 within norms 49.00 51.00 50.00 0.45 innodb select_key2_return_prim 50.00 +1.67% 0.85 within norms 49.00 57.00 50.85 1.62 innodb select_key_prefix 52.00 +0.38% 0.20 within norms 51.00 57.00 52.20 1.17 innodb select_key_prefix_join 5.00 -9.89% -0.45 within norms 4.00 6.00 4.55 0.74 innodb select_key_return_key 46.00 +1.60% 0.75 within norms 46.00 55.00 46.75 1.95 innodb select_many_fields 11.00 +25.42% 3.75 outside norms 11.00 17.00 14.75 1.84 innodb select_range 47.00 +8.38% 4.30 within norms 45.00 76.00 51.30 6.69 innodb select_range_key2 8.00 -8.84% -0.65 outside norms 7.00 8.00 7.35 0.48 innodb select_range_prefix 7.00 -0.72% -0.05 within norms 6.00 8.00 6.95 0.67 innodb select_simple 1.00 +41.18% 0.70 outside norms 1.00 2.00 1.70 0.46 innodb select_simple_cache 1.00 +20.00% 0.25 within norms 1.00 2.00 1.25 0.43 innodb select_simple_join 1.00 -81.82% -0.45 within norms 0.00 1.00 0.55 0.50 innodb update_autocommit 4.00 -23.08% -0.75 outside norms 3.00 4.00 3.25 0.43 innodb update_big 44.00 -10.69% -4.25 outside norms 36.00 56.00 39.75 4.16 innodb update_commit 1.00 +20.00% 0.25 within norms 1.00 2.00 1.25 0.43 innodb update_of_key 31.00 -13.14% -3.60 within norms 20.00 33.00 27.40 4.64 innodb update_of_key_big 24.00 -5.96% -1.35 within norms 18.00 34.00 22.65 3.34 innodb update_of_primary_key_many_keys 759.00 +1.55% 11.95 within norms 702.00 922.00 770.95 53.73 innodb update_rollback 1.00 +25.93% 0.35 within norms 1.00 2.00 1.35 0.48 innodb update_with_key 98.00 +4.67% 4.80 outside norms 98.00 108.00 102.80 3.08 innodb update_with_key_prefix 36.00 +4.00% 1.50 within norms 34.00 40.00 37.50 1.77 innodb wisc_benchmark 2.00 +14.89% 0.35 within norms 2.00 3.00 2.35 0.48 ========================================================================================================================= TRENDING OVER ALL runs Engine Test Time % Diff from Avg Diff Norm? Min Max Avg STD ========================================================================================================================= innodb alter_table_add 13.00 -6.80% -0.83 within norms 11.00 14.00 12.17 0.87 innodb alter_table_drop 15.00 -31.42% -3.59 outside norms 10.00 14.00 11.41 1.07 innodb connect 2.00 -18.37% -0.31 within norms 1.00 2.00 1.69 0.46 innodb connect+select_1_row 2.00 +14.71% 0.34 within norms 2.00 3.00 2.34 0.48 innodb connect+select_simple 3.00 -52.63% -1.03 outside norms 1.00 2.00 1.97 0.18 innodb count 13.00 +13.33% 2.00 outside norms 13.00 18.00 15.00 1.76 innodb count_distinct 5.00 +17.61% 1.07 outside norms 5.00 8.00 6.07 0.83 innodb count_distinct_2 12.00 +1.14% 0.14 within norms 11.00 16.00 12.14 1.38 innodb count_distinct_big 21.00 +1.62% 0.34 within norms 18.00 25.00 21.34 1.97 innodb count_distinct_group 10.00 +20.98% 2.66 outside norms 11.00 14.00 12.66 0.84 innodb count_distinct_group_on_key 8.00 +10.08% 0.90 within norms 8.00 11.00 8.90 1.12 innodb count_distinct_group_on_key_parts 11.00 +6.45% 0.76 within norms 10.00 15.00 11.76 1.36 innodb count_distinct_key_prefix 5.00 -5.84% -0.28 within norms 4.00 6.00 4.72 0.69 innodb count_group_on_key_parts 10.00 -22.88% -1.86 outside norms 7.00 10.00 8.14 0.78 innodb count_on_key 87.00 -12.63% -9.76 outside norms 73.00 83.00 77.24 2.25 innodb create+drop 31.00 -58.83% -11.48 outside norms 19.00 21.00 19.52 0.56 innodb create_index 2.00 -5.45% -0.10 within norms 1.00 3.00 1.90 0.48 innodb create_key+drop 25.00 -10.86% -2.45 outside norms 21.00 23.00 22.55 0.56 innodb create_MANY_tables 44.00 -157.78% -26.93 outside norms 14.00 20.00 17.07 1.70 innodb create_table 0.00 +100.00% 0.07 within norms 0.00 1.00 0.07 0.25 innodb delete_all_many_keys 274.00 +7.82% 23.24 outside norms 239.00 345.00 297.24 21.38 innodb delete_autocommit 3.00 -6.10% -0.17 within norms 2.00 3.00 2.83 0.38 innodb delete_big 1.00 -262.50% -0.72 outside norms 0.00 1.00 0.28 0.45 innodb delete_big_many_keys 274.00 +7.79% 23.14 outside norms 239.00 345.00 297.14 21.37 innodb delete_commit 1.00 +25.64% 0.34 within norms 1.00 2.00 1.34 0.48 innodb delete_key 3.00 -22.54% -0.55 outside norms 2.00 3.00 2.45 0.50 innodb delete_range 9.00 -29.21% -2.03 outside norms 6.00 8.00 6.97 0.56 innodb delete_rollback 1.00 +23.68% 0.31 within norms 1.00 2.00 1.31 0.46 innodb drop_index 2.00 -1.75% -0.03 within norms 1.00 3.00 1.97 0.32 innodb drop_table 0.00 NULL 0.00 within norms 0.00 0.00 0.00 0.00 innodb drop_table_when_MANY_tables 20.00 -48.34% -6.52 outside norms 12.00 15.00 13.48 0.62 innodb insert 107.00 -17.98% -16.31 outside norms 88.00 93.00 90.69 1.37 innodb insert_autocommit 2.00 +22.67% 0.59 outside norms 2.00 3.00 2.59 0.49 innodb insert_commit 2.00 -81.25% -0.90 outside norms 1.00 2.00 1.10 0.30 innodb insert_duplicates 12.00 +6.45% 0.83 outside norms 12.00 14.00 12.83 0.53 innodb insert_key 613.00 -113.13% -325.38 outside norms 189.00 345.00 287.62 32.94 innodb insert_many_fields 4.00 +1.69% 0.07 within norms 3.00 5.00 4.07 0.36 innodb insert_rollback 2.00 -41.46% -0.59 outside norms 1.00 2.00 1.41 0.49 innodb insert_select_1_key 4.00 -17.17% -0.59 outside norms 3.00 4.00 3.41 0.49 innodb insert_select_2_keys 5.00 +3.33% 0.17 within norms 4.00 6.00 5.17 0.59 innodb min_max 7.00 +8.56% 0.66 within norms 6.00 9.00 7.66 1.03 innodb min_max_on_key 18.00 -6.75% -1.14 within norms 14.00 20.00 16.86 1.28 innodb multiple_value_insert 4.00 +11.45% 0.52 within norms 3.00 5.00 4.52 0.56 innodb once_prepared_select 24.00 -14.47% -3.03 outside norms 20.00 22.00 20.97 0.61 innodb order_by_big 13.00 +8.05% 1.14 outside norms 12.00 15.00 14.14 0.94 innodb order_by_big_key 11.00 +11.39% 1.41 outside norms 11.00 14.00 12.41 1.19 innodb order_by_big_key2 11.00 +4.20% 0.48 within norms 10.00 13.00 11.48 0.97 innodb order_by_big_key_desc 12.00 +6.95% 0.90 within norms 12.00 14.00 12.90 0.92 innodb order_by_big_key_diff 11.00 +5.06% 0.59 within norms 10.00 13.00 11.59 0.85 innodb order_by_big_key_prefix 10.00 +16.43% 1.97 outside norms 11.00 13.00 11.97 0.85 innodb order_by_key2_diff 1.00 +14.71% 0.17 within norms 1.00 2.00 1.17 0.38 innodb order_by_key_prefix 1.00 -61.11% -0.38 within norms 0.00 1.00 0.62 0.49 innodb order_by_range 1.00 -38.10% -0.28 within norms 0.00 1.00 0.72 0.45 innodb outer_join 15.00 +13.52% 2.34 outside norms 15.00 21.00 17.34 2.06 innodb outer_join_found 15.00 +11.04% 1.86 within norms 14.00 21.00 16.86 2.19 innodb outer_join_not_found 14.00 +6.67% 1.00 within norms 13.00 18.00 15.00 1.49 innodb outer_join_on_key 11.00 +8.07% 0.97 within norms 10.00 15.00 11.97 1.50 innodb prepared_select 29.00 -12.13% -3.14 outside norms 22.00 29.00 25.86 2.10 innodb select_1_row 2.00 +18.31% 0.45 within norms 2.00 3.00 2.45 0.50 innodb select_1_row_cache 2.00 +3.33% 0.07 within norms 2.00 3.00 2.07 0.25 innodb select_2_rows 3.00 -35.94% -0.79 outside norms 2.00 3.00 2.21 0.41 innodb select_big 11.00 +5.34% 0.62 within norms 10.00 13.00 11.62 1.00 innodb select_big_str 1.00 +7.11% 0.08 within norms 0.00 2.00 1.08 0.28 innodb select_cache 65.00 -12.87% -7.41 outside norms 51.00 71.00 57.59 5.41 innodb select_cache2 55.00 +3.27% 1.86 within norms 51.00 68.00 56.86 4.88 innodb select_column+column 2.00 +24.68% 0.66 outside norms 2.00 3.00 2.66 0.48 innodb select_diff_key 0.00 +100.00% 0.17 within norms 0.00 1.00 0.17 0.38 innodb select_distinct 4.00 -1.75% -0.07 within norms 3.00 5.00 3.93 0.36 innodb select_group 15.00 +1.36% 0.21 within norms 13.00 18.00 15.21 1.47 innodb select_group_when_MANY_tables 4.00 -0.00% 0.00 within norms 3.00 5.00 4.00 0.37 innodb select_join 0.00 +100.00% 0.48 within norms 0.00 1.00 0.48 0.50 innodb select_key 47.00 -5.58% -2.48 within norms 40.00 50.00 44.52 2.50 innodb select_key2 52.00 -5.53% -2.72 outside norms 46.00 54.00 49.28 2.41 innodb select_key2_return_key 50.00 -6.54% -3.07 outside norms 42.00 51.00 46.93 2.32 innodb select_key2_return_prim 50.00 -3.28% -1.59 within norms 43.00 55.00 48.41 2.92 innodb select_key_prefix 52.00 -2.38% -1.21 within norms 45.00 57.00 50.79 3.46 innodb select_key_prefix_join 5.00 -19.83% -0.83 outside norms 4.00 5.00 4.17 0.38 innodb select_key_return_key 46.00 -5.54% -2.41 within norms 39.00 49.00 43.59 2.65 innodb select_many_fields 11.00 +33.12% 5.45 outside norms 15.00 17.00 16.45 0.62 innodb select_range 47.00 +3.81% 1.86 outside norms 47.00 57.00 48.86 1.66 innodb select_range_key2 8.00 -10.48% -0.76 outside norms 6.00 8.00 7.24 0.57 innodb select_range_prefix 7.00 -0.00% 0.00 within norms 6.00 8.00 7.00 0.64 innodb select_simple 1.00 +30.95% 0.45 within norms 1.00 2.00 1.45 0.50 innodb select_simple_cache 1.00 +12.12% 0.14 within norms 1.00 2.00 1.14 0.34 innodb select_simple_join 1.00 -38.10% -0.28 within norms 0.00 1.00 0.72 0.45 innodb update_autocommit 4.00 -43.21% -1.21 outside norms 2.00 3.00 2.79 0.41 innodb update_big 44.00 -22.11% -7.97 outside norms 31.00 40.00 36.03 2.48 innodb update_commit 1.00 +25.64% 0.34 within norms 1.00 2.00 1.34 0.48 innodb update_of_key 31.00 -60.82% -11.72 outside norms 19.00 20.00 19.28 0.45 innodb update_of_key_big 24.00 -31.07% -5.69 outside norms 16.00 20.00 18.31 1.18 innodb update_of_primary_key_many_keys 759.00 +7.11% 58.07 outside norms 661.00 947.00 817.07 54.24 innodb update_rollback 1.00 +29.27% 0.41 within norms 1.00 2.00 1.41 0.49 innodb update_with_key 98.00 -6.80% -6.24 outside norms 90.00 93.00 91.76 0.97 innodb update_with_key_prefix 36.00 -2.15% -0.76 outside norms 34.00 36.00 35.24 0.57 innodb wisc_benchmark 2.00 +14.71% 0.34 within norms 2.00 3.00 2.34 0.48 ========================================================================================================================= FULL REVISION COMMENTARY: 1543.1.1: patrick crews 2010-05-19 Added drizzledump_restore.test - a basic test of whether or not we can restore a table from drizzledump output. The test dumps a table, alters the original table name (<table_name>_orig), restores from the dump file, then compares the original and restored tables. Also included a minor change to test-run.pl so that we can call the drizzle client to restore from a dump file as well as a partial port of the fix for mysql bug#51057, which was a weakness in include/diff_tables.inc that would cause the test to run until timeout if one of the expected tables did not exist. Had to alter diff_tables.inc to work for this test, but this is the only test using this include file. The altered code is merely commented out for now, to see if we need it _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
