=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   1095
RUN DATE: 2012-03-04T02:31:45.527713
SERVER:   drizzled
VERSION:  staging
REVISION: 2517
COMMENT:  2517: Continuous Integr... 2012-03-03 [merge] Merge build tree to 
staging tree.

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      34.00       -8.97%      -2.80    
26.00   34.00   31.20    2.79
innodb  alter_table_drop                     25.00       -0.00%       0.00    
24.00   26.00   25.00    0.63
innodb  connect                               2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  count                                14.00      +13.58%       2.20    
14.00   18.00   16.20    1.83
innodb  count_distinct                        6.00       +6.25%       0.40     
6.00    8.00    6.40    0.80
innodb  count_distinct_2                     12.00      +11.76%       1.60    
12.00   16.00   13.60    1.62
innodb  count_distinct_big                   21.00       +7.89%       1.80    
20.00   25.00   22.80    1.94
innodb  count_distinct_group                 15.00       -4.17%      -0.60    
14.00   15.00   14.40    0.49
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    15.00      -17.19%      -2.20    
11.00   15.00   12.80    1.83
innodb  count_distinct_key_prefix             5.00       -4.17%      -0.20     
4.00    5.00    4.80    0.40
innodb  count_group_on_key_parts             11.00       -0.00%       0.00    
11.00   11.00   11.00    0.00
innodb  count_on_key                         94.00       +0.42%       0.40    
91.00   97.00   94.40    1.96
innodb  create+drop                          34.00       -3.03%      -1.00    
32.00   34.00   33.00    0.89
innodb  create_index                          3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  create_key+drop                      31.00       -0.65%      -0.20    
30.00   32.00   30.80    0.75
innodb  create_MANY_tables                   20.00       +3.85%       0.80    
20.00   21.00   20.80    0.40
innodb  delete_all_many_keys                752.00       +9.07%      75.00   
716.00 1078.00  827.00  135.00
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                752.00       +9.00%      74.40   
715.00 1077.00  826.40  134.75
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          7.00       +5.41%       0.40     
7.00    8.00    7.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   20.00   19.60    0.49
innodb  insert                              117.00       -1.39%      -1.60   
113.00  117.00  115.40    1.50
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                    20.00       -0.00%       0.00    
20.00   20.00   20.00    0.00
innodb  insert_key                          276.00       +0.79%       2.20   
272.00  290.00  278.20    6.34
innodb  insert_many_fields                    6.00       +3.23%       0.20     
6.00    7.00    6.20    0.40
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   5.00       -0.00%       0.00     
5.00    5.00    5.00    0.00
innodb  insert_select_2_keys                  6.00      +11.76%       0.80     
6.00    8.00    6.80    0.75
innodb  min_max                               7.00      +14.63%       1.20     
7.00    9.00    8.20    0.98
innodb  min_max_on_key                       25.00       -1.63%      -0.40    
24.00   26.00   24.60    0.80
innodb  multiple_value_insert                 5.00      +13.79%       0.80     
5.00    6.00    5.80    0.40
innodb  once_prepared_select                 30.00       -1.35%      -0.40    
29.00   30.00   29.60    0.49
innodb  order_by_big                         14.00       -9.38%      -1.20    
12.00   14.00   12.80    0.75
innodb  order_by_big_key                     15.00       -4.17%      -0.60    
12.00   15.00   14.40    1.20
innodb  order_by_big_key2                    13.00       -6.56%      -0.80    
11.00   13.00   12.20    0.98
innodb  order_by_big_key_desc                15.00       -1.35%      -0.20    
14.00   15.00   14.80    0.40
innodb  order_by_big_key_diff                13.00       -6.56%      -0.80    
11.00   13.00   12.20    0.75
innodb  order_by_big_key_prefix              13.00       -1.56%      -0.20    
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       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  order_by_range                        1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  outer_join                           18.00      +16.67%       3.60    
18.00   23.00   21.60    1.85
innodb  outer_join_found                     16.00      +22.33%       4.60    
16.00   22.00   20.60    2.33
innodb  outer_join_not_found                 16.00      +10.11%       1.80    
16.00   19.00   17.80    0.98
innodb  outer_join_on_key                    11.00      +20.29%       2.80    
11.00   15.00   13.80    1.47
innodb  prepared_select                      37.00       +1.60%       0.60    
37.00   38.00   37.60    0.49
innodb  select_1_row                          4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_1_row_cache                    3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  select_2_rows                         4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_big                           13.00       -3.17%      -0.40    
10.00   14.00   12.60    1.36
innodb  select_big_str                        1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  select_cache                         64.00       +1.54%       1.00    
63.00   67.00   65.00    1.41
innodb  select_cache2                        65.00       +1.22%       0.80    
64.00   68.00   65.80    1.47
innodb  select_column+column                  4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_diff_key                       1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_distinct                       4.00       +9.09%       0.40     
4.00    5.00    4.40    0.49
innodb  select_group                         19.00      -10.47%      -1.80    
15.00   19.00   17.20    1.60
innodb  select_group_when_MANY_tables        12.00       -0.00%       0.00    
11.00   14.00   12.00    1.10
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           65.00       -0.62%      -0.40    
64.00   65.00   64.60    0.49
innodb  select_key2                          72.00       -0.56%      -0.40    
71.00   72.00   71.60    0.49
innodb  select_key2_return_key               69.00       -0.58%      -0.40    
68.00   69.00   68.60    0.49
innodb  select_key2_return_prim              70.00       -0.00%       0.00    
69.00   71.00   70.00    0.63
innodb  select_key_prefix                    71.00       -0.00%       0.00    
70.00   72.00   71.00    0.63
innodb  select_key_prefix_join                5.00       -8.70%      -0.40     
4.00    5.00    4.60    0.49
innodb  select_key_return_key                63.00       +0.63%       0.40    
63.00   64.00   63.40    0.49
innodb  select_many_fields                   13.00       -0.00%       0.00    
13.00   13.00   13.00    0.00
innodb  select_range                         41.00       +8.89%       4.00    
41.00   48.00   45.00    2.45
innodb  select_range_key2                    10.00       -2.04%      -0.20     
9.00   10.00    9.80    0.40
innodb  select_range_prefix                   8.00       +4.76%       0.40     
8.00   10.00    8.40    0.80
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                    1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  update_autocommit                     4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  update_big                           59.00       -2.08%      -1.20    
56.00   61.00   57.80    1.94
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        24.00       -2.56%      -0.60    
22.00   24.00   23.40    0.80
innodb  update_of_key_big                    18.00       +2.17%       0.40    
18.00   19.00   18.40    0.49
innodb  update_of_primary_key_many_keys    1285.00       -1.98%     -25.00  
1232.00 1301.00 1260.00   27.61
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     117.00       +2.82%       3.40   
117.00  124.00  120.40    2.42
innodb  update_with_key_prefix               45.00       -6.13%      -2.60    
41.00   45.00   42.40    1.50
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                      34.00       -6.42%      -2.05    
26.00   34.00   31.95    1.66
innodb  alter_table_drop                     25.00       -0.40%      -0.10    
23.00   26.00   24.90    0.77
innodb  connect                               2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
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      -11.11%      -0.30     
2.00    3.00    2.70    0.46
innodb  count                                14.00      +11.39%       1.80    
13.00   18.00   15.80    1.94
innodb  count_distinct                        6.00      +11.76%       0.80     
6.00    8.00    6.80    0.81
innodb  count_distinct_2                     12.00      +10.45%       1.40    
12.00   17.00   13.40    1.53
innodb  count_distinct_big                   21.00       +8.10%       1.85    
20.00   25.00   22.85    2.03
innodb  count_distinct_group                 15.00       -4.17%      -0.60    
11.00   16.00   14.40    1.16
innodb  count_distinct_group_on_key           9.00       +7.22%       0.70     
8.00   12.00    9.70    1.10
innodb  count_distinct_group_on_key_parts    15.00      -10.29%      -1.40    
11.00   15.00   13.60    1.50
innodb  count_distinct_key_prefix             5.00       -1.01%      -0.05     
4.00    6.00    4.95    0.59
innodb  count_group_on_key_parts             11.00       +1.35%       0.15    
10.00   12.00   11.15    0.48
innodb  count_on_key                         94.00       +1.05%       1.00    
90.00   99.00   95.00    2.35
innodb  create+drop                          34.00       -1.64%      -0.55    
32.00   35.00   33.45    0.80
innodb  create_index                          3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  create_key+drop                      31.00       +1.43%       0.45    
30.00   35.00   31.45    1.36
innodb  create_MANY_tables                   20.00       +5.44%       1.15    
20.00   24.00   21.15    0.91
innodb  delete_all_many_keys                752.00      +14.19%     124.40   
691.00 1123.00  876.40  119.80
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.35     
0.00    1.00    0.35    0.48
innodb  delete_big_many_keys                752.00      +14.13%     123.75   
691.00 1122.00  875.75  119.61
innodb  delete_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          7.00       +7.89%       0.60     
7.00    8.00    7.60    0.49
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            3.00       +1.64%       0.05     
3.00    4.00    3.05    0.22
innodb  drop_table_when_MANY_tables          19.00       +1.04%       0.20    
18.00   21.00   19.20    0.81
innodb  insert                              117.00       -2.54%      -2.90   
112.00  117.00  114.10    1.58
innodb  insert_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  insert_commit                         2.00      -14.29%      -0.25     
1.00    2.00    1.75    0.43
innodb  insert_duplicates                    20.00       -0.76%      -0.15    
19.00   21.00   19.85    0.48
innodb  insert_key                          276.00       +1.04%       2.90   
265.00  290.00  278.90    5.34
innodb  insert_many_fields                    6.00       -4.35%      -0.25     
5.00    7.00    5.75    0.54
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   5.00       +2.91%       0.15     
4.00    6.00    5.15    0.48
innodb  insert_select_2_keys                  6.00       +8.40%       0.55     
6.00    8.00    6.55    0.59
innodb  min_max                               7.00      +12.50%       1.00     
6.00   10.00    8.00    1.10
innodb  min_max_on_key                       25.00       -0.20%      -0.05    
24.00   27.00   24.95    0.74
innodb  multiple_value_insert                 5.00      +13.04%       0.75     
5.00    7.00    5.75    0.54
innodb  once_prepared_select                 30.00       -1.69%      -0.50    
29.00   30.00   29.50    0.50
innodb  order_by_big                         14.00       -1.82%      -0.25    
12.00   16.00   13.75    1.18
innodb  order_by_big_key                     15.00       -4.90%      -0.70    
12.00   16.00   14.30    1.14
innodb  order_by_big_key2                    13.00       -2.36%      -0.30    
11.00   14.00   12.70    1.00
innodb  order_by_big_key_desc                15.00       -1.35%      -0.20    
13.00   16.00   14.80    0.81
innodb  order_by_big_key_diff                13.00       -5.26%      -0.65    
11.00   14.00   12.35    0.85
innodb  order_by_big_key_prefix              13.00       +1.14%       0.15    
12.00   15.00   13.15    0.73
innodb  order_by_key2_diff                    1.00      +31.03%       0.45     
1.00    2.00    1.45    0.50
innodb  order_by_key_prefix                   1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  order_by_range                        1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  outer_join                           18.00      +16.08%       3.45    
17.00   24.00   21.45    2.38
innodb  outer_join_found                     16.00      +21.76%       4.45    
16.00   23.00   20.45    2.33
innodb  outer_join_not_found                 16.00      +12.09%       2.20    
15.00   21.00   18.20    1.81
innodb  outer_join_on_key                    11.00      +19.12%       2.60    
11.00   15.00   13.60    1.56
innodb  prepared_select                      37.00       +1.07%       0.40    
36.00   38.00   37.40    0.58
innodb  select_1_row                          4.00       -8.11%      -0.30     
3.00    4.00    3.70    0.46
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       -2.56%      -0.10     
3.00    4.00    3.90    0.30
innodb  select_big                           13.00       -4.42%      -0.55    
10.00   14.00   12.45    1.24
innodb  select_big_str                        1.00      +25.93%       0.35     
1.00    2.00    1.35    0.48
innodb  select_cache                         64.00       -0.79%      -0.50    
57.00   79.00   63.50    4.27
innodb  select_cache2                        65.00       +2.91%       1.95    
62.00   88.00   66.95    5.49
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_diff_key                       1.00     -122.22%      -0.55     
0.00    1.00    0.45    0.50
innodb  select_distinct                       4.00      +11.11%       0.50     
4.00    5.00    4.50    0.50
innodb  select_group                         19.00       -7.34%      -1.30    
15.00   20.00   17.70    1.62
innodb  select_group_when_MANY_tables        12.00       -0.00%       0.00    
11.00   14.00   12.00    0.77
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           65.00       -0.31%      -0.20    
64.00   66.00   64.80    0.60
innodb  select_key2                          72.00       -0.28%      -0.20    
71.00   73.00   71.80    0.68
innodb  select_key2_return_key               69.00       +0.22%       0.15    
68.00   71.00   69.15    0.73
innodb  select_key2_return_prim              70.00       +0.21%       0.15    
69.00   71.00   70.15    0.65
innodb  select_key_prefix                    71.00       +0.35%       0.25    
70.00   73.00   71.25    0.77
innodb  select_key_prefix_join                5.00       -5.26%      -0.25     
4.00    5.00    4.75    0.43
innodb  select_key_return_key                63.00       +1.33%       0.85    
63.00   65.00   63.85    0.65
innodb  select_many_fields                   13.00       -0.00%       0.00    
12.00   14.00   13.00    0.32
innodb  select_range                         41.00       +5.09%       2.20    
40.00   48.00   43.20    2.42
innodb  select_range_key2                    10.00       -2.56%      -0.25     
9.00   11.00    9.75    0.54
innodb  select_range_prefix                   8.00       +9.60%       0.85     
8.00   10.00    8.85    0.79
innodb  select_simple                         2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_cache                   2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  select_simple_join                    1.00      -42.86%      -0.30     
0.00    1.00    0.70    0.46
innodb  update_autocommit                     4.00      -15.94%      -0.55     
3.00    4.00    3.45    0.50
innodb  update_big                           59.00       -2.52%      -1.45    
56.00   61.00   57.55    1.50
innodb  update_commit                         2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  update_of_key                        24.00       -6.19%      -1.40    
21.00   24.00   22.60    0.92
innodb  update_of_key_big                    18.00       +4.76%       0.90    
18.00   20.00   18.90    0.77
innodb  update_of_primary_key_many_keys    1285.00       -0.71%      -9.00  
1173.00 1351.00 1276.00   44.57
innodb  update_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  update_with_key                     117.00       +2.38%       2.85   
117.00  124.00  119.85    1.74
innodb  update_with_key_prefix               45.00       -4.29%      -1.85    
41.00   45.00   43.15    1.28
innodb  wisc_benchmark                        3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      34.00      -49.38%     -11.24    
11.00   61.00   22.76   10.11
innodb  alter_table_drop                     25.00      -29.56%      -5.70    
10.00   57.00   19.30    6.74
innodb  connect                               2.00       +4.85%       0.10     
1.00    3.00    2.10    0.42
innodb  connect+select_1_row                  3.00       -9.59%      -0.26     
2.00    5.00    2.74    0.45
innodb  connect+select_simple                 3.00      -25.64%      -0.61     
1.00    3.00    2.39    0.49
innodb  count                                14.00      +11.25%       1.77    
12.00  193.00   15.77    8.14
innodb  count_distinct                        6.00       +9.36%       0.62     
5.00   50.00    6.62    2.11
innodb  count_distinct_2                     12.00       +9.59%       1.27    
11.00   63.00   13.27    2.77
innodb  count_distinct_big                   21.00       +4.94%       1.09     
5.00   67.00   22.09    2.90
innodb  count_distinct_group                 15.00      -12.33%      -1.65    
10.00   68.00   13.35    2.91
innodb  count_distinct_group_on_key           9.00       +5.72%       0.55     
7.00   69.00    9.55    2.81
innodb  count_distinct_group_on_key_parts    15.00      -20.38%      -2.54     
9.00   72.00   12.46    2.96
innodb  count_distinct_key_prefix             5.00       +2.97%       0.15     
3.00   52.00    5.15    2.21
innodb  count_group_on_key_parts             11.00       -8.36%      -0.85     
7.00   72.00   10.15    2.93
innodb  count_on_key                         94.00       -7.57%      -6.61    
68.00  107.00   87.39    7.58
innodb  create+drop                          34.00       -4.44%      -1.45    
18.00   75.00   32.55   10.92
innodb  create_index                          3.00       -2.85%      -0.08     
1.00    8.00    2.92    1.06
innodb  create_key+drop                      31.00       -7.99%      -2.29    
21.00   50.00   28.71    4.69
innodb  create_MANY_tables                   20.00      +37.48%      11.99    
14.00  121.00   31.99   16.42
innodb  create_table                          0.00     +100.00%       0.09     
0.00    3.00    0.09    0.34
innodb  delete_all_many_keys                752.00      -45.66%    -235.72   
212.00 1888.00  516.28  358.88
innodb  delete_autocommit                     3.00      +13.51%       0.47     
2.00   14.00    3.47    0.72
innodb  delete_big                            0.00     +100.00%       0.31     
0.00    3.00    0.31    0.47
innodb  delete_big_many_keys                752.00      -44.30%    -230.87   
212.00 2293.00  521.13  370.25
innodb  delete_commit                         2.00      -27.34%      -0.43     
1.00    5.00    1.57    0.52
innodb  delete_key                            3.00       +0.81%       0.02     
2.00   35.00    3.02    1.38
innodb  delete_range                          7.00      +15.70%       1.30     
5.00   23.00    8.30    2.99
innodb  delete_rollback                       2.00      -11.72%      -0.21     
1.00   12.00    1.79    0.85
innodb  drop_index                            3.00       -1.36%      -0.04     
1.00    9.00    2.96    1.23
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.22
innodb  drop_table_when_MANY_tables          19.00       +2.37%       0.46    
11.00   90.00   19.46    6.93
innodb  insert                              117.00       -8.62%      -9.28     
3.00  343.00  107.72   13.62
innodb  insert_autocommit                     3.00       +0.94%       0.03     
2.00   99.00    3.03    3.05
innodb  insert_commit                         2.00      -38.02%      -0.55     
1.00    3.00    1.45    0.51
innodb  insert_duplicates                    20.00      -24.52%      -3.94    
11.00   21.00   16.06    2.81
innodb  insert_key                          276.00       +7.81%      23.39   
142.00  700.00  299.39   97.99
innodb  insert_many_fields                    6.00       -6.54%      -0.37     
3.00   17.00    5.63    1.64
innodb  insert_rollback                       2.00      -16.24%      -0.28     
1.00    3.00    1.72    0.51
innodb  insert_select_1_key                   5.00      -28.05%      -1.10     
2.00   10.00    3.90    0.92
innodb  insert_select_2_keys                  6.00       +1.75%       0.11     
4.00   16.00    6.11    1.94
innodb  min_max                               7.00      +10.86%       0.85     
6.00  110.00    7.85    4.20
innodb  min_max_on_key                       25.00      -18.03%      -3.82    
14.00   37.00   21.18    3.21
innodb  multiple_value_insert                 5.00       +9.78%       0.54     
2.00   50.00    5.54    3.95
innodb  once_prepared_select                 30.00      -20.18%      -5.04    
18.00   32.00   24.96    3.73
innodb  order_by_big                         14.00       +1.93%       0.28    
12.00   31.00   14.28    1.47
innodb  order_by_big_key                     15.00      -11.67%      -1.57    
11.00   32.00   13.43    1.63
innodb  order_by_big_key2                    13.00       -5.70%      -0.70    
10.00   33.00   12.30    1.48
innodb  order_by_big_key_desc                15.00       -9.26%      -1.27    
11.00   32.00   13.73    1.69
innodb  order_by_big_key_diff                13.00       -5.44%      -0.67    
10.00   31.00   12.33    1.44
innodb  order_by_big_key_prefix              13.00       -3.96%      -0.50    
10.00   32.00   12.50    1.49
innodb  order_by_key2_diff                    1.00      +28.54%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -23.97%      -0.19     
0.00    2.00    0.81    0.40
innodb  order_by_range                        1.00      -18.63%      -0.16     
0.00    2.00    0.84    0.37
innodb  outer_join                           18.00       +8.90%       1.76    
15.00   61.00   19.76    3.69
innodb  outer_join_found                     16.00      +16.29%       3.11    
14.00   58.00   19.11    3.52
innodb  outer_join_not_found                 16.00       +5.12%       0.86    
12.00   46.00   16.86    3.19
innodb  outer_join_on_key                    11.00      +16.12%       2.11    
10.00   59.00   13.11    2.68
innodb  prepared_select                      37.00      -14.91%      -4.80    
22.00   40.00   32.20    4.63
innodb  select_1_row                          4.00      -34.87%      -1.03     
2.00    4.00    2.97    0.72
innodb  select_1_row_cache                    3.00       -6.91%      -0.19     
2.00    4.00    2.81    0.72
innodb  select_2_rows                         4.00      -33.29%      -1.00     
2.00    4.00    3.00    0.73
innodb  select_big                           13.00       -6.20%      -0.76     
0.00   31.00   12.24    1.50
innodb  select_big_str                        1.00      +16.36%       0.20     
0.00    2.00    1.20    0.40
innodb  select_cache                         64.00       -6.06%      -3.66    
49.00   79.00   60.34    5.65
innodb  select_cache2                        65.00       -6.83%      -4.16    
49.00   88.00   60.84    6.35
innodb  select_column+column                  4.00      -30.77%      -0.94     
2.00    4.00    3.06    0.75
innodb  select_diff_key                       1.00     -341.13%      -0.77     
0.00    1.00    0.23    0.42
innodb  select_distinct                       4.00       +6.80%       0.29     
3.00    8.00    4.29    0.55
innodb  select_group                         19.00      -16.00%      -2.62     
4.00  136.00   16.38    5.03
innodb  select_group_when_MANY_tables        12.00      -21.85%      -2.15     
3.00   49.00    9.85    8.74
innodb  select_join                           1.00      -67.93%      -0.40     
0.00    1.00    0.60    0.49
innodb  select_key                           65.00      -19.27%     -10.50    
40.00   67.00   54.50    7.98
innodb  select_key2                          72.00      -17.63%     -10.79    
45.00   75.00   61.21    8.68
innodb  select_key2_return_key               69.00      -17.83%     -10.44    
42.00   71.00   58.56    8.54
innodb  select_key2_return_prim              70.00      -17.99%     -10.67    
42.00   72.00   59.33    8.67
innodb  select_key_prefix                    71.00      -17.32%     -10.48    
44.00   75.00   60.52    8.76
innodb  select_key_prefix_join                5.00       -4.20%      -0.20     
3.00   10.00    4.80    0.66
innodb  select_key_return_key                63.00      -17.74%      -9.49    
38.00   66.00   53.51    7.96
innodb  select_many_fields                   13.00      +11.45%       1.68    
11.00   19.00   14.68    1.77
innodb  select_range                         41.00      +11.91%       5.54    
38.00   76.00   46.54    4.06
innodb  select_range_key2                    10.00      -18.16%      -1.54     
6.00   11.00    8.46    1.09
innodb  select_range_prefix                   8.00       +0.57%       0.05     
5.00   10.00    8.05    1.16
innodb  select_simple                         2.00      -16.89%      -0.29     
1.00    3.00    1.71    0.50
innodb  select_simple_cache                   2.00      -22.64%      -0.37     
1.00    3.00    1.63    0.51
innodb  select_simple_join                    1.00      -49.05%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     4.00      -19.30%      -0.65     
2.00   16.00    3.35    0.95
innodb  update_big                           59.00      -13.14%      -6.85    
31.00  195.00   52.15   22.66
innodb  update_commit                         2.00      -23.04%      -0.37     
1.00   10.00    1.63    0.69
innodb  update_of_key                        24.00       -0.30%      -0.07    
18.00  100.00   23.93    5.73
innodb  update_of_key_big                    18.00      +33.73%       9.16    
15.00   75.00   27.16   10.66
innodb  update_of_primary_key_many_keys    1285.00       -2.63%     -32.96   
647.00 6065.00 1252.04  863.21
innodb  update_rollback                       2.00      -10.75%      -0.19     
1.00   31.00    1.81    1.75
innodb  update_with_key                     117.00       -5.00%      -5.58    
90.00  598.00  111.42   19.48
innodb  update_with_key_prefix               45.00      -11.90%      -4.79    
33.00  202.00   40.21    6.46
innodb  wisc_benchmark                        3.00      -20.52%      -0.51     
2.00    5.00    2.49    0.52

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

  2516.1.2: Brian Aker 2012-03-03 Update autorun script.
  2516.1.1: Brian Aker 2012-03-03 [merge] Merge with tree to drop dead plugins.
    2514.4.1: Brian Aker 2012-03-02 Remove dead plugins.

_______________________________________________
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