=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   1004
RUN DATE: 2011-04-14T15:13:40.153504
SERVER:   drizzled
VERSION:  staging
REVISION: 2279
COMMENT:  2279: Lee Bieber 2011-04-14 [merge] Merge Olaf - Refactor Table Cache

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      30.00       +3.23%       1.00    
30.00   32.00   31.00    0.89
innodb  alter_table_drop                     24.00       -2.56%      -0.60    
23.00   24.00   23.40    0.49
innodb  connect                               3.00      -25.00%      -0.60     
2.00    3.00    2.40    0.49
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  count                                14.00       +6.67%       1.00    
13.00   17.00   15.00    1.67
innodb  count_distinct                        7.00       -6.06%      -0.40     
6.00    8.00    6.60    0.80
innodb  count_distinct_2                     14.00       -0.00%       0.00    
12.00   16.00   14.00    1.41
innodb  count_distinct_big                   21.00       +6.25%       1.40    
20.00   25.00   22.40    2.15
innodb  count_distinct_group                 14.00       +4.11%       0.60    
12.00   16.00   14.60    1.50
innodb  count_distinct_group_on_key           9.00       +8.16%       0.80     
9.00   11.00    9.80    0.98
innodb  count_distinct_group_on_key_parts    13.00       +4.41%       0.60    
11.00   15.00   13.60    1.50
innodb  count_distinct_key_prefix             5.00       +3.85%       0.20     
4.00    6.00    5.20    0.75
innodb  count_group_on_key_parts             11.00       +1.79%       0.20    
11.00   12.00   11.20    0.40
innodb  count_on_key                         98.00       -1.66%      -1.60    
92.00  100.00   96.40    2.94
innodb  create+drop                          33.00       -1.23%      -0.40    
32.00   33.00   32.60    0.49
innodb  create_index                          3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  create_key+drop                      32.00       +1.84%       0.60    
30.00   36.00   32.60    1.96
innodb  create_MANY_tables                   21.00       -0.96%      -0.20    
20.00   22.00   20.80    0.75
innodb  delete_all_many_keys               1227.00      -28.75%    -274.00   
716.00 1227.00  953.00  191.39
innodb  delete_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  delete_big                            0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_big_many_keys               1226.00      -28.75%    -273.80   
715.00 1226.00  952.20  191.21
innodb  delete_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  delete_key                            3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  delete_range                          8.00       +4.76%       0.40     
8.00    9.00    8.40    0.49
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  drop_table_when_MANY_tables          20.00       -3.09%      -0.60    
19.00   20.00   19.40    0.49
innodb  insert                              112.00       +0.18%       0.20   
111.00  113.00  112.20    0.75
innodb  insert_autocommit                     3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  insert_commit                         1.00      +44.44%       0.80     
1.00    2.00    1.80    0.40
innodb  insert_duplicates                    19.00       -0.00%       0.00    
19.00   19.00   19.00    0.00
innodb  insert_key                          296.00       -3.71%     -10.60   
270.00  307.00  285.40   13.97
innodb  insert_many_fields                    6.00       -0.00%       0.00     
6.00    6.00    6.00    0.00
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   6.00       -7.14%      -0.40     
5.00    6.00    5.60    0.49
innodb  insert_select_2_keys                  6.00       -0.00%       0.00     
5.00    7.00    6.00    0.63
innodb  min_max                               6.00      +16.67%       1.20     
6.00    9.00    7.20    1.17
innodb  min_max_on_key                       25.00       -0.81%      -0.20    
24.00   25.00   24.80    0.40
innodb  multiple_value_insert                 6.00       +6.25%       0.40     
6.00    7.00    6.40    0.49
innodb  once_prepared_select                 29.00       -1.40%      -0.40    
28.00   29.00   28.60    0.49
innodb  order_by_big                         13.00       +8.45%       1.20    
13.00   15.00   14.20    0.75
innodb  order_by_big_key                     14.00       +7.89%       1.20    
14.00   16.00   15.20    0.75
innodb  order_by_big_key2                    14.00       -9.38%      -1.20    
11.00   14.00   12.80    1.17
innodb  order_by_big_key_desc                15.00       +2.60%       0.40    
14.00   16.00   15.40    0.80
innodb  order_by_big_key_diff                12.00       +6.25%       0.80    
12.00   14.00   12.80    0.75
innodb  order_by_big_key_prefix              13.00       -0.00%       0.00    
12.00   14.00   13.00    0.63
innodb  order_by_key2_diff                    2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  order_by_key_prefix                   1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           24.00       -5.26%      -1.20    
17.00   25.00   22.80    2.99
innodb  outer_join_found                     21.00       +1.87%       0.40    
17.00   24.00   21.40    2.42
innodb  outer_join_not_found                 20.00       -2.04%      -0.40    
15.00   22.00   19.60    2.58
innodb  outer_join_on_key                    15.00       -0.00%       0.00    
12.00   17.00   15.00    1.67
innodb  prepared_select                      37.00       -0.54%      -0.20    
36.00   37.00   36.80    0.40
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      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_big                           12.00       +9.09%       1.20    
12.00   14.00   13.20    0.75
innodb  select_big_str                        1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  select_cache                         59.00       +5.45%       3.40    
59.00   64.00   62.40    1.85
innodb  select_cache2                        64.00       +3.32%       2.20    
62.00   76.00   66.20    5.08
innodb  select_column+column                  4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_distinct                       4.00       +4.76%       0.20     
4.00    5.00    4.20    0.40
innodb  select_group                         16.00       +2.44%       0.40    
15.00   19.00   16.40    1.50
innodb  select_group_when_MANY_tables        13.00       -6.56%      -0.80    
11.00   13.00   12.20    0.75
innodb  select_join                           0.00     +100.00%       0.80     
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                          70.00       +0.57%       0.40    
70.00   71.00   70.40    0.49
innodb  select_key2_return_key               69.00       -1.77%      -1.20    
67.00   69.00   67.80    0.75
innodb  select_key2_return_prim              69.00       -1.17%      -0.80    
68.00   69.00   68.20    0.40
innodb  select_key_prefix                    70.00       +0.28%       0.20    
70.00   71.00   70.20    0.40
innodb  select_key_prefix_join                6.00      -15.38%      -0.80     
5.00    6.00    5.20    0.40
innodb  select_key_return_key                63.00       -0.96%      -0.60    
62.00   63.00   62.40    0.49
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         52.00       -7.00%      -3.40    
44.00   52.00   48.60    2.65
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       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  update_autocommit                     4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  update_big                           58.00       +2.36%       1.40    
58.00   61.00   59.40    1.02
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        21.00       +6.25%       1.40    
21.00   23.00   22.40    0.80
innodb  update_of_key_big                    20.00       -2.04%      -0.40    
19.00   20.00   19.60    0.49
innodb  update_of_primary_key_many_keys    1306.00       -1.78%     -22.80  
1165.00 1389.00 1283.20   71.93
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     117.00       +1.02%       1.20   
117.00  121.00  118.20    1.47
innodb  update_with_key_prefix               43.00       +1.83%       0.80    
41.00   46.00   43.80    1.94
innodb  wisc_benchmark                        3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      30.00       +6.40%       2.05    
30.00   34.00   32.05    1.24
innodb  alter_table_drop                     24.00       -2.13%      -0.50    
22.00   25.00   23.50    0.74
innodb  connect                               3.00      -39.53%      -0.85     
2.00    3.00    2.15    0.36
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 2.00      +24.53%       0.65     
2.00    3.00    2.65    0.48
innodb  count                                14.00      +12.77%       2.05    
13.00   18.00   16.05    1.77
innodb  count_distinct                        7.00       -1.45%      -0.10     
6.00    8.00    6.90    0.77
innodb  count_distinct_2                     14.00       -3.32%      -0.45    
11.00   16.00   13.55    1.47
innodb  count_distinct_big                   21.00       +9.68%       2.25    
20.00   25.00   23.25    1.81
innodb  count_distinct_group                 14.00       +3.11%       0.45    
11.00   16.00   14.45    1.43
innodb  count_distinct_group_on_key           9.00       +7.22%       0.70     
8.00   12.00    9.70    1.00
innodb  count_distinct_group_on_key_parts    13.00       +0.38%       0.05    
11.00   15.00   13.05    1.43
innodb  count_distinct_key_prefix             5.00       +6.54%       0.35     
4.00    7.00    5.35    0.73
innodb  count_group_on_key_parts             11.00       +1.79%       0.20    
10.00   12.00   11.20    0.51
innodb  count_on_key                         98.00       -1.66%      -1.60    
92.00  103.00   96.40    3.02
innodb  create+drop                          33.00       +0.15%       0.05    
31.00   35.00   33.05    0.92
innodb  create_index                          3.00       +4.76%       0.15     
3.00    4.00    3.15    0.36
innodb  create_key+drop                      32.00       -1.11%      -0.35    
28.00   36.00   31.65    1.46
innodb  create_MANY_tables                   21.00       -2.94%      -0.60    
19.00   22.00   20.40    0.66
innodb  delete_all_many_keys               1227.00      -63.01%    -474.30   
553.00 1227.00  752.70  182.79
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.30     
0.00    1.00    0.30    0.46
innodb  delete_big_many_keys               1226.00      -63.04%    -474.05   
553.00 1226.00  751.95  182.78
innodb  delete_commit                         2.00       -8.11%      -0.15     
1.00    2.00    1.85    0.36
innodb  delete_key                            3.00       -5.26%      -0.15     
2.00    3.00    2.85    0.36
innodb  delete_range                          8.00       +5.88%       0.50     
8.00   10.00    8.50    0.67
innodb  delete_rollback                       2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  drop_index                            3.00       -1.69%      -0.05     
2.00    4.00    2.95    0.50
innodb  drop_table_when_MANY_tables          20.00       -7.53%      -1.40    
17.00   20.00   18.60    0.80
innodb  insert                              112.00       +1.15%       1.30   
111.00  117.00  113.30    1.52
innodb  insert_autocommit                     3.00       +3.23%       0.10     
3.00    4.00    3.10    0.30
innodb  insert_commit                         1.00      +45.95%       0.85     
1.00    2.00    1.85    0.36
innodb  insert_duplicates                    19.00       +1.55%       0.30    
19.00   20.00   19.30    0.46
innodb  insert_key                          296.00       -6.38%     -17.75   
260.00  307.00  278.25   11.70
innodb  insert_many_fields                    6.00       -5.26%      -0.30     
5.00    7.00    5.70    0.56
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   6.00      -34.83%      -1.55     
3.00    6.00    4.45    0.86
innodb  insert_select_2_keys                  6.00       +2.44%       0.15     
5.00    7.00    6.15    0.57
innodb  min_max                               6.00      +22.08%       1.70     
6.00    9.00    7.70    1.23
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.87%      -0.25    
28.00   29.00   28.75    0.43
innodb  order_by_big                         13.00       +7.80%       1.10    
12.00   15.00   14.10    0.94
innodb  order_by_big_key                     14.00       +3.78%       0.55    
12.00   16.00   14.55    1.20
innodb  order_by_big_key2                    14.00       -7.69%      -1.00    
11.00   14.00   13.00    1.14
innodb  order_by_big_key_desc                15.00       +0.33%       0.05    
13.00   16.00   15.05    0.97
innodb  order_by_big_key_diff                12.00       +6.61%       0.85    
12.00   14.00   12.85    0.65
innodb  order_by_big_key_prefix              13.00       -1.17%      -0.15    
12.00   14.00   12.85    0.65
innodb  order_by_key2_diff                    2.00      -25.00%      -0.40     
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      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  outer_join                           24.00       -5.96%      -1.35    
17.00   26.00   22.65    2.67
innodb  outer_join_found                     21.00       +2.55%       0.55    
17.00   24.00   21.55    2.33
innodb  outer_join_not_found                 20.00       -1.78%      -0.35    
15.00   22.00   19.65    2.17
innodb  outer_join_on_key                    15.00       -0.33%      -0.05    
12.00   17.00   14.95    1.60
innodb  prepared_select                      37.00       -0.82%      -0.30    
36.00   37.00   36.70    0.46
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                         4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_big                           12.00       +5.88%       0.75    
11.00   15.00   12.75    1.22
innodb  select_big_str                        1.00      +33.33%       0.50     
1.00    2.00    1.50    0.50
innodb  select_cache                         59.00       +7.81%       5.00    
59.00   67.00   64.00    2.02
innodb  select_cache2                        64.00       +0.78%       0.50    
61.00   76.00   64.50    3.60
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.15     
0.00    1.00    0.15    0.36
innodb  select_distinct                       4.00      +11.11%       0.50     
4.00    5.00    4.50    0.50
innodb  select_group                         16.00       +5.88%       1.00    
15.00   19.00   17.00    1.48
innodb  select_group_when_MANY_tables        13.00       -9.24%      -1.10    
11.00   13.00   11.90    0.54
innodb  select_join                           0.00     +100.00%       0.70     
0.00    1.00    0.70    0.46
innodb  select_key                           65.00       -1.88%      -1.20    
63.00   65.00   63.80    0.60
innodb  select_key2                          70.00       +0.43%       0.30    
69.00   71.00   70.30    0.71
innodb  select_key2_return_key               69.00       -1.77%      -1.20    
67.00   69.00   67.80    0.60
innodb  select_key2_return_prim              69.00       -0.80%      -0.55    
67.00   70.00   68.45    0.67
innodb  select_key_prefix                    70.00       -0.21%      -0.15    
68.00   71.00   69.85    0.65
innodb  select_key_prefix_join                6.00      -15.38%      -0.80     
5.00    6.00    5.20    0.40
innodb  select_key_return_key                63.00       -0.88%      -0.55    
61.00   64.00   62.45    0.74
innodb  select_many_fields                   13.00       +4.06%       0.55    
13.00   17.00   13.55    0.92
innodb  select_range                         52.00      -13.79%      -6.30    
41.00   52.00   45.70    3.16
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.70%       0.25     
8.00   10.00    9.25    0.54
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      -33.33%      -0.25     
0.00    1.00    0.75    0.43
innodb  update_autocommit                     4.00      -12.68%      -0.45     
3.00    5.00    3.55    0.59
innodb  update_big                           58.00       +1.19%       0.70    
56.00   62.00   58.70    1.52
innodb  update_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  update_of_key                        21.00       +5.62%       1.25    
21.00   24.00   22.25    0.89
innodb  update_of_key_big                    20.00      +32.20%       9.50    
18.00   46.00   29.50    8.80
innodb  update_of_primary_key_many_keys    1306.00       -1.01%     -13.10  
1123.00 1435.00 1292.90   77.56
innodb  update_rollback                       2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  update_with_key                     117.00       +2.26%       2.70   
115.00  125.00  119.70    2.85
innodb  update_with_key_prefix               43.00       +2.05%       0.90    
41.00   47.00   43.90    1.89
innodb  wisc_benchmark                        3.00       -9.09%      -0.25     
2.00    3.00    2.75    0.43

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      30.00      -37.01%      -8.10    
11.00   61.00   21.90   10.16
innodb  alter_table_drop                     24.00      -27.72%      -5.21    
10.00   57.00   18.79    6.84
innodb  connect                               3.00      -43.53%      -0.91     
1.00    3.00    2.09    0.42
innodb  connect+select_1_row                  3.00      -10.26%      -0.28     
2.00    5.00    2.72    0.46
innodb  connect+select_simple                 2.00      +15.56%       0.37     
1.00    3.00    2.37    0.49
innodb  count                                14.00      +11.09%       1.75    
12.00  193.00   15.75    8.50
innodb  count_distinct                        7.00       -6.29%      -0.41     
5.00   50.00    6.59    2.20
innodb  count_distinct_2                     14.00       -5.84%      -0.77    
11.00   63.00   13.23    2.87
innodb  count_distinct_big                   21.00       +4.59%       1.01     
5.00   67.00   22.01    2.96
innodb  count_distinct_group                 14.00       -5.63%      -0.75    
10.00   68.00   13.25    3.01
innodb  count_distinct_group_on_key           9.00       +5.33%       0.51     
7.00   69.00    9.51    2.92
innodb  count_distinct_group_on_key_parts    13.00       -4.94%      -0.61     
9.00   72.00   12.39    3.06
innodb  count_distinct_key_prefix             5.00       +2.86%       0.15     
3.00   52.00    5.15    2.30
innodb  count_group_on_key_parts             11.00       -9.40%      -0.95     
7.00   72.00   10.05    3.04
innodb  count_on_key                         98.00      -13.14%     -11.38    
68.00  107.00   86.62    7.46
innodb  create+drop                          33.00       -1.57%      -0.51    
18.00   75.00   32.49   11.43
innodb  create_index                          3.00       -3.22%      -0.09     
1.00    8.00    2.91    1.10
innodb  create_key+drop                      32.00      -12.55%      -3.57    
21.00   50.00   28.43    4.81
innodb  create_MANY_tables                   21.00      +36.47%      12.06    
14.00  121.00   33.06   16.81
innodb  create_table                          0.00     +100.00%       0.10     
0.00    3.00    0.10    0.35
innodb  delete_all_many_keys               1227.00     -155.27%    -746.32   
212.00 1888.00  480.68  355.98
innodb  delete_autocommit                     3.00      +13.19%       0.46     
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               1226.00     -152.17%    -739.81   
212.00 2293.00  486.19  369.15
innodb  delete_commit                         2.00      -30.07%      -0.46     
1.00    5.00    1.54    0.53
innodb  delete_key                            3.00       +1.17%       0.04     
2.00   35.00    3.04    1.45
innodb  delete_range                          8.00       +3.94%       0.33     
5.00   23.00    8.33    3.12
innodb  delete_rollback                       2.00      -13.14%      -0.23     
1.00   12.00    1.77    0.89
innodb  drop_index                            3.00       -1.56%      -0.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.25
innodb  insert                              112.00       -4.47%      -4.79     
3.00  343.00  107.21   14.15
innodb  insert_autocommit                     3.00       +0.36%       0.01     
2.00   99.00    3.01    3.19
innodb  insert_commit                         1.00      +29.22%       0.41     
1.00    3.00    1.41    0.50
innodb  insert_duplicates                    19.00      -20.72%      -3.26    
11.00   21.00   15.74    2.73
innodb  insert_key                          296.00       +1.72%       5.20   
142.00  700.00  301.20  102.84
innodb  insert_many_fields                    6.00       -6.75%      -0.38     
3.00   17.00    5.62    1.71
innodb  insert_rollback                       2.00      -18.17%      -0.31     
1.00    3.00    1.69    0.52
innodb  insert_select_1_key                   6.00      -57.77%      -2.20     
2.00   10.00    3.80    0.88
innodb  insert_select_2_keys                  6.00       +1.29%       0.08     
4.00   16.00    6.08    2.02
innodb  min_max                               6.00      +23.25%       1.82     
6.00  110.00    7.82    4.38
innodb  min_max_on_key                       25.00      -19.99%      -4.17    
14.00   37.00   20.83    3.15
innodb  multiple_value_insert                 6.00       -8.55%      -0.47     
2.00   50.00    5.53    4.13
innodb  once_prepared_select                 29.00      -18.07%      -4.44    
18.00   32.00   24.56    3.66
innodb  order_by_big                         13.00       +9.11%       1.30    
12.00   31.00   14.30    1.50
innodb  order_by_big_key                     14.00       -4.93%      -0.66    
11.00   32.00   13.34    1.64
innodb  order_by_big_key2                    14.00      -14.32%      -1.75    
10.00   33.00   12.25    1.52
innodb  order_by_big_key_desc                15.00      -10.28%      -1.40    
11.00   32.00   13.60    1.69
innodb  order_by_big_key_diff                12.00       +2.30%       0.28    
10.00   31.00   12.28    1.48
innodb  order_by_big_key_prefix              13.00       -4.48%      -0.56    
10.00   32.00   12.44    1.53
innodb  order_by_key2_diff                    2.00      -42.70%      -0.60     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -25.71%      -0.20     
0.00    2.00    0.80    0.41
innodb  order_by_range                        1.00      -19.56%      -0.16     
0.00    2.00    0.84    0.38
innodb  outer_join                           24.00      -22.78%      -4.45    
15.00   61.00   19.55    3.72
innodb  outer_join_found                     21.00      -10.83%      -2.05    
14.00   58.00   18.95    3.57
innodb  outer_join_not_found                 20.00      -19.95%      -3.33    
12.00   46.00   16.67    3.21
innodb  outer_join_on_key                    15.00      -15.00%      -1.96    
10.00   59.00   13.04    2.76
innodb  prepared_select                      37.00      -16.61%      -5.27    
22.00   40.00   31.73    4.58
innodb  select_1_row                          4.00      -37.87%      -1.10     
2.00    4.00    2.90    0.70
innodb  select_1_row_cache                    3.00       -9.57%      -0.26     
2.00    4.00    2.74    0.70
innodb  select_2_rows                         4.00      -36.46%      -1.07     
2.00    4.00    2.93    0.71
innodb  select_big                           12.00       +1.57%       0.19     
0.00   31.00   12.19    1.52
innodb  select_big_str                        1.00      +15.15%       0.18     
0.00    2.00    1.18    0.39
innodb  select_cache                         59.00       +1.52%       0.91    
49.00   77.00   59.91    5.57
innodb  select_cache2                        64.00       -6.16%      -3.71    
49.00   76.00   60.29    6.21
innodb  select_column+column                  4.00      -33.96%      -1.01     
2.00    4.00    2.99    0.73
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.42
innodb  select_distinct                       4.00       +6.05%       0.26     
3.00    8.00    4.26    0.55
innodb  select_group                         16.00       +1.82%       0.30     
4.00  136.00   16.30    5.24
innodb  select_group_when_MANY_tables        13.00      -34.79%      -3.36     
3.00   49.00    9.64    9.13
innodb  select_join                           0.00     +100.00%       0.58     
0.00    1.00    0.58    0.49
innodb  select_key                           65.00      -21.35%     -11.44    
40.00   66.00   53.56    7.73
innodb  select_key2                          70.00      -16.17%      -9.74    
45.00   75.00   60.26    8.50
innodb  select_key2_return_key               69.00      -19.80%     -11.40    
42.00   71.00   57.60    8.33
innodb  select_key2_return_prim              69.00      -18.24%     -10.64    
42.00   72.00   58.36    8.47
innodb  select_key_prefix                    70.00      -17.57%     -10.46    
44.00   75.00   59.54    8.56
innodb  select_key_prefix_join                6.00      -26.29%      -1.25     
3.00   10.00    4.75    0.65
innodb  select_key_return_key                63.00      -19.83%     -10.43    
38.00   65.00   52.57    7.72
innodb  select_many_fields                   13.00      +12.30%       1.82    
11.00   19.00   14.82    1.79
innodb  select_range                         52.00      -11.12%      -5.21    
38.00   76.00   46.79    4.06
innodb  select_range_key2                    10.00      -19.76%      -1.65     
6.00   11.00    8.35    1.07
innodb  select_range_prefix                   9.00      -13.37%      -1.06     
5.00   10.00    7.94    1.14
innodb  select_simple                         2.00      -19.36%      -0.32     
1.00    3.00    1.68    0.51
innodb  select_simple_cache                   2.00      -25.90%      -0.41     
1.00    3.00    1.59    0.51
innodb  select_simple_join                    1.00      -49.44%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     4.00      -19.35%      -0.65     
2.00   16.00    3.35    0.99
innodb  update_big                           58.00      -12.47%      -6.43    
31.00  195.00   51.57   23.65
innodb  update_commit                         2.00      -25.76%      -0.41     
1.00   10.00    1.59    0.71
innodb  update_of_key                        21.00      +12.80%       3.08    
18.00  100.00   24.08    5.97
innodb  update_of_key_big                    20.00      +28.43%       7.95    
15.00   75.00   27.95   10.85
innodb  update_of_primary_key_many_keys    1306.00       -4.65%     -58.07   
647.00 6065.00 1247.93  914.18
innodb  update_rollback                       2.00      -12.05%      -0.22     
1.00   31.00    1.78    1.83
innodb  update_with_key                     117.00       -5.74%      -6.35    
90.00  598.00  110.65   20.22
innodb  update_with_key_prefix               43.00       -7.62%      -3.04    
33.00  202.00   39.96    6.69
innodb  wisc_benchmark                        3.00      -20.78%      -0.52     
2.00    5.00    2.48    0.52

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

  2278.1.2: Lee Bieber 2011-04-14 [merge] Merge Olaf - Refactor Table Cache
    2263.3.15: Olaf van der Spek 2011-04-14 Fix
    2263.3.14: Olaf van der Spek 2011-04-14 [merge] Merge trunk
    2263.3.13: Olaf van der Spek 2011-04-11 Table Cache
  2278.1.1: Lee Bieber 2011-04-14 [merge] Merge Olaf - Delete unused functions
    2275.2.11: Olaf van der Spek 2011-04-14 [merge] Merge trunk
    2275.2.10: Olaf van der Spek 2011-04-14 Prune
    2275.2.9: Olaf van der Spek 2011-04-14 Prune
    2275.2.8: Olaf van der Spek 2011-04-14 Prune
    2275.2.7: Olaf van der Spek 2011-04-14 Refactor
    2275.2.6: Olaf van der Spek 2011-04-13 Refactor

_______________________________________________
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