=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   554
RUN DATE: 2010-10-13T21:17:03.927890
SERVER:   drizzled
VERSION:  staging
REVISION: 1845
COMMENT:  1845: lbieber 2010-10-13 [merge] Merge Monty - Change necessary to do 
branch patches

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      22.00      -48.65%      -7.20    
12.00   22.00   14.80    3.66
innodb  alter_table_drop                     19.00      -26.67%      -4.00    
12.00   19.00   15.00    2.28
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      -25.00%      -0.60     
2.00    3.00    2.40    0.49
innodb  count                                14.00       +1.41%       0.20    
13.00   17.00   14.20    1.47
innodb  count_distinct                        6.00       -0.00%       0.00     
5.00    7.00    6.00    0.63
innodb  count_distinct_2                     14.00      -12.90%      -1.60    
11.00   14.00   12.40    1.36
innodb  count_distinct_big                   19.00       +9.52%       2.00    
19.00   24.00   21.00    1.67
innodb  count_distinct_group                 14.00      -14.75%      -1.80    
10.00   14.00   12.20    1.60
innodb  count_distinct_group_on_key           8.00       +6.98%       0.60     
8.00   11.00    8.60    1.20
innodb  count_distinct_group_on_key_parts    11.00       +3.51%       0.40    
11.00   13.00   11.40    0.80
innodb  count_distinct_key_prefix             4.00      +13.04%       0.60     
4.00    6.00    4.60    0.80
innodb  count_group_on_key_parts              8.00      +16.67%       1.60     
8.00   10.00    9.60    0.80
innodb  count_on_key                         84.00       +3.23%       2.80    
84.00   89.00   86.80    1.72
innodb  create+drop                          39.00      -31.76%      -9.40    
23.00   39.00   29.60    5.64
innodb  create_index                          2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  create_key+drop                      34.00      -22.30%      -6.20    
25.00   34.00   27.80    3.19
innodb  create_MANY_tables                   69.00     -105.36%     -35.40    
17.00   69.00   33.60   18.54
innodb  create_table                          0.00         NULL       0.00     
0.00    0.00    0.00    0.00
innodb  delete_all_many_keys                332.00      -28.68%     -74.00   
213.00  332.00  258.00   47.02
innodb  delete_autocommit                     4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  delete_big                            1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                332.00      -28.68%     -74.00   
213.00  332.00  258.00   47.02
innodb  delete_commit                         1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          8.00      -21.21%      -1.40     
6.00    8.00    6.60    0.80
innodb  delete_rollback                       1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  drop_index                            6.00      -87.50%      -2.80     
2.00    6.00    3.20    1.47
innodb  drop_table                            0.00         NULL       0.00     
0.00    0.00    0.00    0.00
innodb  drop_table_when_MANY_tables          26.00      -54.76%      -9.20    
14.00   26.00   16.80    4.66
innodb  insert                              108.00       -2.86%      -3.00   
101.00  108.00  105.00    2.97
innodb  insert_autocommit                     2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  insert_commit                         2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  insert_duplicates                    15.00       -5.63%      -0.80    
13.00   15.00   14.20    0.75
innodb  insert_key                          281.00      -44.55%     -86.60   
150.00  281.00  194.40   46.41
innodb  insert_many_fields                   11.00      -57.14%      -4.00     
5.00   11.00    7.00    2.28
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  insert_select_2_keys                  6.00      -30.43%      -1.40     
4.00    6.00    4.60    0.80
innodb  min_max                               8.00       -5.26%      -0.40     
6.00    9.00    7.60    1.02
innodb  min_max_on_key                       18.00      +10.00%       2.00    
18.00   23.00   20.00    1.67
innodb  multiple_value_insert                 5.00      -66.67%      -2.00     
2.00    5.00    3.00    1.10
innodb  once_prepared_select                 23.00       +1.71%       0.40    
22.00   26.00   23.40    1.36
innodb  order_by_big                         15.00       -5.63%      -0.80    
12.00   16.00   14.20    1.47
innodb  order_by_big_key                     14.00       -4.48%      -0.60    
11.00   14.00   13.40    1.20
innodb  order_by_big_key2                    12.00       -1.69%      -0.20    
11.00   13.00   11.80    0.75
innodb  order_by_big_key_desc                14.00       +1.41%       0.20    
12.00   16.00   14.20    1.33
innodb  order_by_big_key_diff                13.00      -10.17%      -1.20    
10.00   13.00   11.80    1.17
innodb  order_by_big_key_prefix              13.00       -3.17%      -0.40    
11.00   14.00   12.60    1.02
innodb  order_by_key2_diff                    2.00      -42.86%      -0.60     
1.00    2.00    1.40    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                        0.00     +100.00%       0.80     
0.00    1.00    0.80    0.40
innodb  outer_join                           17.00       -4.94%      -0.80    
15.00   17.00   16.20    0.75
innodb  outer_join_found                     17.00       -6.25%      -1.00    
15.00   17.00   16.00    0.63
innodb  outer_join_not_found                 14.00       -4.48%      -0.60    
13.00   14.00   13.40    0.49
innodb  outer_join_on_key                    13.00      -12.07%      -1.40    
11.00   13.00   11.60    0.80
innodb  prepared_select                      30.00       -0.67%      -0.20    
27.00   32.00   29.80    1.60
innodb  select_1_row                          2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  select_1_row_cache                    3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  select_2_rows                         3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  select_big                           13.00       -4.84%      -0.60    
11.00   13.00   12.40    0.80
innodb  select_big_str                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  select_cache                         54.00       +9.70%       5.80    
53.00   64.00   59.80    5.15
innodb  select_cache2                        55.00       +9.84%       6.00    
53.00   66.00   61.00    5.76
innodb  select_column+column                  2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  select_diff_key                       0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  select_distinct                       5.00      -19.05%      -0.80     
4.00    5.00    4.20    0.40
innodb  select_group                         16.00       -2.56%      -0.40    
14.00   17.00   15.60    1.36
innodb  select_group_when_MANY_tables         4.00      +16.67%       0.80     
4.00    6.00    4.80    0.75
innodb  select_join                           1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  select_key                           47.00      +10.31%       5.40    
47.00   61.00   52.40    4.63
innodb  select_key2                          60.00       -2.04%      -1.20    
56.00   66.00   58.80    3.92
innodb  select_key2_return_key               58.00       +0.34%       0.20    
54.00   64.00   58.20    3.60
innodb  select_key2_return_prim              59.00       -2.79%      -1.60    
54.00   61.00   57.40    2.58
innodb  select_key_prefix                    60.00       -6.76%      -3.80    
54.00   60.00   56.20    2.04
innodb  select_key_prefix_join                4.00      +16.67%       0.80     
4.00    5.00    4.80    0.40
innodb  select_key_return_key                43.00      +14.00%       7.00    
43.00   58.00   50.00    4.77
innodb  select_many_fields                   13.00      +15.58%       2.40    
13.00   18.00   15.40    1.85
innodb  select_range                         52.00       -5.69%      -2.80    
44.00   53.00   49.20    3.54
innodb  select_range_key2                     9.00       -4.65%      -0.40     
8.00    9.00    8.60    0.49
innodb  select_range_prefix                   8.00       -2.56%      -0.20     
7.00    8.00    7.80    0.40
innodb  select_simple                         1.00      +37.50%       0.60     
1.00    2.00    1.60    0.49
innodb  select_simple_cache                   2.00      -66.67%      -0.80     
1.00    2.00    1.20    0.40
innodb  select_simple_join                    0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  TOTALS                             3469.00      -15.07%    -454.20  
2761.00 3469.00 3014.80  271.26
innodb  update_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  update_big                           54.00      -36.36%     -14.40    
35.00   54.00   39.60    7.28
innodb  update_commit                         2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  update_of_key                        25.00      -11.61%      -2.60    
20.00   25.00   22.40    2.15
innodb  update_of_key_big                    24.00      -22.45%      -4.40    
17.00   24.00   19.60    2.65
innodb  update_of_primary_key_many_keys     888.00      -16.81%    -127.80   
667.00  888.00  760.20   82.62
innodb  update_rollback                       2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  update_with_key                     108.00       +1.10%       1.20   
106.00  112.00  109.20    2.14
innodb  update_with_key_prefix               38.00       -3.26%      -1.20    
35.00   38.00   36.80    0.98
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                      22.00      -59.42%      -8.20    
12.00   22.00   13.80    2.01
innodb  alter_table_drop                     19.00      -36.20%      -5.05    
12.00   19.00   13.95    1.72
innodb  connect                               2.00       +4.76%       0.10     
1.00    3.00    2.10    0.44
innodb  connect+select_1_row                  3.00      -11.11%      -0.30     
2.00    3.00    2.70    0.46
innodb  connect+select_simple                 3.00      -33.33%      -0.75     
2.00    3.00    2.25    0.43
innodb  count                                14.00       +7.59%       1.15    
13.00   17.00   15.15    1.80
innodb  count_distinct                        6.00       +4.00%       0.25     
5.00    8.00    6.25    0.70
innodb  count_distinct_2                     14.00      -11.11%      -1.40    
11.00   16.00   12.60    1.66
innodb  count_distinct_big                   19.00      +13.83%       3.05    
19.00   25.00   22.05    2.01
innodb  count_distinct_group                 14.00      -14.75%      -1.80    
10.00   15.00   12.20    1.69
innodb  count_distinct_group_on_key           8.00       +9.60%       0.85     
8.00   11.00    8.85    1.06
innodb  count_distinct_group_on_key_parts    11.00       +3.93%       0.45     
9.00   14.00   11.45    1.47
innodb  count_distinct_key_prefix             4.00      +14.89%       0.70     
4.00    6.00    4.70    0.84
innodb  count_group_on_key_parts              8.00      +16.67%       1.60     
8.00   10.00    9.60    0.80
innodb  count_on_key                         84.00       +1.29%       1.10    
75.00   93.00   85.10    4.36
innodb  create+drop                          39.00      -35.42%     -10.20    
23.00   39.00   28.80    4.40
innodb  create_index                          2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  create_key+drop                      34.00      -25.69%      -6.95    
25.00   34.00   27.05    1.80
innodb  create_MANY_tables                   69.00     -143.39%     -40.65    
17.00   69.00   28.35   11.18
innodb  create_table                          0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  delete_all_many_keys                332.00      -36.23%     -88.30   
212.00  332.00  243.70   29.66
innodb  delete_autocommit                     4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  delete_big                            1.00     -400.00%      -0.80     
0.00    1.00    0.20    0.40
innodb  delete_big_many_keys                332.00      -36.23%     -88.30   
212.00  332.00  243.70   29.66
innodb  delete_commit                         1.00      +33.33%       0.50     
1.00    2.00    1.50    0.50
innodb  delete_key                            3.00       -5.26%      -0.15     
2.00    4.00    2.85    0.48
innodb  delete_range                          8.00      -28.00%      -1.75     
5.00    8.00    6.25    0.62
innodb  delete_rollback                       1.00      +39.39%       0.65     
1.00    2.00    1.65    0.48
innodb  drop_index                            6.00     -150.00%      -3.60     
2.00    6.00    2.40    0.92
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  drop_table_when_MANY_tables          26.00      -69.38%     -10.65    
13.00   26.00   15.35    2.80
innodb  insert                              108.00       -1.69%      -1.80    
97.00  119.00  106.20    5.90
innodb  insert_autocommit                     2.00      +29.82%       0.85     
2.00    3.00    2.85    0.36
innodb  insert_commit                         2.00      -53.85%      -0.70     
1.00    2.00    1.30    0.46
innodb  insert_duplicates                    15.00       +0.33%       0.05    
13.00   18.00   15.05    1.53
innodb  insert_key                          281.00      -49.35%     -92.85   
148.00  281.00  188.15   28.95
innodb  insert_many_fields                   11.00      -76.00%      -4.75     
5.00   11.00    6.25    1.30
innodb  insert_rollback                       2.00      -17.65%      -0.30     
1.00    2.00    1.70    0.46
innodb  insert_select_1_key                   3.00       +9.09%       0.30     
2.00    4.00    3.30    0.56
innodb  insert_select_2_keys                  6.00      -31.87%      -1.45     
4.00    6.00    4.55    0.59
innodb  min_max                               8.00       -3.23%      -0.25     
6.00    9.00    7.75    0.99
innodb  min_max_on_key                       18.00      +12.41%       2.55    
18.00   24.00   20.55    1.96
innodb  multiple_value_insert                 5.00      -85.19%      -2.30     
2.00    5.00    2.70    0.71
innodb  once_prepared_select                 23.00       +2.54%       0.60    
20.00   26.00   23.60    1.71
innodb  order_by_big                         15.00       -7.91%      -1.10    
12.00   16.00   13.90    1.30
innodb  order_by_big_key                     14.00       -6.87%      -0.90    
11.00   15.00   13.10    1.09
innodb  order_by_big_key2                    12.00       +1.23%       0.15    
10.00   14.00   12.15    1.11
innodb  order_by_big_key_desc                14.00       -2.56%      -0.35    
12.00   16.00   13.65    1.15
innodb  order_by_big_key_diff                13.00      -10.17%      -1.20    
10.00   13.00   11.80    1.08
innodb  order_by_big_key_prefix              13.00       -3.17%      -0.40    
11.00   14.00   12.60    0.86
innodb  order_by_key2_diff                    2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  order_by_range                        0.00     +100.00%       0.80     
0.00    1.00    0.80    0.40
innodb  outer_join                           17.00       -1.80%      -0.30    
15.00   21.00   16.70    1.93
innodb  outer_join_found                     17.00       -2.72%      -0.45    
15.00   21.00   16.55    1.94
innodb  outer_join_not_found                 14.00       +1.75%       0.25    
12.00   18.00   14.25    1.79
innodb  outer_join_on_key                    13.00      -10.17%      -1.20    
10.00   15.00   11.80    1.33
innodb  prepared_select                      30.00       -0.50%      -0.15    
27.00   34.00   29.85    2.08
innodb  select_1_row                          2.00      +25.93%       0.70     
2.00    3.00    2.70    0.46
innodb  select_1_row_cache                    3.00      -17.65%      -0.45     
2.00    3.00    2.55    0.50
innodb  select_2_rows                         3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  select_big                           13.00       -7.88%      -0.95    
10.00   14.00   12.05    0.97
innodb  select_big_str                        1.00      +13.04%       0.15     
1.00    2.00    1.15    0.36
innodb  select_cache                         54.00      +10.37%       6.25    
51.00   65.00   60.25    4.25
innodb  select_cache2                        55.00       +9.69%       5.90    
50.00   68.00   60.90    5.71
innodb  select_column+column                  2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  select_diff_key                       0.00     +100.00%       0.25     
0.00    1.00    0.25    0.43
innodb  select_distinct                       5.00      -17.65%      -0.75     
4.00    5.00    4.25    0.43
innodb  select_group                         16.00       -0.95%      -0.15    
14.00   18.00   15.85    1.39
innodb  select_group_when_MANY_tables         4.00      +15.79%       0.75     
4.00    6.00    4.75    0.62
innodb  select_join                           1.00      -81.82%      -0.45     
0.00    1.00    0.55    0.50
innodb  select_key                           47.00       +8.74%       4.50    
47.00   61.00   51.50    2.97
innodb  select_key2                          60.00       -3.90%      -2.25    
55.00   68.00   57.75    3.55
innodb  select_key2_return_key               58.00       -1.58%      -0.90    
53.00   65.00   57.10    3.87
innodb  select_key2_return_prim              59.00       -2.43%      -1.40    
54.00   66.00   57.60    3.64
innodb  select_key_prefix                    60.00       -6.57%      -3.70    
54.00   65.00   56.30    2.35
innodb  select_key_prefix_join                4.00      +12.09%       0.55     
4.00    5.00    4.55    0.50
innodb  select_key_return_key                43.00      +14.43%       7.25    
43.00   58.00   50.25    3.03
innodb  select_many_fields                   13.00      +18.50%       2.95    
13.00   18.00   15.95    1.32
innodb  select_range                         52.00       -9.82%      -4.65    
43.00   53.00   47.35    3.72
innodb  select_range_key2                     9.00       -9.76%      -0.80     
7.00   10.00    8.20    0.81
innodb  select_range_prefix                   8.00       -7.38%      -0.55     
7.00    8.00    7.45    0.50
innodb  select_simple                         1.00      +35.48%       0.55     
1.00    2.00    1.55    0.50
innodb  select_simple_cache                   2.00      -37.93%      -0.55     
1.00    2.00    1.45    0.50
innodb  select_simple_join                    0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  TOTALS                             3469.00      -17.36%    -513.15  
2759.00 3469.00 2955.85  166.98
innodb  update_autocommit                     3.00       +7.69%       0.25     
3.00    4.00    3.25    0.43
innodb  update_big                           54.00      -44.00%     -16.50    
34.00   54.00   37.50    3.99
innodb  update_commit                         2.00      -33.33%      -0.50     
1.00    2.00    1.50    0.50
innodb  update_of_key                        25.00       -8.70%      -2.00    
19.00   30.00   23.00    2.88
innodb  update_of_key_big                    24.00      -23.71%      -4.60    
16.00   26.00   19.40    2.54
innodb  update_of_primary_key_many_keys     888.00      -18.36%    -137.75   
664.00  888.00  750.25   65.86
innodb  update_rollback                       2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  update_with_key                     108.00       +0.55%       0.60   
100.00  113.00  108.60    2.99
innodb  update_with_key_prefix               38.00       -3.40%      -1.25    
33.00   38.00   36.75    1.26
innodb  wisc_benchmark                        2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      22.00      -80.74%      -9.83    
11.00   14.00   12.17    0.87
innodb  alter_table_drop                     19.00      -66.47%      -7.59    
10.00   14.00   11.41    1.07
innodb  connect                               2.00      -18.37%      -0.31     
1.00    2.00    1.69    0.46
innodb  connect+select_1_row                  3.00      -27.94%      -0.66     
2.00    3.00    2.34    0.48
innodb  connect+select_simple                 3.00      -52.63%      -1.03     
1.00    2.00    1.97    0.18
innodb  count                                14.00       +6.67%       1.00    
13.00   18.00   15.00    1.76
innodb  count_distinct                        6.00       +1.14%       0.07     
5.00    8.00    6.07    0.83
innodb  count_distinct_2                     14.00      -15.34%      -1.86    
11.00   16.00   12.14    1.38
innodb  count_distinct_big                   19.00      +10.99%       2.34    
18.00   25.00   21.34    1.97
innodb  count_distinct_group                 14.00      -10.63%      -1.34    
11.00   14.00   12.66    0.84
innodb  count_distinct_group_on_key           8.00      +10.08%       0.90     
8.00   11.00    8.90    1.12
innodb  count_distinct_group_on_key_parts    11.00       +6.45%       0.76    
10.00   15.00   11.76    1.36
innodb  count_distinct_key_prefix             4.00      +15.33%       0.72     
4.00    6.00    4.72    0.69
innodb  count_group_on_key_parts              8.00       +1.69%       0.14     
7.00   10.00    8.14    0.78
innodb  count_on_key                         84.00       -8.75%      -6.76    
73.00   83.00   77.24    2.25
innodb  create+drop                          39.00      -99.82%     -19.48    
19.00   21.00   19.52    0.56
innodb  create_index                          2.00       -5.45%      -0.10     
1.00    3.00    1.90    0.48
innodb  create_key+drop                      34.00      -50.76%     -11.45    
21.00   23.00   22.55    0.56
innodb  create_MANY_tables                   69.00     -304.24%     -51.93    
14.00   20.00   17.07    1.70
innodb  create_table                          0.00     +100.00%       0.07     
0.00    1.00    0.07    0.25
innodb  delete_all_many_keys                332.00      -11.69%     -34.76   
239.00  345.00  297.24   21.38
innodb  delete_autocommit                     4.00      -41.46%      -1.17     
2.00    3.00    2.83    0.38
innodb  delete_big                            1.00     -262.50%      -0.72     
0.00    1.00    0.28    0.45
innodb  delete_big_many_keys                332.00      -11.73%     -34.86   
239.00  345.00  297.14   21.37
innodb  delete_commit                         1.00      +25.64%       0.34     
1.00    2.00    1.34    0.48
innodb  delete_key                            3.00      -22.54%      -0.55     
2.00    3.00    2.45    0.50
innodb  delete_range                          8.00      -14.85%      -1.03     
6.00    8.00    6.97    0.56
innodb  delete_rollback                       1.00      +23.68%       0.31     
1.00    2.00    1.31    0.46
innodb  drop_index                            6.00     -205.26%      -4.03     
1.00    3.00    1.97    0.32
innodb  drop_table                            0.00         NULL       0.00     
0.00    0.00    0.00    0.00
innodb  drop_table_when_MANY_tables          26.00      -92.84%     -12.52    
12.00   15.00   13.48    0.62
innodb  insert                              108.00      -19.09%     -17.31    
88.00   93.00   90.69    1.37
innodb  insert_autocommit                     2.00      +22.67%       0.59     
2.00    3.00    2.59    0.49
innodb  insert_commit                         2.00      -81.25%      -0.90     
1.00    2.00    1.10    0.30
innodb  insert_duplicates                    15.00      -16.94%      -2.17    
12.00   14.00   12.83    0.53
innodb  insert_key                          281.00       +2.30%       6.62   
189.00  345.00  287.62   32.94
innodb  insert_many_fields                   11.00     -170.34%      -6.93     
3.00    5.00    4.07    0.36
innodb  insert_rollback                       2.00      -41.46%      -0.59     
1.00    2.00    1.41    0.49
innodb  insert_select_1_key                   3.00      +12.12%       0.41     
3.00    4.00    3.41    0.49
innodb  insert_select_2_keys                  6.00      -16.00%      -0.83     
4.00    6.00    5.17    0.59
innodb  min_max                               8.00       -4.50%      -0.34     
6.00    9.00    7.66    1.03
innodb  min_max_on_key                       18.00       -6.75%      -1.14    
14.00   20.00   16.86    1.28
innodb  multiple_value_insert                 5.00      -10.69%      -0.48     
3.00    5.00    4.52    0.56
innodb  once_prepared_select                 23.00       -9.70%      -2.03    
20.00   22.00   20.97    0.61
innodb  order_by_big                         15.00       -6.10%      -0.86    
12.00   15.00   14.14    0.94
innodb  order_by_big_key                     14.00      -12.78%      -1.59    
11.00   14.00   12.41    1.19
innodb  order_by_big_key2                    12.00       -4.50%      -0.52    
10.00   13.00   11.48    0.97
innodb  order_by_big_key_desc                14.00       -8.56%      -1.10    
12.00   14.00   12.90    0.92
innodb  order_by_big_key_diff                13.00      -12.20%      -1.41    
10.00   13.00   11.59    0.85
innodb  order_by_big_key_prefix              13.00       -8.65%      -1.03    
11.00   13.00   11.97    0.85
innodb  order_by_key2_diff                    2.00      -70.59%      -0.83     
1.00    2.00    1.17    0.38
innodb  order_by_key_prefix                   1.00      -61.11%      -0.38     
0.00    1.00    0.62    0.49
innodb  order_by_range                        0.00     +100.00%       0.72     
0.00    1.00    0.72    0.45
innodb  outer_join                           17.00       +1.99%       0.34    
15.00   21.00   17.34    2.06
innodb  outer_join_found                     17.00       -0.82%      -0.14    
14.00   21.00   16.86    2.19
innodb  outer_join_not_found                 14.00       +6.67%       1.00    
13.00   18.00   15.00    1.49
innodb  outer_join_on_key                    13.00       -8.65%      -1.03    
10.00   15.00   11.97    1.50
innodb  prepared_select                      30.00      -16.00%      -4.14    
22.00   29.00   25.86    2.10
innodb  select_1_row                          2.00      +18.31%       0.45     
2.00    3.00    2.45    0.50
innodb  select_1_row_cache                    3.00      -45.00%      -0.93     
2.00    3.00    2.07    0.25
innodb  select_2_rows                         3.00      -35.94%      -0.79     
2.00    3.00    2.21    0.41
innodb  select_big                           13.00      -11.87%      -1.38    
10.00   13.00   11.62    1.00
innodb  select_big_str                        1.00       +9.76%       0.11     
0.00    2.00    1.11    0.32
innodb  select_cache                         54.00       +6.23%       3.59    
51.00   71.00   57.59    5.41
innodb  select_cache2                        55.00       +3.27%       1.86    
51.00   68.00   56.86    4.88
innodb  select_column+column                  2.00      +24.68%       0.66     
2.00    3.00    2.66    0.48
innodb  select_diff_key                       0.00     +100.00%       0.17     
0.00    1.00    0.17    0.38
innodb  select_distinct                       5.00      -27.19%      -1.07     
3.00    5.00    3.93    0.36
innodb  select_group                         16.00       -5.22%      -0.79    
13.00   18.00   15.21    1.47
innodb  select_group_when_MANY_tables         4.00       -0.00%       0.00     
3.00    5.00    4.00    0.37
innodb  select_join                           1.00     -107.14%      -0.52     
0.00    1.00    0.48    0.50
innodb  select_key                           47.00       -5.58%      -2.48    
40.00   50.00   44.52    2.50
innodb  select_key2                          60.00      -21.76%     -10.72    
46.00   54.00   49.28    2.41
innodb  select_key2_return_key               58.00      -23.59%     -11.07    
42.00   51.00   46.93    2.32
innodb  select_key2_return_prim              59.00      -21.87%     -10.59    
43.00   55.00   48.41    2.92
innodb  select_key_prefix                    60.00      -18.13%      -9.21    
45.00   57.00   50.79    3.46
innodb  select_key_prefix_join                4.00       +4.13%       0.17     
4.00    5.00    4.17    0.38
innodb  select_key_return_key                43.00       +1.34%       0.59    
39.00   49.00   43.59    2.65
innodb  select_many_fields                   13.00      +20.96%       3.45    
15.00   17.00   16.45    0.62
innodb  select_range                         52.00       -6.42%      -3.14    
47.00   57.00   48.86    1.66
innodb  select_range_key2                     9.00      -24.29%      -1.76     
6.00    8.00    7.24    0.57
innodb  select_range_prefix                   8.00      -14.29%      -1.00     
6.00    8.00    7.00    0.64
innodb  select_simple                         1.00      +30.95%       0.45     
1.00    2.00    1.45    0.50
innodb  select_simple_cache                   2.00      -75.76%      -0.86     
1.00    2.00    1.14    0.34
innodb  select_simple_join                    0.00     +100.00%       0.72     
0.00    1.00    0.72    0.45
innodb  TOTALS                             3469.00     -246.90%   -2469.01   
999.99  999.99  999.99    0.00
innodb  update_autocommit                     3.00       -7.41%      -0.21     
2.00    3.00    2.79    0.41
innodb  update_big                           54.00      -49.86%     -17.97    
31.00   40.00   36.03    2.48
innodb  update_commit                         2.00      -48.72%      -0.66     
1.00    2.00    1.34    0.48
innodb  update_of_key                        25.00      -29.70%      -5.72    
19.00   20.00   19.28    0.45
innodb  update_of_key_big                    24.00      -31.07%      -5.69    
16.00   20.00   18.31    1.18
innodb  update_of_primary_key_many_keys     888.00      -16.33%    -124.67   
661.00  799.00  763.33   39.70
innodb  update_rollback                       2.00      -41.46%      -0.59     
1.00    2.00    1.41    0.49
innodb  update_with_key                     108.00      -17.70%     -16.24    
90.00   93.00   91.76    0.97
innodb  update_with_key_prefix               38.00       -7.83%      -2.76    
34.00   36.00   35.24    0.57
innodb  wisc_benchmark                        2.00      +14.71%       0.34     
2.00    3.00    2.34    0.48

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

  1843.2.1: Monty Taylor 2010-10-13 Updated pandora-build files to version 0.161

_______________________________________________
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