=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   922
RUN DATE: 2011-02-24T16:15:32.072810
SERVER:   drizzled
VERSION:  staging
REVISION: 2199
COMMENT:  2199: Brian Aker 2011-02-24 [merge] Rollup of BUID, mostly style 
fixes.

=========================================================================================================================
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.63
innodb  alter_table_drop                     24.00       +0.83%       0.20    
24.00   25.00   24.20    0.40
innodb  connect                               2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  count                                13.00      +13.33%       2.00    
13.00   17.00   15.00    1.67
innodb  count_distinct                        6.00       +9.09%       0.60     
6.00    8.00    6.60    0.80
innodb  count_distinct_2                     14.00       +2.78%       0.40    
14.00   16.00   14.40    0.80
innodb  count_distinct_big                   21.00       +5.41%       1.20    
20.00   25.00   22.20    2.32
innodb  count_distinct_group                 14.00       -2.94%      -0.40    
12.00   15.00   13.60    1.02
innodb  count_distinct_group_on_key          10.00       +3.85%       0.40     
9.00   11.00   10.40    0.80
innodb  count_distinct_group_on_key_parts    15.00      -15.38%      -2.00    
11.00   15.00   13.00    1.41
innodb  count_distinct_key_prefix             5.00       -0.00%       0.00     
5.00    5.00    5.00    0.00
innodb  count_group_on_key_parts             11.00       +3.51%       0.40    
11.00   12.00   11.40    0.49
innodb  count_on_key                        100.00       -6.84%      -6.40    
91.00  100.00   93.60    3.26
innodb  create+drop                          33.00       +1.79%       0.60    
33.00   34.00   33.60    0.49
innodb  create_index                          4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  create_key+drop                      37.00      -17.09%      -5.40    
29.00   37.00   31.60    2.87
innodb  create_MANY_tables                   21.00       -0.96%      -0.20    
20.00   21.00   20.80    0.40
innodb  create_table                          0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_all_many_keys                668.00       -2.96%     -19.20   
621.00  683.00  648.80   22.98
innodb  delete_autocommit                     4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  delete_big                            1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  delete_big_many_keys                667.00       -3.00%     -19.40   
620.00  681.00  647.60   22.69
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            2.00      +28.57%       0.80     
2.00    3.00    2.80    0.40
innodb  delete_range                          8.00       +6.98%       0.60     
8.00    9.00    8.60    0.49
innodb  delete_rollback                       3.00      -25.00%      -0.60     
2.00    3.00    2.40    0.49
innodb  drop_index                            2.00      +28.57%       0.80     
2.00    3.00    2.80    0.40
innodb  drop_table_when_MANY_tables          18.00       +5.26%       1.00    
18.00   21.00   19.00    1.10
innodb  insert                              114.00       +0.35%       0.40   
113.00  116.00  114.40    1.02
innodb  insert_autocommit                     3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  insert_commit                         1.00      +44.44%       0.80     
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                          286.00       -0.35%      -1.00   
275.00  302.00  285.00    9.27
innodb  insert_many_fields                    7.00      -12.90%      -0.80     
6.00    7.00    6.20    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       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  insert_select_2_keys                  7.00       -6.06%      -0.40     
6.00    7.00    6.60    0.49
innodb  min_max                               7.00      +12.50%       1.00     
7.00    9.00    8.00    0.89
innodb  min_max_on_key                       24.00       +2.44%       0.60    
24.00   25.00   24.60    0.49
innodb  multiple_value_insert                 6.00       +6.25%       0.40     
6.00    8.00    6.40    0.80
innodb  once_prepared_select                 30.00       -2.04%      -0.60    
29.00   30.00   29.40    0.49
innodb  order_by_big                         14.00       +4.11%       0.60    
13.00   16.00   14.60    1.02
innodb  order_by_big_key                     13.00       +8.45%       1.20    
12.00   16.00   14.20    1.60
innodb  order_by_big_key2                    14.00       -1.45%      -0.20    
13.00   14.00   13.80    0.40
innodb  order_by_big_key_desc                14.00       +4.11%       0.60    
14.00   15.00   14.60    0.49
innodb  order_by_big_key_diff                14.00       -2.94%      -0.40    
13.00   14.00   13.60    0.49
innodb  order_by_big_key_prefix              14.00       -2.94%      -0.40    
13.00   14.00   13.60    0.49
innodb  order_by_key2_diff                    1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  order_by_key_prefix                   1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  order_by_range                        1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  outer_join                           18.00       +7.22%       1.40    
17.00   22.00   19.40    2.15
innodb  outer_join_found                     18.00       +5.26%       1.00    
17.00   22.00   19.00    2.10
innodb  outer_join_not_found                 16.00       +9.09%       1.60    
15.00   20.00   17.60    1.85
innodb  outer_join_on_key                    12.00       +7.69%       1.00    
11.00   15.00   13.00    1.67
innodb  prepared_select                      37.00       +0.54%       0.20    
37.00   38.00   37.20    0.40
innodb  select_1_row                          3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  select_1_row_cache                    4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_2_rows                         4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_big                           12.00       +4.76%       0.60    
11.00   14.00   12.60    1.20
innodb  select_big_str                        2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  select_cache                         70.00       -3.55%      -2.40    
62.00   70.00   67.60    2.87
innodb  select_cache2                        67.00       -5.02%      -3.20    
60.00   67.00   63.80    2.79
innodb  select_column+column                  3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  select_diff_key                       0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  select_distinct                       4.00      +16.67%       0.80     
4.00    5.00    4.80    0.40
innodb  select_group                         17.00      -10.39%      -1.60    
15.00   17.00   15.40    0.80
innodb  select_group_when_MANY_tables        12.00       +1.64%       0.20    
11.00   14.00   12.20    0.98
innodb  select_join                           1.00     -400.00%      -0.80     
0.00    1.00    0.20    0.40
innodb  select_key                           65.00       -1.25%      -0.80    
64.00   65.00   64.20    0.40
innodb  select_key2                          71.00       +0.56%       0.40    
71.00   72.00   71.40    0.49
innodb  select_key2_return_key               69.00       -0.88%      -0.60    
68.00   69.00   68.40    0.49
innodb  select_key2_return_prim              70.00       -0.29%      -0.20    
69.00   70.00   69.80    0.40
innodb  select_key_prefix                    71.00       -0.28%      -0.20    
70.00   71.00   70.80    0.40
innodb  select_key_prefix_join                5.00       +3.85%       0.20     
5.00    6.00    5.20    0.40
innodb  select_key_return_key                64.00       -1.27%      -0.80    
62.00   64.00   63.20    0.75
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         47.00       -6.33%      -2.80    
40.00   47.00   44.20    2.40
innodb  select_range_key2                     9.00       +8.16%       0.80     
9.00   10.00    9.80    0.40
innodb  select_range_prefix                  10.00       -8.70%      -0.80     
9.00   10.00    9.20    0.40
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  update_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  update_big                           61.00       -3.39%      -2.00    
57.00   61.00   59.00    1.67
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        23.00       -1.77%      -0.40    
22.00   23.00   22.60    0.49
innodb  update_of_key_big                    29.00      +18.54%       6.60    
29.00   41.00   35.60    3.88
innodb  update_of_primary_key_many_keys    1333.00       +1.46%      19.80  
1304.00 1470.00 1352.80   59.55
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     118.00       +2.16%       2.60   
118.00  124.00  120.60    2.06
innodb  update_with_key_prefix               43.00       +2.71%       1.20    
42.00   48.00   44.20    2.14
innodb  wisc_benchmark                        2.00      +16.67%       0.40     
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       +3.03%       1.00    
31.00   35.00   33.00    1.00
innodb  alter_table_drop                     24.00       +0.21%       0.05    
23.00   26.00   24.05    0.92
innodb  connect                               2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
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      -11.11%      -0.30     
2.00    3.00    2.70    0.46
innodb  count                                13.00      +16.13%       2.50    
13.00   18.00   15.50    2.06
innodb  count_distinct                        6.00       +6.98%       0.45     
6.00    8.00    6.45    0.59
innodb  count_distinct_2                     14.00       +0.71%       0.10    
12.00   16.00   14.10    1.04
innodb  count_distinct_big                   21.00       +7.28%       1.65    
20.00   25.00   22.65    2.10
innodb  count_distinct_group                 14.00       +1.75%       0.25    
12.00   15.00   14.25    0.99
innodb  count_distinct_group_on_key          10.00       +0.99%       0.10     
8.00   12.00   10.10    0.99
innodb  count_distinct_group_on_key_parts    15.00      -12.36%      -1.65    
11.00   15.00   13.35    0.96
innodb  count_distinct_key_prefix             5.00       +2.91%       0.15     
4.00    6.00    5.15    0.48
innodb  count_group_on_key_parts             11.00       +0.90%       0.10    
10.00   12.00   11.10    0.62
innodb  count_on_key                        100.00       -5.49%      -5.20    
91.00  105.00   94.80    3.41
innodb  create+drop                          33.00       +0.60%       0.20    
32.00   34.00   33.20    0.75
innodb  create_index                          4.00      -19.40%      -0.65     
2.00    4.00    3.35    0.57
innodb  create_key+drop                      37.00      -16.90%      -5.35    
29.00   37.00   31.65    1.62
innodb  create_MANY_tables                   21.00       -0.96%      -0.20    
20.00   23.00   20.80    0.87
innodb  create_table                          0.00     +100.00%       0.10     
0.00    1.00    0.10    0.30
innodb  delete_all_many_keys                668.00       -3.24%     -20.95   
574.00  714.00  647.05   31.44
innodb  delete_autocommit                     4.00       -5.26%      -0.20     
3.00    5.00    3.80    0.60
innodb  delete_big                            1.00      -42.86%      -0.30     
0.00    1.00    0.70    0.46
innodb  delete_big_many_keys                667.00       -3.23%     -20.90   
573.00  713.00  646.10   31.37
innodb  delete_commit                         2.00       -8.11%      -0.15     
1.00    2.00    1.85    0.36
innodb  delete_key                            2.00      +27.27%       0.75     
2.00    3.00    2.75    0.43
innodb  delete_range                          8.00      +10.61%       0.95     
8.00   10.00    8.95    0.74
innodb  delete_rollback                       3.00      -36.36%      -0.80     
2.00    3.00    2.20    0.40
innodb  drop_index                            2.00      +33.33%       1.00     
2.00    4.00    3.00    0.32
innodb  drop_table_when_MANY_tables          18.00       +4.26%       0.80    
18.00   21.00   18.80    0.98
innodb  insert                              114.00       -0.09%      -0.10   
112.00  117.00  113.90    1.26
innodb  insert_autocommit                     3.00       +9.09%       0.30     
3.00    4.00    3.30    0.46
innodb  insert_commit                         1.00      +45.95%       0.85     
1.00    2.00    1.85    0.36
innodb  insert_duplicates                    19.00       +0.78%       0.15    
19.00   20.00   19.15    0.36
innodb  insert_key                          286.00       -1.96%      -5.50   
255.00  302.00  280.50   11.20
innodb  insert_many_fields                    7.00      -17.65%      -1.05     
5.00    7.00    5.95    0.59
innodb  insert_rollback                       2.00       +2.44%       0.05     
1.00    3.00    2.05    0.38
innodb  insert_select_1_key                   4.00       -3.90%      -0.15     
3.00    5.00    3.85    0.48
innodb  insert_select_2_keys                  7.00      -14.75%      -0.90     
5.00    7.00    6.10    0.54
innodb  min_max                               7.00      +11.95%       0.95     
6.00    9.00    7.95    0.97
innodb  min_max_on_key                       24.00       +2.83%       0.70    
24.00   26.00   24.70    0.56
innodb  multiple_value_insert                 6.00       +6.98%       0.45     
5.00    8.00    6.45    0.86
innodb  once_prepared_select                 30.00       -2.56%      -0.75    
29.00   30.00   29.25    0.43
innodb  order_by_big                         14.00       +4.11%       0.60    
13.00   16.00   14.60    1.20
innodb  order_by_big_key                     13.00      +11.26%       1.65    
12.00   16.00   14.65    1.31
innodb  order_by_big_key2                    14.00       -4.48%      -0.60    
11.00   15.00   13.40    0.92
innodb  order_by_big_key_desc                14.00       +7.28%       1.10    
13.00   17.00   15.10    1.14
innodb  order_by_big_key_diff                14.00       -4.09%      -0.55    
12.00   15.00   13.45    0.80
innodb  order_by_big_key_prefix              14.00       -5.66%      -0.75    
12.00   15.00   13.25    0.70
innodb  order_by_key2_diff                    1.00      +23.08%       0.30     
1.00    2.00    1.30    0.46
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      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  outer_join                           18.00      +16.67%       3.60    
17.00   25.00   21.60    2.62
innodb  outer_join_found                     18.00      +13.88%       2.90    
17.00   25.00   20.90    2.51
innodb  outer_join_not_found                 16.00      +15.34%       2.90    
15.00   22.00   18.90    2.02
innodb  outer_join_on_key                    12.00      +17.24%       2.50    
11.00   17.00   14.50    1.83
innodb  prepared_select                      37.00       +1.07%       0.40    
37.00   38.00   37.40    0.49
innodb  select_1_row                          3.00      +13.04%       0.45     
3.00    4.00    3.45    0.50
innodb  select_1_row_cache                    4.00      -12.68%      -0.45     
3.00    4.00    3.55    0.50
innodb  select_2_rows                         4.00       -8.11%      -0.30     
3.00    4.00    3.70    0.46
innodb  select_big                           12.00       +6.61%       0.85    
11.00   14.00   12.85    1.06
innodb  select_big_str                        2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  select_cache                         70.00      -10.50%      -6.65    
57.00   70.00   63.35    4.29
innodb  select_cache2                        67.00       -8.33%      -5.15    
56.00   67.00   61.85    3.05
innodb  select_column+column                  3.00      +15.49%       0.55     
3.00    4.00    3.55    0.50
innodb  select_diff_key                       0.00     +100.00%       0.35     
0.00    1.00    0.35    0.48
innodb  select_distinct                       4.00      +11.11%       0.50     
4.00    5.00    4.50    0.50
innodb  select_group                         17.00       -0.00%       0.00    
15.00   19.00   17.00    1.41
innodb  select_group_when_MANY_tables        12.00       +2.44%       0.30    
11.00   14.00   12.30    0.84
innodb  select_join                           1.00      -53.85%      -0.35     
0.00    1.00    0.65    0.48
innodb  select_key                           65.00       -1.64%      -1.05    
63.00   65.00   63.95    0.59
innodb  select_key2                          71.00       +0.14%       0.10    
69.00   73.00   71.10    0.94
innodb  select_key2_return_key               69.00       -0.88%      -0.60    
67.00   69.00   68.40    0.66
innodb  select_key2_return_prim              70.00       -1.23%      -0.85    
68.00   70.00   69.15    0.85
innodb  select_key_prefix                    71.00       -0.42%      -0.30    
69.00   72.00   70.70    0.71
innodb  select_key_prefix_join                5.00       +1.96%       0.10     
5.00    6.00    5.10    0.30
innodb  select_key_return_key                64.00       -1.91%      -1.20    
62.00   64.00   62.80    0.68
innodb  select_many_fields                   13.00       +1.14%       0.15    
12.00   15.00   13.15    0.57
innodb  select_range                         47.00      -12.44%      -5.20    
38.00   47.00   41.80    2.89
innodb  select_range_key2                     9.00       +4.76%       0.45     
8.00   10.00    9.45    0.59
innodb  select_range_prefix                  10.00       -6.38%      -0.60     
8.00   10.00    9.40    0.58
innodb  select_simple                         2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  update_autocommit                     3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  update_big                           61.00       -3.30%      -1.95    
57.00   63.00   59.05    1.86
innodb  update_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  update_of_key                        23.00       -2.45%      -0.55    
21.00   24.00   22.45    0.67
innodb  update_of_key_big                    29.00      +19.56%       7.05    
29.00   46.00   36.05    3.88
innodb  update_of_primary_key_many_keys    1333.00       +0.51%       6.85  
1219.00 1470.00 1339.85   62.72
innodb  update_rollback                       2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  update_with_key                     118.00       +3.04%       3.70   
117.00  128.00  121.70    2.87
innodb  update_with_key_prefix               43.00       +4.55%       2.05    
40.00   49.00   45.05    2.52
innodb  wisc_benchmark                        2.00      +13.04%       0.30     
2.00    3.00    2.30    0.46

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00      -52.70%     -11.04    
11.00   61.00   20.96   10.09
innodb  alter_table_drop                     24.00      -30.80%      -5.65    
10.00   57.00   18.35    6.97
innodb  connect                               2.00       +3.83%       0.08     
1.00    3.00    2.08    0.42
innodb  connect+select_1_row                  3.00      -11.15%      -0.30     
2.00    5.00    2.70    0.47
innodb  connect+select_simple                 3.00      -27.97%      -0.66     
1.00    3.00    2.34    0.48
innodb  count                                13.00      +17.43%       2.74    
12.00  193.00   15.74    8.86
innodb  count_distinct                        6.00       +8.56%       0.56     
5.00   50.00    6.56    2.28
innodb  count_distinct_2                     14.00       -6.22%      -0.82    
11.00   63.00   13.18    2.96
innodb  count_distinct_big                   21.00       +4.22%       0.92     
5.00   67.00   21.92    3.03
innodb  count_distinct_group                 14.00       -6.59%      -0.87    
10.00   68.00   13.13    3.10
innodb  count_distinct_group_on_key          10.00       -5.33%      -0.51     
7.00   69.00    9.49    3.03
innodb  count_distinct_group_on_key_parts    15.00      -21.82%      -2.69     
9.00   72.00   12.31    3.16
innodb  count_distinct_key_prefix             5.00       +2.40%       0.12     
3.00   52.00    5.12    2.39
innodb  count_group_on_key_parts             11.00      -10.28%      -1.03     
7.00   72.00    9.97    3.16
innodb  count_on_key                        100.00      -16.37%     -14.07    
68.00  107.00   85.93    7.38
innodb  create+drop                          33.00       -1.77%      -0.57    
18.00   75.00   32.43   11.94
innodb  create_index                          4.00      -38.58%      -1.11     
1.00    8.00    2.89    1.14
innodb  create_key+drop                      37.00      -31.35%      -8.83    
21.00   50.00   28.17    4.92
innodb  create_MANY_tables                   21.00      +38.54%      13.17    
14.00  121.00   34.17   17.12
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.36
innodb  delete_all_many_keys                668.00      -44.40%    -205.40   
212.00 1888.00  462.60  365.86
innodb  delete_autocommit                     4.00      -16.21%      -0.56     
2.00   14.00    3.44    0.75
innodb  delete_big                            1.00     -243.95%      -0.71     
0.00    3.00    0.29    0.47
innodb  delete_big_many_keys                667.00      -42.29%    -198.23   
212.00 2293.00  468.77  380.16
innodb  delete_commit                         2.00      -32.45%      -0.49     
1.00    5.00    1.51    0.53
innodb  delete_key                            2.00      +34.66%       1.06     
2.00   35.00    3.06    1.50
innodb  delete_range                          8.00       +3.66%       0.30     
5.00   23.00    8.30    3.25
innodb  delete_rollback                       3.00      -72.79%      -1.26     
1.00   12.00    1.74    0.92
innodb  drop_index                            2.00      +32.17%       0.95     
1.00    9.00    2.95    1.32
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.23
innodb  drop_table_when_MANY_tables          18.00       +8.08%       1.58    
11.00   90.00   19.58    7.56
innodb  insert                              114.00       -6.90%      -7.35     
3.00  343.00  106.65   14.64
innodb  insert_autocommit                     3.00       -0.04%       0.00     
2.00   99.00    3.00    3.33
innodb  insert_commit                         1.00      +27.16%       0.37     
1.00    3.00    1.37    0.49
innodb  insert_duplicates                    19.00      -23.16%      -3.57    
11.00   21.00   15.43    2.64
innodb  insert_key                          286.00       +5.74%      17.40   
142.00  700.00  303.40  107.54
innodb  insert_many_fields                    7.00      -24.91%      -1.40     
3.00   17.00    5.60    1.78
innodb  insert_rollback                       2.00      -20.31%      -0.34     
1.00    3.00    1.66    0.53
innodb  insert_select_1_key                   4.00       -5.81%      -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.10
innodb  min_max                               7.00      +10.54%       0.83     
6.00  110.00    7.83    4.56
innodb  min_max_on_key                       24.00      -17.06%      -3.50    
14.00   37.00   20.50    3.07
innodb  multiple_value_insert                 6.00      -10.15%      -0.55     
2.00   50.00    5.45    4.30
innodb  once_prepared_select                 30.00      -24.17%      -5.84    
18.00   32.00   24.16    3.55
innodb  order_by_big                         14.00       +2.17%       0.31    
12.00   31.00   14.31    1.53
innodb  order_by_big_key                     13.00       +2.03%       0.27    
11.00   32.00   13.27    1.64
innodb  order_by_big_key2                    14.00      -14.82%      -1.81    
10.00   33.00   12.19    1.55
innodb  order_by_big_key_desc                14.00       -3.82%      -0.52    
11.00   32.00   13.48    1.68
innodb  order_by_big_key_diff                14.00      -14.54%      -1.78    
10.00   31.00   12.22    1.51
innodb  order_by_big_key_prefix              14.00      -12.99%      -1.61    
10.00   32.00   12.39    1.56
innodb  order_by_key2_diff                    1.00      +28.40%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -26.60%      -0.21     
0.00    2.00    0.79    0.41
innodb  order_by_range                        1.00      -20.51%      -0.17     
0.00    2.00    0.83    0.38
innodb  outer_join                           18.00       +6.81%       1.32    
15.00   61.00   19.32    3.73
innodb  outer_join_found                     18.00       +3.96%       0.74    
14.00   58.00   18.74    3.58
innodb  outer_join_not_found                 16.00       +2.66%       0.44    
12.00   46.00   16.44    3.17
innodb  outer_join_on_key                    12.00       +6.90%       0.89    
10.00   59.00   12.89    2.78
innodb  prepared_select                      37.00      -18.37%      -5.74    
22.00   40.00   31.26    4.49
innodb  select_1_row                          3.00       -5.48%      -0.16     
2.00    4.00    2.84    0.69
innodb  select_1_row_cache                    4.00      -49.76%      -1.33     
2.00    4.00    2.67    0.68
innodb  select_2_rows                         4.00      -39.37%      -1.13     
2.00    4.00    2.87    0.70
innodb  select_big                           12.00       +1.26%       0.15     
0.00   31.00   12.15    1.55
innodb  select_big_str                        2.00      -71.70%      -0.84     
0.00    2.00    1.16    0.37
innodb  select_cache                         70.00      -17.44%     -10.40    
49.00   77.00   59.60    5.65
innodb  select_cache2                        67.00      -11.76%      -7.05    
49.00   75.00   59.95    6.30
innodb  select_column+column                  3.00       -3.02%      -0.09     
2.00    4.00    2.91    0.71
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.41
innodb  select_distinct                       4.00       +5.53%       0.23     
3.00    8.00    4.23    0.54
innodb  select_group                         17.00       -4.51%      -0.73     
4.00  136.00   16.27    5.46
innodb  select_group_when_MANY_tables        12.00      -27.13%      -2.56     
3.00   49.00    9.44    9.50
innodb  select_join                           1.00      -72.87%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           65.00      -23.50%     -12.37    
40.00   66.00   52.63    7.39
innodb  select_key2                          71.00      -19.70%     -11.68    
45.00   75.00   59.32    8.25
innodb  select_key2_return_key               69.00      -21.82%     -12.36    
42.00   71.00   56.64    8.04
innodb  select_key2_return_prim              70.00      -21.95%     -12.60    
42.00   72.00   57.40    8.19
innodb  select_key_prefix                    71.00      -21.23%     -12.43    
44.00   75.00   58.57    8.27
innodb  select_key_prefix_join                5.00       -6.01%      -0.28     
3.00   10.00    4.72    0.65
innodb  select_key_return_key                64.00      -23.90%     -12.34    
38.00   65.00   51.66    7.40
innodb  select_many_fields                   13.00      +13.11%       1.96    
11.00   19.00   14.96    1.79
innodb  select_range                         47.00       +0.21%       0.10    
38.00   76.00   47.10    3.99
innodb  select_range_key2                     9.00       -9.17%      -0.76     
6.00   11.00    8.24    1.04
innodb  select_range_prefix                  10.00      -27.81%      -2.18     
5.00   10.00    7.82    1.11
innodb  select_simple                         2.00      -21.74%      -0.36     
1.00    3.00    1.64    0.51
innodb  select_simple_cache                   2.00      -29.10%      -0.45     
1.00    3.00    1.55    0.51
innodb  select_simple_join                    1.00      -52.77%      -0.35     
0.00    3.00    0.65    0.48
innodb  update_autocommit                     3.00       +9.80%       0.33     
2.00   16.00    3.33    1.01
innodb  update_big                           61.00      -19.84%     -10.10    
31.00  195.00   50.90   24.58
innodb  update_commit                         2.00      -28.37%      -0.44     
1.00   10.00    1.56    0.73
innodb  update_of_key                        23.00       +5.16%       1.25    
18.00  100.00   24.25    6.20
innodb  update_of_key_big                    29.00       -6.02%      -1.65    
15.00   75.00   27.35   10.97
innodb  update_of_primary_key_many_keys    1333.00       -7.56%     -93.73   
647.00 6065.00 1239.27  965.50
innodb  update_rollback                       2.00      -13.89%      -0.24     
1.00   31.00    1.76    1.91
innodb  update_with_key                     118.00       -7.53%      -8.26    
90.00  598.00  109.74   20.86
innodb  update_with_key_prefix               43.00       -8.64%      -3.42    
33.00  202.00   39.58    6.84
innodb  wisc_benchmark                        2.00      +19.07%       0.47     
2.00    5.00    2.47    0.53

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

  2198.2.5: Brian Aker 2011-02-24 Merge in header fix for haildb
  2198.2.4: Brian Aker 2011-02-24 [merge] Merge docs update
    2197.2.3: Andrew Hutchings 2011-02-24 A few fixups to introduction
    2197.2.2: Andrew Hutchings 2011-02-24 Add basic contributing section to docs
    2197.2.1: Andrew Hutchings 2011-02-24 Fix drizzledump forward references
  2198.2.3: Brian Aker 2011-02-24 [merge] More list
    2183.2.25: Olaf van der Spek 2011-02-24 [merge] Merge trunk
    2183.2.24: Olaf van der Spek 2011-02-24 Remove inline keyword
    2183.2.23: Olaf van der Spek 2011-02-23 x
    2183.2.22: Olaf van der Spek 2011-02-23 x
    2183.2.21: Olaf van der Spek 2011-02-23 Use List::front()
  2198.2.2: Brian Aker 2011-02-24 [merge] Merge in copyright update
    2198.3.1: Olaf van der Spek 2011-02-24 Add copyright
  2198.2.1: Brian Aker 2011-02-24 [merge] Merge in header correction.
    2198.1.1: Olaf van der Spek 2011-02-24 Remove unnecessary alter* includes

_______________________________________________
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