=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   946
RUN DATE: 2011-03-08T01:20:18.376121
SERVER:   drizzled
VERSION:  staging
REVISION: 2224
COMMENT:  2224: Monty Taylor 2011-03-07 [merge] Merge Olaf - XID and 
Dynamic_array refactoring

=========================================================================================================================
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       -5.04%      -1.20    
22.00   25.00   23.80    1.17
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      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  count                                18.00       -7.14%      -1.20    
14.00   18.00   16.80    1.47
innodb  count_distinct                        6.00      +11.76%       0.80     
6.00    8.00    6.80    0.75
innodb  count_distinct_2                     13.00       +4.41%       0.60    
13.00   15.00   13.60    0.80
innodb  count_distinct_big                   24.00      -10.09%      -2.20    
20.00   24.00   21.80    1.83
innodb  count_distinct_group                 13.00       +9.72%       1.40    
13.00   15.00   14.40    0.80
innodb  count_distinct_group_on_key           9.00       -0.00%       0.00     
8.00   10.00    9.00    0.63
innodb  count_distinct_group_on_key_parts    14.00       -9.38%      -1.20    
11.00   14.00   12.80    1.47
innodb  count_distinct_key_prefix             5.00       +7.41%       0.40     
5.00    6.00    5.40    0.49
innodb  count_group_on_key_parts             11.00       -3.77%      -0.40    
10.00   11.00   10.60    0.49
innodb  count_on_key                         92.00       -0.66%      -0.60    
90.00   92.00   91.40    0.80
innodb  create+drop                          33.00       -0.00%       0.00    
32.00   34.00   33.00    0.63
innodb  create_index                          3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  create_key+drop                      31.00       +1.27%       0.40    
31.00   32.00   31.40    0.49
innodb  create_MANY_tables                   20.00       +0.99%       0.20    
20.00   21.00   20.20    0.40
innodb  delete_all_many_keys                624.00       +0.54%       3.40   
608.00  663.00  627.40   18.74
innodb  delete_autocommit                     4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  delete_big                            1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  delete_big_many_keys                623.00       +0.57%       3.60   
608.00  662.00  626.60   18.53
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                         10.00      -13.64%      -1.20     
8.00   10.00    8.80    0.75
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            3.00       -0.00%       0.00     
2.00    4.00    3.00    0.63
innodb  drop_table_when_MANY_tables          18.00       -0.00%       0.00    
18.00   18.00   18.00    0.00
innodb  insert                              111.00       +1.77%       2.00   
111.00  114.00  113.00    1.10
innodb  insert_autocommit                     4.00      -25.00%      -0.80     
3.00    4.00    3.20    0.40
innodb  insert_commit                         1.00      +44.44%       0.80     
1.00    2.00    1.80    0.40
innodb  insert_duplicates                    20.00       -5.26%      -1.00    
18.00   20.00   19.00    0.63
innodb  insert_key                          273.00       +0.36%       1.00   
268.00  278.00  274.00    3.41
innodb  insert_many_fields                    7.00      -16.67%      -1.00     
5.00    7.00    6.00    0.63
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   4.00       +4.76%       0.20     
4.00    5.00    4.20    0.40
innodb  insert_select_2_keys                  7.00      -16.67%      -1.00     
5.00    7.00    6.00    0.63
innodb  min_max                               9.00       -7.14%      -0.60     
7.00    9.00    8.40    0.80
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       +0.68%       0.20    
29.00   30.00   29.20    0.40
innodb  order_by_big                         15.00       -5.63%      -0.80    
13.00   15.00   14.20    0.98
innodb  order_by_big_key                     13.00      +12.16%       1.80    
13.00   16.00   14.80    1.17
innodb  order_by_big_key2                    14.00       -6.06%      -0.80    
13.00   14.00   13.20    0.40
innodb  order_by_big_key_desc                13.00      +14.47%       2.20    
13.00   17.00   15.20    1.33
innodb  order_by_big_key_diff                13.00       -1.56%      -0.20    
12.00   13.00   12.80    0.40
innodb  order_by_big_key_prefix              14.00       -4.48%      -0.60    
13.00   14.00   13.40    0.49
innodb  order_by_key2_diff                    2.00      -66.67%      -0.80     
1.00    2.00    1.20    0.40
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                           18.00      +18.18%       4.00    
18.00   24.00   22.00    2.19
innodb  outer_join_found                     17.00      +19.81%       4.20    
17.00   23.00   21.20    2.23
innodb  outer_join_not_found                 16.00      +18.37%       3.60    
16.00   22.00   19.60    2.06
innodb  outer_join_on_key                    12.00      +17.81%       2.60    
12.00   16.00   14.60    1.50
innodb  prepared_select                      36.00       +2.70%       1.00    
36.00   38.00   37.00    0.63
innodb  select_1_row                          3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_1_row_cache                    4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  select_2_rows                         3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  select_big                           11.00       +9.84%       1.20    
11.00   15.00   12.20    1.60
innodb  select_big_str                        2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  select_cache                         60.00       +6.54%       4.20    
60.00   67.00   64.20    2.48
innodb  select_cache2                        63.00       +2.78%       1.80    
63.00   67.00   64.80    1.60
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_distinct                       5.00       -4.17%      -0.20     
4.00    5.00    4.80    0.40
innodb  select_group                         15.00       +8.54%       1.40    
15.00   19.00   16.40    1.74
innodb  select_group_when_MANY_tables        12.00       -0.00%       0.00    
12.00   12.00   12.00    0.00
innodb  select_join                           0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  select_key                           63.00       +1.25%       0.80    
63.00   64.00   63.80    0.40
innodb  select_key2                          70.00       +1.41%       1.00    
70.00   72.00   71.00    0.89
innodb  select_key2_return_key               67.00       +1.76%       1.20    
67.00   69.00   68.20    0.98
innodb  select_key2_return_prim              69.00       +0.86%       0.60    
69.00   70.00   69.60    0.49
innodb  select_key_prefix                    70.00       +1.41%       1.00    
70.00   72.00   71.00    0.89
innodb  select_key_prefix_join                5.00       -0.00%       0.00     
5.00    5.00    5.00    0.00
innodb  select_key_return_key                63.00       -0.00%       0.00    
63.00   63.00   63.00    0.00
innodb  select_many_fields                   13.00       +2.99%       0.40    
13.00   14.00   13.40    0.49
innodb  select_range                         39.00       +8.88%       3.80    
39.00   46.00   42.80    2.48
innodb  select_range_key2                    10.00       -0.00%       0.00    
10.00   10.00   10.00    0.00
innodb  select_range_prefix                   9.00       -0.00%       0.00     
9.00    9.00    9.00    0.00
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                           61.00       -3.39%      -2.00    
58.00   61.00   59.00    1.10
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        24.00       -1.69%      -0.40    
21.00   25.00   23.60    1.36
innodb  update_of_key_big                    38.00       -1.06%      -0.40    
31.00   45.00   37.60    4.45
innodb  update_of_primary_key_many_keys    1315.00       +0.24%       3.20  
1284.00 1346.00 1318.20   20.48
innodb  update_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  update_with_key                     125.00       -2.12%      -2.60   
119.00  126.00  122.40    2.94
innodb  update_with_key_prefix               46.00       -5.99%      -2.60    
41.00   46.00   43.40    1.85
innodb  wisc_benchmark                        3.00      -25.00%      -0.60     
2.00    3.00    2.40    0.49

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00       -0.76%      -0.25    
31.00   34.00   32.75    1.04
innodb  alter_table_drop                     25.00       -4.38%      -1.05    
22.00   26.00   23.95    0.97
innodb  connect                               2.00      +11.11%       0.25     
2.00    3.00    2.25    0.43
innodb  connect+select_1_row                  3.00       -3.45%      -0.10     
2.00    3.00    2.90    0.30
innodb  connect+select_simple                 3.00      -17.65%      -0.45     
2.00    3.00    2.55    0.50
innodb  count                                18.00      -10.09%      -1.65    
13.00   19.00   16.35    2.01
innodb  count_distinct                        6.00      +11.76%       0.80     
6.00    8.00    6.80    0.75
innodb  count_distinct_2                     13.00       +5.45%       0.75    
11.00   16.00   13.75    1.37
innodb  count_distinct_big                   24.00       -5.96%      -1.35    
20.00   25.00   22.65    1.82
innodb  count_distinct_group                 13.00      +11.56%       1.70    
13.00   16.00   14.70    0.84
innodb  count_distinct_group_on_key           9.00       +7.22%       0.70     
8.00   12.00    9.70    1.05
innodb  count_distinct_group_on_key_parts    14.00       -6.06%      -0.80    
11.00   15.00   13.20    1.08
innodb  count_distinct_key_prefix             5.00       +4.76%       0.25     
5.00    6.00    5.25    0.43
innodb  count_group_on_key_parts             11.00       -2.33%      -0.25    
10.00   11.00   10.75    0.43
innodb  count_on_key                         92.00       +0.05%       0.05    
89.00   95.00   92.05    1.66
innodb  create+drop                          33.00       +0.45%       0.15    
32.00   34.00   33.15    0.65
innodb  create_index                          3.00       +3.23%       0.10     
3.00    4.00    3.10    0.30
innodb  create_key+drop                      31.00       +1.43%       0.45    
30.00   33.00   31.45    0.74
innodb  create_MANY_tables                   20.00       +3.38%       0.70    
20.00   22.00   20.70    0.64
innodb  create_table                          0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  delete_all_many_keys                624.00       +3.33%      21.50   
580.00  721.00  645.50   33.86
innodb  delete_autocommit                     4.00       -8.11%      -0.30     
3.00    5.00    3.70    0.56
innodb  delete_big                            1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  delete_big_many_keys                623.00       +3.35%      21.60   
580.00  719.00  644.60   33.60
innodb  delete_commit                         2.00       -8.11%      -0.15     
1.00    2.00    1.85    0.36
innodb  delete_key                            3.00      -13.21%      -0.35     
2.00    3.00    2.65    0.48
innodb  delete_range                         10.00      -13.64%      -1.20     
8.00   10.00    8.80    0.60
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            3.00       -1.69%      -0.05     
2.00    4.00    2.95    0.50
innodb  drop_table                            0.00     +100.00%       0.10     
0.00    1.00    0.10    0.30
innodb  drop_table_when_MANY_tables          18.00       +3.49%       0.65    
17.00   22.00   18.65    1.06
innodb  insert                              111.00       +2.25%       2.55   
111.00  116.00  113.55    1.28
innodb  insert_autocommit                     4.00      -29.03%      -0.90     
3.00    4.00    3.10    0.30
innodb  insert_commit                         1.00      +47.37%       0.90     
1.00    2.00    1.90    0.30
innodb  insert_duplicates                    20.00       -4.71%      -0.90    
18.00   20.00   19.10    0.44
innodb  insert_key                          273.00       +1.78%       4.95   
263.00  300.00  277.95    8.94
innodb  insert_many_fields                    7.00      -16.67%      -1.00     
5.00    7.00    6.00    0.32
innodb  insert_rollback                       2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  insert_select_1_key                   4.00       -2.56%      -0.10     
3.00    5.00    3.90    0.54
innodb  insert_select_2_keys                  7.00      -12.00%      -0.75     
5.00    8.00    6.25    0.70
innodb  min_max                               9.00      -12.50%      -1.00     
7.00    9.00    8.00    0.95
innodb  min_max_on_key                       24.00       +2.24%       0.55    
24.00   26.00   24.55    0.59
innodb  multiple_value_insert                 6.00       +4.76%       0.30     
5.00    8.00    6.30    0.71
innodb  once_prepared_select                 29.00       +0.51%       0.15    
28.00   30.00   29.15    0.48
innodb  order_by_big                         15.00       -1.69%      -0.25    
13.00   16.00   14.75    0.94
innodb  order_by_big_key                     13.00       +7.80%       1.10    
12.00   16.00   14.10    1.30
innodb  order_by_big_key2                    14.00       -8.11%      -1.05    
11.00   15.00   12.95    0.92
innodb  order_by_big_key_desc                13.00      +11.86%       1.75    
13.00   17.00   14.75    1.26
innodb  order_by_big_key_diff                13.00       -0.00%       0.00    
11.00   14.00   13.00    0.84
innodb  order_by_big_key_prefix              14.00       -5.66%      -0.75    
12.00   14.00   13.25    0.62
innodb  order_by_key2_diff                    2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
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       -5.26%      -0.05     
0.00    1.00    0.95    0.22
innodb  outer_join                           18.00      +16.67%       3.60    
17.00   24.00   21.60    2.48
innodb  outer_join_found                     17.00      +17.68%       3.65    
16.00   23.00   20.65    2.50
innodb  outer_join_not_found                 16.00      +15.79%       3.00    
15.00   23.00   19.00    2.47
innodb  outer_join_on_key                    12.00      +17.53%       2.55    
11.00   17.00   14.55    1.66
innodb  prepared_select                      36.00       +2.83%       1.05    
36.00   38.00   37.05    0.59
innodb  select_1_row                          3.00      +14.29%       0.50     
3.00    4.00    3.50    0.50
innodb  select_1_row_cache                    4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
innodb  select_2_rows                         3.00      +17.81%       0.65     
3.00    4.00    3.65    0.48
innodb  select_big                           11.00      +12.00%       1.50    
11.00   15.00   12.50    1.20
innodb  select_big_str                        2.00      -53.85%      -0.70     
1.00    2.00    1.30    0.46
innodb  select_cache                         60.00       +4.91%       3.10    
57.00   67.00   63.10    2.51
innodb  select_cache2                        63.00       +0.32%       0.20    
57.00   68.00   63.20    2.94
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.25     
0.00    1.00    0.25    0.43
innodb  select_distinct                       5.00       -9.89%      -0.45     
4.00    5.00    4.55    0.50
innodb  select_group                         15.00       +7.12%       1.15    
15.00   19.00   16.15    1.49
innodb  select_group_when_MANY_tables        12.00       -1.27%      -0.15    
11.00   13.00   11.85    0.65
innodb  select_join                           0.00     +100.00%       0.50     
0.00    1.00    0.50    0.50
innodb  select_key                           63.00       +1.33%       0.85    
63.00   66.00   63.85    0.65
innodb  select_key2                          70.00       +1.06%       0.75    
69.00   73.00   70.75    1.04
innodb  select_key2_return_key               67.00       +1.76%       1.20    
67.00   70.00   68.20    0.81
innodb  select_key2_return_prim              69.00       +0.07%       0.05    
67.00   71.00   69.05    0.92
innodb  select_key_prefix                    70.00       +0.50%       0.35    
69.00   72.00   70.35    1.01
innodb  select_key_prefix_join                5.00       +0.99%       0.05     
5.00    6.00    5.05    0.22
innodb  select_key_return_key                63.00       -0.32%      -0.20    
62.00   64.00   62.80    0.68
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         39.00       +8.02%       3.40    
39.00   46.00   42.40    2.48
innodb  select_range_key2                    10.00       -5.26%      -0.50     
8.00   10.00    9.50    0.59
innodb  select_range_prefix                   9.00       +1.10%       0.10     
8.00   10.00    9.10    0.62
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_join                    1.00       -5.26%      -0.05     
0.00    1.00    0.95    0.22
innodb  update_autocommit                     4.00       -5.26%      -0.20     
3.00    5.00    3.80    0.51
innodb  update_big                           61.00       -4.27%      -2.50    
55.00   62.00   58.50    1.50
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        24.00       -6.67%      -1.50    
21.00   25.00   22.50    1.20
innodb  update_of_key_big                    38.00       -3.83%      -1.40    
31.00   45.00   36.60    3.34
innodb  update_of_primary_key_many_keys    1315.00       +0.92%      12.20  
1217.00 1465.00 1327.20   58.99
innodb  update_rollback                       2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  update_with_key                     125.00       -3.52%      -4.25   
115.00  126.00  120.75    2.53
innodb  update_with_key_prefix               46.00       -4.19%      -1.85    
41.00   48.00   44.15    1.96
innodb  wisc_benchmark                        3.00      -20.00%      -0.50     
2.00    3.00    2.50    0.50

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00      -55.12%     -11.73    
11.00   61.00   21.27   10.13
innodb  alter_table_drop                     25.00      -35.14%      -6.50    
10.00   57.00   18.50    6.94
innodb  connect                               2.00       +3.99%       0.08     
1.00    3.00    2.08    0.42
innodb  connect+select_1_row                  3.00      -10.95%      -0.30     
2.00    5.00    2.70    0.47
innodb  connect+select_simple                 3.00      -27.62%      -0.65     
1.00    3.00    2.35    0.48
innodb  count                                18.00      -14.26%      -2.25    
12.00  193.00   15.75    8.74
innodb  count_distinct                        6.00       +8.71%       0.57     
5.00   50.00    6.57    2.25
innodb  count_distinct_2                     13.00       +1.52%       0.20    
11.00   63.00   13.20    2.93
innodb  count_distinct_big                   24.00       -9.37%      -2.06     
5.00   67.00   21.94    3.00
innodb  count_distinct_group                 13.00       +1.33%       0.18    
10.00   68.00   13.18    3.07
innodb  count_distinct_group_on_key           9.00       +5.28%       0.50     
7.00   69.00    9.50    2.99
innodb  count_distinct_group_on_key_parts    14.00      -13.44%      -1.66     
9.00   72.00   12.34    3.13
innodb  count_distinct_key_prefix             5.00       +2.49%       0.13     
3.00   52.00    5.13    2.36
innodb  count_group_on_key_parts             11.00      -10.03%      -1.00     
7.00   72.00   10.00    3.12
innodb  count_on_key                         92.00       -6.84%      -5.89    
68.00  107.00   86.11    7.36
innodb  create+drop                          33.00       -1.69%      -0.55    
18.00   75.00   32.45   11.77
innodb  create_index                          3.00       -3.62%      -0.10     
1.00    8.00    2.90    1.13
innodb  create_key+drop                      31.00       -9.71%      -2.74    
21.00   50.00   28.26    4.89
innodb  create_MANY_tables                   20.00      +40.83%      13.80    
14.00  121.00   33.80   17.03
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.36
innodb  delete_all_many_keys                624.00      -33.38%    -156.15   
212.00 1888.00  467.85  361.91
innodb  delete_autocommit                     4.00      -15.97%      -0.55     
2.00   14.00    3.45    0.75
innodb  delete_big                            1.00     -232.20%      -0.70     
0.00    3.00    0.30    0.47
innodb  delete_big_many_keys                623.00      -31.49%    -149.20   
212.00 2293.00  473.80  375.88
innodb  delete_commit                         2.00      -31.78%      -0.48     
1.00    5.00    1.52    0.53
innodb  delete_key                            3.00       +1.57%       0.05     
2.00   35.00    3.05    1.48
innodb  delete_range                         10.00      -20.20%      -1.68     
5.00   23.00    8.32    3.21
innodb  delete_rollback                       2.00      -14.72%      -0.26     
1.00   12.00    1.74    0.91
innodb  drop_index                            3.00       -1.70%      -0.05     
1.00    9.00    2.95    1.31
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    2.00    0.05    0.23
innodb  drop_table_when_MANY_tables          18.00       +7.96%       1.56    
11.00   90.00   19.56    7.46
innodb  insert                              111.00       -3.90%      -4.17     
3.00  343.00  106.83   14.48
innodb  insert_autocommit                     4.00      -33.28%      -1.00     
2.00   99.00    3.00    3.28
innodb  insert_commit                         1.00      +27.88%       0.39     
1.00    3.00    1.39    0.50
innodb  insert_duplicates                    20.00      -28.80%      -4.47    
11.00   21.00   15.53    2.67
innodb  insert_key                          273.00       +9.80%      29.67   
142.00  700.00  302.67  106.00
innodb  insert_many_fields                    7.00      -24.74%      -1.39     
3.00   17.00    5.61    1.76
innodb  insert_rollback                       2.00      -19.40%      -0.32     
1.00    3.00    1.68    0.53
innodb  insert_select_1_key                   4.00       -5.73%      -0.22     
2.00   10.00    3.78    0.88
innodb  insert_select_2_keys                  7.00      -15.22%      -0.92     
4.00   16.00    6.08    2.07
innodb  min_max                               9.00      -14.96%      -1.17     
6.00  110.00    7.83    4.50
innodb  min_max_on_key                       24.00      -16.42%      -3.39    
14.00   37.00   20.61    3.10
innodb  multiple_value_insert                 6.00       -9.68%      -0.53     
2.00   50.00    5.47    4.25
innodb  once_prepared_select                 29.00      -19.36%      -4.70    
18.00   32.00   24.30    3.60
innodb  order_by_big                         15.00       -4.76%      -0.68    
12.00   31.00   14.32    1.52
innodb  order_by_big_key                     13.00       +2.23%       0.30    
11.00   32.00   13.30    1.64
innodb  order_by_big_key2                    14.00      -14.60%      -1.78    
10.00   33.00   12.22    1.54
innodb  order_by_big_key_desc                13.00       +3.88%       0.53    
11.00   32.00   13.53    1.69
innodb  order_by_big_key_diff                13.00       -6.18%      -0.76    
10.00   31.00   12.24    1.50
innodb  order_by_big_key_prefix              14.00      -12.75%      -1.58    
10.00   32.00   12.42    1.55
innodb  order_by_key2_diff                    2.00      -43.14%      -0.60     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   0.00     +100.00%       0.79     
0.00    2.00    0.79    0.41
innodb  order_by_range                        1.00      -20.00%      -0.17     
0.00    2.00    0.83    0.38
innodb  outer_join                           18.00       +7.09%       1.37    
15.00   61.00   19.37    3.71
innodb  outer_join_found                     17.00       +9.55%       1.79    
14.00   58.00   18.79    3.57
innodb  outer_join_not_found                 16.00       +3.04%       0.50    
12.00   46.00   16.50    3.18
innodb  outer_join_on_key                    12.00       +7.20%       0.93    
10.00   59.00   12.93    2.77
innodb  prepared_select                      36.00      -14.58%      -4.58    
22.00   40.00   31.42    4.53
innodb  select_1_row                          3.00       -4.81%      -0.14     
2.00    4.00    2.86    0.69
innodb  select_1_row_cache                    4.00      -48.44%      -1.31     
2.00    4.00    2.69    0.69
innodb  select_2_rows                         3.00       -3.82%      -0.11     
2.00    4.00    2.89    0.70
innodb  select_big                           11.00       +9.60%       1.17     
0.00   31.00   12.17    1.54
innodb  select_big_str                        2.00      -71.34%      -0.83     
0.00    2.00    1.17    0.38
innodb  select_cache                         60.00       -0.50%      -0.30    
49.00   77.00   59.70    5.62
innodb  select_cache2                        63.00       -4.93%      -2.96    
49.00   75.00   60.04    6.25
innodb  select_column+column                  4.00      -36.18%      -1.06     
2.00    4.00    2.94    0.72
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.41
innodb  select_distinct                       5.00      -17.88%      -0.76     
3.00    8.00    4.24    0.55
innodb  select_group                         15.00       +7.77%       1.26     
4.00  136.00   16.26    5.39
innodb  select_group_when_MANY_tables        12.00      -26.22%      -2.49     
3.00   49.00    9.51    9.38
innodb  select_join                           0.00     +100.00%       0.58     
0.00    1.00    0.58    0.49
innodb  select_key                           63.00      -19.01%     -10.06    
40.00   66.00   52.94    7.52
innodb  select_key2                          70.00      -17.39%     -10.37    
45.00   75.00   59.63    8.35
innodb  select_key2_return_key               67.00      -17.63%     -10.04    
42.00   71.00   56.96    8.15
innodb  select_key2_return_prim              69.00      -19.54%     -11.28    
42.00   72.00   57.72    8.30
innodb  select_key_prefix                    70.00      -18.86%     -11.11    
44.00   75.00   58.89    8.38
innodb  select_key_prefix_join                5.00       -5.81%      -0.27     
3.00   10.00    4.73    0.65
innodb  select_key_return_key                63.00      -21.24%     -11.04    
38.00   65.00   51.96    7.53
innodb  select_many_fields                   13.00      +12.83%       1.91    
11.00   19.00   14.91    1.79
innodb  select_range                         39.00      +16.97%       7.97    
38.00   76.00   46.97    4.03
innodb  select_range_key2                    10.00      -20.78%      -1.72     
6.00   11.00    8.28    1.05
innodb  select_range_prefix                   9.00      -14.51%      -1.14     
5.00   10.00    7.86    1.12
innodb  select_simple                         2.00      -21.02%      -0.35     
1.00    3.00    1.65    0.51
innodb  select_simple_cache                   2.00      -27.99%      -0.44     
1.00    3.00    1.56    0.51
innodb  select_simple_join                    1.00      -51.12%      -0.34     
0.00    3.00    0.66    0.48
innodb  update_autocommit                     4.00      -19.81%      -0.66     
2.00   16.00    3.34    1.01
innodb  update_big                           61.00      -19.34%      -9.88    
31.00  195.00   51.12   24.28
innodb  update_commit                         2.00      -27.38%      -0.43     
1.00   10.00    1.57    0.72
innodb  update_of_key                        24.00       +0.84%       0.20    
18.00  100.00   24.20    6.12
innodb  update_of_key_big                    38.00      -37.70%     -10.40    
15.00   75.00   27.60   10.94
innodb  update_of_primary_key_many_keys    1315.00       -5.84%     -72.59   
647.00 6065.00 1242.41  948.59
innodb  update_rollback                       2.00      -13.31%      -0.23     
1.00   31.00    1.77    1.88
innodb  update_with_key                     125.00      -13.59%     -14.95    
90.00  598.00  110.05   20.66
innodb  update_with_key_prefix               46.00      -15.84%      -6.29    
33.00  202.00   39.71    6.80
innodb  wisc_benchmark                        3.00      -21.41%      -0.53     
2.00    5.00    2.47    0.53

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

  2223.1.3: Monty Taylor 2011-03-07 [merge] Merge Olaf - Refactor DYNAMIC_ARRAY
    2221.7.6: Olaf van der Spek 2011-03-07 Remove unused includes
    2221.7.5: Olaf van der Spek 2011-03-07 Refactor
    2221.7.4: Olaf van der Spek 2011-03-06 Refactor
    2221.7.3: Olaf van der Spek 2011-03-06 Refactor
    2221.7.2: Olaf van der Spek 2011-03-06 Refactor
    2221.7.1: Olaf van der Spek 2011-03-06 DYNAMIC_ARRAY::size()
  2223.1.2: Monty Taylor 2011-03-07 [merge] Merged Andrew- Optimizer bugfixes
    2131.13.2: Andrew Hutchings 2011-03-07 [merge] Merge trunk into branch
    2131.13.1: Andrew Hutchings 2011-01-31 Backport fix from 
http://bugs.mysql.com/bug.php?id=58818
  2223.1.1: Monty Taylor 2011-03-07 [merge] Merged Olaf - Refactor XID cache.
    2221.6.3: Olaf van der Spek 2011-03-07 Remove (apparently) unused XID cache
    2221.6.2: Olaf van der Spek 2011-03-07 Refactor
    2221.6.1: Olaf van der Spek 2011-03-07 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