=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 123
RUN DATE: 2009-12-04T18:45:27.736946
SERVER: drizzled
VERSION: staging
REVISION: 1238
COMMENT: 1238: Brian Aker 2009-12-04 [merge] Merge for staging.
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 13.00 -0.00% 0.00
within norms 12.00 14.00 13.00 1.00
innodb alter_table_drop 13.00 -8.33% -1.00
within norms 11.00 13.00 12.00 1.00
innodb connect 1.00 +33.33% 0.50
within norms 1.00 2.00 1.50 0.50
innodb connect+select_1_row 2.00 +20.00% 0.50
within norms 2.00 3.00 2.50 0.50
innodb connect+select_simple 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
innodb count 17.00 -25.93% -3.50
outside norms 13.00 14.00 13.50 0.50
innodb count_distinct 6.00 -9.09% -0.50
within norms 5.00 6.00 5.50 0.50
innodb count_distinct_2 12.00 -4.35% -0.50
within norms 11.00 12.00 11.50 0.50
innodb count_distinct_big 23.00 -21.05% -4.00
outside norms 19.00 19.00 19.00 0.00
innodb count_distinct_group 14.00 -7.69% -1.00
outside norms 13.00 13.00 13.00 0.00
innodb count_distinct_group_on_key 8.00 -0.00% 0.00
within norms 8.00 8.00 8.00 0.00
innodb count_distinct_group_on_key_parts 13.00 -18.18% -2.00
outside norms 11.00 11.00 11.00 0.00
innodb count_distinct_key_prefix 4.00 +11.11% 0.50
within norms 4.00 5.00 4.50 0.50
innodb count_group_on_key_parts 9.00 -12.50% -1.00
outside norms 8.00 8.00 8.00 0.00
innodb count_on_key 75.00 +3.23% 2.50
outside norms 76.00 79.00 77.50 1.50
innodb create+drop 19.00 +5.00% 1.00
outside norms 20.00 20.00 20.00 0.00
innodb create_index 3.00 -50.00% -1.00
outside norms 2.00 2.00 2.00 0.00
innodb create_key+drop 23.00 -2.22% -0.50
within norms 22.00 23.00 22.50 0.50
innodb create_MANY_tables 15.00 +3.23% 0.50
within norms 15.00 16.00 15.50 0.50
innodb create_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb delete_all_many_keys 252.00 +16.42% 49.50
outside norms 286.00 317.00 301.50 15.50
innodb delete_autocommit 2.00 +33.33% 1.00
outside norms 3.00 3.00 3.00 0.00
innodb delete_big 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
innodb delete_big_many_keys 252.00 +16.42% 49.50
outside norms 286.00 317.00 301.50 15.50
innodb delete_commit 2.00 -33.33% -0.50
within norms 1.00 2.00 1.50 0.50
innodb delete_key 3.00 -50.00% -1.00
outside norms 2.00 2.00 2.00 0.00
innodb delete_range 7.00 +6.67% 0.50
within norms 7.00 8.00 7.50 0.50
innodb delete_rollback 1.00 +33.33% 0.50
within norms 1.00 2.00 1.50 0.50
innodb drop_index 2.00 +20.00% 0.50
within norms 2.00 3.00 2.50 0.50
innodb drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb drop_table_when_MANY_tables 13.00 -0.00% 0.00
within norms 13.00 13.00 13.00 0.00
innodb insert 90.00 -0.00% 0.00
within norms 89.00 91.00 90.00 1.00
innodb insert_autocommit 2.00 +20.00% 0.50
within norms 2.00 3.00 2.50 0.50
innodb insert_commit 2.00 -100.00% -1.00
outside norms 1.00 1.00 1.00 0.00
innodb insert_duplicates 13.00 -0.00% 0.00
within norms 13.00 13.00 13.00 0.00
innodb insert_key 218.00 +16.48% 43.00
outside norms 251.00 271.00 261.00 10.00
innodb insert_many_fields 4.00 -0.00% 0.00
within norms 4.00 4.00 4.00 0.00
innodb insert_rollback 2.00 -33.33% -0.50
within norms 1.00 2.00 1.50 0.50
innodb insert_select_1_key 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
innodb insert_select_2_keys 5.00 +9.09% 0.50
within norms 5.00 6.00 5.50 0.50
innodb min_max 7.00 -7.69% -0.50
within norms 6.00 7.00 6.50 0.50
innodb min_max_on_key 17.00 +2.86% 0.50
within norms 16.00 19.00 17.50 1.50
innodb multiple_value_insert 5.00 -0.00% 0.00
within norms 5.00 5.00 5.00 0.00
innodb once_prepared_select 21.00 -0.00% 0.00
within norms 21.00 21.00 21.00 0.00
innodb order_by_big 13.00 +3.70% 0.50
within norms 13.00 14.00 13.50 0.50
innodb order_by_big_key 12.00 -0.00% 0.00
within norms 12.00 12.00 12.00 0.00
innodb order_by_big_key2 10.00 +13.04% 1.50
outside norms 11.00 12.00 11.50 0.50
innodb order_by_big_key_desc 12.00 -0.00% 0.00
within norms 12.00 12.00 12.00 0.00
innodb order_by_big_key_diff 11.00 +4.35% 0.50
within norms 11.00 12.00 11.50 0.50
innodb order_by_big_key_prefix 11.00 -0.00% 0.00
within norms 11.00 11.00 11.00 0.00
innodb order_by_key2_diff 2.00 -33.33% -0.50
within norms 1.00 2.00 1.50 0.50
innodb order_by_key_prefix 0.00 +100.00% 1.00
outside norms 1.00 1.00 1.00 0.00
innodb order_by_range 1.00 -100.00% -0.50
within norms 0.00 1.00 0.50 0.50
innodb outer_join 16.00 +11.11% 2.00
within norms 16.00 20.00 18.00 2.00
innodb outer_join_found 16.00 +11.11% 2.00
within norms 15.00 21.00 18.00 3.00
innodb outer_join_not_found 13.00 +18.75% 3.00
outside norms 14.00 18.00 16.00 2.00
innodb outer_join_on_key 11.00 +15.38% 2.00
within norms 11.00 15.00 13.00 2.00
innodb prepared_select 24.00 +9.43% 2.50
outside norms 25.00 28.00 26.50 1.50
innodb select_1_row 2.00 +20.00% 0.50
within norms 2.00 3.00 2.50 0.50
innodb select_1_row_cache 3.00 -50.00% -1.00
outside norms 2.00 2.00 2.00 0.00
innodb select_2_rows 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
innodb select_big 11.00 -4.76% -0.50
within norms 10.00 11.00 10.50 0.50
innodb select_big_str 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
innodb select_cache 69.00 -25.45% -14.00
outside norms 52.00 58.00 55.00 3.00
innodb select_cache2 69.00 -27.78% -15.00
outside norms 52.00 56.00 54.00 2.00
innodb select_column+column 2.00 +33.33% 1.00
outside norms 3.00 3.00 3.00 0.00
innodb select_diff_key 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb select_distinct 4.00 -0.00% 0.00
within norms 4.00 4.00 4.00 0.00
innodb select_group 17.00 -0.00% 0.00
within norms 17.00 17.00 17.00 0.00
innodb select_group_when_MANY_tables 4.00 -14.29% -0.50
within norms 3.00 4.00 3.50 0.50
innodb select_join 0.00 +100.00% 1.00
outside norms 1.00 1.00 1.00 0.00
innodb select_key 42.00 +4.55% 2.00
within norms 40.00 48.00 44.00 4.00
innodb select_key2 49.00 -1.03% -0.50
within norms 48.00 49.00 48.50 0.50
innodb select_key2_return_key 44.00 +1.12% 0.50
within norms 42.00 47.00 44.50 2.50
innodb select_key2_return_prim 45.00 -0.00% 0.00
within norms 45.00 45.00 45.00 0.00
innodb select_key_prefix 50.00 +3.85% 2.00
within norms 49.00 55.00 52.00 3.00
innodb select_key_prefix_join 4.00 -0.00% 0.00
within norms 4.00 4.00 4.00 0.00
innodb select_key_return_key 44.00 -2.33% -1.00
within norms 41.00 45.00 43.00 2.00
innodb select_many_fields 17.00 -6.25% -1.00
outside norms 16.00 16.00 16.00 0.00
innodb select_range 48.00 +2.04% 1.00
outside norms 49.00 49.00 49.00 0.00
innodb select_range_key2 7.00 -0.00% 0.00
within norms 7.00 7.00 7.00 0.00
innodb select_range_prefix 7.00 -7.69% -0.50
within norms 6.00 7.00 6.50 0.50
innodb select_simple 2.00 -33.33% -0.50
within norms 1.00 2.00 1.50 0.50
innodb select_simple_cache 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
innodb select_simple_join 1.00 -100.00% -0.50
within norms 0.00 1.00 0.50 0.50
innodb update_autocommit 2.00 +20.00% 0.50
within norms 2.00 3.00 2.50 0.50
innodb update_big 37.00 -5.71% -2.00
outside norms 34.00 36.00 35.00 1.00
innodb update_commit 2.00 -33.33% -0.50
within norms 1.00 2.00 1.50 0.50
innodb update_of_key 20.00 -2.56% -0.50
within norms 19.00 20.00 19.50 0.50
innodb update_of_key_big 17.00 +5.56% 1.00
within norms 16.00 20.00 18.00 2.00
innodb update_of_primary_key_many_keys 707.00 +15.48% 129.50
outside norms 799.00 874.00 836.50 37.50
innodb update_rollback 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
innodb update_with_key 91.00 -0.00% 0.00
within norms 90.00 92.00 91.00 1.00
innodb update_with_key_prefix 35.00 -0.00% 0.00
within norms 35.00 35.00 35.00 0.00
innodb wisc_benchmark 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 13.00 -8.33% -1.00
outside norms 11.00 14.00 12.00 0.89
innodb alter_table_drop 13.00 -13.04% -1.50
outside norms 10.00 13.00 11.50 1.02
innodb connect 1.00 +37.50% 0.60
outside norms 1.00 2.00 1.60 0.49
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 2.00 -5.26% -0.10
within norms 1.00 2.00 1.90 0.30
innodb count 17.00 -21.43% -3.00
outside norms 13.00 17.00 14.00 1.41
innodb count_distinct 6.00 +6.25% 0.40
within norms 5.00 8.00 6.40 0.80
innodb count_distinct_2 12.00 +1.64% 0.20
within norms 11.00 15.00 12.20 1.33
innodb count_distinct_big 23.00 -13.30% -2.70
outside norms 18.00 24.00 20.30 1.68
innodb count_distinct_group 14.00 -11.11% -1.40
outside norms 11.00 13.00 12.60 0.80
innodb count_distinct_group_on_key 8.00 +9.09% 0.80
within norms 8.00 11.00 8.80 1.08
innodb count_distinct_group_on_key_parts 13.00 -17.12% -1.90
outside norms 10.00 13.00 11.10 0.94
innodb count_distinct_key_prefix 4.00 +13.04% 0.60
within norms 4.00 6.00 4.60 0.66
innodb count_group_on_key_parts 9.00 -7.14% -0.60
outside norms 8.00 9.00 8.40 0.49
innodb count_on_key 75.00 +2.47% 1.90
outside norms 75.00 79.00 76.90 1.45
innodb create+drop 19.00 +3.06% 0.60
outside norms 19.00 20.00 19.60 0.49
innodb create_index 3.00 -57.89% -1.10
outside norms 1.00 3.00 1.90 0.54
innodb create_key+drop 23.00 -1.32% -0.30
within norms 22.00 23.00 22.70 0.46
innodb create_MANY_tables 15.00 +7.98% 1.30
outside norms 15.00 18.00 16.30 1.27
innodb create_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb delete_all_many_keys 252.00 +14.84% 43.90
outside norms 273.00 340.00 295.90 19.35
innodb delete_autocommit 2.00 +31.03% 0.90
outside norms 2.00 3.00 2.90 0.30
innodb delete_big 1.00 -150.00% -0.60
outside norms 0.00 1.00 0.40 0.49
innodb delete_big_many_keys 252.00 +14.81% 43.80
outside norms 273.00 340.00 295.80 19.35
innodb delete_commit 2.00 -53.85% -0.70
outside norms 1.00 2.00 1.30 0.46
innodb delete_key 3.00 -30.43% -0.70
outside norms 2.00 3.00 2.30 0.46
innodb delete_range 7.00 +1.41% 0.10
within norms 6.00 8.00 7.10 0.83
innodb delete_rollback 1.00 +28.57% 0.40
within norms 1.00 2.00 1.40 0.49
innodb drop_index 2.00 +4.76% 0.10
within norms 2.00 3.00 2.10 0.30
innodb drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb drop_table_when_MANY_tables 13.00 +2.26% 0.30
within norms 13.00 14.00 13.30 0.46
innodb insert 90.00 +0.77% 0.70
within norms 89.00 92.00 90.70 0.90
innodb insert_autocommit 2.00 +28.57% 0.80
outside norms 2.00 3.00 2.80 0.40
innodb insert_commit 2.00 -81.82% -0.90
outside norms 1.00 2.00 1.10 0.30
innodb insert_duplicates 13.00 -1.56% -0.20
within norms 12.00 13.00 12.80 0.40
innodb insert_key 218.00 +21.33% 59.10
outside norms 249.00 316.00 277.10 22.38
innodb insert_many_fields 4.00 -2.56% -0.10
within norms 3.00 4.00 3.90 0.30
innodb insert_rollback 2.00 -66.67% -0.80
outside norms 1.00 2.00 1.20 0.40
innodb insert_select_1_key 3.00 +9.09% 0.30
within norms 3.00 4.00 3.30 0.46
innodb insert_select_2_keys 5.00 +9.09% 0.50
within norms 5.00 6.00 5.50 0.50
innodb min_max 7.00 +1.41% 0.10
within norms 6.00 9.00 7.10 0.94
innodb min_max_on_key 17.00 -3.66% -0.60
within norms 14.00 19.00 16.40 1.28
innodb multiple_value_insert 5.00 -4.17% -0.20
within norms 4.00 5.00 4.80 0.40
innodb once_prepared_select 21.00 +0.94% 0.20
within norms 21.00 22.00 21.20 0.40
innodb order_by_big 13.00 +7.14% 1.00
outside norms 13.00 15.00 14.00 0.89
innodb order_by_big_key 12.00 +4.76% 0.60
within norms 11.00 14.00 12.60 1.20
innodb order_by_big_key2 10.00 +11.50% 1.30
outside norms 10.00 12.00 11.30 0.78
innodb order_by_big_key_desc 12.00 +6.98% 0.90
within norms 12.00 14.00 12.90 0.94
innodb order_by_big_key_diff 11.00 +4.35% 0.50
within norms 10.00 13.00 11.50 0.81
innodb order_by_big_key_prefix 11.00 +8.33% 1.00
outside norms 11.00 13.00 12.00 0.89
innodb order_by_key2_diff 2.00 -81.82% -0.90
outside norms 1.00 2.00 1.10 0.30
innodb order_by_key_prefix 0.00 +100.00% 0.90
outside norms 0.00 1.00 0.90 0.30
innodb order_by_range 1.00 -42.86% -0.30
within norms 0.00 1.00 0.70 0.46
innodb outer_join 16.00 +4.76% 0.80
within norms 15.00 20.00 16.80 1.66
innodb outer_join_found 16.00 +2.44% 0.40
within norms 15.00 21.00 16.40 1.91
innodb outer_join_not_found 13.00 +11.56% 1.70
outside norms 13.00 18.00 14.70 1.49
innodb outer_join_on_key 11.00 +7.56% 0.90
within norms 11.00 15.00 11.90 1.37
innodb prepared_select 24.00 +6.25% 1.60
within norms 23.00 28.00 25.60 1.69
innodb select_1_row 2.00 +25.93% 0.70
outside norms 2.00 3.00 2.70 0.46
innodb select_1_row_cache 3.00 -50.00% -1.00
outside norms 2.00 2.00 2.00 0.00
innodb select_2_rows 2.00 +9.09% 0.20
within norms 2.00 3.00 2.20 0.40
innodb select_big 11.00 +3.51% 0.40
within norms 10.00 13.00 11.40 1.02
innodb select_big_str 1.00 +9.09% 0.10
within norms 1.00 2.00 1.10 0.30
innodb select_cache 69.00 -26.84% -14.60
outside norms 51.00 59.00 54.40 2.76
innodb select_cache2 69.00 -26.37% -14.40
outside norms 51.00 58.00 54.60 2.11
innodb select_column+column 2.00 +25.93% 0.70
outside norms 2.00 3.00 2.70 0.46
innodb select_diff_key 0.00 +100.00% 0.10
within norms 0.00 1.00 0.10 0.30
innodb select_distinct 4.00 +2.44% 0.10
within norms 4.00 5.00 4.10 0.30
innodb select_group 17.00 -11.84% -1.80
outside norms 14.00 17.00 15.20 1.33
innodb select_group_when_MANY_tables 4.00 -0.00% 0.00
within norms 3.00 5.00 4.00 0.45
innodb select_join 0.00 +100.00% 0.60
outside norms 0.00 1.00 0.60 0.49
innodb select_key 42.00 +6.46% 2.90
within norms 40.00 50.00 44.90 2.98
innodb select_key2 49.00 -0.20% -0.10
within norms 46.00 53.00 48.90 2.02
innodb select_key2_return_key 44.00 +6.78% 3.20
outside norms 42.00 51.00 47.20 2.68
innodb select_key2_return_prim 45.00 +6.64% 3.20
outside norms 45.00 55.00 48.20 2.79
innodb select_key_prefix 50.00 +1.38% 0.70
within norms 46.00 56.00 50.70 3.03
innodb select_key_prefix_join 4.00 +2.44% 0.10
within norms 4.00 5.00 4.10 0.30
innodb select_key_return_key 44.00 +2.65% 1.20
within norms 41.00 49.00 45.20 2.71
innodb select_many_fields 17.00 -3.03% -0.50
within norms 15.00 17.00 16.50 0.67
innodb select_range 48.00 +1.84% 0.90
outside norms 48.00 49.00 48.90 0.30
innodb select_range_key2 7.00 +4.11% 0.30
within norms 7.00 8.00 7.30 0.46
innodb select_range_prefix 7.00 -2.94% -0.20
within norms 6.00 8.00 6.80 0.60
innodb select_simple 2.00 -25.00% -0.40
within norms 1.00 2.00 1.60 0.49
innodb select_simple_cache 1.00 +9.09% 0.10
within norms 1.00 2.00 1.10 0.30
innodb select_simple_join 1.00 -66.67% -0.40
within norms 0.00 1.00 0.60 0.49
innodb update_autocommit 2.00 +28.57% 0.80
outside norms 2.00 3.00 2.80 0.40
innodb update_big 37.00 -2.78% -1.00
within norms 34.00 40.00 36.00 2.00
innodb update_commit 2.00 -66.67% -0.80
outside norms 1.00 2.00 1.20 0.40
innodb update_of_key 20.00 -3.09% -0.60
outside norms 19.00 20.00 19.40 0.49
innodb update_of_key_big 17.00 +5.03% 0.90
within norms 16.00 20.00 17.90 1.58
innodb update_of_primary_key_many_keys 707.00 +12.83% 104.10
outside norms 737.00 900.00 811.10 45.93
innodb update_rollback 1.00 +28.57% 0.40
within norms 1.00 2.00 1.40 0.49
innodb update_with_key 91.00 +0.76% 0.70
within norms 90.00 93.00 91.70 1.00
innodb update_with_key_prefix 35.00 +0.57% 0.20
within norms 35.00 36.00 35.20 0.40
innodb wisc_benchmark 2.00 +16.67% 0.40
within norms 2.00 3.00 2.40 0.49
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 13.00 -7.62% -0.92
outside norms 11.00 14.00 12.08 0.84
innodb alter_table_drop 13.00 -15.25% -1.72
outside norms 10.00 13.00 11.28 0.96
innodb connect 1.00 +41.86% 0.72
outside norms 1.00 2.00 1.72 0.45
innodb connect+select_1_row 2.00 +12.28% 0.28
within norms 2.00 3.00 2.28 0.45
innodb connect+select_simple 2.00 -2.04% -0.04
within norms 1.00 2.00 1.96 0.20
innodb count 17.00 -13.64% -2.04
outside norms 13.00 17.00 14.96 1.66
innodb count_distinct 6.00 -0.00% 0.00
within norms 5.00 8.00 6.00 0.85
innodb count_distinct_2 12.00 -0.00% 0.00
within norms 11.00 16.00 12.00 1.30
innodb count_distinct_big 23.00 -7.88% -1.68
within norms 18.00 25.00 21.32 1.95
innodb count_distinct_group 14.00 -10.06% -1.28
outside norms 11.00 14.00 12.72 0.83
innodb count_distinct_group_on_key 8.00 +9.91% 0.88
within norms 8.00 11.00 8.88 1.14
innodb count_distinct_group_on_key_parts 13.00 -10.54% -1.24
within norms 10.00 15.00 11.76 1.36
innodb count_distinct_key_prefix 4.00 +14.53% 0.68
outside norms 4.00 6.00 4.68 0.61
innodb count_group_on_key_parts 9.00 -11.94% -0.96
outside norms 7.00 10.00 8.04 0.72
innodb count_on_key 75.00 +2.75% 2.12
within norms 73.00 83.00 77.12 2.37
innodb create+drop 19.00 +2.26% 0.44
within norms 19.00 21.00 19.44 0.57
innodb create_index 3.00 -56.25% -1.08
outside norms 1.00 3.00 1.92 0.48
innodb create_key+drop 23.00 -2.13% -0.48
within norms 21.00 23.00 22.52 0.57
innodb create_MANY_tables 15.00 +13.99% 2.44
outside norms 15.00 20.00 17.44 1.44
innodb create_table 0.00 +100.00% 0.04
within norms 0.00 1.00 0.04 0.20
innodb delete_all_many_keys 252.00 +16.47% 49.68
outside norms 273.00 345.00 301.68 18.11
innodb delete_autocommit 2.00 +29.58% 0.84
outside norms 2.00 3.00 2.84 0.37
innodb delete_big 1.00 -212.50% -0.68
outside norms 0.00 1.00 0.32 0.47
innodb delete_big_many_keys 252.00 +16.43% 49.56
outside norms 273.00 345.00 301.56 18.12
innodb delete_commit 2.00 -47.06% -0.64
outside norms 1.00 2.00 1.36 0.48
innodb delete_key 3.00 -20.97% -0.52
outside norms 2.00 3.00 2.48 0.50
innodb delete_range 7.00 -0.57% -0.04
within norms 6.00 8.00 6.96 0.60
innodb delete_rollback 1.00 +24.24% 0.32
within norms 1.00 2.00 1.32 0.47
innodb drop_index 2.00 -2.04% -0.04
within norms 1.00 3.00 1.96 0.34
innodb drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb drop_table_when_MANY_tables 13.00 +4.13% 0.56
within norms 13.00 15.00 13.56 0.57
innodb insert 90.00 +0.79% 0.72
within norms 88.00 93.00 90.72 1.28
innodb insert_autocommit 2.00 +23.08% 0.60
outside norms 2.00 3.00 2.60 0.49
innodb insert_commit 2.00 -78.57% -0.88
outside norms 1.00 2.00 1.12 0.32
innodb insert_duplicates 13.00 -1.56% -0.20
within norms 12.00 14.00 12.80 0.57
innodb insert_key 218.00 +26.33% 77.92
outside norms 249.00 345.00 295.92 24.58
innodb insert_many_fields 4.00 +1.96% 0.08
within norms 3.00 5.00 4.08 0.39
innodb insert_rollback 2.00 -42.86% -0.60
outside norms 1.00 2.00 1.40 0.49
innodb insert_select_1_key 3.00 +12.79% 0.44
within norms 3.00 4.00 3.44 0.50
innodb insert_select_2_keys 5.00 +4.58% 0.24
within norms 4.00 6.00 5.24 0.51
innodb min_max 7.00 +7.41% 0.56
within norms 6.00 9.00 7.56 1.02
innodb min_max_on_key 17.00 -0.00% 0.00
within norms 14.00 20.00 17.00 1.30
innodb multiple_value_insert 5.00 -7.76% -0.36
within norms 4.00 5.00 4.64 0.48
innodb once_prepared_select 21.00 -0.00% 0.00
within norms 20.00 22.00 21.00 0.63
innodb order_by_big 13.00 +7.41% 1.04
outside norms 12.00 15.00 14.04 0.96
innodb order_by_big_key 12.00 +3.23% 0.40
within norms 11.00 14.00 12.40 1.13
innodb order_by_big_key2 10.00 +12.89% 1.48
outside norms 10.00 13.00 11.48 0.98
innodb order_by_big_key_desc 12.00 +7.12% 0.92
within norms 12.00 14.00 12.92 0.93
innodb order_by_big_key_diff 11.00 +4.84% 0.56
within norms 10.00 13.00 11.56 0.85
innodb order_by_big_key_prefix 11.00 +8.33% 1.00
outside norms 11.00 13.00 12.00 0.85
innodb order_by_key2_diff 2.00 -66.67% -0.80
outside norms 1.00 2.00 1.20 0.40
innodb order_by_key_prefix 0.00 +100.00% 0.64
outside norms 0.00 1.00 0.64 0.48
innodb order_by_range 1.00 -31.58% -0.24
within norms 0.00 1.00 0.76 0.43
innodb outer_join 16.00 +8.68% 1.52
within norms 15.00 21.00 17.52 2.16
innodb outer_join_found 16.00 +6.32% 1.08
within norms 14.00 21.00 17.08 2.28
innodb outer_join_not_found 13.00 +14.02% 2.12
outside norms 13.00 18.00 15.12 1.56
innodb outer_join_on_key 11.00 +9.24% 1.12
within norms 10.00 15.00 12.12 1.56
innodb prepared_select 24.00 +6.98% 1.80
within norms 22.00 29.00 25.80 2.15
innodb select_1_row 2.00 +19.35% 0.48
within norms 2.00 3.00 2.48 0.50
innodb select_1_row_cache 3.00 -44.23% -0.92
outside norms 2.00 3.00 2.08 0.27
innodb select_2_rows 2.00 +10.71% 0.24
within norms 2.00 3.00 2.24 0.43
innodb select_big 11.00 +5.50% 0.64
within norms 10.00 13.00 11.64 1.02
innodb select_big_str 1.00 +8.24% 0.09
within norms 1.00 2.00 1.09 0.29
innodb select_cache 69.00 -21.31% -12.12
outside norms 51.00 71.00 56.88 5.27
innodb select_cache2 69.00 -21.99% -12.44
outside norms 51.00 68.00 56.56 4.54
innodb select_column+column 2.00 +23.08% 0.60
outside norms 2.00 3.00 2.60 0.49
innodb select_diff_key 0.00 +100.00% 0.16
within norms 0.00 1.00 0.16 0.37
innodb select_distinct 4.00 -2.04% -0.08
within norms 3.00 5.00 3.92 0.39
innodb select_group 17.00 -12.14% -1.84
outside norms 13.00 18.00 15.16 1.46
innodb select_group_when_MANY_tables 4.00 -0.00% 0.00
within norms 3.00 5.00 4.00 0.40
innodb select_join 0.00 +100.00% 0.44
within norms 0.00 1.00 0.44 0.50
innodb select_key 42.00 +5.58% 2.48
within norms 40.00 50.00 44.48 2.67
innodb select_key2 49.00 +0.81% 0.40
within norms 46.00 54.00 49.40 2.56
innodb select_key2_return_key 44.00 +5.90% 2.76
outside norms 42.00 51.00 46.76 2.44
innodb select_key2_return_prim 45.00 +6.48% 3.12
outside norms 43.00 55.00 48.12 2.79
innodb select_key_prefix 50.00 +2.04% 1.04
within norms 45.00 57.00 51.04 3.39
innodb select_key_prefix_join 4.00 +4.76% 0.20
within norms 4.00 5.00 4.20 0.40
innodb select_key_return_key 44.00 -1.01% -0.44
within norms 39.00 49.00 43.56 2.70
innodb select_many_fields 17.00 -3.16% -0.52
within norms 15.00 17.00 16.48 0.64
innodb select_range 48.00 +2.04% 1.00
within norms 48.00 57.00 49.00 1.72
innodb select_range_key2 7.00 +2.78% 0.20
within norms 6.00 8.00 7.20 0.57
innodb select_range_prefix 7.00 -0.00% 0.00
within norms 6.00 8.00 7.00 0.69
innodb select_simple 2.00 -38.89% -0.56
outside norms 1.00 2.00 1.44 0.50
innodb select_simple_cache 1.00 +13.79% 0.16
within norms 1.00 2.00 1.16 0.37
innodb select_simple_join 1.00 -31.58% -0.24
within norms 0.00 1.00 0.76 0.43
innodb update_autocommit 2.00 +27.54% 0.76
outside norms 2.00 3.00 2.76 0.43
innodb update_big 37.00 -1.87% -0.68
within norms 32.00 40.00 36.32 2.38
innodb update_commit 2.00 -47.06% -0.64
outside norms 1.00 2.00 1.36 0.48
innodb update_of_key 20.00 -3.95% -0.76
outside norms 19.00 20.00 19.24 0.43
innodb update_of_key_big 17.00 +7.41% 1.36
outside norms 16.00 20.00 18.36 1.23
innodb update_of_primary_key_many_keys 707.00 +14.62% 121.04
outside norms 737.00 947.00 828.04 46.10
innodb update_rollback 1.00 +28.57% 0.40
within norms 1.00 2.00 1.40 0.49
innodb update_with_key 91.00 +0.91% 0.84
within norms 90.00 93.00 91.84 0.92
innodb update_with_key_prefix 35.00 +0.79% 0.28
within norms 34.00 36.00 35.28 0.53
innodb wisc_benchmark 2.00 +15.25% 0.36
within norms 2.00 3.00 2.36 0.48
=========================================================================================================================
FULL REVISION COMMENTARY:
1237.2.12: Brian Aker 2009-12-04 [merge] Update for build.
1237.8.1: Monty Taylor 2009-12-04 Fixed the util build issue.
1237.2.11: Brian Aker 2009-12-04 [merge] Merge Monty
1237.7.1: Monty Taylor 2009-12-04 Added Makefile-based valgrind run.
1237.2.10: Brian Aker 2009-12-04 [merge] Merging Jay
1143.4.9: Jay Pipes 2009-12-04 Fixes LP Bug#480710.
1143.4.8: Jay Pipes 2009-12-04 This commit fixes issues raised by Joe Da...
1143.4.7: Jay Pipes 2009-12-03 Removes unused ReplicationServices::start...
1143.4.6: Jay Pipes 2009-12-03 Adds test case to transaction log for TRU...
1143.4.5: Jay Pipes 2009-12-02 [merge] Merge trunk
1143.4.4: Jay Pipes 2009-12-01 [merge] Merge trunk
1237.2.9: Brian Aker 2009-12-04 Fixing bad include.
1237.2.8: Brian Aker 2009-12-03 [merge] More dead merge..
1237.6.11: Brian Aker 2009-12-03 Dead functions.
1237.2.7: Brian Aker 2009-12-03 [merge] Merge.
1237.6.10: Brian Aker 2009-12-03 Pass through charsets to remove dead code.
1237.6.9: Brian Aker 2009-12-03 Remove dead code from blob
1237.6.8: Brian Aker 2009-12-03 More dead varstring field code.
1237.6.7: Brian Aker 2009-12-03 More removal of field
1237.6.6: Brian Aker 2009-12-03 More field removal.
1237.6.5: Brian Aker 2009-12-03 Dead Field code.
1237.6.4: Brian Aker 2009-12-03 Remove dead section of Field
1237.6.3: Brian Aker 2009-12-03 Remove dead code.
1237.6.2: Brian Aker 2009-12-03 Minor cleanup for dead code.
1237.6.1: Brian Aker 2009-12-03 Remove dead bits in parser/whitespace/etc.
1237.2.6: Brian Aker 2009-12-03 Fix for bug #492046
1237.2.5: Brian Aker 2009-12-03 [merge] Updating for libz
1237.5.1: Monty Taylor 2009-12-02 Added valgrind suppressions for the li...
1237.2.4: Brian Aker 2009-12-03 [merge] Merge Monty
1228.3.3: Monty Taylor 2009-12-02 [merge] Merged trunk.
1228.3.2: Monty Taylor 2009-12-01 Removed engine_map - just use vector_o...
1228.3.1: Monty Taylor 2009-11-26 Removed NameMap. Also remove the alias...
1237.2.3: Brian Aker 2009-12-03 Tiny cast and remove dead call cleanup.
1237.2.2: Brian Aker 2009-12-02 [merge] Merge for staging.
1237.3.4: Brian Aker 2009-12-02 [merge] Merge
1237.4.1: Brian Aker 2009-12-02 Remove dead handler call.
1237.3.3: Brian Aker 2009-12-02 [merge] Table index up to SE merge.
1235.1.14: Brian Aker 2009-12-02 Final move of index flags up to Engin...
1235.1.13: Brian Aker 2009-12-02 Next pass through interface to move i...
1235.1.12: Brian Aker 2009-12-02 Clean up index interface before movin...
1237.3.2: Brian Aker 2009-12-02 [merge] A number of dead code removal pa...
1235.1.11: Brian Aker 2009-12-02 Small cleanups, did in MERGE table on...
1235.1.10: Brian Aker 2009-12-02 Cleaned up the update call (I noticed...
1235.1.9: Brian Aker 2009-12-02 Remove code around update batch handle...
1235.1.8: Brian Aker 2009-12-02 Dead code removal.
1237.3.1: Brian Aker 2009-12-02 Remove low byte from cursor.
1237.2.1: Brian Aker 2009-12-02 [merge] Merge for Staging.
1237.1.3: Brian Aker 2009-12-02 [merge] Merge Brian
1235.1.7: Brian Aker 2009-12-01 Remove more dead code.
1235.1.6: Brian Aker 2009-12-01 Remove dead code.
1235.1.5: Brian Aker 2009-12-01 Remove dead table_map_iterator.
1237.1.2: Brian Aker 2009-12-02 [merge] Merge Stewart
1235.3.14: Stewart Smith 2009-12-02 my_end() no longer requires an argum...
1235.3.13: Stewart Smith 2009-12-02 remove MY_GIVE_INFO parameter to my_...
1235.3.12: Stewart Smith 2009-12-02 remove final bits of my_end(MY_CHECK...
1235.3.11: Stewart Smith 2009-12-02 remove remaining --debug-check calls...
1235.3.10: Stewart Smith 2009-12-02 remove --debug-check from drizzle
1235.3.9: Stewart Smith 2009-12-02 remove --debug-check from drizzledump
1235.3.8: Stewart Smith 2009-12-02 remove --debug-check from drizzleimport
1235.3.7: Stewart Smith 2009-12-02 remove outdated --compress option fro...
1235.3.6: Stewart Smith 2009-12-02 fix copyright notice in drizzleimport.cc
1235.3.5: Stewart Smith 2009-12-02 remove --debug-check from drizzleslap
1235.3.4: Stewart Smith 2009-12-02 remove outdated --compress option fro...
1235.3.3: Stewart Smith 2009-12-02 Add who modified drizzletest for Driz...
1235.3.2: Stewart Smith 2009-12-02 remove unused --compress option from ...
1235.3.1: Stewart Smith 2009-12-02 remove dead embedded server code from...
1237.1.1: Brian Aker 2009-12-01 [merge] Merge Monty
1228.1.12: Monty Taylor 2009-12-01 [merge] Merged trunk.
1228.2.1: Monty Taylor 2009-11-30 Fixed Solaris. Duh.
1228.1.11: Monty Taylor 2009-11-29 Logging modules.
1228.1.10: Monty Taylor 2009-11-29 Version, length, transaction_log.
1228.1.9: Monty Taylor 2009-11-29 Replication and error messages.
1228.1.8: Monty Taylor 2009-11-29 Made a bunch of smaler plugins dynamic.
1228.1.7: Monty Taylor 2009-11-28 [merge] Merged dynamic crc and md5.
1192.5.6: Monty Taylor 2009-11-11 [merge] Fix crc32 dynamic loading.
1192.8.1: Monty Taylor 2009-11-11 Made crc32 dynamic.
1192.5.5: Monty Taylor 2009-11-11 Made md5 dynamic.
1228.1.6: Monty Taylor 2009-11-28 [merge] Merged making sleep dynamic.
1192.5.4: Monty Taylor 2009-11-11 Made sleep dynamic.
1228.1.5: Monty Taylor 2009-11-28 Merged in some naming things.
1228.1.4: Monty Taylor 2009-11-27 Fixes to valgrind supressions.
1228.1.3: Monty Taylor 2009-11-27 All of the outstanding plugin loader sys...
1228.1.2: Monty Taylor 2009-11-27 Moved STL containers into the PoolOfThre...
1228.1.1: Monty Taylor 2009-11-27 Moved the archive_open_tables list into ...
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
