=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   1099
RUN DATE: 2012-03-04T11:53:55.746599
SERVER:   drizzled
VERSION:  staging
REVISION: 2519
COMMENT:  2519: Continuous Integr... 2012-03-04 [merge] Merge build tree to 
staging tree.

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       -8.11%      -2.40    
24.00   34.00   29.60    3.88
innodb  alter_table_drop                     24.00       +0.83%       0.20    
23.00   25.00   24.20    0.75
innodb  connect                               2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
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      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  count                                18.00      -18.42%      -2.80    
13.00   18.00   15.20    1.94
innodb  count_distinct                        6.00       +9.09%       0.60     
6.00    8.00    6.60    0.80
innodb  count_distinct_2                     13.00       +7.14%       1.00    
12.00   16.00   14.00    1.41
innodb  count_distinct_big                   25.00      -11.61%      -2.60    
20.00   25.00   22.40    2.15
innodb  count_distinct_group                 13.00      +12.16%       1.80    
13.00   16.00   14.80    0.98
innodb  count_distinct_group_on_key          10.00       +5.66%       0.60     
9.00   12.00   10.60    1.02
innodb  count_distinct_group_on_key_parts    14.00       +2.78%       0.40    
14.00   15.00   14.40    0.49
innodb  count_distinct_key_prefix             4.00      +23.08%       1.20     
4.00    6.00    5.20    0.75
innodb  count_group_on_key_parts             11.00       -0.00%       0.00    
11.00   11.00   11.00    0.00
innodb  count_on_key                         91.00       +2.36%       2.20    
91.00   96.00   93.20    1.72
innodb  create+drop                          35.00       -2.34%      -0.80    
33.00   35.00   34.20    0.75
innodb  create_index                          4.00      -25.00%      -0.80     
3.00    4.00    3.20    0.40
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.96%      -0.20    
20.00   22.00   20.80    0.75
innodb  delete_all_many_keys               1080.00      -26.94%    -229.20   
752.00 1080.00  850.80  119.21
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               1079.00      -26.88%    -228.60   
752.00 1079.00  850.40  118.82
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       -2.56%      -0.20     
7.00    8.00    7.80    0.40
innodb  delete_rollback                       2.00       +9.09%       0.20     
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          19.00       -1.06%      -0.20    
18.00   19.00   18.80    0.40
innodb  insert                              115.00       +0.17%       0.20   
113.00  117.00  115.20    1.33
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       -0.00%       0.00    
20.00   20.00   20.00    0.00
innodb  insert_key                          283.00       -1.00%      -2.80   
276.00  284.00  280.20    3.19
innodb  insert_many_fields                    5.00      +10.71%       0.60     
5.00    6.00    5.60    0.49
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   5.00       -8.70%      -0.40     
4.00    5.00    4.60    0.49
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.76%      -0.80     
7.00    9.00    8.20    0.98
innodb  min_max_on_key                       26.00       -4.84%      -1.20    
24.00   26.00   24.80    0.75
innodb  multiple_value_insert                 6.00       -3.45%      -0.20     
5.00    6.00    5.80    0.40
innodb  once_prepared_select                 29.00       +2.03%       0.60    
29.00   30.00   29.60    0.49
innodb  order_by_big                         12.00       +4.76%       0.60    
12.00   14.00   12.60    0.80
innodb  order_by_big_key                     15.00       -4.17%      -0.60    
13.00   15.00   14.40    0.80
innodb  order_by_big_key2                    12.00       +1.64%       0.20    
12.00   13.00   12.20    0.40
innodb  order_by_big_key_desc                13.00      +10.96%       1.60    
13.00   15.00   14.60    0.80
innodb  order_by_big_key_diff                13.00       -8.33%      -1.00    
11.00   13.00   12.00    0.89
innodb  order_by_big_key_prefix              12.00       +4.76%       0.60    
12.00   13.00   12.60    0.49
innodb  order_by_key2_diff                    1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
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                           18.00      +11.76%       2.40    
18.00   22.00   20.40    1.96
innodb  outer_join_found                     17.00      +14.14%       2.80    
16.00   22.00   19.80    2.71
innodb  outer_join_not_found                 16.00      +12.09%       2.20    
16.00   20.00   18.20    1.83
innodb  outer_join_on_key                    12.00       +9.09%       1.20    
11.00   15.00   13.20    1.47
innodb  prepared_select                      37.00       +0.54%       0.20    
37.00   38.00   37.20    0.40
innodb  select_1_row                          3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  select_1_row_cache                    4.00      -17.65%      -0.60     
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    
12.00   13.00   12.60    0.49
innodb  select_big_str                        2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  select_cache                         59.00       +7.23%       4.60    
59.00   67.00   63.60    3.20
innodb  select_cache2                        65.00       -1.56%      -1.00    
57.00   71.00   64.00    4.56
innodb  select_column+column                  3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  select_diff_key                       1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  select_distinct                       5.00       -4.17%      -0.20     
4.00    5.00    4.80    0.40
innodb  select_group                         16.00       +3.61%       0.60    
15.00   19.00   16.60    1.62
innodb  select_group_when_MANY_tables        12.00       -1.69%      -0.20    
11.00   12.00   11.80    0.40
innodb  select_join                           1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  select_key                           64.00       +0.31%       0.20    
64.00   65.00   64.20    0.40
innodb  select_key2                          70.00       +1.41%       1.00    
70.00   72.00   71.00    0.89
innodb  select_key2_return_key               69.00       -0.58%      -0.40    
67.00   69.00   68.60    0.80
innodb  select_key2_return_prim              69.00       +0.86%       0.60    
69.00   71.00   69.60    0.80
innodb  select_key_prefix                    70.00       +1.13%       0.80    
70.00   72.00   70.80    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                63.00       -0.00%       0.00    
62.00   64.00   63.00    0.63
innodb  select_many_fields                   13.00       -0.00%       0.00    
13.00   13.00   13.00    0.00
innodb  select_range                         44.00       -1.85%      -0.80    
41.00   48.00   43.20    2.64
innodb  select_range_key2                    10.00       -0.00%       0.00    
10.00   10.00   10.00    0.00
innodb  select_range_prefix                   8.00       +6.98%       0.60     
8.00    9.00    8.60    0.49
innodb  select_simple                         3.00      -36.36%      -0.80     
2.00    3.00    2.20    0.40
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  update_autocommit                     4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  update_big                           57.00       +0.35%       0.20    
55.00   59.00   57.20    1.60
innodb  update_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  update_of_key                        22.00       +0.90%       0.20    
21.00   24.00   22.20    0.98
innodb  update_of_key_big                    19.00       -2.15%      -0.40    
18.00   20.00   18.60    0.80
innodb  update_of_primary_key_many_keys    1239.00       +3.74%      48.20  
1239.00 1316.00 1287.20   27.31
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     119.00       +0.34%       0.40   
117.00  121.00  119.40    1.50
innodb  update_with_key_prefix               44.00       +0.45%       0.20    
43.00   46.00   44.20    1.17
innodb  wisc_benchmark                        3.00       -7.14%      -0.20     
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       -2.56%      -0.80    
24.00   34.00   31.20    2.66
innodb  alter_table_drop                     24.00       +3.03%       0.75    
23.00   26.00   24.75    0.89
innodb  connect                               2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
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      +24.53%       0.65     
2.00    3.00    2.65    0.48
innodb  count                                18.00      -12.85%      -2.05    
13.00   18.00   15.95    1.91
innodb  count_distinct                        6.00      +10.45%       0.70     
6.00    8.00    6.70    0.78
innodb  count_distinct_2                     13.00       +5.11%       0.70    
12.00   17.00   13.70    1.62
innodb  count_distinct_big                   25.00       -7.99%      -1.85    
20.00   25.00   23.15    2.01
innodb  count_distinct_group                 13.00       +9.41%       1.35    
11.00   16.00   14.35    1.19
innodb  count_distinct_group_on_key          10.00       +0.50%       0.05     
8.00   12.00   10.05    1.20
innodb  count_distinct_group_on_key_parts    14.00       -2.94%      -0.40    
11.00   15.00   13.60    1.50
innodb  count_distinct_key_prefix             4.00      +20.79%       1.05     
4.00    6.00    5.05    0.67
innodb  count_group_on_key_parts             11.00       +1.35%       0.15    
11.00   12.00   11.15    0.36
innodb  count_on_key                         91.00       +3.50%       3.30    
90.00   99.00   94.30    2.45
innodb  create+drop                          35.00       -4.48%      -1.50    
32.00   35.00   33.50    0.87
innodb  create_index                          4.00      -31.15%      -0.95     
3.00    4.00    3.05    0.22
innodb  create_key+drop                      31.00       +1.43%       0.45    
30.00   35.00   31.45    1.36
innodb  create_MANY_tables                   21.00       +0.71%       0.15    
20.00   24.00   21.15    0.91
innodb  delete_all_many_keys               1080.00      -22.34%    -197.25   
691.00 1123.00  882.75  130.10
innodb  delete_autocommit                     4.00       -9.59%      -0.35     
3.00    4.00    3.65    0.48
innodb  delete_big                            0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys               1079.00      -22.32%    -196.90   
691.00 1122.00  882.10  129.87
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.58%      -0.35     
7.00    8.00    7.65    0.48
innodb  delete_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  drop_index                            3.00       +1.64%       0.05     
3.00    4.00    3.05    0.22
innodb  drop_table_when_MANY_tables          19.00       +0.78%       0.15    
18.00   21.00   19.15    0.79
innodb  insert                              115.00       -0.66%      -0.75   
112.00  117.00  114.25    1.58
innodb  insert_autocommit                     3.00      +10.45%       0.35     
3.00    4.00    3.35    0.48
innodb  insert_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  insert_duplicates                    20.00       -0.25%      -0.05    
19.00   21.00   19.95    0.38
innodb  insert_key                          283.00       -1.29%      -3.60   
265.00  290.00  279.40    5.09
innodb  insert_many_fields                    5.00      +13.79%       0.80     
5.00    7.00    5.80    0.51
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.99%       0.05     
4.00    6.00    5.05    0.59
innodb  insert_select_2_keys                  6.00       +7.69%       0.50     
6.00    8.00    6.50    0.59
innodb  min_max                               9.00       -9.76%      -0.80     
6.00   10.00    8.20    1.08
innodb  min_max_on_key                       26.00       -4.21%      -1.05    
24.00   27.00   24.95    0.80
innodb  multiple_value_insert                 6.00       -2.56%      -0.15     
5.00    7.00    5.85    0.48
innodb  once_prepared_select                 29.00       +1.69%       0.50    
29.00   30.00   29.50    0.50
innodb  order_by_big                         12.00      +10.78%       1.45    
12.00   16.00   13.45    1.28
innodb  order_by_big_key                     15.00       -4.17%      -0.60    
12.00   16.00   14.40    1.11
innodb  order_by_big_key2                    12.00       +4.76%       0.60    
11.00   14.00   12.60    0.97
innodb  order_by_big_key_desc                13.00      +12.16%       1.80    
13.00   16.00   14.80    0.75
innodb  order_by_big_key_diff                13.00       -6.56%      -0.80    
11.00   14.00   12.20    0.93
innodb  order_by_big_key_prefix              12.00       +8.05%       1.05    
12.00   15.00   13.05    0.74
innodb  order_by_key2_diff                    1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  order_by_key_prefix                   1.00       -5.26%      -0.05     
0.00    1.00    0.95    0.22
innodb  order_by_range                        1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  outer_join                           18.00      +16.08%       3.45    
17.00   24.00   21.45    2.22
innodb  outer_join_found                     17.00      +17.87%       3.70    
16.00   23.00   20.70    2.30
innodb  outer_join_not_found                 16.00      +13.51%       2.50    
15.00   21.00   18.50    1.75
innodb  outer_join_on_key                    12.00      +12.41%       1.70    
11.00   15.00   13.70    1.42
innodb  prepared_select                      37.00       +0.80%       0.30    
36.00   38.00   37.30    0.56
innodb  select_1_row                          3.00      +20.00%       0.75     
3.00    4.00    3.75    0.43
innodb  select_1_row_cache                    4.00      -15.94%      -0.55     
3.00    4.00    3.45    0.50
innodb  select_2_rows                         4.00       -3.90%      -0.15     
3.00    4.00    3.85    0.36
innodb  select_big                           13.00       -4.84%      -0.60    
10.00   14.00   12.40    1.11
innodb  select_big_str                        2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  select_cache                         59.00       +7.81%       5.00    
57.00   79.00   64.00    4.36
innodb  select_cache2                        65.00       +2.33%       1.55    
57.00   88.00   66.55    6.02
innodb  select_column+column                  3.00      +22.08%       0.85     
3.00    4.00    3.85    0.36
innodb  select_diff_key                       1.00     -122.22%      -0.55     
0.00    1.00    0.45    0.50
innodb  select_distinct                       5.00       -8.70%      -0.40     
4.00    5.00    4.60    0.49
innodb  select_group                         16.00       +6.71%       1.15    
15.00   20.00   17.15    1.68
innodb  select_group_when_MANY_tables        12.00       -0.42%      -0.05    
11.00   14.00   11.95    0.74
innodb  select_join                           1.00      -33.33%      -0.25     
0.00    1.00    0.75    0.43
innodb  select_key                           64.00       +1.01%       0.65    
64.00   66.00   64.65    0.65
innodb  select_key2                          70.00       +2.17%       1.55    
70.00   73.00   71.55    0.80
innodb  select_key2_return_key               69.00       -0.15%      -0.10    
67.00   70.00   68.90    0.70
innodb  select_key2_return_prim              69.00       +1.43%       1.00    
69.00   71.00   70.00    0.77
innodb  select_key_prefix                    70.00       +1.55%       1.10    
70.00   73.00   71.10    0.83
innodb  select_key_prefix_join                5.00       -5.26%      -0.25     
4.00    5.00    4.75    0.43
innodb  select_key_return_key                63.00       +1.02%       0.65    
62.00   65.00   63.65    0.73
innodb  select_many_fields                   13.00       -0.39%      -0.05    
12.00   13.00   12.95    0.22
innodb  select_range                         44.00       -1.27%      -0.55    
40.00   48.00   43.45    2.60
innodb  select_range_key2                    10.00       -1.01%      -0.10     
9.00   11.00    9.90    0.44
innodb  select_range_prefix                   8.00       +8.05%       0.70     
8.00   10.00    8.70    0.71
innodb  select_simple                         3.00      -42.86%      -0.90     
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                    0.00     +100.00%       0.70     
0.00    1.00    0.70    0.46
innodb  update_autocommit                     4.00      -15.94%      -0.55     
3.00    4.00    3.45    0.50
innodb  update_big                           57.00       +0.35%       0.20    
55.00   61.00   57.20    1.40
innodb  update_commit                         2.00       -0.00%       0.00     
1.00    3.00    2.00    0.32
innodb  update_of_key                        22.00       +2.44%       0.55    
21.00   24.00   22.55    0.92
innodb  update_of_key_big                    19.00       -0.80%      -0.15    
18.00   20.00   18.85    0.73
innodb  update_of_primary_key_many_keys    1239.00       +3.26%      41.75  
1194.00 1351.00 1280.75   39.38
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     119.00       +0.83%       1.00   
117.00  124.00  120.00    1.67
innodb  update_with_key_prefix               44.00       -1.62%      -0.70    
41.00   46.00   43.30    1.35
innodb  wisc_benchmark                        3.00      -15.38%      -0.40     
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.46%      -9.22    
11.00   61.00   22.78   10.10
innodb  alter_table_drop                     24.00      -24.26%      -4.69    
10.00   57.00   19.31    6.73
innodb  connect                               2.00       +4.87%       0.10     
1.00    3.00    2.10    0.42
innodb  connect+select_1_row                  3.00       -9.55%      -0.26     
2.00    5.00    2.74    0.45
innodb  connect+select_simple                 2.00      +16.26%       0.39     
1.00    3.00    2.39    0.49
innodb  count                                18.00      -14.12%      -2.23    
12.00  193.00   15.77    8.12
innodb  count_distinct                        6.00       +9.37%       0.62     
5.00   50.00    6.62    2.11
innodb  count_distinct_2                     13.00       +2.09%       0.28    
11.00   63.00   13.28    2.77
innodb  count_distinct_big                   25.00      -13.15%      -2.91     
5.00   67.00   22.09    2.90
innodb  count_distinct_group                 13.00       +2.68%       0.36    
10.00   68.00   13.36    2.91
innodb  count_distinct_group_on_key          10.00       -4.69%      -0.45     
7.00   69.00    9.55    2.80
innodb  count_distinct_group_on_key_parts    14.00      -12.29%      -1.53     
9.00   72.00   12.47    2.96
innodb  count_distinct_key_prefix             4.00      +22.38%       1.15     
3.00   52.00    5.15    2.20
innodb  count_group_on_key_parts             11.00       -8.33%      -0.85     
7.00   72.00   10.15    2.92
innodb  count_on_key                         91.00       -4.11%      -3.59    
68.00  107.00   87.41    7.58
innodb  create+drop                          35.00       -7.49%      -2.44    
18.00   75.00   32.56   10.90
innodb  create_index                          4.00      -37.08%      -1.08     
1.00    8.00    2.92    1.06
innodb  create_key+drop                      31.00       -7.95%      -2.28    
21.00   50.00   28.72    4.69
innodb  create_MANY_tables                   21.00      +34.27%      10.95    
14.00  121.00   31.95   16.40
innodb  create_table                          0.00     +100.00%       0.09     
0.00    3.00    0.09    0.34
innodb  delete_all_many_keys               1080.00     -108.60%    -562.26   
212.00 1888.00  517.74  358.96
innodb  delete_autocommit                     4.00      -15.28%      -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               1079.00     -106.48%    -556.44   
212.00 2293.00  522.56  370.26
innodb  delete_commit                         2.00      -27.20%      -0.43     
1.00    5.00    1.57    0.52
innodb  delete_key                            3.00       +0.81%       0.02     
2.00   35.00    3.02    1.38
innodb  delete_range                          8.00       +3.64%       0.30     
5.00   23.00    8.30    2.98
innodb  delete_rollback                       2.00      -11.61%      -0.21     
1.00   12.00    1.79    0.85
innodb  drop_index                            3.00       -1.32%      -0.04     
1.00    9.00    2.96    1.23
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.35%       0.46    
11.00   90.00   19.46    6.92
innodb  insert                              115.00       -6.73%      -7.25     
3.00  343.00  107.75   13.60
innodb  insert_autocommit                     3.00       +0.94%       0.03     
2.00   99.00    3.03    3.04
innodb  insert_commit                         2.00      -37.82%      -0.55     
1.00    3.00    1.45    0.51
innodb  insert_duplicates                    20.00      -24.40%      -3.92    
11.00   21.00   16.08    2.82
innodb  insert_key                          283.00       +5.45%      16.31   
142.00  700.00  299.31   97.79
innodb  insert_many_fields                    5.00      +11.21%       0.63     
3.00   17.00    5.63    1.64
innodb  insert_rollback                       2.00      -16.17%      -0.28     
1.00    3.00    1.72    0.51
innodb  insert_select_1_key                   5.00      -27.97%      -1.09     
2.00   10.00    3.91    0.92
innodb  insert_select_2_keys                  6.00       +1.78%       0.11     
4.00   16.00    6.11    1.93
innodb  min_max                               9.00      -14.57%      -1.14     
6.00  110.00    7.86    4.19
innodb  min_max_on_key                       26.00      -22.67%      -4.81    
14.00   37.00   21.19    3.21
innodb  multiple_value_insert                 6.00       -8.23%      -0.46     
2.00   50.00    5.54    3.94
innodb  once_prepared_select                 29.00      -16.09%      -4.02    
18.00   32.00   24.98    3.73
innodb  order_by_big                         12.00      +15.89%       2.27    
12.00   31.00   14.27    1.47
innodb  order_by_big_key                     15.00      -11.64%      -1.56    
11.00   32.00   13.44    1.63
innodb  order_by_big_key2                    12.00       +2.42%       0.30    
10.00   33.00   12.30    1.48
innodb  order_by_big_key_desc                13.00       +5.32%       0.73    
11.00   32.00   13.73    1.68
innodb  order_by_big_key_diff                13.00       -5.46%      -0.67    
10.00   31.00   12.33    1.44
innodb  order_by_big_key_prefix              12.00       +4.03%       0.50    
10.00   32.00   12.50    1.49
innodb  order_by_key2_diff                    1.00      +28.51%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -23.85%      -0.19     
0.00    2.00    0.81    0.40
innodb  order_by_range                        1.00      -18.54%      -0.16     
0.00    2.00    0.84    0.37
innodb  outer_join                           18.00       +8.92%       1.76    
15.00   61.00   19.76    3.69
innodb  outer_join_found                     17.00      +11.08%       2.12    
14.00   58.00   19.12    3.52
innodb  outer_join_not_found                 16.00       +5.16%       0.87    
12.00   46.00   16.87    3.19
innodb  outer_join_on_key                    12.00       +8.51%       1.12    
10.00   59.00   13.12    2.68
innodb  prepared_select                      37.00      -14.84%      -4.78    
22.00   40.00   32.22    4.63
innodb  select_1_row                          3.00       -1.05%      -0.03     
2.00    4.00    2.97    0.72
innodb  select_1_row_cache                    4.00      -42.41%      -1.19     
2.00    4.00    2.81    0.72
innodb  select_2_rows                         4.00      -33.16%      -1.00     
2.00    4.00    3.00    0.73
innodb  select_big                           13.00       -6.19%      -0.76     
0.00   31.00   12.24    1.49
innodb  select_big_str                        2.00      -66.97%      -0.80     
0.00    2.00    1.20    0.40
innodb  select_cache                         59.00       +2.25%       1.36    
49.00   79.00   60.36    5.65
innodb  select_cache2                        65.00       -6.81%      -4.14    
49.00   88.00   60.86    6.34
innodb  select_column+column                  3.00       +2.01%       0.06     
2.00    4.00    3.06    0.75
innodb  select_diff_key                       1.00     -340.95%      -0.77     
0.00    1.00    0.23    0.42
innodb  select_distinct                       5.00      -16.42%      -0.71     
3.00    8.00    4.29    0.55
innodb  select_group                         16.00       +2.31%       0.38     
4.00  136.00   16.38    5.02
innodb  select_group_when_MANY_tables        12.00      -21.76%      -2.14     
3.00   49.00    9.86    8.73
innodb  select_join                           1.00      -68.03%      -0.40     
0.00    1.00    0.60    0.49
innodb  select_key                           64.00      -17.35%      -9.46    
40.00   67.00   54.54    7.98
innodb  select_key2                          70.00      -14.29%      -8.75    
45.00   75.00   61.25    8.69
innodb  select_key2_return_key               69.00      -17.75%     -10.40    
42.00   71.00   58.60    8.55
innodb  select_key2_return_prim              69.00      -16.23%      -9.63    
42.00   72.00   59.37    8.67
innodb  select_key_prefix                    70.00      -15.59%      -9.44    
44.00   75.00   60.56    8.77
innodb  select_key_prefix_join                5.00       -4.19%      -0.20     
3.00   10.00    4.80    0.66
innodb  select_key_return_key                63.00      -17.66%      -9.46    
38.00   66.00   53.54    7.97
innodb  select_many_fields                   13.00      +11.41%       1.68    
11.00   19.00   14.68    1.77
innodb  select_range                         44.00       +5.44%       2.53    
38.00   76.00   46.53    4.06
innodb  select_range_key2                    10.00      -18.07%      -1.53     
6.00   11.00    8.47    1.10
innodb  select_range_prefix                   8.00       +0.61%       0.05     
5.00   10.00    8.05    1.16
innodb  select_simple                         3.00      -75.11%      -1.29     
1.00    3.00    1.71    0.50
innodb  select_simple_cache                   2.00      -22.53%      -0.37     
1.00    3.00    1.63    0.51
innodb  select_simple_join                    0.00     +100.00%       0.67     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     4.00      -19.24%      -0.65     
2.00   16.00    3.35    0.95
innodb  update_big                           57.00       -9.26%      -4.83    
31.00  195.00   52.17   22.62
innodb  update_commit                         2.00      -23.00%      -0.37     
1.00   10.00    1.63    0.69
innodb  update_of_key                        22.00       +8.03%       1.92    
18.00  100.00   23.92    5.72
innodb  update_of_key_big                    19.00      +29.96%       8.13    
15.00   75.00   27.13   10.66
innodb  update_of_primary_key_many_keys    1239.00       +1.06%      13.21   
647.00 6065.00 1252.21  861.14
innodb  update_rollback                       2.00      -10.70%      -0.19     
1.00   31.00    1.81    1.75
innodb  update_with_key                     119.00       -6.77%      -7.54    
90.00  598.00  111.46   19.45
innodb  update_with_key_prefix               44.00       -9.37%      -3.77    
33.00  202.00   40.23    6.45
innodb  wisc_benchmark                        3.00      -20.47%      -0.51     
2.00    5.00    2.49    0.52

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

  2518.1.1: Continuous Integr... 2012-03-04 [merge] Merge test tree with build 
tree.
    2517.1.3: Brian Aker 2012-03-04 Fix performance regression introduced with 
catalog being added to key.

_______________________________________________
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