=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   909
RUN DATE: 2011-02-19T14:28:19.833805
SERVER:   drizzled
VERSION:  staging
REVISION: 2185
COMMENT:  2185: Lee Bieber 2011-02-19 [merge] Merge Marisa - adds logo 
references to the include file

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       +3.03%       1.00    
32.00   34.00   33.00    0.89
innodb  alter_table_drop                     23.00       +3.36%       0.80    
23.00   25.00   23.80    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       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  count                                18.00      -12.50%      -2.00    
13.00   18.00   16.00    2.10
innodb  count_distinct                        6.00       +6.25%       0.40     
6.00    7.00    6.40    0.49
innodb  count_distinct_2                     13.00       +4.41%       0.60    
13.00   15.00   13.60    0.80
innodb  count_distinct_big                   24.00       -4.35%      -1.00    
20.00   25.00   23.00    2.10
innodb  count_distinct_group                 14.00       -1.45%      -0.20    
12.00   15.00   13.80    1.17
innodb  count_distinct_group_on_key          10.00       +1.96%       0.20     
9.00   12.00   10.20    1.17
innodb  count_distinct_group_on_key_parts    13.00       +4.41%       0.60    
13.00   14.00   13.60    0.49
innodb  count_distinct_key_prefix             6.00       -7.14%      -0.40     
5.00    6.00    5.60    0.49
innodb  count_group_on_key_parts             10.00      +10.71%       1.20    
10.00   12.00   11.20    0.75
innodb  count_on_key                         96.00       +2.44%       2.40    
95.00  105.00   98.40    3.72
innodb  create+drop                          32.00       +3.03%       1.00    
32.00   34.00   33.00    0.63
innodb  create_index                          4.00      -17.65%      -0.60     
2.00    4.00    3.40    0.80
innodb  create_key+drop                      31.00       +1.27%       0.40    
30.00   33.00   31.40    1.02
innodb  create_MANY_tables                   21.00       +0.94%       0.20    
20.00   23.00   21.20    1.17
innodb  create_table                          0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_all_many_keys                645.00       +1.74%      11.40   
645.00  667.00  656.40    7.45
innodb  delete_autocommit                     4.00       -0.00%       0.00     
3.00    5.00    4.00    0.63
innodb  delete_big                            0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  delete_big_many_keys                644.00       +1.77%      11.60   
644.00  667.00  655.60    7.74
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                          8.00      +13.04%       1.20     
8.00   10.00    9.20    0.75
innodb  delete_rollback                       3.00      -36.36%      -0.80     
2.00    3.00    2.20    0.40
innodb  drop_index                            3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  drop_table_when_MANY_tables          18.00       +6.25%       1.20    
18.00   21.00   19.20    1.17
innodb  insert                              115.00       -1.41%      -1.60   
112.00  115.00  113.40    1.02
innodb  insert_autocommit                     3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  insert_commit                         2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  insert_duplicates                    19.00       -0.00%       0.00    
19.00   19.00   19.00    0.00
innodb  insert_key                          279.00       +1.90%       5.40   
279.00  291.00  284.40    5.43
innodb  insert_many_fields                    6.00       -7.14%      -0.40     
5.00    7.00    5.60    0.80
innodb  insert_rollback                       2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
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      -12.90%      -0.80     
6.00    7.00    6.20    0.40
innodb  min_max                               6.00      +21.05%       1.60     
6.00    9.00    7.60    1.20
innodb  min_max_on_key                       26.00       -3.17%      -0.80    
25.00   26.00   25.20    0.40
innodb  multiple_value_insert                 7.00      -12.90%      -0.80     
5.00    7.00    6.20    0.75
innodb  once_prepared_select                 29.00       +0.68%       0.20    
29.00   30.00   29.20    0.40
innodb  order_by_big                         15.00       -2.74%      -0.40    
13.00   16.00   14.60    1.36
innodb  order_by_big_key                     15.00       -1.35%      -0.20    
13.00   16.00   14.80    1.17
innodb  order_by_big_key2                    14.00       -9.38%      -1.20    
11.00   14.00   12.80    0.98
innodb  order_by_big_key_desc                17.00      -11.84%      -1.80    
13.00   17.00   15.20    1.47
innodb  order_by_big_key_diff                13.00       +4.41%       0.60    
12.00   15.00   13.60    1.02
innodb  order_by_big_key_prefix              13.00       -0.00%       0.00    
12.00   14.00   13.00    0.63
innodb  order_by_key2_diff                    1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
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       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           23.00       -5.50%      -1.20    
17.00   24.00   21.80    2.48
innodb  outer_join_found                     21.00       +1.87%       0.40    
17.00   23.00   21.40    2.33
innodb  outer_join_not_found                 20.00       -4.17%      -0.80    
15.00   22.00   19.20    2.32
innodb  outer_join_on_key                    15.00       +1.32%       0.20    
12.00   17.00   15.20    1.72
innodb  prepared_select                      37.00       +1.07%       0.40    
37.00   38.00   37.40    0.49
innodb  select_1_row                          4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  select_1_row_cache                    3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_2_rows                         4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_big                           12.00       +7.69%       1.00    
12.00   14.00   13.00    0.89
innodb  select_big_str                        1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  select_cache                         57.00      +10.38%       6.60    
57.00   69.00   63.60    3.83
innodb  select_cache2                        62.00       -0.65%      -0.40    
57.00   64.00   61.60    2.42
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_diff_key                       1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  select_distinct                       4.00       +9.09%       0.40     
4.00    5.00    4.40    0.49
innodb  select_group                         18.00       -3.45%      -0.60    
15.00   18.00   17.40    1.20
innodb  select_group_when_MANY_tables        12.00       +4.76%       0.60    
12.00   14.00   12.60    0.80
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           64.00       -0.31%      -0.20    
63.00   64.00   63.80    0.40
innodb  select_key2                          71.00       +0.56%       0.40    
70.00   73.00   71.40    1.02
innodb  select_key2_return_key               68.00       +0.58%       0.40    
67.00   69.00   68.40    0.80
innodb  select_key2_return_prim              68.00       +1.16%       0.80    
68.00   70.00   68.80    0.75
innodb  select_key_prefix                    71.00       -0.28%      -0.20    
70.00   72.00   70.80    0.75
innodb  select_key_prefix_join                5.00       -0.00%       0.00     
5.00    5.00    5.00    0.00
innodb  select_key_return_key                62.00       +0.96%       0.60    
62.00   63.00   62.60    0.49
innodb  select_many_fields                   13.00       +2.99%       0.40    
13.00   15.00   13.40    0.80
innodb  select_range                         41.00       -1.49%      -0.60    
39.00   43.00   40.40    1.50
innodb  select_range_key2                     9.00       +2.17%       0.20     
9.00   10.00    9.20    0.40
innodb  select_range_prefix                   9.00       +6.25%       0.60     
9.00   10.00    9.60    0.49
innodb  select_simple                         2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
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      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  update_big                           57.00       +4.04%       2.40    
57.00   63.00   59.40    2.58
innodb  update_commit                         1.00      +44.44%       0.80     
1.00    2.00    1.80    0.40
innodb  update_of_key                        22.00       +0.90%       0.20    
22.00   23.00   22.20    0.40
innodb  update_of_key_big                    38.00       -6.74%      -2.40    
31.00   38.00   35.60    2.58
innodb  update_of_primary_key_many_keys    1337.00       +1.56%      21.20  
1337.00 1377.00 1358.20   15.42
innodb  update_rollback                       2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  update_with_key                     117.00       +3.78%       4.60   
117.00  125.00  121.60    2.65
innodb  update_with_key_prefix               45.00       +0.44%       0.20    
42.00   47.00   45.20    1.83
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                      32.00       +2.44%       0.80    
31.00   35.00   32.80    1.03
innodb  alter_table_drop                     23.00       +3.56%       0.85    
23.00   26.00   23.85    1.01
innodb  connect                               2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
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      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  count                                18.00      -16.13%      -2.50    
13.00   18.00   15.50    2.04
innodb  count_distinct                        6.00       +9.77%       0.65     
6.00    8.00    6.65    0.65
innodb  count_distinct_2                     13.00       +4.76%       0.65    
12.00   16.00   13.65    1.15
innodb  count_distinct_big                   24.00       -6.19%      -1.40    
20.00   25.00   22.60    1.83
innodb  count_distinct_group                 14.00       +1.75%       0.25    
11.00   15.00   14.25    1.22
innodb  count_distinct_group_on_key          10.00       +5.66%       0.60     
9.00   17.00   10.60    2.18
innodb  count_distinct_group_on_key_parts    13.00       +2.99%       0.40    
11.00   15.00   13.40    1.11
innodb  count_distinct_key_prefix             6.00      -12.15%      -0.65     
4.00    7.00    5.35    0.73
innodb  count_group_on_key_parts             10.00       +9.91%       1.10    
10.00   12.00   11.10    0.44
innodb  count_on_key                         96.00       -0.84%      -0.80    
91.00  105.00   95.20    3.20
innodb  create+drop                          32.00       +0.78%       0.25    
30.00   34.00   32.25    0.94
innodb  create_index                          4.00      -25.00%      -0.80     
2.00    4.00    3.20    0.51
innodb  create_key+drop                      31.00       -1.97%      -0.60    
28.00   33.00   30.40    1.39
innodb  create_MANY_tables                   21.00       -1.45%      -0.30    
19.00   23.00   20.70    0.95
innodb  create_table                          0.00     +100.00%       0.15     
0.00    1.00    0.15    0.36
innodb  delete_all_many_keys                645.00       +1.68%      11.05   
604.00  716.00  656.05   32.72
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.40     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                644.00       +1.70%      11.15   
603.00  715.00  655.15   32.72
innodb  delete_commit                         2.00       -5.26%      -0.10     
1.00    2.00    1.90    0.30
innodb  delete_key                            3.00       -1.69%      -0.05     
2.00    3.00    2.95    0.22
innodb  delete_range                          8.00       +8.05%       0.70     
7.00   10.00    8.70    0.78
innodb  delete_rollback                       3.00      -46.34%      -0.95     
2.00    3.00    2.05    0.22
innodb  drop_index                            3.00       +1.64%       0.05     
2.00    4.00    3.05    0.50
innodb  drop_table_when_MANY_tables          18.00       -4.05%      -0.70    
15.00   21.00   17.30    1.58
innodb  insert                              115.00       -0.74%      -0.85   
112.00  117.00  114.15    1.24
innodb  insert_autocommit                     3.00      +10.45%       0.35     
3.00    4.00    3.35    0.48
innodb  insert_commit                         2.00      -14.29%      -0.25     
1.00    2.00    1.75    0.43
innodb  insert_duplicates                    19.00       +0.26%       0.05    
18.00   20.00   19.05    0.50
innodb  insert_key                          279.00       +1.19%       3.35   
265.00  304.00  282.35   11.51
innodb  insert_many_fields                    6.00       -5.26%      -0.30     
5.00    7.00    5.70    0.56
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                  7.00      -13.82%      -0.85     
4.00    8.00    6.15    0.79
innodb  min_max                               6.00      +23.57%       1.85     
6.00    9.00    7.85    1.11
innodb  min_max_on_key                       26.00       -5.48%      -1.35    
24.00   26.00   24.65    0.65
innodb  multiple_value_insert                 7.00       -6.87%      -0.45     
5.00    8.00    6.55    0.67
innodb  once_prepared_select                 29.00       +0.85%       0.25    
29.00   30.00   29.25    0.43
innodb  order_by_big                         15.00       -2.74%      -0.40    
13.00   16.00   14.60    1.28
innodb  order_by_big_key                     15.00       -0.67%      -0.10    
12.00   17.00   14.90    1.37
innodb  order_by_big_key2                    14.00       -6.06%      -0.80    
11.00   15.00   13.20    0.93
innodb  order_by_big_key_desc                17.00      -11.11%      -1.70    
13.00   17.00   15.30    1.00
innodb  order_by_big_key_diff                13.00       -0.39%      -0.05    
11.00   15.00   12.95    1.02
innodb  order_by_big_key_prefix              13.00       +3.35%       0.45    
12.00   15.00   13.45    0.80
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      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           23.00       -4.31%      -0.95    
17.00   26.00   22.05    2.96
innodb  outer_join_found                     21.00       +0.94%       0.20    
17.00   25.00   21.20    2.73
innodb  outer_join_not_found                 20.00       -4.99%      -0.95    
14.00   22.00   19.05    2.60
innodb  outer_join_on_key                    15.00       -1.01%      -0.15    
11.00   17.00   14.85    2.03
innodb  prepared_select                      37.00       +0.80%       0.30    
37.00   38.00   37.30    0.46
innodb  select_1_row                          4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
innodb  select_1_row_cache                    3.00      +14.29%       0.50     
3.00    4.00    3.50    0.50
innodb  select_2_rows                         4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_big                           12.00       +9.09%       1.20    
12.00   15.00   13.20    0.87
innodb  select_big_str                        1.00      +23.08%       0.30     
1.00    2.00    1.30    0.46
innodb  select_cache                         57.00      +11.15%       7.15    
57.00   71.00   64.15    3.98
innodb  select_cache2                        62.00       +1.12%       0.70    
57.00   69.00   62.70    2.43
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_diff_key                       1.00     -185.71%      -0.65     
0.00    1.00    0.35    0.48
innodb  select_distinct                       4.00      +13.04%       0.60     
4.00    5.00    4.60    0.49
innodb  select_group                         18.00       -3.45%      -0.60    
15.00   19.00   17.40    1.32
innodb  select_group_when_MANY_tables        12.00       +1.23%       0.15    
11.00   14.00   12.15    0.79
innodb  select_join                           1.00      -81.82%      -0.45     
0.00    1.00    0.55    0.50
innodb  select_key                           64.00       -0.16%      -0.10    
63.00   66.00   63.90    0.77
innodb  select_key2                          71.00       +0.14%       0.10    
69.00   73.00   71.10    1.18
innodb  select_key2_return_key               68.00       +0.73%       0.50    
67.00   71.00   68.50    1.07
innodb  select_key2_return_prim              68.00       +1.81%       1.25    
68.00   71.00   69.25    0.94
innodb  select_key_prefix                    71.00       -0.42%      -0.30    
69.00   73.00   70.70    0.95
innodb  select_key_prefix_join                5.00       +2.91%       0.15     
5.00    6.00    5.15    0.36
innodb  select_key_return_key                62.00       +1.51%       0.95    
62.00   65.00   62.95    0.74
innodb  select_many_fields                   13.00       +2.62%       0.35    
13.00   15.00   13.35    0.57
innodb  select_range                         41.00       +1.68%       0.70    
39.00   49.00   41.70    2.70
innodb  select_range_key2                     9.00       +5.26%       0.50     
9.00   10.00    9.50    0.50
innodb  select_range_prefix                   9.00       +2.17%       0.20     
8.00   10.00    9.20    0.68
innodb  select_simple                         2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00      -42.86%      -0.30     
0.00    1.00    0.70    0.46
innodb  update_autocommit                     4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  update_big                           57.00       +3.31%       1.95    
57.00   63.00   58.95    1.80
innodb  update_commit                         1.00      +48.72%       0.95     
1.00    2.00    1.95    0.22
innodb  update_of_key                        22.00       +0.90%       0.20    
21.00   24.00   22.20    0.93
innodb  update_of_key_big                    38.00      -10.30%      -3.55    
29.00   38.00   34.45    3.04
innodb  update_of_primary_key_many_keys    1337.00       +1.58%      21.45  
1242.00 1489.00 1358.45   64.70
innodb  update_rollback                       2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  update_with_key                     117.00       +4.49%       5.50   
117.00  128.00  122.50    2.60
innodb  update_with_key_prefix               45.00       -1.35%      -0.60    
41.00   48.00   44.40    1.98
innodb  wisc_benchmark                        3.00      -13.21%      -0.35     
2.00    3.00    2.65    0.48

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00      -54.06%     -11.23    
11.00   61.00   20.77   10.05
innodb  alter_table_drop                     23.00      -25.96%      -4.74    
10.00   57.00   18.26    6.99
innodb  connect                               2.00       +3.78%       0.08     
1.00    3.00    2.08    0.42
innodb  connect+select_1_row                  3.00      -11.29%      -0.30     
2.00    5.00    2.70    0.48
innodb  connect+select_simple                 3.00      -28.33%      -0.66     
1.00    3.00    2.34    0.48
innodb  count                                18.00      -14.28%      -2.25    
12.00  193.00   15.75    8.92
innodb  count_distinct                        6.00       +8.58%       0.56     
5.00   50.00    6.56    2.30
innodb  count_distinct_2                     13.00       +1.25%       0.16    
11.00   63.00   13.16    2.98
innodb  count_distinct_big                   24.00       -9.51%      -2.08     
5.00   67.00   21.92    3.04
innodb  count_distinct_group                 14.00       -6.73%      -0.88    
10.00   68.00   13.12    3.12
innodb  count_distinct_group_on_key          10.00       -5.42%      -0.51     
7.00   69.00    9.49    3.05
innodb  count_distinct_group_on_key_parts    13.00       -5.70%      -0.70     
9.00   72.00   12.30    3.18
innodb  count_distinct_key_prefix             6.00      -17.07%      -0.88     
3.00   52.00    5.13    2.41
innodb  count_group_on_key_parts             10.00       -0.43%      -0.04     
7.00   72.00    9.96    3.18
innodb  count_on_key                         96.00      -11.87%     -10.18    
68.00  107.00   85.82    7.37
innodb  create+drop                          32.00       +1.27%       0.41    
18.00   75.00   32.41   12.03
innodb  create_index                          4.00      -38.95%      -1.12     
1.00    8.00    2.88    1.15
innodb  create_key+drop                      31.00      -10.26%      -2.88    
21.00   50.00   28.12    4.94
innodb  create_MANY_tables                   21.00      +38.91%      13.38    
14.00  121.00   34.38   17.17
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.36
innodb  delete_all_many_keys                645.00      -40.34%    -185.41   
212.00 1888.00  459.60  368.02
innodb  delete_autocommit                     4.00      -16.38%      -0.56     
2.00   14.00    3.44    0.75
innodb  delete_big                            0.00     +100.00%       0.28     
0.00    3.00    0.28    0.46
innodb  delete_big_many_keys                644.00      -38.23%    -178.11   
212.00 2293.00  465.89  382.52
innodb  delete_commit                         2.00      -32.81%      -0.49     
1.00    5.00    1.51    0.53
innodb  delete_key                            3.00       +2.21%       0.07     
2.00   35.00    3.07    1.51
innodb  delete_range                          8.00       +3.54%       0.29     
5.00   23.00    8.29    3.27
innodb  delete_rollback                       3.00      -73.55%      -1.27     
1.00   12.00    1.73    0.92
innodb  drop_index                            3.00       -1.73%      -0.05     
1.00    9.00    2.95    1.33
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       +8.14%       1.60    
11.00   90.00   19.60    7.62
innodb  insert                              115.00       -7.95%      -8.46     
3.00  343.00  106.54   14.73
innodb  insert_autocommit                     3.00       -0.12%       0.00     
2.00   99.00    3.00    3.35
innodb  insert_commit                         2.00      -46.60%      -0.64     
1.00    3.00    1.36    0.49
innodb  insert_duplicates                    19.00      -23.62%      -3.63    
11.00   21.00   15.37    2.62
innodb  insert_key                          279.00       +8.16%      24.79   
142.00  700.00  303.79  108.40
innodb  insert_many_fields                    6.00       -7.20%      -0.40     
3.00   17.00    5.60    1.79
innodb  insert_rollback                       2.00      -20.86%      -0.35     
1.00    3.00    1.65    0.53
innodb  insert_select_1_key                   4.00       -5.77%      -0.22     
2.00   10.00    3.78    0.89
innodb  insert_select_2_keys                  7.00      -15.34%      -0.93     
4.00   16.00    6.07    2.11
innodb  min_max                               6.00      +23.30%       1.82     
6.00  110.00    7.82    4.60
innodb  min_max_on_key                       26.00      -27.20%      -5.56    
14.00   37.00   20.44    3.05
innodb  multiple_value_insert                 7.00      -28.94%      -1.57     
2.00   50.00    5.43    4.33
innodb  once_prepared_select                 29.00      -20.43%      -4.92    
18.00   32.00   24.08    3.52
innodb  order_by_big                         15.00       -4.84%      -0.69    
12.00   31.00   14.31    1.54
innodb  order_by_big_key                     15.00      -13.18%      -1.75    
11.00   32.00   13.25    1.64
innodb  order_by_big_key2                    14.00      -15.01%      -1.83    
10.00   33.00   12.17    1.55
innodb  order_by_big_key_desc                17.00      -26.28%      -3.54    
11.00   32.00   13.46    1.68
innodb  order_by_big_key_diff                13.00       -6.52%      -0.80    
10.00   31.00   12.20    1.51
innodb  order_by_big_key_prefix              13.00       -5.02%      -0.62    
10.00   32.00   12.38    1.57
innodb  order_by_key2_diff                    1.00      +28.47%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -26.93%      -0.21     
0.00    2.00    0.79    0.41
innodb  order_by_range                        1.00      -20.55%      -0.17     
0.00    2.00    0.83    0.38
innodb  outer_join                           23.00      -19.33%      -3.73    
15.00   61.00   19.27    3.73
innodb  outer_join_found                     21.00      -12.27%      -2.30    
14.00   58.00   18.70    3.58
innodb  outer_join_not_found                 20.00      -21.99%      -3.61    
12.00   46.00   16.39    3.17
innodb  outer_join_on_key                    15.00      -16.60%      -2.14    
10.00   59.00   12.86    2.78
innodb  prepared_select                      37.00      -18.73%      -5.84    
22.00   40.00   31.16    4.46
innodb  select_1_row                          4.00      -41.05%      -1.16     
2.00    4.00    2.84    0.69
innodb  select_1_row_cache                    3.00      -12.94%      -0.34     
2.00    4.00    2.66    0.67
innodb  select_2_rows                         4.00      -39.99%      -1.14     
2.00    4.00    2.86    0.69
innodb  select_big                           12.00       +1.21%       0.15     
0.00   31.00   12.15    1.55
innodb  select_big_str                        1.00      +13.43%       0.16     
0.00    2.00    1.16    0.37
innodb  select_cache                         57.00       +4.26%       2.54    
49.00   77.00   59.54    5.64
innodb  select_cache2                        62.00       -3.47%      -2.08    
49.00   75.00   59.92    6.33
innodb  select_column+column                  4.00      -37.70%      -1.10     
2.00    4.00    2.90    0.71
innodb  select_diff_key                       1.00     -358.47%      -0.78     
0.00    1.00    0.22    0.41
innodb  select_distinct                       4.00       +5.45%       0.23     
3.00    8.00    4.23    0.54
innodb  select_group                         18.00      -10.71%      -1.74     
4.00  136.00   16.26    5.50
innodb  select_group_when_MANY_tables        12.00      -27.71%      -2.60     
3.00   49.00    9.40    9.56
innodb  select_join                           1.00      -73.05%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           64.00      -22.01%     -11.54    
40.00   66.00   52.46    7.31
innodb  select_key2                          71.00      -20.06%     -11.86    
45.00   75.00   59.14    8.19
innodb  select_key2_return_key               68.00      -20.44%     -11.54    
42.00   71.00   56.46    7.97
innodb  select_key2_return_prim              68.00      -18.84%     -10.78    
42.00   72.00   57.22    8.12
innodb  select_key_prefix                    71.00      -21.62%     -12.62    
44.00   75.00   58.38    8.19
innodb  select_key_prefix_join                5.00       -6.13%      -0.29     
3.00   10.00    4.71    0.66
innodb  select_key_return_key                62.00      -20.43%     -10.52    
38.00   65.00   51.48    7.33
innodb  select_many_fields                   13.00      +13.28%       1.99    
11.00   19.00   14.99    1.79
innodb  select_range                         41.00      +13.10%       6.18    
39.00   76.00   47.18    3.95
innodb  select_range_key2                     9.00       -9.42%      -0.77     
6.00   11.00    8.23    1.03
innodb  select_range_prefix                   9.00      -15.39%      -1.20     
5.00   10.00    7.80    1.10
innodb  select_simple                         2.00      -22.15%      -0.36     
1.00    3.00    1.64    0.51
innodb  select_simple_cache                   2.00      -29.68%      -0.46     
1.00    3.00    1.54    0.51
innodb  select_simple_join                    1.00      -53.75%      -0.35     
0.00    3.00    0.65    0.48
innodb  update_autocommit                     4.00      -20.43%      -0.68     
2.00   16.00    3.32    1.02
innodb  update_big                           57.00      -12.26%      -6.23    
31.00  195.00   50.77   24.75
innodb  update_commit                         1.00      +35.53%       0.55     
1.00   10.00    1.55    0.73
innodb  update_of_key                        22.00       +9.37%       2.28    
18.00  100.00   24.28    6.24
innodb  update_of_key_big                    38.00      -39.69%     -10.80    
15.00   75.00   27.20   10.98
innodb  update_of_primary_key_many_keys    1337.00       -8.07%     -99.79   
647.00 6065.00 1237.21  975.01
innodb  update_rollback                       2.00      -14.21%      -0.25     
1.00   31.00    1.75    1.92
innodb  update_with_key                     117.00       -6.79%      -7.44    
90.00  598.00  109.56   20.97
innodb  update_with_key_prefix               45.00      -13.93%      -5.50    
33.00  202.00   39.50    6.85
innodb  wisc_benchmark                        3.00      -21.21%      -0.53     
2.00    5.00    2.48    0.53

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

  2184.1.2: Lee Bieber 2011-02-19 [merge] Merge Marisa - adds logo references 
to the include file
    1994.4.78: Marisa Plumb 2011-02-18 adding images to include.am file
    1994.4.77: Marisa Plumb 2011-02-17 [merge] updating
  2184.1.1: Lee Bieber 2011-02-19 [merge] Merge Monty - some randome clean up 
stuff
    2183.1.2: Monty Taylor 2011-02-15 A slew of tiny meaningless changes.
    2183.1.1: Monty Taylor 2011-02-14 Use fs::path instead of string searching.

_______________________________________________
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