=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   937
RUN DATE: 2011-03-02T22:15:50.227132
SERVER:   drizzled
VERSION:  staging
REVISION: 2216
COMMENT:  2216: Lee Bieber 2011-03-02 [merge] Merge Patrick - 727506: Can't run 
dbqp on rhel 5.5

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      31.00       +4.91%       1.60    
31.00   34.00   32.60    1.02
innodb  alter_table_drop                     26.00       -7.44%      -1.80    
23.00   26.00   24.20    1.17
innodb  connect                               2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  connect+select_1_row                  2.00      +28.57%       0.80     
2.00    3.00    2.80    0.40
innodb  connect+select_simple                 2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  count                                14.00      +13.58%       2.20    
13.00   18.00   16.20    2.23
innodb  count_distinct                        6.00      +11.76%       0.80     
6.00    8.00    6.80    0.75
innodb  count_distinct_2                     13.00       +7.14%       1.00    
12.00   16.00   14.00    1.41
innodb  count_distinct_big                   20.00      +13.04%       3.00    
20.00   25.00   23.00    2.10
innodb  count_distinct_group                 15.00       +1.32%       0.20    
14.00   16.00   15.20    0.75
innodb  count_distinct_group_on_key          10.00       -2.04%      -0.20     
8.00   11.00    9.80    1.17
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       +3.85%       0.20     
5.00    6.00    5.20    0.40
innodb  count_group_on_key_parts             11.00       -1.85%      -0.20    
10.00   11.00   10.80    0.40
innodb  count_on_key                         90.00       +3.23%       3.00    
90.00   95.00   93.00    1.90
innodb  create+drop                          33.00       +0.60%       0.20    
32.00   34.00   33.20    0.75
innodb  create_index                          3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  create_key+drop                      32.00       -0.00%       0.00    
31.00   33.00   32.00    0.63
innodb  create_MANY_tables                   21.00       -0.96%      -0.20    
20.00   22.00   20.80    0.75
innodb  create_table                          0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_all_many_keys                713.00       -5.82%     -39.20   
640.00  721.00  673.80   35.54
innodb  delete_autocommit                     4.00       -0.00%       0.00     
3.00    5.00    4.00    0.63
innodb  delete_big                            1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                712.00       -5.86%     -39.40   
639.00  719.00  672.60   35.27
innodb  delete_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  delete_key                            3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  delete_range                          9.00       -0.00%       0.00     
8.00   10.00    9.00    0.63
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  drop_table_when_MANY_tables          22.00      -14.58%      -2.80    
17.00   22.00   19.20    1.72
innodb  insert                              114.00       -0.35%      -0.40   
112.00  116.00  113.60    1.50
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                    19.00       +1.04%       0.20    
19.00   20.00   19.20    0.40
innodb  insert_key                          291.00       -2.75%      -7.80   
274.00  298.00  283.20    9.66
innodb  insert_many_fields                    6.00       -0.00%       0.00     
6.00    6.00    6.00    0.00
innodb  insert_rollback                       2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  insert_select_1_key                   4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  insert_select_2_keys                  6.00       -3.45%      -0.20     
5.00    6.00    5.80    0.40
innodb  min_max                               7.00      +10.26%       0.80     
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                 7.00       -2.94%      -0.20     
6.00    8.00    6.80    0.75
innodb  once_prepared_select                 29.00       +0.68%       0.20    
29.00   30.00   29.20    0.40
innodb  order_by_big                         13.00      +13.33%       2.00    
13.00   16.00   15.00    1.10
innodb  order_by_big_key                     12.00       +6.25%       0.80    
12.00   13.00   12.80    0.40
innodb  order_by_big_key2                    12.00       +3.23%       0.40    
11.00   15.00   12.40    1.36
innodb  order_by_big_key_desc                14.00       -2.94%      -0.40    
13.00   14.00   13.60    0.49
innodb  order_by_big_key_diff                11.00      +12.70%       1.60    
11.00   14.00   12.60    1.20
innodb  order_by_big_key_prefix              13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
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       -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      +13.46%       2.80    
17.00   23.00   20.80    2.71
innodb  outer_join_found                     17.00      +14.14%       2.80    
17.00   22.00   19.80    2.32
innodb  outer_join_not_found                 15.00      +14.77%       2.60    
15.00   20.00   17.60    2.15
innodb  outer_join_on_key                    12.00      +13.04%       1.80    
12.00   16.00   13.80    1.60
innodb  prepared_select                      37.00       +0.54%       0.20    
36.00   38.00   37.20    0.75
innodb  select_1_row                          4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
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                           11.00       +8.33%       1.00    
11.00   13.00   12.00    0.63
innodb  select_big_str                        1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  select_cache                         63.00       +0.63%       0.40    
62.00   65.00   63.40    1.02
innodb  select_cache2                        65.00       -1.56%      -1.00    
60.00   65.00   64.00    2.00
innodb  select_column+column                  4.00       -5.26%      -0.20     
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                       4.00       +9.09%       0.40     
4.00    5.00    4.40    0.49
innodb  select_group                         15.00       +5.06%       0.80    
15.00   19.00   15.80    1.60
innodb  select_group_when_MANY_tables        13.00       -4.84%      -0.60    
12.00   13.00   12.40    0.49
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           64.00       -0.00%       0.00    
63.00   66.00   64.00    1.10
innodb  select_key2                          70.00       +1.13%       0.80    
69.00   73.00   70.80    1.47
innodb  select_key2_return_key               68.00       +0.29%       0.20    
67.00   70.00   68.20    0.98
innodb  select_key2_return_prim              69.00       -0.00%       0.00    
68.00   71.00   69.00    1.10
innodb  select_key_prefix                    70.00       +0.28%       0.20    
69.00   72.00   70.20    0.98
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.64%      -0.40    
62.00   64.00   62.60    0.80
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         42.00       -0.48%      -0.20    
39.00   46.00   41.80    2.64
innodb  select_range_key2                     9.00       +6.25%       0.60     
9.00   10.00    9.60    0.49
innodb  select_range_prefix                   8.00       +6.98%       0.60     
8.00    9.00    8.60    0.49
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   3.00      -36.36%      -0.80     
2.00    3.00    2.20    0.40
innodb  select_simple_join                    1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  update_autocommit                     3.00      +21.05%       0.80     
3.00    5.00    3.80    0.75
innodb  update_big                           61.00       -4.10%      -2.40    
57.00   61.00   58.60    1.36
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        22.00       +1.79%       0.40    
22.00   23.00   22.40    0.49
innodb  update_of_key_big                    37.00       -1.65%      -0.60    
34.00   39.00   36.40    1.62
innodb  update_of_primary_key_many_keys    1430.00       -5.13%     -69.80  
1293.00 1465.00 1360.20   72.32
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     115.00       +3.85%       4.60   
115.00  124.00  119.60    3.01
innodb  update_with_key_prefix               47.00       -5.38%      -2.40    
41.00   47.00   44.60    2.06
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                      31.00       +4.62%       1.50    
30.00   34.00   32.50    1.16
innodb  alter_table_drop                     26.00       -8.79%      -2.10    
23.00   26.00   23.90    0.83
innodb  connect                               2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  connect+select_1_row                  2.00      +31.03%       0.90     
2.00    3.00    2.90    0.30
innodb  connect+select_simple                 2.00      +27.27%       0.75     
2.00    3.00    2.75    0.43
innodb  count                                14.00      +10.26%       1.60    
13.00   19.00   15.60    2.11
innodb  count_distinct                        6.00      +12.41%       0.85     
6.00    8.00    6.85    0.79
innodb  count_distinct_2                     13.00       +8.13%       1.15    
11.00   16.00   14.15    1.19
innodb  count_distinct_big                   20.00      +11.11%       2.50    
20.00   25.00   22.50    1.88
innodb  count_distinct_group                 15.00       -3.81%      -0.55    
12.00   16.00   14.45    1.07
innodb  count_distinct_group_on_key          10.00       +1.96%       0.20     
8.00   12.00   10.20    1.08
innodb  count_distinct_group_on_key_parts    13.00       +3.70%       0.50    
11.00   15.00   13.50    1.12
innodb  count_distinct_key_prefix             5.00       +3.85%       0.20     
5.00    6.00    5.20    0.40
innodb  count_group_on_key_parts             11.00       +0.45%       0.05    
10.00   12.00   11.05    0.50
innodb  count_on_key                         90.00       +3.43%       3.20    
89.00  100.00   93.20    2.48
innodb  create+drop                          33.00       +1.64%       0.55    
32.00   35.00   33.55    0.80
innodb  create_index                          3.00       +9.09%       0.30     
3.00    4.00    3.30    0.46
innodb  create_key+drop                      32.00       -1.75%      -0.55    
29.00   37.00   31.45    1.60
innodb  create_MANY_tables                   21.00       -1.20%      -0.25    
20.00   22.00   20.75    0.62
innodb  create_table                          0.00     +100.00%       0.10     
0.00    1.00    0.10    0.30
innodb  delete_all_many_keys                713.00       -9.29%     -60.60   
580.00  721.00  652.40   34.40
innodb  delete_autocommit                     4.00       -5.26%      -0.20     
3.00    5.00    3.80    0.51
innodb  delete_big                            1.00      -53.85%      -0.35     
0.00    1.00    0.65    0.48
innodb  delete_big_many_keys                712.00       -9.29%     -60.55   
580.00  719.00  651.45   34.08
innodb  delete_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  delete_key                            3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  delete_range                          9.00       -0.56%      -0.05     
8.00   11.00    8.95    0.67
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.45
innodb  drop_table                            0.00     +100.00%       0.15     
0.00    1.00    0.15    0.36
innodb  drop_table_when_MANY_tables          22.00      -16.71%      -3.15    
17.00   22.00   18.85    1.15
innodb  insert                              114.00       -0.31%      -0.35   
112.00  116.00  113.65    1.15
innodb  insert_autocommit                     3.00       +1.64%       0.05     
3.00    4.00    3.05    0.22
innodb  insert_commit                         2.00       -8.11%      -0.15     
1.00    2.00    1.85    0.36
innodb  insert_duplicates                    19.00       +0.78%       0.15    
19.00   20.00   19.15    0.36
innodb  insert_key                          291.00       -3.12%      -8.80   
263.00  302.00  282.20   10.60
innodb  insert_many_fields                    6.00       -1.69%      -0.10     
5.00    7.00    5.90    0.44
innodb  insert_rollback                       2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  insert_select_1_key                   4.00       -5.26%      -0.20     
3.00    5.00    3.80    0.51
innodb  insert_select_2_keys                  6.00       +6.25%       0.40     
5.00    7.00    6.40    0.58
innodb  min_max                               7.00      +11.95%       0.95     
7.00    9.00    7.95    0.92
innodb  min_max_on_key                       25.00       -1.42%      -0.35    
24.00   26.00   24.65    0.57
innodb  multiple_value_insert                 7.00       -9.38%      -0.60     
5.00    8.00    6.40    0.73
innodb  once_prepared_select                 29.00       +0.68%       0.20    
28.00   30.00   29.20    0.51
innodb  order_by_big                         13.00      +11.26%       1.65    
13.00   16.00   14.65    1.11
innodb  order_by_big_key                     12.00      +15.19%       2.15    
12.00   16.00   14.15    1.49
innodb  order_by_big_key2                    12.00      +10.11%       1.35    
11.00   15.00   13.35    1.01
innodb  order_by_big_key_desc                14.00       +6.35%       0.95    
13.00   17.00   14.95    1.12
innodb  order_by_big_key_diff                11.00      +16.03%       2.10    
11.00   14.00   13.10    0.89
innodb  order_by_big_key_prefix              13.00       +3.70%       0.50    
12.00   15.00   13.50    0.67
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       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  order_by_range                        1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  outer_join                           18.00      +13.04%       2.70    
17.00   24.00   20.70    2.65
innodb  outer_join_found                     17.00      +15.00%       3.00    
16.00   23.00   20.00    2.53
innodb  outer_join_not_found                 15.00      +17.58%       3.20    
15.00   23.00   18.20    2.54
innodb  outer_join_on_key                    12.00      +13.98%       1.95    
11.00   17.00   13.95    1.86
innodb  prepared_select                      37.00       +0.67%       0.25    
36.00   38.00   37.25    0.54
innodb  select_1_row                          4.00      -19.40%      -0.65     
3.00    4.00    3.35    0.48
innodb  select_1_row_cache                    3.00      +18.92%       0.70     
3.00    4.00    3.70    0.46
innodb  select_2_rows                         4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
innodb  select_big                           11.00      +14.73%       1.90    
11.00   15.00   12.90    1.18
innodb  select_big_str                        1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  select_cache                         63.00       +1.25%       0.80    
57.00   70.00   63.80    3.76
innodb  select_cache2                        65.00       -3.17%      -2.00    
57.00   68.00   63.00    2.90
innodb  select_column+column                  4.00       -8.11%      -0.30     
3.00    4.00    3.70    0.46
innodb  select_diff_key                       1.00     -185.71%      -0.65     
0.00    1.00    0.35    0.48
innodb  select_distinct                       4.00      +11.11%       0.50     
4.00    5.00    4.50    0.50
innodb  select_group                         15.00       +5.36%       0.85    
15.00   19.00   15.85    1.19
innodb  select_group_when_MANY_tables        13.00       -7.44%      -0.90    
11.00   14.00   12.10    0.77
innodb  select_join                           1.00     -100.00%      -0.50     
0.00    1.00    0.50    0.50
innodb  select_key                           64.00       -0.16%      -0.10    
63.00   66.00   63.90    0.70
innodb  select_key2                          70.00       +1.34%       0.95    
69.00   73.00   70.95    0.97
innodb  select_key2_return_key               68.00       +0.44%       0.30    
67.00   70.00   68.30    0.64
innodb  select_key2_return_prim              69.00       +0.36%       0.25    
68.00   71.00   69.25    0.83
innodb  select_key_prefix                    70.00       +0.57%       0.40    
69.00   72.00   70.40    0.73
innodb  select_key_prefix_join                5.00       +0.99%       0.05     
5.00    6.00    5.05    0.22
innodb  select_key_return_key                63.00       -0.32%      -0.20    
62.00   64.00   62.80    0.68
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         42.00       +0.83%       0.35    
39.00   47.00   42.35    2.41
innodb  select_range_key2                     9.00       +5.76%       0.55     
8.00   10.00    9.55    0.59
innodb  select_range_prefix                   8.00      +12.09%       1.10     
8.00   10.00    9.10    0.62
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   3.00      -46.34%      -0.95     
2.00    3.00    2.05    0.22
innodb  select_simple_join                    1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  update_autocommit                     3.00      +18.92%       0.70     
3.00    5.00    3.70    0.56
innodb  update_big                           61.00       -3.48%      -2.05    
57.00   64.00   58.95    1.83
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        22.00       +2.00%       0.45    
21.00   24.00   22.45    0.80
innodb  update_of_key_big                    37.00       -3.35%      -1.20    
29.00   41.00   35.80    2.82
innodb  update_of_primary_key_many_keys    1430.00       -6.62%     -88.75  
1217.00 1470.00 1341.25   66.83
innodb  update_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  update_with_key                     115.00       +4.52%       5.45   
115.00  124.00  120.45    2.16
innodb  update_with_key_prefix               47.00       -4.91%      -2.20    
41.00   48.00   44.80    2.06
innodb  wisc_benchmark                        2.00      +18.37%       0.45     
2.00    3.00    2.45    0.50

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      31.00      -46.55%      -9.85    
11.00   61.00   21.15   10.11
innodb  alter_table_drop                     26.00      -40.97%      -7.56    
10.00   57.00   18.44    6.95
innodb  connect                               2.00       +3.87%       0.08     
1.00    3.00    2.08    0.42
innodb  connect+select_1_row                  2.00      +25.98%       0.70     
2.00    5.00    2.70    0.47
innodb  connect+select_simple                 2.00      +14.89%       0.35     
1.00    3.00    2.35    0.48
innodb  count                                14.00      +11.08%       1.75    
12.00  193.00   15.75    8.78
innodb  count_distinct                        6.00       +8.65%       0.57     
5.00   50.00    6.57    2.26
innodb  count_distinct_2                     13.00       +1.48%       0.20    
11.00   63.00   13.20    2.94
innodb  count_distinct_big                   20.00       +8.83%       1.94     
5.00   67.00   21.94    3.01
innodb  count_distinct_group                 15.00      -13.96%      -1.84    
10.00   68.00   13.16    3.08
innodb  count_distinct_group_on_key          10.00       -5.21%      -0.50     
7.00   69.00    9.50    3.01
innodb  count_distinct_group_on_key_parts    13.00       -5.38%      -0.66     
9.00   72.00   12.34    3.14
innodb  count_distinct_key_prefix             5.00       +2.45%       0.13     
3.00   52.00    5.13    2.37
innodb  count_group_on_key_parts             11.00      -10.10%      -1.01     
7.00   72.00    9.99    3.14
innodb  count_on_key                         90.00       -4.58%      -3.94    
68.00  107.00   86.06    7.38
innodb  create+drop                          33.00       -1.71%      -0.55    
18.00   75.00   32.45   11.83
innodb  create_index                          3.00       -3.70%      -0.11     
1.00    8.00    2.89    1.14
innodb  create_key+drop                      32.00      -13.38%      -3.78    
21.00   50.00   28.22    4.90
innodb  create_MANY_tables                   21.00      +38.12%      12.94    
14.00  121.00   33.94   17.06
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.36
innodb  delete_all_many_keys                713.00      -52.98%    -246.94   
212.00 1888.00  466.06  363.46
innodb  delete_autocommit                     4.00      -16.00%      -0.55     
2.00   14.00    3.45    0.75
innodb  delete_big                            1.00     -236.43%      -0.70     
0.00    3.00    0.30    0.47
innodb  delete_big_many_keys                712.00      -50.82%    -239.91   
212.00 2293.00  472.09  377.55
innodb  delete_commit                         2.00      -32.12%      -0.49     
1.00    5.00    1.51    0.53
innodb  delete_key                            3.00       +1.70%       0.05     
2.00   35.00    3.05    1.49
innodb  delete_range                          9.00       -8.21%      -0.68     
5.00   23.00    8.32    3.22
innodb  delete_rollback                       2.00      -14.89%      -0.26     
1.00   12.00    1.74    0.91
innodb  drop_index                            3.00       -1.68%      -0.05     
1.00    9.00    2.95    1.31
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    2.00    0.05    0.23
innodb  drop_table_when_MANY_tables          22.00      -12.42%      -2.43    
11.00   90.00   19.57    7.50
innodb  insert                              114.00       -6.78%      -7.24     
3.00  343.00  106.76   14.54
innodb  insert_autocommit                     3.00       -0.00%       0.00     
2.00   99.00    3.00    3.30
innodb  insert_commit                         2.00      -44.79%      -0.62     
1.00    3.00    1.38    0.50
innodb  insert_duplicates                    19.00      -22.65%      -3.51    
11.00   21.00   15.49    2.66
innodb  insert_key                          291.00       +3.95%      11.98   
142.00  700.00  302.98  106.57
innodb  insert_many_fields                    6.00       -7.00%      -0.39     
3.00   17.00    5.61    1.77
innodb  insert_rollback                       2.00      -19.64%      -0.33     
1.00    3.00    1.67    0.54
innodb  insert_select_1_key                   4.00       -5.80%      -0.22     
2.00   10.00    3.78    0.88
innodb  insert_select_2_keys                  6.00       +1.22%       0.07     
4.00   16.00    6.07    2.08
innodb  min_max                               7.00      +10.57%       0.83     
6.00  110.00    7.83    4.53
innodb  min_max_on_key                       25.00      -21.51%      -4.43    
14.00   37.00   20.57    3.10
innodb  multiple_value_insert                 7.00      -28.12%      -1.54     
2.00   50.00    5.46    4.27
innodb  once_prepared_select                 29.00      -19.61%      -4.75    
18.00   32.00   24.25    3.58
innodb  order_by_big                         13.00       +9.19%       1.32    
12.00   31.00   14.32    1.53
innodb  order_by_big_key                     12.00       +9.67%       1.28    
11.00   32.00   13.28    1.64
innodb  order_by_big_key2                    12.00       +1.72%       0.21    
10.00   33.00   12.21    1.55
innodb  order_by_big_key_desc                14.00       -3.61%      -0.49    
11.00   32.00   13.51    1.69
innodb  order_by_big_key_diff                11.00      +10.10%       1.24    
10.00   31.00   12.24    1.50
innodb  order_by_big_key_prefix              13.00       -4.76%      -0.59    
10.00   32.00   12.41    1.56
innodb  order_by_key2_diff                    1.00      +28.47%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -26.02%      -0.21     
0.00    2.00    0.79    0.41
innodb  order_by_range                        1.00      -20.25%      -0.17     
0.00    2.00    0.83    0.38
innodb  outer_join                           18.00       +6.96%       1.35    
15.00   61.00   19.35    3.72
innodb  outer_join_found                     17.00       +9.43%       1.77    
14.00   58.00   18.77    3.57
innodb  outer_join_not_found                 15.00       +8.93%       1.47    
12.00   46.00   16.47    3.17
innodb  outer_join_on_key                    12.00       +7.07%       0.91    
10.00   59.00   12.91    2.77
innodb  prepared_select                      37.00      -17.98%      -5.64    
22.00   40.00   31.36    4.52
innodb  select_1_row                          4.00      -40.16%      -1.15     
2.00    4.00    2.85    0.69
innodb  select_1_row_cache                    3.00      -11.60%      -0.31     
2.00    4.00    2.69    0.69
innodb  select_2_rows                         4.00      -38.87%      -1.12     
2.00    4.00    2.88    0.70
innodb  select_big                           11.00       +9.60%       1.17     
0.00   31.00   12.17    1.55
innodb  select_big_str                        1.00      +14.29%       0.17     
0.00    2.00    1.17    0.38
innodb  select_cache                         63.00       -5.61%      -3.35    
49.00   77.00   59.65    5.62
innodb  select_cache2                        65.00       -8.34%      -5.00    
49.00   75.00   60.00    6.26
innodb  select_column+column                  4.00      -36.64%      -1.07     
2.00    4.00    2.93    0.72
innodb  select_diff_key                       1.00     -351.56%      -0.78     
0.00    1.00    0.22    0.42
innodb  select_distinct                       4.00       +5.59%       0.24     
3.00    8.00    4.24    0.54
innodb  select_group                         15.00       +7.76%       1.26     
4.00  136.00   16.26    5.41
innodb  select_group_when_MANY_tables        13.00      -37.07%      -3.52     
3.00   49.00    9.48    9.42
innodb  select_join                           1.00      -72.76%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           64.00      -21.16%     -11.18    
40.00   66.00   52.82    7.47
innodb  select_key2                          70.00      -17.62%     -10.49    
45.00   75.00   59.51    8.32
innodb  select_key2_return_key               68.00      -19.63%     -11.16    
42.00   71.00   56.84    8.12
innodb  select_key2_return_prim              69.00      -19.78%     -11.40    
42.00   72.00   57.60    8.26
innodb  select_key_prefix                    70.00      -19.11%     -11.23    
44.00   75.00   58.77    8.34
innodb  select_key_prefix_join                5.00       -5.90%      -0.28     
3.00   10.00    4.72    0.65
innodb  select_key_return_key                63.00      -21.51%     -11.15    
38.00   65.00   51.85    7.48
innodb  select_many_fields                   13.00      +12.93%       1.93    
11.00   19.00   14.93    1.79
innodb  select_range                         42.00      +10.65%       5.01    
38.00   76.00   47.01    4.03
innodb  select_range_key2                     9.00       -8.89%      -0.73     
6.00   11.00    8.27    1.05
innodb  select_range_prefix                   8.00       -1.97%      -0.15     
5.00   10.00    7.85    1.11
innodb  select_simple                         2.00      -21.28%      -0.35     
1.00    3.00    1.65    0.51
innodb  select_simple_cache                   3.00      -92.54%      -1.44     
1.00    3.00    1.56    0.51
innodb  select_simple_join                    1.00      -51.92%      -0.34     
0.00    3.00    0.66    0.48
innodb  update_autocommit                     3.00      +10.02%       0.33     
2.00   16.00    3.33    1.01
innodb  update_big                           61.00      -19.51%      -9.96    
31.00  195.00   51.04   24.39
innodb  update_commit                         2.00      -27.74%      -0.43     
1.00   10.00    1.57    0.73
innodb  update_of_key                        22.00       +9.16%       2.22    
18.00  100.00   24.22    6.15
innodb  update_of_key_big                    37.00      -34.55%      -9.50    
15.00   75.00   27.50   10.94
innodb  update_of_primary_key_many_keys    1430.00      -15.19%    -188.55   
647.00 6065.00 1241.45  954.87
innodb  update_rollback                       2.00      -13.54%      -0.24     
1.00   31.00    1.76    1.89
innodb  update_with_key                     115.00       -4.62%      -5.07    
90.00  598.00  109.93   20.73
innodb  update_with_key_prefix               47.00      -18.47%      -7.33    
33.00  202.00   39.67    6.82
innodb  wisc_benchmark                        2.00      +19.07%       0.47     
2.00    5.00    2.47    0.53

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

  2215.1.3: Lee Bieber 2011-03-02 Fix distcheck issue with docs
  2215.1.2: Lee Bieber 2011-03-02 [merge] Merge Patrick - 727506: Can't run 
dbqp on rhel 5.5
    2211.3.2: patrick crews 2011-03-02 Including uuid module so we can work 
with red hat...grr.  We could require packages and whatnot, but just inlcuding 
the small file until such time as redhat moves to python 2.5 seems good
  2215.1.1: Lee Bieber 2011-03-02 [merge] Merge Marisa - latest documentation 
updates
    1994.4.105: Marisa Plumb 2011-03-02 starting red hat fixes
    1994.4.104: Marisa Plumb 2011-03-02 new doc with note about versioning
    1994.4.103: Marisa Plumb 2011-03-02 [merge] more updates
    1994.4.102: Marisa Plumb 2011-03-02 [merge] update
    1994.4.101: Marisa Plumb 2011-03-01 [merge] updating
    1994.4.100: Marisa Plumb 2011-02-28 addressing bug 723669 
    1994.4.99: Marisa Plumb 2011-02-28 adding drizzleadmin as manpage in 
include.am
    1994.4.98: Marisa Plumb 2011-02-27 [merge] updating
    1994.4.97: Marisa Plumb 2011-02-24 [merge] updating

_______________________________________________
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