=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   1000
RUN DATE: 2011-04-12T11:57:08.010760
SERVER:   drizzled
VERSION:  staging
REVISION: 2275
COMMENT:  2275: Brian Aker 2011-04-12 [merge] Merge in Olaf

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       +1.84%       0.60    
31.00   34.00   32.60    1.20
innodb  alter_table_drop                     24.00       -0.84%      -0.20    
22.00   25.00   23.80    0.98
innodb  connect                               3.00      -36.36%      -0.80     
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                 2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  count                                14.00      +17.65%       3.00    
14.00   18.00   17.00    1.55
innodb  count_distinct                        6.00      +11.76%       0.80     
6.00    8.00    6.80    0.75
innodb  count_distinct_2                     13.00       -3.17%      -0.40    
11.00   14.00   12.60    1.02
innodb  count_distinct_big                   21.00      +11.02%       2.60    
21.00   25.00   23.60    1.36
innodb  count_distinct_group                 15.00       -1.35%      -0.20    
14.00   15.00   14.80    0.40
innodb  count_distinct_group_on_key           9.00       +2.17%       0.20     
8.00   10.00    9.20    0.75
innodb  count_distinct_group_on_key_parts    15.00       -8.70%      -1.20    
12.00   15.00   13.80    1.17
innodb  count_distinct_key_prefix             4.00      +23.08%       1.20     
4.00    6.00    5.20    0.75
innodb  count_group_on_key_parts             11.00       -0.00%       0.00    
10.00   12.00   11.00    0.63
innodb  count_on_key                         94.00       +3.09%       3.00    
94.00  103.00   97.00    3.16
innodb  create+drop                          32.00       +1.84%       0.60    
31.00   34.00   32.60    1.20
innodb  create_index                          3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  create_key+drop                      36.00      -13.21%      -4.20    
28.00   36.00   31.80    2.64
innodb  create_MANY_tables                   22.00       -6.80%      -1.40    
20.00   22.00   20.60    0.80
innodb  delete_all_many_keys               1021.00      -17.06%    -148.80   
634.00 1021.00  872.20  148.23
innodb  delete_autocommit                     4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  delete_big_many_keys               1019.00      -16.94%    -147.60   
633.00 1019.00  871.40  148.00
innodb  delete_commit                         1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          9.00       -9.76%      -0.80     
8.00    9.00    8.20    0.40
innodb  delete_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  drop_index                            4.00      -33.33%      -1.00     
2.00    4.00    3.00    0.63
innodb  drop_table_when_MANY_tables          20.00       -7.53%      -1.40    
17.00   20.00   18.60    1.02
innodb  insert                              113.00       -0.53%      -0.60   
112.00  113.00  112.40    0.49
innodb  insert_autocommit                     3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  insert_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_duplicates                    19.00       +3.06%       0.60    
19.00   20.00   19.60    0.49
innodb  insert_key                          307.00      -10.04%     -28.00   
264.00  307.00  279.00   14.63
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                   6.00      -20.00%      -1.00     
4.00    6.00    5.00    0.63
innodb  insert_select_2_keys                  7.00      -12.90%      -0.80     
6.00    7.00    6.20    0.40
innodb  min_max                               7.00      +12.50%       1.00     
6.00    9.00    8.00    1.26
innodb  min_max_on_key                       25.00       -2.46%      -0.60    
24.00   25.00   24.40    0.49
innodb  multiple_value_insert                 6.00       -3.45%      -0.20     
5.00    6.00    5.80    0.40
innodb  once_prepared_select                 29.00       -0.69%      -0.20    
28.00   29.00   28.80    0.40
innodb  order_by_big                         15.00       -4.17%      -0.60    
13.00   15.00   14.40    0.80
innodb  order_by_big_key                     16.00       -3.90%      -0.60    
14.00   16.00   15.40    0.80
innodb  order_by_big_key2                    11.00      +12.70%       1.60    
11.00   14.00   12.60    1.36
innodb  order_by_big_key_desc                14.00       +7.89%       1.20    
14.00   16.00   15.20    0.75
innodb  order_by_big_key_diff                13.00       -0.00%       0.00    
12.00   14.00   13.00    0.63
innodb  order_by_big_key_prefix              12.00       +4.76%       0.60    
12.00   13.00   12.60    0.49
innodb  order_by_key2_diff                    1.00      +37.50%       0.60     
1.00    2.00    1.60    0.49
innodb  order_by_key_prefix                   1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  order_by_range                        1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  outer_join                           23.00       +5.74%       1.40    
23.00   26.00   24.40    1.02
innodb  outer_join_found                     22.00       +4.35%       1.00    
22.00   24.00   23.00    0.89
innodb  outer_join_not_found                 19.00       +6.86%       1.40    
19.00   21.00   20.40    0.80
innodb  outer_join_on_key                    15.00       +6.25%       1.00    
15.00   17.00   16.00    0.89
innodb  prepared_select                      37.00       -1.09%      -0.40    
36.00   37.00   36.60    0.49
innodb  select_1_row                          4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_1_row_cache                    3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  select_2_rows                         3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_big                           13.00       -3.17%      -0.40    
11.00   15.00   12.60    1.36
innodb  select_big_str                        2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  select_cache                         63.00       +3.37%       2.20    
63.00   67.00   65.20    1.60
innodb  select_cache2                        63.00       +1.25%       0.80    
61.00   70.00   63.80    3.19
innodb  select_column+column                  4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_distinct                       5.00      -13.64%      -0.60     
4.00    5.00    4.40    0.49
innodb  select_group                         15.00      +11.76%       2.00    
15.00   19.00   17.00    1.41
innodb  select_group_when_MANY_tables        13.00      -10.17%      -1.20    
11.00   13.00   11.80    0.75
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           63.00       +0.94%       0.60    
63.00   64.00   63.60    0.49
innodb  select_key2                          70.00       -0.00%       0.00    
69.00   71.00   70.00    0.63
innodb  select_key2_return_key               67.00       +0.89%       0.60    
67.00   68.00   67.60    0.49
innodb  select_key2_return_prim              68.00       +0.29%       0.20    
67.00   69.00   68.20    0.75
innodb  select_key_prefix                    71.00       -1.43%      -1.00    
69.00   71.00   70.00    0.63
innodb  select_key_prefix_join                5.00       +3.85%       0.20     
5.00    6.00    5.20    0.40
innodb  select_key_return_key                62.00       +0.64%       0.40    
61.00   64.00   62.40    1.02
innodb  select_many_fields                   13.00       +7.14%       1.00    
13.00   17.00   14.00    1.55
innodb  select_range                         50.00       -9.17%      -4.20    
41.00   50.00   45.80    3.66
innodb  select_range_key2                    10.00       -4.17%      -0.40     
9.00   10.00    9.60    0.49
innodb  select_range_prefix                   9.00       +4.26%       0.40     
9.00   10.00    9.40    0.49
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  select_simple_join                    1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  update_autocommit                     4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  update_big                           61.00       -4.10%      -2.40    
58.00   61.00   58.60    1.20
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        22.00       +0.90%       0.20    
22.00   23.00   22.20    0.40
innodb  update_of_key_big                    20.00       +9.91%       2.20    
18.00   34.00   22.20    5.95
innodb  update_of_primary_key_many_keys    1389.00      -10.38%    -130.60  
1123.00 1389.00 1258.40   85.28
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     121.00       -1.85%      -2.20   
116.00  121.00  118.80    1.72
innodb  update_with_key_prefix               46.00       -5.02%      -2.20    
41.00   46.00   43.80    1.94
innodb  wisc_benchmark                        2.00      +28.57%       0.80     
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       +1.39%       0.45    
30.00   35.00   32.45    1.16
innodb  alter_table_drop                     24.00       -1.05%      -0.25    
22.00   26.00   23.75    1.09
innodb  connect                               3.00      -33.33%      -0.75     
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                                14.00      +11.67%       1.85    
13.00   18.00   15.85    1.88
innodb  count_distinct                        6.00      +12.41%       0.85     
6.00    8.00    6.85    0.73
innodb  count_distinct_2                     13.00       +2.99%       0.40    
11.00   16.00   13.40    1.43
innodb  count_distinct_big                   21.00       +9.68%       2.25    
21.00   25.00   23.25    1.61
innodb  count_distinct_group                 15.00       -4.17%      -0.60    
11.00   16.00   14.40    1.24
innodb  count_distinct_group_on_key           9.00       +5.26%       0.50     
8.00   12.00    9.50    0.97
innodb  count_distinct_group_on_key_parts    15.00      -14.94%      -1.95    
11.00   15.00   13.05    1.40
innodb  count_distinct_key_prefix             4.00      +25.23%       1.35     
4.00    7.00    5.35    0.73
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       +2.13%       2.05    
92.00  103.00   96.05    2.84
innodb  create+drop                          32.00       +3.18%       1.05    
31.00   35.00   33.05    0.97
innodb  create_index                          3.00       +1.64%       0.05     
2.00    4.00    3.05    0.38
innodb  create_key+drop                      36.00      -14.29%      -4.50    
28.00   36.00   31.50    1.43
innodb  create_MANY_tables                   22.00       -8.11%      -1.65    
19.00   22.00   20.35    0.65
innodb  delete_all_many_keys               1021.00      -47.17%    -327.25   
553.00 1021.00  693.75  130.03
innodb  delete_autocommit                     4.00       -8.11%      -0.30     
3.00    4.00    3.70    0.46
innodb  delete_big                            0.00     +100.00%       0.35     
0.00    1.00    0.35    0.48
innodb  delete_big_many_keys               1019.00      -47.06%    -326.10   
553.00 1019.00  692.90  129.97
innodb  delete_commit                         1.00      +44.44%       0.80     
1.00    2.00    1.80    0.40
innodb  delete_key                            3.00       -5.26%      -0.15     
2.00    3.00    2.85    0.36
innodb  delete_range                          9.00       -6.51%      -0.55     
7.00   10.00    8.45    0.74
innodb  delete_rollback                       2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  drop_index                            4.00      -33.33%      -1.00     
2.00    4.00    3.00    0.55
innodb  drop_table_when_MANY_tables          20.00       -8.11%      -1.50    
17.00   20.00   18.50    0.74
innodb  insert                              113.00       +0.44%       0.50   
111.00  117.00  113.50    1.47
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.81%       0.35    
19.00   20.00   19.35    0.48
innodb  insert_key                          307.00      -10.19%     -28.40   
260.00  307.00  278.60   11.24
innodb  insert_many_fields                    6.00       -6.19%      -0.35     
5.00    7.00    5.65    0.57
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   6.00      -44.58%      -1.85     
3.00    6.00    4.15    0.65
innodb  insert_select_2_keys                  7.00      -10.24%      -0.65     
5.00    7.00    6.35    0.57
innodb  min_max                               7.00       +8.50%       0.65     
6.00    9.00    7.65    1.15
innodb  min_max_on_key                       25.00       -2.04%      -0.50    
24.00   25.00   24.50    0.50
innodb  multiple_value_insert                 6.00       +4.00%       0.25     
5.00    8.00    6.25    0.77
innodb  once_prepared_select                 29.00       -0.52%      -0.15    
28.00   29.00   28.85    0.36
innodb  order_by_big                         15.00       -4.90%      -0.70    
12.00   15.00   14.30    0.95
innodb  order_by_big_key                     16.00      -14.29%      -2.00    
12.00   16.00   14.00    1.45
innodb  order_by_big_key2                    11.00      +14.73%       1.90    
11.00   14.00   12.90    1.09
innodb  order_by_big_key_desc                14.00       +5.08%       0.75    
13.00   16.00   14.75    0.94
innodb  order_by_big_key_diff                13.00       +0.76%       0.10    
12.00   15.00   13.10    0.77
innodb  order_by_big_key_prefix              12.00       +5.88%       0.75    
12.00   14.00   12.75    0.70
innodb  order_by_key2_diff                    1.00      +37.50%       0.60     
1.00    2.00    1.60    0.49
innodb  order_by_key_prefix                   1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  order_by_range                        1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  outer_join                           23.00       -1.77%      -0.40    
17.00   26.00   22.60    2.24
innodb  outer_join_found                     22.00       -1.38%      -0.30    
17.00   24.00   21.70    2.03
innodb  outer_join_not_found                 19.00       +3.80%       0.75    
16.00   25.00   19.75    2.17
innodb  outer_join_on_key                    15.00       -0.67%      -0.10    
12.00   17.00   14.90    1.41
innodb  prepared_select                      37.00       -0.82%      -0.30    
36.00   38.00   36.70    0.56
innodb  select_1_row                          4.00      -12.68%      -0.45     
3.00    4.00    3.55    0.50
innodb  select_1_row_cache                    3.00      +13.04%       0.45     
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                           13.00       -4.00%      -0.50    
11.00   15.00   12.50    1.16
innodb  select_big_str                        2.00      -29.03%      -0.45     
1.00    2.00    1.55    0.50
innodb  select_cache                         63.00       +2.10%       1.35    
60.00   72.00   64.35    2.71
innodb  select_cache2                        63.00       +1.79%       1.15    
58.00   73.00   64.15    3.53
innodb  select_column+column                  4.00       -6.67%      -0.25     
3.00    4.00    3.75    0.43
innodb  select_diff_key                       0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  select_distinct                       5.00       -8.70%      -0.40     
4.00    5.00    4.60    0.49
innodb  select_group                         15.00      +11.76%       2.00    
15.00   19.00   17.00    1.45
innodb  select_group_when_MANY_tables        13.00       -9.24%      -1.10    
10.00   13.00   11.90    0.70
innodb  select_join                           1.00      -33.33%      -0.25     
0.00    1.00    0.75    0.43
innodb  select_key                           63.00       +1.33%       0.85    
63.00   66.00   63.85    0.79
innodb  select_key2                          70.00       +0.43%       0.30    
69.00   71.00   70.30    0.71
innodb  select_key2_return_key               67.00       +1.33%       0.90    
67.00   69.00   67.90    0.62
innodb  select_key2_return_prim              68.00       +0.87%       0.60    
67.00   70.00   68.60    0.73
innodb  select_key_prefix                    71.00       -1.65%      -1.15    
68.00   71.00   69.85    0.73
innodb  select_key_prefix_join                5.00       +2.91%       0.15     
5.00    6.00    5.15    0.36
innodb  select_key_return_key                62.00       +0.88%       0.55    
61.00   64.00   62.55    0.80
innodb  select_many_fields                   13.00       +4.41%       0.60    
13.00   17.00   13.60    0.92
innodb  select_range                         50.00      -11.11%      -5.00    
40.00   50.00   45.00    3.03
innodb  select_range_key2                    10.00       -5.26%      -0.50     
9.00   10.00    9.50    0.50
innodb  select_range_prefix                   9.00       +2.17%       0.20     
8.00   10.00    9.20    0.60
innodb  select_simple                         2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  select_simple_cache                   2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_join                    1.00      -42.86%      -0.30     
0.00    1.00    0.70    0.46
innodb  update_autocommit                     4.00      -12.68%      -0.45     
3.00    5.00    3.55    0.59
innodb  update_big                           61.00       -3.21%      -1.90    
56.00   65.00   59.10    2.10
innodb  update_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  update_of_key                        22.00       +0.45%       0.10    
21.00   24.00   22.10    0.99
innodb  update_of_key_big                    20.00      +39.21%      12.90    
18.00   46.00   32.90    7.65
innodb  update_of_primary_key_many_keys    1389.00       -5.89%     -77.25  
1123.00 1435.00 1311.75   75.58
innodb  update_rollback                       2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  update_with_key                     121.00       -0.46%      -0.55   
115.00  125.00  120.45    2.73
innodb  update_with_key_prefix               46.00       -4.31%      -1.90    
41.00   47.00   44.10    1.81
innodb  wisc_benchmark                        2.00      +25.93%       0.70     
2.00    3.00    2.70    0.46

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00      -46.40%     -10.14    
11.00   61.00   21.86   10.17
innodb  alter_table_drop                     24.00      -27.85%      -5.23    
10.00   57.00   18.77    6.85
innodb  connect                               3.00      -43.57%      -0.91     
1.00    3.00    2.09    0.42
innodb  connect+select_1_row                  3.00      -10.31%      -0.28     
2.00    5.00    2.72    0.46
innodb  connect+select_simple                 2.00      +15.50%       0.37     
1.00    3.00    2.37    0.49
innodb  count                                14.00      +11.11%       1.75    
12.00  193.00   15.75    8.52
innodb  count_distinct                        6.00       +8.89%       0.59     
5.00   50.00    6.59    2.20
innodb  count_distinct_2                     13.00       +1.69%       0.22    
11.00   63.00   13.22    2.87
innodb  count_distinct_big                   21.00       +4.57%       1.01     
5.00   67.00   22.01    2.96
innodb  count_distinct_group                 15.00      -13.22%      -1.75    
10.00   68.00   13.25    3.01
innodb  count_distinct_group_on_key           9.00       +5.31%       0.50     
7.00   69.00    9.50    2.92
innodb  count_distinct_group_on_key_parts    15.00      -21.12%      -2.62     
9.00   72.00   12.38    3.06
innodb  count_distinct_key_prefix             4.00      +22.27%       1.15     
3.00   52.00    5.15    2.31
innodb  count_group_on_key_parts             11.00       -9.46%      -0.95     
7.00   72.00   10.05    3.05
innodb  count_on_key                         94.00       -8.58%      -7.43    
68.00  107.00   86.57    7.45
innodb  create+drop                          32.00       +1.51%       0.49    
18.00   75.00   32.49   11.46
innodb  create_index                          3.00       -3.27%      -0.09     
1.00    8.00    2.91    1.11
innodb  create_key+drop                      36.00      -26.68%      -7.58    
21.00   50.00   28.42    4.81
innodb  create_MANY_tables                   22.00      +33.56%      11.11    
14.00  121.00   33.11   16.83
innodb  create_table                          0.00     +100.00%       0.10     
0.00    3.00    0.10    0.35
innodb  delete_all_many_keys               1021.00     -113.32%    -542.38   
212.00 1888.00  478.62  355.18
innodb  delete_autocommit                     4.00      -15.71%      -0.54     
2.00   14.00    3.46    0.74
innodb  delete_big                            0.00     +100.00%       0.30     
0.00    3.00    0.30    0.47
innodb  delete_big_many_keys               1019.00     -110.47%    -534.84   
212.00 2293.00  484.16  368.48
innodb  delete_commit                         1.00      +34.88%       0.54     
1.00    5.00    1.54    0.53
innodb  delete_key                            3.00       +1.21%       0.04     
2.00   35.00    3.04    1.45
innodb  delete_range                          9.00       -8.06%      -0.67     
5.00   23.00    8.33    3.13
innodb  delete_rollback                       2.00      -13.20%      -0.23     
1.00   12.00    1.77    0.89
innodb  drop_index                            4.00      -35.43%      -1.05     
1.00    9.00    2.95    1.28
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.23
innodb  drop_table_when_MANY_tables          20.00       -2.54%      -0.50    
11.00   90.00   19.50    7.26
innodb  insert                              113.00       -5.42%      -5.81     
3.00  343.00  107.19   14.18
innodb  insert_autocommit                     3.00       +0.36%       0.01     
2.00   99.00    3.01    3.20
innodb  insert_commit                         2.00      -41.70%      -0.59     
1.00    3.00    1.41    0.50
innodb  insert_duplicates                    19.00      -20.82%      -3.27    
11.00   21.00   15.73    2.73
innodb  insert_key                          307.00       -1.89%      -5.70   
142.00  700.00  301.30  103.07
innodb  insert_many_fields                    6.00       -6.78%      -0.38     
3.00   17.00    5.62    1.71
innodb  insert_rollback                       2.00      -18.26%      -0.31     
1.00    3.00    1.69    0.53
innodb  insert_select_1_key                   6.00      -58.07%      -2.20     
2.00   10.00    3.80    0.87
innodb  insert_select_2_keys                  7.00      -15.13%      -0.92     
4.00   16.00    6.08    2.02
innodb  min_max                               7.00      +10.49%       0.82     
6.00  110.00    7.82    4.39
innodb  min_max_on_key                       25.00      -20.09%      -4.18    
14.00   37.00   20.82    3.14
innodb  multiple_value_insert                 6.00       -8.63%      -0.48     
2.00   50.00    5.52    4.14
innodb  once_prepared_select                 29.00      -18.16%      -4.46    
18.00   32.00   24.54    3.66
innodb  order_by_big                         15.00       -4.86%      -0.70    
12.00   31.00   14.30    1.50
innodb  order_by_big_key                     16.00      -19.98%      -2.66    
11.00   32.00   13.34    1.64
innodb  order_by_big_key2                    11.00      +10.15%       1.24    
10.00   33.00   12.24    1.52
innodb  order_by_big_key_desc                14.00       -3.00%      -0.41    
11.00   32.00   13.59    1.68
innodb  order_by_big_key_diff                13.00       -5.85%      -0.72    
10.00   31.00   12.28    1.48
innodb  order_by_big_key_prefix              12.00       +3.53%       0.44    
10.00   32.00   12.44    1.53
innodb  order_by_key2_diff                    1.00      +28.57%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -25.51%      -0.20     
0.00    2.00    0.80    0.41
innodb  order_by_range                        1.00      -19.66%      -0.16     
0.00    2.00    0.84    0.38
innodb  outer_join                           23.00      -17.75%      -3.47    
15.00   61.00   19.53    3.72
innodb  outer_join_found                     22.00      -16.17%      -3.06    
14.00   58.00   18.94    3.57
innodb  outer_join_not_found                 19.00      -14.04%      -2.34    
12.00   46.00   16.66    3.20
innodb  outer_join_on_key                    15.00      -15.08%      -1.97    
10.00   59.00   13.03    2.76
innodb  prepared_select                      37.00      -16.69%      -5.29    
22.00   40.00   31.71    4.58
innodb  select_1_row                          4.00      -38.05%      -1.10     
2.00    4.00    2.90    0.70
innodb  select_1_row_cache                    3.00       -9.66%      -0.26     
2.00    4.00    2.74    0.70
innodb  select_2_rows                         3.00       -2.47%      -0.07     
2.00    4.00    2.93    0.71
innodb  select_big                           13.00       -6.67%      -0.81     
0.00   31.00   12.19    1.53
innodb  select_big_str                        2.00      -69.59%      -0.82     
0.00    2.00    1.18    0.39
innodb  select_cache                         63.00       -5.18%      -3.10    
49.00   77.00   59.90    5.57
innodb  select_cache2                        63.00       -4.55%      -2.74    
49.00   75.00   60.26    6.20
innodb  select_column+column                  4.00      -34.15%      -1.02     
2.00    4.00    2.98    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.40%      -0.74     
3.00    8.00    4.26    0.55
innodb  select_group                         15.00       +7.94%       1.29     
4.00  136.00   16.29    5.25
innodb  select_group_when_MANY_tables        13.00      -34.93%      -3.37     
3.00   49.00    9.63    9.14
innodb  select_join                           1.00      -72.63%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           63.00      -17.72%      -9.48    
40.00   66.00   53.52    7.72
innodb  select_key2                          70.00      -16.25%      -9.79    
45.00   75.00   60.21    8.50
innodb  select_key2_return_key               67.00      -16.42%      -9.45    
42.00   71.00   57.55    8.32
innodb  select_key2_return_prim              68.00      -16.61%      -9.69    
42.00   72.00   58.31    8.46
innodb  select_key_prefix                    71.00      -19.34%     -11.51    
44.00   75.00   59.49    8.55
innodb  select_key_prefix_join                5.00       -5.29%      -0.25     
3.00   10.00    4.75    0.65
innodb  select_key_return_key                62.00      -18.02%      -9.47    
38.00   65.00   52.53    7.71
innodb  select_many_fields                   13.00      +12.34%       1.83    
11.00   19.00   14.83    1.79
innodb  select_range                         50.00       -6.86%      -3.21    
38.00   76.00   46.79    4.07
innodb  select_range_key2                    10.00      -19.83%      -1.66     
6.00   11.00    8.34    1.07
innodb  select_range_prefix                   9.00      -13.47%      -1.07     
5.00   10.00    7.93    1.14
innodb  select_simple                         2.00      -19.46%      -0.33     
1.00    3.00    1.67    0.51
innodb  select_simple_cache                   2.00      -26.04%      -0.41     
1.00    3.00    1.59    0.51
innodb  select_simple_join                    1.00      -49.76%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     4.00      -19.41%      -0.65     
2.00   16.00    3.35    0.99
innodb  update_big                           61.00      -18.36%      -9.46    
31.00  195.00   51.54   23.70
innodb  update_commit                         2.00      -25.90%      -0.41     
1.00   10.00    1.59    0.71
innodb  update_of_key                        22.00       +8.67%       2.09    
18.00  100.00   24.09    5.98
innodb  update_of_key_big                    20.00      +28.53%       7.98    
15.00   75.00   27.98   10.86
innodb  update_of_primary_key_many_keys    1389.00      -11.31%    -141.12   
647.00 6065.00 1247.88  916.67
innodb  update_rollback                       2.00      -12.11%      -0.22     
1.00   31.00    1.78    1.84
innodb  update_with_key                     121.00       -9.38%     -10.38    
90.00  598.00  110.62   20.26
innodb  update_with_key_prefix               46.00      -15.16%      -6.06    
33.00  202.00   39.94    6.70
innodb  wisc_benchmark                        2.00      +19.41%       0.48     
2.00    5.00    2.48    0.52

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

  2272.1.3: Olaf van der Spek 2011-04-11 Table Cache
  2272.1.2: Olaf van der Spek 2011-04-11 Table Cache
  2272.1.1: Olaf van der Spek 2011-04-11 Refactor includes

_______________________________________________
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