=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: heap
MACHINE: orisndriz05
RUN ID: 124
RUN DATE: 2009-12-04T19:38:29.400897
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
=========================================================================================================================
heap alter_table_add 12.00 +5.26% 0.67
within norms 12.00 14.00 12.67 0.94
heap alter_table_drop 11.00 +5.71% 0.67
within norms 11.00 13.00 11.67 0.94
heap connect 2.00 -20.00% -0.33
within norms 1.00 2.00 1.67 0.47
heap connect+select_1_row 3.00 -12.50% -0.33
within norms 2.00 3.00 2.67 0.47
heap connect+select_simple 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap count 18.00 -20.00% -3.00
outside norms 13.00 18.00 15.00 2.16
heap count_distinct 6.00 -5.88% -0.33
within norms 5.00 6.00 5.67 0.47
heap count_distinct_2 12.00 -2.86% -0.33
within norms 11.00 12.00 11.67 0.47
heap count_distinct_big 23.00 -13.11% -2.67
outside norms 19.00 23.00 20.33 1.89
heap count_distinct_group 12.00 +5.26% 0.67
outside norms 12.00 13.00 12.67 0.47
heap count_distinct_group_on_key 8.00 -0.00% 0.00
within norms 8.00 8.00 8.00 0.00
heap count_distinct_group_on_key_parts 13.00 -11.43% -1.33
outside norms 11.00 13.00 11.67 0.94
heap count_distinct_key_prefix 4.00 +7.69% 0.33
within norms 4.00 5.00 4.33 0.47
heap count_group_on_key_parts 8.00 -0.00% 0.00
within norms 8.00 8.00 8.00 0.00
heap count_on_key 77.00 +0.43% 0.33
within norms 76.00 79.00 77.33 1.25
heap create+drop 20.00 -0.00% 0.00
within norms 20.00 20.00 20.00 0.00
heap create_index 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap create_key+drop 22.00 +1.49% 0.33
within norms 22.00 23.00 22.33 0.47
heap create_MANY_tables 14.00 +6.67% 1.00
outside norms 14.00 16.00 15.00 0.82
heap create_table 1.00 -200.00% -0.67
outside norms 0.00 1.00 0.33 0.47
heap delete_all_many_keys 276.00 +5.80% 17.00
within norms 276.00 317.00 293.00 17.45
heap delete_autocommit 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
heap delete_big 0.00 +100.00% 0.67
outside norms 0.00 1.00 0.67 0.47
heap delete_big_many_keys 276.00 +5.80% 17.00
within norms 276.00 317.00 293.00 17.45
heap delete_commit 1.00 +25.00% 0.33
within norms 1.00 2.00 1.33 0.47
heap delete_key 3.00 -28.57% -0.67
outside norms 2.00 3.00 2.33 0.47
heap delete_range 7.00 +4.55% 0.33
within norms 7.00 8.00 7.33 0.47
heap delete_rollback 2.00 -20.00% -0.33
within norms 1.00 2.00 1.67 0.47
heap drop_index 2.00 +14.29% 0.33
within norms 2.00 3.00 2.33 0.47
heap drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap drop_table_when_MANY_tables 12.00 +5.26% 0.67
outside norms 12.00 13.00 12.67 0.47
heap insert 91.00 -0.74% -0.67
within norms 89.00 91.00 90.33 0.94
heap insert_autocommit 2.00 +14.29% 0.33
within norms 2.00 3.00 2.33 0.47
heap insert_commit 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
heap insert_duplicates 13.00 -0.00% 0.00
within norms 13.00 13.00 13.00 0.00
heap insert_key 226.00 +9.36% 23.33
outside norms 226.00 271.00 249.33 18.41
heap insert_many_fields 4.00 -0.00% 0.00
within norms 4.00 4.00 4.00 0.00
heap insert_rollback 2.00 -20.00% -0.33
within norms 1.00 2.00 1.67 0.47
heap insert_select_1_key 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
heap insert_select_2_keys 5.00 +6.25% 0.33
within norms 5.00 6.00 5.33 0.47
heap min_max 9.00 -22.73% -1.67
outside norms 6.00 9.00 7.33 1.25
heap min_max_on_key 16.00 +5.88% 1.00
within norms 16.00 19.00 17.00 1.41
heap multiple_value_insert 4.00 +14.29% 0.67
outside norms 4.00 5.00 4.67 0.47
heap once_prepared_select 21.00 -0.00% 0.00
within norms 21.00 21.00 21.00 0.00
heap order_by_big 14.00 -2.44% -0.33
within norms 13.00 14.00 13.67 0.47
heap order_by_big_key 14.00 -10.53% -1.33
outside norms 12.00 14.00 12.67 0.94
heap order_by_big_key2 12.00 -2.86% -0.33
within norms 11.00 12.00 11.67 0.47
heap order_by_big_key_desc 14.00 -10.53% -1.33
outside norms 12.00 14.00 12.67 0.94
heap order_by_big_key_diff 13.00 -8.33% -1.00
outside norms 11.00 13.00 12.00 0.82
heap order_by_big_key_prefix 12.00 -5.88% -0.67
outside norms 11.00 12.00 11.33 0.47
heap order_by_key2_diff 1.00 +25.00% 0.33
within norms 1.00 2.00 1.33 0.47
heap order_by_key_prefix 0.00 +100.00% 0.67
outside norms 0.00 1.00 0.67 0.47
heap order_by_range 1.00 -50.00% -0.33
within norms 0.00 1.00 0.67 0.47
heap outer_join 16.00 +7.69% 1.33
within norms 16.00 20.00 17.33 1.89
heap outer_join_found 15.00 +11.76% 2.00
within norms 15.00 21.00 17.00 2.83
heap outer_join_not_found 14.00 +8.70% 1.33
within norms 14.00 18.00 15.33 1.89
heap outer_join_on_key 11.00 +10.81% 1.33
within norms 11.00 15.00 12.33 1.89
heap prepared_select 25.00 +3.85% 1.00
within norms 25.00 28.00 26.00 1.41
heap select_1_row 2.00 +14.29% 0.33
within norms 2.00 3.00 2.33 0.47
heap select_1_row_cache 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap select_2_rows 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap select_big 12.00 -9.09% -1.00
outside norms 10.00 12.00 11.00 0.82
heap select_cache 58.00 -3.57% -2.00
within norms 52.00 58.00 56.00 2.83
heap select_cache2 52.00 +2.50% 1.33
within norms 52.00 56.00 53.33 1.89
heap select_column+column 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
heap select_diff_key 1.00 -200.00% -0.67
outside norms 0.00 1.00 0.33 0.47
heap select_distinct 4.00 -0.00% 0.00
within norms 4.00 4.00 4.00 0.00
heap select_group 17.00 -0.00% 0.00
within norms 17.00 17.00 17.00 0.00
heap select_group_when_MANY_tables 4.00 -9.09% -0.33
within norms 3.00 4.00 3.67 0.47
heap select_join 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
heap select_key 45.00 -1.50% -0.67
within norms 40.00 48.00 44.33 3.30
heap select_key2 48.00 +0.69% 0.33
within norms 48.00 49.00 48.33 0.47
heap select_key2_return_key 49.00 -6.52% -3.00
outside norms 42.00 49.00 46.00 2.94
heap select_key2_return_prim 49.00 -5.76% -2.67
outside norms 45.00 49.00 46.33 1.89
heap select_key_prefix 54.00 -2.53% -1.33
within norms 49.00 55.00 52.67 2.62
heap select_key_prefix_join 4.00 -0.00% 0.00
within norms 4.00 4.00 4.00 0.00
heap select_key_return_key 45.00 -3.05% -1.33
within norms 41.00 45.00 43.67 1.89
heap select_many_fields 16.00 -0.00% 0.00
within norms 16.00 16.00 16.00 0.00
heap select_range 49.00 -0.00% 0.00
within norms 49.00 49.00 49.00 0.00
heap select_range_key2 8.00 -9.09% -0.67
outside norms 7.00 8.00 7.33 0.47
heap select_range_prefix 7.00 -5.00% -0.33
within norms 6.00 7.00 6.67 0.47
heap select_simple 1.00 +25.00% 0.33
within norms 1.00 2.00 1.33 0.47
heap select_simple_cache 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
heap select_simple_join 0.00 +100.00% 0.33
within norms 0.00 1.00 0.33 0.47
heap update_autocommit 3.00 -12.50% -0.33
within norms 2.00 3.00 2.67 0.47
heap update_big 31.00 +7.92% 2.67
outside norms 31.00 36.00 33.67 2.05
heap update_commit 1.00 +25.00% 0.33
within norms 1.00 2.00 1.33 0.47
heap update_of_key 20.00 -1.69% -0.33
within norms 19.00 20.00 19.67 0.47
heap update_of_key_big 18.00 -0.00% 0.00
within norms 16.00 20.00 18.00 1.63
heap update_of_primary_key_many_keys 777.00 +4.86% 39.67
within norms 777.00 874.00 816.67 41.52
heap update_rollback 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
heap update_with_key 91.00 -0.00% 0.00
within norms 90.00 92.00 91.00 0.82
heap update_with_key_prefix 35.00 -0.00% 0.00
within norms 35.00 35.00 35.00 0.00
heap 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
=========================================================================================================================
heap alter_table_add 12.00 -0.84% -0.10
within norms 11.00 14.00 11.90 0.83
heap alter_table_drop 11.00 +2.65% 0.30
within norms 10.00 13.00 11.30 0.90
heap connect 2.00 -17.65% -0.30
within norms 1.00 2.00 1.70 0.46
heap connect+select_1_row 3.00 -30.43% -0.70
outside norms 2.00 3.00 2.30 0.46
heap connect+select_simple 2.00 -5.26% -0.10
within norms 1.00 2.00 1.90 0.30
heap count 18.00 -24.14% -3.50
outside norms 13.00 18.00 14.50 1.80
heap count_distinct 6.00 +6.25% 0.40
within norms 5.00 8.00 6.40 0.80
heap count_distinct_2 12.00 +2.44% 0.30
within norms 11.00 15.00 12.30 1.27
heap count_distinct_big 23.00 -10.58% -2.20
outside norms 19.00 24.00 20.80 1.66
heap count_distinct_group 12.00 +4.00% 0.50
within norms 11.00 13.00 12.50 0.81
heap count_distinct_group_on_key 8.00 +9.09% 0.80
within norms 8.00 11.00 8.80 1.08
heap count_distinct_group_on_key_parts 13.00 -14.04% -1.60
outside norms 10.00 13.00 11.40 1.02
heap count_distinct_key_prefix 4.00 +13.04% 0.60
within norms 4.00 6.00 4.60 0.66
heap count_group_on_key_parts 8.00 +4.76% 0.40
within norms 8.00 9.00 8.40 0.49
heap count_on_key 77.00 -0.00% 0.00
within norms 75.00 79.00 77.00 1.41
heap create+drop 20.00 -2.04% -0.40
within norms 19.00 20.00 19.60 0.49
heap create_index 2.00 -11.11% -0.20
within norms 1.00 2.00 1.80 0.40
heap create_key+drop 22.00 +3.08% 0.70
outside norms 22.00 23.00 22.70 0.46
heap create_MANY_tables 14.00 +12.50% 2.00
outside norms 14.00 18.00 16.00 1.41
heap create_table 1.00 -900.00% -0.90
outside norms 0.00 1.00 0.10 0.30
heap delete_all_many_keys 276.00 +6.09% 17.90
within norms 273.00 340.00 293.90 20.25
heap delete_autocommit 3.00 -3.45% -0.10
within norms 2.00 3.00 2.90 0.30
heap delete_big 0.00 +100.00% 0.30
within norms 0.00 1.00 0.30 0.46
heap delete_big_many_keys 276.00 +6.09% 17.90
within norms 273.00 340.00 293.90 20.25
heap delete_commit 1.00 +23.08% 0.30
within norms 1.00 2.00 1.30 0.46
heap delete_key 3.00 -30.43% -0.70
outside norms 2.00 3.00 2.30 0.46
heap delete_range 7.00 +2.78% 0.20
within norms 6.00 8.00 7.20 0.75
heap delete_rollback 2.00 -42.86% -0.60
outside norms 1.00 2.00 1.40 0.49
heap drop_index 2.00 +4.76% 0.10
within norms 2.00 3.00 2.10 0.30
heap drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap drop_table_when_MANY_tables 12.00 +9.09% 1.20
outside norms 12.00 14.00 13.20 0.60
heap insert 91.00 -0.22% -0.20
within norms 89.00 92.00 90.80 0.87
heap insert_autocommit 2.00 +25.93% 0.70
outside norms 2.00 3.00 2.70 0.46
heap insert_commit 1.00 +9.09% 0.10
within norms 1.00 2.00 1.10 0.30
heap insert_duplicates 13.00 -1.56% -0.20
within norms 12.00 13.00 12.80 0.40
heap insert_key 226.00 +16.48% 44.60
outside norms 226.00 316.00 270.60 26.47
heap insert_many_fields 4.00 -2.56% -0.10
within norms 3.00 4.00 3.90 0.30
heap insert_rollback 2.00 -53.85% -0.70
outside norms 1.00 2.00 1.30 0.46
heap insert_select_1_key 3.00 +6.25% 0.20
within norms 3.00 4.00 3.20 0.40
heap insert_select_2_keys 5.00 +7.41% 0.40
within norms 5.00 6.00 5.40 0.49
heap min_max 9.00 -23.29% -1.70
outside norms 6.00 9.00 7.30 1.10
heap min_max_on_key 16.00 +2.44% 0.40
within norms 14.00 19.00 16.40 1.28
heap multiple_value_insert 4.00 +14.89% 0.70
outside norms 4.00 5.00 4.70 0.46
heap once_prepared_select 21.00 +0.94% 0.20
within norms 21.00 22.00 21.20 0.40
heap order_by_big 14.00 +0.71% 0.10
within norms 13.00 15.00 14.10 0.83
heap order_by_big_key 14.00 -9.38% -1.20
within norms 11.00 14.00 12.80 1.25
heap order_by_big_key2 12.00 -5.26% -0.60
within norms 10.00 12.00 11.40 0.80
heap order_by_big_key_desc 14.00 -6.87% -0.90
within norms 12.00 14.00 13.10 0.94
heap order_by_big_key_diff 13.00 -10.17% -1.20
outside norms 11.00 13.00 11.80 0.75
heap order_by_big_key_prefix 12.00 +0.83% 0.10
within norms 11.00 13.00 12.10 0.83
heap order_by_key2_diff 1.00 +9.09% 0.10
within norms 1.00 2.00 1.10 0.30
heap order_by_key_prefix 0.00 +100.00% 0.80
outside norms 0.00 1.00 0.80 0.40
heap order_by_range 1.00 -42.86% -0.30
within norms 0.00 1.00 0.70 0.46
heap outer_join 16.00 +4.76% 0.80
within norms 15.00 20.00 16.80 1.66
heap outer_join_found 15.00 +7.98% 1.30
within norms 15.00 21.00 16.30 1.95
heap outer_join_not_found 14.00 +4.76% 0.70
within norms 13.00 18.00 14.70 1.49
heap outer_join_on_key 11.00 +7.56% 0.90
within norms 11.00 15.00 11.90 1.37
heap prepared_select 25.00 +2.34% 0.60
within norms 23.00 28.00 25.60 1.69
heap select_1_row 2.00 +23.08% 0.60
outside norms 2.00 3.00 2.60 0.49
heap select_1_row_cache 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap select_2_rows 2.00 +9.09% 0.20
within norms 2.00 3.00 2.20 0.40
heap select_big 12.00 -3.45% -0.40
within norms 10.00 13.00 11.60 0.92
heap select_cache 58.00 -6.42% -3.50
outside norms 51.00 59.00 54.50 2.87
heap select_cache2 52.00 +4.41% 2.40
outside norms 51.00 58.00 54.40 2.24
heap select_column+column 3.00 -11.11% -0.30
within norms 2.00 3.00 2.70 0.46
heap select_diff_key 1.00 -400.00% -0.80
outside norms 0.00 1.00 0.20 0.40
heap select_distinct 4.00 -0.00% 0.00
within norms 4.00 4.00 4.00 0.00
heap select_group 17.00 -11.84% -1.80
outside norms 14.00 17.00 15.20 1.33
heap select_group_when_MANY_tables 4.00 -0.00% 0.00
within norms 3.00 5.00 4.00 0.45
heap select_join 1.00 -42.86% -0.30
within norms 0.00 1.00 0.70 0.46
heap select_key 45.00 -0.00% 0.00
within norms 40.00 50.00 45.00 2.97
heap select_key2 48.00 +1.64% 0.80
within norms 46.00 53.00 48.80 2.04
heap select_key2_return_key 49.00 -3.81% -1.80
within norms 42.00 51.00 47.20 2.68
heap select_key2_return_prim 49.00 -1.24% -0.60
within norms 45.00 55.00 48.40 2.76
heap select_key_prefix 54.00 -6.93% -3.50
outside norms 46.00 55.00 50.50 2.73
heap select_key_prefix_join 4.00 +2.44% 0.10
within norms 4.00 5.00 4.10 0.30
heap select_key_return_key 45.00 +0.88% 0.40
within norms 41.00 49.00 45.40 2.62
heap select_many_fields 16.00 +2.44% 0.40
within norms 15.00 17.00 16.40 0.66
heap select_range 49.00 -0.20% -0.10
within norms 48.00 49.00 48.90 0.30
heap select_range_key2 8.00 -8.11% -0.60
outside norms 7.00 8.00 7.40 0.49
heap select_range_prefix 7.00 -2.94% -0.20
within norms 6.00 8.00 6.80 0.60
heap select_simple 1.00 +33.33% 0.50
within norms 1.00 2.00 1.50 0.50
heap select_simple_cache 1.00 +9.09% 0.10
within norms 1.00 2.00 1.10 0.30
heap select_simple_join 0.00 +100.00% 0.50
within norms 0.00 1.00 0.50 0.50
heap update_autocommit 3.00 -7.14% -0.20
within norms 2.00 3.00 2.80 0.40
heap update_big 31.00 +12.43% 4.40
outside norms 31.00 40.00 35.40 2.46
heap update_commit 1.00 +16.67% 0.20
within norms 1.00 2.00 1.20 0.40
heap update_of_key 20.00 -3.09% -0.60
outside norms 19.00 20.00 19.40 0.49
heap update_of_key_big 18.00 -0.00% 0.00
within norms 16.00 20.00 18.00 1.55
heap update_of_primary_key_many_keys 777.00 +3.60% 29.00
within norms 737.00 900.00 806.00 46.60
heap update_rollback 1.00 +28.57% 0.40
within norms 1.00 2.00 1.40 0.49
heap update_with_key 91.00 +0.55% 0.50
within norms 90.00 93.00 91.50 0.92
heap update_with_key_prefix 35.00 +0.57% 0.20
within norms 35.00 36.00 35.20 0.40
heap 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
=========================================================================================================================
heap alter_table_add 12.00 +0.64% 0.08
within norms 11.00 14.00 12.08 0.83
heap alter_table_drop 11.00 +2.39% 0.27
within norms 10.00 13.00 11.27 0.94
heap connect 2.00 -15.56% -0.27
within norms 1.00 2.00 1.73 0.44
heap connect+select_1_row 3.00 -30.00% -0.69
outside norms 2.00 3.00 2.31 0.46
heap connect+select_simple 2.00 -1.96% -0.04
within norms 1.00 2.00 1.96 0.19
heap count 18.00 -19.39% -2.92
outside norms 13.00 18.00 15.08 1.73
heap count_distinct 6.00 -0.00% 0.00
within norms 5.00 8.00 6.00 0.83
heap count_distinct_2 12.00 -0.00% 0.00
within norms 11.00 16.00 12.00 1.27
heap count_distinct_big 23.00 -7.55% -1.62
within norms 18.00 25.00 21.38 1.94
heap count_distinct_group 12.00 +5.45% 0.69
within norms 11.00 14.00 12.69 0.82
heap count_distinct_group_on_key 8.00 +9.57% 0.85
within norms 8.00 11.00 8.85 1.13
heap count_distinct_group_on_key_parts 13.00 -10.10% -1.19
within norms 10.00 15.00 11.81 1.36
heap count_distinct_key_prefix 4.00 +14.05% 0.65
outside norms 4.00 6.00 4.65 0.62
heap count_group_on_key_parts 8.00 +0.48% 0.04
within norms 7.00 10.00 8.04 0.71
heap count_on_key 77.00 +0.15% 0.12
within norms 73.00 83.00 77.12 2.33
heap create+drop 20.00 -2.77% -0.54
within norms 19.00 21.00 19.46 0.57
heap create_index 2.00 -4.00% -0.08
within norms 1.00 3.00 1.92 0.47
heap create_key+drop 22.00 +2.22% 0.50
within norms 21.00 23.00 22.50 0.57
heap create_MANY_tables 14.00 +19.11% 3.31
outside norms 14.00 20.00 17.31 1.56
heap create_table 1.00 -1200.00% -0.92
outside norms 0.00 1.00 0.08 0.27
heap delete_all_many_keys 276.00 +8.21% 24.69
outside norms 273.00 345.00 300.69 18.43
heap delete_autocommit 3.00 -5.41% -0.15
within norms 2.00 3.00 2.85 0.36
heap delete_big 0.00 +100.00% 0.31
within norms 0.00 1.00 0.31 0.46
heap delete_big_many_keys 276.00 +8.18% 24.58
outside norms 273.00 345.00 300.58 18.44
heap delete_commit 1.00 +25.71% 0.35
within norms 1.00 2.00 1.35 0.48
heap delete_key 3.00 -20.00% -0.50
within norms 2.00 3.00 2.50 0.50
heap delete_range 7.00 -0.55% -0.04
within norms 6.00 8.00 6.96 0.59
heap delete_rollback 2.00 -48.57% -0.65
outside norms 1.00 2.00 1.35 0.48
heap drop_index 2.00 -1.96% -0.04
within norms 1.00 3.00 1.96 0.34
heap drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap drop_table_when_MANY_tables 12.00 +11.11% 1.50
outside norms 12.00 15.00 13.50 0.64
heap insert 91.00 -0.30% -0.27
within norms 88.00 93.00 90.73 1.26
heap insert_autocommit 2.00 +22.39% 0.58
outside norms 2.00 3.00 2.58 0.49
heap insert_commit 1.00 +10.34% 0.12
within norms 1.00 2.00 1.12 0.32
heap insert_duplicates 13.00 -1.50% -0.19
within norms 12.00 14.00 12.81 0.56
heap insert_key 226.00 +22.93% 67.23
outside norms 226.00 345.00 293.23 27.60
heap insert_many_fields 4.00 +1.89% 0.08
within norms 3.00 5.00 4.08 0.38
heap insert_rollback 2.00 -40.54% -0.58
outside norms 1.00 2.00 1.42 0.49
heap insert_select_1_key 3.00 +12.36% 0.42
within norms 3.00 4.00 3.42 0.49
heap insert_select_2_keys 5.00 +4.41% 0.23
within norms 4.00 6.00 5.23 0.50
heap min_max 9.00 -18.18% -1.38
outside norms 6.00 9.00 7.62 1.04
heap min_max_on_key 16.00 +5.67% 0.96
within norms 14.00 20.00 16.96 1.29
heap multiple_value_insert 4.00 +13.33% 0.62
outside norms 4.00 5.00 4.62 0.49
heap once_prepared_select 21.00 -0.00% 0.00
within norms 20.00 22.00 21.00 0.62
heap order_by_big 14.00 +0.27% 0.04
within norms 12.00 15.00 14.04 0.94
heap order_by_big_key 14.00 -12.35% -1.54
outside norms 11.00 14.00 12.46 1.15
heap order_by_big_key2 12.00 -4.35% -0.50
within norms 10.00 13.00 11.50 0.97
heap order_by_big_key_desc 14.00 -8.01% -1.04
outside norms 12.00 14.00 12.96 0.94
heap order_by_big_key_diff 13.00 -11.92% -1.38
outside norms 10.00 13.00 11.62 0.88
heap order_by_big_key_prefix 12.00 -0.00% 0.00
within norms 11.00 13.00 12.00 0.83
heap order_by_key2_diff 1.00 +16.13% 0.19
within norms 1.00 2.00 1.19 0.39
heap order_by_key_prefix 0.00 +100.00% 0.62
outside norms 0.00 1.00 0.62 0.49
heap order_by_range 1.00 -30.00% -0.23
within norms 0.00 1.00 0.77 0.42
heap outer_join 16.00 +8.37% 1.46
within norms 15.00 21.00 17.46 2.13
heap outer_join_found 15.00 +11.76% 2.00
within norms 14.00 21.00 17.00 2.27
heap outer_join_not_found 14.00 +7.14% 1.08
within norms 13.00 18.00 15.08 1.54
heap outer_join_on_key 11.00 +8.92% 1.08
within norms 10.00 15.00 12.08 1.54
heap prepared_select 25.00 +2.99% 0.77
within norms 22.00 29.00 25.77 2.12
heap select_1_row 2.00 +18.75% 0.46
within norms 2.00 3.00 2.46 0.50
heap select_1_row_cache 2.00 +3.70% 0.08
within norms 2.00 3.00 2.08 0.27
heap select_2_rows 2.00 +10.34% 0.23
within norms 2.00 3.00 2.23 0.42
heap select_big 12.00 -2.97% -0.35
within norms 10.00 13.00 11.65 1.00
heap select_cache 58.00 -1.89% -1.08
within norms 51.00 71.00 56.92 5.17
heap select_cache2 52.00 +7.78% 4.38
within norms 51.00 68.00 56.38 4.53
heap select_column+column 3.00 -14.71% -0.38
within norms 2.00 3.00 2.62 0.49
heap select_diff_key 1.00 -420.00% -0.81
outside norms 0.00 1.00 0.19 0.39
heap select_distinct 4.00 -1.96% -0.08
within norms 3.00 5.00 3.92 0.38
heap select_group 17.00 -11.62% -1.77
outside norms 13.00 18.00 15.23 1.48
heap select_group_when_MANY_tables 4.00 -0.00% 0.00
within norms 3.00 5.00 4.00 0.39
heap select_join 1.00 -116.67% -0.54
outside norms 0.00 1.00 0.46 0.50
heap select_key 45.00 -1.12% -0.50
within norms 40.00 50.00 44.50 2.62
heap select_key2 48.00 +2.73% 1.35
within norms 46.00 54.00 49.35 2.53
heap select_key2_return_key 49.00 -4.60% -2.15
within norms 42.00 51.00 46.85 2.43
heap select_key2_return_prim 49.00 -1.76% -0.85
within norms 43.00 55.00 48.15 2.74
heap select_key_prefix 54.00 -5.56% -2.85
within norms 45.00 57.00 51.15 3.37
heap select_key_prefix_join 4.00 +4.59% 0.19
within norms 4.00 5.00 4.19 0.39
heap select_key_return_key 45.00 -3.17% -1.38
within norms 39.00 49.00 43.62 2.66
heap select_many_fields 16.00 +2.80% 0.46
within norms 15.00 17.00 16.46 0.63
heap select_range 49.00 -0.00% 0.00
within norms 48.00 57.00 49.00 1.69
heap select_range_key2 8.00 -10.64% -0.77
outside norms 6.00 8.00 7.23 0.58
heap select_range_prefix 7.00 -0.00% 0.00
within norms 6.00 8.00 7.00 0.68
heap select_simple 1.00 +29.73% 0.42
within norms 1.00 2.00 1.42 0.49
heap select_simple_cache 1.00 +13.33% 0.15
within norms 1.00 2.00 1.15 0.36
heap select_simple_join 0.00 +100.00% 0.73
outside norms 0.00 1.00 0.73 0.44
heap update_autocommit 3.00 -8.33% -0.23
within norms 2.00 3.00 2.77 0.42
heap update_big 31.00 +14.16% 5.12
outside norms 31.00 40.00 36.12 2.55
heap update_commit 1.00 +25.71% 0.35
within norms 1.00 2.00 1.35 0.48
heap update_of_key 20.00 -3.79% -0.73
outside norms 19.00 20.00 19.27 0.44
heap update_of_key_big 18.00 +1.89% 0.35
within norms 16.00 20.00 18.35 1.21
heap update_of_primary_key_many_keys 777.00 +5.94% 49.08
outside norms 737.00 947.00 826.08 46.26
heap update_rollback 1.00 +27.78% 0.38
within norms 1.00 2.00 1.38 0.49
heap update_with_key 91.00 +0.88% 0.81
within norms 90.00 93.00 91.81 0.92
heap update_with_key_prefix 35.00 +0.76% 0.27
within norms 34.00 36.00 35.27 0.52
heap wisc_benchmark 2.00 +14.75% 0.35
within norms 2.00 3.00 2.35 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
