=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   990
RUN DATE: 2011-04-05T10:01:26.268769
SERVER:   drizzled
VERSION:  staging
REVISION: 2268
COMMENT:  2268: Brian Aker 2011-04-04 [merge] Merge in access work.

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00       -1.23%      -0.40    
31.00   33.00   32.60    0.80
innodb  alter_table_drop                     23.00       +2.54%       0.60    
23.00   24.00   23.60    0.49
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       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  count                                14.00      +15.66%       2.60    
14.00   18.00   16.60    1.36
innodb  count_distinct                        8.00      -11.11%      -0.80     
6.00    8.00    7.20    0.75
innodb  count_distinct_2                     15.00       -4.17%      -0.60    
12.00   16.00   14.40    1.36
innodb  count_distinct_big                   21.00      +11.76%       2.80    
21.00   25.00   23.80    1.47
innodb  count_distinct_group                 14.00       -0.00%       0.00    
11.00   16.00   14.00    1.67
innodb  count_distinct_group_on_key           9.00       +8.16%       0.80     
9.00   12.00    9.80    1.17
innodb  count_distinct_group_on_key_parts    13.00       -1.56%      -0.20    
11.00   15.00   12.80    1.60
innodb  count_distinct_key_prefix             5.00      +10.71%       0.60     
5.00    7.00    5.60    0.80
innodb  count_group_on_key_parts             11.00       +1.79%       0.20    
11.00   12.00   11.20    0.40
innodb  count_on_key                         94.00       +3.89%       3.80    
94.00  102.00   97.80    2.71
innodb  create+drop                          33.00       +1.79%       0.60    
33.00   35.00   33.60    0.80
innodb  create_index                          3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  create_key+drop                      32.00       -1.27%      -0.40    
31.00   32.00   31.60    0.49
innodb  create_MANY_tables                   21.00       -2.94%      -0.60    
19.00   21.00   20.40    0.80
innodb  delete_all_many_keys                674.00       -3.82%     -24.80   
609.00  681.00  649.20   27.45
innodb  delete_autocommit                     4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  delete_big                            0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  delete_big_many_keys                674.00       -3.98%     -25.80   
608.00  680.00  648.20   27.80
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          9.00       -2.27%      -0.20     
8.00   10.00    8.80    0.75
innodb  delete_rollback                       3.00      -36.36%      -0.80     
2.00    3.00    2.20    0.40
innodb  drop_index                            3.00       -0.00%       0.00     
2.00    4.00    3.00    0.63
innodb  drop_table_when_MANY_tables          19.00       -2.15%      -0.40    
18.00   19.00   18.60    0.49
innodb  insert                              115.00       -0.52%      -0.60   
113.00  116.00  114.40    1.02
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                          296.00       -4.08%     -11.60   
272.00  296.00  284.40    9.83
innodb  insert_many_fields                    6.00       -3.45%      -0.20     
5.00    6.00    5.80    0.40
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  insert_select_2_keys                  5.00      +19.35%       1.20     
5.00    7.00    6.20    0.75
innodb  min_max                               7.00      +12.50%       1.00     
7.00    9.00    8.00    0.89
innodb  min_max_on_key                       24.00       +1.64%       0.40    
24.00   25.00   24.40    0.49
innodb  multiple_value_insert                 7.00       -0.00%       0.00     
6.00    8.00    7.00    0.63
innodb  once_prepared_select                 29.00       -0.00%       0.00    
29.00   29.00   29.00    0.00
innodb  order_by_big                         15.00       -2.74%      -0.40    
14.00   15.00   14.60    0.49
innodb  order_by_big_key                     13.00       +2.99%       0.40    
12.00   16.00   13.40    1.36
innodb  order_by_big_key2                    14.00       -6.06%      -0.80    
11.00   14.00   13.20    1.17
innodb  order_by_big_key_desc                14.00       +2.78%       0.40    
14.00   16.00   14.40    0.80
innodb  order_by_big_key_diff                14.00       -7.69%      -1.00    
12.00   14.00   13.00    0.63
innodb  order_by_big_key_prefix              12.00       +6.25%       0.80    
12.00   14.00   12.80    0.98
innodb  order_by_key2_diff                    1.00      +37.50%       0.60     
1.00    2.00    1.60    0.49
innodb  order_by_key_prefix                   1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  order_by_range                        1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  outer_join                           23.00       -0.88%      -0.20    
20.00   24.00   22.80    1.47
innodb  outer_join_found                     23.00       -5.50%      -1.20    
18.00   23.00   21.80    1.94
innodb  outer_join_not_found                 21.00       -3.96%      -0.80    
17.00   22.00   20.20    1.72
innodb  outer_join_on_key                    15.00       -0.00%       0.00    
13.00   17.00   15.00    1.41
innodb  prepared_select                      36.00       +1.64%       0.60    
36.00   37.00   36.60    0.49
innodb  select_1_row                          4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_1_row_cache                    3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  select_2_rows                         4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_big                           11.00       +9.84%       1.20    
11.00   13.00   12.20    0.98
innodb  select_big_str                        2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  select_cache                         63.00       +2.17%       1.40    
63.00   67.00   64.40    1.36
innodb  select_cache2                        63.00       +2.48%       1.60    
63.00   69.00   64.60    2.33
innodb  select_column+column                  3.00      +16.67%       0.60     
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       +9.09%       0.40     
4.00    5.00    4.40    0.49
innodb  select_group                         19.00      -10.47%      -1.80    
15.00   19.00   17.20    1.60
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.60     
0.00    1.00    0.60    0.49
innodb  select_key                           63.00       +1.56%       1.00    
63.00   65.00   64.00    0.63
innodb  select_key2                          69.00       +1.99%       1.40    
69.00   71.00   70.40    0.80
innodb  select_key2_return_key               67.00       +1.18%       0.80    
67.00   68.00   67.80    0.40
innodb  select_key2_return_prim              68.00       +0.58%       0.40    
68.00   69.00   68.40    0.49
innodb  select_key_prefix                    69.00       +1.43%       1.00    
69.00   71.00   70.00    0.63
innodb  select_key_prefix_join                6.00      -15.38%      -0.80     
5.00    6.00    5.20    0.40
innodb  select_key_return_key                61.00       +1.93%       1.20    
61.00   63.00   62.20    0.75
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         48.00       -9.09%      -4.00    
41.00   48.00   44.00    2.45
innodb  select_range_key2                     9.00       -0.00%       0.00     
9.00    9.00    9.00    0.00
innodb  select_range_prefix                   9.00       +4.26%       0.40     
9.00   10.00    9.40    0.49
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  update_autocommit                     4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  update_big                           62.00       -4.73%      -2.80    
58.00   62.00   59.20    1.47
innodb  update_commit                         1.00      +44.44%       0.80     
1.00    2.00    1.80    0.40
innodb  update_of_key                        22.00       -0.00%       0.00    
21.00   24.00   22.00    1.10
innodb  update_of_key_big                    32.00      +12.57%       4.60    
31.00   46.00   36.60    5.35
innodb  update_of_primary_key_many_keys    1435.00       -4.99%     -68.20  
1313.00 1435.00 1366.80   48.86
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     120.00       +0.83%       1.00   
118.00  125.00  121.00    2.61
innodb  update_with_key_prefix               41.00       +5.96%       2.60    
41.00   46.00   43.60    1.85
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.69%      -0.55    
31.00   35.00   32.45    0.92
innodb  alter_table_drop                     23.00       +3.16%       0.75    
22.00   26.00   23.75    1.04
innodb  connect                               2.00      +11.11%       0.25     
2.00    3.00    2.25    0.43
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 3.00      -13.21%      -0.35     
2.00    3.00    2.65    0.48
innodb  count                                14.00       +9.68%       1.50    
13.00   18.00   15.50    1.80
innodb  count_distinct                        8.00      -11.89%      -0.85     
6.00    8.00    7.15    0.65
innodb  count_distinct_2                     15.00       -8.70%      -1.20    
11.00   17.00   13.80    1.69
innodb  count_distinct_big                   21.00       +9.29%       2.15    
21.00   25.00   23.15    1.71
innodb  count_distinct_group                 14.00       +3.78%       0.55    
11.00   16.00   14.55    1.16
innodb  count_distinct_group_on_key           9.00       +5.26%       0.50     
8.00   12.00    9.50    1.07
innodb  count_distinct_group_on_key_parts    13.00       +0.38%       0.05    
11.00   15.00   13.05    1.36
innodb  count_distinct_key_prefix             5.00      +10.71%       0.60     
5.00    7.00    5.60    0.58
innodb  count_group_on_key_parts             11.00       -1.38%      -0.15    
10.00   12.00   10.85    0.48
innodb  count_on_key                         94.00       +1.52%       1.45    
91.00  102.00   95.45    2.56
innodb  create+drop                          33.00       +1.05%       0.35    
32.00   35.00   33.35    0.91
innodb  create_index                          3.00       -1.69%      -0.05     
2.00    4.00    2.95    0.38
innodb  create_key+drop                      32.00       -2.73%      -0.85    
30.00   32.00   31.15    0.73
innodb  create_MANY_tables                   21.00       -1.45%      -0.30    
19.00   24.00   20.70    1.14
innodb  delete_all_many_keys                674.00       -5.08%     -32.60   
582.00  705.00  641.40   29.97
innodb  delete_autocommit                     4.00       -9.59%      -0.35     
3.00    5.00    3.65    0.57
innodb  delete_big                            0.00     +100.00%       0.55     
0.00    1.00    0.55    0.50
innodb  delete_big_many_keys                674.00       -5.23%     -33.50   
581.00  704.00  640.50   30.06
innodb  delete_commit                         2.00       -5.26%      -0.10     
1.00    2.00    1.90    0.30
innodb  delete_key                            3.00       -5.26%      -0.15     
2.00    4.00    2.85    0.48
innodb  delete_range                          9.00       -4.65%      -0.40     
7.00   10.00    8.60    0.80
innodb  delete_rollback                       3.00      -42.86%      -0.90     
2.00    3.00    2.10    0.30
innodb  drop_index                            3.00       +1.64%       0.05     
2.00    4.00    3.05    0.59
innodb  drop_table_when_MANY_tables          19.00       -2.15%      -0.40    
17.00   21.00   18.60    0.80
innodb  insert                              115.00       -1.10%      -1.25   
111.00  116.00  113.75    1.26
innodb  insert_autocommit                     3.00       +7.69%       0.25     
3.00    4.00    3.25    0.43
innodb  insert_commit                         2.00      -17.65%      -0.30     
1.00    2.00    1.70    0.46
innodb  insert_duplicates                    19.00       +0.78%       0.15    
19.00   20.00   19.15    0.36
innodb  insert_key                          296.00       -5.54%     -15.55   
265.00  296.00  280.45    9.14
innodb  insert_many_fields                    6.00       -4.35%      -0.25     
5.00    7.00    5.75    0.54
innodb  insert_rollback                       2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  insert_select_1_key                   4.00       -2.56%      -0.10     
3.00    5.00    3.90    0.54
innodb  insert_select_2_keys                  5.00      +19.35%       1.20     
5.00    7.00    6.20    0.75
innodb  min_max                               7.00       +9.09%       0.70     
6.00    9.00    7.70    0.95
innodb  min_max_on_key                       24.00       +1.84%       0.45    
24.00   25.00   24.45    0.50
innodb  multiple_value_insert                 7.00       -6.06%      -0.40     
6.00    8.00    6.60    0.58
innodb  once_prepared_select                 29.00       +0.51%       0.15    
28.00   30.00   29.15    0.48
innodb  order_by_big                         15.00       -5.26%      -0.75    
13.00   15.00   14.25    0.89
innodb  order_by_big_key                     13.00       +3.70%       0.50    
12.00   16.00   13.50    1.16
innodb  order_by_big_key2                    14.00       -8.11%      -1.05    
11.00   14.00   12.95    0.97
innodb  order_by_big_key_desc                14.00       +2.10%       0.30    
13.00   16.00   14.30    0.95
innodb  order_by_big_key_diff                14.00       -6.87%      -0.90    
11.00   15.00   13.10    0.94
innodb  order_by_big_key_prefix              12.00       +7.69%       1.00    
12.00   15.00   13.00    0.95
innodb  order_by_key2_diff                    1.00      +33.33%       0.50     
1.00    2.00    1.50    0.50
innodb  order_by_key_prefix                   1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  order_by_range                        1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  outer_join                           23.00       -3.84%      -0.85    
18.00   24.00   22.15    1.80
innodb  outer_join_found                     23.00       -7.73%      -1.65    
17.00   23.00   21.35    1.90
innodb  outer_join_not_found                 21.00       -7.69%      -1.50    
16.00   25.00   19.50    2.09
innodb  outer_join_on_key                    15.00       -2.74%      -0.40    
12.00   17.00   14.60    1.32
innodb  prepared_select                      36.00       +2.17%       0.80    
36.00   38.00   36.80    0.51
innodb  select_1_row                          4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_1_row_cache                    3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  select_2_rows                         4.00       -9.59%      -0.35     
3.00    4.00    3.65    0.48
innodb  select_big                           11.00      +10.20%       1.25    
11.00   15.00   12.25    1.18
innodb  select_big_str                        2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  select_cache                         63.00       +0.55%       0.35    
60.00   72.00   63.35    2.92
innodb  select_cache2                        63.00       +1.64%       1.05    
58.00   73.00   64.05    3.19
innodb  select_column+column                  3.00      +22.08%       0.85     
3.00    4.00    3.85    0.36
innodb  select_diff_key                       0.00     +100.00%       0.25     
0.00    1.00    0.25    0.43
innodb  select_distinct                       4.00      +11.11%       0.50     
4.00    5.00    4.50    0.50
innodb  select_group                         19.00      -10.79%      -1.85    
15.00   19.00   17.15    1.46
innodb  select_group_when_MANY_tables        12.00       -1.69%      -0.20    
10.00   13.00   11.80    0.81
innodb  select_join                           0.00     +100.00%       0.75     
0.00    1.00    0.75    0.43
innodb  select_key                           63.00       +1.64%       1.05    
63.00   66.00   64.05    0.80
innodb  select_key2                          69.00       +2.27%       1.60    
69.00   72.00   70.60    0.80
innodb  select_key2_return_key               67.00       +1.76%       1.20    
67.00   70.00   68.20    0.87
innodb  select_key2_return_prim              68.00       +1.45%       1.00    
68.00   71.00   69.00    0.77
innodb  select_key_prefix                    69.00       +1.71%       1.20    
68.00   72.00   70.20    0.87
innodb  select_key_prefix_join                6.00      -15.38%      -0.80     
5.00    6.00    5.20    0.40
innodb  select_key_return_key                61.00       +2.87%       1.80    
61.00   64.00   62.80    0.68
innodb  select_many_fields                   13.00       +1.52%       0.20    
12.00   14.00   13.20    0.51
innodb  select_range                         48.00       -9.09%      -4.00    
39.00   49.00   44.00    3.19
innodb  select_range_key2                     9.00       +3.74%       0.35     
9.00   10.00    9.35    0.48
innodb  select_range_prefix                   9.00       +3.23%       0.30     
8.00   10.00    9.30    0.64
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      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  update_autocommit                     4.00       -9.59%      -0.35     
3.00    5.00    3.65    0.57
innodb  update_big                           62.00       -4.29%      -2.55    
56.00   65.00   59.45    1.96
innodb  update_commit                         1.00      +47.37%       0.90     
1.00    2.00    1.90    0.30
innodb  update_of_key                        22.00       -0.69%      -0.15    
21.00   24.00   21.85    0.91
innodb  update_of_key_big                    32.00      +11.36%       4.10    
30.00   46.00   36.10    3.78
innodb  update_of_primary_key_many_keys    1435.00       -7.23%     -96.80  
1228.00 1469.00 1338.20   57.92
innodb  update_rollback                       2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  update_with_key                     120.00       +0.99%       1.20   
117.00  127.00  121.20    2.44
innodb  update_with_key_prefix               41.00       +6.50%       2.85    
41.00   46.00   43.85    1.49
innodb  wisc_benchmark                        3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00      -51.68%     -11.24    
11.00   61.00   21.76   10.17
innodb  alter_table_drop                     23.00      -22.83%      -4.27    
10.00   57.00   18.73    6.87
innodb  connect                               2.00       +4.28%       0.09     
1.00    3.00    2.09    0.42
innodb  connect+select_1_row                  3.00      -10.43%      -0.28     
2.00    5.00    2.72    0.46
innodb  connect+select_simple                 3.00      -26.91%      -0.64     
1.00    3.00    2.36    0.49
innodb  count                                14.00      +11.07%       1.74    
12.00  193.00   15.74    8.56
innodb  count_distinct                        8.00      -21.50%      -1.42     
5.00   50.00    6.58    2.21
innodb  count_distinct_2                     15.00      -13.40%      -1.77    
11.00   63.00   13.23    2.88
innodb  count_distinct_big                   21.00       +4.52%       0.99     
5.00   67.00   21.99    2.97
innodb  count_distinct_group                 14.00       -5.77%      -0.76    
10.00   68.00   13.24    3.02
innodb  count_distinct_group_on_key           9.00       +5.29%       0.50     
7.00   69.00    9.50    2.93
innodb  count_distinct_group_on_key_parts    13.00       -5.03%      -0.62     
9.00   72.00   12.38    3.07
innodb  count_distinct_key_prefix             5.00       +2.84%       0.15     
3.00   52.00    5.15    2.32
innodb  count_group_on_key_parts             11.00       -9.58%      -0.96     
7.00   72.00   10.04    3.06
innodb  count_on_key                         94.00       -8.69%      -7.52    
68.00  107.00   86.48    7.42
innodb  create+drop                          33.00       -1.58%      -0.51    
18.00   75.00   32.49   11.51
innodb  create_index                          3.00       -3.34%      -0.10     
1.00    8.00    2.90    1.11
innodb  create_key+drop                      32.00      -12.73%      -3.61    
21.00   50.00   28.39    4.82
innodb  create_MANY_tables                   21.00      +36.82%      12.24    
14.00  121.00   33.24   16.86
innodb  create_table                          0.00     +100.00%       0.10     
0.00    3.00    0.10    0.35
innodb  delete_all_many_keys                674.00      -41.68%    -198.26   
212.00 1888.00  475.74  355.44
innodb  delete_autocommit                     4.00      -15.82%      -0.55     
2.00   14.00    3.45    0.74
innodb  delete_big                            0.00     +100.00%       0.31     
0.00    3.00    0.31    0.47
innodb  delete_big_many_keys                674.00      -40.02%    -192.65   
212.00 2293.00  481.35  368.90
innodb  delete_commit                         2.00      -30.35%      -0.47     
1.00    5.00    1.53    0.53
innodb  delete_key                            3.00       +1.26%       0.04     
2.00   35.00    3.04    1.46
innodb  delete_range                          9.00       -8.06%      -0.67     
5.00   23.00    8.33    3.14
innodb  delete_rollback                       3.00      -70.24%      -1.24     
1.00   12.00    1.76    0.89
innodb  drop_index                            3.00       -1.59%      -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.64%       0.52    
11.00   90.00   19.52    7.30
innodb  insert                              115.00       -7.35%      -7.87     
3.00  343.00  107.13   14.24
innodb  insert_autocommit                     3.00       +0.33%       0.01     
2.00   99.00    3.01    3.21
innodb  insert_commit                         2.00      -42.17%      -0.59     
1.00    3.00    1.41    0.50
innodb  insert_duplicates                    19.00      -21.11%      -3.31    
11.00   21.00   15.69    2.72
innodb  insert_key                          296.00       +1.85%       5.57   
142.00  700.00  301.57  103.58
innodb  insert_many_fields                    6.00       -6.79%      -0.38     
3.00   17.00    5.62    1.72
innodb  insert_rollback                       2.00      -18.48%      -0.31     
1.00    3.00    1.69    0.53
innodb  insert_select_1_key                   4.00       -5.56%      -0.21     
2.00   10.00    3.79    0.87
innodb  insert_select_2_keys                  5.00      +17.74%       1.08     
4.00   16.00    6.08    2.03
innodb  min_max                               7.00      +10.50%       0.82     
6.00  110.00    7.82    4.41
innodb  min_max_on_key                       24.00      -15.49%      -3.22    
14.00   37.00   20.78    3.14
innodb  multiple_value_insert                 7.00      -26.77%      -1.48     
2.00   50.00    5.52    4.16
innodb  once_prepared_select                 29.00      -18.35%      -4.50    
18.00   32.00   24.50    3.65
innodb  order_by_big                         15.00       -4.83%      -0.69    
12.00   31.00   14.31    1.51
innodb  order_by_big_key                     13.00       +2.40%       0.32    
11.00   32.00   13.32    1.64
innodb  order_by_big_key2                    14.00      -14.40%      -1.76    
10.00   33.00   12.24    1.52
innodb  order_by_big_key_desc                14.00       -3.10%      -0.42    
11.00   32.00   13.58    1.68
innodb  order_by_big_key_diff                14.00      -14.05%      -1.72    
10.00   31.00   12.28    1.48
innodb  order_by_big_key_prefix              12.00       +3.51%       0.44    
10.00   32.00   12.44    1.53
innodb  order_by_key2_diff                    1.00      +28.49%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -25.65%      -0.20     
0.00    2.00    0.80    0.41
innodb  order_by_range                        1.00      -19.74%      -0.16     
0.00    2.00    0.84    0.38
innodb  outer_join                           23.00      -17.96%      -3.50    
15.00   61.00   19.50    3.71
innodb  outer_join_found                     23.00      -21.64%      -4.09    
14.00   58.00   18.91    3.56
innodb  outer_join_not_found                 21.00      -26.27%      -4.37    
12.00   46.00   16.63    3.20
innodb  outer_join_on_key                    15.00      -15.26%      -1.99    
10.00   59.00   13.01    2.76
innodb  prepared_select                      36.00      -13.71%      -4.34    
22.00   40.00   31.66    4.57
innodb  select_1_row                          4.00      -38.36%      -1.11     
2.00    4.00    2.89    0.70
innodb  select_1_row_cache                    3.00       -9.94%      -0.27     
2.00    4.00    2.73    0.70
innodb  select_2_rows                         4.00      -36.91%      -1.08     
2.00    4.00    2.92    0.71
innodb  select_big                           11.00       +9.70%       1.18     
0.00   31.00   12.18    1.53
innodb  select_big_str                        2.00      -70.31%      -0.83     
0.00    2.00    1.17    0.38
innodb  select_cache                         63.00       -5.26%      -3.15    
49.00   77.00   59.85    5.58
innodb  select_cache2                        63.00       -4.60%      -2.77    
49.00   75.00   60.23    6.21
innodb  select_column+column                  3.00       -0.84%      -0.03     
2.00    4.00    2.97    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       +5.99%       0.25     
3.00    8.00    4.25    0.55
innodb  select_group                         19.00      -16.64%      -2.71     
4.00  136.00   16.29    5.28
innodb  select_group_when_MANY_tables        12.00      -24.83%      -2.39     
3.00   49.00    9.61    9.19
innodb  select_join                           0.00     +100.00%       0.58     
0.00    1.00    0.58    0.49
innodb  select_key                           63.00      -17.94%      -9.58    
40.00   66.00   53.42    7.69
innodb  select_key2                          69.00      -14.78%      -8.89    
45.00   75.00   60.11    8.48
innodb  select_key2_return_key               67.00      -16.62%      -9.55    
42.00   71.00   57.45    8.30
innodb  select_key2_return_prim              68.00      -16.81%      -9.79    
42.00   72.00   58.21    8.44
innodb  select_key_prefix                    69.00      -16.18%      -9.61    
44.00   75.00   59.39    8.53
innodb  select_key_prefix_join                6.00      -26.48%      -1.26     
3.00   10.00    4.74    0.65
innodb  select_key_return_key                61.00      -16.34%      -8.57    
38.00   65.00   52.43    7.69
innodb  select_many_fields                   13.00      +12.39%       1.84    
11.00   19.00   14.84    1.79
innodb  select_range                         48.00       -2.55%      -1.19    
38.00   76.00   46.81    4.07
innodb  select_range_key2                     9.00       -8.03%      -0.67     
6.00   11.00    8.33    1.06
innodb  select_range_prefix                   9.00      -13.63%      -1.08     
5.00   10.00    7.92    1.14
innodb  select_simple                         2.00      -19.69%      -0.33     
1.00    3.00    1.67    0.51
innodb  select_simple_cache                   2.00      -26.45%      -0.42     
1.00    3.00    1.58    0.51
innodb  select_simple_join                    1.00      -49.76%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     4.00      -19.40%      -0.65     
2.00   16.00    3.35    0.99
innodb  update_big                           62.00      -20.46%     -10.53    
31.00  195.00   51.47   23.80
innodb  update_commit                         1.00      +36.89%       0.58     
1.00   10.00    1.58    0.71
innodb  update_of_key                        22.00       +8.74%       2.11    
18.00  100.00   24.11    6.01
innodb  update_of_key_big                    32.00      -14.38%      -4.02    
15.00   75.00   27.98   10.88
innodb  update_of_primary_key_many_keys    1435.00      -15.02%    -187.41   
647.00 6065.00 1247.59  922.31
innodb  update_rollback                       2.00      -12.38%      -0.22     
1.00   31.00    1.78    1.85
innodb  update_with_key                     120.00       -8.57%      -9.47    
90.00  598.00  110.53   20.34
innodb  update_with_key_prefix               41.00       -2.76%      -1.10    
33.00  202.00   39.90    6.71
innodb  wisc_benchmark                        3.00      -20.98%      -0.52     
2.00    5.00    2.48    0.53

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

  2263.2.3: Brian Aker 2011-04-04 Merge fix for drizzle.
  2263.2.2: Brian Aker 2011-04-04 [merge] Merge in owner tree.
    2241.6.2: Brian Aker 2011-04-02 This adds the concept of a definer to a 
table definition.
    2241.6.1: Brian Aker 2011-03-18 Fix for bad usage of "="
  2263.2.1: Monty Taylor 2011-04-03 [merge] Merged Eliot into trunk. Fixed 
windows build.

_______________________________________________
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