=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 621
RUN DATE: 2010-11-03T08:05:34.397864
SERVER: drizzled
VERSION: staging
REVISION: 1900
COMMENT: 1900: Brian Aker 2010-11-02 [merge] Merge in Joe's transaction id
code.
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 39.00 -47.73% -12.60
15.00 39.00 26.40 9.56
innodb alter_table_drop 30.00 -44.23% -9.20
13.00 30.00 20.80 6.85
innodb connect+select_1_row 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb connect+select_simple 3.00 -36.36% -0.80
2.00 3.00 2.20 0.40
innodb count 17.00 -10.39% -1.60
13.00 17.00 15.40 1.96
innodb count_distinct 6.00 -0.00% 0.00
5.00 7.00 6.00 0.63
innodb count_distinct_2 12.00 +1.64% 0.20
11.00 15.00 12.20 1.47
innodb count_distinct_big 23.00 -6.48% -1.40
19.00 23.00 21.60 1.50
innodb count_distinct_group 14.00 -4.48% -0.60
12.00 15.00 13.40 1.20
innodb count_distinct_group_on_key 8.00 +9.09% 0.80
8.00 10.00 8.80 0.75
innodb count_distinct_group_on_key_parts 14.00 -12.90% -1.60
10.00 14.00 12.40 1.36
innodb count_distinct_key_prefix 5.00 +3.85% 0.20
5.00 6.00 5.20 0.40
innodb count_group_on_key_parts 10.00 +1.96% 0.20
10.00 11.00 10.20 0.40
innodb count_on_key 92.00 -3.60% -3.20
84.00 92.00 88.80 2.79
innodb create+drop 59.00 -26.61% -12.40
26.00 65.00 46.60 13.95
innodb create_index 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb create_key+drop 41.00 -21.30% -7.20
27.00 41.00 33.80 6.27
innodb create_MANY_tables 77.00 -15.27% -10.20
34.00 92.00 66.80 19.81
innodb create_table 1.00 -400.00% -0.80
0.00 1.00 0.20 0.40
innodb delete_all_many_keys 1273.00 -50.01% -424.40
304.00 1708.00 848.60 556.48
innodb delete_autocommit 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb delete_big 1.00 -66.67% -0.40
0.00 1.00 0.60 0.49
innodb delete_big_many_keys 1273.00 -50.01% -424.40
304.00 1708.00 848.60 556.48
innodb delete_commit 2.00 -66.67% -0.80
1.00 2.00 1.20 0.40
innodb delete_key 4.00 -0.00% 0.00
2.00 7.00 4.00 1.67
innodb delete_range 9.00 -15.38% -1.20
6.00 9.00 7.80 1.47
innodb delete_rollback 2.00 -42.86% -0.60
1.00 2.00 1.40 0.49
innodb drop_index 6.00 -87.50% -2.80
2.00 6.00 3.20 1.47
innodb drop_table 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb drop_table_when_MANY_tables 30.00 -19.05% -4.80
18.00 32.00 25.20 5.46
innodb insert 130.00 -15.04% -17.00
101.00 130.00 113.00 11.35
innodb insert_autocommit 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb insert_commit 1.00 +16.67% 0.20
1.00 2.00 1.20 0.40
innodb insert_duplicates 17.00 -13.33% -2.00
13.00 17.00 15.00 1.41
innodb insert_key 685.00 -43.13% -206.40
201.00 801.00 478.60 229.84
innodb insert_many_fields 12.00 -50.00% -4.00
5.00 12.00 8.00 2.45
innodb insert_rollback 2.00 -25.00% -0.40
1.00 2.00 1.60 0.49
innodb insert_select_1_key 6.00 -57.89% -2.20
2.00 6.00 3.80 1.33
innodb insert_select_2_keys 8.00 -11.11% -0.80
4.00 11.00 7.20 2.48
innodb min_max 9.00 -28.57% -2.00
6.00 9.00 7.00 1.10
innodb min_max_on_key 21.00 -11.70% -2.20
17.00 21.00 18.80 1.47
innodb multiple_value_insert 15.00 -82.93% -6.80
3.00 15.00 8.20 4.87
innodb once_prepared_select 26.00 -9.24% -2.20
23.00 26.00 23.80 1.17
innodb order_by_big 13.00 +5.80% 0.80
13.00 15.00 13.80 0.75
innodb order_by_big_key 14.00 -9.38% -1.20
12.00 14.00 12.80 0.98
innodb order_by_big_key2 10.00 +16.67% 2.00
10.00 13.00 12.00 1.26
innodb order_by_big_key_desc 15.00 -7.14% -1.00
13.00 15.00 14.00 0.63
innodb order_by_big_key_diff 11.00 +5.17% 0.60
11.00 13.00 11.60 0.80
innodb order_by_big_key_prefix 13.00 -3.17% -0.40
11.00 13.00 12.60 0.80
innodb order_by_key2_diff 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb order_by_key_prefix 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb order_by_range 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb outer_join 17.00 +14.14% 2.80
17.00 22.00 19.80 1.94
innodb outer_join_found 16.00 +15.79% 3.00
16.00 21.00 19.00 2.10
innodb outer_join_not_found 14.00 +15.66% 2.60
14.00 18.00 16.60 1.74
innodb outer_join_on_key 13.00 +1.52% 0.20
12.00 14.00 13.20 0.75
innodb prepared_select 29.00 +8.23% 2.60
29.00 33.00 31.60 1.36
innodb select_1_row 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb select_1_row_cache 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb select_2_rows 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb select_big 13.00 -14.04% -1.60
10.00 13.00 11.40 1.36
innodb select_big_str 2.00 -66.67% -0.80
1.00 2.00 1.20 0.40
innodb select_cache 52.00 +12.16% 7.20
52.00 66.00 59.20 4.96
innodb select_cache2 55.00 +6.46% 3.80
52.00 68.00 58.80 6.43
innodb select_column+column 2.00 +23.08% 0.60
2.00 3.00 2.60 0.49
innodb select_diff_key 1.00 -66.67% -0.40
0.00 1.00 0.60 0.49
innodb select_distinct 5.00 -4.17% -0.20
4.00 5.00 4.80 0.40
innodb select_group 14.00 +2.78% 0.40
13.00 16.00 14.40 1.02
innodb select_group_when_MANY_tables 10.00 -72.41% -4.20
4.00 10.00 5.80 2.23
innodb select_join 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb select_key 50.00 +0.40% 0.20
48.00 53.00 50.20 1.72
innodb select_key2 61.00 -0.99% -0.60
59.00 62.00 60.40 1.20
innodb select_key2_return_key 55.00 +3.85% 2.20
55.00 58.00 57.20 1.17
innodb select_key2_return_prim 57.00 +2.73% 1.60
57.00 60.00 58.60 1.36
innodb select_key_prefix 56.00 +6.35% 3.80
56.00 62.00 59.80 2.14
innodb select_key_prefix_join 4.00 +4.76% 0.20
4.00 5.00 4.20 0.40
innodb select_key_return_key 49.00 -2.08% -1.00
45.00 50.00 48.00 1.79
innodb select_many_fields 13.00 -3.17% -0.40
12.00 13.00 12.60 0.49
innodb select_range 53.00 -11.81% -5.60
44.00 53.00 47.40 3.83
innodb select_range_key2 9.00 -2.27% -0.20
8.00 9.00 8.80 0.40
innodb select_range_prefix 8.00 +2.44% 0.20
8.00 9.00 8.20 0.40
innodb select_simple 1.00 +44.44% 0.80
1.00 2.00 1.80 0.40
innodb select_simple_cache 2.00 -66.67% -0.80
1.00 2.00 1.20 0.40
innodb select_simple_join 1.00 -66.67% -0.40
0.00 1.00 0.60 0.49
innodb TOTALS 8416.00 -39.90% -2400.20
3147.00 9999.99 6015.80 2,742.66
innodb update_autocommit 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb update_big 66.00 -20.00% -11.00
36.00 74.00 55.00 15.59
innodb update_commit 1.00 +28.57% 0.40
1.00 2.00 1.40 0.49
innodb update_of_key 49.00 -36.11% -13.00
25.00 49.00 36.00 9.92
innodb update_of_key_big 31.00 -15.67% -4.20
19.00 32.00 26.80 5.00
innodb update_of_primary_key_many_keys 3350.00 -48.86% -1099.60
820.00 4554.00 2250.40 1,473.35
innodb update_rollback 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb update_with_key 119.00 -4.02% -4.60
102.00 126.00 114.40 8.11
innodb update_with_key_prefix 45.00 -10.29% -4.20
37.00 45.00 40.80 2.71
innodb wisc_benchmark 3.00 -36.36% -0.80
2.00 3.00 2.20 0.40
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 39.00 -69.57% -16.00
15.00 39.00 23.00 7.83
innodb alter_table_drop 30.00 -56.13% -10.79
13.00 30.00 19.21 5.56
innodb connect+select_1_row 3.00 -5.00% -0.14
2.00 3.00 2.86 0.35
innodb connect+select_simple 3.00 -23.53% -0.57
2.00 3.00 2.43 0.49
innodb count 17.00 -20.81% -2.93
13.00 17.00 14.07 1.58
innodb count_distinct 6.00 +2.33% 0.14
5.00 8.00 6.14 0.74
innodb count_distinct_2 12.00 +1.18% 0.14
11.00 15.00 12.14 1.46
innodb count_distinct_big 23.00 -10.27% -2.14
19.00 24.00 20.86 1.46
innodb count_distinct_group 14.00 -12.64% -1.57
10.00 15.00 12.43 1.59
innodb count_distinct_group_on_key 8.00 +8.94% 0.79
8.00 11.00 8.79 0.94
innodb count_distinct_group_on_key_parts 14.00 -19.51% -2.29
10.00 14.00 11.71 1.44
innodb count_distinct_key_prefix 5.00 +1.41% 0.07
4.00 6.00 5.07 0.70
innodb count_group_on_key_parts 10.00 -2.94% -0.29
8.00 11.00 9.71 0.80
innodb count_on_key 92.00 -5.40% -4.71
82.00 94.00 87.29 3.95
innodb create+drop 59.00 -53.82% -20.64
25.00 65.00 38.36 11.08
innodb create_index 3.00 -10.53% -0.29
1.00 4.00 2.71 0.80
innodb create_key+drop 41.00 -36.67% -11.00
26.00 41.00 30.00 4.83
innodb create_MANY_tables 77.00 -45.48% -24.07
29.00 92.00 52.93 18.05
innodb create_table 1.00 -366.67% -0.79
0.00 1.00 0.21 0.41
innodb delete_all_many_keys 1273.00 -146.64% -756.86
290.00 1708.00 516.14 415.19
innodb delete_autocommit 4.00 -16.67% -0.57
3.00 4.00 3.43 0.49
innodb delete_big 1.00 -180.00% -0.64
0.00 1.00 0.36 0.48
innodb delete_big_many_keys 1273.00 -146.64% -756.86
290.00 1708.00 516.14 415.19
innodb delete_commit 2.00 -55.56% -0.71
1.00 2.00 1.29 0.45
innodb delete_key 4.00 -19.15% -0.64
2.00 7.00 3.36 1.17
innodb delete_range 9.00 -28.57% -2.00
5.00 9.00 7.00 1.20
innodb delete_rollback 2.00 -40.00% -0.57
1.00 2.00 1.43 0.49
innodb drop_index 6.00 -110.00% -3.14
2.00 6.00 2.86 1.06
innodb drop_table 0.00 +100.00% 0.14
0.00 1.00 0.14 0.35
innodb drop_table_when_MANY_tables 30.00 -43.84% -9.14
14.00 32.00 20.86 5.46
innodb insert 130.00 -22.97% -24.29
100.00 130.00 105.71 8.79
innodb insert_autocommit 3.00 -2.44% -0.07
2.00 3.00 2.93 0.26
innodb insert_commit 1.00 +22.22% 0.29
1.00 2.00 1.29 0.45
innodb insert_duplicates 17.00 -17.24% -2.50
13.00 17.00 14.50 0.98
innodb insert_key 685.00 -111.28% -360.79
201.00 801.00 324.21 180.65
innodb insert_many_fields 12.00 -68.00% -4.86
5.00 12.00 7.14 1.96
innodb insert_rollback 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb insert_select_1_key 6.00 -58.49% -2.21
2.00 6.00 3.79 0.94
innodb insert_select_2_keys 8.00 -34.94% -2.07
4.00 11.00 5.93 2.05
innodb min_max 9.00 -36.96% -2.43
6.00 9.00 6.57 0.82
innodb min_max_on_key 21.00 -12.64% -2.36
17.00 21.00 18.64 1.23
innodb multiple_value_insert 15.00 -172.73% -9.50
2.00 15.00 5.50 3.66
innodb once_prepared_select 26.00 -9.31% -2.21
23.00 26.00 23.79 0.86
innodb order_by_big 13.00 +4.71% 0.64
12.00 15.00 13.64 1.17
innodb order_by_big_key 14.00 -11.36% -1.43
11.00 14.00 12.57 1.05
innodb order_by_big_key2 10.00 +14.63% 1.71
10.00 13.00 11.71 1.22
innodb order_by_big_key_desc 15.00 -14.13% -1.86
11.00 15.00 13.14 1.30
innodb order_by_big_key_diff 11.00 +4.94% 0.57
10.00 13.00 11.57 1.18
innodb order_by_big_key_prefix 13.00 -5.81% -0.71
11.00 13.00 12.29 0.96
innodb order_by_key2_diff 1.00 +22.22% 0.29
1.00 2.00 1.29 0.45
innodb order_by_key_prefix 1.00 -7.69% -0.07
0.00 1.00 0.93 0.26
innodb order_by_range 1.00 -16.67% -0.14
0.00 1.00 0.86 0.35
innodb outer_join 17.00 +11.85% 2.29
17.00 23.00 19.29 2.25
innodb outer_join_found 16.00 +13.18% 2.43
16.00 22.00 18.43 2.16
innodb outer_join_not_found 14.00 +14.41% 2.36
14.00 19.00 16.36 1.91
innodb outer_join_on_key 13.00 -0.55% -0.07
11.00 15.00 12.93 1.22
innodb prepared_select 29.00 +9.58% 3.07
29.00 33.00 32.07 1.03
innodb select_1_row 3.00 -7.69% -0.21
2.00 3.00 2.79 0.41
innodb select_1_row_cache 2.00 +20.00% 0.50
2.00 3.00 2.50 0.50
innodb select_2_rows 3.00 -5.00% -0.14
2.00 3.00 2.86 0.35
innodb select_big 13.00 -15.19% -1.71
10.00 14.00 11.29 1.22
innodb select_big_str 2.00 -75.00% -0.86
1.00 2.00 1.14 0.35
innodb select_cache 52.00 +10.57% 6.14
52.00 66.00 58.14 4.85
innodb select_cache2 55.00 +7.12% 4.21
52.00 68.00 59.21 5.89
innodb select_column+column 2.00 +22.22% 0.57
2.00 3.00 2.57 0.49
innodb select_diff_key 1.00 -133.33% -0.57
0.00 1.00 0.43 0.49
innodb select_distinct 5.00 -11.11% -0.50
4.00 5.00 4.50 0.50
innodb select_group 14.00 +7.55% 1.14
13.00 18.00 15.14 1.51
innodb select_group_when_MANY_tables 10.00 -91.78% -4.79
4.00 10.00 5.21 1.61
innodb select_join 1.00 -40.00% -0.29
0.00 1.00 0.71 0.45
innodb select_key 50.00 -1.89% -0.93
44.00 53.00 49.07 2.19
innodb select_key2 61.00 -0.12% -0.07
59.00 63.00 60.93 1.16
innodb select_key2_return_key 55.00 +5.06% 2.93
55.00 59.00 57.93 1.10
innodb select_key2_return_prim 57.00 +3.51% 2.07
57.00 62.00 59.07 1.67
innodb select_key_prefix 56.00 +7.00% 4.21
56.00 62.00 60.21 1.42
innodb select_key_prefix_join 4.00 +11.11% 0.50
4.00 5.00 4.50 0.50
innodb select_key_return_key 49.00 -2.54% -1.21
44.00 52.00 47.79 2.24
innodb select_many_fields 13.00 -2.25% -0.29
12.00 13.00 12.71 0.45
innodb select_range 53.00 -12.77% -6.00
43.00 53.00 47.00 3.40
innodb select_range_key2 9.00 -4.13% -0.36
8.00 9.00 8.64 0.48
innodb select_range_prefix 8.00 +2.61% 0.21
7.00 9.00 8.21 0.56
innodb select_simple 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb select_simple_cache 2.00 -27.27% -0.43
1.00 2.00 1.57 0.49
innodb select_simple_join 1.00 -100.00% -0.50
0.00 1.00 0.50 0.50
innodb TOTALS 8416.00 -95.68% -4115.14
3076.00 9999.99 4300.86 2,081.97
innodb update_autocommit 4.00 -19.15% -0.64
3.00 4.00 3.36 0.48
innodb update_big 66.00 -37.70% -18.07
35.00 74.00 47.93 12.76
innodb update_commit 1.00 +33.33% 0.50
1.00 2.00 1.50 0.50
innodb update_of_key 49.00 -74.11% -20.86
22.00 49.00 28.14 8.39
innodb update_of_key_big 31.00 -38.66% -8.64
16.00 32.00 22.36 5.18
innodb update_of_primary_key_many_keys 3350.00 -144.82% -1981.64
796.00 4554.00 1368.36 1,099.83
innodb update_rollback 2.00 -21.74% -0.36
1.00 2.00 1.64 0.48
innodb update_with_key 119.00 -9.97% -10.79
100.00 126.00 108.21 6.94
innodb update_with_key_prefix 45.00 -16.88% -6.50
36.00 45.00 38.50 2.44
innodb wisc_benchmark 3.00 -20.00% -0.50
2.00 4.00 2.50 0.63
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 39.00 -220.40% -26.83
11.00 14.00 12.17 0.87
innodb alter_table_drop 30.00 -162.84% -18.59
10.00 14.00 11.41 1.07
innodb connect+select_1_row 3.00 -27.94% -0.66
2.00 3.00 2.34 0.48
innodb connect+select_simple 3.00 -52.63% -1.03
1.00 2.00 1.97 0.18
innodb count 17.00 -13.33% -2.00
13.00 18.00 15.00 1.76
innodb count_distinct 6.00 +1.14% 0.07
5.00 8.00 6.07 0.83
innodb count_distinct_2 12.00 +1.14% 0.14
11.00 16.00 12.14 1.38
innodb count_distinct_big 23.00 -7.75% -1.66
18.00 25.00 21.34 1.97
innodb count_distinct_group 14.00 -10.63% -1.34
11.00 14.00 12.66 0.84
innodb count_distinct_group_on_key 8.00 +10.08% 0.90
8.00 11.00 8.90 1.12
innodb count_distinct_group_on_key_parts 14.00 -19.06% -2.24
10.00 15.00 11.76 1.36
innodb count_distinct_key_prefix 5.00 -5.84% -0.28
4.00 6.00 4.72 0.69
innodb count_group_on_key_parts 10.00 -22.88% -1.86
7.00 10.00 8.14 0.78
innodb count_on_key 92.00 -19.11% -14.76
73.00 83.00 77.24 2.25
innodb create+drop 59.00 -202.30% -39.48
19.00 21.00 19.52 0.56
innodb create_index 3.00 -58.18% -1.10
1.00 3.00 1.90 0.48
innodb create_key+drop 41.00 -81.80% -18.45
21.00 23.00 22.55 0.56
innodb create_MANY_tables 77.00 -351.11% -59.93
14.00 20.00 17.07 1.70
innodb create_table 1.00 -1349.99% -0.93
0.00 1.00 0.07 0.25
innodb delete_all_many_keys 1273.00 -328.27% -975.76
239.00 345.00 297.24 21.38
innodb delete_autocommit 4.00 -41.46% -1.17
2.00 3.00 2.83 0.38
innodb delete_big 1.00 -262.50% -0.72
0.00 1.00 0.28 0.45
innodb delete_big_many_keys 1273.00 -328.42% -975.86
239.00 345.00 297.14 21.37
innodb delete_commit 2.00 -48.72% -0.66
1.00 2.00 1.34 0.48
innodb delete_key 4.00 -63.38% -1.55
2.00 3.00 2.45 0.50
innodb delete_range 9.00 -29.21% -2.03
6.00 8.00 6.97 0.56
innodb delete_rollback 2.00 -52.63% -0.69
1.00 2.00 1.31 0.46
innodb drop_index 6.00 -205.26% -4.03
1.00 3.00 1.97 0.32
innodb drop_table 0.00 +100.00% 0.04
0.00 2.00 0.04 0.22
innodb drop_table_when_MANY_tables 30.00 -122.51% -16.52
12.00 15.00 13.48 0.62
innodb insert 130.00 -43.35% -39.31
88.00 93.00 90.69 1.37
innodb insert_autocommit 3.00 -16.00% -0.41
2.00 3.00 2.59 0.49
innodb insert_commit 1.00 +9.37% 0.10
1.00 2.00 1.10 0.30
innodb insert_duplicates 17.00 -32.53% -4.17
12.00 14.00 12.83 0.53
innodb insert_key 685.00 -138.16% -397.38
189.00 345.00 287.62 32.94
innodb insert_many_fields 12.00 -194.92% -7.93
3.00 5.00 4.07 0.36
innodb insert_rollback 2.00 -41.46% -0.59
1.00 2.00 1.41 0.49
innodb insert_select_1_key 6.00 -75.76% -2.59
3.00 4.00 3.41 0.49
innodb insert_select_2_keys 8.00 -54.67% -2.83
4.00 6.00 5.17 0.59
innodb min_max 9.00 -17.57% -1.34
6.00 9.00 7.66 1.03
innodb min_max_on_key 21.00 -24.54% -4.14
14.00 20.00 16.86 1.28
innodb multiple_value_insert 15.00 -232.06% -10.48
3.00 5.00 4.52 0.56
innodb once_prepared_select 26.00 -24.01% -5.03
20.00 22.00 20.97 0.61
innodb order_by_big 13.00 +8.05% 1.14
12.00 15.00 14.14 0.94
innodb order_by_big_key 14.00 -12.78% -1.59
11.00 14.00 12.41 1.19
innodb order_by_big_key2 10.00 +12.91% 1.48
10.00 13.00 11.48 0.97
innodb order_by_big_key_desc 15.00 -16.31% -2.10
12.00 14.00 12.90 0.92
innodb order_by_big_key_diff 11.00 +5.06% 0.59
10.00 13.00 11.59 0.85
innodb order_by_big_key_prefix 13.00 -8.65% -1.03
11.00 13.00 11.97 0.85
innodb order_by_key2_diff 1.00 +14.71% 0.17
1.00 2.00 1.17 0.38
innodb order_by_key_prefix 1.00 -61.11% -0.38
0.00 1.00 0.62 0.49
innodb order_by_range 1.00 -38.10% -0.28
0.00 1.00 0.72 0.45
innodb outer_join 17.00 +1.99% 0.34
15.00 21.00 17.34 2.06
innodb outer_join_found 16.00 +5.11% 0.86
14.00 21.00 16.86 2.19
innodb outer_join_not_found 14.00 +6.67% 1.00
13.00 18.00 15.00 1.49
innodb outer_join_on_key 13.00 -8.65% -1.03
10.00 15.00 11.97 1.50
innodb prepared_select 29.00 -12.13% -3.14
22.00 29.00 25.86 2.10
innodb select_1_row 3.00 -22.54% -0.55
2.00 3.00 2.45 0.50
innodb select_1_row_cache 2.00 +3.33% 0.07
2.00 3.00 2.07 0.25
innodb select_2_rows 3.00 -35.94% -0.79
2.00 3.00 2.21 0.41
innodb select_big 13.00 -11.87% -1.38
10.00 13.00 11.62 1.00
innodb select_big_str 2.00 -80.63% -0.89
0.00 2.00 1.11 0.32
innodb select_cache 52.00 +9.70% 5.59
51.00 71.00 57.59 5.41
innodb select_cache2 55.00 +3.27% 1.86
51.00 68.00 56.86 4.88
innodb select_column+column 2.00 +24.68% 0.66
2.00 3.00 2.66 0.48
innodb select_diff_key 1.00 -480.00% -0.83
0.00 1.00 0.17 0.38
innodb select_distinct 5.00 -27.19% -1.07
3.00 5.00 3.93 0.36
innodb select_group 14.00 +7.94% 1.21
13.00 18.00 15.21 1.47
innodb select_group_when_MANY_tables 10.00 -150.00% -6.00
3.00 5.00 4.00 0.37
innodb select_join 1.00 -107.14% -0.52
0.00 1.00 0.48 0.50
innodb select_key 50.00 -12.32% -5.48
40.00 50.00 44.52 2.50
innodb select_key2 61.00 -23.79% -11.72
46.00 54.00 49.28 2.41
innodb select_key2_return_key 55.00 -17.19% -8.07
42.00 51.00 46.93 2.32
innodb select_key2_return_prim 57.00 -17.74% -8.59
43.00 55.00 48.41 2.92
innodb select_key_prefix 56.00 -10.25% -5.21
45.00 57.00 50.79 3.46
innodb select_key_prefix_join 4.00 +4.13% 0.17
4.00 5.00 4.17 0.38
innodb select_key_return_key 49.00 -12.42% -5.41
39.00 49.00 43.59 2.65
innodb select_many_fields 13.00 +20.96% 3.45
15.00 17.00 16.45 0.62
innodb select_range 53.00 -8.47% -4.14
47.00 57.00 48.86 1.66
innodb select_range_key2 9.00 -24.29% -1.76
6.00 8.00 7.24 0.57
innodb select_range_prefix 8.00 -14.29% -1.00
6.00 8.00 7.00 0.64
innodb select_simple 1.00 +30.95% 0.45
1.00 2.00 1.45 0.50
innodb select_simple_cache 2.00 -75.76% -0.86
1.00 2.00 1.14 0.34
innodb select_simple_join 1.00 -38.10% -0.28
0.00 1.00 0.72 0.45
innodb TOTALS 8416.00 -741.61% -7416.01
999.99 999.99 999.99 0.00
innodb update_autocommit 4.00 -43.21% -1.21
2.00 3.00 2.79 0.41
innodb update_big 66.00 -83.16% -29.97
31.00 40.00 36.03 2.48
innodb update_commit 1.00 +25.64% 0.34
1.00 2.00 1.34 0.48
innodb update_of_key 49.00 -154.20% -29.72
19.00 20.00 19.28 0.45
innodb update_of_key_big 31.00 -69.30% -12.69
16.00 20.00 18.31 1.18
innodb update_of_primary_key_many_keys 3350.00 -338.86% -2586.67
661.00 799.00 763.33 39.70
innodb update_rollback 2.00 -41.46% -0.59
1.00 2.00 1.41 0.49
innodb update_with_key 119.00 -29.69% -27.24
90.00 93.00 91.76 0.97
innodb update_with_key_prefix 45.00 -27.69% -9.76
34.00 36.00 35.24 0.57
innodb wisc_benchmark 3.00 -27.94% -0.66
2.00 3.00 2.34 0.48
=========================================================================================================================
FULL REVISION COMMENTARY:
1856.2.21: Joseph Daly 2010-10-31 [merge] merge trunk
1856.2.20: Joseph Daly 2010-10-31 fix valgrind message
1856.2.19: Joseph Daly 2010-10-29 [merge] merge trunk
1856.2.18: Joseph Daly 2010-10-28 code cleanup, test fixes
1856.2.17: Joseph Daly 2010-10-28 [merge] merge trunk
1856.2.16: Joseph Daly 2010-10-28 [merge] update with tests from pcrews
1856.3.1: patrick crews 2010-10-28 Changes to transaction_log tests to deal
with transaction_id's based on Innodb id's
1856.2.15: Joseph Daly 2010-10-26 test fixes
1856.2.14: Joseph Daly 2010-10-26 allow events to use a transaction id
1856.2.13: Joseph Daly 2010-10-26 fix up startup/shutdown events to set a
transaction id
1856.2.12: Joseph Daly 2010-10-26 various coding standards corrections
1856.2.11: Joseph Daly 2010-10-25 [merge] merge trunk
1856.2.10: Joseph Daly 2010-10-25 fix up non diff
1856.2.9: Joseph Daly 2010-10-25 zero out transaction id after its set in the
GPB message
1856.2.8: Joseph Daly 2010-10-24 working alter, drop, create schema
1856.2.7: Joseph Daly 2010-10-23 create schema changes
1856.2.6: Joseph Daly 2010-10-21 [merge] merge trunk
1856.2.5: Joseph Daly 2010-10-20 rework names for retrieving current trans id
1856.2.4: Joseph Daly 2010-10-20 add global_resource_manager for non innodb
engines
1856.2.3: Joseph Daly 2010-10-19 add empty impl for non xa engines
1856.2.2: Joseph Daly 2010-10-18 [merge] merge trunk
1856.2.1: Joseph Daly 2010-10-17 use transaction_id in innodb for transaction
log
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
