=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   915
RUN DATE: 2011-02-22T09:43:25.607342
SERVER:   drizzled
VERSION:  staging
REVISION: 2192
COMMENT:  2192: Lee Bieber 2011-02-22 [merge] Merge Patrick - 722884: 
mysql_protocol.prototest is taking too long to execute    

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00       -0.61%      -0.20    
32.00   34.00   32.80    0.75
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                  3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  connect+select_simple                 3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  count                                13.00      +14.47%       2.20    
13.00   18.00   15.20    1.94
innodb  count_distinct                        7.00      -12.90%      -0.80     
6.00    7.00    6.20    0.40
innodb  count_distinct_2                     14.00       +2.78%       0.40    
12.00   16.00   14.40    1.36
innodb  count_distinct_big                   21.00       +5.41%       1.20    
20.00   25.00   22.20    1.94
innodb  count_distinct_group                 15.00       -0.00%       0.00    
15.00   15.00   15.00    0.00
innodb  count_distinct_group_on_key           8.00      +14.89%       1.40     
8.00   11.00    9.40    1.02
innodb  count_distinct_group_on_key_parts    13.00       +1.52%       0.20    
12.00   15.00   13.20    0.98
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             10.00       +9.09%       1.00    
10.00   12.00   11.00    0.63
innodb  count_on_key                         92.00       +0.65%       0.60    
92.00   93.00   92.60    0.49
innodb  create+drop                          32.00       +2.44%       0.80    
32.00   34.00   32.80    0.98
innodb  create_index                          4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  create_key+drop                      33.00       -3.77%      -1.20    
31.00   33.00   31.80    0.75
innodb  create_MANY_tables                   22.00       -5.77%      -1.20    
20.00   22.00   20.80    0.98
innodb  delete_all_many_keys                714.00       -7.59%     -50.40   
622.00  714.00  663.60   39.14
innodb  delete_autocommit                     3.00      +21.05%       0.80     
3.00    5.00    3.80    0.75
innodb  delete_big                            1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  delete_big_many_keys                713.00       -7.57%     -50.20   
622.00  713.00  662.80   38.93
innodb  delete_commit                         2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  delete_key                            2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  delete_range                         10.00       -8.70%      -0.80     
9.00   10.00    9.20    0.40
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       -1.06%      -0.20    
18.00   20.00   18.80    0.75
innodb  insert                              114.00       -0.88%      -1.00   
112.00  114.00  113.00    0.63
innodb  insert_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  insert_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_duplicates                    19.00       -0.00%       0.00    
19.00   19.00   19.00    0.00
innodb  insert_key                          297.00       -5.10%     -14.40   
270.00  298.00  282.60   12.40
innodb  insert_many_fields                    6.00       -0.00%       0.00     
5.00    7.00    6.00    0.63
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  insert_select_2_keys                  6.00       -7.14%      -0.40     
5.00    6.00    5.60    0.49
innodb  min_max                               7.00       +7.89%       0.60     
7.00    9.00    7.60    0.80
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.00%       0.00    
29.00   29.00   29.00    0.00
innodb  order_by_big                         13.00       +4.41%       0.60    
13.00   15.00   13.60    0.80
innodb  order_by_big_key                     15.00       -0.00%       0.00    
14.00   16.00   15.00    0.89
innodb  order_by_big_key2                    13.00       +2.99%       0.40    
12.00   14.00   13.40    0.80
innodb  order_by_big_key_desc                16.00       -5.26%      -0.80    
14.00   16.00   15.20    0.98
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       +6.25%       0.80    
12.00   13.00   12.80    0.40
innodb  order_by_key2_diff                    1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  order_by_key_prefix                   1.00      -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                           24.00       +0.83%       0.20    
24.00   25.00   24.20    0.40
innodb  outer_join_found                     23.00       +0.86%       0.20    
22.00   25.00   23.20    0.98
innodb  outer_join_not_found                 20.00       +2.91%       0.60    
20.00   21.00   20.60    0.49
innodb  outer_join_on_key                    16.00       +1.23%       0.20    
16.00   17.00   16.20    0.40
innodb  prepared_select                      38.00       -1.60%      -0.60    
37.00   38.00   37.40    0.49
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                           14.00       -6.06%      -0.80    
12.00   14.00   13.20    0.75
innodb  select_big_str                        2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  select_cache                         60.00       +0.99%       0.60    
57.00   68.00   60.60    3.88
innodb  select_cache2                        61.00       -0.99%      -0.60    
56.00   67.00   60.40    3.67
innodb  select_column+column                  4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
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                         18.00       -0.00%       0.00    
18.00   18.00   18.00    0.00
innodb  select_group_when_MANY_tables        14.00      -11.11%      -1.40    
12.00   14.00   12.60    0.80
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           65.00       -1.88%      -1.20    
63.00   65.00   63.80    0.75
innodb  select_key2                          71.00       -1.14%      -0.80    
69.00   71.00   70.20    0.75
innodb  select_key2_return_key               69.00       -1.47%      -1.00    
67.00   69.00   68.00    0.63
innodb  select_key2_return_prim              70.00       -2.34%      -1.60    
68.00   70.00   68.40    0.80
innodb  select_key_prefix                    71.00       -0.85%      -0.60    
69.00   72.00   70.40    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                64.00       -1.59%      -1.00    
62.00   64.00   63.00    0.63
innodb  select_many_fields                   13.00       -0.00%       0.00    
12.00   14.00   13.00    0.63
innodb  select_range                         39.00       +4.88%       2.00    
38.00   46.00   41.00    3.03
innodb  select_range_key2                    10.00      -11.11%      -1.00     
8.00   10.00    9.00    0.63
innodb  select_range_prefix                   8.00      +16.67%       1.60     
8.00   10.00    9.60    0.80
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  update_autocommit                     4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  update_big                           61.00       -2.35%      -1.40    
57.00   61.00   59.60    1.36
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        23.00       -1.77%      -0.40    
22.00   23.00   22.60    0.49
innodb  update_of_key_big                    38.00       -2.15%      -0.80    
32.00   46.00   37.20    4.83
innodb  update_of_primary_key_many_keys    1455.00       -6.81%     -92.80  
1277.00 1455.00 1362.20   76.77
innodb  update_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  update_with_key                     125.00       -2.46%      -3.00   
118.00  125.00  122.00    2.45
innodb  update_with_key_prefix               44.00       +0.90%       0.40    
40.00   48.00   44.40    2.87
innodb  wisc_benchmark                        2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00       -0.00%       0.00    
31.00   35.00   33.00    1.05
innodb  alter_table_drop                     26.00       -8.79%      -2.10    
23.00   26.00   23.90    1.09
innodb  connect                               2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  connect+select_1_row                  3.00       -3.45%      -0.10     
2.00    3.00    2.90    0.30
innodb  connect+select_simple                 3.00      -13.21%      -0.35     
2.00    3.00    2.65    0.48
innodb  count                                13.00      +16.67%       2.60    
13.00   18.00   15.60    2.06
innodb  count_distinct                        7.00       -7.69%      -0.50     
6.00    8.00    6.50    0.59
innodb  count_distinct_2                     14.00       -1.82%      -0.25    
12.00   16.00   13.75    1.22
innodb  count_distinct_big                   21.00       +6.46%       1.45    
20.00   25.00   22.45    1.96
innodb  count_distinct_group                 15.00       -3.81%      -0.55    
12.00   15.00   14.45    0.97
innodb  count_distinct_group_on_key           8.00      +19.19%       1.90     
8.00   12.00    9.90    0.99
innodb  count_distinct_group_on_key_parts    13.00       +3.35%       0.45    
11.00   15.00   13.45    0.97
innodb  count_distinct_key_prefix             5.00       +8.26%       0.45     
5.00    7.00    5.45    0.59
innodb  count_group_on_key_parts             10.00       +9.50%       1.05    
10.00   12.00   11.05    0.50
innodb  count_on_key                         92.00       +2.95%       2.80    
92.00  105.00   94.80    3.22
innodb  create+drop                          32.00       +1.99%       0.65    
31.00   34.00   32.65    0.85
innodb  create_index                          4.00      -21.21%      -0.70     
2.00    4.00    3.30    0.56
innodb  create_key+drop                      33.00       -5.77%      -1.80    
29.00   33.00   31.20    1.21
innodb  create_MANY_tables                   22.00       -5.01%      -1.05    
20.00   23.00   20.95    0.86
innodb  create_table                          0.00     +100.00%       0.10     
0.00    1.00    0.10    0.30
innodb  delete_all_many_keys                714.00       -8.55%     -56.25   
604.00  716.00  657.75   32.19
innodb  delete_autocommit                     3.00      +16.67%       0.60     
3.00    5.00    3.60    0.66
innodb  delete_big                            1.00      -81.82%      -0.45     
0.00    1.00    0.55    0.50
innodb  delete_big_many_keys                713.00       -8.53%     -56.05   
603.00  715.00  656.95   32.09
innodb  delete_commit                         2.00       -5.26%      -0.10     
1.00    2.00    1.90    0.30
innodb  delete_key                            2.00      +29.82%       0.85     
2.00    3.00    2.85    0.36
innodb  delete_range                         10.00      -11.73%      -1.05     
8.00   10.00    8.95    0.67
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          19.00       -4.68%      -0.85    
16.00   21.00   18.15    1.39
innodb  insert                              114.00       -0.09%      -0.10   
112.00  117.00  113.90    1.22
innodb  insert_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  insert_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  insert_duplicates                    19.00       +0.26%       0.05    
19.00   20.00   19.05    0.22
innodb  insert_key                          297.00       -4.97%     -14.05   
265.00  304.00  282.95   11.23
innodb  insert_many_fields                    6.00       -3.45%      -0.20     
5.00    7.00    5.80    0.60
innodb  insert_rollback                       2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  insert_select_1_key                   4.00       -6.67%      -0.25     
3.00    5.00    3.75    0.54
innodb  insert_select_2_keys                  6.00       -0.84%      -0.05     
5.00    7.00    5.95    0.50
innodb  min_max                               7.00      +10.83%       0.85     
6.00    9.00    7.85    1.01
innodb  min_max_on_key                       25.00       -1.01%      -0.25    
24.00   26.00   24.75    0.62
innodb  multiple_value_insert                 7.00       -6.87%      -0.45     
5.00    8.00    6.55    0.74
innodb  once_prepared_select                 29.00       +0.68%       0.20    
29.00   30.00   29.20    0.40
innodb  order_by_big                         13.00      +10.34%       1.50    
13.00   16.00   14.50    1.32
innodb  order_by_big_key                     15.00       -1.35%      -0.20    
12.00   16.00   14.80    1.29
innodb  order_by_big_key2                    13.00       +1.52%       0.20    
11.00   15.00   13.20    0.98
innodb  order_by_big_key_desc                16.00       -5.61%      -0.85    
13.00   17.00   15.15    1.11
innodb  order_by_big_key_diff                12.00       +7.69%       1.00    
11.00   15.00   13.00    1.00
innodb  order_by_big_key_prefix              12.00       +8.40%       1.10    
12.00   15.00   13.10    0.77
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      -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                           24.00       -6.19%      -1.40    
17.00   26.00   22.60    2.37
innodb  outer_join_found                     23.00       -5.99%      -1.30    
17.00   25.00   21.70    2.33
innodb  outer_join_not_found                 20.00       -1.78%      -0.35    
15.00   22.00   19.65    1.85
innodb  outer_join_on_key                    16.00       -5.26%      -0.80    
12.00   17.00   15.20    1.57
innodb  prepared_select                      38.00       -1.47%      -0.55    
37.00   38.00   37.45    0.50
innodb  select_1_row                          3.00      +14.29%       0.50     
3.00    4.00    3.50    0.50
innodb  select_1_row_cache                    4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
innodb  select_2_rows                         3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_big                           14.00       -7.69%      -1.00    
11.00   14.00   13.00    0.89
innodb  select_big_str                        2.00      -37.93%      -0.55     
1.00    2.00    1.45    0.50
innodb  select_cache                         60.00       +5.36%       3.40    
57.00   70.00   63.40    4.15
innodb  select_cache2                        61.00       +1.69%       1.05    
56.00   69.00   62.05    3.04
innodb  select_column+column                  4.00       -8.11%      -0.30     
3.00    4.00    3.70    0.46
innodb  select_diff_key                       1.00     -233.33%      -0.70     
0.00    1.00    0.30    0.46
innodb  select_distinct                       4.00      +10.11%       0.45     
4.00    5.00    4.45    0.50
innodb  select_group                         18.00       -2.86%      -0.50    
15.00   19.00   17.50    1.16
innodb  select_group_when_MANY_tables        14.00      -14.75%      -1.80    
11.00   14.00   12.20    0.93
innodb  select_join                           1.00      -53.85%      -0.35     
0.00    1.00    0.65    0.48
innodb  select_key                           65.00       -1.64%      -1.05    
63.00   66.00   63.95    0.80
innodb  select_key2                          71.00       -0.00%       0.00    
69.00   73.00   71.00    1.22
innodb  select_key2_return_key               69.00       -0.80%      -0.55    
67.00   71.00   68.45    1.12
innodb  select_key2_return_prim              70.00       -1.30%      -0.90    
68.00   71.00   69.10    1.04
innodb  select_key_prefix                    71.00       -0.42%      -0.30    
69.00   73.00   70.70    1.05
innodb  select_key_prefix_join                5.00       +1.96%       0.10     
5.00    6.00    5.10    0.30
innodb  select_key_return_key                64.00       -1.75%      -1.10    
62.00   65.00   62.90    0.83
innodb  select_many_fields                   13.00       +1.52%       0.20    
12.00   15.00   13.20    0.60
innodb  select_range                         39.00       +5.68%       2.35    
38.00   47.00   41.35    2.50
innodb  select_range_key2                    10.00       -6.95%      -0.65     
8.00   10.00    9.35    0.57
innodb  select_range_prefix                   8.00      +14.89%       1.40     
8.00   10.00    9.40    0.66
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                    1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  update_autocommit                     4.00       -6.67%      -0.25     
3.00    4.00    3.75    0.43
innodb  update_big                           61.00       -2.95%      -1.75    
57.00   63.00   59.25    1.87
innodb  update_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  update_of_key                        23.00       -2.91%      -0.65    
21.00   24.00   22.35    0.85
innodb  update_of_key_big                    38.00       -7.80%      -2.75    
29.00   46.00   35.25    3.86
innodb  update_of_primary_key_many_keys    1455.00       -7.10%     -96.50  
1242.00 1489.00 1358.50   68.92
innodb  update_rollback                       2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  update_with_key                     125.00       -2.12%      -2.60   
117.00  128.00  122.40    2.54
innodb  update_with_key_prefix               44.00       +2.00%       0.90    
40.00   49.00   44.90    2.41
innodb  wisc_benchmark                        2.00      +20.00%       0.50     
2.00    3.00    2.50    0.50

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00      -58.21%     -12.14    
11.00   61.00   20.86   10.07
innodb  alter_table_drop                     26.00      -42.07%      -7.70    
10.00   57.00   18.30    6.98
innodb  connect                               2.00       +3.86%       0.08     
1.00    3.00    2.08    0.42
innodb  connect+select_1_row                  3.00      -11.25%      -0.30     
2.00    5.00    2.70    0.47
innodb  connect+select_simple                 3.00      -28.27%      -0.66     
1.00    3.00    2.34    0.48
innodb  count                                13.00      +17.46%       2.75    
12.00  193.00   15.75    8.89
innodb  count_distinct                        7.00       -6.68%      -0.44     
5.00   50.00    6.56    2.29
innodb  count_distinct_2                     14.00       -6.29%      -0.83    
11.00   63.00   13.17    2.97
innodb  count_distinct_big                   21.00       +4.20%       0.92     
5.00   67.00   21.92    3.03
innodb  count_distinct_group                 15.00      -14.25%      -1.87    
10.00   68.00   13.13    3.11
innodb  count_distinct_group_on_key           8.00      +15.66%       1.49     
7.00   69.00    9.49    3.04
innodb  count_distinct_group_on_key_parts    13.00       -5.64%      -0.69     
9.00   72.00   12.31    3.17
innodb  count_distinct_key_prefix             5.00       +2.44%       0.13     
3.00   52.00    5.13    2.40
innodb  count_group_on_key_parts             10.00       -0.36%      -0.04     
7.00   72.00    9.96    3.17
innodb  count_on_key                         92.00       -7.14%      -6.13    
68.00  107.00   85.87    7.37
innodb  create+drop                          32.00       +1.29%       0.42    
18.00   75.00   32.42   11.98
innodb  create_index                          4.00      -38.80%      -1.12     
1.00    8.00    2.88    1.15
innodb  create_key+drop                      33.00      -17.26%      -4.86    
21.00   50.00   28.14    4.93
innodb  create_MANY_tables                   22.00      +35.83%      12.28    
14.00  121.00   34.28   17.15
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.36
innodb  delete_all_many_keys                714.00      -54.85%    -252.92   
212.00 1888.00  461.08  367.07
innodb  delete_autocommit                     3.00      +12.75%       0.44     
2.00   14.00    3.44    0.75
innodb  delete_big                            1.00     -248.15%      -0.71     
0.00    3.00    0.29    0.47
innodb  delete_big_many_keys                713.00      -52.57%    -245.67   
212.00 2293.00  467.33  381.47
innodb  delete_commit                         2.00      -32.71%      -0.49     
1.00    5.00    1.51    0.53
innodb  delete_key                            2.00      +34.72%       1.06     
2.00   35.00    3.06    1.51
innodb  delete_range                         10.00      -20.51%      -1.70     
5.00   23.00    8.30    3.26
innodb  delete_rollback                       2.00      -15.57%      -0.27     
1.00   12.00    1.73    0.92
innodb  drop_index                            3.00       -1.72%      -0.05     
1.00    9.00    2.95    1.33
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.23
innodb  drop_table_when_MANY_tables          19.00       +3.01%       0.59    
11.00   90.00   19.59    7.59
innodb  insert                              114.00       -6.96%      -7.42     
3.00  343.00  106.58   14.69
innodb  insert_autocommit                     3.00       -0.04%       0.00     
2.00   99.00    3.00    3.34
innodb  insert_commit                         2.00      -46.11%      -0.63     
1.00    3.00    1.37    0.49
innodb  insert_duplicates                    19.00      -23.41%      -3.60    
11.00   21.00   15.40    2.63
innodb  insert_key                          297.00       +2.18%       6.62   
142.00  700.00  303.62  108.00
innodb  insert_many_fields                    6.00       -7.15%      -0.40     
3.00   17.00    5.60    1.79
innodb  insert_rollback                       2.00      -20.68%      -0.34     
1.00    3.00    1.66    0.53
innodb  insert_select_1_key                   4.00       -5.82%      -0.22     
2.00   10.00    3.78    0.89
innodb  insert_select_2_keys                  6.00       +1.09%       0.07     
4.00   16.00    6.07    2.11
innodb  min_max                               7.00      +10.51%       0.82     
6.00  110.00    7.82    4.58
innodb  min_max_on_key                       25.00      -22.13%      -4.53    
14.00   37.00   20.47    3.06
innodb  multiple_value_insert                 7.00      -28.67%      -1.56     
2.00   50.00    5.44    4.32
innodb  once_prepared_select                 29.00      -20.25%      -4.88    
18.00   32.00   24.12    3.54
innodb  order_by_big                         13.00       +9.12%       1.30    
12.00   31.00   14.30    1.54
innodb  order_by_big_key                     15.00      -13.10%      -1.74    
11.00   32.00   13.26    1.64
innodb  order_by_big_key2                    13.00       -6.72%      -0.82    
10.00   33.00   12.18    1.55
innodb  order_by_big_key_desc                16.00      -18.75%      -2.53    
11.00   32.00   13.47    1.68
innodb  order_by_big_key_diff                12.00       +1.73%       0.21    
10.00   31.00   12.21    1.51
innodb  order_by_big_key_prefix              12.00       +3.09%       0.38    
10.00   32.00   12.38    1.57
innodb  order_by_key2_diff                    1.00      +28.45%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -26.88%      -0.21     
0.00    2.00    0.79    0.41
innodb  order_by_range                        1.00      -20.37%      -0.17     
0.00    2.00    0.83    0.38
innodb  outer_join                           24.00      -24.30%      -4.69    
15.00   61.00   19.31    3.73
innodb  outer_join_found                     23.00      -22.77%      -4.27    
14.00   58.00   18.73    3.59
innodb  outer_join_not_found                 20.00      -21.78%      -3.58    
12.00   46.00   16.42    3.18
innodb  outer_join_on_key                    16.00      -24.17%      -3.11    
10.00   59.00   12.89    2.79
innodb  prepared_select                      38.00      -21.76%      -6.79    
22.00   40.00   31.21    4.47
innodb  select_1_row                          3.00       -5.57%      -0.16     
2.00    4.00    2.84    0.69
innodb  select_1_row_cache                    4.00      -50.31%      -1.34     
2.00    4.00    2.66    0.67
innodb  select_2_rows                         3.00       -4.78%      -0.14     
2.00    4.00    2.86    0.70
innodb  select_big                           14.00      -15.21%      -1.85     
0.00   31.00   12.15    1.55
innodb  select_big_str                        2.00      -72.57%      -0.84     
0.00    2.00    1.16    0.37
innodb  select_cache                         60.00       -0.75%      -0.45    
49.00   77.00   59.55    5.63
innodb  select_cache2                        61.00       -1.79%      -1.07    
49.00   75.00   59.93    6.31
innodb  select_column+column                  4.00      -37.50%      -1.09     
2.00    4.00    2.91    0.71
innodb  select_diff_key                       1.00     -356.76%      -0.78     
0.00    1.00    0.22    0.41
innodb  select_distinct                       4.00       +5.47%       0.23     
3.00    8.00    4.23    0.54
innodb  select_group                         18.00      -10.63%      -1.73     
4.00  136.00   16.27    5.48
innodb  select_group_when_MANY_tables        14.00      -48.67%      -4.58     
3.00   49.00    9.42    9.53
innodb  select_join                           1.00      -72.51%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           65.00      -23.73%     -12.47    
40.00   66.00   52.53    7.35
innodb  select_key2                          71.00      -19.90%     -11.78    
45.00   75.00   59.22    8.21
innodb  select_key2_return_key               69.00      -22.03%     -12.46    
42.00   71.00   56.54    8.00
innodb  select_key2_return_prim              70.00      -22.17%     -12.70    
42.00   72.00   57.30    8.15
innodb  select_key_prefix                    71.00      -21.44%     -12.54    
44.00   75.00   58.46    8.23
innodb  select_key_prefix_join                5.00       -6.09%      -0.29     
3.00   10.00    4.71    0.65
innodb  select_key_return_key                64.00      -24.12%     -12.44    
38.00   65.00   51.56    7.36
innodb  select_many_fields                   13.00      +13.20%       1.98    
11.00   19.00   14.98    1.79
innodb  select_range                         39.00      +17.26%       8.13    
38.00   76.00   47.13    3.98
innodb  select_range_key2                    10.00      -21.48%      -1.77     
6.00   11.00    8.23    1.03
innodb  select_range_prefix                   8.00       -2.41%      -0.19     
5.00   10.00    7.81    1.10
innodb  select_simple                         2.00      -21.96%      -0.36     
1.00    3.00    1.64    0.51
innodb  select_simple_cache                   2.00      -29.41%      -0.45     
1.00    3.00    1.55    0.51
innodb  select_simple_join                    1.00      -53.44%      -0.35     
0.00    3.00    0.65    0.48
innodb  update_autocommit                     4.00      -20.30%      -0.67     
2.00   16.00    3.33    1.02
innodb  update_big                           61.00      -19.99%     -10.16    
31.00  195.00   50.84   24.67
innodb  update_commit                         2.00      -28.67%      -0.45     
1.00   10.00    1.55    0.73
innodb  update_of_key                        23.00       +5.21%       1.27    
18.00  100.00   24.27    6.22
innodb  update_of_key_big                    38.00      -39.31%     -10.72    
15.00   75.00   27.28   10.98
innodb  update_of_primary_key_many_keys    1455.00      -17.50%    -216.71   
647.00 6065.00 1238.29  970.60
innodb  update_rollback                       2.00      -14.02%      -0.25     
1.00   31.00    1.75    1.92
innodb  update_with_key                     125.00      -14.00%     -15.35    
90.00  598.00  109.65   20.93
innodb  update_with_key_prefix               44.00      -11.29%      -4.46    
33.00  202.00   39.54    6.85
innodb  wisc_benchmark                        2.00      +19.12%       0.47     
2.00    5.00    2.47    0.53

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

  2187.6.1: patrick crews 2011-02-21 Removed redundant use of ports - shows 
about 30 seconds improved runtime

_______________________________________________
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