=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 374
RUN DATE: 2010-07-29T03:50:28.867575
SERVER: drizzled
VERSION: staging
REVISION: 1672
COMMENT: 1672: Brian Aker 2010-07-28 [merge] Rollup of Stewart
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 15.00 -5.63% -0.80
outside norms 13.00 15.00 14.20 0.75
innodb alter_table_drop 13.00 -0.00% 0.00
within norms 12.00 15.00 13.00 1.10
innodb connect 2.00 +9.09% 0.20
within norms 2.00 3.00 2.20 0.40
innodb connect+select_1_row 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
innodb connect+select_simple 2.00 +9.09% 0.20
within norms 2.00 3.00 2.20 0.40
innodb count 16.00 -8.11% -1.20
within norms 13.00 16.00 14.80 1.47
innodb count_distinct 8.00 -17.65% -1.20
within norms 5.00 8.00 6.80 1.47
innodb count_distinct_2 14.00 -6.06% -0.80
within norms 11.00 15.00 13.20 1.47
innodb count_distinct_big 24.00 -9.09% -2.00
within norms 19.00 24.00 22.00 2.45
innodb count_distinct_group 13.00 -3.17% -0.40
within norms 11.00 14.00 12.60 1.36
innodb count_distinct_group_on_key 11.00 -12.24% -1.20
within norms 8.00 12.00 9.80 1.60
innodb count_distinct_group_on_key_parts 13.00 -8.33% -1.00
within norms 10.00 14.00 12.00 1.67
innodb count_distinct_key_prefix 6.00 -15.38% -0.80
outside norms 5.00 6.00 5.20 0.40
innodb count_group_on_key_parts 11.00 -5.77% -0.60
outside norms 10.00 11.00 10.40 0.49
innodb count_on_key 90.00 -3.93% -3.40
within norms 82.00 91.00 86.60 3.44
innodb create+drop 29.00 +3.33% 1.00
within norms 28.00 33.00 30.00 1.67
innodb create_index 2.00 +16.67% 0.40
within norms 2.00 4.00 2.40 0.80
innodb create_key+drop 30.00 -6.38% -1.80
within norms 26.00 31.00 28.20 2.04
innodb create_MANY_tables 34.00 +8.11% 3.00
within norms 29.00 42.00 37.00 4.86
innodb create_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb delete_all_many_keys 238.00 +4.26% 10.60
within norms 231.00 275.00 248.60 15.91
innodb delete_autocommit 3.00 +16.67% 0.60
outside norms 3.00 4.00 3.60 0.49
innodb delete_big 0.00 +100.00% 0.20
within norms 0.00 1.00 0.20 0.40
innodb delete_big_many_keys 238.00 +4.26% 10.60
within norms 231.00 275.00 248.60 15.91
innodb delete_commit 1.00 +16.67% 0.20
within norms 1.00 2.00 1.20 0.40
innodb delete_key 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
innodb delete_range 6.00 +6.25% 0.40
within norms 6.00 8.00 6.40 0.80
innodb delete_rollback 1.00 +37.50% 0.60
outside norms 1.00 2.00 1.60 0.49
innodb drop_index 2.00 +9.09% 0.20
within norms 2.00 3.00 2.20 0.40
innodb drop_table 0.00 +100.00% 0.20
within norms 0.00 1.00 0.20 0.40
innodb drop_table_when_MANY_tables 20.00 -6.38% -1.20
within norms 16.00 23.00 18.80 2.48
innodb insert 104.00 -0.19% -0.20
within norms 100.00 106.00 103.80 2.04
innodb insert_autocommit 2.00 +23.08% 0.60
outside norms 2.00 3.00 2.60 0.49
innodb insert_commit 2.00 -25.00% -0.40
within norms 1.00 2.00 1.60 0.49
innodb insert_duplicates 16.00 -11.11% -1.60
outside norms 13.00 16.00 14.40 1.20
innodb insert_key 222.00 +5.37% 12.60
within norms 198.00 266.00 234.60 24.52
innodb insert_many_fields 5.00 -0.00% 0.00
within norms 4.00 6.00 5.00 0.89
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 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
innodb insert_select_2_keys 5.00 -4.17% -0.20
within norms 4.00 5.00 4.80 0.40
innodb min_max 8.00 -8.11% -0.60
within norms 6.00 9.00 7.40 1.20
innodb min_max_on_key 22.00 -6.80% -1.40
outside norms 19.00 22.00 20.60 1.20
innodb multiple_value_insert 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
innodb once_prepared_select 21.00 +7.08% 1.60
within norms 21.00 26.00 22.60 1.74
innodb order_by_big 14.00 -0.00% 0.00
within norms 13.00 17.00 14.00 1.55
innodb order_by_big_key 12.00 +6.25% 0.80
within norms 12.00 15.00 12.80 1.17
innodb order_by_big_key2 11.00 +5.17% 0.60
within norms 11.00 14.00 11.60 1.20
innodb order_by_big_key_desc 12.00 +1.64% 0.20
within norms 11.00 14.00 12.20 0.98
innodb order_by_big_key_diff 11.00 +6.78% 0.80
outside norms 11.00 13.00 11.80 0.75
innodb order_by_big_key_prefix 10.00 +10.71% 1.20
within norms 10.00 14.00 11.20 1.47
innodb order_by_key2_diff 2.00 -42.86% -0.60
outside norms 1.00 2.00 1.40 0.49
innodb order_by_key_prefix 0.00 +100.00% 0.80
outside norms 0.00 1.00 0.80 0.40
innodb order_by_range 1.00 -25.00% -0.20
within norms 0.00 1.00 0.80 0.40
innodb outer_join 15.00 +19.35% 3.60
outside norms 15.00 21.00 18.60 2.58
innodb outer_join_found 15.00 +16.67% 3.00
outside norms 14.00 21.00 18.00 2.90
innodb outer_join_not_found 13.00 +17.72% 2.80
outside norms 13.00 19.00 15.80 2.48
innodb outer_join_on_key 11.00 +12.70% 1.60
outside norms 11.00 14.00 12.60 1.36
innodb prepared_select 34.00 -9.68% -3.00
outside norms 27.00 34.00 31.00 2.76
innodb select_1_row 3.00 -7.14% -0.20
within norms 2.00 3.00 2.80 0.40
innodb select_1_row_cache 2.00 +16.67% 0.40
within norms 2.00 3.00 2.40 0.49
innodb select_2_rows 3.00 +6.25% 0.20
within norms 3.00 4.00 3.20 0.40
innodb select_big 11.00 +6.78% 0.80
within norms 11.00 14.00 11.80 1.17
innodb select_big_str 1.00 +16.67% 0.20
within norms 1.00 2.00 1.20 0.40
innodb select_cache 63.00 -8.25% -4.80
within norms 51.00 64.00 58.20 5.56
innodb select_cache2 64.00 -8.11% -4.80
within norms 50.00 66.00 59.20 6.76
innodb select_column+column 4.00 -33.33% -1.00
outside norms 2.00 4.00 3.00 0.63
innodb select_diff_key 0.00 +100.00% 0.20
within norms 0.00 1.00 0.20 0.40
innodb select_distinct 4.00 +4.76% 0.20
within norms 4.00 5.00 4.20 0.40
innodb select_group 15.00 +3.85% 0.60
within norms 14.00 17.00 15.60 1.20
innodb select_group_when_MANY_tables 5.00 -4.17% -0.20
within norms 4.00 5.00 4.80 0.40
innodb select_join 1.00 -25.00% -0.20
within norms 0.00 1.00 0.80 0.40
innodb select_key 50.00 +1.96% 1.00
outside norms 50.00 52.00 51.00 0.63
innodb select_key2 56.00 -1.45% -0.80
outside norms 54.00 56.00 55.20 0.75
innodb select_key2_return_key 52.00 +1.89% 1.00
outside norms 52.00 54.00 53.00 0.63
innodb select_key2_return_prim 54.00 -0.00% 0.00
within norms 53.00 56.00 54.00 1.10
innodb select_key_prefix 55.00 -0.00% 0.00
within norms 54.00 56.00 55.00 0.63
innodb select_key_prefix_join 4.00 +13.04% 0.60
outside norms 4.00 5.00 4.60 0.49
innodb select_key_return_key 49.00 +0.41% 0.20
within norms 49.00 50.00 49.20 0.40
innodb select_many_fields 14.00 +7.89% 1.20
outside norms 14.00 17.00 15.20 1.17
innodb select_range 50.00 -4.60% -2.20
within norms 43.00 52.00 47.80 3.31
innodb select_range_key2 8.00 -5.26% -0.40
within norms 7.00 8.00 7.60 0.49
innodb select_range_prefix 7.00 +2.78% 0.20
within norms 6.00 8.00 7.20 0.75
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 +28.57% 0.40
within norms 1.00 2.00 1.40 0.49
innodb select_simple_join 0.00 +100.00% 0.20
within norms 0.00 1.00 0.20 0.40
innodb update_autocommit 3.00 +6.25% 0.20
within norms 3.00 4.00 3.20 0.40
innodb update_big 35.00 +2.78% 1.00
within norms 35.00 38.00 36.00 1.10
innodb update_commit 2.00 -25.00% -0.40
within norms 1.00 2.00 1.60 0.49
innodb update_of_key 21.00 +4.55% 1.00
within norms 20.00 25.00 22.00 2.10
innodb update_of_key_big 20.00 -7.53% -1.40
outside norms 17.00 20.00 18.60 1.02
innodb update_of_primary_key_many_keys 731.00 +4.34% 33.20
within norms 713.00 848.00 764.20 50.46
innodb update_rollback 2.00 -25.00% -0.40
within norms 1.00 2.00 1.60 0.49
innodb update_with_key 105.00 -0.57% -0.60
within norms 102.00 107.00 104.40 1.74
innodb update_with_key_prefix 39.00 -1.04% -0.40
within norms 37.00 40.00 38.60 1.02
innodb wisc_benchmark 2.00 +16.67% 0.40
within norms 2.00 3.00 2.40 0.49
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 15.00 -3.45% -0.50
within norms 12.00 29.00 14.50 3.44
innodb alter_table_drop 13.00 +6.14% 0.85
within norms 12.00 28.00 13.85 3.32
innodb connect 2.00 +2.44% 0.05
within norms 2.00 3.00 2.05 0.22
innodb connect+select_1_row 3.00 -3.45% -0.10
within norms 2.00 3.00 2.90 0.30
innodb connect+select_simple 2.00 +14.89% 0.35
within norms 2.00 3.00 2.35 0.48
innodb count 16.00 -7.02% -1.05
within norms 13.00 17.00 14.95 1.83
innodb count_distinct 8.00 -25.98% -1.65
outside norms 5.00 9.00 6.35 1.15
innodb count_distinct_2 14.00 -10.67% -1.35
within norms 11.00 16.00 12.65 1.65
innodb count_distinct_big 24.00 -7.14% -1.60
within norms 19.00 25.00 22.40 1.77
innodb count_distinct_group 13.00 -11.59% -1.35
within norms 10.00 14.00 11.65 1.59
innodb count_distinct_group_on_key 11.00 -21.55% -1.95
outside norms 8.00 12.00 9.05 1.40
innodb count_distinct_group_on_key_parts 13.00 -16.59% -1.85
outside norms 10.00 14.00 11.15 1.53
innodb count_distinct_key_prefix 6.00 -27.66% -1.30
outside norms 4.00 6.00 4.70 0.71
innodb count_group_on_key_parts 11.00 -7.84% -0.80
outside norms 8.00 11.00 10.20 0.75
innodb count_on_key 90.00 -3.57% -3.10
outside norms 82.00 91.00 86.90 2.47
innodb create+drop 29.00 +7.79% 2.45
within norms 26.00 40.00 31.45 3.41
innodb create_index 2.00 +28.57% 0.80
within norms 2.00 5.00 2.80 1.03
innodb create_key+drop 30.00 -8.70% -2.40
outside norms 26.00 31.00 27.60 1.32
innodb create_MANY_tables 34.00 +15.74% 6.35
within norms 24.00 66.00 40.35 8.38
innodb create_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb delete_all_many_keys 238.00 +1.55% 3.75
within norms 226.00 292.00 241.75 17.42
innodb delete_autocommit 3.00 +16.67% 0.60
outside norms 3.00 4.00 3.60 0.49
innodb delete_big 0.00 +100.00% 0.20
within norms 0.00 1.00 0.20 0.40
innodb delete_big_many_keys 238.00 +1.55% 3.75
within norms 226.00 292.00 241.75 17.42
innodb delete_commit 1.00 +20.00% 0.25
within norms 1.00 2.00 1.25 0.43
innodb delete_key 3.00 +13.04% 0.45
within norms 2.00 5.00 3.45 0.67
innodb delete_range 6.00 +3.23% 0.20
within norms 6.00 8.00 6.20 0.51
innodb delete_rollback 1.00 +31.03% 0.45
within norms 1.00 2.00 1.45 0.50
innodb drop_index 2.00 +14.89% 0.35
within norms 2.00 4.00 2.35 0.73
innodb drop_table 0.00 +100.00% 0.05
within norms 0.00 1.00 0.05 0.22
innodb drop_table_when_MANY_tables 20.00 -1.01% -0.20
within norms 16.00 28.00 19.80 2.93
innodb insert 104.00 +5.02% 5.50
outside norms 100.00 121.00 109.50 5.15
innodb insert_autocommit 2.00 +31.03% 0.90
outside norms 2.00 3.00 2.90 0.30
innodb insert_commit 2.00 -66.67% -0.80
outside norms 1.00 2.00 1.20 0.40
innodb insert_duplicates 16.00 -7.74% -1.15
within norms 13.00 17.00 14.85 1.24
innodb insert_key 222.00 +6.29% 14.90
within norms 191.00 312.00 236.90 31.26
innodb insert_many_fields 5.00 -11.11% -0.50
within norms 3.00 6.00 4.50 0.74
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 +6.25% 0.20
within norms 3.00 6.00 3.20 0.68
innodb insert_select_2_keys 5.00 -4.17% -0.20
within norms 4.00 6.00 4.80 0.60
innodb min_max 8.00 -9.59% -0.70
within norms 6.00 9.00 7.30 0.95
innodb min_max_on_key 22.00 -6.80% -1.40
outside norms 19.00 23.00 20.60 1.32
innodb multiple_value_insert 3.00 -5.26% -0.15
within norms 2.00 5.00 2.85 0.73
innodb once_prepared_select 21.00 +8.70% 2.00
outside norms 20.00 27.00 23.00 1.76
innodb order_by_big 14.00 +3.11% 0.45
within norms 13.00 17.00 14.45 1.20
innodb order_by_big_key 12.00 +9.09% 1.20
within norms 12.00 16.00 13.20 1.36
innodb order_by_big_key2 11.00 +7.95% 0.95
within norms 10.00 14.00 11.95 1.20
innodb order_by_big_key_desc 12.00 +3.61% 0.45
within norms 11.00 15.00 12.45 1.12
innodb order_by_big_key_diff 11.00 +8.33% 1.00
outside norms 11.00 14.00 12.00 0.95
innodb order_by_big_key_prefix 10.00 +14.89% 1.75
outside norms 10.00 15.00 11.75 1.37
innodb order_by_key2_diff 2.00 -25.00% -0.40
within norms 1.00 2.00 1.60 0.49
innodb order_by_key_prefix 0.00 +100.00% 0.75
outside norms 0.00 1.00 0.75 0.43
innodb order_by_range 1.00 -42.86% -0.30
within norms 0.00 1.00 0.70 0.46
innodb outer_join 15.00 +11.50% 1.95
within norms 15.00 21.00 16.95 2.20
innodb outer_join_found 15.00 +8.81% 1.45
within norms 14.00 21.00 16.45 2.04
innodb outer_join_not_found 13.00 +7.14% 1.00
within norms 12.00 19.00 14.00 2.07
innodb outer_join_on_key 11.00 +5.98% 0.70
within norms 10.00 14.00 11.70 1.23
innodb prepared_select 34.00 -13.14% -3.95
outside norms 26.00 34.00 30.05 2.50
innodb select_1_row 3.00 -13.21% -0.35
within norms 2.00 3.00 2.65 0.48
innodb select_1_row_cache 2.00 +20.00% 0.50
within norms 2.00 3.00 2.50 0.50
innodb select_2_rows 3.00 -3.45% -0.10
within norms 2.00 4.00 2.90 0.44
innodb select_big 11.00 +5.98% 0.70
within norms 10.00 14.00 11.70 0.95
innodb select_big_str 1.00 +4.76% 0.05
within norms 1.00 2.00 1.05 0.22
innodb select_cache 63.00 -6.96% -4.10
within norms 51.00 65.00 58.90 4.95
innodb select_cache2 64.00 -8.20% -4.85
within norms 50.00 66.00 59.15 6.32
innodb select_column+column 4.00 -35.59% -1.05
outside norms 2.00 4.00 2.95 0.50
innodb select_diff_key 0.00 +100.00% 0.15
within norms 0.00 1.00 0.15 0.36
innodb select_distinct 4.00 +8.05% 0.35
within norms 3.00 5.00 4.35 0.57
innodb select_group 15.00 +3.23% 0.50
within norms 12.00 18.00 15.50 1.75
innodb select_group_when_MANY_tables 5.00 +0.99% 0.05
within norms 4.00 6.00 5.05 0.67
innodb select_join 1.00 -81.82% -0.45
within norms 0.00 1.00 0.55 0.50
innodb select_key 50.00 +1.96% 1.00
within norms 50.00 58.00 51.00 2.24
innodb select_key2 56.00 +0.27% 0.15
within norms 54.00 66.00 56.15 2.90
innodb select_key2_return_key 52.00 +1.61% 0.85
within norms 52.00 56.00 52.85 0.91
innodb select_key2_return_prim 54.00 +0.37% 0.20
within norms 53.00 61.00 54.20 1.86
innodb select_key_prefix 55.00 -0.27% -0.15
within norms 54.00 56.00 54.85 0.48
innodb select_key_prefix_join 4.00 +13.04% 0.60
outside norms 4.00 6.00 4.60 0.58
innodb select_key_return_key 49.00 +2.00% 1.00
within norms 49.00 58.00 50.00 2.41
innodb select_many_fields 14.00 +10.54% 1.65
within norms 11.00 18.00 15.65 1.85
innodb select_range 50.00 -8.11% -3.75
outside norms 43.00 52.00 46.25 3.13
innodb select_range_key2 8.00 -3.23% -0.25
within norms 7.00 9.00 7.75 0.54
innodb select_range_prefix 7.00 +2.10% 0.15
within norms 6.00 8.00 7.15 0.85
innodb select_simple 2.00 -29.03% -0.45
within norms 1.00 2.00 1.55 0.50
innodb select_simple_cache 1.00 +23.08% 0.30
within norms 1.00 2.00 1.30 0.46
innodb select_simple_join 0.00 +100.00% 0.45
within norms 0.00 1.00 0.45 0.50
innodb update_autocommit 3.00 +6.25% 0.20
within norms 3.00 4.00 3.20 0.40
innodb update_big 35.00 +8.85% 3.40
within norms 35.00 59.00 38.40 4.99
innodb update_commit 2.00 -29.03% -0.45
within norms 1.00 2.00 1.55 0.50
innodb update_of_key 21.00 +18.60% 4.80
outside norms 20.00 31.00 25.80 3.70
innodb update_of_key_big 20.00 +1.23% 0.25
within norms 16.00 24.00 20.25 2.41
innodb update_of_primary_key_many_keys 731.00 +2.15% 16.10
within norms 678.00 885.00 747.10 54.51
innodb update_rollback 2.00 -21.21% -0.35
within norms 1.00 2.00 1.65 0.48
innodb update_with_key 105.00 +2.96% 3.20
within norms 102.00 121.00 108.20 4.18
innodb update_with_key_prefix 39.00 -1.43% -0.55
within norms 34.00 41.00 38.45 1.60
innodb wisc_benchmark 2.00 +14.89% 0.35
within norms 2.00 3.00 2.35 0.48
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 15.00 -23.23% -2.83
outside norms 11.00 14.00 12.17 0.87
innodb alter_table_drop 13.00 -13.90% -1.59
outside norms 10.00 14.00 11.41 1.07
innodb connect 2.00 -18.37% -0.31
within norms 1.00 2.00 1.69 0.46
innodb connect+select_1_row 3.00 -27.94% -0.66
outside norms 2.00 3.00 2.34 0.48
innodb connect+select_simple 2.00 -1.75% -0.03
within norms 1.00 2.00 1.97 0.18
innodb count 16.00 -6.67% -1.00
within norms 13.00 18.00 15.00 1.76
innodb count_distinct 8.00 -31.82% -1.93
outside norms 5.00 8.00 6.07 0.83
innodb count_distinct_2 14.00 -15.34% -1.86
outside norms 11.00 16.00 12.14 1.38
innodb count_distinct_big 24.00 -12.44% -2.66
outside norms 18.00 25.00 21.34 1.97
innodb count_distinct_group 13.00 -2.72% -0.34
within norms 11.00 14.00 12.66 0.84
innodb count_distinct_group_on_key 11.00 -23.64% -2.10
outside norms 8.00 11.00 8.90 1.12
innodb count_distinct_group_on_key_parts 13.00 -10.56% -1.24
within norms 10.00 15.00 11.76 1.36
innodb count_distinct_key_prefix 6.00 -27.01% -1.28
outside norms 4.00 6.00 4.72 0.69
innodb count_group_on_key_parts 11.00 -35.17% -2.86
outside norms 7.00 10.00 8.14 0.78
innodb count_on_key 90.00 -16.52% -12.76
outside norms 73.00 83.00 77.24 2.25
innodb create+drop 29.00 -48.59% -9.48
outside norms 19.00 21.00 19.52 0.56
innodb create_index 2.00 -5.45% -0.10
within norms 1.00 3.00 1.90 0.48
innodb create_key+drop 30.00 -33.03% -7.45
outside norms 21.00 23.00 22.55 0.56
innodb create_MANY_tables 34.00 -99.19% -16.93
outside norms 14.00 20.00 17.07 1.70
innodb create_table 0.00 +100.00% 0.07
within norms 0.00 1.00 0.07 0.25
innodb delete_all_many_keys 238.00 +19.93% 59.24
outside norms 239.00 345.00 297.24 21.38
innodb delete_autocommit 3.00 -6.10% -0.17
within norms 2.00 3.00 2.83 0.38
innodb delete_big 0.00 +100.00% 0.28
within norms 0.00 1.00 0.28 0.45
innodb delete_big_many_keys 238.00 +19.90% 59.14
outside norms 239.00 345.00 297.14 21.37
innodb delete_commit 1.00 +25.64% 0.34
within norms 1.00 2.00 1.34 0.48
innodb delete_key 3.00 -22.54% -0.55
outside norms 2.00 3.00 2.45 0.50
innodb delete_range 6.00 +13.86% 0.97
outside norms 6.00 8.00 6.97 0.56
innodb delete_rollback 1.00 +23.68% 0.31
within norms 1.00 2.00 1.31 0.46
innodb drop_index 2.00 -1.75% -0.03
within norms 1.00 3.00 1.97 0.32
innodb drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb drop_table_when_MANY_tables 20.00 -48.34% -6.52
outside norms 12.00 15.00 13.48 0.62
innodb insert 104.00 -14.68% -13.31
outside norms 88.00 93.00 90.69 1.37
innodb insert_autocommit 2.00 +22.67% 0.59
outside norms 2.00 3.00 2.59 0.49
innodb insert_commit 2.00 -81.25% -0.90
outside norms 1.00 2.00 1.10 0.30
innodb insert_duplicates 16.00 -24.73% -3.17
outside norms 12.00 14.00 12.83 0.53
innodb insert_key 222.00 +22.82% 65.62
outside norms 189.00 345.00 287.62 32.94
innodb insert_many_fields 5.00 -22.88% -0.93
outside norms 3.00 5.00 4.07 0.36
innodb insert_rollback 2.00 -41.46% -0.59
outside norms 1.00 2.00 1.41 0.49
innodb insert_select_1_key 3.00 +12.12% 0.41
within norms 3.00 4.00 3.41 0.49
innodb insert_select_2_keys 5.00 +3.33% 0.17
within norms 4.00 6.00 5.17 0.59
innodb min_max 8.00 -4.50% -0.34
within norms 6.00 9.00 7.66 1.03
innodb min_max_on_key 22.00 -30.47% -5.14
outside norms 14.00 20.00 16.86 1.28
innodb multiple_value_insert 3.00 +33.59% 1.52
outside norms 3.00 5.00 4.52 0.56
innodb once_prepared_select 21.00 -0.16% -0.03
within norms 20.00 22.00 20.97 0.61
innodb order_by_big 14.00 +0.98% 0.14
within norms 12.00 15.00 14.14 0.94
innodb order_by_big_key 12.00 +3.33% 0.41
within norms 11.00 14.00 12.41 1.19
innodb order_by_big_key2 11.00 +4.20% 0.48
within norms 10.00 13.00 11.48 0.97
innodb order_by_big_key_desc 12.00 +6.95% 0.90
within norms 12.00 14.00 12.90 0.92
innodb order_by_big_key_diff 11.00 +5.06% 0.59
within norms 10.00 13.00 11.59 0.85
innodb order_by_big_key_prefix 10.00 +16.43% 1.97
outside norms 11.00 13.00 11.97 0.85
innodb order_by_key2_diff 2.00 -70.59% -0.83
outside norms 1.00 2.00 1.17 0.38
innodb order_by_key_prefix 0.00 +100.00% 0.62
outside norms 0.00 1.00 0.62 0.49
innodb order_by_range 1.00 -38.10% -0.28
within norms 0.00 1.00 0.72 0.45
innodb outer_join 15.00 +13.52% 2.34
outside norms 15.00 21.00 17.34 2.06
innodb outer_join_found 15.00 +11.04% 1.86
within norms 14.00 21.00 16.86 2.19
innodb outer_join_not_found 13.00 +13.33% 2.00
outside norms 13.00 18.00 15.00 1.49
innodb outer_join_on_key 11.00 +8.07% 0.97
within norms 10.00 15.00 11.97 1.50
innodb prepared_select 34.00 -31.47% -8.14
outside norms 22.00 29.00 25.86 2.10
innodb select_1_row 3.00 -22.54% -0.55
outside norms 2.00 3.00 2.45 0.50
innodb select_1_row_cache 2.00 +3.33% 0.07
within norms 2.00 3.00 2.07 0.25
innodb select_2_rows 3.00 -35.94% -0.79
outside norms 2.00 3.00 2.21 0.41
innodb select_big 11.00 +5.34% 0.62
within norms 10.00 13.00 11.62 1.00
innodb select_big_str 1.00 +9.07% 0.10
within norms 0.00 2.00 1.10 0.31
innodb select_cache 63.00 -9.40% -5.41
outside norms 51.00 71.00 57.59 5.41
innodb select_cache2 64.00 -12.55% -7.14
outside norms 51.00 68.00 56.86 4.88
innodb select_column+column 4.00 -50.65% -1.34
outside norms 2.00 3.00 2.66 0.48
innodb select_diff_key 0.00 +100.00% 0.17
within norms 0.00 1.00 0.17 0.38
innodb select_distinct 4.00 -1.75% -0.07
within norms 3.00 5.00 3.93 0.36
innodb select_group 15.00 +1.36% 0.21
within norms 13.00 18.00 15.21 1.47
innodb select_group_when_MANY_tables 5.00 -25.00% -1.00
outside norms 3.00 5.00 4.00 0.37
innodb select_join 1.00 -107.14% -0.52
outside norms 0.00 1.00 0.48 0.50
innodb select_key 50.00 -12.32% -5.48
outside norms 40.00 50.00 44.52 2.50
innodb select_key2 56.00 -13.65% -6.72
outside norms 46.00 54.00 49.28 2.41
innodb select_key2_return_key 52.00 -10.80% -5.07
outside norms 42.00 51.00 46.93 2.32
innodb select_key2_return_prim 54.00 -11.54% -5.59
outside norms 43.00 55.00 48.41 2.92
innodb select_key_prefix 55.00 -8.28% -4.21
outside norms 45.00 57.00 50.79 3.46
innodb select_key_prefix_join 4.00 +4.13% 0.17
within norms 4.00 5.00 4.17 0.38
innodb select_key_return_key 49.00 -12.42% -5.41
outside norms 39.00 49.00 43.59 2.65
innodb select_many_fields 14.00 +14.88% 2.45
outside norms 15.00 17.00 16.45 0.62
innodb select_range 50.00 -2.33% -1.14
within norms 47.00 57.00 48.86 1.66
innodb select_range_key2 8.00 -10.48% -0.76
outside norms 6.00 8.00 7.24 0.57
innodb select_range_prefix 7.00 -0.00% 0.00
within norms 6.00 8.00 7.00 0.64
innodb select_simple 2.00 -38.10% -0.55
outside norms 1.00 2.00 1.45 0.50
innodb select_simple_cache 1.00 +12.12% 0.14
within norms 1.00 2.00 1.14 0.34
innodb select_simple_join 0.00 +100.00% 0.72
outside norms 0.00 1.00 0.72 0.45
innodb update_autocommit 3.00 -7.41% -0.21
within norms 2.00 3.00 2.79 0.41
innodb update_big 35.00 +2.87% 1.03
within norms 31.00 40.00 36.03 2.48
innodb update_commit 2.00 -48.72% -0.66
outside norms 1.00 2.00 1.34 0.48
innodb update_of_key 21.00 -8.94% -1.72
outside norms 19.00 20.00 19.28 0.45
innodb update_of_key_big 20.00 -9.23% -1.69
outside norms 16.00 20.00 18.31 1.18
innodb update_of_primary_key_many_keys 731.00 +10.53% 86.07
outside norms 661.00 947.00 817.07 54.24
innodb update_rollback 2.00 -41.46% -0.59
outside norms 1.00 2.00 1.41 0.49
innodb update_with_key 105.00 -14.43% -13.24
outside norms 90.00 93.00 91.76 0.97
innodb update_with_key_prefix 39.00 -10.67% -3.76
outside norms 34.00 36.00 35.24 0.57
innodb wisc_benchmark 2.00 +14.71% 0.34
within norms 2.00 3.00 2.34 0.48
=========================================================================================================================
FULL REVISION COMMENTARY:
1671.1.4: Brian Aker 2010-07-28 [merge] Merge Archive fix from Stewart.
1668.5.1: Stewart Smith 2010-07-28 after RENAME TABLE for an ARCHIVE table,
the table proto stored in the ARZ header still has the old table name in it. We
can easily fix this by returning the correct name from getTableDefinition and
not having to then rewrite the ARZ header.
1671.1.3: Brian Aker 2010-07-28 [merge] Merge Stewart timestamp removal.
1668.4.1: Stewart Smith 2010-07-28 TimestampFieldOptions in the table proto
contains nothing that we use. remove it.
1671.1.2: Brian Aker 2010-07-28 [merge] Merge Stewart for comment.
1668.3.1: Stewart Smith 2010-07-28 upper layer treats empty string for
COMMENT as removing comment. Fix this in routine for filling out table protobuf
message. (only user visible with statement_transform is used for SHOW CREATE
TABLE
1671.1.1: Brian Aker 2010-07-28 [merge] Merge Stewart.
1668.2.1: Stewart Smith 2010-07-28 [merge] merge remove unused row type in
table message
1638.2.6: Stewart Smith 2010-07-27 [merge] merge trunk
1638.2.5: Stewart Smith 2010-07-20 [merge] merge trunk
1638.2.4: Stewart Smith 2010-07-19 [merge] Merged
default-collation-in-table-message into remove-unused-row-type-in-table-message.
1638.2.3: Stewart Smith 2010-07-13 [merge] merge trunk
1638.2.2: Stewart Smith 2010-07-05 [merge] Merged
default-collation-in-table-message into remove-unused-row-type-in-table-message.
1638.2.1: Stewart Smith 2010-06-28 remove unused row_type from table
proto (although referenced in a bunch of places)
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
