=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 819
RUN DATE: 2011-01-14T21:02:05.486840
SERVER: drizzled
VERSION: staging
REVISION: 2087
COMMENT: 2087: Lee Bieber 2011-01-14 [merge] Merge Stewart - some
documentation clean up
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -1.91% -0.60
29.00 32.00 31.40 1.20
innodb alter_table_drop 25.00 -2.46% -0.60
24.00 25.00 24.40 0.49
innodb connect 3.00 -15.38% -0.40
2.00 3.00 2.60 0.49
innodb connect+select_1_row 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb connect+select_simple 2.00 +16.67% 0.40
2.00 3.00 2.40 0.49
innodb count 14.00 +10.26% 1.60
14.00 18.00 15.60 1.96
innodb count_distinct 7.00 -0.00% 0.00
6.00 8.00 7.00 0.63
innodb count_distinct_2 15.00 +1.32% 0.20
15.00 16.00 15.20 0.40
innodb count_distinct_big 22.00 +2.65% 0.60
21.00 25.00 22.60 1.62
innodb count_distinct_group 21.00 -6.06% -1.20
14.00 22.00 19.80 2.99
innodb count_distinct_group_on_key 10.00 +5.66% 0.60
10.00 12.00 10.60 0.80
innodb count_distinct_group_on_key_parts 25.00 -23.76% -4.80
16.00 25.00 20.20 3.43
innodb count_distinct_key_prefix 5.00 +10.71% 0.60
5.00 6.00 5.60 0.49
innodb count_group_on_key_parts 10.00 +9.09% 1.00
10.00 12.00 11.00 0.63
innodb count_on_key 95.00 -0.21% -0.20
93.00 98.00 94.80 1.83
innodb create+drop 33.00 -5.10% -1.60
30.00 33.00 31.40 1.02
innodb create_index 4.00 -25.00% -0.80
2.00 4.00 3.20 0.75
innodb create_key+drop 28.00 +4.11% 1.20
28.00 31.00 29.20 1.17
innodb create_MANY_tables 19.00 +6.86% 1.40
19.00 22.00 20.40 1.02
innodb delete_all_many_keys 648.00 +1.55% 10.20
630.00 744.00 658.20 43.32
innodb delete_autocommit 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb delete_big 1.00 -150.00% -0.60
0.00 1.00 0.40 0.49
innodb delete_big_many_keys 647.00 +1.58% 10.40
629.00 743.00 657.40 43.21
innodb delete_commit 2.00 -42.86% -0.60
1.00 2.00 1.40 0.49
innodb delete_key 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb delete_range 9.00 -7.14% -0.60
8.00 9.00 8.40 0.49
innodb delete_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb drop_index 2.00 +37.50% 1.20
2.00 4.00 3.20 0.75
innodb drop_table_when_MANY_tables 15.00 +8.54% 1.40
15.00 18.00 16.40 1.02
innodb insert 111.00 +2.29% 2.60
111.00 116.00 113.60 1.85
innodb insert_autocommit 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb insert_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_duplicates 20.00 -3.09% -0.60
19.00 20.00 19.40 0.49
innodb insert_key 275.00 +2.27% 6.40
270.00 308.00 281.40 13.54
innodb insert_many_fields 6.00 -0.00% 0.00
6.00 6.00 6.00 0.00
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb insert_select_2_keys 5.00 +13.79% 0.80
5.00 7.00 5.80 0.75
innodb min_max 7.00 +10.26% 0.80
7.00 9.00 7.80 0.98
innodb min_max_on_key 24.00 +2.44% 0.60
24.00 25.00 24.60 0.49
innodb multiple_value_insert 6.00 +3.23% 0.20
6.00 7.00 6.20 0.40
innodb once_prepared_select 30.00 -1.35% -0.40
29.00 30.00 29.60 0.49
innodb order_by_big 13.00 +12.16% 1.80
13.00 16.00 14.80 0.98
innodb order_by_big_key 16.00 -9.59% -1.40
13.00 16.00 14.60 1.36
innodb order_by_big_key2 14.00 -7.69% -1.00
12.00 14.00 13.00 0.63
innodb order_by_big_key_desc 16.00 -3.90% -0.60
14.00 16.00 15.40 0.80
innodb order_by_big_key_diff 14.00 -1.45% -0.20
13.00 15.00 13.80 0.75
innodb order_by_big_key_prefix 13.00 +8.45% 1.20
13.00 15.00 14.20 0.75
innodb order_by_key2_diff 2.00 -42.86% -0.60
1.00 2.00 1.40 0.49
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 22.00 -2.80% -0.60
19.00 22.00 21.40 1.20
innodb outer_join_found 22.00 -4.76% -1.00
17.00 22.00 21.00 2.00
innodb outer_join_not_found 19.00 -1.06% -0.20
16.00 21.00 18.80 1.60
innodb outer_join_on_key 16.00 -8.11% -1.20
13.00 16.00 14.80 0.98
innodb prepared_select 36.00 +2.70% 1.00
36.00 38.00 37.00 0.89
innodb select_1_row 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_1_row_cache 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb select_2_rows 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb select_big 13.00 +5.80% 0.80
12.00 15.00 13.80 1.17
innodb select_big_str 1.00 +16.67% 0.20
1.00 2.00 1.20 0.40
innodb select_cache 58.00 +6.15% 3.80
58.00 65.00 61.80 2.79
innodb select_cache2 63.00 -1.29% -0.80
56.00 65.00 62.20 3.31
innodb select_column+column 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb select_diff_key 0.00 +100.00% 0.60
0.00 1.00 0.60 0.49
innodb select_distinct 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb select_group 19.00 -6.74% -1.20
16.00 19.00 17.80 1.47
innodb select_group_when_MANY_tables 12.00 -1.69% -0.20
11.00 12.00 11.80 0.40
innodb select_join 0.00 +100.00% 0.80
0.00 1.00 0.80 0.40
innodb select_key 63.00 +0.94% 0.60
63.00 65.00 63.60 0.80
innodb select_key2 70.00 +1.41% 1.00
70.00 72.00 71.00 0.89
innodb select_key2_return_key 67.00 +2.33% 1.60
67.00 70.00 68.60 1.20
innodb select_key2_return_prim 69.00 +0.29% 0.20
68.00 71.00 69.20 1.17
innodb select_key_prefix 71.00 -0.00% 0.00
70.00 72.00 71.00 0.89
innodb select_key_prefix_join 6.00 -15.38% -0.80
5.00 6.00 5.20 0.40
innodb select_key_return_key 63.00 -0.64% -0.40
61.00 64.00 62.60 1.02
innodb select_many_fields 13.00 -0.00% 0.00
13.00 13.00 13.00 0.00
innodb select_range 46.00 -7.98% -3.40
39.00 47.00 42.60 3.38
innodb select_range_key2 10.00 -8.70% -0.80
8.00 10.00 9.20 0.75
innodb select_range_prefix 8.00 +11.11% 1.00
8.00 10.00 9.00 0.63
innodb select_simple 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_simple_cache 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_simple_join 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb update_autocommit 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb update_big 59.00 -0.00% 0.00
57.00 63.00 59.00 2.10
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 23.00 -2.68% -0.60
21.00 23.00 22.40 0.80
innodb update_of_key_big 36.00 +7.22% 2.80
36.00 41.00 38.80 1.72
innodb update_of_primary_key_many_keys 1330.00 +2.68% 36.60
1292.00 1505.00 1366.60 72.73
innodb update_rollback 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb update_with_key 118.00 +1.01% 1.20
118.00 121.00 119.20 1.17
innodb update_with_key_prefix 43.00 +1.38% 0.60
42.00 45.00 43.60 1.02
innodb wisc_benchmark 2.00 +28.57% 0.80
2.00 3.00 2.80 0.40
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -0.16% -0.05
29.00 35.00 31.95 1.28
innodb alter_table_drop 25.00 -3.52% -0.85
23.00 25.00 24.15 0.73
innodb connect 3.00 -20.00% -0.50
2.00 3.00 2.50 0.50
innodb connect+select_1_row 3.00 -3.45% -0.10
2.00 3.00 2.90 0.30
innodb connect+select_simple 2.00 +16.67% 0.40
2.00 3.00 2.40 0.49
innodb count 14.00 +15.41% 2.55
14.00 23.00 16.55 2.33
innodb count_distinct 7.00 -1.45% -0.10
6.00 8.00 6.90 0.70
innodb count_distinct_2 15.00 -6.01% -0.85
12.00 16.00 14.15 1.31
innodb count_distinct_big 22.00 +3.72% 0.85
20.00 25.00 22.85 1.80
innodb count_distinct_group 21.00 -30.84% -4.95
13.00 22.00 16.05 2.77
innodb count_distinct_group_on_key 10.00 +3.85% 0.40
9.00 12.00 10.40 0.92
innodb count_distinct_group_on_key_parts 25.00 -60.77% -9.45
12.00 25.00 15.55 3.26
innodb count_distinct_key_prefix 5.00 +9.91% 0.55
4.00 7.00 5.55 0.67
innodb count_group_on_key_parts 10.00 +10.31% 1.15
10.00 12.00 11.15 0.57
innodb count_on_key 95.00 +1.04% 1.00
92.00 104.00 96.00 2.95
innodb create+drop 33.00 -4.10% -1.30
30.00 33.00 31.70 0.95
innodb create_index 4.00 -25.00% -0.80
2.00 4.00 3.20 0.60
innodb create_key+drop 28.00 +6.67% 2.00
28.00 32.00 30.00 1.26
innodb create_MANY_tables 19.00 +6.63% 1.35
19.00 22.00 20.35 0.85
innodb create_table 0.00 +100.00% 0.05
0.00 1.00 0.05 0.22
innodb delete_all_many_keys 648.00 +2.01% 13.30
612.00 744.00 661.30 33.55
innodb delete_autocommit 3.00 +17.81% 0.65
3.00 4.00 3.65 0.48
innodb delete_big 1.00 -122.22% -0.55
0.00 1.00 0.45 0.50
innodb delete_big_many_keys 647.00 +2.05% 13.55
611.00 743.00 660.55 33.60
innodb delete_commit 2.00 -21.21% -0.35
1.00 2.00 1.65 0.48
innodb delete_key 3.00 -3.45% -0.10
2.00 4.00 2.90 0.44
innodb delete_range 9.00 -4.65% -0.40
7.00 10.00 8.60 0.66
innodb delete_rollback 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb drop_index 2.00 +36.51% 1.15
2.00 4.00 3.15 0.48
innodb drop_table 0.00 +100.00% 0.05
0.00 1.00 0.05 0.22
innodb drop_table_when_MANY_tables 15.00 +14.53% 2.55
15.00 20.00 17.55 1.47
innodb insert 111.00 +2.84% 3.25
111.00 117.00 114.25 1.70
innodb insert_autocommit 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb insert_commit 2.00 -14.29% -0.25
1.00 2.00 1.75 0.43
innodb insert_duplicates 20.00 -4.44% -0.85
18.00 20.00 19.15 0.48
innodb insert_key 275.00 +2.74% 7.75
270.00 308.00 282.75 10.16
innodb insert_many_fields 6.00 -7.14% -0.40
5.00 6.00 5.60 0.49
innodb insert_rollback 2.00 -0.00% 0.00
1.00 3.00 2.00 0.32
innodb insert_select_1_key 4.00 -0.00% 0.00
3.00 5.00 4.00 0.55
innodb insert_select_2_keys 5.00 +16.67% 1.00
5.00 8.00 6.00 0.71
innodb min_max 7.00 +13.58% 1.10
7.00 10.00 8.10 1.09
innodb min_max_on_key 24.00 +1.64% 0.40
24.00 25.00 24.40 0.49
innodb multiple_value_insert 6.00 +10.45% 0.70
6.00 8.00 6.70 0.56
innodb once_prepared_select 30.00 -1.52% -0.45
29.00 30.00 29.55 0.50
innodb order_by_big 13.00 +11.26% 1.65
13.00 16.00 14.65 1.15
innodb order_by_big_key 16.00 -11.50% -1.65
12.00 16.00 14.35 1.39
innodb order_by_big_key2 14.00 -6.46% -0.85
12.00 15.00 13.15 0.91
innodb order_by_big_key_desc 16.00 -3.56% -0.55
13.00 17.00 15.45 1.12
innodb order_by_big_key_diff 14.00 -5.26% -0.70
11.00 15.00 13.30 0.95
innodb order_by_big_key_prefix 13.00 +4.06% 0.55
12.00 15.00 13.55 0.74
innodb order_by_key2_diff 2.00 -33.33% -0.50
1.00 2.00 1.50 0.50
innodb order_by_key_prefix 1.00 -25.00% -0.20
0.00 1.00 0.80 0.40
innodb order_by_range 1.00 -5.26% -0.05
0.00 1.00 0.95 0.22
innodb outer_join 22.00 +2.65% 0.60
18.00 30.00 22.60 2.60
innodb outer_join_found 22.00 -0.46% -0.10
17.00 30.00 21.90 2.75
innodb outer_join_not_found 19.00 +1.04% 0.20
15.00 21.00 19.20 1.72
innodb outer_join_on_key 16.00 -7.38% -1.10
11.00 16.00 14.90 1.37
innodb prepared_select 36.00 +3.10% 1.15
36.00 38.00 37.15 0.65
innodb select_1_row 4.00 -6.67% -0.25
3.00 4.00 3.75 0.43
innodb select_1_row_cache 3.00 +10.45% 0.35
3.00 4.00 3.35 0.48
innodb select_2_rows 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_big 13.00 +1.14% 0.15
11.00 15.00 13.15 1.15
innodb select_big_str 1.00 +25.93% 0.35
1.00 2.00 1.35 0.48
innodb select_cache 58.00 +8.01% 5.05
57.00 70.00 63.05 3.23
innodb select_cache2 63.00 +1.72% 1.10
56.00 70.00 64.10 3.33
innodb select_column+column 4.00 -8.11% -0.30
3.00 4.00 3.70 0.46
innodb select_diff_key 0.00 +100.00% 0.20
0.00 1.00 0.20 0.40
innodb select_distinct 4.00 +8.05% 0.35
4.00 5.00 4.35 0.48
innodb select_group 19.00 -9.83% -1.70
15.00 19.00 17.30 1.42
innodb select_group_when_MANY_tables 12.00 +1.23% 0.15
11.00 14.00 12.15 0.73
innodb select_join 0.00 +100.00% 0.55
0.00 1.00 0.55 0.50
innodb select_key 63.00 +1.41% 0.90
63.00 65.00 63.90 0.70
innodb select_key2 70.00 +1.55% 1.10
70.00 72.00 71.10 0.62
innodb select_key2_return_key 67.00 +2.26% 1.55
67.00 70.00 68.55 0.86
innodb select_key2_return_prim 69.00 +0.50% 0.35
68.00 71.00 69.35 0.73
innodb select_key_prefix 71.00 -0.35% -0.25
70.00 72.00 70.75 0.70
innodb select_key_prefix_join 6.00 -15.38% -0.80
5.00 6.00 5.20 0.40
innodb select_key_return_key 63.00 -0.24% -0.15
61.00 64.00 62.85 0.79
innodb select_many_fields 13.00 +1.14% 0.15
13.00 14.00 13.15 0.36
innodb select_range 46.00 -5.75% -2.50
39.00 47.00 43.50 2.52
innodb select_range_key2 10.00 -4.71% -0.45
8.00 10.00 9.55 0.59
innodb select_range_prefix 8.00 +13.04% 1.20
8.00 10.00 9.20 0.51
innodb select_simple 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_simple_cache 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_simple_join 1.00 -17.65% -0.15
0.00 1.00 0.85 0.36
innodb update_autocommit 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb update_big 59.00 +0.67% 0.40
57.00 63.00 59.40 1.77
innodb update_commit 2.00 -2.56% -0.05
1.00 2.00 1.95 0.22
innodb update_of_key 23.00 -2.22% -0.50
21.00 24.00 22.50 0.87
innodb update_of_key_big 36.00 -0.28% -0.10
29.00 42.00 35.90 3.69
innodb update_of_primary_key_many_keys 1330.00 +2.65% 36.25
1292.00 1505.00 1366.25 57.85
innodb update_rollback 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
innodb update_with_key 118.00 +2.64% 3.20
118.00 127.00 121.20 2.58
innodb update_with_key_prefix 43.00 +1.71% 0.75
40.00 47.00 43.75 1.97
innodb wisc_benchmark 2.00 +23.08% 0.60
2.00 3.00 2.60 0.49
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 32.00 -64.94% -12.60
11.00 61.00 19.40 9.73
innodb alter_table_drop 25.00 -42.18% -7.42
10.00 57.00 17.58 7.08
innodb connect 3.00 -45.18% -0.93
1.00 3.00 2.07 0.42
innodb connect+select_1_row 3.00 -12.33% -0.33
2.00 5.00 2.67 0.49
innodb connect+select_simple 2.00 +13.35% 0.31
1.00 3.00 2.31 0.47
innodb count 14.00 +11.03% 1.74
12.00 193.00 15.74 9.41
innodb count_distinct 7.00 -7.12% -0.47
5.00 50.00 6.53 2.41
innodb count_distinct_2 15.00 -14.63% -1.91
11.00 63.00 13.09 3.11
innodb count_distinct_big 22.00 -0.92% -0.20
5.00 67.00 21.80 3.13
innodb count_distinct_group 21.00 -62.32% -8.06
10.00 68.00 12.94 3.21
innodb count_distinct_group_on_key 10.00 -6.08% -0.57
7.00 69.00 9.43 3.18
innodb count_distinct_group_on_key_parts 25.00 -105.35% -12.83
9.00 72.00 12.17 3.31
innodb count_distinct_key_prefix 5.00 +1.75% 0.09
3.00 52.00 5.09 2.54
innodb count_group_on_key_parts 10.00 -1.91% -0.19
7.00 72.00 9.81 3.33
innodb count_on_key 95.00 -12.11% -10.26
68.00 107.00 84.74 6.99
innodb create+drop 33.00 -1.80% -0.58
18.00 75.00 32.42 12.69
innodb create_index 4.00 -40.75% -1.16
1.00 8.00 2.84 1.20
innodb create_key+drop 28.00 -0.37% -0.10
21.00 50.00 27.90 4.99
innodb create_MANY_tables 19.00 +46.93% 16.80
14.00 121.00 35.80 17.37
innodb create_table 0.00 +100.00% 0.11
0.00 3.00 0.11 0.37
innodb delete_all_many_keys 648.00 -48.18% -210.71
212.00 1888.00 437.29 383.11
innodb delete_autocommit 3.00 +12.12% 0.41
2.00 14.00 3.41 0.77
innodb delete_big 1.00 -279.80% -0.74
0.00 3.00 0.26 0.46
innodb delete_big_many_keys 647.00 -45.53% -202.43
212.00 2293.00 444.57 399.13
innodb delete_commit 2.00 -36.48% -0.53
1.00 5.00 1.47 0.53
innodb delete_key 3.00 +3.01% 0.09
2.00 35.00 3.09 1.59
innodb delete_range 9.00 -8.89% -0.74
5.00 23.00 8.26 3.45
innodb delete_rollback 2.00 -22.58% -0.37
1.00 4.00 1.63 0.59
innodb drop_index 2.00 +31.73% 0.93
1.00 9.00 2.93 1.40
innodb drop_table 0.00 +100.00% 0.05
0.00 2.00 0.05 0.24
innodb drop_table_when_MANY_tables 15.00 +23.58% 4.63
11.00 49.00 19.63 6.60
innodb insert 111.00 -5.11% -5.40
3.00 343.00 105.60 15.27
innodb insert_autocommit 3.00 -1.44% -0.04
2.00 99.00 2.96 3.54
innodb insert_commit 2.00 -52.07% -0.68
1.00 3.00 1.32 0.47
innodb insert_duplicates 20.00 -33.94% -5.07
11.00 21.00 14.93 2.41
innodb insert_key 275.00 +10.04% 30.68
142.00 700.00 305.68 114.49
innodb insert_many_fields 6.00 -7.60% -0.42
3.00 17.00 5.58 1.88
innodb insert_rollback 2.00 -23.48% -0.38
1.00 3.00 1.62 0.54
innodb insert_select_1_key 4.00 -6.45% -0.24
2.00 10.00 3.76 0.91
innodb insert_select_2_keys 5.00 +17.03% 1.03
4.00 16.00 6.03 2.20
innodb min_max 7.00 +10.44% 0.82
6.00 110.00 7.82 4.84
innodb min_max_on_key 24.00 -20.29% -4.05
14.00 37.00 19.95 2.85
innodb multiple_value_insert 6.00 -12.99% -0.69
2.00 50.00 5.31 4.56
innodb once_prepared_select 30.00 -27.70% -6.51
18.00 32.00 23.49 3.25
innodb order_by_big 13.00 +8.93% 1.27
12.00 31.00 14.27 1.58
innodb order_by_big_key 16.00 -22.00% -2.89
11.00 32.00 13.11 1.62
innodb order_by_big_key2 14.00 -15.98% -1.93
10.00 33.00 12.07 1.58
innodb order_by_big_key_desc 16.00 -20.74% -2.75
11.00 32.00 13.25 1.61
innodb order_by_big_key_diff 14.00 -15.72% -1.90
10.00 31.00 12.10 1.53
innodb order_by_big_key_prefix 13.00 -6.04% -0.74
10.00 32.00 12.26 1.60
innodb order_by_key2_diff 2.00 -43.05% -0.60
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 1.00 -27.72% -0.22
0.00 2.00 0.78 0.42
innodb order_by_range 1.00 -22.91% -0.19
0.00 2.00 0.81 0.40
innodb outer_join 22.00 -15.88% -3.01
15.00 61.00 18.99 3.73
innodb outer_join_found 22.00 -19.23% -3.55
14.00 58.00 18.45 3.60
innodb outer_join_not_found 19.00 -17.82% -2.87
12.00 46.00 16.13 3.14
innodb outer_join_on_key 16.00 -26.51% -3.35
10.00 59.00 12.65 2.79
innodb prepared_select 36.00 -18.19% -5.54
22.00 40.00 30.46 4.18
innodb select_1_row 4.00 -45.65% -1.25
2.00 4.00 2.75 0.65
innodb select_1_row_cache 3.00 -16.86% -0.43
2.00 4.00 2.57 0.63
innodb select_2_rows 4.00 -44.74% -1.24
2.00 4.00 2.76 0.65
innodb select_big 13.00 -8.01% -0.96
0.00 31.00 12.04 1.57
innodb select_big_str 1.00 +12.03% 0.14
0.00 2.00 1.14 0.35
innodb select_cache 58.00 +1.79% 1.06
49.00 77.00 59.06 5.63
innodb select_cache2 63.00 -5.78% -3.44
49.00 73.00 59.56 6.49
innodb select_column+column 4.00 -42.82% -1.20
2.00 4.00 2.80 0.66
innodb select_diff_key 0.00 +100.00% 0.21
0.00 1.00 0.21 0.40
innodb select_distinct 4.00 +4.65% 0.20
3.00 8.00 4.20 0.54
innodb select_group 19.00 -17.59% -2.84
4.00 136.00 16.16 5.78
innodb select_group_when_MANY_tables 12.00 -34.62% -3.09
3.00 47.00 8.91 9.72
innodb select_join 0.00 +100.00% 0.56
0.00 1.00 0.56 0.50
innodb select_key 63.00 -23.16% -11.85
40.00 66.00 51.15 6.60
innodb select_key2 70.00 -21.16% -12.23
45.00 75.00 57.77 7.55
innodb select_key2_return_key 67.00 -21.61% -11.91
42.00 70.00 55.09 7.29
innodb select_key2_return_prim 69.00 -23.57% -13.16
42.00 72.00 55.84 7.44
innodb select_key_prefix 71.00 -24.62% -14.03
44.00 75.00 56.97 7.49
innodb select_key_prefix_join 6.00 -28.86% -1.34
3.00 10.00 4.66 0.66
innodb select_key_return_key 63.00 -25.57% -12.83
38.00 65.00 50.17 6.60
innodb select_many_fields 13.00 +14.45% 2.20
11.00 19.00 15.20 1.78
innodb select_range 46.00 +3.63% 1.73
39.00 76.00 47.73 3.72
innodb select_range_key2 10.00 -23.80% -1.92
6.00 10.00 8.08 0.98
innodb select_range_prefix 8.00 -4.80% -0.37
5.00 10.00 7.63 1.02
innodb select_simple 2.00 -25.60% -0.41
1.00 3.00 1.59 0.52
innodb select_simple_cache 2.00 -34.46% -0.51
1.00 3.00 1.49 0.52
innodb select_simple_join 1.00 -55.58% -0.36
0.00 3.00 0.64 0.49
innodb update_autocommit 4.00 -24.40% -0.78
2.00 7.00 3.22 0.54
innodb update_big 59.00 -19.09% -9.46
31.00 195.00 49.54 25.63
innodb update_commit 2.00 -35.99% -0.53
1.00 3.00 1.47 0.50
innodb update_of_key 23.00 +6.07% 1.49
18.00 100.00 24.49 6.56
innodb update_of_key_big 36.00 -37.83% -9.88
15.00 75.00 26.12 10.97
innodb update_of_primary_key_many_keys 1330.00 -8.75% -107.05
647.00 6065.00 1222.95 1,046.76
innodb update_rollback 2.00 -26.81% -0.42
1.00 4.00 1.58 0.58
innodb update_with_key 118.00 -9.18% -9.92
90.00 598.00 108.08 21.67
innodb update_with_key_prefix 43.00 -10.37% -4.04
33.00 202.00 38.96 7.00
innodb wisc_benchmark 2.00 +18.83% 0.46
2.00 5.00 2.46 0.53
=========================================================================================================================
FULL REVISION COMMENTARY:
2086.1.3: Lee Bieber 2011-01-14 [merge] Merge Stewart - some documentation
clean up
1994.5.38: Stewart Smith 2011-01-14 \r, like the Daleks, just keeps coming
back
1994.5.37: Stewart Smith 2011-01-14 add FIXME that we should document
current implementation of ALTER TABLE
1994.5.36: Stewart Smith 2011-01-14 add some FIXME to analyze docs.
1994.5.35: Stewart Smith 2011-01-14 \r again :(
1994.5.34: Stewart Smith 2011-01-14 add note that text/varchar is valid utf8
1994.5.33: Stewart Smith 2011-01-14 add FIXME for CREATE INDEX
implementation should be documented
1994.5.32: Stewart Smith 2011-01-14 few notes on DATA_DICTIONARY
documentation.
1994.5.31: Stewart Smith 2011-01-14 just a syntax fix
1994.5.30: Stewart Smith 2011-01-14 add explanation as to why 0000-00-00 is
an invalid date. add fixmes about some of the TIME type restrictions
1994.5.29: Stewart Smith 2011-01-14 add FIXME for EXECUTE doing things
inside explicit txn
1994.5.28: Stewart Smith 2011-01-14 add a small note about isolation of
DROP SCHEMA from other txns.
1994.5.27: Stewart Smith 2011-01-14 add note that impl of DROP INDEX should
be documented
1994.5.26: Stewart Smith 2011-01-14 add FIXME that LOAD DATA INFILE should
come under DML.
1994.5.25: Stewart Smith 2011-01-14 \r and trailing whitespace removed.
1994.5.24: Stewart Smith 2011-01-14 \r and trailing whitespace removed.
1994.5.23: Stewart Smith 2011-01-14 add a FIXME to flesh out insert docs
1994.5.22: Stewart Smith 2011-01-14 fix up some joins docs. remove \r to
prevent injuries to puppies and add a FIXME about documenting our join
implementation.
1994.5.21: Stewart Smith 2011-01-14 logging is done by plugins, so imply in
docs that new plugins can implement new logging.
1994.5.20: Stewart Smith 2011-01-14 add some FIXME for clarifications
needed in locks doc
1994.5.19: Stewart Smith 2011-01-14 rearrange explanation of absence of old
weird types in numeric data types doc to be after explanation of what we do
have. I think it reads better that way
1994.5.18: Stewart Smith 2011-01-14 add some FIXMEs to ORDER BY docs about
what should be added.
1994.5.17: Stewart Smith 2011-01-14 remove \r at end of line as they cause
kitten injuries.
1994.5.16: Stewart Smith 2011-01-14 remove \r at end of line as they cause
kitten injuries.
1994.5.15: Stewart Smith 2011-01-14 fix tpyo
1994.5.14: Stewart Smith 2011-01-14 talk about statement rollback (briefly)
in replication docs
1994.5.13: Stewart Smith 2011-01-14 add savepoint example
1994.5.12: Stewart Smith 2011-01-14 clear up explanation on what SHOw
commands are. that the tablesa re implemented as table functions is'nt really
relevant ot end user
1994.5.11: Stewart Smith 2011-01-14 remove \r newlines from scalar functions
1994.5.10: Stewart Smith 2011-01-14 add BEGIN to start_transaction docs.
also about near future of having error on BEGIn; BEGIN;
1994.5.9: Stewart Smith 2011-01-14 storage engine docs. add bit about some
temp table only engines.
1994.5.8: Stewart Smith 2011-01-14 fix up spinx syntax
1994.5.7: Stewart Smith 2011-01-14 small note on utf8 and collations for
string dataa types - should be expanded into real sentences.
1994.5.6: Stewart Smith 2011-01-14 notes on transaction docs. statements
can be rolled back, celan up some language around definition
1994.5.5: Stewart Smith 2011-01-14 add some notes on TRUNCATE, including
things that should be expanded on
1994.5.4: Stewart Smith 2011-01-14 UPDATE has a condition
1994.5.3: Stewart Smith 2011-01-14 add note about what uuid lib we use
1994.5.2: Stewart Smith 2011-01-14 add a bit of a note on how variables
docs should be expanded
1994.5.1: Stewart Smith 2011-01-14 WHERE clause example is just a simple one
2086.1.2: Lee Bieber 2011-01-14 [merge] Merge Patrick - fix bug 693130: Tests
depending on archive engine should be skipped if archive isn't enabled
2081.3.1: Patrick Crews 2011-01-14 Fix for bug693130. Moved
drizzledump-max to the archive suite - more logical place. Can't *really* fix
this issue as test-run.pl is too dumb to handle it
2086.1.1: Lee Bieber 2011-01-14 [merge] Merge Patrick - fix bug 697292: The
have_valgrind include file in the test has the opposite effect
2081.2.1: Patrick Crews 2011-01-14 Made include/have_valgrind do what the
name implies altered not_valgrind to do the job of skipping tests that are in a
valgrind run. Updates to tests and whatnot to accomodate this
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
