=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   1106
RUN DATE: 2012-03-08T23:17:48.682586
SERVER:   drizzled
VERSION:  staging
REVISION: 2524
COMMENT:  2524: Continuous Integr... 2012-03-08 [merge] 
http://jenkins.drizzle.org/job/promote-drizzle-build/12/

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       -3.23%      -1.00    
25.00   33.00   31.00    3.03
innodb  alter_table_drop                     25.00       -0.00%       0.00    
24.00   26.00   25.00    0.63
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       +7.89%       1.20    
13.00   18.00   15.20    2.32
innodb  count_distinct                        6.00      +11.76%       0.80     
6.00    8.00    6.80    0.75
innodb  count_distinct_2                     13.00       +5.80%       0.80    
12.00   15.00   13.80    1.17
innodb  count_distinct_big                   20.00       +6.54%       1.40    
20.00   24.00   21.40    1.74
innodb  count_distinct_group                 14.00       +1.41%       0.20    
14.00   15.00   14.20    0.40
innodb  count_distinct_group_on_key           9.00       +4.26%       0.40     
8.00   11.00    9.40    1.02
innodb  count_distinct_group_on_key_parts    14.00      -11.11%      -1.40    
11.00   14.00   12.60    1.36
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             11.00       +1.79%       0.20    
11.00   12.00   11.20    0.40
innodb  count_on_key                         98.00       -1.24%      -1.20    
93.00   99.00   96.80    2.40
innodb  create+drop                          34.00       -1.80%      -0.60    
32.00   35.00   33.40    1.02
innodb  create_index                          3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  create_key+drop                      33.00       -3.13%      -1.00    
31.00   34.00   32.00    1.26
innodb  create_MANY_tables                   20.00       +1.96%       0.40    
20.00   21.00   20.40    0.49
innodb  delete_all_many_keys               1092.00      -23.73%    -209.40   
782.00 1092.00  882.60  117.20
innodb  delete_autocommit                     4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  delete_big                            0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_big_many_keys               1091.00      -23.64%    -208.60   
782.00 1091.00  882.40  116.84
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          8.00       +4.76%       0.40     
8.00    9.00    8.40    0.49
innodb  delete_rollback                       3.00      -36.36%      -0.80     
2.00    3.00    2.20    0.40
innodb  drop_index                            3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  drop_table_when_MANY_tables          18.00       +3.23%       0.60    
18.00   19.00   18.60    0.49
innodb  insert                              115.00       -0.17%      -0.20   
114.00  115.00  114.80    0.40
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                    21.00       -6.06%      -1.20    
19.00   21.00   19.80    0.75
innodb  insert_key                          276.00       +2.06%       5.80   
273.00  287.00  281.80    6.05
innodb  insert_many_fields                    6.00       -3.45%      -0.20     
5.00    6.00    5.80    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       -4.17%      -0.20     
4.00    6.00    4.80    0.75
innodb  insert_select_2_keys                  6.00       +6.25%       0.40     
6.00    7.00    6.40    0.49
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.45%      -0.20     
5.00    6.00    5.80    0.40
innodb  once_prepared_select                 30.00       -1.35%      -0.40    
29.00   30.00   29.60    0.49
innodb  order_by_big                         14.00       +1.41%       0.20    
12.00   15.00   14.20    1.17
innodb  order_by_big_key                     11.00      +21.43%       3.00    
11.00   15.00   14.00    1.55
innodb  order_by_big_key2                    12.00       -0.00%       0.00    
11.00   13.00   12.00    0.63
innodb  order_by_big_key_desc                13.00      +12.16%       1.80    
13.00   16.00   14.80    0.98
innodb  order_by_big_key_diff                12.00       +1.64%       0.20    
12.00   13.00   12.20    0.40
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      -42.86%      -0.60     
1.00    2.00    1.40    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                           23.00       -0.00%       0.00    
23.00   23.00   23.00    0.00
innodb  outer_join_found                     22.00       -0.00%       0.00    
22.00   22.00   22.00    0.00
innodb  outer_join_not_found                 19.00       +3.06%       0.60    
19.00   21.00   19.60    0.80
innodb  outer_join_on_key                    14.00       +5.41%       0.80    
14.00   15.00   14.80    0.40
innodb  prepared_select                      36.00       +2.17%       0.80    
36.00   38.00   36.80    0.75
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      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_2_rows                         4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_big                           13.00       -0.00%       0.00    
13.00   13.00   13.00    0.00
innodb  select_big_str                        1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  select_cache                         67.00       -3.08%      -2.00    
61.00   68.00   65.00    2.90
innodb  select_cache2                        66.00       -2.80%      -1.80    
59.00   68.00   64.20    3.25
innodb  select_column+column                  4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
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                         19.00      -13.10%      -2.20    
15.00   19.00   16.80    1.83
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                           65.00       -1.56%      -1.00    
63.00   65.00   64.00    0.63
innodb  select_key2                          71.00       +0.28%       0.20    
70.00   73.00   71.20    0.98
innodb  select_key2_return_key               69.00       -0.88%      -0.60    
68.00   69.00   68.40    0.49
innodb  select_key2_return_prim              70.00       -0.29%      -0.20    
68.00   71.00   69.80    0.98
innodb  select_key_prefix                    71.00       -0.28%      -0.20    
70.00   71.00   70.80    0.40
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       -1.27%      -0.80    
63.00   64.00   63.20    0.40
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         41.00       +9.69%       4.40    
41.00   50.00   45.40    3.72
innodb  select_range_key2                    10.00       -0.00%       0.00    
10.00   10.00   10.00    0.00
innodb  select_range_prefix                   9.00       -0.00%       0.00     
9.00    9.00    9.00    0.00
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      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  update_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  update_big                           58.00       -0.00%       0.00    
57.00   59.00   58.00    0.63
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        22.00       +2.65%       0.60    
22.00   24.00   22.60    0.80
innodb  update_of_key_big                    18.00       +7.22%       1.40    
18.00   21.00   19.40    1.02
innodb  update_of_primary_key_many_keys    1177.00       +7.18%      91.00  
1177.00 1298.00 1268.00   46.52
innodb  update_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  update_with_key                     119.00       +1.49%       1.80   
119.00  123.00  120.80    1.47
innodb  update_with_key_prefix               44.00       -2.80%      -1.20    
41.00   44.00   42.80    1.17
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                      32.00       -5.61%      -1.70    
24.00   34.00   30.30    3.08
innodb  alter_table_drop                     25.00       -0.40%      -0.10    
23.00   26.00   24.90    0.83
innodb  connect                               3.00      -33.33%      -0.75     
2.00    3.00    2.25    0.43
innodb  connect+select_1_row                  3.00       -1.69%      -0.05     
2.00    3.00    2.95    0.22
innodb  connect+select_simple                 2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  count                                14.00      +11.67%       1.85    
13.00   18.00   15.85    2.06
innodb  count_distinct                        6.00      +11.11%       0.75     
6.00    8.00    6.75    0.83
innodb  count_distinct_2                     13.00       +5.11%       0.70    
12.00   16.00   13.70    1.31
innodb  count_distinct_big                   20.00      +10.51%       2.35    
20.00   25.00   22.35    2.03
innodb  count_distinct_group                 14.00       +2.10%       0.30    
11.00   16.00   14.30    1.10
innodb  count_distinct_group_on_key           9.00       +6.74%       0.65     
8.00   12.00    9.65    1.24
innodb  count_distinct_group_on_key_parts    14.00       -6.87%      -0.90    
11.00   15.00   13.10    1.51
innodb  count_distinct_key_prefix             5.00       +4.76%       0.25     
4.00    6.00    5.25    0.70
innodb  count_group_on_key_parts             11.00       +1.79%       0.20    
11.00   12.00   11.20    0.40
innodb  count_on_key                         98.00       -3.27%      -3.10    
91.00   99.00   94.90    2.47
innodb  create+drop                          34.00       -1.64%      -0.55    
32.00   35.00   33.45    0.92
innodb  create_index                          3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  create_key+drop                      33.00       -5.10%      -1.60    
30.00   34.00   31.40    1.11
innodb  create_MANY_tables                   20.00       +3.15%       0.65    
20.00   22.00   20.65    0.57
innodb  delete_all_many_keys               1092.00      -24.15%    -212.45   
716.00 1092.00  879.55  124.80
innodb  delete_autocommit                     4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  delete_big                            0.00     +100.00%       0.35     
0.00    1.00    0.35    0.48
innodb  delete_big_many_keys               1091.00      -24.11%    -211.95   
715.00 1091.00  879.05  124.57
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       +1.64%       0.05     
3.00    4.00    3.05    0.22
innodb  delete_range                          8.00       -1.91%      -0.15     
7.00    9.00    7.85    0.57
innodb  delete_rollback                       3.00      -42.86%      -0.90     
2.00    3.00    2.10    0.30
innodb  drop_index                            3.00       +1.64%       0.05     
2.00    4.00    3.05    0.38
innodb  drop_table_when_MANY_tables          18.00       +5.26%       1.00    
18.00   20.00   19.00    0.63
innodb  insert                              115.00       -0.48%      -0.55   
112.00  117.00  114.45    1.43
innodb  insert_autocommit                     3.00       +9.09%       0.30     
3.00    4.00    3.30    0.46
innodb  insert_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  insert_duplicates                    21.00       -5.53%      -1.10    
19.00   21.00   19.90    0.44
innodb  insert_key                          276.00       +1.69%       4.75   
272.00  290.00  280.75    4.88
innodb  insert_many_fields                    6.00       -2.56%      -0.15     
5.00    7.00    5.85    0.48
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   5.00       -2.04%      -0.10     
4.00    6.00    4.90    0.54
innodb  insert_select_2_keys                  6.00       +7.69%       0.50     
6.00    8.00    6.50    0.59
innodb  min_max                               7.00      +15.15%       1.25     
7.00   10.00    8.25    0.99
innodb  min_max_on_key                       24.00       +3.42%       0.85    
24.00   27.00   24.85    0.79
innodb  multiple_value_insert                 6.00       -2.56%      -0.15     
5.00    6.00    5.85    0.36
innodb  once_prepared_select                 30.00       -1.35%      -0.40    
29.00   30.00   29.60    0.49
innodb  order_by_big                         14.00       -4.09%      -0.55    
12.00   16.00   13.45    1.32
innodb  order_by_big_key                     11.00      +22.81%       3.25    
11.00   16.00   14.25    1.22
innodb  order_by_big_key2                    12.00       +2.44%       0.30    
11.00   14.00   12.30    0.84
innodb  order_by_big_key_desc                13.00      +11.86%       1.75    
13.00   16.00   14.75    0.70
innodb  order_by_big_key_diff                12.00       +1.23%       0.15    
11.00   14.00   12.15    0.79
innodb  order_by_big_key_prefix              13.00       -1.17%      -0.15    
12.00   14.00   12.85    0.57
innodb  order_by_key2_diff                    2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
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      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  outer_join                           23.00       -4.07%      -0.90    
18.00   24.00   22.10    1.70
innodb  outer_join_found                     22.00       -3.77%      -0.80    
16.00   23.00   21.20    1.94
innodb  outer_join_not_found                 19.00       -1.06%      -0.20    
16.00   21.00   18.80    1.40
innodb  outer_join_on_key                    14.00       +0.71%       0.10    
11.00   15.00   14.10    1.26
innodb  prepared_select                      36.00       +3.23%       1.20    
36.00   38.00   37.20    0.68
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      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  select_2_rows                         4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_big                           13.00       -3.17%      -0.40    
10.00   14.00   12.60    1.02
innodb  select_big_str                        1.00      +25.93%       0.35     
1.00    2.00    1.35    0.48
innodb  select_cache                         67.00       -4.69%      -3.00    
59.00   68.00   64.00    2.70
innodb  select_cache2                        66.00       -1.38%      -0.90    
57.00   72.00   65.10    3.59
innodb  select_column+column                  4.00       -1.27%      -0.05     
3.00    4.00    3.95    0.22
innodb  select_diff_key                       0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  select_distinct                       5.00       -7.53%      -0.35     
4.00    5.00    4.65    0.48
innodb  select_group                         19.00      -12.09%      -2.05    
15.00   19.00   16.95    1.66
innodb  select_group_when_MANY_tables        12.00       -0.42%      -0.05    
11.00   14.00   11.95    0.74
innodb  select_join                           0.00     +100.00%       0.70     
0.00    1.00    0.70    0.46
innodb  select_key                           65.00       -0.93%      -0.60    
63.00   66.00   64.40    0.66
innodb  select_key2                          71.00       +0.42%       0.30    
70.00   73.00   71.30    1.00
innodb  select_key2_return_key               69.00       -0.51%      -0.35    
67.00   70.00   68.65    0.73
innodb  select_key2_return_prim              70.00       -0.14%      -0.10    
68.00   71.00   69.90    0.89
innodb  select_key_prefix                    71.00       -0.07%      -0.05    
70.00   73.00   70.95    0.80
innodb  select_key_prefix_join                5.00       -4.17%      -0.20     
4.00    6.00    4.80    0.51
innodb  select_key_return_key                64.00       -1.03%      -0.65    
62.00   65.00   63.35    0.73
innodb  select_many_fields                   13.00       +0.38%       0.05    
13.00   14.00   13.05    0.22
innodb  select_range                         41.00       +7.45%       3.30    
40.00   50.00   44.30    3.26
innodb  select_range_key2                    10.00       -1.01%      -0.10     
9.00   11.00    9.90    0.44
innodb  select_range_prefix                   9.00       -2.27%      -0.20     
8.00   10.00    8.80    0.68
innodb  select_simple                         2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  select_simple_cache                   2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_join                    1.00      -33.33%      -0.25     
0.00    1.00    0.75    0.43
innodb  update_autocommit                     3.00      +15.49%       0.55     
3.00    4.00    3.55    0.50
innodb  update_big                           58.00       -0.96%      -0.55    
55.00   61.00   57.45    1.36
innodb  update_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  update_of_key                        22.00       +2.87%       0.65    
21.00   24.00   22.65    0.91
innodb  update_of_key_big                    18.00       +4.76%       0.90    
18.00   21.00   18.90    0.89
innodb  update_of_primary_key_many_keys    1177.00       +8.09%     103.55  
1177.00 1339.00 1280.55   38.19
innodb  update_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  update_with_key                     119.00       +1.08%       1.30   
117.00  124.00  120.30    1.71
innodb  update_with_key_prefix               44.00       -1.85%      -0.80    
41.00   46.00   43.20    1.33
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      -40.16%      -9.17    
11.00   61.00   22.83   10.09
innodb  alter_table_drop                     25.00      -29.17%      -5.65    
10.00   57.00   19.35    6.73
innodb  connect                               3.00      -42.54%      -0.90     
1.00    3.00    2.10    0.42
innodb  connect+select_1_row                  3.00       -9.52%      -0.26     
2.00    5.00    2.74    0.45
innodb  connect+select_simple                 2.00      +16.27%       0.39     
1.00    3.00    2.39    0.49
innodb  count                                14.00      +11.24%       1.77    
12.00  193.00   15.77    8.10
innodb  count_distinct                        6.00       +9.38%       0.62     
5.00   50.00    6.62    2.11
innodb  count_distinct_2                     13.00       +2.10%       0.28    
11.00   63.00   13.28    2.76
innodb  count_distinct_big                   20.00       +9.47%       2.09     
5.00   67.00   22.09    2.89
innodb  count_distinct_group                 14.00       -4.75%      -0.63    
10.00   68.00   13.37    2.90
innodb  count_distinct_group_on_key           9.00       +5.75%       0.55     
7.00   69.00    9.55    2.79
innodb  count_distinct_group_on_key_parts    14.00      -12.26%      -1.53     
9.00   72.00   12.47    2.95
innodb  count_distinct_key_prefix             5.00       +3.03%       0.16     
3.00   52.00    5.16    2.20
innodb  count_group_on_key_parts             11.00       -8.25%      -0.84     
7.00   72.00   10.16    2.92
innodb  count_on_key                         98.00      -12.04%     -10.53    
68.00  107.00   87.47    7.59
innodb  create+drop                          34.00       -4.40%      -1.43    
18.00   75.00   32.57   10.86
innodb  create_index                          3.00       -2.69%      -0.08     
1.00    8.00    2.92    1.06
innodb  create_key+drop                      33.00      -14.83%      -4.26    
21.00   50.00   28.74    4.68
innodb  create_MANY_tables                   20.00      +37.25%      11.87    
14.00  121.00   31.87   16.37
innodb  create_table                          0.00     +100.00%       0.09     
0.00    3.00    0.09    0.34
innodb  delete_all_many_keys               1092.00     -109.95%    -571.87   
212.00 1888.00  520.13  358.93
innodb  delete_autocommit                     4.00      -15.23%      -0.53     
2.00   14.00    3.47    0.72
innodb  delete_big                            0.00     +100.00%       0.31     
0.00    3.00    0.31    0.47
innodb  delete_big_many_keys               1091.00     -107.84%    -566.09   
212.00 2293.00  524.91  370.12
innodb  delete_commit                         2.00      -26.97%      -0.42     
1.00    5.00    1.58    0.52
innodb  delete_key                            3.00       +0.83%       0.03     
2.00   35.00    3.03    1.38
innodb  delete_range                          8.00       +3.63%       0.30     
5.00   23.00    8.30    2.97
innodb  delete_rollback                       3.00      -67.19%      -1.21     
1.00   12.00    1.79    0.85
innodb  drop_index                            3.00       -1.31%      -0.04     
1.00    9.00    2.96    1.22
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.22
innodb  drop_table_when_MANY_tables          18.00       +7.46%       1.45    
11.00   90.00   19.45    6.89
innodb  insert                              115.00       -6.69%      -7.21     
3.00  343.00  107.79   13.57
innodb  insert_autocommit                     3.00       +0.99%       0.03     
2.00   99.00    3.03    3.03
innodb  insert_commit                         2.00      -37.65%      -0.55     
1.00    3.00    1.45    0.51
innodb  insert_duplicates                    21.00      -30.42%      -4.90    
11.00   21.00   16.10    2.83
innodb  insert_key                          276.00       +7.75%      23.18   
142.00  700.00  299.18   97.44
innodb  insert_many_fields                    6.00       -6.52%      -0.37     
3.00   17.00    5.63    1.63
innodb  insert_rollback                       2.00      -16.04%      -0.28     
1.00    3.00    1.72    0.51
innodb  insert_select_1_key                   5.00      -27.76%      -1.09     
2.00   10.00    3.91    0.92
innodb  insert_select_2_keys                  6.00       +1.80%       0.11     
4.00   16.00    6.11    1.93
innodb  min_max                               7.00      +10.90%       0.86     
6.00  110.00    7.86    4.17
innodb  min_max_on_key                       24.00      -13.11%      -2.78    
14.00   37.00   21.22    3.21
innodb  multiple_value_insert                 6.00       -8.21%      -0.46     
2.00   50.00    5.54    3.93
innodb  once_prepared_select                 30.00      -19.94%      -4.99    
18.00   32.00   25.01    3.74
innodb  order_by_big                         14.00       +1.86%       0.27    
12.00   31.00   14.27    1.47
innodb  order_by_big_key                     11.00      +18.16%       2.44    
11.00   32.00   13.44    1.63
innodb  order_by_big_key2                    12.00       +2.41%       0.30    
10.00   33.00   12.30    1.48
innodb  order_by_big_key_desc                13.00       +5.37%       0.74    
11.00   32.00   13.74    1.68
innodb  order_by_big_key_diff                12.00       +2.63%       0.32    
10.00   31.00   12.32    1.44
innodb  order_by_big_key_prefix              13.00       -3.94%      -0.49    
10.00   32.00   12.51    1.48
innodb  order_by_key2_diff                    2.00      -42.86%      -0.60     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   0.00     +100.00%       0.81     
0.00    2.00    0.81    0.40
innodb  order_by_range                        1.00      -18.53%      -0.16     
0.00    2.00    0.84    0.37
innodb  outer_join                           23.00      -16.25%      -3.21    
15.00   61.00   19.79    3.68
innodb  outer_join_found                     22.00      -14.94%      -2.86    
14.00   58.00   19.14    3.51
innodb  outer_join_not_found                 19.00      -12.50%      -2.11    
12.00   46.00   16.89    3.19
innodb  outer_join_on_key                    14.00       -6.65%      -0.87    
10.00   59.00   13.13    2.67
innodb  prepared_select                      36.00      -11.63%      -3.75    
22.00   40.00   32.25    4.63
innodb  select_1_row                          4.00      -34.46%      -1.03     
2.00    4.00    2.97    0.72
innodb  select_1_row_cache                    3.00       -6.61%      -0.19     
2.00    4.00    2.81    0.72
innodb  select_2_rows                         4.00      -32.99%      -0.99     
2.00    4.00    3.01    0.73
innodb  select_big                           13.00       -6.15%      -0.75     
0.00   31.00   12.25    1.49
innodb  select_big_str                        1.00      +16.63%       0.20     
0.00    2.00    1.20    0.40
innodb  select_cache                         67.00      -10.96%      -6.62    
49.00   79.00   60.38    5.64
innodb  select_cache2                        66.00       -8.41%      -5.12    
49.00   88.00   60.88    6.33
innodb  select_column+column                  4.00      -30.39%      -0.93     
2.00    4.00    3.07    0.75
innodb  select_diff_key                       0.00     +100.00%       0.23     
0.00    1.00    0.23    0.42
innodb  select_distinct                       5.00      -16.37%      -0.70     
3.00    8.00    4.30    0.55
innodb  select_group                         19.00      -15.97%      -2.62     
4.00  136.00   16.38    5.01
innodb  select_group_when_MANY_tables        12.00      -21.57%      -2.13     
3.00   49.00    9.87    8.70
innodb  select_join                           0.00     +100.00%       0.59     
0.00    1.00    0.59    0.49
innodb  select_key                           65.00      -19.05%     -10.40    
40.00   67.00   54.60    7.99
innodb  select_key2                          71.00      -15.80%      -9.69    
45.00   75.00   61.31    8.69
innodb  select_key2_return_key               69.00      -17.62%     -10.33    
42.00   71.00   58.67    8.56
innodb  select_key2_return_prim              70.00      -17.78%     -10.57    
42.00   72.00   59.43    8.69
innodb  select_key_prefix                    71.00      -17.11%     -10.37    
44.00   75.00   60.63    8.78
innodb  select_key_prefix_join                5.00       -4.14%      -0.20     
3.00   10.00    4.80    0.66
innodb  select_key_return_key                64.00      -19.38%     -10.39    
38.00   66.00   53.61    7.98
innodb  select_many_fields                   13.00      +11.35%       1.66    
11.00   19.00   14.66    1.77
innodb  select_range                         41.00      +11.88%       5.53    
38.00   76.00   46.53    4.05
innodb  select_range_key2                    10.00      -17.93%      -1.52     
6.00   11.00    8.48    1.10
innodb  select_range_prefix                   9.00      -11.73%      -0.94     
5.00   10.00    8.06    1.16
innodb  select_simple                         2.00      -16.61%      -0.28     
1.00    3.00    1.72    0.50
innodb  select_simple_cache                   2.00      -22.27%      -0.36     
1.00    3.00    1.64    0.51
innodb  select_simple_join                    1.00      -48.92%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     3.00      +10.58%       0.35     
2.00   16.00    3.35    0.95
innodb  update_big                           58.00      -11.10%      -5.79    
31.00  195.00   52.21   22.55
innodb  update_commit                         2.00      -22.81%      -0.37     
1.00   10.00    1.63    0.69
innodb  update_of_key                        22.00       +7.99%       1.91    
18.00  100.00   23.91    5.70
innodb  update_of_key_big                    18.00      +33.52%       9.07    
15.00   75.00   27.07   10.64
innodb  update_of_primary_key_many_keys    1177.00       +6.02%      75.44   
647.00 6065.00 1252.44  857.54
innodb  update_rollback                       2.00      -10.56%      -0.19     
1.00   31.00    1.81    1.74
innodb  update_with_key                     119.00       -6.71%      -7.48    
90.00  598.00  111.52   19.40
innodb  update_with_key_prefix               44.00       -9.32%      -3.75    
33.00  202.00   40.25    6.43
innodb  wisc_benchmark                        2.00      +19.70%       0.49     
2.00    5.00    2.49    0.52

=========================================================================================================================
FULL REVISION COMMENTARY:

  2522.2.2: Continuous Integr... 2012-03-08 [merge] Merging 
lp:~brianaker/drizzle/next-docs to Build branch
    2521.3.3: Brian Aker 2012-03-07 [merge] Fix documentation + strlen usage.
      2522.3.1: Brian Aker 2012-03-07 Fix a number of documentation errors.

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help   : https://help.launchpad.net/ListHelp

Reply via email to