=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: heap
MACHINE: orisndriz05
RUN ID: 116
RUN DATE: 2009-12-02T12:57:22.834593
SERVER: drizzled
VERSION: staging
REVISION: 1238
COMMENT: 1238: Brian Aker 2009-12-02 [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 11.00 +5.71% 0.67
outside norms 11.00 12.00 11.67 0.47
heap alter_table_drop 11.00 -0.00% 0.00
within norms 11.00 11.00 11.00 0.00
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 -28.57% -0.67
outside norms 2.00 3.00 2.33 0.47
heap connect+select_simple 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap count 16.00 -14.29% -2.00
outside norms 13.00 16.00 14.00 1.41
heap count_distinct 7.00 -10.53% -0.67
outside norms 6.00 7.00 6.33 0.47
heap count_distinct_2 15.00 -12.50% -1.67
within norms 11.00 15.00 13.33 1.70
heap count_distinct_big 24.00 -10.77% -2.33
outside norms 20.00 24.00 21.67 1.70
heap count_distinct_group 13.00 -5.41% -0.67
within norms 11.00 13.00 12.33 0.94
heap count_distinct_group_on_key 11.00 -6.45% -0.67
outside norms 10.00 11.00 10.33 0.47
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 6.00 -28.57% -1.33
outside norms 4.00 6.00 4.67 0.94
heap count_group_on_key_parts 9.00 -0.00% 0.00
within norms 9.00 9.00 9.00 0.00
heap count_on_key 75.00 +2.60% 2.00
outside norms 75.00 78.00 77.00 1.41
heap create+drop 19.00 +1.72% 0.33
within norms 19.00 20.00 19.33 0.47
heap create_index 2.00 -20.00% -0.33
within norms 1.00 2.00 1.67 0.47
heap create_key+drop 23.00 -0.00% 0.00
within norms 23.00 23.00 23.00 0.00
heap create_MANY_tables 15.00 +8.16% 1.33
outside norms 15.00 18.00 16.33 1.25
heap create_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap delete_all_many_keys 273.00 +8.80% 26.33
within norms 273.00 340.00 299.33 29.17
heap delete_autocommit 3.00 -12.50% -0.33
within norms 2.00 3.00 2.67 0.47
heap delete_big 0.00 +100.00% 0.33
within norms 0.00 1.00 0.33 0.47
heap delete_big_many_keys 273.00 +8.80% 26.33
within norms 273.00 340.00 299.33 29.17
heap delete_commit 2.00 -20.00% -0.33
within norms 1.00 2.00 1.67 0.47
heap delete_key 2.00 +14.29% 0.33
within norms 2.00 3.00 2.33 0.47
heap delete_range 7.00 -0.00% 0.00
within norms 6.00 8.00 7.00 0.82
heap delete_rollback 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
heap drop_index 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap drop_table_when_MANY_tables 13.00 +2.50% 0.33
within norms 13.00 14.00 13.33 0.47
heap insert 92.00 -1.10% -1.00
outside norms 90.00 92.00 91.00 0.82
heap insert_autocommit 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
heap insert_commit 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
heap insert_duplicates 12.00 +2.70% 0.33
within norms 12.00 13.00 12.33 0.47
heap insert_key 249.00 +10.97% 30.67
outside norms 249.00 316.00 279.67 27.64
heap insert_many_fields 4.00 -0.00% 0.00
within norms 4.00 4.00 4.00 0.00
heap insert_rollback 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
heap insert_select_1_key 3.00 +10.00% 0.33
within norms 3.00 4.00 3.33 0.47
heap insert_select_2_keys 5.00 +6.25% 0.33
within norms 5.00 6.00 5.33 0.47
heap min_max 8.00 -14.29% -1.00
outside norms 6.00 8.00 7.00 0.82
heap min_max_on_key 17.00 -8.51% -1.33
outside norms 14.00 17.00 15.67 1.25
heap multiple_value_insert 5.00 -0.00% 0.00
within norms 5.00 5.00 5.00 0.00
heap once_prepared_select 22.00 -3.13% -0.67
outside norms 21.00 22.00 21.33 0.47
heap order_by_big 15.00 -0.00% 0.00
within norms 15.00 15.00 15.00 0.00
heap order_by_big_key 14.00 -7.69% -1.00
within norms 11.00 14.00 13.00 1.41
heap order_by_big_key2 12.00 -5.88% -0.67
within norms 10.00 12.00 11.33 0.94
heap order_by_big_key_desc 14.00 -5.00% -0.67
within norms 12.00 14.00 13.33 0.94
heap order_by_big_key_diff 12.00 -2.86% -0.33
within norms 11.00 12.00 11.67 0.47
heap order_by_big_key_prefix 13.00 -2.63% -0.33
within norms 12.00 13.00 12.67 0.47
heap order_by_key2_diff 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
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 -0.00% 0.00
within norms 16.00 16.00 16.00 0.00
heap outer_join_found 16.00 -2.13% -0.33
within norms 15.00 16.00 15.67 0.47
heap outer_join_not_found 14.00 -0.00% 0.00
within norms 14.00 14.00 14.00 0.00
heap outer_join_on_key 11.00 +5.71% 0.67
outside norms 11.00 12.00 11.67 0.47
heap prepared_select 24.00 +4.00% 1.00
within norms 23.00 28.00 25.00 2.16
heap select_1_row 2.00 +25.00% 0.67
outside norms 2.00 3.00 2.67 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 3.00 -28.57% -0.67
outside norms 2.00 3.00 2.33 0.47
heap select_big 12.00 -0.00% 0.00
within norms 11.00 13.00 12.00 0.82
heap select_cache 51.00 +3.16% 1.67
outside norms 51.00 54.00 52.67 1.25
heap select_cache2 57.00 -1.79% -1.00
within norms 53.00 58.00 56.00 2.16
heap select_column+column 2.00 +25.00% 0.67
outside norms 2.00 3.00 2.67 0.47
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 16.00 -6.67% -1.00
outside norms 14.00 16.00 15.00 0.82
heap select_group_when_MANY_tables 4.00 -0.00% 0.00
within norms 4.00 4.00 4.00 0.00
heap select_join 1.00 -50.00% -0.33
within norms 0.00 1.00 0.67 0.47
heap select_key 44.00 +2.94% 1.33
within norms 42.00 50.00 45.33 3.40
heap select_key2 46.00 +4.83% 2.33
outside norms 46.00 50.00 48.33 1.70
heap select_key2_return_key 49.00 -4.26% -2.00
within norms 44.00 49.00 47.00 2.16
heap select_key2_return_prim 48.00 +1.37% 0.67
within norms 48.00 50.00 48.67 0.94
heap select_key_prefix 52.00 -1.96% -1.00
outside norms 50.00 52.00 51.00 0.82
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 49.00 -6.52% -3.00
outside norms 43.00 49.00 46.00 2.45
heap select_many_fields 17.00 -0.00% 0.00
within norms 17.00 17.00 17.00 0.00
heap select_range 48.00 +1.37% 0.67
outside norms 48.00 49.00 48.67 0.47
heap select_range_key2 8.00 -9.09% -0.67
outside norms 7.00 8.00 7.33 0.47
heap select_range_prefix 6.00 +10.00% 0.67
within norms 6.00 8.00 6.67 0.94
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.67
outside norms 0.00 1.00 0.67 0.47
heap update_autocommit 3.00 -12.50% -0.33
within norms 2.00 3.00 2.67 0.47
heap update_big 35.00 +0.94% 0.33
within norms 35.00 36.00 35.33 0.47
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 -3.45% -0.67
outside norms 19.00 20.00 19.33 0.47
heap update_of_key_big 17.00 +5.56% 1.00
within norms 17.00 20.00 18.00 1.41
heap update_of_primary_key_many_keys 737.00 +8.18% 65.67
within norms 737.00 900.00 802.67 70.21
heap update_rollback 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap update_with_key 93.00 -1.45% -1.33
outside norms 91.00 93.00 91.67 0.94
heap update_with_key_prefix 35.00 +0.94% 0.33
within norms 35.00 36.00 35.33 0.47
heap wisc_benchmark 2.00 +14.29% 0.33
within norms 2.00 3.00 2.33 0.47
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
heap alter_table_add 11.00 +8.33% 1.00
outside norms 11.00 14.00 12.00 0.89
heap alter_table_drop 11.00 +3.51% 0.40
within norms 10.00 13.00 11.40 1.11
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 16.00 -9.59% -1.40
within norms 13.00 17.00 14.60 1.62
heap count_distinct 7.00 -7.69% -0.50
within norms 5.00 8.00 6.50 0.92
heap count_distinct_2 15.00 -20.00% -2.50
outside norms 11.00 16.00 12.50 1.75
heap count_distinct_big 24.00 -11.11% -2.40
outside norms 18.00 25.00 21.60 2.11
heap count_distinct_group 13.00 -1.56% -0.20
within norms 11.00 14.00 12.80 0.98
heap count_distinct_group_on_key 11.00 -17.02% -1.60
outside norms 8.00 11.00 9.40 1.02
heap count_distinct_group_on_key_parts 13.00 -12.07% -1.40
outside norms 10.00 14.00 11.60 1.36
heap count_distinct_key_prefix 6.00 -25.00% -1.20
outside norms 4.00 6.00 4.80 0.75
heap count_group_on_key_parts 9.00 -8.43% -0.70
outside norms 8.00 9.00 8.30 0.46
heap count_on_key 75.00 +2.60% 2.00
outside norms 75.00 79.00 77.00 1.18
heap create+drop 19.00 +3.55% 0.70
outside norms 19.00 21.00 19.70 0.64
heap create_index 2.00 -0.00% 0.00
within norms 1.00 3.00 2.00 0.63
heap create_key+drop 23.00 -1.32% -0.30
within norms 22.00 23.00 22.70 0.46
heap create_MANY_tables 15.00 +12.79% 2.20
outside norms 15.00 19.00 17.20 1.33
heap create_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap delete_all_many_keys 273.00 +7.46% 22.00
outside norms 273.00 340.00 295.00 18.08
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.20
within norms 0.00 1.00 0.20 0.40
heap delete_big_many_keys 273.00 +7.39% 21.80
outside norms 273.00 340.00 294.80 18.02
heap delete_commit 2.00 -53.85% -0.70
outside norms 1.00 2.00 1.30 0.46
heap delete_key 2.00 +16.67% 0.40
within norms 2.00 3.00 2.40 0.49
heap delete_range 7.00 +1.41% 0.10
within norms 6.00 8.00 7.10 0.70
heap delete_rollback 1.00 +23.08% 0.30
within norms 1.00 2.00 1.30 0.46
heap drop_index 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap drop_table_when_MANY_tables 13.00 +5.11% 0.70
outside norms 13.00 15.00 13.70 0.64
heap insert 92.00 -1.32% -1.20
within norms 88.00 92.00 90.80 1.25
heap insert_autocommit 3.00 -7.14% -0.20
within norms 2.00 3.00 2.80 0.40
heap insert_commit 1.00 +16.67% 0.20
within norms 1.00 2.00 1.20 0.40
heap insert_duplicates 12.00 +5.51% 0.70
outside norms 12.00 13.00 12.70 0.46
heap insert_key 249.00 +13.48% 38.80
outside norms 249.00 316.00 287.80 21.68
heap insert_many_fields 4.00 -0.00% 0.00
within norms 3.00 5.00 4.00 0.45
heap insert_rollback 1.00 +16.67% 0.20
within norms 1.00 2.00 1.20 0.40
heap insert_select_1_key 3.00 +14.29% 0.50
within norms 3.00 4.00 3.50 0.50
heap insert_select_2_keys 5.00 +7.41% 0.40
within norms 5.00 6.00 5.40 0.49
heap min_max 8.00 -6.67% -0.50
within norms 6.00 9.00 7.50 1.02
heap min_max_on_key 17.00 -3.03% -0.50
within norms 14.00 18.00 16.50 1.20
heap multiple_value_insert 5.00 -4.17% -0.20
within norms 4.00 5.00 4.80 0.40
heap once_prepared_select 22.00 -3.77% -0.80
outside norms 20.00 22.00 21.20 0.60
heap order_by_big 15.00 -4.90% -0.70
within norms 13.00 15.00 14.30 0.90
heap order_by_big_key 14.00 -13.82% -1.70
outside norms 11.00 14.00 12.30 1.27
heap order_by_big_key2 12.00 -5.26% -0.60
within norms 10.00 13.00 11.40 0.92
heap order_by_big_key_desc 14.00 -8.53% -1.10
outside norms 12.00 14.00 12.90 0.94
heap order_by_big_key_diff 12.00 -4.35% -0.50
within norms 10.00 13.00 11.50 0.92
heap order_by_big_key_prefix 13.00 -7.44% -0.90
outside 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 +6.43% 1.10
within norms 15.00 20.00 17.10 1.92
heap outer_join_found 16.00 +5.88% 1.00
within norms 15.00 21.00 17.00 2.05
heap outer_join_not_found 14.00 +6.04% 0.90
within norms 13.00 17.00 14.90 1.45
heap outer_join_on_key 11.00 +9.09% 1.10
within norms 11.00 15.00 12.10 1.37
heap prepared_select 24.00 +8.05% 2.10
outside norms 23.00 29.00 26.10 2.07
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 3.00 -36.36% -0.80
outside norms 2.00 3.00 2.20 0.40
heap select_big 12.00 -4.35% -0.50
within norms 10.00 13.00 11.50 0.92
heap select_cache 51.00 +7.61% 4.20
outside norms 51.00 62.00 55.20 3.34
heap select_cache2 57.00 +1.89% 1.10
within norms 53.00 68.00 58.10 5.03
heap select_column+column 2.00 +25.93% 0.70
outside norms 2.00 3.00 2.70 0.46
heap select_diff_key 1.00 -900.00% -0.90
outside norms 0.00 1.00 0.10 0.30
heap select_distinct 4.00 +2.44% 0.10
within norms 4.00 5.00 4.10 0.30
heap select_group 16.00 -5.96% -0.90
within norms 14.00 17.00 15.10 1.22
heap select_group_when_MANY_tables 4.00 -0.00% 0.00
within norms 4.00 4.00 4.00 0.00
heap select_join 1.00 -100.00% -0.50
within norms 0.00 1.00 0.50 0.50
heap select_key 44.00 +1.57% 0.70
within norms 42.00 50.00 44.70 2.19
heap select_key2 46.00 +6.31% 3.10
outside norms 46.00 54.00 49.10 2.39
heap select_key2_return_key 49.00 -3.16% -1.50
within norms 44.00 51.00 47.50 1.91
heap select_key2_return_prim 48.00 +0.62% 0.30
within norms 46.00 52.00 48.30 1.73
heap select_key_prefix 52.00 -1.96% -1.00
within norms 45.00 56.00 51.00 3.82
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 49.00 -10.61% -4.70
outside norms 41.00 49.00 44.30 2.57
heap select_many_fields 17.00 -2.41% -0.40
within norms 15.00 17.00 16.60 0.66
heap select_range 48.00 +1.44% 0.70
outside norms 48.00 49.00 48.70 0.46
heap select_range_key2 8.00 -9.59% -0.70
outside norms 7.00 8.00 7.30 0.46
heap select_range_prefix 6.00 +14.29% 1.00
outside norms 6.00 8.00 7.00 0.63
heap select_simple 1.00 +37.50% 0.60
outside norms 1.00 2.00 1.60 0.49
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.80
outside norms 0.00 1.00 0.80 0.40
heap update_autocommit 3.00 -3.45% -0.10
within norms 2.00 3.00 2.90 0.30
heap update_big 35.00 +2.78% 1.00
within norms 34.00 40.00 36.00 2.00
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 -4.17% -0.80
outside norms 19.00 20.00 19.20 0.40
heap update_of_key_big 17.00 +7.10% 1.30
within norms 16.00 20.00 18.30 1.35
heap update_of_primary_key_many_keys 737.00 +8.53% 68.70
outside norms 737.00 900.00 805.70 41.20
heap update_rollback 2.00 -33.33% -0.50
within norms 1.00 2.00 1.50 0.50
heap update_with_key 93.00 -1.09% -1.00
outside norms 91.00 93.00 92.00 0.89
heap update_with_key_prefix 35.00 +1.41% 0.50
within norms 35.00 36.00 35.50 0.50
heap wisc_benchmark 2.00 +23.08% 0.60
outside norms 2.00 3.00 2.60 0.49
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
heap alter_table_add 11.00 +8.68% 1.05
outside norms 11.00 14.00 12.05 0.77
heap alter_table_drop 11.00 +2.02% 0.23
within norms 10.00 13.00 11.23 0.95
heap connect 2.00 -15.79% -0.27
within norms 1.00 2.00 1.73 0.45
heap connect+select_1_row 3.00 -32.00% -0.73
outside norms 2.00 3.00 2.27 0.45
heap connect+select_simple 2.00 -2.33% -0.05
within norms 1.00 2.00 1.95 0.21
heap count 16.00 -6.02% -0.91
within norms 13.00 17.00 15.09 1.70
heap count_distinct 7.00 -16.67% -1.00
outside norms 5.00 8.00 6.00 0.85
heap count_distinct_2 15.00 -25.00% -3.00
outside norms 11.00 16.00 12.00 1.35
heap count_distinct_big 24.00 -11.16% -2.41
outside norms 18.00 25.00 21.59 1.92
heap count_distinct_group 13.00 -2.51% -0.32
within norms 11.00 14.00 12.68 0.87
heap count_distinct_group_on_key 11.00 -22.22% -2.00
outside norms 8.00 11.00 9.00 1.17
heap count_distinct_group_on_key_parts 13.00 -9.16% -1.09
within norms 10.00 15.00 11.91 1.38
heap count_distinct_key_prefix 6.00 -28.16% -1.32
outside norms 4.00 6.00 4.68 0.63
heap count_group_on_key_parts 9.00 -12.50% -1.00
outside norms 7.00 10.00 8.00 0.74
heap count_on_key 75.00 +2.83% 2.18
within norms 73.00 83.00 77.18 2.44
heap create+drop 19.00 +2.11% 0.41
within norms 19.00 21.00 19.41 0.58
heap create_index 2.00 -4.76% -0.09
within norms 1.00 3.00 1.91 0.51
heap create_key+drop 23.00 -2.22% -0.50
within norms 21.00 23.00 22.50 0.58
heap create_MANY_tables 15.00 +15.38% 2.73
outside norms 15.00 20.00 17.73 1.29
heap create_table 0.00 +100.00% 0.05
within norms 0.00 1.00 0.05 0.21
heap delete_all_many_keys 273.00 +9.51% 28.68
outside norms 273.00 345.00 301.68 18.73
heap delete_autocommit 3.00 -6.45% -0.18
within norms 2.00 3.00 2.82 0.39
heap delete_big 0.00 +100.00% 0.27
within norms 0.00 1.00 0.27 0.45
heap delete_big_many_keys 273.00 +9.47% 28.55
outside norms 273.00 345.00 301.55 18.75
heap delete_commit 2.00 -46.67% -0.64
outside norms 1.00 2.00 1.36 0.48
heap delete_key 2.00 +21.43% 0.55
outside norms 2.00 3.00 2.55 0.50
heap delete_range 7.00 -0.65% -0.05
within norms 6.00 8.00 6.95 0.56
heap delete_rollback 1.00 +24.14% 0.32
within norms 1.00 2.00 1.32 0.47
heap drop_index 2.00 -4.76% -0.09
within norms 1.00 2.00 1.91 0.29
heap drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap drop_table_when_MANY_tables 13.00 +4.67% 0.64
outside norms 13.00 15.00 13.64 0.57
heap insert 92.00 -1.35% -1.23
within norms 88.00 93.00 90.77 1.31
heap insert_autocommit 3.00 -13.79% -0.36
within norms 2.00 3.00 2.64 0.48
heap insert_commit 1.00 +8.33% 0.09
within norms 1.00 2.00 1.09 0.29
heap insert_duplicates 12.00 +6.05% 0.77
outside norms 12.00 14.00 12.77 0.60
heap insert_key 249.00 +17.13% 51.45
outside norms 249.00 345.00 300.45 22.48
heap insert_many_fields 4.00 +2.22% 0.09
within norms 3.00 5.00 4.09 0.42
heap insert_rollback 1.00 +26.67% 0.36
within norms 1.00 2.00 1.36 0.48
heap insert_select_1_key 3.00 +14.29% 0.50
within norms 3.00 4.00 3.50 0.50
heap insert_select_2_keys 5.00 +3.51% 0.18
within norms 4.00 6.00 5.18 0.49
heap min_max 8.00 -5.39% -0.41
within norms 6.00 9.00 7.59 0.98
heap min_max_on_key 17.00 -0.27% -0.05
within norms 14.00 20.00 16.95 1.30
heap multiple_value_insert 5.00 -7.84% -0.36
within norms 4.00 5.00 4.64 0.48
heap once_prepared_select 22.00 -4.76% -1.00
outside norms 20.00 22.00 21.00 0.67
heap order_by_big 15.00 -6.11% -0.86
within norms 12.00 15.00 14.14 0.97
heap order_by_big_key 14.00 -13.24% -1.64
outside norms 11.00 14.00 12.36 1.15
heap order_by_big_key2 12.00 -3.94% -0.45
within norms 10.00 13.00 11.55 0.99
heap order_by_big_key_desc 14.00 -8.07% -1.05
outside norms 12.00 14.00 12.95 0.93
heap order_by_big_key_diff 12.00 -3.53% -0.41
within norms 10.00 13.00 11.59 0.89
heap order_by_big_key_prefix 13.00 -7.92% -0.95
outside norms 11.00 13.00 12.05 0.82
heap order_by_key2_diff 1.00 +15.38% 0.18
within norms 1.00 2.00 1.18 0.39
heap order_by_key_prefix 0.00 +100.00% 0.59
outside norms 0.00 1.00 0.59 0.49
heap order_by_range 1.00 -29.41% -0.23
within norms 0.00 1.00 0.77 0.42
heap outer_join 16.00 +8.57% 1.50
within norms 15.00 21.00 17.50 2.21
heap outer_join_found 16.00 +6.38% 1.09
within norms 14.00 21.00 17.09 2.19
heap outer_join_not_found 14.00 +6.95% 1.05
within norms 13.00 17.00 15.05 1.52
heap outer_join_on_key 11.00 +9.02% 1.09
within norms 10.00 15.00 12.09 1.50
heap prepared_select 24.00 +7.04% 1.82
within norms 22.00 29.00 25.82 2.21
heap select_1_row 2.00 +20.00% 0.50
within norms 2.00 3.00 2.50 0.50
heap select_1_row_cache 2.00 +4.35% 0.09
within norms 2.00 3.00 2.09 0.29
heap select_2_rows 3.00 -34.69% -0.77
outside norms 2.00 3.00 2.23 0.42
heap select_big 12.00 -2.72% -0.32
within norms 10.00 13.00 11.68 0.97
heap select_cache 51.00 +10.88% 6.23
outside norms 51.00 71.00 57.23 5.44
heap select_cache2 57.00 +0.08% 0.05
within norms 51.00 68.00 57.05 4.56
heap select_column+column 2.00 +22.81% 0.59
outside norms 2.00 3.00 2.59 0.49
heap select_diff_key 1.00 -450.00% -0.82
outside norms 0.00 1.00 0.18 0.39
heap select_distinct 4.00 -2.33% -0.09
within norms 3.00 5.00 3.91 0.42
heap select_group 16.00 -6.34% -0.95
within norms 13.00 18.00 15.05 1.43
heap select_group_when_MANY_tables 4.00 -0.00% 0.00
within norms 3.00 5.00 4.00 0.30
heap select_join 1.00 -175.00% -0.64
outside norms 0.00 1.00 0.36 0.48
heap select_key 44.00 +0.82% 0.36
within norms 40.00 50.00 44.36 2.46
heap select_key2 46.00 +6.73% 3.32
outside norms 46.00 54.00 49.32 2.60
heap select_key2_return_key 49.00 -4.66% -2.18
within norms 43.00 51.00 46.82 2.29
heap select_key2_return_prim 48.00 +0.19% 0.09
within norms 43.00 53.00 48.09 2.41
heap select_key_prefix 52.00 -1.87% -0.95
within norms 45.00 57.00 51.05 3.46
heap select_key_prefix_join 4.00 +5.38% 0.23
within norms 4.00 5.00 4.23 0.42
heap select_key_return_key 49.00 -13.00% -5.64
outside norms 39.00 49.00 43.36 2.55
heap select_many_fields 17.00 -3.03% -0.50
within norms 15.00 17.00 16.50 0.66
heap select_range 48.00 +2.04% 1.00
within norms 48.00 57.00 49.00 1.83
heap select_range_key2 8.00 -11.39% -0.82
outside norms 6.00 8.00 7.18 0.57
heap select_range_prefix 6.00 +14.84% 1.05
outside norms 6.00 8.00 7.05 0.71
heap select_simple 1.00 +31.25% 0.45
within norms 1.00 2.00 1.45 0.50
heap select_simple_cache 1.00 +12.00% 0.14
within norms 1.00 2.00 1.14 0.34
heap select_simple_join 0.00 +100.00% 0.82
outside norms 0.00 1.00 0.82 0.39
heap update_autocommit 3.00 -8.20% -0.23
within norms 2.00 3.00 2.77 0.42
heap update_big 35.00 +3.63% 1.32
within norms 32.00 40.00 36.32 2.42
heap update_commit 1.00 +26.67% 0.36
within norms 1.00 2.00 1.36 0.48
heap update_of_key 20.00 -4.27% -0.82
outside norms 19.00 20.00 19.18 0.39
heap update_of_key_big 17.00 +7.88% 1.45
outside norms 16.00 20.00 18.45 1.12
heap update_of_primary_key_many_keys 737.00 +10.92% 90.32
outside norms 737.00 947.00 827.32 47.75
heap update_rollback 2.00 -37.50% -0.55
outside norms 1.00 2.00 1.45 0.50
heap update_with_key 93.00 -1.14% -1.05
outside norms 91.00 93.00 91.95 0.88
heap update_with_key_prefix 35.00 +0.90% 0.32
within norms 34.00 36.00 35.32 0.55
heap wisc_benchmark 2.00 +16.98% 0.41
within norms 2.00 3.00 2.41 0.49
=========================================================================================================================
FULL REVISION COMMENTARY:
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
