=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 424
RUN DATE: 2010-08-19T17:53:37.616643
SERVER: drizzled
VERSION: staging
REVISION: 1721
COMMENT: 1721: Patrick Crews 2010-08-19 [merge] Rollup patch - stewart's show
create table patch + a couple of fixes
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 13.00 +1.52% 0.20
within norms 12.00 15.00 13.20 0.98
innodb alter_table_drop 13.00 -3.17% -0.40
within norms 12.00 13.00 12.60 0.49
innodb connect 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
innodb connect+select_1_row 3.00 -7.14% -0.20
within norms 2.00 3.00 2.80 0.40
innodb connect+select_simple 2.00 +23.08% 0.60
outside norms 2.00 3.00 2.60 0.49
innodb count 17.00 -4.94% -0.80
outside norms 16.00 17.00 16.20 0.40
innodb count_distinct 5.00 +19.35% 1.20
outside norms 5.00 8.00 6.20 1.17
innodb count_distinct_2 12.00 +9.09% 1.20
within norms 12.00 15.00 13.20 1.47
innodb count_distinct_big 23.00 +1.71% 0.40
within norms 23.00 24.00 23.40 0.49
innodb count_distinct_group 11.00 +8.33% 1.00
within norms 10.00 14.00 12.00 1.67
innodb count_distinct_group_on_key 8.00 +11.11% 1.00
within norms 8.00 11.00 9.00 1.26
innodb count_distinct_group_on_key_parts 10.00 +10.71% 1.20
within norms 10.00 14.00 11.20 1.60
innodb count_distinct_key_prefix 5.00 +3.85% 0.20
within norms 4.00 6.00 5.20 0.75
innodb count_group_on_key_parts 10.00 -2.04% -0.20
within norms 7.00 11.00 9.80 1.47
innodb count_on_key 88.00 -5.26% -4.40
within norms 73.00 89.00 83.60 5.99
innodb create+drop 34.00 -8.28% -2.60
within norms 25.00 39.00 31.40 4.84
innodb create_index 2.00 +9.09% 0.20
within norms 2.00 3.00 2.20 0.40
innodb create_key+drop 29.00 -8.21% -2.20
outside norms 26.00 29.00 26.80 1.17
innodb create_MANY_tables 36.00 -13.92% -4.40
within norms 23.00 45.00 31.60 8.04
innodb create_table 2.00 -100.00% -1.00
outside norms 0.00 2.00 1.00 0.89
innodb delete_all_many_keys 269.00 -9.44% -23.20
outside norms 217.00 269.00 245.80 21.64
innodb delete_autocommit 3.00 +11.76% 0.40
within norms 3.00 4.00 3.40 0.49
innodb delete_big 1.00 -150.00% -0.60
outside norms 0.00 1.00 0.40 0.49
innodb delete_big_many_keys 269.00 -9.44% -23.20
outside norms 217.00 269.00 245.80 21.64
innodb delete_commit 2.00 -11.11% -0.20
within norms 1.00 2.00 1.80 0.40
innodb delete_key 4.00 -17.65% -0.60
outside norms 3.00 4.00 3.40 0.49
innodb delete_range 6.00 -3.45% -0.20
within norms 5.00 6.00 5.80 0.40
innodb delete_rollback 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
innodb drop_index 2.00 +9.09% 0.20
within norms 2.00 3.00 2.20 0.40
innodb drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb drop_table_when_MANY_tables 15.00 +1.32% 0.20
within norms 15.00 16.00 15.20 0.40
innodb insert 109.00 -2.25% -2.40
within norms 96.00 119.00 106.60 7.50
innodb insert_autocommit 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
innodb insert_commit 1.00 +16.67% 0.20
within norms 1.00 2.00 1.20 0.40
innodb insert_duplicates 17.00 -6.25% -1.00
outside norms 15.00 17.00 16.00 0.89
innodb insert_key 212.00 +2.93% 6.40
within norms 200.00 259.00 218.40 21.15
innodb insert_many_fields 6.00 -15.38% -0.80
outside norms 5.00 6.00 5.20 0.40
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 +6.25% 0.20
within norms 3.00 4.00 3.20 0.40
innodb insert_select_2_keys 4.00 +9.09% 0.40
within norms 4.00 5.00 4.40 0.49
innodb min_max 9.00 -9.76% -0.80
outside norms 7.00 9.00 8.20 0.75
innodb min_max_on_key 21.00 -0.96% -0.20
within norms 19.00 23.00 20.80 1.60
innodb multiple_value_insert 3.00 -7.14% -0.20
within norms 2.00 3.00 2.80 0.40
innodb once_prepared_select 23.00 +4.17% 1.00
within norms 21.00 27.00 24.00 2.00
innodb order_by_big 15.00 +1.32% 0.20
within norms 13.00 16.00 15.20 1.17
innodb order_by_big_key 15.00 -5.63% -0.80
within norms 12.00 16.00 14.20 1.47
innodb order_by_big_key2 14.00 -7.69% -1.00
outside norms 12.00 14.00 13.00 0.89
innodb order_by_big_key_desc 14.00 -4.48% -0.60
within norms 11.00 16.00 13.40 1.74
innodb order_by_big_key_diff 13.00 +1.52% 0.20
within norms 11.00 15.00 13.20 1.33
innodb order_by_big_key_prefix 12.00 +1.64% 0.20
within norms 10.00 15.00 12.20 1.72
innodb order_by_key2_diff 1.00 +44.44% 0.80
outside norms 1.00 2.00 1.80 0.40
innodb order_by_key_prefix 1.00 -400.00% -0.80
outside norms 0.00 1.00 0.20 0.40
innodb order_by_range 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
innodb outer_join 21.00 -19.32% -3.40
outside norms 15.00 21.00 17.60 2.42
innodb outer_join_found 21.00 -20.69% -3.60
outside norms 15.00 21.00 17.40 2.58
innodb outer_join_not_found 17.00 -14.86% -2.20
outside norms 12.00 17.00 14.80 1.94
innodb outer_join_on_key 13.00 -6.56% -0.80
outside norms 11.00 13.00 12.20 0.75
innodb prepared_select 33.00 -6.45% -2.00
outside norms 29.00 33.00 31.00 1.67
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 +23.08% 0.60
outside norms 2.00 3.00 2.60 0.49
innodb select_2_rows 2.00 +23.08% 0.60
outside norms 2.00 3.00 2.60 0.49
innodb select_big 13.00 -4.84% -0.60
within norms 11.00 15.00 12.40 1.50
innodb select_big_str 1.00 +28.57% 0.40
within norms 1.00 2.00 1.40 0.49
innodb select_cache 67.00 -17.96% -10.20
outside norms 52.00 67.00 56.80 5.23
innodb select_cache2 70.00 -22.38% -12.80
outside norms 50.00 70.00 57.20 6.88
innodb select_column+column 3.00 -7.14% -0.20
within norms 2.00 3.00 2.80 0.40
innodb select_diff_key 1.00 -400.00% -0.80
outside norms 0.00 1.00 0.20 0.40
innodb select_distinct 4.00 +9.09% 0.40
within norms 4.00 5.00 4.40 0.49
innodb select_group 16.00 +2.44% 0.40
within norms 16.00 17.00 16.40 0.49
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 -400.00% -0.80
outside norms 0.00 1.00 0.20 0.40
innodb select_key 53.00 -4.33% -2.20
outside norms 50.00 53.00 50.80 1.17
innodb select_key2 59.00 +1.01% 0.60
within norms 55.00 63.00 59.60 2.65
innodb select_key2_return_key 63.00 -5.35% -3.20
within norms 53.00 63.00 59.80 3.66
innodb select_key2_return_prim 64.00 -6.67% -4.00
outside norms 54.00 64.00 60.00 3.85
innodb select_key_prefix 55.00 +3.85% 2.20
within norms 55.00 65.00 57.20 3.92
innodb select_key_prefix_join 4.00 +20.00% 1.00
outside norms 4.00 6.00 5.00 0.63
innodb select_key_return_key 54.00 -2.66% -1.40
within norms 49.00 58.00 52.60 3.20
innodb select_many_fields 15.00 +5.06% 0.80
outside norms 15.00 17.00 15.80 0.75
innodb select_range 52.00 -12.07% -5.60
outside norms 42.00 52.00 46.40 3.88
innodb select_range_key2 8.00 +2.44% 0.20
within norms 7.00 10.00 8.20 0.98
innodb select_range_prefix 7.00 +5.41% 0.40
within norms 7.00 8.00 7.40 0.49
innodb select_simple 2.00 -42.86% -0.60
outside norms 1.00 2.00 1.40 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.40
within norms 0.00 1.00 0.40 0.49
innodb update_autocommit 3.00 +6.25% 0.20
within norms 3.00 4.00 3.20 0.40
innodb update_big 37.00 -2.21% -0.80
outside norms 35.00 37.00 36.20 0.75
innodb update_commit 2.00 -11.11% -0.20
within norms 1.00 2.00 1.80 0.40
innodb update_of_key 29.00 -21.85% -5.20
outside norms 20.00 29.00 23.80 4.26
innodb update_of_key_big 21.00 -5.00% -1.00
within norms 18.00 23.00 20.00 1.90
innodb update_of_primary_key_many_keys 830.00 -7.79% -60.00
within norms 686.00 833.00 770.00 68.86
innodb update_rollback 2.00 -11.11% -0.20
within norms 1.00 2.00 1.80 0.40
innodb update_with_key 107.00 +0.93% 1.00
within norms 103.00 112.00 108.00 3.03
innodb update_with_key_prefix 37.00 +3.65% 1.40
outside norms 37.00 41.00 38.40 1.36
innodb wisc_benchmark 2.00 +23.08% 0.60
outside norms 2.00 3.00 2.60 0.49
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 13.00 +6.79% 0.95
within norms 12.00 21.00 13.95 2.06
innodb alter_table_drop 13.00 +5.73% 0.79
within norms 12.00 21.00 13.79 1.99
innodb connect 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
innodb connect+select_1_row 3.00 -14.00% -0.37
within norms 2.00 3.00 2.63 0.48
innodb connect+select_simple 2.00 +17.39% 0.42
within norms 2.00 3.00 2.42 0.49
innodb count 17.00 -11.00% -1.68
outside norms 13.00 18.00 15.32 1.62
innodb count_distinct 5.00 +21.49% 1.37
outside norms 5.00 8.00 6.37 0.98
innodb count_distinct_2 12.00 +9.88% 1.32
within norms 11.00 17.00 13.32 1.69
innodb count_distinct_big 23.00 -3.31% -0.74
within norms 19.00 24.00 22.26 1.65
innodb count_distinct_group 11.00 +9.91% 1.21
within norms 10.00 16.00 12.21 1.73
innodb count_distinct_group_on_key 8.00 +14.61% 1.37
within norms 8.00 14.00 9.37 1.66
innodb count_distinct_group_on_key_parts 10.00 +13.24% 1.53
within norms 10.00 14.00 11.53 1.53
innodb count_distinct_key_prefix 5.00 +3.06% 0.16
within norms 4.00 8.00 5.16 1.04
innodb count_group_on_key_parts 10.00 -0.53% -0.05
within norms 7.00 11.00 9.95 0.94
innodb count_on_key 88.00 -2.77% -2.37
within norms 73.00 107.00 85.63 6.91
innodb create+drop 34.00 -1.10% -0.37
within norms 23.00 45.00 33.63 6.56
innodb create_index 2.00 +9.52% 0.21
within norms 2.00 3.00 2.21 0.41
innodb create_key+drop 29.00 -5.15% -1.42
within norms 25.00 31.00 27.58 1.66
innodb create_MANY_tables 36.00 +9.28% 3.68
within norms 16.00 69.00 39.68 15.86
innodb create_table 2.00 -442.86% -1.63
outside norms 0.00 2.00 0.37 0.74
innodb delete_all_many_keys 269.00 -12.18% -29.21
outside norms 216.00 269.00 239.79 16.48
innodb delete_autocommit 3.00 +14.93% 0.53
outside norms 3.00 4.00 3.53 0.50
innodb delete_big 1.00 -171.43% -0.63
outside norms 0.00 1.00 0.37 0.48
innodb delete_big_many_keys 269.00 -12.21% -29.26
outside norms 216.00 269.00 239.74 16.52
innodb delete_commit 2.00 -31.03% -0.47
within norms 1.00 2.00 1.53 0.50
innodb delete_key 4.00 +29.63% 1.68
within norms 2.00 35.00 5.68 7.16
innodb delete_range 6.00 +4.20% 0.26
within norms 5.00 9.00 6.26 0.96
innodb delete_rollback 1.00 +32.14% 0.47
within norms 1.00 2.00 1.47 0.50
innodb drop_index 2.00 +20.83% 0.53
within norms 2.00 8.00 2.53 1.35
innodb drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
innodb drop_table_when_MANY_tables 15.00 +11.49% 1.95
within norms 14.00 23.00 16.95 2.82
innodb insert 109.00 +1.24% 1.37
within norms 96.00 124.00 110.37 7.29
innodb insert_autocommit 3.00 -1.79% -0.05
within norms 2.00 3.00 2.95 0.22
innodb insert_commit 1.00 +17.39% 0.21
within norms 1.00 2.00 1.21 0.41
innodb insert_duplicates 17.00 -13.33% -2.00
outside norms 13.00 17.00 15.00 1.08
innodb insert_key 212.00 +16.95% 43.26
within norms 156.00 518.00 255.26 81.35
innodb insert_many_fields 6.00 -15.15% -0.79
outside norms 4.00 6.00 5.21 0.61
innodb insert_rollback 2.00 -18.75% -0.32
within norms 1.00 2.00 1.68 0.46
innodb insert_select_1_key 3.00 +17.39% 0.63
within norms 3.00 6.00 3.63 0.98
innodb insert_select_2_keys 4.00 +20.00% 1.00
outside norms 4.00 7.00 5.00 0.92
innodb min_max 9.00 -14.77% -1.16
outside norms 6.00 9.00 7.84 0.87
innodb min_max_on_key 21.00 -1.27% -0.26
within norms 18.00 23.00 20.74 1.74
innodb multiple_value_insert 3.00 -11.76% -0.32
within norms 2.00 4.00 2.68 0.57
innodb once_prepared_select 23.00 +1.35% 0.32
within norms 21.00 27.00 23.32 1.52
innodb order_by_big 15.00 -1.42% -0.21
within norms 13.00 17.00 14.79 1.36
innodb order_by_big_key 15.00 -12.65% -1.68
outside norms 12.00 16.00 13.32 1.38
innodb order_by_big_key2 14.00 -11.76% -1.47
outside norms 11.00 14.00 12.53 1.09
innodb order_by_big_key_desc 14.00 -5.56% -0.74
within norms 11.00 16.00 13.26 1.41
innodb order_by_big_key_diff 13.00 -2.07% -0.26
within norms 11.00 15.00 12.74 1.33
innodb order_by_big_key_prefix 12.00 +0.87% 0.11
within norms 10.00 15.00 12.11 1.48
innodb order_by_key2_diff 1.00 +42.42% 0.74
outside norms 1.00 2.00 1.74 0.44
innodb order_by_key_prefix 1.00 -90.00% -0.47
within norms 0.00 1.00 0.53 0.50
innodb order_by_range 1.00 -26.67% -0.21
within norms 0.00 1.00 0.79 0.41
innodb outer_join 21.00 -17.35% -3.11
outside norms 15.00 21.00 17.89 2.25
innodb outer_join_found 21.00 -20.54% -3.58
outside norms 15.00 21.00 17.42 2.16
innodb outer_join_not_found 17.00 -12.15% -1.84
within norms 12.00 18.00 15.16 2.21
innodb outer_join_on_key 13.00 -9.29% -1.11
within norms 10.00 14.00 11.89 1.12
innodb prepared_select 33.00 -9.23% -2.79
outside norms 27.00 35.00 30.21 2.17
innodb select_1_row 3.00 -5.56% -0.16
within norms 2.00 3.00 2.84 0.36
innodb select_1_row_cache 2.00 +17.39% 0.42
within norms 2.00 3.00 2.42 0.49
innodb select_2_rows 2.00 +28.30% 0.79
outside norms 2.00 3.00 2.79 0.41
innodb select_big 13.00 -9.78% -1.16
outside norms 10.00 15.00 11.84 1.14
innodb select_big_str 1.00 +9.52% 0.11
within norms 1.00 2.00 1.11 0.31
innodb select_cache 67.00 -18.86% -10.63
outside norms 51.00 67.00 56.37 4.62
innodb select_cache2 70.00 -21.35% -12.32
outside norms 50.00 70.00 57.68 6.14
innodb select_column+column 3.00 -7.55% -0.21
within norms 2.00 3.00 2.79 0.41
innodb select_diff_key 1.00 -850.00% -0.89
outside norms 0.00 1.00 0.11 0.31
innodb select_distinct 4.00 +8.43% 0.37
within norms 4.00 5.00 4.37 0.48
innodb select_group 16.00 -0.33% -0.05
within norms 14.00 18.00 15.95 1.43
innodb select_group_when_MANY_tables 5.00 -6.74% -0.32
within norms 4.00 6.00 4.68 0.57
innodb select_join 1.00 -137.50% -0.58
outside norms 0.00 1.00 0.42 0.49
innodb select_key 53.00 -3.60% -1.84
within norms 49.00 58.00 51.16 2.11
innodb select_key2 59.00 -2.37% -1.37
within norms 54.00 63.00 57.63 2.72
innodb select_key2_return_key 63.00 -11.87% -6.68
outside norms 52.00 63.00 56.32 3.69
innodb select_key2_return_prim 64.00 -13.01% -7.37
outside norms 52.00 64.00 56.63 4.03
innodb select_key_prefix 55.00 +1.69% 0.95
within norms 55.00 65.00 55.95 2.33
innodb select_key_prefix_join 4.00 +20.00% 1.00
outside norms 4.00 6.00 5.00 0.73
innodb select_key_return_key 54.00 -5.56% -2.84
within norms 49.00 59.00 51.16 2.96
innodb select_many_fields 15.00 +8.06% 1.32
outside norms 15.00 18.00 16.32 0.92
innodb select_range 52.00 -11.64% -5.42
outside norms 42.00 52.00 46.58 3.45
innodb select_range_key2 8.00 -0.66% -0.05
within norms 6.00 10.00 7.95 0.83
innodb select_range_prefix 7.00 +6.34% 0.47
within norms 6.00 8.00 7.47 0.60
innodb select_simple 2.00 -31.03% -0.47
within norms 1.00 2.00 1.53 0.50
innodb select_simple_cache 1.00 +32.14% 0.47
within norms 1.00 2.00 1.47 0.50
innodb select_simple_join 0.00 +100.00% 0.53
outside norms 0.00 1.00 0.53 0.50
innodb update_autocommit 3.00 +8.06% 0.26
within norms 3.00 4.00 3.26 0.44
innodb update_big 37.00 +6.89% 2.74
within norms 34.00 63.00 39.74 7.14
innodb update_commit 2.00 -31.03% -0.47
within norms 1.00 2.00 1.53 0.50
innodb update_of_key 29.00 +3.84% 1.16
within norms 20.00 100.00 30.16 16.97
innodb update_of_key_big 21.00 +1.48% 0.32
within norms 17.00 27.00 21.32 2.99
innodb update_of_primary_key_many_keys 830.00 -9.26% -70.37
within norms 673.00 999.99 759.63 76.43
innodb update_rollback 2.00 -35.71% -0.53
outside norms 1.00 2.00 1.47 0.50
innodb update_with_key 107.00 +20.89% 28.26
within norms 103.00 598.00 135.26 109.14
innodb update_with_key_prefix 37.00 +21.98% 10.42
within norms 36.00 202.00 47.42 36.46
innodb wisc_benchmark 2.00 +24.00% 0.63
outside norms 2.00 3.00 2.63 0.48
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 13.00 -6.80% -0.83
within 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 17.00 -13.33% -2.00
outside norms 13.00 18.00 15.00 1.76
innodb count_distinct 5.00 +17.61% 1.07
outside norms 5.00 8.00 6.07 0.83
innodb count_distinct_2 12.00 +1.14% 0.14
within norms 11.00 16.00 12.14 1.38
innodb count_distinct_big 23.00 -7.75% -1.66
within norms 18.00 25.00 21.34 1.97
innodb count_distinct_group 11.00 +13.08% 1.66
outside norms 11.00 14.00 12.66 0.84
innodb count_distinct_group_on_key 8.00 +10.08% 0.90
within norms 8.00 11.00 8.90 1.12
innodb count_distinct_group_on_key_parts 10.00 +14.96% 1.76
outside norms 10.00 15.00 11.76 1.36
innodb count_distinct_key_prefix 5.00 -5.84% -0.28
within norms 4.00 6.00 4.72 0.69
innodb count_group_on_key_parts 10.00 -22.88% -1.86
outside norms 7.00 10.00 8.14 0.78
innodb count_on_key 88.00 -13.93% -10.76
outside norms 73.00 83.00 77.24 2.25
innodb create+drop 34.00 -74.20% -14.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 29.00 -28.59% -6.45
outside norms 21.00 23.00 22.55 0.56
innodb create_MANY_tables 36.00 -110.91% -18.93
outside norms 14.00 20.00 17.07 1.70
innodb create_table 2.00 -2799.98% -1.93
outside norms 0.00 1.00 0.07 0.25
innodb delete_all_many_keys 269.00 +9.50% 28.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 1.00 -262.50% -0.72
outside norms 0.00 1.00 0.28 0.45
innodb delete_big_many_keys 269.00 +9.47% 28.14
outside norms 239.00 345.00 297.14 21.37
innodb delete_commit 2.00 -48.72% -0.66
outside norms 1.00 2.00 1.34 0.48
innodb delete_key 4.00 -63.38% -1.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 15.00 -11.25% -1.52
outside norms 12.00 15.00 13.48 0.62
innodb insert 109.00 -20.19% -18.31
outside norms 88.00 93.00 90.69 1.37
innodb insert_autocommit 3.00 -16.00% -0.41
within norms 2.00 3.00 2.59 0.49
innodb insert_commit 1.00 +9.37% 0.10
within norms 1.00 2.00 1.10 0.30
innodb insert_duplicates 17.00 -32.53% -4.17
outside norms 12.00 14.00 12.83 0.53
innodb insert_key 212.00 +26.29% 75.62
outside norms 189.00 345.00 287.62 32.94
innodb insert_many_fields 6.00 -47.46% -1.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 4.00 +22.67% 1.17
outside norms 4.00 6.00 5.17 0.59
innodb min_max 9.00 -17.57% -1.34
outside norms 6.00 9.00 7.66 1.03
innodb min_max_on_key 21.00 -24.54% -4.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 23.00 -9.70% -2.03
outside norms 20.00 22.00 20.97 0.61
innodb order_by_big 15.00 -6.10% -0.86
within norms 12.00 15.00 14.14 0.94
innodb order_by_big_key 15.00 -20.83% -2.59
outside norms 11.00 14.00 12.41 1.19
innodb order_by_big_key2 14.00 -21.92% -2.52
outside norms 10.00 13.00 11.48 0.97
innodb order_by_big_key_desc 14.00 -8.56% -1.10
outside norms 12.00 14.00 12.90 0.92
innodb order_by_big_key_diff 13.00 -12.20% -1.41
outside norms 10.00 13.00 11.59 0.85
innodb order_by_big_key_prefix 12.00 -0.29% -0.03
within norms 11.00 13.00 11.97 0.85
innodb order_by_key2_diff 1.00 +14.71% 0.17
within norms 1.00 2.00 1.17 0.38
innodb order_by_key_prefix 1.00 -61.11% -0.38
within 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 21.00 -21.07% -3.66
outside norms 15.00 21.00 17.34 2.06
innodb outer_join_found 21.00 -24.54% -4.14
outside norms 14.00 21.00 16.86 2.19
innodb outer_join_not_found 17.00 -13.33% -2.00
outside norms 13.00 18.00 15.00 1.49
innodb outer_join_on_key 13.00 -8.65% -1.03
within norms 10.00 15.00 11.97 1.50
innodb prepared_select 33.00 -27.60% -7.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 2.00 +9.38% 0.21
within norms 2.00 3.00 2.21 0.41
innodb select_big 13.00 -11.87% -1.38
outside norms 10.00 13.00 11.62 1.00
innodb select_big_str 1.00 +9.76% 0.11
within norms 0.00 2.00 1.11 0.32
innodb select_cache 67.00 -16.35% -9.41
outside norms 51.00 71.00 57.59 5.41
innodb select_cache2 70.00 -23.10% -13.14
outside norms 51.00 68.00 56.86 4.88
innodb select_column+column 3.00 -12.99% -0.34
within norms 2.00 3.00 2.66 0.48
innodb select_diff_key 1.00 -480.00% -0.83
outside 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 16.00 -5.22% -0.79
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 53.00 -19.05% -8.48
outside norms 40.00 50.00 44.52 2.50
innodb select_key2 59.00 -19.73% -9.72
outside norms 46.00 54.00 49.28 2.41
innodb select_key2_return_key 63.00 -34.24% -16.07
outside norms 42.00 51.00 46.93 2.32
innodb select_key2_return_prim 64.00 -32.19% -15.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 54.00 -23.89% -10.41
outside norms 39.00 49.00 43.59 2.65
innodb select_many_fields 15.00 +8.81% 1.45
outside norms 15.00 17.00 16.45 0.62
innodb select_range 52.00 -6.42% -3.14
outside 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 37.00 -2.68% -0.97
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 29.00 -50.45% -9.72
outside norms 19.00 20.00 19.28 0.45
innodb update_of_key_big 21.00 -14.69% -2.69
outside norms 16.00 20.00 18.31 1.18
innodb update_of_primary_key_many_keys 830.00 -3.20% -25.77
within norms 661.00 874.00 804.23 40.50
innodb update_rollback 2.00 -41.46% -0.59
outside norms 1.00 2.00 1.41 0.49
innodb update_with_key 107.00 -16.61% -15.24
outside norms 90.00 93.00 91.76 0.97
innodb update_with_key_prefix 37.00 -4.99% -1.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:
1720.1.3: Patrick Crews 2010-08-19 [merge] Merge Monty to make intltool
optional
1719.1.1: Monty Taylor 2010-08-19 _actually_ make OSX work with no
intltool. Sorry.
1720.1.2: Patrick Crews 2010-08-19 Updated pbxt tests due to inclusion of
COLLATE info in SHOW CREATE TABLE output now. Only re-recorded .result files
1720.1.1: Brian Aker 2010-08-19 [merge] Merging Stewart's show create table
patch.
1638.10.120: Stewart Smith 2010-08-17 [merge] merge trunk
1638.10.119: Stewart Smith 2010-08-17 make innobase plugin not directly
access the mysql_query_str for CREATE TABLE, and instead use the table protobuf
message and statement_transform to get a SQL string to pass to innobase for
parsing to get the foreign keys out of it.
1638.10.118: Stewart Smith 2010-08-17 fix naming of constraints to be more
standards compliant and correct. the index_name part of it just doesn't exist
in SQL-99
1638.10.117: Stewart Smith 2010-08-16 update innodb test for auto_increment
behaviour
1638.10.116: Stewart Smith 2010-08-16 only display AUTO_INCREMENT value if
explicitly set by user (and preserve across ALTER TABLE).
1638.10.115: Stewart Smith 2010-08-11 remove auto_increment in TableOptions
in Table protobuf message. It was unused and confusing
1638.10.114: Stewart Smith 2010-08-10 when creating a CreateField from a
Field, a auto_incremen column should not have a default value of 0 as that's
not magic.
1638.10.113: Stewart Smith 2010-08-10 [merge] link fix for
libdrizzled_message
1638.10.112: Stewart Smith 2010-08-10 [merge] fix linking of
drizzled/message lib and libcharset
1638.10.111: Stewart Smith 2010-08-09 fix drizzledump-max test result for
having explicit COLLATE in SHOW CREATE TABLE
1638.10.110: Stewart Smith 2010-08-09 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.109: Stewart Smith 2010-08-05 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.108: Stewart Smith 2010-08-04 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.107: Stewart Smith 2010-08-03 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.106: Stewart Smith 2010-08-03 fix null_values transaction_log
CREATE TABLE result
1638.10.105: Stewart Smith 2010-08-03 fix filesystem_engine test case
results for CREATE TABLE out of proto
1638.10.104: Stewart Smith 2010-08-02 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.103: Stewart Smith 2010-07-30 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.102: Stewart Smith 2010-07-29 [merge] merge trunk
1638.10.101: Stewart Smith 2010-07-28 [merge] merge test fixes for
DATE/DATETIME default
1638.10.100: Stewart Smith 2010-07-28 [merge] merge fix for default value
of DATE in proto
1638.10.99: Stewart Smith 2010-07-28 fix type_datetime.result for explicit
COLLATE in SHOW CREATE TABLE
1638.10.98: Stewart Smith 2010-07-28 update transaction_log/update.result
to reflect correct CREATE TABLE statements. My code is correct, old
statement_transform wasn't reproducing the CREATE TABLE statement correctly.
1638.10.97: Stewart Smith 2010-07-28 [merge] merge in table comment fix
1638.10.96: Stewart Smith 2010-07-28 fix show_check test result for
explicit COLLATE in SHOW CREATE TABLE
1638.10.95: Stewart Smith 2010-07-28 fix archive_aio_posix test result for
explicit COLLATE in SHOW CREATE TABLE
1638.10.94: Stewart Smith 2010-07-28 [merge] merge fix for RENAME TABLE for
ARCHIVE
1638.10.93: Stewart Smith 2010-07-28 ARCHIVE test result for explicit
COLLATE in SHOW CREATE TABLE
1638.10.92: Stewart Smith 2010-07-27 even more fixes due to SHOW CREATE
TABLE now actually working
1638.10.91: Stewart Smith 2010-07-27 test result fixes for the dictionary
suites: table names should be upper case as well as having explicit COLLATE in
SHOW CREATE TABLE
1638.10.90: Stewart Smith 2010-07-27 blackhole create_max_fields test to
have explicit COLLATE in SHOW CREATE TABLE
1638.10.89: Stewart Smith 2010-07-27 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.88: Stewart Smith 2010-07-27 fix SHOW CREATE TABLE tests for
explicit COLLATE in CREATE TABLE
1638.10.87: Stewart Smith 2010-07-27 fix SHOW CREATE TABLE tests for
explicit COLLATE in CREATE TABLE
1638.10.86: Stewart Smith 2010-07-27 fix some more tests for explicit
COLLATE in CREATE TABLE, including transaction_log whitespace changes
1638.10.85: Stewart Smith 2010-07-27 explicit COLLATE in CREATE TABLE test
result fixes for innodb_mysql test
1638.10.84: Stewart Smith 2010-07-27 some CREATE TABLE fixes for
transaction_log tests
1638.10.83: Stewart Smith 2010-07-26 fix some more tests for explicit
COLLATE in CREATE TABLE
1638.10.82: Stewart Smith 2010-07-26 fix some tests for explicit COLLATE in
CREATE TABLE
1638.10.81: Stewart Smith 2010-07-26 fix key.result for explicit COLLATE in
CREATE TABLE
1638.10.80: Stewart Smith 2010-07-26 fix storing and manipulating foreign
keys in the proto around ALTER TABLE, CREATE TABLE and ALTER TABLE ADD/DROP
FOREIGN KEY. We also (mostly) emulate the naming of innodb foreign keys in the
upper layer.
1638.10.79: Stewart Smith 2010-07-26 restore the foreign key names to SHOW
CREATE TABLE in the innodb test result file.
1638.10.78: Stewart Smith 2010-07-26 separate out adding the foreign key to
the table protobuf message from mysql_prepare_create_table and call a function
to do it directly from the parser where we set up the foreign key structures
1638.10.77: Stewart Smith 2010-07-26 table_ident.h was missing a dependency
on session.h for: ./drizzled/table_ident.h:53: error: âempty_c_stringâ was
not declared in this scope
1638.10.76: Stewart Smith 2010-07-21 innodb.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.75: Stewart Smith 2010-07-21 heap.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.74: Stewart Smith 2010-07-21 func_system.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.73: Stewart Smith 2010-07-21 func_misc.result with explicit COLLATE
in SHOW CREATE TABLE
1638.10.72: Stewart Smith 2010-07-21 func_math.result with explicit COLLATE
in SHOW CREATE TABLE
1638.10.71: Stewart Smith 2010-07-21 func_group.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.70: Stewart Smith 2010-07-21 func_gconcat.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.69: Stewart Smith 2010-07-21 foreign_key.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.68: Stewart Smith 2010-07-21 drizzledump.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.67: Stewart Smith 2010-07-21 default_collation.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.66: Stewart Smith 2010-07-21 default.result with explicit COLLATE
in SHOW CREATE TABLE
1638.10.65: Stewart Smith 2010-07-21 ctype_utf8.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.64: Stewart Smith 2010-07-21 create_no_windows.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.63: Stewart Smith 2010-07-21 create.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.62: Stewart Smith 2010-07-21 constraint.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.61: Stewart Smith 2010-07-21 comment_talbe.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.60: Stewart Smith 2010-07-21 comment_index.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.59: Stewart Smith 2010-07-21 comment_column.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.58: Stewart Smith 2010-07-21 case.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.57: Stewart Smith 2010-07-21 binary.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.56: Stewart Smith 2010-07-21 bigint.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.55: Stewart Smith 2010-07-21 auto_increment.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.54: Stewart Smith 2010-07-21 alter_table.result: COLLATE and ENGINE
in same line for SHOW CREATE TABLE
1638.10.53: Stewart Smith 2010-07-21 no newline before COLLATE in SHOW
CREATE TABLE
1638.10.52: Stewart Smith 2010-07-21 alter_table test: COLLATE is now
explicit in SHOW CREATE TABLE as table proto has no way to find out if it was
an explicit option or not.
1638.10.51: Stewart Smith 2010-07-21 show_create_table_basic test: COLLATE
is now explicit in SHOW CREATE TABLE as table proto has no way to find out if
it was an explicit option or not.
1638.10.50: Stewart Smith 2010-07-21 revert patch that removse explicitly
setting collation for talbe_function tables.
1638.10.49: Stewart Smith 2010-07-20 [merge] merge trunk
1638.10.48: Stewart Smith 2010-07-19 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.47: Stewart Smith 2010-07-13 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.46: Stewart Smith 2010-07-13 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.45: Stewart Smith 2010-07-12 don't have internal innodb foreign key
names in FOREIGN KEY clauses in innodb.result
1638.10.44: Stewart Smith 2010-07-12 fix spaces in CREATE TABLE ... FOREIGN
KEY statement
1638.10.43: Stewart Smith 2010-07-12 foreign_key test result update: don't
have innodb internal foreign key names in the result (now that we're using
statement_transform for foreign key)
1638.10.42: Stewart Smith 2010-07-12 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.41: Stewart Smith 2010-07-06 [merge] Merged
varchar-text-keylength-in-proto-as-characters-not-bytes into
show-create-table-using-table-message.
1638.10.40: Stewart Smith 2010-07-05 [merge] Merged
bug600635-table-proto-default-null-false into
show-create-table-using-table-message.
1638.10.39: Stewart Smith 2010-07-02 correctly have auto_increment value in
drizzledump test result
1638.10.38: Stewart Smith 2010-07-02 correctly have default COLLATE for
table in SHOW CREATE TABLE result for default_collation test result.
1638.10.37: Stewart Smith 2010-07-02 fix result of default test: varbinary
defaults are now represented as hex in SHOW CREATE TABLE and the COLLATE for
the table wasn't being shown.
1638.10.36: Stewart Smith 2010-07-02 correct the create.result file to show
the COLLATE clause at teh end of the SHOW CREATE TABLE output. Previously, this
wasn't being displayed due to some kind of bug.
1638.10.35: Stewart Smith 2010-07-02 table_function doesn't need to
explicitly set collation for its tables as the default (utf8_general_ci) is
exactly what we want.
1638.10.34: Stewart Smith 2010-07-02 [merge] Merged
bug600635-table-proto-default-null-false into
show-create-table-using-table-message.
1638.10.33: Stewart Smith 2010-07-01 index comments in statement_transform
1638.10.32: Stewart Smith 2010-07-01 statement transform for create table:
formatting of decimal default value doesn't matter
1638.10.31: Stewart Smith 2010-07-01 statement_transform for CREATE TABLE:
only print DEFAULT NULL if default_null is actually set, not just if the proto
has it.
1638.10.30: Stewart Smith 2010-07-01 get USING (BTREE|HASH) index type
syntax correct for statement_transform in CREATE TABLE.
1638.10.29: Stewart Smith 2010-07-01 fix collation detection for BLOB/TEXT
in statement_transform for CREATE TABLE. Also, the DEFAULT NULL for BLOB
columns is implicit, so don't print it.
1638.10.28: Stewart Smith 2010-07-01 fix a lot of quoting and escaping of
things in SHOW CREATE TABLE in statement_transform
1638.10.27: Stewart Smith 2010-07-01 [merge] Merged
bug600088-multibyte-comments-in-show-create into
show-create-table-using-table-message.
1638.10.26: Stewart Smith 2010-06-30 use length of create table string in
appending to packet.
1638.10.25: Stewart Smith 2010-06-30 fix table comment formatting in
statement_transform to have SHOW CREATE work with a table comment
1638.10.24: Stewart Smith 2010-06-30 fix display of VARBINARY default
values in SHOW CREATE TABLE. Always use printable characters by encoding in hex.
1638.10.23: Stewart Smith 2010-06-30 add SHOW CREATE TABLE test for
VARBINARY columns (especially with default values).
1638.10.22: Stewart Smith 2010-06-30 [merge] Merged
use-CURRENT_TIMESTAMP-in-proto into show-create-table-using-table-message.
1638.10.21: Stewart Smith 2010-06-30 [merge] Merged
use-CURRENT_TIMESTAMP-in-proto into show-create-table-using-table-message.
1638.10.20: Stewart Smith 2010-06-30 present DEFAULT and ON UPDATE
correctly in statement_transform
1638.10.19: Stewart Smith 2010-06-30 [merge] Merged
table-proto-default-update-expression into
show-create-table-using-table-message.
1638.10.18: Stewart Smith 2010-06-29 [merge] merge
1638.10.17: Stewart Smith 2010-06-29 fix SHOW CREATE TABLE
(statement_transform) for auto_increment, including the (now correct)
auto_increment test result.
1638.10.16: Stewart Smith 2010-06-29 fix up AUTO_INCREMENT must be after
NOT NULL in statement_transform
1638.10.15: Stewart Smith 2010-06-29 TIMESTAMP fields are default NOT NULL
for some bonghits reason, so we get to have explicit NULLability.
1638.10.14: Stewart Smith 2010-06-28 if a DOUBLE column has scale and
precision, display them
1638.10.13: Stewart Smith 2010-06-28 NOT NULL comes after COLLATE in CREATE
TABLE
1638.10.12: Stewart Smith 2010-06-28 fix the bonghits quoting rules in
field CREATE TABLE definitions for quotes around the identifier, comment and
default value.
1638.10.11: Stewart Smith 2010-06-28 fix varchar/varbinary and blob/text
for statement_transform of table definition
1638.10.10: Stewart Smith 2010-06-28 fix statement_transform for producing
list of engine options
1638.10.9: Stewart Smith 2010-06-28 [merge] merge
1638.10.8: Stewart Smith 2010-06-28 fix DEFAULT NULL and NOT NULL for
statement_transform
1638.10.7: Stewart Smith 2010-06-28 [merge] Merged
default-collation-in-table-message into show-create-table-using-table-message.
1638.10.6: Stewart Smith 2010-06-28 statement_transform: ENGINE clause of
CREATE TABLE doesn't have spaces around equals sign
1638.10.5: Stewart Smith 2010-06-28 statement_transform: only print index
name iff it's not PRIMARY for a pkey. Also get indenting correct for index
names.
1638.10.4: Stewart Smith 2010-06-28 statement_transform for CREATE TABLE:
field types are lower case.
1638.10.3: Stewart Smith 2010-06-28 statement_transform for CREATE TABLE:
fields are indented by 2 spaces
1638.10.2: Stewart Smith 2010-06-28 for store_create_info() (called in SHOW
CREATE TABLE code path) call transformTableDefinitionToSql() in
statement_transform lib instead of doing manual things on Table. This is the
initial step in getting SHOW CREATE TABLE to be run from proto.
1638.10.1: Stewart Smith 2010-06-28 add really simple SHOW CREATE TABLE
test to help with migrating SHOW CREATE to use proto
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
