=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   890
RUN DATE: 2011-02-12T01:03:47.788965
SERVER:   drizzled
VERSION:  staging
REVISION: 2160
COMMENT:  2160: Lee Bieber 2011-02-12 [merge] Merge Brian - fixes for union

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00       -0.00%       0.00    
32.00   34.00   33.00    0.63
innodb  alter_table_drop                     25.00       -3.31%      -0.80    
23.00   25.00   24.20    0.75
innodb  connect                               2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  connect+select_1_row                  3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  connect+select_simple                 3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  count                                15.00       +3.85%       0.60    
14.00   18.00   15.60    1.62
innodb  count_distinct                        6.00      +14.29%       1.00     
6.00    8.00    7.00    0.63
innodb  count_distinct_2                     13.00       +4.41%       0.60    
13.00   15.00   13.60    0.80
innodb  count_distinct_big                   25.00       -8.70%      -2.00    
21.00   25.00   23.00    1.67
innodb  count_distinct_group                 14.00       +2.78%       0.40    
13.00   16.00   14.40    1.02
innodb  count_distinct_group_on_key           9.00       +8.16%       0.80     
9.00   10.00    9.80    0.40
innodb  count_distinct_group_on_key_parts    12.00       +7.69%       1.00    
12.00   14.00   13.00    0.63
innodb  count_distinct_key_prefix             4.00      +20.00%       1.00     
4.00    6.00    5.00    0.63
innodb  count_group_on_key_parts             11.00       -1.85%      -0.20    
10.00   11.00   10.80    0.40
innodb  count_on_key                         92.00       +1.29%       1.20    
91.00   95.00   93.20    1.47
innodb  create+drop                          31.00       +3.73%       1.20    
31.00   34.00   32.20    1.17
innodb  create_index                          3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  create_key+drop                      28.00       +2.78%       0.80    
28.00   30.00   28.80    0.75
innodb  create_MANY_tables                   21.00       -1.94%      -0.40    
20.00   21.00   20.60    0.49
innodb  create_table                          0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_all_many_keys                709.00       -5.60%     -37.60   
583.00  738.00  671.40   52.73
innodb  delete_autocommit                     3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  delete_big                            1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                708.00       -5.58%     -37.40   
582.00  737.00  670.60   52.73
innodb  delete_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  delete_key                            3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  delete_range                          8.00       +9.09%       0.80     
8.00   10.00    8.80    0.75
innodb  delete_rollback                       2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  drop_index                            3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  drop_table_when_MANY_tables          17.00       -6.25%      -1.00    
15.00   17.00   16.00    0.63
innodb  insert                              116.00       -0.52%      -0.60   
115.00  116.00  115.40    0.49
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.04%       0.20    
19.00   20.00   19.20    0.40
innodb  insert_key                          295.00       -3.07%      -8.80   
266.00  302.00  286.20   12.46
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                   3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  insert_select_2_keys                  8.00      -14.29%      -1.00     
6.00    8.00    7.00    0.89
innodb  min_max                               9.00      -15.38%      -1.20     
7.00    9.00    7.80    0.75
innodb  min_max_on_key                       25.00       -1.63%      -0.40    
24.00   25.00   24.60    0.49
innodb  multiple_value_insert                 6.00       +3.23%       0.20     
5.00    8.00    6.20    0.98
innodb  once_prepared_select                 29.00       +1.36%       0.40    
29.00   30.00   29.40    0.49
innodb  order_by_big                         13.00       +2.99%       0.40    
13.00   15.00   13.40    0.80
innodb  order_by_big_key                     13.00       +7.14%       1.00    
13.00   15.00   14.00    0.89
innodb  order_by_big_key2                    14.00       -6.06%      -0.80    
12.00   14.00   13.20    0.75
innodb  order_by_big_key_desc                15.00       -0.00%       0.00    
14.00   16.00   15.00    0.63
innodb  order_by_big_key_diff                14.00       -4.48%      -0.60    
12.00   14.00   13.40    0.80
innodb  order_by_big_key_prefix              14.00       -2.94%      -0.40    
13.00   14.00   13.60    0.49
innodb  order_by_key2_diff                    1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  order_by_key_prefix                   1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           25.00      -14.68%      -3.20    
17.00   25.00   21.80    3.25
innodb  outer_join_found                     24.00      -16.50%      -3.40    
16.00   24.00   20.60    3.07
innodb  outer_join_not_found                 22.00      -13.40%      -2.60    
15.00   22.00   19.40    2.87
innodb  outer_join_on_key                    17.00      -18.06%      -2.60    
11.00   17.00   14.40    2.15
innodb  prepared_select                      37.00       +0.54%       0.20    
37.00   38.00   37.20    0.40
innodb  select_1_row                          3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  select_1_row_cache                    4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_2_rows                         3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  select_big                           12.00       +3.23%       0.40    
12.00   14.00   12.40    0.80
innodb  select_big_str                        1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  select_cache                         57.00       +5.63%       3.40    
57.00   64.00   60.40    3.14
innodb  select_cache2                        60.00       +2.91%       1.80    
60.00   65.00   61.80    1.94
innodb  select_column+column                  4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_diff_key                       1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  select_distinct                       5.00       -4.17%      -0.20     
4.00    5.00    4.80    0.40
innodb  select_group                         18.00       -1.12%      -0.20    
16.00   19.00   17.80    0.98
innodb  select_group_when_MANY_tables        12.00       +1.64%       0.20    
11.00   14.00   12.20    1.17
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           63.00       +0.63%       0.40    
63.00   64.00   63.40    0.49
innodb  select_key2                          70.00       +1.69%       1.20    
70.00   73.00   71.20    1.17
innodb  select_key2_return_key               68.00       +0.29%       0.20    
67.00   69.00   68.20    0.75
innodb  select_key2_return_prim              68.00       +2.02%       1.40    
68.00   71.00   69.40    1.20
innodb  select_key_prefix                    70.00       +0.57%       0.40    
69.00   71.00   70.40    0.80
innodb  select_key_prefix_join                5.00       +7.41%       0.40     
5.00    6.00    5.40    0.49
innodb  select_key_return_key                63.00       -0.00%       0.00    
62.00   64.00   63.00    0.63
innodb  select_many_fields                   14.00       -6.06%      -0.80    
13.00   14.00   13.20    0.40
innodb  select_range                         42.00       +0.47%       0.20    
41.00   44.00   42.20    1.17
innodb  select_range_key2                    10.00       -4.17%      -0.40     
9.00   10.00    9.60    0.49
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                    0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  update_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  update_big                           58.00       +2.36%       1.40    
56.00   63.00   59.40    3.01
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        23.00       -3.60%      -0.80    
21.00   23.00   22.20    0.98
innodb  update_of_key_big                    36.00       -7.14%      -2.40    
31.00   36.00   33.60    2.24
innodb  update_of_primary_key_many_keys    1426.00       -5.19%     -70.40  
1218.00 1466.00 1355.60   87.06
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     118.00       +3.44%       4.20   
118.00  125.00  122.20    2.40
innodb  update_with_key_prefix               43.00       +0.92%       0.40    
42.00   45.00   43.40    1.02
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                      33.00       -1.85%      -0.60    
31.00   34.00   32.40    0.86
innodb  alter_table_drop                     25.00       -3.52%      -0.85    
23.00   25.00   24.15    0.73
innodb  connect                               2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  connect+select_1_row                  3.00       -1.69%      -0.05     
2.00    3.00    2.95    0.22
innodb  connect+select_simple                 3.00      -11.11%      -0.30     
2.00    3.00    2.70    0.46
innodb  count                                15.00       +4.15%       0.65    
13.00   18.00   15.65    1.71
innodb  count_distinct                        6.00       +9.09%       0.60     
6.00    8.00    6.60    0.73
innodb  count_distinct_2                     13.00       +6.14%       0.85    
12.00   16.00   13.85    1.11
innodb  count_distinct_big                   25.00       -8.93%      -2.05    
20.00   25.00   22.95    1.80
innodb  count_distinct_group                 14.00       +3.11%       0.45    
13.00   16.00   14.45    0.86
innodb  count_distinct_group_on_key           9.00       +9.55%       0.95     
8.00   12.00    9.95    0.97
innodb  count_distinct_group_on_key_parts    12.00       +9.77%       1.30    
11.00   14.00   13.30    0.78
innodb  count_distinct_key_prefix             4.00      +23.81%       1.25     
4.00    6.00    5.25    0.54
innodb  count_group_on_key_parts             11.00       -0.00%       0.00    
10.00   12.00   11.00    0.45
innodb  count_on_key                         92.00       +2.08%       1.95    
91.00   98.00   93.95    1.75
innodb  create+drop                          31.00       +2.21%       0.70    
30.00   34.00   31.70    1.19
innodb  create_index                          3.00       +4.76%       0.15     
2.00    4.00    3.15    0.48
innodb  create_key+drop                      28.00       +2.61%       0.75    
28.00   30.00   28.75    0.77
innodb  create_MANY_tables                   21.00       -1.94%      -0.40    
19.00   22.00   20.60    0.80
innodb  create_table                          0.00     +100.00%       0.15     
0.00    1.00    0.15    0.36
innodb  delete_all_many_keys                709.00       -6.42%     -42.75   
569.00  738.00  666.25   43.48
innodb  delete_autocommit                     3.00      +15.49%       0.55     
3.00    4.00    3.55    0.50
innodb  delete_big                            1.00      -81.82%      -0.45     
0.00    1.00    0.55    0.50
innodb  delete_big_many_keys                708.00       -6.40%     -42.60   
569.00  737.00  665.40   43.29
innodb  delete_commit                         2.00       -5.26%      -0.10     
1.00    2.00    1.90    0.30
innodb  delete_key                            3.00       -7.14%      -0.20     
2.00    4.00    2.80    0.60
innodb  delete_range                          8.00       +8.05%       0.70     
8.00   10.00    8.70    0.71
innodb  delete_rollback                       2.00      +11.11%       0.25     
2.00    3.00    2.25    0.43
innodb  drop_index                            3.00       +7.69%       0.25     
3.00    4.00    3.25    0.43
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  drop_table_when_MANY_tables          17.00       -4.29%      -0.70    
15.00   17.00   16.30    0.56
innodb  insert                              116.00       -1.40%      -1.60   
112.00  116.00  114.40    1.20
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       +0.52%       0.10    
19.00   20.00   19.10    0.30
innodb  insert_key                          295.00       -3.44%      -9.80   
266.00  304.00  285.20   11.38
innodb  insert_many_fields                    6.00       -6.19%      -0.35     
5.00    6.00    5.65    0.48
innodb  insert_rollback                       2.00       -5.26%      -0.10     
1.00    2.00    1.90    0.30
innodb  insert_select_1_key                   3.00      +25.93%       1.05     
3.00    5.00    4.05    0.50
innodb  insert_select_2_keys                  8.00      -25.00%      -1.60     
6.00    8.00    6.40    0.66
innodb  min_max                               9.00      -17.65%      -1.35     
6.00    9.00    7.65    1.06
innodb  min_max_on_key                       25.00       -1.63%      -0.40    
24.00   26.00   24.60    0.58
innodb  multiple_value_insert                 6.00       +6.98%       0.45     
5.00    8.00    6.45    0.74
innodb  once_prepared_select                 29.00       +0.34%       0.10    
28.00   30.00   29.10    0.44
innodb  order_by_big                         13.00       +8.45%       1.20    
13.00   16.00   14.20    1.08
innodb  order_by_big_key                     13.00       +9.72%       1.40    
13.00   16.00   14.40    0.92
innodb  order_by_big_key2                    14.00       -7.69%      -1.00    
12.00   14.00   13.00    0.71
innodb  order_by_big_key_desc                15.00       +1.32%       0.20    
14.00   17.00   15.20    0.81
innodb  order_by_big_key_diff                14.00       -6.87%      -0.90    
12.00   14.00   13.10    0.77
innodb  order_by_big_key_prefix              14.00       -4.87%      -0.65    
12.00   15.00   13.35    0.79
innodb  order_by_key2_diff                    1.00      +31.03%       0.45     
1.00    2.00    1.45    0.50
innodb  order_by_key_prefix                   1.00      -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                           25.00      -13.38%      -2.95    
17.00   25.00   22.05    2.64
innodb  outer_join_found                     24.00      -12.15%      -2.60    
16.00   25.00   21.40    2.89
innodb  outer_join_not_found                 22.00      -15.18%      -2.90    
14.00   22.00   19.10    2.57
innodb  outer_join_on_key                    17.00      -14.09%      -2.10    
11.00   18.00   14.90    2.00
innodb  prepared_select                      37.00       +0.67%       0.25    
37.00   38.00   37.25    0.43
innodb  select_1_row                          3.00      +15.49%       0.55     
3.00    4.00    3.55    0.50
innodb  select_1_row_cache                    4.00      -15.94%      -0.55     
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                           12.00       +8.40%       1.10    
12.00   14.00   13.10    0.89
innodb  select_big_str                        1.00      +23.08%       0.30     
1.00    2.00    1.30    0.46
innodb  select_cache                         57.00       +8.29%       5.15    
57.00   67.00   62.15    2.82
innodb  select_cache2                        60.00       +3.61%       2.25    
57.00   67.00   62.25    2.34
innodb  select_column+column                  4.00       -3.90%      -0.15     
3.00    4.00    3.85    0.36
innodb  select_diff_key                       1.00     -233.33%      -0.70     
0.00    1.00    0.30    0.46
innodb  select_distinct                       5.00      -11.11%      -0.50     
4.00    5.00    4.50    0.50
innodb  select_group                         18.00       -4.65%      -0.80    
15.00   19.00   17.20    1.44
innodb  select_group_when_MANY_tables        12.00       +0.83%       0.10    
11.00   14.00   12.10    0.89
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           63.00       +0.63%       0.40    
62.00   65.00   63.40    0.66
innodb  select_key2                          70.00       +1.20%       0.85    
69.00   73.00   70.85    1.06
innodb  select_key2_return_key               68.00       +0.44%       0.30    
67.00   70.00   68.30    0.84
innodb  select_key2_return_prim              68.00       +1.73%       1.20    
68.00   71.00   69.20    0.98
innodb  select_key_prefix                    70.00       +0.78%       0.55    
69.00   72.00   70.55    0.92
innodb  select_key_prefix_join                5.00       +4.76%       0.25     
5.00    6.00    5.25    0.43
innodb  select_key_return_key                63.00       -0.24%      -0.15    
62.00   65.00   62.85    0.85
innodb  select_many_fields                   14.00       -6.46%      -0.85    
13.00   14.00   13.15    0.36
innodb  select_range                         42.00       +0.71%       0.30    
39.00   45.00   42.30    1.82
innodb  select_range_key2                    10.00       -4.71%      -0.45     
9.00   11.00    9.55    0.59
innodb  select_range_prefix                   9.00       +2.17%       0.20     
8.00   10.00    9.20    0.60
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                    0.00     +100.00%       0.70     
0.00    1.00    0.70    0.46
innodb  update_autocommit                     3.00      +18.92%       0.70     
3.00    4.00    3.70    0.46
innodb  update_big                           58.00       +2.77%       1.65    
56.00   64.00   59.65    2.37
innodb  update_commit                         2.00       -5.26%      -0.10     
1.00    2.00    1.90    0.30
innodb  update_of_key                        23.00       -3.37%      -0.75    
21.00   25.00   22.25    1.13
innodb  update_of_key_big                    36.00       +1.23%       0.45    
31.00   47.00   36.45    4.13
innodb  update_of_primary_key_many_keys    1426.00       -4.45%     -60.80  
1203.00 1482.00 1365.20   77.67
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     118.00       +3.24%       3.95   
117.00  127.00  121.95    2.62
innodb  update_with_key_prefix               43.00       +2.60%       1.15    
40.00   50.00   44.15    2.61
innodb  wisc_benchmark                        3.00      -17.65%      -0.45     
2.00    3.00    2.55    0.50

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00      -61.02%     -12.51    
11.00   61.00   20.49   10.00
innodb  alter_table_drop                     25.00      -37.87%      -6.87    
10.00   57.00   18.13    7.02
innodb  connect                               2.00       +3.75%       0.08     
1.00    3.00    2.08    0.42
innodb  connect+select_1_row                  3.00      -11.48%      -0.31     
2.00    5.00    2.69    0.48
innodb  connect+select_simple                 3.00      -28.64%      -0.67     
1.00    3.00    2.33    0.48
innodb  count                                15.00       +4.80%       0.76    
12.00  193.00   15.76    9.02
innodb  count_distinct                        6.00       +8.54%       0.56     
5.00   50.00    6.56    2.32
innodb  count_distinct_2                     13.00       +1.16%       0.15    
11.00   63.00   13.15    3.00
innodb  count_distinct_big                   25.00      -14.14%      -3.10     
5.00   67.00   21.90    3.06
innodb  count_distinct_group                 14.00       -6.95%      -0.91    
10.00   68.00   13.09    3.14
innodb  count_distinct_group_on_key           9.00       +4.84%       0.46     
7.00   69.00    9.46    3.06
innodb  count_distinct_group_on_key_parts    12.00       +2.21%       0.27     
9.00   72.00   12.27    3.21
innodb  count_distinct_key_prefix             4.00      +21.85%       1.12     
3.00   52.00    5.12    2.44
innodb  count_group_on_key_parts             11.00      -10.77%      -1.07     
7.00   72.00    9.93    3.21
innodb  count_on_key                         92.00       -7.48%      -6.40    
68.00  107.00   85.60    7.29
innodb  create+drop                          31.00       +4.37%       1.41    
18.00   75.00   32.41   12.17
innodb  create_index                          3.00       -4.49%      -0.13     
1.00    8.00    2.87    1.16
innodb  create_key+drop                      28.00       +0.21%       0.06    
21.00   50.00   28.06    4.98
innodb  create_MANY_tables                   21.00      +39.47%      13.69    
14.00  121.00   34.69   17.24
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.36
innodb  delete_all_many_keys                709.00      -55.86%    -254.12   
212.00 1888.00  454.88  371.18
innodb  delete_autocommit                     3.00      +12.57%       0.43     
2.00   14.00    3.43    0.75
innodb  delete_big                            1.00     -256.96%      -0.72     
0.00    3.00    0.28    0.46
innodb  delete_big_many_keys                708.00      -53.45%    -246.63   
212.00 2293.00  461.38  385.98
innodb  delete_commit                         2.00      -33.60%      -0.50     
1.00    5.00    1.50    0.53
innodb  delete_key                            3.00       +2.30%       0.07     
2.00   35.00    3.07    1.53
innodb  delete_range                          8.00       +3.42%       0.28     
5.00   23.00    8.28    3.31
innodb  delete_rollback                       2.00      -16.21%      -0.28     
1.00   12.00    1.72    0.93
innodb  drop_index                            3.00       -1.82%      -0.05     
1.00    9.00    2.95    1.35
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    2.00    0.05    0.23
innodb  drop_table_when_MANY_tables          17.00      +13.48%       2.65    
11.00   90.00   19.65    7.69
innodb  insert                              116.00       -9.06%      -9.64     
3.00  343.00  106.36   14.85
innodb  insert_autocommit                     3.00       -0.41%      -0.01     
2.00   99.00    2.99    3.39
innodb  insert_commit                         2.00      -47.53%      -0.64     
1.00    3.00    1.36    0.49
innodb  insert_duplicates                    19.00      -24.31%      -3.72    
11.00   21.00   15.28    2.58
innodb  insert_key                          295.00       +3.07%       9.36   
142.00  700.00  304.36  109.71
innodb  insert_many_fields                    6.00       -7.24%      -0.41     
3.00   17.00    5.59    1.81
innodb  insert_rollback                       2.00      -21.36%      -0.35     
1.00    3.00    1.65    0.54
innodb  insert_select_1_key                   3.00      +20.59%       0.78     
2.00   10.00    3.78    0.90
innodb  insert_select_2_keys                  8.00      -31.81%      -1.93     
4.00   16.00    6.07    2.13
innodb  min_max                               9.00      -15.04%      -1.18     
6.00  110.00    7.82    4.65
innodb  min_max_on_key                       25.00      -22.89%      -4.66    
14.00   37.00   20.34    3.02
innodb  multiple_value_insert                 6.00      -11.06%      -0.60     
2.00   50.00    5.40    4.38
innodb  once_prepared_select                 29.00      -21.03%      -5.04    
18.00   32.00   23.96    3.47
innodb  order_by_big                         13.00       +9.08%       1.30    
12.00   31.00   14.30    1.54
innodb  order_by_big_key                     13.00       +1.61%       0.21    
11.00   32.00   13.21    1.63
innodb  order_by_big_key2                    14.00      -15.23%      -1.85    
10.00   33.00   12.15    1.55
innodb  order_by_big_key_desc                15.00      -11.78%      -1.58    
11.00   32.00   13.42    1.67
innodb  order_by_big_key_diff                14.00      -14.87%      -1.81    
10.00   31.00   12.19    1.52
innodb  order_by_big_key_prefix              14.00      -13.32%      -1.65    
10.00   32.00   12.35    1.58
innodb  order_by_key2_diff                    1.00      +28.38%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -27.13%      -0.21     
0.00    2.00    0.79    0.42
innodb  order_by_range                        1.00      -21.12%      -0.17     
0.00    2.00    0.83    0.39
innodb  outer_join                           25.00      -30.12%      -5.79    
15.00   61.00   19.21    3.72
innodb  outer_join_found                     24.00      -28.69%      -5.35    
14.00   58.00   18.65    3.58
innodb  outer_join_not_found                 22.00      -34.67%      -5.66    
12.00   46.00   16.34    3.16
innodb  outer_join_on_key                    17.00      -32.60%      -4.18    
10.00   59.00   12.82    2.78
innodb  prepared_select                      37.00      -19.28%      -5.98    
22.00   40.00   31.02    4.41
innodb  select_1_row                          3.00       -6.38%      -0.18     
2.00    4.00    2.82    0.68
innodb  select_1_row_cache                    4.00      -51.66%      -1.36     
2.00    4.00    2.64    0.67
innodb  select_2_rows                         3.00       -5.66%      -0.16     
2.00    4.00    2.84    0.69
innodb  select_big                           12.00       +0.99%       0.12     
0.00   31.00   12.12    1.56
innodb  select_big_str                        1.00      +13.14%       0.15     
0.00    2.00    1.15    0.36
innodb  select_cache                         57.00       +4.08%       2.42    
49.00   77.00   59.42    5.62
innodb  select_cache2                        60.00       -0.25%      -0.15    
49.00   75.00   59.85    6.37
innodb  select_column+column                  4.00      -38.68%      -1.12     
2.00    4.00    2.88    0.70
innodb  select_diff_key                       1.00     -363.28%      -0.78     
0.00    1.00    0.22    0.41
innodb  select_distinct                       5.00      -18.41%      -0.78     
3.00    8.00    4.22    0.54
innodb  select_group                         18.00      -10.89%      -1.77     
4.00  136.00   16.23    5.55
innodb  select_group_when_MANY_tables        12.00      -28.59%      -2.67     
3.00   49.00    9.33    9.66
innodb  select_join                           1.00      -72.69%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           63.00      -20.72%     -10.81    
40.00   66.00   52.19    7.18
innodb  select_key2                          70.00      -18.93%     -11.14    
45.00   75.00   58.86    8.07
innodb  select_key2_return_key               68.00      -21.04%     -11.82    
42.00   70.00   56.18    7.84
innodb  select_key2_return_prim              68.00      -19.43%     -11.06    
42.00   72.00   56.94    8.00
innodb  select_key_prefix                    70.00      -20.50%     -11.91    
44.00   75.00   58.09    8.07
innodb  select_key_prefix_join                5.00       -6.37%      -0.30     
3.00   10.00    4.70    0.66
innodb  select_key_return_key                63.00      -23.01%     -11.78    
38.00   65.00   51.22    7.20
innodb  select_many_fields                   14.00       +6.85%       1.03    
11.00   19.00   15.03    1.79
innodb  select_range                         42.00      +11.22%       5.31    
39.00   76.00   47.31    3.89
innodb  select_range_key2                    10.00      -22.01%      -1.80     
6.00   11.00    8.20    1.02
innodb  select_range_prefix                   9.00      -15.87%      -1.23     
5.00   10.00    7.77    1.08
innodb  select_simple                         2.00      -22.96%      -0.37     
1.00    3.00    1.63    0.51
innodb  select_simple_cache                   2.00      -30.58%      -0.47     
1.00    3.00    1.53    0.52
innodb  select_simple_join                    0.00     +100.00%       0.65     
0.00    3.00    0.65    0.49
innodb  update_autocommit                     3.00       +9.48%       0.31     
2.00   16.00    3.31    1.03
innodb  update_big                           58.00      -14.66%      -7.42    
31.00  195.00   50.58   25.00
innodb  update_commit                         2.00      -29.70%      -0.46     
1.00   10.00    1.54    0.74
innodb  update_of_key                        23.00       +5.44%       1.32    
18.00  100.00   24.32    6.31
innodb  update_of_key_big                    36.00      -33.15%      -8.96    
15.00   75.00   27.04   11.04
innodb  update_of_primary_key_many_keys    1426.00      -15.59%    -192.35   
647.00 6065.00 1233.65  989.39
innodb  update_rollback                       2.00      -14.74%      -0.26     
1.00   31.00    1.74    1.94
innodb  update_with_key                     118.00       -8.00%      -8.75    
90.00  598.00  109.25   21.11
innodb  update_with_key_prefix               43.00       -9.19%      -3.62    
33.00  202.00   39.38    6.88
innodb  wisc_benchmark                        3.00      -21.39%      -0.53     
2.00    5.00    2.47    0.53

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

  2155.6.1: Brian Aker 2011-02-11 Fix for union.

_______________________________________________
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