=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: innodb
MACHINE: orisndriz05
RUN ID: 1080
RUN DATE: 2012-01-16T20:00:26.407463
SERVER: drizzled
VERSION: staging
REVISION: 2494
COMMENT: 2494: Mark Atwood 2012-01-16 [merge] merge
lp:~patrick-crews/drizzle/qp-merge2
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 33.00 -1.85% -0.60
32.00 33.00 32.40 0.49
innodb alter_table_drop 26.00 -4.00% -1.00
24.00 26.00 25.00 0.63
innodb connect 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb connect+select_1_row 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb connect+select_simple 3.00 -7.14% -0.20
2.00 3.00 2.80 0.40
innodb count 18.00 -16.88% -2.60
13.00 18.00 15.40 2.15
innodb count_distinct 7.00 +2.78% 0.20
6.00 8.00 7.20 0.75
innodb count_distinct_2 12.00 +6.25% 0.80
12.00 14.00 12.80 0.75
innodb count_distinct_big 25.00 -13.64% -3.00
20.00 25.00 22.00 2.10
innodb count_distinct_group 15.00 -0.00% 0.00
14.00 16.00 15.00 0.63
innodb count_distinct_group_on_key 10.00 -6.38% -0.60
9.00 10.00 9.40 0.49
innodb count_distinct_group_on_key_parts 13.00 +7.14% 1.00
13.00 15.00 14.00 0.63
innodb count_distinct_key_prefix 5.00 -4.17% -0.20
4.00 5.00 4.80 0.40
innodb count_group_on_key_parts 11.00 -0.00% 0.00
10.00 12.00 11.00 0.63
innodb count_on_key 96.00 +0.41% 0.40
96.00 97.00 96.40 0.49
innodb create+drop 33.00 +2.37% 0.80
33.00 35.00 33.80 0.75
innodb create_index 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb create_key+drop 31.00 +1.27% 0.40
30.00 33.00 31.40 1.02
innodb create_MANY_tables 21.00 -0.00% 0.00
20.00 22.00 21.00 0.63
innodb delete_all_many_keys 898.00 -5.08% -43.40
803.00 898.00 854.60 30.51
innodb delete_autocommit 4.00 -11.11% -0.40
3.00 4.00 3.60 0.49
innodb delete_big 1.00 -400.00% -0.80
0.00 1.00 0.20 0.40
innodb delete_big_many_keys 897.00 -5.04% -43.00
803.00 897.00 854.00 30.19
innodb delete_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb delete_key 3.00 -0.00% 0.00
3.00 3.00 3.00 0.00
innodb delete_range 8.00 -2.56% -0.20
7.00 8.00 7.80 0.40
innodb delete_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb drop_index 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb drop_table_when_MANY_tables 19.00 -0.00% 0.00
18.00 20.00 19.00 0.63
innodb insert 114.00 -0.00% 0.00
112.00 115.00 114.00 1.10
innodb insert_autocommit 3.00 +6.25% 0.20
3.00 4.00 3.20 0.40
innodb insert_commit 2.00 -11.11% -0.20
1.00 2.00 1.80 0.40
innodb insert_duplicates 20.00 -2.04% -0.40
19.00 20.00 19.60 0.49
innodb insert_key 280.00 -0.36% -1.00
271.00 283.00 279.00 4.43
innodb insert_many_fields 5.00 +3.85% 0.20
5.00 6.00 5.20 0.40
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 5.00 -0.00% 0.00
5.00 5.00 5.00 0.00
innodb insert_select_2_keys 6.00 +9.09% 0.60
6.00 7.00 6.60 0.49
innodb min_max 9.00 -15.38% -1.20
7.00 9.00 7.80 0.98
innodb min_max_on_key 25.00 -0.81% -0.20
24.00 25.00 24.80 0.40
innodb multiple_value_insert 6.00 -7.14% -0.40
5.00 6.00 5.60 0.49
innodb once_prepared_select 29.00 +1.36% 0.40
29.00 30.00 29.40 0.49
innodb order_by_big 14.00 -1.45% -0.20
13.00 15.00 13.80 0.75
innodb order_by_big_key 16.00 -12.68% -1.80
13.00 16.00 14.20 1.17
innodb order_by_big_key2 12.00 +3.23% 0.40
12.00 14.00 12.40 0.80
innodb order_by_big_key_desc 15.00 -2.74% -0.40
13.00 16.00 14.60 1.02
innodb order_by_big_key_diff 11.00 +9.84% 1.20
11.00 13.00 12.20 0.75
innodb order_by_big_key_prefix 13.00 -0.00% 0.00
12.00 14.00 13.00 0.63
innodb order_by_key2_diff 2.00 -25.00% -0.40
1.00 2.00 1.60 0.49
innodb order_by_key_prefix 0.00 +100.00% 0.60
0.00 1.00 0.60 0.49
innodb order_by_range 1.00 -0.00% 0.00
1.00 1.00 1.00 0.00
innodb outer_join 22.00 -3.77% -0.80
18.00 24.00 21.20 2.32
innodb outer_join_found 22.00 -10.00% -2.00
17.00 22.00 20.00 2.10
innodb outer_join_not_found 21.00 -16.67% -3.00
16.00 21.00 18.00 2.10
innodb outer_join_on_key 15.00 -10.29% -1.40
11.00 15.00 13.60 1.74
innodb prepared_select 37.00 +1.60% 0.60
37.00 38.00 37.60 0.49
innodb select_1_row 3.00 +11.76% 0.40
3.00 4.00 3.40 0.49
innodb select_1_row_cache 4.00 -5.26% -0.20
3.00 4.00 3.80 0.40
innodb select_2_rows 4.00 -0.00% 0.00
4.00 4.00 4.00 0.00
innodb select_big 12.00 +4.76% 0.60
11.00 14.00 12.60 1.20
innodb select_big_str 1.00 +28.57% 0.40
1.00 2.00 1.40 0.49
innodb select_cache 61.00 -0.00% 0.00
60.00 63.00 61.00 1.10
innodb select_cache2 62.00 +4.62% 3.00
62.00 68.00 65.00 2.19
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.20
0.00 1.00 0.20 0.40
innodb select_distinct 5.00 -8.70% -0.40
4.00 5.00 4.60 0.49
innodb select_group 18.00 +3.23% 0.60
18.00 20.00 18.60 0.80
innodb select_group_when_MANY_tables 12.00 -0.00% 0.00
11.00 13.00 12.00 0.63
innodb select_join 0.00 +100.00% 0.60
0.00 1.00 0.60 0.49
innodb select_key 64.00 +0.93% 0.60
64.00 65.00 64.60 0.49
innodb select_key2 71.00 +1.11% 0.80
71.00 73.00 71.80 0.75
innodb select_key2_return_key 68.00 +2.02% 1.40
68.00 71.00 69.40 1.02
innodb select_key2_return_prim 69.00 +1.43% 1.00
69.00 71.00 70.00 0.63
innodb select_key_prefix 70.00 +1.69% 1.20
70.00 72.00 71.20 0.75
innodb select_key_prefix_join 5.00 -0.00% 0.00
5.00 5.00 5.00 0.00
innodb select_key_return_key 64.00 -0.00% 0.00
63.00 65.00 64.00 0.63
innodb select_many_fields 13.00 +1.52% 0.20
13.00 14.00 13.20 0.40
innodb select_range 41.00 +2.84% 1.20
41.00 45.00 42.20 1.47
innodb select_range_key2 10.00 -6.38% -0.60
9.00 10.00 9.40 0.49
innodb select_range_prefix 9.00 +4.26% 0.40
9.00 10.00 9.40 0.49
innodb select_simple 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb select_simple_cache 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb select_simple_join 1.00 -66.67% -0.40
0.00 1.00 0.60 0.49
innodb update_autocommit 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb update_big 59.00 -0.68% -0.40
57.00 61.00 58.60 1.50
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 21.00 +3.67% 0.80
21.00 23.00 21.80 0.75
innodb update_of_key_big 20.00 -4.17% -0.80
18.00 20.00 19.20 0.98
innodb update_of_primary_key_many_keys 1260.00 +0.25% 3.20
1173.00 1311.00 1263.20 48.95
innodb update_rollback 2.00 +9.09% 0.20
2.00 3.00 2.20 0.40
innodb update_with_key 119.00 +0.17% 0.20
118.00 121.00 119.20 1.17
innodb update_with_key_prefix 42.00 +2.33% 1.00
42.00 45.00 43.00 1.10
innodb wisc_benchmark 2.00 +23.08% 0.60
2.00 3.00 2.60 0.49
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 33.00 -3.13% -1.00
30.00 33.00 32.00 0.71
innodb alter_table_drop 26.00 -4.21% -1.05
24.00 26.00 24.95 0.74
innodb connect 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb connect+select_1_row 3.00 -5.26% -0.15
2.00 3.00 2.85 0.36
innodb connect+select_simple 3.00 -13.21% -0.35
2.00 3.00 2.65 0.48
innodb count 18.00 -12.15% -1.95
13.00 19.00 16.05 2.22
innodb count_distinct 7.00 -0.00% 0.00
6.00 8.00 7.00 0.77
innodb count_distinct_2 12.00 +11.76% 1.60
12.00 16.00 13.60 1.20
innodb count_distinct_big 25.00 -9.65% -2.20
20.00 26.00 22.80 2.14
innodb count_distinct_group 15.00 -1.35% -0.20
12.00 18.00 14.80 1.25
innodb count_distinct_group_on_key 10.00 -2.56% -0.25
8.00 12.00 9.75 1.04
innodb count_distinct_group_on_key_parts 13.00 +2.62% 0.35
11.00 15.00 13.35 1.24
innodb count_distinct_key_prefix 5.00 +1.96% 0.10
4.00 6.00 5.10 0.62
innodb count_group_on_key_parts 11.00 -1.38% -0.15
10.00 12.00 10.85 0.65
innodb count_on_key 96.00 -0.68% -0.65
91.00 104.00 95.35 3.13
innodb create+drop 33.00 +1.64% 0.55
32.00 35.00 33.55 0.86
innodb create_index 3.00 +3.23% 0.10
3.00 4.00 3.10 0.30
innodb create_key+drop 31.00 +2.52% 0.80
30.00 35.00 31.80 1.40
innodb create_MANY_tables 21.00 +1.18% 0.25
20.00 22.00 21.25 0.70
innodb delete_all_many_keys 898.00 -1.00% -8.90
749.00 1107.00 889.10 100.95
innodb delete_autocommit 4.00 -9.59% -0.35
3.00 4.00 3.65 0.48
innodb delete_big 1.00 -400.00% -0.80
0.00 1.00 0.20 0.40
innodb delete_big_many_keys 897.00 -0.95% -8.40
749.00 1106.00 888.60 100.73
innodb delete_commit 2.00 -5.26% -0.10
1.00 2.00 1.90 0.30
innodb delete_key 3.00 -3.45% -0.10
2.00 3.00 2.90 0.30
innodb delete_range 8.00 -1.91% -0.15
7.00 9.00 7.85 0.57
innodb delete_rollback 2.00 +4.76% 0.10
2.00 3.00 2.10 0.30
innodb drop_index 3.00 -0.00% 0.00
2.00 4.00 3.00 0.55
innodb drop_table 0.00 +100.00% 0.05
0.00 1.00 0.05 0.22
innodb drop_table_when_MANY_tables 19.00 +0.52% 0.10
18.00 21.00 19.10 0.83
innodb insert 114.00 +0.09% 0.10
112.00 116.00 114.10 1.04
innodb insert_autocommit 3.00 +9.09% 0.30
3.00 4.00 3.30 0.46
innodb insert_commit 2.00 -14.29% -0.25
1.00 2.00 1.75 0.43
innodb insert_duplicates 20.00 -2.04% -0.40
19.00 20.00 19.60 0.49
innodb insert_key 280.00 +2.44% 7.00
271.00 297.00 287.00 6.29
innodb insert_many_fields 5.00 +9.91% 0.55
5.00 6.00 5.55 0.50
innodb insert_rollback 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb insert_select_1_key 5.00 -4.17% -0.20
3.00 6.00 4.80 0.68
innodb insert_select_2_keys 6.00 +6.25% 0.40
6.00 7.00 6.40 0.49
innodb min_max 9.00 -9.09% -0.75
7.00 9.00 8.25 0.94
innodb min_max_on_key 25.00 -0.20% -0.05
24.00 26.00 24.95 0.74
innodb multiple_value_insert 6.00 -5.26% -0.30
5.00 7.00 5.70 0.56
innodb once_prepared_select 29.00 +0.85% 0.25
29.00 30.00 29.25 0.43
innodb order_by_big 14.00 -0.36% -0.05
12.00 16.00 13.95 1.07
innodb order_by_big_key 16.00 -13.07% -1.85
12.00 16.00 14.15 1.39
innodb order_by_big_key2 12.00 +4.00% 0.50
11.00 14.00 12.50 0.87
innodb order_by_big_key_desc 15.00 -0.00% 0.00
13.00 16.00 15.00 0.95
innodb order_by_big_key_diff 11.00 +13.39% 1.70
11.00 14.00 12.70 0.90
innodb order_by_big_key_prefix 13.00 +0.38% 0.05
11.00 14.00 13.05 0.92
innodb order_by_key2_diff 2.00 -53.85% -0.70
1.00 2.00 1.30 0.46
innodb order_by_key_prefix 0.00 +100.00% 0.85
0.00 1.00 0.85 0.36
innodb order_by_range 1.00 -5.26% -0.05
0.00 1.00 0.95 0.22
innodb outer_join 22.00 +1.57% 0.35
18.00 26.00 22.35 2.71
innodb outer_join_found 22.00 -5.01% -1.05
17.00 24.00 20.95 2.40
innodb outer_join_not_found 21.00 -10.24% -1.95
15.00 22.00 19.05 2.52
innodb outer_join_on_key 15.00 -8.30% -1.15
11.00 16.00 13.85 1.62
innodb prepared_select 37.00 +0.80% 0.30
36.00 38.00 37.30 0.56
innodb select_1_row 3.00 +16.67% 0.60
3.00 4.00 3.60 0.49
innodb select_1_row_cache 4.00 -8.11% -0.30
3.00 4.00 3.70 0.46
innodb select_2_rows 4.00 -8.11% -0.30
3.00 4.00 3.70 0.46
innodb select_big 12.00 +6.98% 0.90
11.00 14.00 12.90 1.04
innodb select_big_str 1.00 +31.03% 0.45
1.00 2.00 1.45 0.50
innodb select_cache 61.00 +3.33% 2.10
54.00 73.00 63.10 4.21
innodb select_cache2 62.00 +4.76% 3.10
60.00 72.00 65.10 3.08
innodb select_column+column 4.00 -3.90% -0.15
3.00 4.00 3.85 0.36
innodb select_diff_key 0.00 +100.00% 0.15
0.00 1.00 0.15 0.36
innodb select_distinct 5.00 -6.38% -0.30
4.00 5.00 4.70 0.46
innodb select_group 18.00 -3.15% -0.55
15.00 20.00 17.45 1.43
innodb select_group_when_MANY_tables 12.00 +0.41% 0.05
11.00 14.00 12.05 0.67
innodb select_join 0.00 +100.00% 0.70
0.00 1.00 0.70 0.46
innodb select_key 64.00 +1.08% 0.70
63.00 67.00 64.70 0.90
innodb select_key2 71.00 +0.70% 0.50
70.00 74.00 71.50 0.92
innodb select_key2_return_key 68.00 +1.45% 1.00
68.00 71.00 69.00 0.95
innodb select_key2_return_prim 69.00 +1.00% 0.70
69.00 72.00 69.70 0.84
innodb select_key_prefix 70.00 +1.62% 1.15
70.00 73.00 71.15 0.85
innodb select_key_prefix_join 5.00 +12.28% 0.70
5.00 7.00 5.70 0.64
innodb select_key_return_key 64.00 -0.63% -0.40
63.00 66.00 63.60 0.80
innodb select_many_fields 13.00 +2.99% 0.40
13.00 17.00 13.40 0.92
innodb select_range 41.00 +3.53% 1.50
39.00 49.00 42.50 2.54
innodb select_range_key2 10.00 -4.17% -0.40
9.00 11.00 9.60 0.58
innodb select_range_prefix 9.00 +2.70% 0.25
8.00 10.00 9.25 0.54
innodb select_simple 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb select_simple_cache 2.00 +6.98% 0.15
2.00 3.00 2.15 0.36
innodb select_simple_join 1.00 -42.86% -0.30
0.00 1.00 0.70 0.46
innodb update_autocommit 3.00 +10.45% 0.35
3.00 4.00 3.35 0.48
innodb update_big 59.00 -1.03% -0.60
57.00 61.00 58.40 1.39
innodb update_commit 2.00 -0.00% 0.00
2.00 2.00 2.00 0.00
innodb update_of_key 21.00 +6.04% 1.35
21.00 25.00 22.35 1.06
innodb update_of_key_big 20.00 -4.99% -0.95
17.00 21.00 19.05 0.97
innodb update_of_primary_key_many_keys 1260.00 +2.38% 30.75
1173.00 1452.00 1290.75 49.32
innodb update_rollback 2.00 +2.44% 0.05
2.00 3.00 2.05 0.22
innodb update_with_key 119.00 +0.46% 0.55
116.00 122.00 119.55 1.47
innodb update_with_key_prefix 42.00 +1.87% 0.80
40.00 46.00 42.80 1.47
innodb wisc_benchmark 2.00 +21.57% 0.55
2.00 3.00 2.55 0.50
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Min Max Avg STD
=========================================================================================================================
innodb alter_table_add 33.00 -45.85% -10.37
11.00 61.00 22.63 10.12
innodb alter_table_drop 26.00 -35.33% -6.79
10.00 57.00 19.21 6.75
innodb connect 2.00 +4.82% 0.10
1.00 3.00 2.10 0.42
innodb connect+select_1_row 3.00 -9.71% -0.27
2.00 5.00 2.73 0.45
innodb connect+select_simple 3.00 -25.85% -0.62
1.00 3.00 2.38 0.49
innodb count 18.00 -14.13% -2.23
12.00 193.00 15.77 8.19
innodb count_distinct 7.00 -5.76% -0.38
5.00 50.00 6.62 2.13
innodb count_distinct_2 12.00 +9.55% 1.27
11.00 63.00 13.27 2.78
innodb count_distinct_big 25.00 -13.24% -2.92
5.00 67.00 22.08 2.91
innodb count_distinct_group 15.00 -12.44% -1.66
10.00 68.00 13.34 2.93
innodb count_distinct_group_on_key 10.00 -4.80% -0.46
7.00 69.00 9.54 2.82
innodb count_distinct_group_on_key_parts 13.00 -4.45% -0.55
9.00 72.00 12.45 2.97
innodb count_distinct_key_prefix 5.00 +3.01% 0.16
3.00 52.00 5.16 2.22
innodb count_group_on_key_parts 11.00 -8.53% -0.86
7.00 72.00 10.14 2.95
innodb count_on_key 96.00 -9.99% -8.72
68.00 107.00 87.28 7.58
innodb create+drop 33.00 -1.41% -0.46
18.00 75.00 32.54 11.00
innodb create_index 3.00 -2.90% -0.08
1.00 8.00 2.92 1.07
innodb create_key+drop 31.00 -8.15% -2.33
21.00 50.00 28.67 4.71
innodb create_MANY_tables 21.00 +34.69% 11.15
14.00 121.00 32.15 16.49
innodb create_table 0.00 +100.00% 0.10
0.00 3.00 0.10 0.34
innodb delete_all_many_keys 898.00 -75.88% -387.43
212.00 1888.00 510.57 358.30
innodb delete_autocommit 4.00 -15.38% -0.53
2.00 14.00 3.47 0.72
innodb delete_big 1.00 -225.24% -0.69
0.00 3.00 0.31 0.47
innodb delete_big_many_keys 897.00 -74.00% -381.48
212.00 2293.00 515.52 369.94
innodb delete_commit 2.00 -27.86% -0.44
1.00 5.00 1.56 0.52
innodb delete_key 3.00 +0.82% 0.02
2.00 35.00 3.02 1.40
innodb delete_range 8.00 +3.79% 0.31
5.00 23.00 8.31 3.01
innodb delete_rollback 2.00 -11.92% -0.21
1.00 12.00 1.79 0.86
innodb drop_index 3.00 -1.38% -0.04
1.00 9.00 2.96 1.24
innodb drop_table 0.00 +100.00% 0.04
0.00 2.00 0.04 0.22
innodb drop_table_when_MANY_tables 19.00 +2.38% 0.46
11.00 90.00 19.46 6.98
innodb insert 114.00 -5.93% -6.38
3.00 343.00 107.62 13.70
innodb insert_autocommit 3.00 +0.72% 0.02
2.00 99.00 3.02 3.07
innodb insert_commit 2.00 -38.43% -0.56
1.00 3.00 1.44 0.50
innodb insert_duplicates 20.00 -24.97% -4.00
11.00 21.00 16.00 2.79
innodb insert_key 280.00 +6.58% 19.72
142.00 700.00 299.72 98.74
innodb insert_many_fields 5.00 +11.15% 0.63
3.00 17.00 5.63 1.65
innodb insert_rollback 2.00 -16.52% -0.28
1.00 3.00 1.72 0.51
innodb insert_select_1_key 5.00 -28.68% -1.11
2.00 10.00 3.89 0.91
innodb insert_select_2_keys 6.00 +1.65% 0.10
4.00 16.00 6.10 1.95
innodb min_max 9.00 -14.66% -1.15
6.00 110.00 7.85 4.22
innodb min_max_on_key 25.00 -18.35% -3.88
14.00 37.00 21.12 3.20
innodb multiple_value_insert 6.00 -8.35% -0.46
2.00 50.00 5.54 3.98
innodb once_prepared_select 29.00 -16.49% -4.11
18.00 32.00 24.89 3.71
innodb order_by_big 14.00 +1.99% 0.28
12.00 31.00 14.28 1.47
innodb order_by_big_key 16.00 -19.23% -2.58
11.00 32.00 13.42 1.64
innodb order_by_big_key2 12.00 +2.37% 0.29
10.00 33.00 12.29 1.49
innodb order_by_big_key_desc 15.00 -9.40% -1.29
11.00 32.00 13.71 1.69
innodb order_by_big_key_diff 11.00 +10.77% 1.33
10.00 31.00 12.33 1.45
innodb order_by_big_key_prefix 13.00 -4.05% -0.51
10.00 32.00 12.49 1.49
innodb order_by_key2_diff 2.00 -42.92% -0.60
1.00 3.00 1.40 0.49
innodb order_by_key_prefix 0.00 +100.00% 0.80
0.00 2.00 0.80 0.40
innodb order_by_range 1.00 -18.54% -0.16
0.00 2.00 0.84 0.37
innodb outer_join 22.00 -11.50% -2.27
15.00 61.00 19.73 3.70
innodb outer_join_found 22.00 -15.24% -2.91
14.00 58.00 19.09 3.53
innodb outer_join_not_found 21.00 -24.69% -4.16
12.00 46.00 16.84 3.20
innodb outer_join_on_key 15.00 -14.45% -1.89
10.00 59.00 13.11 2.69
innodb prepared_select 37.00 -15.18% -4.88
22.00 40.00 32.12 4.62
innodb select_1_row 3.00 -1.58% -0.05
2.00 4.00 2.95 0.71
innodb select_1_row_cache 4.00 -43.00% -1.20
2.00 4.00 2.80 0.72
innodb select_2_rows 4.00 -33.87% -1.01
2.00 4.00 2.99 0.73
innodb select_big 12.00 +1.95% 0.24
0.00 31.00 12.24 1.50
innodb select_big_str 1.00 +16.21% 0.19
0.00 2.00 1.19 0.40
innodb select_cache 61.00 -1.19% -0.72
49.00 78.00 60.28 5.64
innodb select_cache2 62.00 -2.07% -1.26
49.00 84.00 60.74 6.29
innodb select_column+column 4.00 -31.29% -0.95
2.00 4.00 3.05 0.74
innodb select_diff_key 0.00 +100.00% 0.22
0.00 1.00 0.22 0.42
innodb select_distinct 5.00 -16.57% -0.71
3.00 8.00 4.29 0.55
innodb select_group 18.00 -10.00% -1.64
4.00 136.00 16.36 5.07
innodb select_group_when_MANY_tables 12.00 -22.25% -2.18
3.00 49.00 9.82 8.80
innodb select_join 0.00 +100.00% 0.59
0.00 1.00 0.59 0.49
innodb select_key 64.00 -17.77% -9.66
40.00 67.00 54.34 7.93
innodb select_key2 71.00 -16.30% -9.95
45.00 75.00 61.05 8.65
innodb select_key2_return_key 68.00 -16.43% -9.60
42.00 71.00 58.40 8.51
innodb select_key2_return_prim 69.00 -16.63% -9.84
42.00 72.00 59.16 8.63
innodb select_key_prefix 70.00 -15.97% -9.64
44.00 75.00 60.36 8.73
innodb select_key_prefix_join 5.00 -4.16% -0.20
3.00 10.00 4.80 0.66
innodb select_key_return_key 64.00 -19.96% -10.65
38.00 66.00 53.35 7.92
innodb select_many_fields 13.00 +11.61% 1.71
11.00 19.00 14.71 1.77
innodb select_range 41.00 +12.00% 5.59
38.00 76.00 46.59 4.06
innodb select_range_key2 10.00 -18.45% -1.56
6.00 11.00 8.44 1.09
innodb select_range_prefix 9.00 -11.98% -0.96
5.00 10.00 8.04 1.16
innodb select_simple 2.00 -17.25% -0.29
1.00 3.00 1.71 0.50
innodb select_simple_cache 2.00 -23.13% -0.38
1.00 3.00 1.62 0.51
innodb select_simple_join 1.00 -49.26% -0.33
0.00 3.00 0.67 0.48
innodb update_autocommit 3.00 +10.51% 0.35
2.00 16.00 3.35 0.96
innodb update_big 59.00 -13.30% -6.93
31.00 195.00 52.07 22.82
innodb update_commit 2.00 -23.54% -0.38
1.00 10.00 1.62 0.69
innodb update_of_key 21.00 +12.30% 2.95
18.00 100.00 23.95 5.77
innodb update_of_key_big 20.00 +26.70% 7.28
15.00 75.00 27.28 10.69
innodb update_of_primary_key_many_keys 1260.00 -0.68% -8.48
647.00 6065.00 1251.52 871.13
innodb update_rollback 2.00 -10.93% -0.20
1.00 31.00 1.80 1.77
innodb update_with_key 119.00 -6.92% -7.70
90.00 598.00 111.30 19.60
innodb update_with_key_prefix 42.00 -4.56% -1.83
33.00 202.00 40.17 6.49
innodb wisc_benchmark 2.00 +19.60% 0.49
2.00 5.00 2.49 0.52
=========================================================================================================================
FULL REVISION COMMENTARY:
2483.1.1: Patrick Crews 2012-01-05 [merge] Redo of kewpie merge. Leaving
dbqp in tree as a transition
0.125.83: Patrick Crews 2011-12-30 Added test data file + update / fix of
test case (couldn't run w/ --repeat=2)
0.125.82: Patrick Crews 2011-12-29 Porting of xtrabackup test suite to
kewpie format
0.125.81: patrick crews 2011-12-28 [merge] Fix of adding tar4ibd to PATH.
Needed the dirname, not the binary : (
0.135.1: patrick crews 2011-12-28 Updates to system to add tar4ibd binary
to PATH if one is provided. This is to facilitate xtrabackup testing
0.125.80: patrick crews 2011-12-22 [merge] Merge fix of lp:907957
0.134.1: patrick crews 2011-12-22 Fix for lp:907957. The test runner
could generate a socket file path that exceeded MySQL's limit of 107
characters. Now, for such cases, we copy the MTR trick of creating a path in
/tmp. Our path is currently uuid_botN.sM.sock, where N = the executor id, and
M = the server number
0.125.79: Patrick Crews 2011-12-21 [merge] Merge trunk
0.133.4: Patrick Crews 2011-12-20 Merge from randgen trunk
0.133.3: Patrick Crews 2011-12-19 Consolidated two test modules into one
0.133.2: Patrick Crews 2011-12-16 Added 5.1 and percona 5.1 test beds.
Might remove later, but trying things out for now
0.133.1: Patrick Crews 2011-12-16 Added upgrade test cases that use
datadirs generated by other server versions. We try to use a previous version
and a current version's datadir. Also includes code to allow for running
mysql-5.0 servers.
0.125.78: Patrick Crews 2011-12-21 Tweak replace test cases and updated
existing tests to fix minor errors
0.125.77: patrick crews 2011-12-14 [merge] Merge randgen cluster test
changes
0.132.1: Patrick Crews 2011-12-14 Tweaks to randgen cluster tests and
addition of suite_config file
0.125.76: patrick crews 2011-12-14 Fix of commit file import : (
0.125.75: patrick crews 2011-12-14 Refactored existing cluster tests to use
suite-wide config and added new test cases
0.125.74: Patrick Crews 2011-12-13 Updated crashme tests to use batch mode.
This is a bit of a whiff as the crashme test will just die on errors (rather
than trying to continue). However, this solves the problem of endless timeouts
on failures without a lot of time. Attempts at interacting with the crashme
subproc's stdin /stdout were proving unreliable and problematic
0.125.73: Patrick Crews 2011-12-12 Tweaks to innodbCrash2 test case
0.125.72: Patrick Crews 2011-12-12 Updates / polish for the innodb crash
suite
0.125.71: patrick crews 2011-12-12 Tweaked crash tests to use a suite-wide
config file. This allows for easier tweaks to all tests within a suite.
Created base crash test case to clean up individual test case modules / store
common code in one location. Added test-debug output to test cases (vs. dumb
print stmts) and incorporated use of randgen-seed option to avoid needing
random variants (can just change seed and shuffle all tests that are equipped
to change with seed value)
0.125.70: Patrick Crews 2011-12-12 Initial work on making suites
config-file-tunable (for ease of test-tweaking)
0.125.69: patrick crews 2011-12-09 Initial code to allow for the use of a
suite-wide config file that defines common attributes for related tests
0.125.68: Patrick Crews 2011-12-09 Added initial innodb crash tests +
randgen grammars
0.125.67: Patrick Crews 2011-12-07 Updated handling code to start a server
with a pre-loaded datadir
0.125.66: Patrick Crews 2011-12-07 Catch annoying error and exit if we hit
it
0.125.65: Patrick Crews 2011-12-07 Minor updates to Drizzle log file name +
cosmetic tweaks
0.125.64: patrick crews 2011-12-07 [merge] Merge trunk - many updates to
drizzle test cases
0.131.4: Patrick Crews 2011-12-06 Fix typo : (
0.131.3: Patrick Crews 2011-12-06 Update location of datadir to be
appropriate (in workdir/qp_data)
0.131.2: Patrick Crews 2011-12-06 Added placeholder for dbqp in docs
0.131.1: Patrick Crews 2011-12-06 Updates of drizzle test cases to deal
with refactoring. Setting no-secure-file-priv when not using mtr/dtr now as
well
0.125.63: patrick crews 2011-12-07 Refactored option parsing to allow for
more flexibility in merging into other trees. Makes this work easier and
handles important directory detection better this way
0.125.62: Patrick Crews 2011-12-05 Remove unused option / attribute from
system_management
0.125.61: patrick crews 2011-12-05 Update of docs + rename of dbqp to
something not so hard on the fingers, eyes, and auto-complete : )
0.125.60: Patrick Crews 2011-12-01 Tweaks to mysqldump merge, port of
updates to BaseTestCase + test updates
0.125.59: Patrick Crews 2011-12-01 [merge] Merge longbow's updates to
mysqldump utility method. We dump to a result file vs. dumping to stdout to
avoid portability issues and be cleaner in how we do things
0.130.1: Valentine Gostev 2011-12-01 Modified take_mysqldump to use
--restult-file rather than stdout
0.125.58: Patrick Crews 2011-11-30 Finished tweaking server objects for
greater control + setup of replication slaves : )
0.125.57: Patrick Crews 2011-11-30 Additional work and fixes to move server
control to the Server objects. This enables more interesting setup options
0.125.56: patrick crews 2011-11-30 Tweaks to server handling to allow more
flexible and interesting things to be done in tests
0.125.55: Patrick Crews 2011-11-29 Re-add crashing grammar
0.125.54: Patrick Crews 2011-11-29 Redo premature removal of bug test +
workaround in main suite : (
0.125.53: Patrick Crews 2011-11-29 Updates for galera. Handling of IST
addresses + test updates (re-enabled test of ROLLBACK TO SAVEPOINT)
0.125.52: Patrick Crews 2011-11-29 Added new randgen grammar
0.125.51: Patrick Crews 2011-11-29 Ported in Vadim's fixes to Percona /
Galera servers (query-cache-size=0). Also enabled auto-find and add to PATH
for wsrep_sst scripts for galera trees. Also fixed IST address issue
0.125.50: Patrick Crews 2011-11-28 Added test case for --galera-info option
for xtrabackup and rejiggered existing tests slightly
0.125.49: Patrick Crews 2011-11-28 Added subunit output for test runs
(native mode only so far)
0.125.48: Patrick Crews 2011-11-23 Removed debugging bits from basic_test
and rejiggered slave_test to use check_slave_by_query
0.125.47: Patrick Crews 2011-11-22 Fix error in test refactor
0.125.46: Patrick Crews 2011-11-22 Refactor, speed up of test execution,
and reorg of test cases
0.125.45: Patrick Crews 2011-11-21 Rename of directories
0.125.44: Patrick Crews 2011-11-18 Added test case to add a new node to an
already-populated cluster
0.125.43: Patrick Crews 2011-11-18 Defanged translog_concurrent1.yy to not
use ROLLBACK TO SAVEPOINT as it breaks things : )
0.125.42: Patrick Crews 2011-11-18 Added tests of DROP functionality
0.125.41: Patrick Crews 2011-11-18 Added rollback tests
0.125.40: Patrick Crews 2011-11-17 Added tests of various ALTER TABLE
operations
0.125.39: Patrick Crews 2011-11-16 Updates to system to run servers with
galera replication + tests
0.125.38: Patrick Crews 2011-11-14 Tweaks to cluster test + randgen gendata
file
0.125.37: Patrick Crews 2011-11-11 [merge] Merge trunk
0.129.2: patrick crews 2011-11-11 Cleanup of query_cache test case
0.129.1: patrick crews 2011-11-11 Moved crashing test cases to
randgen_bugs suite + cleanup of test cases
0.125.36: Patrick Crews 2011-11-11 Added support for Galera-based mysql
servers / clusters and added a basic test case
0.125.35: patrick crews 2011-11-01 Work on repeating bug 826632. Test case
fails, but only with 7 schemas, 100 tables per schema (table rows = 1-100), and
xtrabackup --parallel=50. Reducing schemas, or --parallel value results in a
passing test : /
0.125.34: patrick crews 2011-11-01 Added some test cases for bugs /
bug-hunting in xtrabackup, particularly passing bad values to the --parallel
option
0.125.33: patrick crews 2011-11-01 Better way to use helgrind with testing
0.125.32: patrick crews 2011-10-31 [merge] Merge stewart's work on
bug856404 query_cache_strip_comments
0.128.1: Stewart Smith 2011-10-31 add randgen test case for
query_cache_strip_comments with odd quote escaping
0.125.31: patrick crews 2011-10-31 [merge] Merge stewart's work on
reproducing bug 758788 (innodb_dict_size_limit)
0.127.1: Stewart Smith 2011-10-31 modify innodb_dict_size test to set
server options so we are able to reproduce a crash within a few seconds
0.125.30: patrick crews 2011-10-31 initial test for innodb_dict_size_limit
bug
0.125.29: Patrick Crews 2011-10-28 Updated slave test so that we also
ensure replication is working between master and slave (simple check)
0.125.28: Patrick Crews 2011-10-28 Update of assertion to check slave
status vs. master
0.125.27: Patrick Crews 2011-10-28 Spawning a slave from a master
xtrabackup and replicating from there : )
0.125.26: Patrick Crews 2011-10-27 Additional progress on testing our
ability to spwan a slave via xtrabackup
0.125.25: patrick crews 2011-10-27 Initial work on 'spawn a slave via
xtrabackup' test
0.125.24: patrick crews 2011-10-27 Allowing that we might not have direct
control over server code, we can read in a config of running servers + minor
tweaks
0.125.23: Patrick Crews 2011-10-26 Cleanup of xtrabackup tests
0.125.22: patrick crews 2011-10-26 Work on cleaning up xtrabackup tests
0.125.21: Patrick Crews 2011-10-26 Initial xtrabackup test working.
0.125.20: patrick crews 2011-10-26 Tweaks for xtrabackup + mysql cnf files
0.125.19: Patrick Crews 2011-10-26 Updated --gendata option for MySQL &
Percona Servers + additonal xtrabackup work
0.125.18: patrick crews 2011-10-26 Initial xtrabackup test + code to make
it happen
0.125.17: patrick crews 2011-10-22 [merge] Merge trunk
0.126.1: Patrick Crews 2011-10-20 Rename of directories
0.125.16: patrick crews 2011-10-22 Added handling for non-existent pid file
for new kill_pid() method - eg server crashed
0.125.15: patrick crews 2011-10-20 Tweaks to drizzle randgen tests
0.125.14: patrick crews 2011-10-20 Finish migration of drizzle randgen
tests to native mode
0.125.13: patrick crews 2011-10-20 Migrated drizzle innodb trx log tests to
unittest mode
0.125.12: patrick crews 2011-10-19 Minor fix of output management
0.125.11: patrick crews 2011-10-19 Remove outdated / retired code
0.125.10: patrick crews 2011-10-19 Added crashme and sqlbench suites / made
them unittest mode
0.125.9: patrick crews 2011-10-19 Tweaks and improvements. Made randgen
mode move to native mode (randgen runs = python unittest modules)
0.125.8: patrick crews 2011-10-18 Updated example test - we can pass our
servers and other relevant objects to a test case : )
0.125.7: patrick crews 2011-10-18 Initial docs merge
0.125.6: patrick crews 2011-10-13 Native mode working...mostly
0.125.5: patrick crews 2011-10-13 Code to introduce native (unittest /
python module) mode
0.125.4: patrick crews 2011-10-13 Further progress on using mysql / percona
trees + creation of randgen tests / grammar dir for percona
0.125.3: patrick crews 2011-10-12 Further tweaks for mysql / percona
goodness
0.125.2: patrick crews 2011-10-10 Additional code to run mysql+percona
servers
0.125.1: patrick crews 2011-10-05 Initial branch
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
