=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   968
RUN DATE: 2011-03-23T10:30:06.788492
SERVER:   drizzled
VERSION:  staging
REVISION: 2247
COMMENT:  2247: Lee Bieber 2011-03-23 [merge] Merge Patrick - Updated dbqp's 
ld_lib_paths to find the new libdrizzle locations

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       +1.23%       0.40    
29.00   34.00   32.40    1.85
innodb  alter_table_drop                     22.00       +6.78%       1.60    
22.00   25.00   23.60    1.20
innodb  connect                               2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  count                                17.00      -11.84%      -1.80    
13.00   19.00   15.20    2.40
innodb  count_distinct                        7.00       -9.38%      -0.60     
6.00    7.00    6.40    0.49
innodb  count_distinct_2                     15.00       -8.70%      -1.20    
11.00   15.00   13.80    1.47
innodb  count_distinct_big                   25.00      -10.62%      -2.40    
21.00   25.00   22.60    1.96
innodb  count_distinct_group                 14.00       +1.41%       0.20    
13.00   15.00   14.20    0.75
innodb  count_distinct_group_on_key           9.00       +4.26%       0.40     
9.00   10.00    9.40    0.49
innodb  count_distinct_group_on_key_parts    15.00      -17.19%      -2.20    
11.00   15.00   12.80    1.33
innodb  count_distinct_key_prefix             6.00       -3.45%      -0.20     
5.00    6.00    5.80    0.40
innodb  count_group_on_key_parts             10.00       +5.66%       0.60    
10.00   11.00   10.60    0.49
innodb  count_on_key                         96.00       -2.56%      -2.40    
91.00   97.00   93.60    2.42
innodb  create+drop                          32.00       -0.00%       0.00    
31.00   33.00   32.00    0.63
innodb  create_index                          3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  create_key+drop                      31.00       -0.00%       0.00    
31.00   31.00   31.00    0.00
innodb  create_MANY_tables                   24.00       -5.26%      -1.20    
21.00   24.00   22.80    1.17
innodb  delete_all_many_keys                610.00       +5.60%      36.20   
610.00  705.00  646.20   34.32
innodb  delete_autocommit                     4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  delete_big                            1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  delete_big_many_keys                609.00       +5.64%      36.40   
609.00  704.00  645.40   34.31
innodb  delete_commit                         1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  delete_key                            3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  delete_range                          8.00       +4.76%       0.40     
8.00    9.00    8.40    0.49
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  drop_table_when_MANY_tables          19.00       +3.06%       0.60    
19.00   21.00   19.60    0.80
innodb  insert                              115.00       -1.23%      -1.40   
111.00  116.00  113.60    1.85
innodb  insert_autocommit                     4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  insert_commit                         1.00      +44.44%       0.80     
1.00    2.00    1.80    0.40
innodb  insert_duplicates                    19.00       +1.04%       0.20    
19.00   20.00   19.20    0.40
innodb  insert_key                          277.00       +2.19%       6.20   
277.00  296.00  283.20    6.94
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                   3.00      +16.67%       0.60     
3.00    5.00    3.60    0.80
innodb  insert_select_2_keys                  7.00      -12.90%      -0.80     
5.00    7.00    6.20    0.75
innodb  min_max                               9.00      -12.50%      -1.00     
7.00   10.00    8.00    1.26
innodb  min_max_on_key                       24.00       +0.83%       0.20    
24.00   25.00   24.20    0.40
innodb  multiple_value_insert                 6.00       +9.09%       0.60     
6.00    7.00    6.60    0.49
innodb  once_prepared_select                 29.00       -0.00%       0.00    
28.00   30.00   29.00    0.63
innodb  order_by_big                         13.00       +7.14%       1.00    
13.00   16.00   14.00    1.26
innodb  order_by_big_key                     13.00       +8.45%       1.20    
13.00   16.00   14.20    1.47
innodb  order_by_big_key2                    11.00      +12.70%       1.60    
11.00   14.00   12.60    1.02
innodb  order_by_big_key_desc                14.00       +5.41%       0.80    
13.00   16.00   14.80    1.17
innodb  order_by_big_key_diff                12.00       +9.09%       1.20    
12.00   14.00   13.20    0.75
innodb  order_by_big_key_prefix              12.00       +7.69%       1.00    
12.00   14.00   13.00    0.89
innodb  order_by_key2_diff                    1.00      +37.50%       0.60     
1.00    2.00    1.60    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      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  outer_join                           19.00      +13.64%       3.00    
19.00   25.00   22.00    2.68
innodb  outer_join_found                     18.00      +12.62%       2.60    
18.00   23.00   20.60    2.24
innodb  outer_join_not_found                 17.00      +13.27%       2.60    
16.00   23.00   19.60    2.73
innodb  outer_join_on_key                    12.00      +17.81%       2.60    
12.00   17.00   14.60    2.24
innodb  prepared_select                      37.00       -0.00%       0.00    
37.00   37.00   37.00    0.00
innodb  select_1_row                          4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
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      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_big                           12.00       +1.64%       0.20    
11.00   14.00   12.20    0.98
innodb  select_big_str                        2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  select_cache                         62.00       +4.32%       2.80    
62.00   71.00   64.80    3.25
innodb  select_cache2                        65.00       +0.61%       0.40    
60.00   69.00   65.40    3.14
innodb  select_column+column                  3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  select_distinct                       5.00       -4.17%      -0.20     
4.00    5.00    4.80    0.40
innodb  select_group                         18.00      -11.11%      -1.80    
15.00   18.00   16.20    0.98
innodb  select_group_when_MANY_tables        11.00       +5.17%       0.60    
10.00   13.00   11.60    1.02
innodb  select_join                           1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  select_key                           64.00       -0.00%       0.00    
63.00   65.00   64.00    0.63
innodb  select_key2                          71.00       -0.00%       0.00    
70.00   72.00   71.00    0.63
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.29%      -0.20    
68.00   70.00   68.80    0.75
innodb  select_key_prefix                    70.00       +0.57%       0.40    
70.00   72.00   70.40    0.80
innodb  select_key_prefix_join                6.00       -7.14%      -0.40     
5.00    6.00    5.60    0.49
innodb  select_key_return_key                63.00       -0.32%      -0.20    
62.00   64.00   62.80    0.75
innodb  select_many_fields                   14.00       -6.06%      -0.80    
13.00   14.00   13.20    0.40
innodb  select_range                         39.00      +10.55%       4.60    
39.00   47.00   43.60    3.38
innodb  select_range_key2                     9.00       +4.26%       0.40     
9.00   10.00    9.40    0.49
innodb  select_range_prefix                  10.00       -4.17%      -0.40     
9.00   10.00    9.60    0.49
innodb  select_simple                         2.00       +9.09%       0.20     
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      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  update_big                           56.00       +5.72%       3.40    
56.00   62.00   59.40    2.15
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        22.00       -0.00%       0.00    
21.00   23.00   22.00    0.89
innodb  update_of_key_big                    36.00       -0.56%      -0.20    
30.00   39.00   35.80    3.31
innodb  update_of_primary_key_many_keys    1294.00       +4.39%      59.40  
1294.00 1469.00 1353.40   61.21
innodb  update_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  update_with_key                     121.00       -1.00%      -1.20   
118.00  122.00  119.80    1.47
innodb  update_with_key_prefix               42.00       +2.78%       1.20    
42.00   46.00   43.20    1.60
innodb  wisc_benchmark                        3.00      -15.38%      -0.40     
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       +1.84%       0.60    
26.00   35.00   32.60    2.08
innodb  alter_table_drop                     22.00       +6.58%       1.55    
22.00   25.00   23.55    0.86
innodb  connect                               2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 3.00      -11.11%      -0.30     
2.00    3.00    2.70    0.46
innodb  count                                17.00      -10.39%      -1.60    
13.00   19.00   15.40    1.88
innodb  count_distinct                        7.00       -6.87%      -0.45     
5.00    8.00    6.55    0.74
innodb  count_distinct_2                     15.00       -9.89%      -1.35    
11.00   16.00   13.65    1.15
innodb  count_distinct_big                   25.00       -8.93%      -2.05    
21.00   25.00   22.95    1.88
innodb  count_distinct_group                 14.00       +3.45%       0.50    
11.00   16.00   14.50    1.12
innodb  count_distinct_group_on_key           9.00       +5.26%       0.50     
8.00   11.00    9.50    0.87
innodb  count_distinct_group_on_key_parts    15.00      -13.64%      -1.80    
11.00   15.00   13.20    1.17
innodb  count_distinct_key_prefix             6.00       -9.09%      -0.50     
4.00    6.00    5.50    0.67
innodb  count_group_on_key_parts             10.00       +8.68%       0.95    
10.00   12.00   10.95    0.59
innodb  count_on_key                         96.00       -2.07%      -1.95    
91.00   97.00   94.05    1.86
innodb  create+drop                          32.00       +2.88%       0.95    
31.00   35.00   32.95    0.97
innodb  create_index                          3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  create_key+drop                      31.00       +0.96%       0.30    
30.00   34.00   31.30    0.95
innodb  create_MANY_tables                   24.00      -13.21%      -2.80    
19.00   24.00   21.20    1.29
innodb  delete_all_many_keys                610.00       +4.55%      29.10   
609.00  705.00  639.10   22.41
innodb  delete_autocommit                     4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
innodb  delete_big                            1.00     -233.33%      -0.70     
0.00    1.00    0.30    0.46
innodb  delete_big_many_keys                609.00       +4.60%      29.35   
608.00  704.00  638.35   22.38
innodb  delete_commit                         1.00      +45.95%       0.85     
1.00    2.00    1.85    0.36
innodb  delete_key                            3.00       -5.26%      -0.15     
2.00    4.00    2.85    0.48
innodb  delete_range                          8.00       +5.33%       0.45     
7.00   10.00    8.45    0.67
innodb  delete_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  drop_index                            3.00       -1.69%      -0.05     
2.00    4.00    2.95    0.38
innodb  drop_table_when_MANY_tables          19.00       -1.33%      -0.25    
17.00   21.00   18.75    0.94
innodb  insert                              115.00       -1.19%      -1.35   
111.00  116.00  113.65    1.28
innodb  insert_autocommit                     4.00      -25.00%      -0.80     
3.00    4.00    3.20    0.40
innodb  insert_commit                         1.00      +48.72%       0.95     
1.00    2.00    1.95    0.22
innodb  insert_duplicates                    19.00       +1.30%       0.25    
19.00   20.00   19.25    0.43
innodb  insert_key                          277.00       +0.59%       1.65   
265.00  296.00  278.65    7.40
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                   3.00      +22.08%       0.85     
3.00    5.00    3.85    0.65
innodb  insert_select_2_keys                  7.00      -12.00%      -0.75     
5.00    8.00    6.25    0.70
innodb  min_max                               9.00      -17.65%      -1.35     
6.00   10.00    7.65    1.06
innodb  min_max_on_key                       24.00       +1.84%       0.45    
24.00   25.00   24.45    0.50
innodb  multiple_value_insert                 6.00       +9.77%       0.65     
6.00    7.00    6.65    0.48
innodb  once_prepared_select                 29.00       +0.17%       0.05    
28.00   31.00   29.05    0.67
innodb  order_by_big                         13.00       +6.14%       0.85    
12.00   16.00   13.85    1.19
innodb  order_by_big_key                     13.00       +6.81%       0.95    
12.00   16.00   13.95    1.53
innodb  order_by_big_key2                    11.00      +10.93%       1.35    
11.00   14.00   12.35    0.85
innodb  order_by_big_key_desc                14.00       +6.35%       0.95    
13.00   16.00   14.95    1.12
innodb  order_by_big_key_diff                12.00       +6.25%       0.80    
11.00   14.00   12.80    0.81
innodb  order_by_big_key_prefix              12.00       +5.51%       0.70    
12.00   14.00   12.70    0.84
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      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  order_by_range                        1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  outer_join                           19.00      +13.83%       3.05    
18.00   26.00   22.05    2.85
innodb  outer_join_found                     18.00      +14.69%       3.10    
17.00   26.00   21.10    2.86
innodb  outer_join_not_found                 17.00      +11.69%       2.25    
16.00   23.00   19.25    2.26
innodb  outer_join_on_key                    12.00      +20.00%       3.00    
12.00   18.00   15.00    2.17
innodb  prepared_select                      37.00       +0.27%       0.10    
36.00   39.00   37.10    0.54
innodb  select_1_row                          4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
innodb  select_1_row_cache                    3.00      +14.29%       0.50     
3.00    4.00    3.50    0.50
innodb  select_2_rows                         4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_big                           12.00       +4.00%       0.50    
11.00   14.00   12.50    0.97
innodb  select_big_str                        2.00      -53.85%      -0.70     
1.00    2.00    1.30    0.46
innodb  select_cache                         62.00       +1.90%       1.20    
58.00   71.00   63.20    3.25
innodb  select_cache2                        65.00       -0.85%      -0.55    
58.00   71.00   64.45    3.31
innodb  select_column+column                  3.00      +20.00%       0.75     
3.00    4.00    3.75    0.43
innodb  select_diff_key                       0.00     +100.00%       0.30     
0.00    1.00    0.30    0.46
innodb  select_distinct                       5.00       -7.53%      -0.35     
4.00    5.00    4.65    0.48
innodb  select_group                         18.00       -9.09%      -1.50    
15.00   19.00   16.50    1.24
innodb  select_group_when_MANY_tables        11.00       +7.95%       0.95    
10.00   14.00   11.95    0.80
innodb  select_join                           1.00     -100.00%      -0.50     
0.00    1.00    0.50    0.50
innodb  select_key                           64.00       -0.08%      -0.05    
63.00   65.00   63.95    0.50
innodb  select_key2                          71.00       -0.07%      -0.05    
70.00   72.00   70.95    0.67
innodb  select_key2_return_key               68.00       +0.51%       0.35    
67.00   70.00   68.35    0.85
innodb  select_key2_return_prim              69.00       +0.14%       0.10    
68.00   71.00   69.10    0.77
innodb  select_key_prefix                    70.00       +0.92%       0.65    
69.00   72.00   70.65    0.85
innodb  select_key_prefix_join                6.00      -15.38%      -0.80     
4.00    6.00    5.20    0.51
innodb  select_key_return_key                63.00       -0.24%      -0.15    
61.00   64.00   62.85    0.79
innodb  select_many_fields                   14.00       -5.66%      -0.75    
13.00   14.00   13.25    0.43
innodb  select_range                         39.00       +8.45%       3.60    
38.00   47.00   42.60    3.07
innodb  select_range_key2                     9.00       +4.76%       0.45     
9.00   10.00    9.45    0.50
innodb  select_range_prefix                  10.00       -6.95%      -0.65     
8.00   10.00    9.35    0.57
innodb  select_simple                         2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
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.75     
0.00    1.00    0.75    0.43
innodb  update_autocommit                     4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
innodb  update_big                           56.00       +4.60%       2.70    
56.00   62.00   58.70    1.62
innodb  update_commit                         2.00       -2.56%      -0.05     
1.00    3.00    1.95    0.38
innodb  update_of_key                        22.00       -0.23%      -0.05    
21.00   24.00   21.95    0.86
innodb  update_of_key_big                    36.00       +1.77%       0.65    
29.00   46.00   36.65    4.77
innodb  update_of_primary_key_many_keys    1294.00       +2.84%      37.85  
1233.00 1469.00 1331.85   48.99
innodb  update_rollback                       2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  update_with_key                     121.00       -0.17%      -0.20   
116.00  127.00  120.80    2.82
innodb  update_with_key_prefix               42.00       +4.65%       2.05    
40.00   47.00   44.05    1.96
innodb  wisc_benchmark                        3.00       -9.09%      -0.25     
2.00    3.00    2.75    0.43

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00      -48.54%     -10.46    
11.00   61.00   21.54   10.15
innodb  alter_table_drop                     22.00      -18.14%      -3.38    
10.00   57.00   18.62    6.90
innodb  connect                               2.00       +4.10%       0.09     
1.00    3.00    2.09    0.42
innodb  connect+select_1_row                  3.00      -10.66%      -0.29     
2.00    5.00    2.71    0.47
innodb  connect+select_simple                 3.00      -27.18%      -0.64     
1.00    3.00    2.36    0.49
innodb  count                                17.00       -7.95%      -1.25    
12.00  193.00   15.75    8.64
innodb  count_distinct                        7.00       -6.50%      -0.43     
5.00   50.00    6.57    2.23
innodb  count_distinct_2                     15.00      -13.51%      -1.79    
11.00   63.00   13.21    2.90
innodb  count_distinct_big                   25.00      -13.79%      -3.03     
5.00   67.00   21.97    2.99
innodb  count_distinct_group                 14.00       -6.00%      -0.79    
10.00   68.00   13.21    3.04
innodb  count_distinct_group_on_key           9.00       +5.28%       0.50     
7.00   69.00    9.50    2.96
innodb  count_distinct_group_on_key_parts    15.00      -21.32%      -2.64     
9.00   72.00   12.36    3.10
innodb  count_distinct_key_prefix             6.00      -16.78%      -0.86     
3.00   52.00    5.14    2.34
innodb  count_group_on_key_parts             10.00       +0.20%       0.02     
7.00   72.00   10.02    3.09
innodb  count_on_key                         96.00      -11.24%      -9.70    
68.00  107.00   86.30    7.38
innodb  create+drop                          32.00       +1.44%       0.47    
18.00   75.00   32.47   11.63
innodb  create_index                          3.00       -3.37%      -0.10     
1.00    8.00    2.90    1.12
innodb  create_key+drop                      31.00       -9.42%      -2.67    
21.00   50.00   28.33    4.85
innodb  create_MANY_tables                   24.00      +28.34%       9.49    
14.00  121.00   33.49   16.93
innodb  create_table                          0.00     +100.00%       0.10     
0.00    3.00    0.10    0.36
innodb  delete_all_many_keys                610.00      -29.15%    -137.70   
212.00 1888.00  472.30  358.32
innodb  delete_autocommit                     4.00      -15.93%      -0.55     
2.00   14.00    3.45    0.74
innodb  delete_big                            1.00     -232.96%      -0.70     
0.00    3.00    0.30    0.47
innodb  delete_big_many_keys                609.00      -27.39%    -130.93   
212.00 2293.00  478.07  372.01
innodb  delete_commit                         1.00      +34.48%       0.53     
1.00    5.00    1.53    0.53
innodb  delete_key                            3.00       +1.39%       0.04     
2.00   35.00    3.04    1.47
innodb  delete_range                          8.00       +3.88%       0.32     
5.00   23.00    8.32    3.17
innodb  delete_rollback                       2.00      -13.94%      -0.24     
1.00   12.00    1.76    0.90
innodb  drop_index                            3.00       -1.66%      -0.05     
1.00    9.00    2.95    1.29
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    2.00    0.05    0.23
innodb  drop_table_when_MANY_tables          19.00       +2.75%       0.54    
11.00   90.00   19.54    7.37
innodb  insert                              115.00       -7.48%      -8.00     
3.00  343.00  107.00   14.35
innodb  insert_autocommit                     4.00      -33.09%      -0.99     
2.00   99.00    3.01    3.24
innodb  insert_commit                         1.00      +28.59%       0.40     
1.00    3.00    1.40    0.50
innodb  insert_duplicates                    19.00      -21.65%      -3.38    
11.00   21.00   15.62    2.70
innodb  insert_key                          277.00       +8.29%      25.05   
142.00  700.00  302.05  104.65
innodb  insert_many_fields                    6.00       -6.82%      -0.38     
3.00   17.00    5.62    1.74
innodb  insert_rollback                       2.00      -18.84%      -0.32     
1.00    3.00    1.68    0.53
innodb  insert_select_1_key                   3.00      +20.74%       0.79     
2.00   10.00    3.79    0.88
innodb  insert_select_2_keys                  7.00      -15.17%      -0.92     
4.00   16.00    6.08    2.05
innodb  min_max                               9.00      -15.03%      -1.18     
6.00  110.00    7.82    4.45
innodb  min_max_on_key                       24.00      -15.90%      -3.29    
14.00   37.00   20.71    3.12
innodb  multiple_value_insert                 6.00       -9.09%      -0.50     
2.00   50.00    5.50    4.20
innodb  once_prepared_select                 29.00      -18.80%      -4.59    
18.00   32.00   24.41    3.63
innodb  order_by_big                         13.00       +9.15%       1.31    
12.00   31.00   14.31    1.52
innodb  order_by_big_key                     13.00       +2.37%       0.32    
11.00   32.00   13.32    1.64
innodb  order_by_big_key2                    11.00      +10.00%       1.22    
10.00   33.00   12.22    1.53
innodb  order_by_big_key_desc                14.00       -3.23%      -0.44    
11.00   32.00   13.56    1.69
innodb  order_by_big_key_diff                12.00       +2.10%       0.26    
10.00   31.00   12.26    1.49
innodb  order_by_big_key_prefix              12.00       +3.42%       0.43    
10.00   32.00   12.43    1.54
innodb  order_by_key2_diff                    1.00      +28.39%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -25.95%      -0.21     
0.00    2.00    0.79    0.41
innodb  order_by_range                        1.00      -19.73%      -0.16     
0.00    2.00    0.84    0.38
innodb  outer_join                           19.00       +2.27%       0.44    
15.00   61.00   19.44    3.72
innodb  outer_join_found                     18.00       +4.54%       0.86    
14.00   58.00   18.86    3.57
innodb  outer_join_not_found                 17.00       -2.59%      -0.43    
12.00   46.00   16.57    3.19
innodb  outer_join_on_key                    12.00       +7.55%       0.98    
10.00   59.00   12.98    2.77
innodb  prepared_select                      37.00      -17.24%      -5.44    
22.00   40.00   31.56    4.56
innodb  select_1_row                          4.00      -39.00%      -1.12     
2.00    4.00    2.88    0.70
innodb  select_1_row_cache                    3.00      -10.52%      -0.29     
2.00    4.00    2.71    0.70
innodb  select_2_rows                         4.00      -37.56%      -1.09     
2.00    4.00    2.91    0.71
innodb  select_big                           12.00       +1.46%       0.18     
0.00   31.00   12.18    1.53
innodb  select_big_str                        2.00      -70.78%      -0.83     
0.00    2.00    1.17    0.38
innodb  select_cache                         62.00       -3.71%      -2.22    
49.00   77.00   59.78    5.60
innodb  select_cache2                        65.00       -8.07%      -4.85    
49.00   75.00   60.15    6.23
innodb  select_column+column                  3.00       -1.47%      -0.04     
2.00    4.00    2.96    0.72
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.42
innodb  select_distinct                       5.00      -17.62%      -0.75     
3.00    8.00    4.25    0.55
innodb  select_group                         18.00      -10.62%      -1.73     
4.00  136.00   16.27    5.32
innodb  select_group_when_MANY_tables        11.00      -14.96%      -1.43     
3.00   49.00    9.57    9.27
innodb  select_join                           1.00      -74.08%      -0.43     
0.00    1.00    0.57    0.49
innodb  select_key                           64.00      -20.29%     -10.79    
40.00   66.00   53.21    7.62
innodb  select_key2                          71.00      -18.52%     -11.09    
45.00   75.00   59.91    8.43
innodb  select_key2_return_key               68.00      -18.80%     -10.76    
42.00   71.00   57.24    8.24
innodb  select_key2_return_prim              69.00      -18.97%     -11.00    
42.00   72.00   58.00    8.38
innodb  select_key_prefix                    70.00      -18.29%     -10.82    
44.00   75.00   59.18    8.48
innodb  select_key_prefix_join                6.00      -26.67%      -1.26     
3.00   10.00    4.74    0.65
innodb  select_key_return_key                63.00      -20.63%     -10.77    
38.00   65.00   52.23    7.62
innodb  select_many_fields                   14.00       +5.86%       0.87    
11.00   19.00   14.87    1.79
innodb  select_range                         39.00      +16.77%       7.86    
38.00   76.00   46.86    4.07
innodb  select_range_key2                     9.00       -8.31%      -0.69     
6.00   11.00    8.31    1.06
innodb  select_range_prefix                  10.00      -26.68%      -2.11     
5.00   10.00    7.89    1.13
innodb  select_simple                         2.00      -20.32%      -0.34     
1.00    3.00    1.66    0.51
innodb  select_simple_cache                   2.00      -27.12%      -0.43     
1.00    3.00    1.57    0.51
innodb  select_simple_join                    0.00     +100.00%       0.66     
0.00    3.00    0.66    0.48
innodb  update_autocommit                     4.00      -19.63%      -0.66     
2.00   16.00    3.34    1.00
innodb  update_big                           56.00       -9.14%      -4.69    
31.00  195.00   51.31   24.01
innodb  update_commit                         2.00      -26.71%      -0.42     
1.00   10.00    1.58    0.72
innodb  update_of_key                        22.00       +8.90%       2.15    
18.00  100.00   24.15    6.06
innodb  update_of_key_big                    36.00      -29.42%      -8.18    
15.00   75.00   27.82   10.91
innodb  update_of_primary_key_many_keys    1294.00       -3.90%     -48.61   
647.00 6065.00 1245.39  933.87
innodb  update_rollback                       2.00      -12.73%      -0.23     
1.00   31.00    1.77    1.86
innodb  update_with_key                     121.00       -9.69%     -10.69    
90.00  598.00  110.31   20.48
innodb  update_with_key_prefix               42.00       -5.48%      -2.18    
33.00  202.00   39.82    6.75
innodb  wisc_benchmark                        3.00      -21.05%      -0.52     
2.00    5.00    2.48    0.53

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

  2246.1.2: Lee Bieber 2011-03-23 [merge] Merge Patrick - Updated dbqp's 
ld_lib_paths to find the new libdrizzle locations
    2246.2.1: patrick crews 2011-03-23 Fixed ld_lib_paths in dbqp to find the 
new libdrizzle locations in Monty's libdrizzle2.0 tree
  2246.1.1: Lee Bieber 2011-03-23 [merge] Merge Monty - Splits out 
libdrizzle-1.0 and libdrizzle-2.0.
    2244.1.2: Monty Taylor 2011-03-22 Added libdrizzle-2.0 to the list of libs 
dbqp loads.
    2244.1.1: Monty Taylor 2011-03-22 Split libdrizzle into 1.0 and 2.0. 
Applied the C++ changes to 2.0 branch.

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

Reply via email to