=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 111
RUN DATE: 2009-12-01T16:45:19.297919
SERVER: drizzled
VERSION: staging
REVISION: 1236
COMMENT: 1236: Brian Aker 2009-12-01 [merge] Merge Brian + Monty. This has the
HEAP -...
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 14.00 -21.74% -2.50
outside norms 11.00 12.00 11.50 0.50
innodb alter_table_drop 13.00 -23.81% -2.50
outside norms 10.00 11.00 10.50 0.50
innodb connect 2.00 -33.33% -0.50
within norms 1.00 2.00 1.50 0.50
innodb connect+select_1_row 3.00 -50.00% -1.00
outside norms 2.00 2.00 2.00 0.00
innodb connect+select_simple 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
innodb count 13.00 +13.33% 2.00
within norms 13.00 17.00 15.00 2.00
innodb count_distinct 6.00 +20.00% 1.50
outside norms 7.00 8.00 7.50 0.50
innodb count_distinct_2 12.00 -0.00% 0.00
within norms 12.00 12.00 12.00 0.00
innodb count_distinct_big 20.00 +2.44% 0.50
within norms 19.00 22.00 20.50 1.50
innodb count_distinct_group 11.00 +8.33% 1.00
within norms 11.00 13.00 12.00 1.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 10.00 12.00 11.00 1.00
innodb count_distinct_key_prefix 5.00 -0.00% 0.00
within norms 5.00 5.00 5.00 0.00
innodb count_group_on_key_parts 10.00 -25.00% -2.00
outside norms 8.00 8.00 8.00 0.00
innodb count_on_key 77.00 -0.65% -0.50
within norms 76.00 77.00 76.50 0.50
innodb create+drop 20.00 -2.56% -0.50
within norms 19.00 20.00 19.50 0.50
innodb create_index 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
innodb create_key+drop 22.00 +2.22% 0.50
within norms 22.00 23.00 22.50 0.50
innodb create_MANY_tables 17.00 +5.56% 1.00
outside norms 18.00 18.00 18.00 0.00
innodb create_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb delete_all_many_keys 306.00 -4.26% -12.50
outside norms 289.00 298.00 293.50 4.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 NULL -1.00
outside norms 0.00 0.00 0.00 0.00
innodb delete_big_many_keys 305.00 -3.92% -11.50
outside norms 289.00 298.00 293.50 4.50
innodb delete_commit 2.00 -100.00% -1.00
outside norms 1.00 1.00 1.00 0.00
innodb delete_key 2.00 +20.00% 0.50
within norms 2.00 3.00 2.50 0.50
innodb delete_range 6.00 +20.00% 1.50
outside norms 7.00 8.00 7.50 0.50
innodb delete_rollback 1.00 +50.00% 1.00
outside norms 2.00 2.00 2.00 0.00
innodb drop_index 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
innodb drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb drop_table_when_MANY_tables 14.00 -0.00% 0.00
within norms 14.00 14.00 14.00 0.00
innodb insert 92.00 -1.10% -1.00
within norms 90.00 92.00 91.00 1.00
innodb insert_autocommit 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
innodb insert_commit 1.00 -0.00% 0.00
within 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 307.00 -2.33% -7.00
outside norms 296.00 304.00 300.00 4.00
innodb insert_many_fields 4.00 -0.00% 0.00
within norms 4.00 4.00 4.00 0.00
innodb insert_rollback 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
innodb insert_select_1_key 4.00 -14.29% -0.50
within norms 3.00 4.00 3.50 0.50
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 +6.67% 0.50
within norms 7.00 8.00 7.50 0.50
innodb min_max_on_key 15.00 +11.76% 2.00
outside norms 17.00 17.00 17.00 0.00
innodb multiple_value_insert 4.00 +11.11% 0.50
within norms 4.00 5.00 4.50 0.50
innodb once_prepared_select 21.00 +2.33% 0.50
within norms 21.00 22.00 21.50 0.50
innodb order_by_big 15.00 -11.11% -1.50
outside norms 13.00 14.00 13.50 0.50
innodb order_by_big_key 11.00 +15.38% 2.00
outside norms 12.00 14.00 13.00 1.00
innodb order_by_big_key2 11.00 +8.33% 1.00
outside norms 12.00 12.00 12.00 0.00
innodb order_by_big_key_desc 13.00 -0.00% 0.00
within norms 12.00 14.00 13.00 1.00
innodb order_by_big_key_diff 12.00 -0.00% 0.00
within norms 11.00 13.00 12.00 1.00
innodb order_by_big_key_prefix 11.00 +12.00% 1.50
outside norms 12.00 13.00 12.50 0.50
innodb order_by_key2_diff 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
innodb order_by_key_prefix 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
innodb order_by_range 0.00 +100.00% 1.00
outside norms 1.00 1.00 1.00 0.00
innodb outer_join 16.00 -3.23% -0.50
within norms 15.00 16.00 15.50 0.50
innodb outer_join_found 15.00 +3.23% 0.50
within norms 15.00 16.00 15.50 0.50
innodb outer_join_not_found 14.00 -3.70% -0.50
within norms 13.00 14.00 13.50 0.50
innodb outer_join_on_key 11.00 -0.00% 0.00
within norms 11.00 11.00 11.00 0.00
innodb prepared_select 30.00 -15.38% -4.00
outside norms 25.00 27.00 26.00 1.00
innodb select_1_row 2.00 +33.33% 1.00
outside norms 3.00 3.00 3.00 0.00
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 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
innodb select_big 11.00 +4.35% 0.50
within norms 11.00 12.00 11.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 57.00 -6.54% -3.50
outside norms 51.00 56.00 53.50 2.50
innodb select_cache2 51.00 +7.27% 4.00
outside norms 54.00 56.00 55.00 1.00
innodb select_column+column 3.00 -20.00% -0.50
within norms 2.00 3.00 2.50 0.50
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 16.00 -14.29% -2.00
outside norms 14.00 14.00 14.00 0.00
innodb select_group_when_MANY_tables 5.00 -25.00% -1.00
outside norms 4.00 4.00 4.00 0.00
innodb select_join 1.00 -100.00% -0.50
within norms 0.00 1.00 0.50 0.50
innodb select_key 45.00 -3.45% -1.50
within norms 42.00 45.00 43.50 1.50
innodb select_key2 49.00 +1.01% 0.50
within norms 48.00 51.00 49.50 1.50
innodb select_key2_return_key 45.00 +2.17% 1.00
within norms 45.00 47.00 46.00 1.00
innodb select_key2_return_prim 46.00 +5.15% 2.50
outside norms 47.00 50.00 48.50 1.50
innodb select_key_prefix 57.00 -16.33% -8.00
outside norms 46.00 52.00 49.00 3.00
innodb select_key_prefix_join 4.00 +11.11% 0.50
within norms 4.00 5.00 4.50 0.50
innodb select_key_return_key 48.00 -7.87% -3.50
outside norms 42.00 47.00 44.50 2.50
innodb select_many_fields 17.00 -3.03% -0.50
within norms 16.00 17.00 16.50 0.50
innodb select_range 48.00 +2.04% 1.00
outside norms 49.00 49.00 49.00 0.00
innodb select_range_key2 8.00 -6.67% -0.50
within norms 7.00 8.00 7.50 0.50
innodb select_range_prefix 7.00 -0.00% 0.00
within norms 7.00 7.00 7.00 0.00
innodb select_simple 1.00 +50.00% 1.00
outside norms 2.00 2.00 2.00 0.00
innodb select_simple_cache 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
innodb select_simple_join 0.00 +100.00% 0.50
within norms 0.00 1.00 0.50 0.50
innodb update_autocommit 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
innodb update_big 34.00 -0.00% 0.00
within norms 34.00 34.00 34.00 0.00
innodb update_commit 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
innodb update_of_key 20.00 -5.26% -1.00
outside norms 19.00 19.00 19.00 0.00
innodb update_of_key_big 18.00 +7.69% 1.50
outside norms 19.00 20.00 19.50 0.50
innodb update_of_primary_key_many_keys 848.00 -6.47% -51.50
outside norms 787.00 806.00 796.50 9.50
innodb update_rollback 2.00 -100.00% -1.00
outside norms 1.00 1.00 1.00 0.00
innodb update_with_key 93.00 -0.54% -0.50
within norms 92.00 93.00 92.50 0.50
innodb update_with_key_prefix 36.00 -1.41% -0.50
within norms 35.00 36.00 35.50 0.50
innodb wisc_benchmark 2.00 +33.33% 1.00
outside norms 3.00 3.00 3.00 0.00
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 14.00 -15.70% -1.90
outside norms 11.00 14.00 12.10 0.83
innodb alter_table_drop 13.00 -14.04% -1.60
outside norms 10.00 13.00 11.40 1.36
innodb connect 2.00 -17.65% -0.30
within norms 1.00 2.00 1.70 0.46
innodb connect+select_1_row 3.00 -30.43% -0.70
outside norms 2.00 3.00 2.30 0.46
innodb connect+select_simple 2.00 -5.26% -0.10
within norms 1.00 2.00 1.90 0.30
innodb count 13.00 +13.33% 2.00
outside norms 13.00 17.00 15.00 1.67
innodb count_distinct 6.00 +4.76% 0.30
within norms 5.00 8.00 6.30 1.00
innodb count_distinct_2 12.00 -0.00% 0.00
within norms 11.00 16.00 12.00 1.41
innodb count_distinct_big 20.00 +6.98% 1.50
within norms 18.00 25.00 21.50 2.11
innodb count_distinct_group 11.00 +15.38% 2.00
outside norms 11.00 14.00 13.00 0.77
innodb count_distinct_group_on_key 8.00 +11.11% 1.00
within norms 8.00 11.00 9.00 1.10
innodb count_distinct_group_on_key_parts 13.00 -7.44% -0.90
within norms 10.00 15.00 12.10 1.64
innodb count_distinct_key_prefix 5.00 -4.17% -0.20
within norms 4.00 6.00 4.80 0.60
innodb count_group_on_key_parts 10.00 -26.58% -2.10
outside norms 7.00 8.00 7.90 0.30
innodb count_on_key 77.00 +1.41% 1.10
within norms 76.00 83.00 78.10 2.21
innodb create+drop 20.00 -2.04% -0.40
within norms 19.00 21.00 19.60 0.66
innodb create_index 2.00 +4.76% 0.10
within norms 1.00 3.00 2.10 0.54
innodb create_key+drop 22.00 +3.08% 0.70
outside norms 22.00 23.00 22.70 0.46
innodb create_MANY_tables 17.00 +2.30% 0.40
within norms 15.00 19.00 17.40 1.02
innodb create_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb delete_all_many_keys 306.00 -3.94% -11.60
outside norms 273.00 306.00 294.40 9.25
innodb delete_autocommit 2.00 +33.33% 1.00
outside norms 3.00 3.00 3.00 0.00
innodb delete_big 1.00 -400.00% -0.80
outside norms 0.00 1.00 0.20 0.40
innodb delete_big_many_keys 305.00 -3.71% -10.90
outside norms 273.00 306.00 294.10 9.07
innodb delete_commit 2.00 -66.67% -0.80
outside norms 1.00 2.00 1.20 0.40
innodb delete_key 2.00 +20.00% 0.50
within norms 2.00 3.00 2.50 0.50
innodb delete_range 6.00 +14.29% 1.00
outside norms 6.00 8.00 7.00 0.63
innodb delete_rollback 1.00 +28.57% 0.40
within norms 1.00 2.00 1.40 0.49
innodb drop_index 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
innodb drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb drop_table_when_MANY_tables 14.00 -1.45% -0.20
within norms 13.00 15.00 13.80 0.60
innodb insert 92.00 -1.66% -1.50
outside norms 88.00 92.00 90.50 1.28
innodb insert_autocommit 3.00 -15.38% -0.40
within norms 2.00 3.00 2.60 0.49
innodb insert_commit 1.00 +16.67% 0.20
within norms 1.00 2.00 1.20 0.40
innodb insert_duplicates 13.00 -2.36% -0.30
within norms 12.00 13.00 12.70 0.46
innodb insert_key 307.00 -4.78% -14.00
within norms 253.00 313.00 293.00 14.89
innodb insert_many_fields 4.00 -0.00% 0.00
within norms 3.00 5.00 4.00 0.45
innodb insert_rollback 1.00 +28.57% 0.40
within norms 1.00 2.00 1.40 0.49
innodb insert_select_1_key 4.00 -14.29% -0.50
within norms 3.00 4.00 3.50 0.50
innodb insert_select_2_keys 5.00 +5.66% 0.30
within norms 4.00 6.00 5.30 0.64
innodb min_max 7.00 +9.09% 0.70
within norms 6.00 9.00 7.70 1.10
innodb min_max_on_key 15.00 +12.28% 2.10
outside norms 15.00 18.00 17.10 0.94
innodb multiple_value_insert 4.00 +14.89% 0.70
outside norms 4.00 5.00 4.70 0.46
innodb once_prepared_select 21.00 +0.94% 0.20
within norms 20.00 22.00 21.20 0.60
innodb order_by_big 15.00 -6.38% -0.90
within norms 13.00 15.00 14.10 0.94
innodb order_by_big_key 11.00 +9.84% 1.20
outside norms 11.00 14.00 12.20 1.17
innodb order_by_big_key2 11.00 +5.98% 0.70
within norms 10.00 13.00 11.70 0.90
innodb order_by_big_key_desc 13.00 -0.00% 0.00
within norms 12.00 14.00 13.00 0.89
innodb order_by_big_key_diff 12.00 -4.35% -0.50
within norms 10.00 13.00 11.50 1.12
innodb order_by_big_key_prefix 11.00 +7.56% 0.90
outside norms 11.00 13.00 11.90 0.83
innodb order_by_key2_diff 1.00 +23.08% 0.30
within norms 1.00 2.00 1.30 0.46
innodb order_by_key_prefix 1.00 -42.86% -0.30
within norms 0.00 1.00 0.70 0.46
innodb order_by_range 0.00 +100.00% 0.70
outside norms 0.00 1.00 0.70 0.46
innodb outer_join 16.00 +8.05% 1.40
within norms 15.00 20.00 17.40 2.15
innodb outer_join_found 15.00 +13.79% 2.40
outside norms 15.00 21.00 17.40 2.20
innodb outer_join_not_found 14.00 +7.28% 1.10
within norms 13.00 17.00 15.10 1.64
innodb outer_join_on_key 11.00 +9.84% 1.20
within norms 11.00 15.00 12.20 1.54
innodb prepared_select 30.00 -14.50% -3.80
outside norms 23.00 29.00 26.20 1.99
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 2.00 -0.00% 0.00
within 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 +5.17% 0.60
within norms 10.00 13.00 11.60 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 57.00 +2.56% 1.50
within norms 51.00 71.00 58.50 5.32
innodb select_cache2 51.00 +13.71% 8.10
outside norms 54.00 68.00 59.10 4.99
innodb select_column+column 3.00 -20.00% -0.50
within norms 2.00 3.00 2.50 0.50
innodb select_diff_key 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb select_distinct 4.00 +2.44% 0.10
within norms 4.00 5.00 4.10 0.30
innodb select_group 16.00 -6.67% -1.00
within norms 13.00 17.00 15.00 1.48
innodb select_group_when_MANY_tables 5.00 -21.95% -0.90
outside norms 4.00 5.00 4.10 0.30
innodb select_join 1.00 -150.00% -0.60
outside norms 0.00 1.00 0.40 0.49
innodb select_key 45.00 -0.22% -0.10
within norms 42.00 49.00 44.90 1.87
innodb select_key2 49.00 +2.00% 1.00
within norms 46.00 54.00 50.00 2.86
innodb select_key2_return_key 45.00 +3.64% 1.70
within norms 43.00 51.00 46.70 2.37
innodb select_key2_return_prim 46.00 +4.56% 2.20
within norms 44.00 52.00 48.20 2.36
innodb select_key_prefix 57.00 -10.47% -5.40
outside norms 45.00 57.00 51.60 4.41
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 48.00 -9.59% -4.20
outside norms 41.00 47.00 43.80 2.23
innodb select_many_fields 17.00 -3.66% -0.60
within norms 15.00 17.00 16.40 0.66
innodb select_range 48.00 +3.03% 1.50
within norms 48.00 57.00 49.50 2.54
innodb select_range_key2 8.00 -9.59% -0.70
outside norms 7.00 8.00 7.30 0.46
innodb select_range_prefix 7.00 +4.11% 0.30
within norms 7.00 8.00 7.30 0.46
innodb select_simple 1.00 +37.50% 0.60
outside 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 0.00 +100.00% 0.90
outside norms 0.00 1.00 0.90 0.30
innodb update_autocommit 3.00 -3.45% -0.10
within norms 2.00 3.00 2.90 0.30
innodb update_big 34.00 +6.85% 2.50
outside norms 34.00 40.00 36.50 2.29
innodb update_commit 1.00 +16.67% 0.20
within norms 1.00 2.00 1.20 0.40
innodb update_of_key 20.00 -4.17% -0.80
outside norms 19.00 20.00 19.20 0.40
innodb update_of_key_big 18.00 +2.17% 0.40
within norms 16.00 20.00 18.40 1.28
innodb update_of_primary_key_many_keys 848.00 -4.60% -37.30
outside norms 782.00 842.00 810.70 18.19
innodb update_rollback 2.00 -53.85% -0.70
outside norms 1.00 2.00 1.30 0.46
innodb update_with_key 93.00 -1.09% -1.00
outside norms 91.00 93.00 92.00 0.89
innodb update_with_key_prefix 36.00 -1.41% -0.50
within norms 35.00 36.00 35.50 0.50
innodb wisc_benchmark 2.00 +25.93% 0.70
outside norms 2.00 3.00 2.70 0.46
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 14.00 -15.65% -1.89
outside norms 11.00 14.00 12.11 0.79
innodb alter_table_drop 13.00 -15.42% -1.74
outside norms 10.00 13.00 11.26 1.02
innodb connect 2.00 -15.15% -0.26
within norms 1.00 2.00 1.74 0.44
innodb connect+select_1_row 3.00 -32.56% -0.74
outside norms 2.00 3.00 2.26 0.44
innodb connect+select_simple 2.00 -2.70% -0.05
within norms 1.00 2.00 1.95 0.22
innodb count 13.00 +14.83% 2.26
outside norms 13.00 17.00 15.26 1.68
innodb count_distinct 6.00 -0.88% -0.05
within norms 5.00 8.00 5.95 0.89
innodb count_distinct_2 12.00 -1.79% -0.21
within norms 11.00 16.00 11.79 1.15
innodb count_distinct_big 20.00 +7.32% 1.58
within norms 18.00 25.00 21.58 1.96
innodb count_distinct_group 11.00 +13.64% 1.74
outside norms 11.00 14.00 12.74 0.85
innodb count_distinct_group_on_key 8.00 +8.98% 0.79
within norms 8.00 11.00 8.79 1.10
innodb count_distinct_group_on_key_parts 13.00 -8.81% -1.05
within norms 10.00 15.00 11.95 1.43
innodb count_distinct_key_prefix 5.00 -6.74% -0.32
within norms 4.00 6.00 4.68 0.57
innodb count_group_on_key_parts 10.00 -27.52% -2.16
outside norms 7.00 10.00 7.84 0.67
innodb count_on_key 77.00 +0.27% 0.21
within norms 73.00 83.00 77.21 2.57
innodb create+drop 20.00 -2.98% -0.58
within norms 19.00 21.00 19.42 0.59
innodb create_index 2.00 -2.70% -0.05
within norms 1.00 3.00 1.95 0.51
innodb create_key+drop 22.00 +1.88% 0.42
within norms 21.00 23.00 22.42 0.59
innodb create_MANY_tables 17.00 +5.28% 0.95
within norms 15.00 20.00 17.95 1.15
innodb create_table 0.00 +100.00% 0.05
within norms 0.00 1.00 0.05 0.22
innodb delete_all_many_keys 306.00 -1.31% -3.95
within norms 273.00 345.00 302.05 16.46
innodb delete_autocommit 2.00 +29.63% 0.84
outside norms 2.00 3.00 2.84 0.36
innodb delete_big 1.00 -280.00% -0.74
outside norms 0.00 1.00 0.26 0.44
innodb delete_big_many_keys 305.00 -1.03% -3.11
within norms 273.00 345.00 301.89 16.48
innodb delete_commit 2.00 -52.00% -0.68
outside norms 1.00 2.00 1.32 0.46
innodb delete_key 2.00 +22.45% 0.58
outside norms 2.00 3.00 2.58 0.49
innodb delete_range 6.00 +13.64% 0.95
outside norms 6.00 8.00 6.95 0.51
innodb delete_rollback 1.00 +26.92% 0.37
within norms 1.00 2.00 1.37 0.48
innodb drop_index 2.00 -5.56% -0.11
within norms 1.00 2.00 1.89 0.31
innodb drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb drop_table_when_MANY_tables 14.00 -2.31% -0.32
within norms 13.00 15.00 13.68 0.57
innodb insert 92.00 -1.39% -1.26
within norms 88.00 93.00 90.74 1.37
innodb insert_autocommit 3.00 -16.33% -0.42
within norms 2.00 3.00 2.58 0.49
innodb insert_commit 1.00 +9.52% 0.11
within norms 1.00 2.00 1.11 0.31
innodb insert_duplicates 13.00 -1.23% -0.16
within norms 12.00 14.00 12.84 0.59
innodb insert_key 307.00 -1.07% -3.26
within norms 253.00 345.00 303.74 19.63
innodb insert_many_fields 4.00 +2.56% 0.11
within norms 3.00 5.00 4.11 0.45
innodb insert_rollback 1.00 +29.63% 0.42
within norms 1.00 2.00 1.42 0.49
innodb insert_select_1_key 4.00 -13.43% -0.47
within norms 3.00 4.00 3.53 0.50
innodb insert_select_2_keys 5.00 +3.06% 0.16
within norms 4.00 6.00 5.16 0.49
innodb min_max 7.00 +8.90% 0.68
within norms 6.00 9.00 7.68 0.98
innodb min_max_on_key 15.00 +12.58% 2.16
outside norms 15.00 20.00 17.16 1.18
innodb multiple_value_insert 4.00 +12.64% 0.58
outside norms 4.00 5.00 4.58 0.49
innodb once_prepared_select 21.00 -0.25% -0.05
within norms 20.00 22.00 20.95 0.69
innodb order_by_big 15.00 -7.14% -1.00
outside norms 12.00 15.00 14.00 0.97
innodb order_by_big_key 11.00 +10.30% 1.26
outside norms 11.00 14.00 12.26 1.07
innodb order_by_big_key2 11.00 +5.00% 0.58
within norms 10.00 13.00 11.58 0.99
innodb order_by_big_key_desc 13.00 -0.82% -0.11
within norms 12.00 14.00 12.89 0.91
innodb order_by_big_key_diff 12.00 -3.64% -0.42
within norms 10.00 13.00 11.58 0.94
innodb order_by_big_key_prefix 11.00 +7.93% 0.95
outside norms 11.00 13.00 11.95 0.83
innodb order_by_key2_diff 1.00 +17.39% 0.21
within norms 1.00 2.00 1.21 0.41
innodb order_by_key_prefix 1.00 -72.73% -0.42
within norms 0.00 1.00 0.58 0.49
innodb order_by_range 0.00 +100.00% 0.79
outside norms 0.00 1.00 0.79 0.41
innodb outer_join 16.00 +9.79% 1.74
within norms 15.00 21.00 17.74 2.29
innodb outer_join_found 15.00 +13.37% 2.32
outside norms 14.00 21.00 17.32 2.27
innodb outer_join_not_found 14.00 +7.96% 1.21
within norms 13.00 17.00 15.21 1.58
innodb outer_join_on_key 11.00 +9.52% 1.16
within norms 10.00 15.00 12.16 1.60
innodb prepared_select 30.00 -15.62% -4.05
outside norms 22.00 29.00 25.95 2.19
innodb select_1_row 2.00 +19.15% 0.47
within norms 2.00 3.00 2.47 0.50
innodb select_1_row_cache 2.00 +5.00% 0.11
within norms 2.00 3.00 2.11 0.31
innodb select_2_rows 2.00 +9.52% 0.21
within norms 2.00 3.00 2.21 0.41
innodb select_big 11.00 +5.43% 0.63
within norms 10.00 13.00 11.63 0.98
innodb select_big_str 1.00 +8.86% 0.10
within norms 1.00 2.00 1.10 0.30
innodb select_cache 57.00 +1.63% 0.95
within norms 51.00 71.00 57.95 5.50
innodb select_cache2 51.00 +10.86% 6.21
outside norms 51.00 68.00 57.21 4.81
innodb select_column+column 3.00 -16.33% -0.42
within norms 2.00 3.00 2.58 0.49
innodb select_diff_key 0.00 +100.00% 0.16
within norms 0.00 1.00 0.16 0.36
innodb select_distinct 4.00 -2.70% -0.11
within norms 3.00 5.00 3.89 0.45
innodb select_group 16.00 -6.29% -0.95
within norms 13.00 18.00 15.05 1.50
innodb select_group_when_MANY_tables 5.00 -25.00% -1.00
outside norms 3.00 5.00 4.00 0.32
innodb select_join 1.00 -216.67% -0.68
outside norms 0.00 1.00 0.32 0.46
innodb select_key 45.00 -1.79% -0.79
within norms 40.00 49.00 44.21 2.24
innodb select_key2 49.00 +0.96% 0.47
within norms 46.00 54.00 49.47 2.68
innodb select_key2_return_key 45.00 +3.82% 1.79
within norms 43.00 51.00 46.79 2.31
innodb select_key2_return_prim 46.00 +4.17% 2.00
within norms 43.00 53.00 48.00 2.55
innodb select_key_prefix 57.00 -11.65% -5.95
outside norms 45.00 57.00 51.05 3.71
innodb select_key_prefix_join 4.00 +6.17% 0.26
within norms 4.00 5.00 4.26 0.44
innodb select_key_return_key 48.00 -11.76% -5.05
outside norms 39.00 47.00 42.95 2.30
innodb select_many_fields 17.00 -3.53% -0.58
within norms 15.00 17.00 16.42 0.67
innodb select_range 48.00 +2.15% 1.05
within norms 48.00 57.00 49.05 1.96
innodb select_range_key2 8.00 -11.76% -0.84
outside norms 6.00 8.00 7.16 0.59
innodb select_range_prefix 7.00 +1.48% 0.11
within norms 6.00 8.00 7.11 0.64
innodb select_simple 1.00 +32.14% 0.47
within norms 1.00 2.00 1.47 0.50
innodb select_simple_cache 1.00 +13.64% 0.16
within norms 1.00 2.00 1.16 0.36
innodb select_simple_join 0.00 +100.00% 0.84
outside norms 0.00 1.00 0.84 0.36
innodb update_autocommit 3.00 -7.55% -0.21
within norms 2.00 3.00 2.79 0.41
innodb update_big 34.00 +6.78% 2.47
within norms 32.00 40.00 36.47 2.56
innodb update_commit 1.00 +26.92% 0.37
within norms 1.00 2.00 1.37 0.48
innodb update_of_key 20.00 -4.40% -0.84
outside norms 19.00 20.00 19.16 0.36
innodb update_of_key_big 18.00 +2.84% 0.53
within norms 16.00 20.00 18.53 1.04
innodb update_of_primary_key_many_keys 848.00 -2.02% -16.79
within norms 782.00 947.00 831.21 41.84
innodb update_rollback 2.00 -46.15% -0.63
outside norms 1.00 2.00 1.37 0.48
innodb update_with_key 93.00 -1.09% -1.00
outside norms 91.00 93.00 92.00 0.86
innodb update_with_key_prefix 36.00 -1.94% -0.68
outside norms 34.00 36.00 35.32 0.57
innodb wisc_benchmark 2.00 +17.39% 0.42
within norms 2.00 3.00 2.42 0.49
=========================================================================================================================
FULL REVISION COMMENTARY:
1235.1.4: Brian Aker 2009-12-01 [merge] Merge of identifier work.
1235.2.1: Brian Aker 2009-12-01 More identifier work.
1235.1.3: Brian Aker 2009-12-01 Remove the need for trans/non-trans temp t...
1235.1.2: Brian Aker 2009-12-01 Added engine flag so that an engine can sk...
1235.1.1: Brian Aker 2009-12-01 [merge] Merge Monty.
1233.2.1: Monty Taylor 2009-12-01 Renamed instances of HEAP engine to MEMO...
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
