=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   997
RUN DATE: 2011-04-11T17:23:59.577088
SERVER:   drizzled
VERSION:  staging
REVISION: 2274
COMMENT:  2274: Brian Aker 2011-04-11 [merge] Merge in Innodb patch from Percona

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      34.00       -4.29%      -1.40    
31.00   34.00   32.60    1.02
innodb  alter_table_drop                     24.00       -1.69%      -0.40    
23.00   24.00   23.60    0.49
innodb  connect                               2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
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       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  count                                18.00      -12.50%      -2.00    
14.00   18.00   16.00    1.67
innodb  count_distinct                        6.00       +9.09%       0.60     
6.00    7.00    6.60    0.49
innodb  count_distinct_2                     11.00      +11.29%       1.40    
11.00   14.00   12.40    1.20
innodb  count_distinct_big                   24.00       -5.26%      -1.20    
21.00   24.00   22.80    1.47
innodb  count_distinct_group                 15.00       -5.63%      -0.80    
12.00   16.00   14.20    1.47
innodb  count_distinct_group_on_key          10.00       -2.04%      -0.20     
9.00   11.00    9.80    0.75
innodb  count_distinct_group_on_key_parts    12.00       +6.25%       0.80    
11.00   15.00   12.80    1.47
innodb  count_distinct_key_prefix             6.00      -15.38%      -0.80     
4.00    6.00    5.20    0.75
innodb  count_group_on_key_parts             11.00       +3.51%       0.40    
11.00   12.00   11.40    0.49
innodb  count_on_key                         97.00       -2.32%      -2.20    
92.00   97.00   94.80    1.72
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.64%       0.20    
31.00   32.00   31.20    0.40
innodb  create_MANY_tables                   20.00       -0.00%       0.00    
20.00   20.00   20.00    0.00
innodb  delete_all_many_keys                987.00      -42.10%    -292.40   
553.00  987.00  694.60  150.58
innodb  delete_autocommit                     3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  delete_big                            0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                986.00      -42.07%    -292.00   
553.00  986.00  694.00  150.32
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  delete_range                          8.00       +4.76%       0.40     
8.00    9.00    8.40    0.49
innodb  delete_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
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.26%      -0.60    
17.00   19.00   18.40    0.80
innodb  insert                              112.00       +1.41%       1.60   
112.00  117.00  113.60    1.85
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                    20.00       -2.04%      -0.40    
19.00   20.00   19.60    0.49
innodb  insert_key                          275.00       -0.73%      -2.00   
260.00  280.00  273.00    6.90
innodb  insert_many_fields                    6.00       -7.14%      -0.40     
5.00    6.00    5.60    0.49
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   5.00      -25.00%      -1.00     
3.00    5.00    4.00    0.63
innodb  insert_select_2_keys                  6.00       +3.23%       0.20     
6.00    7.00    6.20    0.40
innodb  min_max                               9.00      -25.00%      -1.80     
6.00    9.00    7.20    1.17
innodb  min_max_on_key                       24.00       +1.64%       0.40    
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       -1.40%      -0.40    
28.00   29.00   28.60    0.49
innodb  order_by_big                         15.00      -10.29%      -1.40    
12.00   15.00   13.60    1.20
innodb  order_by_big_key                     14.00       +1.41%       0.20    
13.00   15.00   14.20    0.75
innodb  order_by_big_key2                    14.00      -11.11%      -1.40    
11.00   14.00   12.60    1.36
innodb  order_by_big_key_desc                15.00       -2.74%      -0.40    
13.00   16.00   14.60    1.02
innodb  order_by_big_key_diff                13.00       -3.17%      -0.40    
12.00   13.00   12.60    0.49
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                    2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  order_by_key_prefix                   0.00     +100.00%       0.80     
0.00    1.00    0.80    0.40
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           25.00       -8.70%      -2.00    
17.00   25.00   23.00    3.03
innodb  outer_join_found                     24.00       -9.09%      -2.00    
17.00   24.00   22.00    2.61
innodb  outer_join_not_found                 21.00       -5.00%      -1.00    
16.00   22.00   20.00    2.10
innodb  outer_join_on_key                    17.00      -11.84%      -1.80    
12.00   17.00   15.20    1.72
innodb  prepared_select                      37.00       -1.09%      -0.40    
36.00   37.00   36.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       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_big                           11.00      +11.29%       1.40    
11.00   14.00   12.40    1.02
innodb  select_big_str                        1.00      +37.50%       0.60     
1.00    2.00    1.60    0.49
innodb  select_cache                         64.00       +1.23%       0.80    
64.00   67.00   64.80    1.17
innodb  select_cache2                        63.00       +2.48%       1.60    
61.00   70.00   64.60    3.38
innodb  select_column+column                  4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_diff_key                       0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  select_distinct                       4.00      +13.04%       0.60     
4.00    5.00    4.60    0.49
innodb  select_group                         19.00      -10.47%      -1.80    
15.00   19.00   17.20    1.47
innodb  select_group_when_MANY_tables        12.00       -1.69%      -0.20    
11.00   12.00   11.80    0.40
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           64.00       -0.95%      -0.60    
63.00   64.00   63.40    0.49
innodb  select_key2                          70.00       +0.57%       0.40    
70.00   71.00   70.40    0.49
innodb  select_key2_return_key               68.00       -0.59%      -0.40    
67.00   68.00   67.60    0.49
innodb  select_key2_return_prim              69.00       -0.58%      -0.40    
67.00   70.00   68.60    1.02
innodb  select_key_prefix                    70.00       -0.29%      -0.20    
69.00   70.00   69.80    0.40
innodb  select_key_prefix_join                5.00       +3.85%       0.20     
5.00    6.00    5.20    0.40
innodb  select_key_return_key                64.00       -2.24%      -1.40    
61.00   64.00   62.60    1.02
innodb  select_many_fields                   13.00       +4.41%       0.60    
13.00   14.00   13.60    0.49
innodb  select_range                         47.00       -3.07%      -1.40    
42.00   49.00   45.60    2.33
innodb  select_range_key2                    10.00       -2.04%      -0.20     
9.00   10.00    9.80    0.40
innodb  select_range_prefix                   9.00       +2.17%       0.20     
9.00   10.00    9.20    0.40
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      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  update_autocommit                     3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  update_big                           58.00       -0.69%      -0.40    
56.00   59.00   57.60    1.02
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        22.00       +2.65%       0.60    
22.00   24.00   22.60    0.80
innodb  update_of_key_big                    18.00      +44.44%      14.40    
18.00   39.00   32.40    7.55
innodb  update_of_primary_key_many_keys    1236.00       +2.92%      37.20  
1182.00 1350.00 1273.20   59.55
innodb  update_rollback                       2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  update_with_key                     116.00       +2.85%       3.40   
115.00  125.00  119.40    3.61
innodb  update_with_key_prefix               46.00       -3.14%      -1.40    
41.00   47.00   44.60    2.24
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       -4.78%      -1.55    
30.00   35.00   32.45    1.07
innodb  alter_table_drop                     24.00       -1.05%      -0.25    
22.00   26.00   23.75    0.99
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      -13.21%      -0.35     
2.00    3.00    2.65    0.48
innodb  count                                18.00      -14.29%      -2.25    
13.00   18.00   15.75    1.79
innodb  count_distinct                        6.00      +13.04%       0.90     
6.00    8.00    6.90    0.70
innodb  count_distinct_2                     11.00      +18.82%       2.55    
11.00   17.00   13.55    1.66
innodb  count_distinct_big                   24.00       -3.23%      -0.75    
21.00   25.00   23.25    1.61
innodb  count_distinct_group                 15.00       -3.81%      -0.55    
11.00   16.00   14.45    1.28
innodb  count_distinct_group_on_key          10.00       -5.82%      -0.55     
8.00   12.00    9.45    0.97
innodb  count_distinct_group_on_key_parts    12.00       +6.25%       0.80    
11.00   15.00   12.80    1.36
innodb  count_distinct_key_prefix             6.00      -10.09%      -0.55     
4.00    7.00    5.45    0.67
innodb  count_group_on_key_parts             11.00       +1.79%       0.20    
11.00   12.00   11.20    0.40
innodb  count_on_key                         97.00       -1.52%      -1.45    
92.00  102.00   95.55    2.46
innodb  create+drop                          34.00       -2.10%      -0.70    
32.00   35.00   33.30    0.84
innodb  create_index                          3.00       -0.00%       0.00     
2.00    4.00    3.00    0.45
innodb  create_key+drop                      31.00       +0.96%       0.30    
30.00   32.00   31.30    0.64
innodb  create_MANY_tables                   20.00       +0.99%       0.20    
19.00   21.00   20.20    0.51
innodb  delete_all_many_keys                987.00      -50.64%    -331.80   
553.00  987.00  655.20   81.63
innodb  delete_autocommit                     3.00      +15.49%       0.55     
3.00    4.00    3.55    0.50
innodb  delete_big                            0.00     +100.00%       0.45     
0.00    1.00    0.45    0.50
innodb  delete_big_many_keys                986.00      -50.68%    -331.65   
553.00  986.00  654.35   81.59
innodb  delete_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  delete_key                            3.00       -3.45%      -0.10     
2.00    4.00    2.90    0.44
innodb  delete_range                          8.00       +5.88%       0.50     
7.00   10.00    8.50    0.74
innodb  delete_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  drop_index                            3.00       +1.64%       0.05     
2.00    4.00    3.05    0.50
innodb  drop_table_when_MANY_tables          19.00       -3.26%      -0.60    
17.00   19.00   18.40    0.66
innodb  insert                              112.00       +1.45%       1.65   
111.00  117.00  113.65    1.39
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                    20.00       -3.63%      -0.70    
19.00   20.00   19.30    0.46
innodb  insert_key                          275.00       +1.24%       3.45   
260.00  296.00  278.45    9.21
innodb  insert_many_fields                    6.00       -8.11%      -0.45     
5.00    6.00    5.55    0.50
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   5.00      -26.58%      -1.05     
3.00    5.00    3.95    0.38
innodb  insert_select_2_keys                  6.00       +3.23%       0.20     
5.00    7.00    6.20    0.68
innodb  min_max                               9.00      -18.42%      -1.40     
6.00    9.00    7.60    1.11
innodb  min_max_on_key                       24.00       +2.04%       0.50    
24.00   25.00   24.50    0.50
innodb  multiple_value_insert                 6.00       +5.51%       0.35     
5.00    8.00    6.35    0.73
innodb  once_prepared_select                 29.00       -0.17%      -0.05    
28.00   30.00   28.95    0.50
innodb  order_by_big                         15.00       -5.63%      -0.80    
12.00   15.00   14.20    0.98
innodb  order_by_big_key                     14.00       -2.56%      -0.35    
12.00   16.00   13.65    1.19
innodb  order_by_big_key2                    14.00       -7.69%      -1.00    
11.00   14.00   13.00    1.00
innodb  order_by_big_key_desc                15.00       -2.04%      -0.30    
13.00   16.00   14.70    0.90
innodb  order_by_big_key_diff                13.00       -0.00%       0.00    
11.00   15.00   13.00    0.89
innodb  order_by_big_key_prefix              13.00       -0.00%       0.00    
12.00   15.00   13.00    0.84
innodb  order_by_key2_diff                    2.00      -29.03%      -0.45     
1.00    2.00    1.55    0.50
innodb  order_by_key_prefix                   0.00     +100.00%       0.85     
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                           25.00      -11.11%      -2.50    
17.00   25.00   22.50    2.13
innodb  outer_join_found                     24.00      -10.60%      -2.30    
17.00   24.00   21.70    2.00
innodb  outer_join_not_found                 21.00       -6.33%      -1.25    
16.00   25.00   19.75    2.17
innodb  outer_join_on_key                    17.00      -14.09%      -2.10    
12.00   17.00   14.90    1.37
innodb  prepared_select                      37.00       -0.82%      -0.30    
36.00   38.00   36.70    0.56
innodb  select_1_row                          4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
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      -12.68%      -0.45     
3.00    4.00    3.55    0.50
innodb  select_big                           11.00      +10.20%       1.25    
11.00   15.00   12.25    1.09
innodb  select_big_str                        1.00      +33.33%       0.50     
1.00    2.00    1.50    0.50
innodb  select_cache                         64.00       -0.31%      -0.20    
60.00   72.00   63.80    2.91
innodb  select_cache2                        63.00       +1.79%       1.15    
58.00   73.00   64.15    3.53
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_diff_key                       0.00     +100.00%       0.30     
0.00    1.00    0.30    0.46
innodb  select_distinct                       4.00      +11.11%       0.50     
4.00    5.00    4.50    0.50
innodb  select_group                         19.00      -13.10%      -2.20    
15.00   19.00   16.80    1.50
innodb  select_group_when_MANY_tables        12.00       -0.42%      -0.05    
10.00   13.00   11.95    0.67
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           64.00       -0.16%      -0.10    
63.00   66.00   63.90    0.77
innodb  select_key2                          70.00       +0.64%       0.45    
69.00   72.00   70.45    0.74
innodb  select_key2_return_key               68.00       -0.00%       0.00    
67.00   70.00   68.00    0.77
innodb  select_key2_return_prim              69.00       -0.29%      -0.20    
67.00   71.00   68.80    0.87
innodb  select_key_prefix                    70.00       -0.07%      -0.05    
68.00   71.00   69.95    0.74
innodb  select_key_prefix_join                5.00       +1.96%       0.10     
5.00    6.00    5.10    0.30
innodb  select_key_return_key                64.00       -2.15%      -1.35    
61.00   64.00   62.65    0.79
innodb  select_many_fields                   13.00       +2.62%       0.35    
13.00   14.00   13.35    0.48
innodb  select_range                         47.00       -5.50%      -2.45    
39.00   49.00   44.55    3.02
innodb  select_range_key2                    10.00       -5.26%      -0.50     
9.00   10.00    9.50    0.50
innodb  select_range_prefix                   9.00       +1.64%       0.15     
8.00   10.00    9.15    0.65
innodb  select_simple                         2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00      -42.86%      -0.30     
0.00    1.00    0.70    0.46
innodb  update_autocommit                     3.00      +15.49%       0.55     
3.00    5.00    3.55    0.59
innodb  update_big                           58.00       +1.94%       1.15    
56.00   65.00   59.15    2.03
innodb  update_commit                         2.00       -5.26%      -0.10     
1.00    2.00    1.90    0.30
innodb  update_of_key                        22.00       +0.45%       0.10    
21.00   24.00   22.10    0.99
innodb  update_of_key_big                    18.00      +49.22%      17.45    
18.00   46.00   35.45    5.38
innodb  update_of_primary_key_many_keys    1236.00       +6.58%      87.00  
1182.00 1435.00 1323.00   59.97
innodb  update_rollback                       2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  update_with_key                     116.00       +3.89%       4.70   
115.00  125.00  120.70    2.78
innodb  update_with_key_prefix               46.00       -4.31%      -1.90    
41.00   47.00   44.10    1.76
innodb  wisc_benchmark                        3.00      -13.21%      -0.35     
2.00    3.00    2.65    0.48

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      34.00      -55.79%     -12.18    
11.00   61.00   21.82   10.17
innodb  alter_table_drop                     24.00      -27.96%      -5.24    
10.00   57.00   18.76    6.86
innodb  connect                               2.00       +4.25%       0.09     
1.00    3.00    2.09    0.42
innodb  connect+select_1_row                  3.00      -10.35%      -0.28     
2.00    5.00    2.72    0.46
innodb  connect+select_simple                 3.00      -26.75%      -0.63     
1.00    3.00    2.37    0.49
innodb  count                                18.00      -14.31%      -2.25    
12.00  193.00   15.75    8.53
innodb  count_distinct                        6.00       +8.87%       0.58     
5.00   50.00    6.58    2.20
innodb  count_distinct_2                     11.00      +16.83%       2.23    
11.00   63.00   13.23    2.88
innodb  count_distinct_big                   24.00       -9.08%      -2.00     
5.00   67.00   22.00    2.96
innodb  count_distinct_group                 15.00      -13.26%      -1.76    
10.00   68.00   13.24    3.02
innodb  count_distinct_group_on_key          10.00       -5.20%      -0.49     
7.00   69.00    9.51    2.93
innodb  count_distinct_group_on_key_parts    12.00       +3.06%       0.38     
9.00   72.00   12.38    3.07
innodb  count_distinct_key_prefix             6.00      -16.59%      -0.85     
3.00   52.00    5.15    2.31
innodb  count_group_on_key_parts             11.00       -9.48%      -0.95     
7.00   72.00   10.05    3.05
innodb  count_on_key                         97.00      -12.09%     -10.46    
68.00  107.00   86.54    7.43
innodb  create+drop                          34.00       -4.65%      -1.51    
18.00   75.00   32.49   11.48
innodb  create_index                          3.00       -3.28%      -0.10     
1.00    8.00    2.90    1.11
innodb  create_key+drop                      31.00       -9.13%      -2.59    
21.00   50.00   28.41    4.81
innodb  create_MANY_tables                   20.00      +39.67%      13.15    
14.00  121.00   33.15   16.84
innodb  create_table                          0.00     +100.00%       0.10     
0.00    3.00    0.10    0.35
innodb  delete_all_many_keys                987.00     -106.86%    -509.86   
212.00 1888.00  477.14  354.82
innodb  delete_autocommit                     3.00      +13.17%       0.46     
2.00   14.00    3.46    0.74
innodb  delete_big                            0.00     +100.00%       0.31     
0.00    3.00    0.31    0.47
innodb  delete_big_many_keys                986.00     -104.26%    -503.29   
212.00 2293.00  482.71  368.20
innodb  delete_commit                         2.00      -30.09%      -0.46     
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                          8.00       +3.95%       0.33     
5.00   23.00    8.33    3.13
innodb  delete_rollback                       2.00      -13.25%      -0.23     
1.00   12.00    1.77    0.89
innodb  drop_index                            3.00       -1.58%      -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          19.00       +2.60%       0.51    
11.00   90.00   19.51    7.28
innodb  insert                              112.00       -4.51%      -4.83     
3.00  343.00  107.17   14.20
innodb  insert_autocommit                     3.00       +0.36%       0.01     
2.00   99.00    3.01    3.20
innodb  insert_commit                         2.00      -41.89%      -0.59     
1.00    3.00    1.41    0.50
innodb  insert_duplicates                    20.00      -27.28%      -4.29    
11.00   21.00   15.71    2.73
innodb  insert_key                          275.00       +8.75%      26.36   
142.00  700.00  301.36  103.24
innodb  insert_many_fields                    6.00       -6.80%      -0.38     
3.00   17.00    5.62    1.72
innodb  insert_rollback                       2.00      -18.33%      -0.31     
1.00    3.00    1.69    0.53
innodb  insert_select_1_key                   5.00      -31.90%      -1.21     
2.00   10.00    3.79    0.87
innodb  insert_select_2_keys                  6.00       +1.30%       0.08     
4.00   16.00    6.08    2.03
innodb  min_max                               9.00      -15.11%      -1.18     
6.00  110.00    7.82    4.40
innodb  min_max_on_key                       24.00      -15.35%      -3.19    
14.00   37.00   20.81    3.14
innodb  multiple_value_insert                 6.00       -8.64%      -0.48     
2.00   50.00    5.52    4.15
innodb  once_prepared_select                 29.00      -18.23%      -4.47    
18.00   32.00   24.53    3.65
innodb  order_by_big                         15.00       -4.87%      -0.70    
12.00   31.00   14.30    1.51
innodb  order_by_big_key                     14.00       -5.05%      -0.67    
11.00   32.00   13.33    1.64
innodb  order_by_big_key2                    14.00      -14.37%      -1.76    
10.00   33.00   12.24    1.52
innodb  order_by_big_key_desc                15.00      -10.40%      -1.41    
11.00   32.00   13.59    1.68
innodb  order_by_big_key_diff                13.00       -5.88%      -0.72    
10.00   31.00   12.28    1.48
innodb  order_by_big_key_prefix              13.00       -4.51%      -0.56    
10.00   32.00   12.44    1.53
innodb  order_by_key2_diff                    2.00      -42.95%      -0.60     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   0.00     +100.00%       0.80     
0.00    2.00    0.80    0.41
innodb  order_by_range                        1.00      -19.58%      -0.16     
0.00    2.00    0.84    0.38
innodb  outer_join                           25.00      -28.09%      -5.48    
15.00   61.00   19.52    3.71
innodb  outer_join_found                     24.00      -26.82%      -5.07    
14.00   58.00   18.93    3.56
innodb  outer_join_not_found                 21.00      -26.13%      -4.35    
12.00   46.00   16.65    3.20
innodb  outer_join_on_key                    17.00      -30.51%      -3.97    
10.00   59.00   13.03    2.76
innodb  prepared_select                      37.00      -16.74%      -5.31    
22.00   40.00   31.69    4.58
innodb  select_1_row                          4.00      -38.12%      -1.10     
2.00    4.00    2.90    0.70
innodb  select_1_row_cache                    3.00       -9.78%      -0.27     
2.00    4.00    2.73    0.70
innodb  select_2_rows                         4.00      -36.69%      -1.07     
2.00    4.00    2.93    0.71
innodb  select_big                           11.00       +9.71%       1.18     
0.00   31.00   12.18    1.52
innodb  select_big_str                        1.00      +15.09%       0.18     
0.00    2.00    1.18    0.39
innodb  select_cache                         64.00       -6.88%      -4.12    
49.00   77.00   59.88    5.58
innodb  select_cache2                        63.00       -4.56%      -2.75    
49.00   75.00   60.25    6.21
innodb  select_column+column                  4.00      -34.25%      -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                       4.00       +6.05%       0.26     
3.00    8.00    4.26    0.55
innodb  select_group                         19.00      -16.61%      -2.71     
4.00  136.00   16.29    5.26
innodb  select_group_when_MANY_tables        12.00      -24.64%      -2.37     
3.00   49.00    9.63    9.16
innodb  select_join                           1.00      -72.71%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           64.00      -19.66%     -10.52    
40.00   66.00   53.48    7.71
innodb  select_key2                          70.00      -16.32%      -9.82    
45.00   75.00   60.18    8.49
innodb  select_key2_return_key               68.00      -18.23%     -10.48    
42.00   71.00   57.52    8.32
innodb  select_key2_return_prim              69.00      -18.39%     -10.72    
42.00   72.00   58.28    8.45
innodb  select_key_prefix                    70.00      -17.73%     -10.54    
44.00   75.00   59.46    8.54
innodb  select_key_prefix_join                5.00       -5.34%      -0.25     
3.00   10.00    4.75    0.65
innodb  select_key_return_key                64.00      -21.90%     -11.50    
38.00   65.00   52.50    7.70
innodb  select_many_fields                   13.00      +12.34%       1.83    
11.00   19.00   14.83    1.79
innodb  select_range                         47.00       -0.44%      -0.20    
38.00   76.00   46.80    4.07
innodb  select_range_key2                    10.00      -19.90%      -1.66     
6.00   11.00    8.34    1.06
innodb  select_range_prefix                   9.00      -13.53%      -1.07     
5.00   10.00    7.93    1.14
innodb  select_simple                         2.00      -19.53%      -0.33     
1.00    3.00    1.67    0.51
innodb  select_simple_cache                   2.00      -26.23%      -0.42     
1.00    3.00    1.58    0.51
innodb  select_simple_join                    1.00      -50.00%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     3.00      +10.39%       0.35     
2.00   16.00    3.35    0.99
innodb  update_big                           58.00      -12.59%      -6.48    
31.00  195.00   51.52   23.73
innodb  update_commit                         2.00      -26.01%      -0.41     
1.00   10.00    1.59    0.71
innodb  update_of_key                        22.00       +8.70%       2.10    
18.00  100.00   24.10    5.99
innodb  update_of_key_big                    18.00      +35.74%      10.01    
15.00   75.00   28.01   10.86
innodb  update_of_primary_key_many_keys    1236.00       +0.95%      11.83   
647.00 6065.00 1247.83  918.52
innodb  update_rollback                       2.00      -12.15%      -0.22     
1.00   31.00    1.78    1.84
innodb  update_with_key                     116.00       -4.89%      -5.41    
90.00  598.00  110.59   20.29
innodb  update_with_key_prefix               46.00      -15.20%      -6.07    
33.00  202.00   39.93    6.71
innodb  wisc_benchmark                        3.00      -20.92%      -0.52     
2.00    5.00    2.48    0.53

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

  2263.7.1: Laurynas Biveinis 2011-04-07 Port Percona's innodb_io_patches.patch

_______________________________________________
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