=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   983
RUN DATE: 2011-04-01T14:31:01.857008
SERVER:   drizzled
VERSION:  staging
REVISION: 2260
COMMENT:  2260: Lee Bieber 2011-04-01 [merge] Merge Monty - Finishes the 
libdrizzle-2.0 transition in how we install stuff

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       +2.44%       0.80    
32.00   35.00   32.80    1.17
innodb  alter_table_drop                     24.00       +1.64%       0.40    
22.00   26.00   24.40    1.50
innodb  connect                               2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  count                                17.00      -14.86%      -2.20    
13.00   17.00   14.80    1.83
innodb  count_distinct                        8.00      -17.65%      -1.20     
6.00    8.00    6.80    0.75
innodb  count_distinct_2                     14.00       -7.69%      -1.00    
12.00   14.00   13.00    0.63
innodb  count_distinct_big                   25.00       -7.76%      -1.80    
21.00   25.00   23.20    1.47
innodb  count_distinct_group                 16.00       -8.11%      -1.20    
14.00   16.00   14.80    0.75
innodb  count_distinct_group_on_key           9.00       -2.27%      -0.20     
8.00    9.00    8.80    0.40
innodb  count_distinct_group_on_key_parts    12.00       +7.69%       1.00    
11.00   14.00   13.00    1.26
innodb  count_distinct_key_prefix             6.00      -11.11%      -0.60     
5.00    6.00    5.40    0.49
innodb  count_group_on_key_parts             11.00       -0.00%       0.00    
11.00   11.00   11.00    0.00
innodb  count_on_key                         98.00       -2.51%      -2.40    
93.00   98.00   95.60    2.06
innodb  create+drop                          33.00       -0.00%       0.00    
32.00   34.00   33.00    0.63
innodb  create_index                          3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  create_key+drop                      32.00       -3.23%      -1.00    
30.00   32.00   31.00    0.63
innodb  create_MANY_tables                   20.00       +1.96%       0.40    
20.00   21.00   20.40    0.49
innodb  delete_all_many_keys                639.00       -1.24%      -7.80   
588.00  674.00  631.20   27.52
innodb  delete_autocommit                     3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  delete_big                            0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                638.00       -1.24%      -7.80   
587.00  673.00  630.20   27.52
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  delete_range                          8.00       +2.44%       0.20     
7.00   10.00    8.20    0.98
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     
2.00    4.00    3.00    0.63
innodb  drop_table_when_MANY_tables          18.00       +3.23%       0.60    
18.00   19.00   18.60    0.49
innodb  insert                              115.00       -1.23%      -1.40   
112.00  115.00  113.60    1.02
innodb  insert_autocommit                     3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  insert_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  insert_duplicates                    19.00       +1.04%       0.20    
19.00   20.00   19.20    0.40
innodb  insert_key                          276.00       +0.65%       1.80   
265.00  292.00  277.80    8.68
innodb  insert_many_fields                    5.00       +7.41%       0.40     
5.00    6.00    5.40    0.49
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  insert_select_2_keys                  6.00       +9.09%       0.60     
6.00    7.00    6.60    0.49
innodb  min_max                               9.00      -21.62%      -1.60     
6.00    9.00    7.40    1.02
innodb  min_max_on_key                       24.00       +2.44%       0.60    
24.00   25.00   24.60    0.49
innodb  multiple_value_insert                 7.00       -9.38%      -0.60     
6.00    7.00    6.40    0.49
innodb  once_prepared_select                 29.00       -0.00%       0.00    
29.00   29.00   29.00    0.00
innodb  order_by_big                         15.00       -2.74%      -0.40    
13.00   15.00   14.60    0.80
innodb  order_by_big_key                     15.00      -11.94%      -1.60    
12.00   15.00   13.40    1.36
innodb  order_by_big_key2                    13.00       -0.00%       0.00    
12.00   14.00   13.00    0.63
innodb  order_by_big_key_desc                16.00       -8.11%      -1.20    
14.00   16.00   14.80    0.75
innodb  order_by_big_key_diff                12.00      +10.45%       1.40    
12.00   15.00   13.40    1.02
innodb  order_by_big_key_prefix              13.00       -1.56%      -0.20    
12.00   14.00   12.80    0.75
innodb  order_by_key2_diff                    1.00      +44.44%       0.80     
1.00    2.00    1.80    0.40
innodb  order_by_key_prefix                   1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           19.00      +12.84%       2.80    
19.00   24.00   21.80    1.60
innodb  outer_join_found                     18.00      +15.89%       3.40    
18.00   23.00   21.40    1.74
innodb  outer_join_not_found                 16.00      +18.37%       3.60    
16.00   25.00   19.60    3.01
innodb  outer_join_on_key                    13.00       +9.72%       1.40    
13.00   16.00   14.40    1.02
innodb  prepared_select                      37.00       -0.54%      -0.20    
36.00   38.00   36.80    0.75
innodb  select_1_row                          3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_1_row_cache                    4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  select_2_rows                         3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_big                           11.00      +11.29%       1.40    
11.00   15.00   12.40    1.36
innodb  select_big_str                        2.00      -66.67%      -0.80     
1.00    2.00    1.20    0.40
innodb  select_cache                         67.00       -3.40%      -2.20    
60.00   72.00   64.80    4.35
innodb  select_cache2                        65.00       +0.91%       0.60    
58.00   73.00   65.60    4.92
innodb  select_column+column                  4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_distinct                       5.00       -4.17%      -0.20     
4.00    5.00    4.80    0.40
innodb  select_group                         18.00       -5.88%      -1.00    
15.00   18.00   17.00    1.26
innodb  select_group_when_MANY_tables        12.00       -1.69%      -0.20    
10.00   13.00   11.80    0.98
innodb  select_join                           0.00     +100.00%       0.80     
0.00    1.00    0.80    0.40
innodb  select_key                           64.00       +0.62%       0.40    
63.00   66.00   64.40    1.02
innodb  select_key2                          70.00       +0.28%       0.20    
69.00   71.00   70.20    0.75
innodb  select_key2_return_key               69.00       -0.88%      -0.60    
67.00   69.00   68.40    0.80
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    
68.00   71.00   69.60    1.02
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.32%      -0.20    
62.00   64.00   62.80    0.75
innodb  select_many_fields                   14.00       -2.94%      -0.40    
13.00   14.00   13.60    0.49
innodb  select_range                         47.00       -1.29%      -0.60    
40.00   49.00   46.40    3.32
innodb  select_range_key2                    10.00       -6.38%      -0.60     
9.00   10.00    9.40    0.49
innodb  select_range_prefix                   9.00       +4.26%       0.40     
9.00   10.00    9.40    0.49
innodb  select_simple                         3.00      -25.00%      -0.60     
2.00    3.00    2.40    0.49
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  update_autocommit                     5.00      -31.58%      -1.20     
3.00    5.00    3.80    0.75
innodb  update_big                           57.00       +4.68%       2.80    
57.00   65.00   59.80    2.93
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        21.00       +4.55%       1.00    
21.00   24.00   22.00    1.26
innodb  update_of_key_big                    34.00       +5.56%       2.00    
32.00   42.00   36.00    3.58
innodb  update_of_primary_key_many_keys    1327.00       -0.29%      -3.80  
1228.00 1408.00 1323.20   57.33
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     119.00       +1.00%       1.20   
119.00  122.00  120.20    1.17
innodb  update_with_key_prefix               43.00       +2.71%       1.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       +0.78%       0.25    
29.00   35.00   32.25    1.22
innodb  alter_table_drop                     24.00       -0.63%      -0.15    
22.00   26.00   23.85    1.11
innodb  connect                               2.00      +11.11%       0.25     
2.00    3.00    2.25    0.43
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      +21.57%       0.55     
2.00    3.00    2.55    0.50
innodb  count                                17.00      -11.11%      -1.70    
13.00   19.00   15.30    1.98
innodb  count_distinct                        8.00      -15.94%      -1.10     
6.00    8.00    6.90    0.70
innodb  count_distinct_2                     14.00       -2.56%      -0.35    
11.00   17.00   13.65    1.56
innodb  count_distinct_big                   25.00       -9.17%      -2.10    
21.00   25.00   22.90    1.76
innodb  count_distinct_group                 16.00       -9.22%      -1.35    
13.00   16.00   14.65    0.85
innodb  count_distinct_group_on_key           9.00       +4.76%       0.45     
8.00   12.00    9.45    0.92
innodb  count_distinct_group_on_key_parts    12.00       +7.69%       1.00    
11.00   15.00   13.00    1.22
innodb  count_distinct_key_prefix             6.00       -8.11%      -0.45     
4.00    6.00    5.55    0.59
innodb  count_group_on_key_parts             11.00       -1.85%      -0.20    
10.00   11.00   10.80    0.40
innodb  count_on_key                         98.00       -3.87%      -3.65    
91.00   98.00   94.35    2.06
innodb  create+drop                          33.00       -0.00%       0.00    
31.00   35.00   33.00    1.00
innodb  create_index                          3.00       -1.69%      -0.05     
2.00    4.00    2.95    0.38
innodb  create_key+drop                      32.00       -3.39%      -1.05    
30.00   32.00   30.95    0.67
innodb  create_MANY_tables                   20.00       +5.21%       1.10    
20.00   24.00   21.10    1.34
innodb  delete_all_many_keys                639.00       -0.09%      -0.60   
582.00  705.00  638.40   27.24
innodb  delete_autocommit                     3.00      +17.81%       0.65     
3.00    5.00    3.65    0.57
innodb  delete_big                            0.00     +100.00%       0.55     
0.00    1.00    0.55    0.50
innodb  delete_big_many_keys                638.00       -0.07%      -0.45   
581.00  704.00  637.55   27.28
innodb  delete_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  delete_key                            3.00       -9.09%      -0.25     
2.00    4.00    2.75    0.54
innodb  delete_range                          8.00       +5.88%       0.50     
7.00   10.00    8.50    0.74
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     
2.00    4.00    3.05    0.50
innodb  drop_table_when_MANY_tables          18.00       +3.49%       0.65    
17.00   21.00   18.65    0.85
innodb  insert                              115.00       -1.41%      -1.60   
111.00  116.00  113.40    1.28
innodb  insert_autocommit                     3.00       +7.69%       0.25     
3.00    4.00    3.25    0.43
innodb  insert_commit                         2.00      -14.29%      -0.25     
1.00    2.00    1.75    0.43
innodb  insert_duplicates                    19.00       +0.78%       0.15    
19.00   20.00   19.15    0.36
innodb  insert_key                          276.00       +1.20%       3.35   
265.00  296.00  279.35    7.48
innodb  insert_many_fields                    5.00      +12.28%       0.70     
5.00    7.00    5.70    0.56
innodb  insert_rollback                       2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  insert_select_1_key                   3.00      +23.08%       0.90     
3.00    5.00    3.90    0.62
innodb  insert_select_2_keys                  6.00       +3.23%       0.20     
5.00    8.00    6.20    0.81
innodb  min_max                               9.00      -16.88%      -1.30     
6.00   10.00    7.70    1.05
innodb  min_max_on_key                       24.00       +1.84%       0.45    
24.00   25.00   24.45    0.50
innodb  multiple_value_insert                 7.00       -6.87%      -0.45     
6.00    7.00    6.55    0.50
innodb  once_prepared_select                 29.00       +0.34%       0.10    
28.00   30.00   29.10    0.54
innodb  order_by_big                         15.00       -6.38%      -0.90    
13.00   16.00   14.10    1.04
innodb  order_by_big_key                     15.00       -9.09%      -1.25    
12.00   16.00   13.75    1.30
innodb  order_by_big_key2                    13.00       -1.56%      -0.20    
11.00   14.00   12.80    0.81
innodb  order_by_big_key_desc                16.00       -9.97%      -1.45    
13.00   16.00   14.55    1.07
innodb  order_by_big_key_diff                12.00       +9.09%       1.20    
11.00   15.00   13.20    0.93
innodb  order_by_big_key_prefix              13.00       +0.38%       0.05    
12.00   15.00   13.05    0.92
innodb  order_by_key2_diff                    1.00      +33.33%       0.50     
1.00    2.00    1.50    0.50
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      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  outer_join                           19.00      +13.64%       3.00    
18.00   25.00   22.00    2.21
innodb  outer_join_found                     18.00      +15.09%       3.20    
17.00   24.00   21.20    2.09
innodb  outer_join_not_found                 16.00      +17.53%       3.40    
16.00   25.00   19.40    2.44
innodb  outer_join_on_key                    13.00      +10.96%       1.60    
12.00   17.00   14.60    1.66
innodb  prepared_select                      37.00       -0.27%      -0.10    
36.00   38.00   36.90    0.44
innodb  select_1_row                          3.00      +15.49%       0.55     
3.00    4.00    3.55    0.50
innodb  select_1_row_cache                    4.00      -15.94%      -0.55     
3.00    4.00    3.45    0.50
innodb  select_2_rows                         3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_big                           11.00      +11.29%       1.40    
11.00   15.00   12.40    1.20
innodb  select_big_str                        2.00      -53.85%      -0.70     
1.00    2.00    1.30    0.46
innodb  select_cache                         67.00       -5.59%      -3.55    
60.00   72.00   63.45    3.31
innodb  select_cache2                        65.00       -1.01%      -0.65    
58.00   73.00   64.35    3.37
innodb  select_column+column                  4.00       -2.56%      -0.10     
3.00    4.00    3.90    0.30
innodb  select_diff_key                       0.00     +100.00%       0.25     
0.00    1.00    0.25    0.43
innodb  select_distinct                       5.00       -9.89%      -0.45     
4.00    5.00    4.55    0.50
innodb  select_group                         18.00       -7.46%      -1.25    
15.00   19.00   16.75    1.41
innodb  select_group_when_MANY_tables        12.00       -2.56%      -0.30    
10.00   13.00   11.70    0.95
innodb  select_join                           0.00     +100.00%       0.65     
0.00    1.00    0.65    0.48
innodb  select_key                           64.00       -0.00%       0.00    
63.00   66.00   64.00    0.77
innodb  select_key2                          70.00       +0.92%       0.65    
69.00   72.00   70.65    0.73
innodb  select_key2_return_key               69.00       -1.25%      -0.85    
67.00   70.00   68.15    0.91
innodb  select_key2_return_prim              69.00       -0.00%       0.00    
68.00   71.00   69.00    0.77
innodb  select_key_prefix                    70.00       +0.28%       0.20    
68.00   72.00   70.20    0.87
innodb  select_key_prefix_join                5.00       +4.76%       0.25     
5.00    6.00    5.25    0.43
innodb  select_key_return_key                63.00       -0.24%      -0.15    
61.00   64.00   62.85    0.73
innodb  select_many_fields                   14.00       -6.46%      -0.85    
12.00   14.00   13.15    0.48
innodb  select_range                         47.00       -7.80%      -3.40    
39.00   49.00   43.60    3.38
innodb  select_range_key2                    10.00       -5.82%      -0.55     
9.00   10.00    9.45    0.50
innodb  select_range_prefix                   9.00       +3.23%       0.30     
8.00   10.00    9.30    0.64
innodb  select_simple                         3.00      -39.53%      -0.85     
2.00    3.00    2.15    0.36
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  update_autocommit                     5.00      -36.99%      -1.35     
3.00    5.00    3.65    0.57
innodb  update_big                           57.00       +4.28%       2.55    
56.00   65.00   59.55    1.88
innodb  update_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  update_of_key                        21.00       +4.11%       0.90    
21.00   24.00   21.90    0.83
innodb  update_of_key_big                    34.00       +5.03%       1.80    
30.00   42.00   35.80    3.06
innodb  update_of_primary_key_many_keys    1327.00       +0.32%       4.25  
1228.00 1469.00 1331.25   50.69
innodb  update_rollback                       2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  update_with_key                     119.00       +1.41%       1.70   
117.00  127.00  120.70    2.30
innodb  update_with_key_prefix               43.00       +1.94%       0.85    
42.00   46.00   43.85    1.39
innodb  wisc_benchmark                        3.00      -17.65%      -0.45     
2.00    3.00    2.55    0.50

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00      -47.49%     -10.30    
11.00   61.00   21.70   10.16
innodb  alter_table_drop                     24.00      -28.35%      -5.30    
10.00   57.00   18.70    6.88
innodb  connect                               2.00       +4.25%       0.09     
1.00    3.00    2.09    0.42
innodb  connect+select_1_row                  3.00      -10.49%      -0.28     
2.00    5.00    2.72    0.47
innodb  connect+select_simple                 2.00      +15.31%       0.36     
1.00    3.00    2.36    0.49
innodb  count                                17.00       -8.01%      -1.26    
12.00  193.00   15.74    8.58
innodb  count_distinct                        8.00      -21.56%      -1.42     
5.00   50.00    6.58    2.22
innodb  count_distinct_2                     14.00       -5.89%      -0.78    
11.00   63.00   13.22    2.89
innodb  count_distinct_big                   25.00      -13.72%      -3.02     
5.00   67.00   21.98    2.97
innodb  count_distinct_group                 16.00      -20.91%      -2.77    
10.00   68.00   13.23    3.03
innodb  count_distinct_group_on_key           9.00       +5.27%       0.50     
7.00   69.00    9.50    2.94
innodb  count_distinct_group_on_key_parts    12.00       +3.03%       0.38     
9.00   72.00   12.38    3.08
innodb  count_distinct_key_prefix             6.00      -16.65%      -0.86     
3.00   52.00    5.14    2.32
innodb  count_group_on_key_parts             11.00       -9.65%      -0.97     
7.00   72.00   10.03    3.07
innodb  count_on_key                         98.00      -13.40%     -11.58    
68.00  107.00   86.42    7.39
innodb  create+drop                          33.00       -1.60%      -0.52    
18.00   75.00   32.48   11.55
innodb  create_index                          3.00       -3.40%      -0.10     
1.00    8.00    2.90    1.11
innodb  create_key+drop                      32.00      -12.80%      -3.63    
21.00   50.00   28.37    4.83
innodb  create_MANY_tables                   20.00      +39.95%      13.31    
14.00  121.00   33.31   16.88
innodb  create_table                          0.00     +100.00%       0.10     
0.00    3.00    0.10    0.35
innodb  delete_all_many_keys                639.00      -34.60%    -164.26   
212.00 1888.00  474.74  356.20
innodb  delete_autocommit                     3.00      +13.12%       0.45     
2.00   14.00    3.45    0.74
innodb  delete_big                            0.00     +100.00%       0.30     
0.00    3.00    0.30    0.47
innodb  delete_big_many_keys                638.00      -32.81%    -157.60   
212.00 2293.00  480.40  369.73
innodb  delete_commit                         2.00      -30.57%      -0.47     
1.00    5.00    1.53    0.53
innodb  delete_key                            3.00       +1.26%       0.04     
2.00   35.00    3.04    1.46
innodb  delete_range                          8.00       +3.92%       0.33     
5.00   23.00    8.33    3.15
innodb  delete_rollback                       2.00      -13.64%      -0.24     
1.00   12.00    1.76    0.90
innodb  drop_index                            3.00       -1.59%      -0.05     
1.00    9.00    2.95    1.29
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.23
innodb  drop_table_when_MANY_tables          18.00       +7.79%       1.52    
11.00   90.00   19.52    7.32
innodb  insert                              115.00       -7.39%      -7.91     
3.00  343.00  107.09   14.26
innodb  insert_autocommit                     3.00       +0.29%       0.01     
2.00   99.00    3.01    3.22
innodb  insert_commit                         2.00      -42.39%      -0.60     
1.00    3.00    1.40    0.50
innodb  insert_duplicates                    19.00      -21.26%      -3.33    
11.00   21.00   15.67    2.71
innodb  insert_key                          276.00       +8.51%      25.67   
142.00  700.00  301.67  103.88
innodb  insert_many_fields                    5.00      +11.00%       0.62     
3.00   17.00    5.62    1.73
innodb  insert_rollback                       2.00      -18.60%      -0.31     
1.00    3.00    1.69    0.53
innodb  insert_select_1_key                   3.00      +20.81%       0.79     
2.00   10.00    3.79    0.87
innodb  insert_select_2_keys                  6.00       +1.28%       0.08     
4.00   16.00    6.08    2.04
innodb  min_max                               9.00      -15.09%      -1.18     
6.00  110.00    7.82    4.42
innodb  min_max_on_key                       24.00      -15.60%      -3.24    
14.00   37.00   20.76    3.13
innodb  multiple_value_insert                 7.00      -26.96%      -1.49     
2.00   50.00    5.51    4.17
innodb  once_prepared_select                 29.00      -18.47%      -4.52    
18.00   32.00   24.48    3.65
innodb  order_by_big                         15.00       -4.84%      -0.69    
12.00   31.00   14.31    1.51
innodb  order_by_big_key                     15.00      -12.62%      -1.68    
11.00   32.00   13.32    1.64
innodb  order_by_big_key2                    13.00       -6.27%      -0.77    
10.00   33.00   12.23    1.52
innodb  order_by_big_key_desc                16.00      -17.87%      -2.43    
11.00   32.00   13.57    1.69
innodb  order_by_big_key_diff                12.00       +2.21%       0.27    
10.00   31.00   12.27    1.49
innodb  order_by_big_key_prefix              13.00       -4.55%      -0.57    
10.00   32.00   12.43    1.54
innodb  order_by_key2_diff                    1.00      +28.44%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -25.66%      -0.20     
0.00    2.00    0.80    0.41
innodb  order_by_range                        1.00      -19.71%      -0.16     
0.00    2.00    0.84    0.38
innodb  outer_join                           19.00       +2.47%       0.48    
15.00   61.00   19.48    3.71
innodb  outer_join_found                     18.00       +4.72%       0.89    
14.00   58.00   18.89    3.56
innodb  outer_join_not_found                 16.00       +3.68%       0.61    
12.00   46.00   16.61    3.19
innodb  outer_join_on_key                    13.00       +0.03%       0.00    
10.00   59.00   13.00    2.76
innodb  prepared_select                      37.00      -16.97%      -5.37    
22.00   40.00   31.63    4.57
innodb  select_1_row                          3.00       -3.91%      -0.11     
2.00    4.00    2.89    0.70
innodb  select_1_row_cache                    4.00      -46.78%      -1.27     
2.00    4.00    2.73    0.70
innodb  select_2_rows                         3.00       -2.85%      -0.08     
2.00    4.00    2.92    0.71
innodb  select_big                           11.00       +9.69%       1.18     
0.00   31.00   12.18    1.53
innodb  select_big_str                        2.00      -70.66%      -0.83     
0.00    2.00    1.17    0.38
innodb  select_cache                         67.00      -11.99%      -7.17    
49.00   77.00   59.83    5.59
innodb  select_cache2                        65.00       -7.97%      -4.80    
49.00   75.00   60.20    6.22
innodb  select_column+column                  4.00      -34.61%      -1.03     
2.00    4.00    2.97    0.73
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.42
innodb  select_distinct                       5.00      -17.53%      -0.75     
3.00    8.00    4.25    0.55
innodb  select_group                         18.00      -10.53%      -1.72     
4.00  136.00   16.28    5.29
innodb  select_group_when_MANY_tables        12.00      -25.00%      -2.40     
3.00   49.00    9.60    9.21
innodb  select_join                           0.00     +100.00%       0.58     
0.00    1.00    0.58    0.49
innodb  select_key                           64.00      -19.94%     -10.64    
40.00   66.00   53.36    7.67
innodb  select_key2                          70.00      -16.56%      -9.94    
45.00   75.00   60.06    8.47
innodb  select_key2_return_key               69.00      -20.22%     -11.61    
42.00   71.00   57.39    8.29
innodb  select_key2_return_prim              69.00      -18.64%     -10.84    
42.00   72.00   58.16    8.43
innodb  select_key_prefix                    70.00      -17.98%     -10.67    
44.00   75.00   59.33    8.52
innodb  select_key_prefix_join                5.00       -5.45%      -0.26     
3.00   10.00    4.74    0.65
innodb  select_key_return_key                63.00      -20.28%     -10.62    
38.00   65.00   52.38    7.67
innodb  select_many_fields                   14.00       +5.71%       0.85    
11.00   19.00   14.85    1.79
innodb  select_range                         47.00       -0.38%      -0.18    
38.00   76.00   46.82    4.07
innodb  select_range_key2                    10.00      -20.09%      -1.67     
6.00   11.00    8.33    1.06
innodb  select_range_prefix                   9.00      -13.75%      -1.09     
5.00   10.00    7.91    1.13
innodb  select_simple                         3.00      -79.72%      -1.33     
1.00    3.00    1.67    0.51
innodb  select_simple_cache                   2.00      -26.63%      -0.42     
1.00    3.00    1.58    0.51
innodb  select_simple_join                    1.00      -49.92%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     5.00      -49.31%      -1.65     
2.00   16.00    3.35    0.99
innodb  update_big                           57.00      -10.83%      -5.57    
31.00  195.00   51.43   23.86
innodb  update_commit                         2.00      -26.32%      -0.42     
1.00   10.00    1.58    0.72
innodb  update_of_key                        21.00      +12.93%       3.12    
18.00  100.00   24.12    6.02
innodb  update_of_key_big                    34.00      -21.73%      -6.07    
15.00   75.00   27.93   10.88
innodb  update_of_primary_key_many_keys    1327.00       -6.44%     -80.25   
647.00 6065.00 1246.75  925.45
innodb  update_rollback                       2.00      -12.45%      -0.22     
1.00   31.00    1.78    1.85
innodb  update_with_key                     119.00       -7.72%      -8.53    
90.00  598.00  110.47   20.38
innodb  update_with_key_prefix               43.00       -7.83%      -3.12    
33.00  202.00   39.88    6.72
innodb  wisc_benchmark                        3.00      -21.01%      -0.52     
2.00    5.00    2.48    0.53

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

  2259.1.1: Monty Taylor 2011-03-31 Finish the transition to libdrizzle-2.0 
libs (after discussion with derks

_______________________________________________
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