=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   612
RUN DATE: 2010-10-31T18:47:31.275158
SERVER:   drizzled
VERSION:  staging
REVISION: 1896
COMMENT:  1896: Brian Aker 2010-10-31 [merge] Merge Monty.

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      17.00      +20.31%       4.33    
17.00   27.00   21.33    4.19
innodb  alter_table_drop                     15.00      +16.67%       3.00    
15.00   22.00   18.00    2.94
innodb  connect                               2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  connect+select_1_row                  2.00      +14.29%       0.33     
2.00    3.00    2.33    0.47
innodb  connect+select_simple                 3.00      -12.50%      -0.33     
2.00    3.00    2.67    0.47
innodb  count                                14.00       -5.00%      -0.67    
13.00   14.00   13.33    0.47
innodb  count_distinct                        7.00      -10.53%      -0.67     
6.00    7.00    6.33    0.47
innodb  count_distinct_2                     14.00      -16.67%      -2.00    
11.00   14.00   12.00    1.41
innodb  count_distinct_big                   24.00      -12.50%      -2.67    
20.00   24.00   21.33    1.89
innodb  count_distinct_group                 14.00      -16.67%      -2.00    
11.00   14.00   12.00    1.41
innodb  count_distinct_group_on_key          11.00      -17.86%      -1.67     
8.00   11.00    9.33    1.25
innodb  count_distinct_group_on_key_parts    13.00      -11.43%      -1.33    
10.00   13.00   11.67    1.25
innodb  count_distinct_key_prefix             6.00      -28.57%      -1.33     
4.00    6.00    4.67    0.94
innodb  count_group_on_key_parts             10.00      -15.38%      -1.33     
8.00   10.00    8.67    0.94
innodb  count_on_key                         83.00       +4.23%       3.67    
83.00   94.00   86.67    5.19
innodb  create+drop                          33.00      +10.00%       3.67    
33.00   39.00   36.67    2.62
innodb  create_index                          2.00      +14.29%       0.33     
2.00    3.00    2.33    0.47
innodb  create_key+drop                      27.00       +3.57%       1.00    
27.00   29.00   28.00    0.82
innodb  create_MANY_tables                   45.00      +11.18%       5.67    
44.00   63.00   50.67    8.73
innodb  create_table                          0.00     +100.00%       0.33     
0.00    1.00    0.33    0.47
innodb  delete_all_many_keys                332.00       +2.73%       9.33   
332.00  348.00  341.33    6.80
innodb  delete_autocommit                     3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_big                            0.00     +100.00%       0.33     
0.00    1.00    0.33    0.47
innodb  delete_big_many_keys                332.00       +2.73%       9.33   
332.00  348.00  341.33    6.80
innodb  delete_commit                         2.00      -50.00%      -0.67     
1.00    2.00    1.33    0.47
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          6.00      +10.00%       0.67     
6.00    7.00    6.67    0.47
innodb  delete_rollback                       2.00      -20.00%      -0.33     
1.00    2.00    1.67    0.47
innodb  drop_index                            3.00      +10.00%       0.33     
3.00    4.00    3.33    0.47
innodb  drop_table                            0.00         NULL       0.00     
0.00    0.00    0.00    0.00
innodb  drop_table_when_MANY_tables          19.00       -0.00%       0.00    
14.00   24.00   19.00    4.08
innodb  insert                              101.00       -0.33%      -0.33   
100.00  101.00  100.67    0.47
innodb  insert_autocommit                     3.00      -12.50%      -0.33     
2.00    3.00    2.67    0.47
innodb  insert_commit                         1.00      +40.00%       0.67     
1.00    2.00    1.67    0.47
innodb  insert_duplicates                    14.00       -0.00%       0.00    
14.00   14.00   14.00    0.00
innodb  insert_key                          246.00       +3.15%       8.00   
231.00  285.00  254.00   22.76
innodb  insert_many_fields                    9.00      -12.50%      -1.00     
7.00    9.00    8.00    0.82
innodb  insert_rollback                       2.00      -20.00%      -0.33     
1.00    2.00    1.67    0.47
innodb  insert_select_1_key                   4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  insert_select_2_keys                  5.00      +16.67%       1.00     
5.00    8.00    6.00    1.41
innodb  min_max                               6.00       +5.26%       0.33     
6.00    7.00    6.33    0.47
innodb  min_max_on_key                       20.00       -5.26%      -1.00    
17.00   20.00   19.00    1.41
innodb  multiple_value_insert                 4.00       +7.69%       0.33     
4.00    5.00    4.33    0.47
innodb  once_prepared_select                 24.00       -1.41%      -0.33    
23.00   24.00   23.67    0.47
innodb  order_by_big                         15.00       -0.00%       0.00    
15.00   15.00   15.00    0.00
innodb  order_by_big_key                     13.00       -2.63%      -0.33    
12.00   13.00   12.67    0.47
innodb  order_by_big_key2                    13.00       -5.41%      -0.67    
11.00   13.00   12.33    0.94
innodb  order_by_big_key_desc                14.00       -2.44%      -0.33    
12.00   15.00   13.67    1.25
innodb  order_by_big_key_diff                13.00       -0.00%       0.00    
13.00   13.00   13.00    0.00
innodb  order_by_big_key_prefix              13.00       -5.41%      -0.67    
11.00   13.00   12.33    0.94
innodb  order_by_key2_diff                    2.00      -50.00%      -0.67     
1.00    2.00    1.33    0.47
innodb  order_by_key_prefix                   1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  order_by_range                        0.00     +100.00%       0.67     
0.00    1.00    0.67    0.47
innodb  outer_join                           22.00       -4.76%      -1.00    
20.00   22.00   21.00    0.82
innodb  outer_join_found                     21.00       -8.62%      -1.67    
17.00   21.00   19.33    1.70
innodb  outer_join_not_found                 19.00       -7.55%      -1.33    
15.00   19.00   17.67    1.89
innodb  outer_join_on_key                    14.00       -2.44%      -0.33    
12.00   15.00   13.67    1.25
innodb  prepared_select                      32.00       +1.03%       0.33    
32.00   33.00   32.33    0.47
innodb  select_1_row                          3.00      -12.50%      -0.33     
2.00    3.00    2.67    0.47
innodb  select_1_row_cache                    3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  select_2_rows                         3.00      -12.50%      -0.33     
2.00    3.00    2.67    0.47
innodb  select_big                           12.00       -9.09%      -1.00    
10.00   12.00   11.00    0.82
innodb  select_big_str                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  select_cache                         60.00       -4.65%      -2.67    
52.00   60.00   57.33    3.77
innodb  select_cache2                        66.00       -5.88%      -3.67    
55.00   66.00   62.33    5.19
innodb  select_column+column                  2.00      +14.29%       0.33     
2.00    3.00    2.33    0.47
innodb  select_diff_key                       0.00     +100.00%       0.33     
0.00    1.00    0.33    0.47
innodb  select_distinct                       4.00       +7.69%       0.33     
4.00    5.00    4.33    0.47
innodb  select_group                         17.00       -8.51%      -1.33    
13.00   17.00   15.67    1.89
innodb  select_group_when_MANY_tables         4.00       +7.69%       0.33     
4.00    5.00    4.33    0.47
innodb  select_join                           1.00     -200.00%      -0.67     
0.00    1.00    0.33    0.47
innodb  select_key                           44.00       +5.71%       2.67    
44.00   49.00   46.67    2.05
innodb  select_key2                          62.00       -1.09%      -0.67    
60.00   62.00   61.33    0.94
innodb  select_key2_return_key               59.00       -0.57%      -0.33    
58.00   59.00   58.67    0.47
innodb  select_key2_return_prim              57.00       +1.16%       0.67    
57.00   59.00   57.67    0.94
innodb  select_key_prefix                    60.00       +0.55%       0.33    
60.00   61.00   60.33    0.47
innodb  select_key_prefix_join                5.00       -0.00%       0.00     
5.00    5.00    5.00    0.00
innodb  select_key_return_key                46.00       +5.48%       2.67    
46.00   52.00   48.67    2.49
innodb  select_many_fields                   13.00       -0.00%       0.00    
13.00   13.00   13.00    0.00
innodb  select_range                         52.00       -7.59%      -3.67    
45.00   52.00   48.33    2.87
innodb  select_range_key2                     8.00       +4.00%       0.33     
8.00    9.00    8.33    0.47
innodb  select_range_prefix                   9.00       -3.85%      -0.33     
8.00    9.00    8.67    0.47
innodb  select_simple                         1.00      +25.00%       0.33     
1.00    2.00    1.33    0.47
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    0.00     +100.00%       0.67     
0.00    1.00    0.67    0.47
innodb  TOTALS                             3383.00       +1.39%      47.67  
3383.00 3470.00 3430.67   36.00
innodb  update_autocommit                     3.00      +10.00%       0.33     
3.00    4.00    3.33    0.47
innodb  update_big                           35.00      +25.00%      11.67    
35.00   57.00   46.67    9.03
innodb  update_commit                         1.00      +25.00%       0.33     
1.00    2.00    1.33    0.47
innodb  update_of_key                        24.00       +2.70%       0.67    
24.00   25.00   24.67    0.47
innodb  update_of_key_big                    16.00      +23.81%       5.00    
16.00   24.00   21.00    3.56
innodb  update_of_primary_key_many_keys     890.00       +0.63%       5.67   
888.00  909.00  895.67    9.46
innodb  update_rollback                       1.00      +25.00%       0.33     
1.00    2.00    1.33    0.47
innodb  update_with_key                     105.00       +0.32%       0.33   
104.00  107.00  105.33    1.25
innodb  update_with_key_prefix               37.00       +0.89%       0.33    
37.00   38.00   37.33    0.47
innodb  wisc_benchmark                        2.00      +25.00%       0.67     
2.00    4.00    2.67    0.94

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      17.00      +23.16%       5.13    
12.00   34.00   22.13    6.35
innodb  alter_table_drop                     15.00      +18.09%       3.31    
12.00   27.00   18.31    4.45
innodb  connect                               2.00      +17.95%       0.44     
2.00    3.00    2.44    0.50
innodb  connect+select_1_row                  2.00      +28.89%       0.81     
2.00    3.00    2.81    0.39
innodb  connect+select_simple                 3.00      -23.08%      -0.56     
2.00    3.00    2.44    0.50
innodb  count                                14.00       +0.44%       0.06    
13.00   18.00   14.06    1.64
innodb  count_distinct                        7.00      -12.00%      -0.75     
5.00    8.00    6.25    0.75
innodb  count_distinct_2                     14.00      -17.89%      -2.13    
11.00   15.00   11.88    1.32
innodb  count_distinct_big                   24.00      -16.01%      -3.31    
20.00   24.00   20.69    1.45
innodb  count_distinct_group                 14.00      -14.87%      -1.81    
10.00   14.00   12.19    1.51
innodb  count_distinct_group_on_key          11.00      -24.82%      -2.19     
8.00   11.00    8.81    0.95
innodb  count_distinct_group_on_key_parts    13.00      -14.29%      -1.63    
10.00   14.00   11.38    1.36
innodb  count_distinct_key_prefix             6.00      -28.00%      -1.31     
4.00    6.00    4.69    0.77
innodb  count_group_on_key_parts             10.00       -4.58%      -0.44     
8.00   10.00    9.56    0.79
innodb  count_on_key                         83.00       +3.35%       2.88    
80.00   94.00   85.88    3.76
innodb  create+drop                          33.00       +4.86%       1.69    
25.00   41.00   34.69    4.81
innodb  create_index                          2.00      +21.95%       0.56     
1.00    4.00    2.56    0.79
innodb  create_key+drop                      27.00       +4.64%       1.31    
26.00   31.00   28.31    1.69
innodb  create_MANY_tables                   45.00      +10.11%       5.06    
27.00   72.00   50.06   15.22
innodb  create_table                          0.00     +100.00%       0.13     
0.00    1.00    0.13    0.33
innodb  delete_all_many_keys                332.00       +0.49%       1.63   
290.00  438.00  333.63   33.98
innodb  delete_autocommit                     3.00       +7.69%       0.25     
3.00    4.00    3.25    0.43
innodb  delete_big                            0.00     +100.00%       0.31     
0.00    1.00    0.31    0.46
innodb  delete_big_many_keys                332.00       +0.49%       1.63   
290.00  438.00  333.63   33.98
innodb  delete_commit                         2.00      -45.45%      -0.63     
1.00    2.00    1.38    0.48
innodb  delete_key                            3.00       +9.43%       0.31     
3.00    4.00    3.31    0.46
innodb  delete_range                          6.00      +11.93%       0.81     
5.00   11.00    6.81    1.42
innodb  delete_rollback                       2.00      -39.13%      -0.56     
1.00    2.00    1.44    0.50
innodb  drop_index                            3.00       -6.67%      -0.19     
2.00    4.00    2.81    0.81
innodb  drop_table                            0.00     +100.00%       0.13     
0.00    1.00    0.13    0.33
innodb  drop_table_when_MANY_tables          19.00       +4.10%       0.81    
14.00   24.00   19.81    3.86
innodb  insert                              101.00       +0.80%       0.81   
100.00  105.00  101.81    1.51
innodb  insert_autocommit                     3.00       -6.67%      -0.19     
2.00    3.00    2.81    0.39
innodb  insert_commit                         1.00      +23.81%       0.31     
1.00    2.00    1.31    0.46
innodb  insert_duplicates                    14.00       +2.18%       0.31    
14.00   15.00   14.31    0.46
innodb  insert_key                          246.00       +0.66%       1.63   
184.00  292.00  247.63   35.44
innodb  insert_many_fields                    9.00      -27.43%      -1.94     
5.00   10.00    7.06    1.48
innodb  insert_rollback                       2.00      -33.33%      -0.50     
1.00    2.00    1.50    0.50
innodb  insert_select_1_key                   4.00       -8.47%      -0.31     
3.00    5.00    3.69    0.68
innodb  insert_select_2_keys                  5.00       +8.05%       0.44     
4.00    8.00    5.44    1.12
innodb  min_max                               6.00      +10.28%       0.69     
6.00    9.00    6.69    0.92
innodb  min_max_on_key                       20.00       -7.02%      -1.31    
16.00   21.00   18.69    1.36
innodb  multiple_value_insert                 4.00       +1.54%       0.06     
2.00    6.00    4.06    1.09
innodb  once_prepared_select                 24.00       -2.13%      -0.50    
22.00   25.00   23.50    0.79
innodb  order_by_big                         15.00       -7.14%      -1.00    
12.00   16.00   14.00    1.32
innodb  order_by_big_key                     13.00       -4.00%      -0.50    
11.00   14.00   12.50    1.17
innodb  order_by_big_key2                    13.00      -12.43%      -1.44    
10.00   13.00   11.56    1.32
innodb  order_by_big_key_desc                14.00       -9.27%      -1.19    
11.00   15.00   12.81    1.29
innodb  order_by_big_key_diff                13.00      -11.83%      -1.38    
10.00   13.00   11.63    1.32
innodb  order_by_big_key_prefix              13.00       -5.58%      -0.69    
11.00   14.00   12.31    1.04
innodb  order_by_key2_diff                    2.00      -39.13%      -0.56     
1.00    2.00    1.44    0.50
innodb  order_by_key_prefix                   1.00      -14.29%      -0.13     
0.00    1.00    0.88    0.33
innodb  order_by_range                        0.00     +100.00%       0.75     
0.00    1.00    0.75    0.43
innodb  outer_join                           22.00      -12.46%      -2.44    
17.00   23.00   19.56    2.03
innodb  outer_join_found                     21.00      -11.26%      -2.13    
16.00   22.00   18.88    2.12
innodb  outer_join_not_found                 19.00      -15.15%      -2.50    
14.00   19.00   16.50    1.87
innodb  outer_join_on_key                    14.00       -4.67%      -0.63    
11.00   16.00   13.38    1.45
innodb  prepared_select                      32.00       +1.16%       0.38    
31.00   33.00   32.38    0.60
innodb  select_1_row                          3.00      -11.63%      -0.31     
2.00    3.00    2.69    0.46
innodb  select_1_row_cache                    3.00      -11.63%      -0.31     
2.00    3.00    2.69    0.46
innodb  select_2_rows                         3.00       -9.09%      -0.25     
2.00    3.00    2.75    0.43
innodb  select_big                           12.00       -3.23%      -0.38    
10.00   14.00   11.63    1.17
innodb  select_big_str                        1.00      +15.79%       0.19     
1.00    2.00    1.19    0.39
innodb  select_cache                         60.00       -6.79%      -3.81    
52.00   65.00   56.19    4.52
innodb  select_cache2                        66.00      -14.66%      -8.44    
51.00   66.00   57.56    5.59
innodb  select_column+column                  2.00      +23.81%       0.63     
2.00    3.00    2.63    0.48
innodb  select_diff_key                       0.00     +100.00%       0.25     
0.00    1.00    0.25    0.43
innodb  select_distinct                       4.00       +7.25%       0.31     
4.00    5.00    4.31    0.46
innodb  select_group                         17.00       -7.51%      -1.19    
13.00   19.00   15.81    1.70
innodb  select_group_when_MANY_tables         4.00      +17.95%       0.88     
4.00    7.00    4.88    0.78
innodb  select_join                           1.00     -100.00%      -0.50     
0.00    1.00    0.50    0.50
innodb  select_key                           44.00      +10.77%       5.31    
44.00   52.00   49.31    2.17
innodb  select_key2                          62.00       -2.06%      -1.25    
58.00   62.00   60.75    1.15
innodb  select_key2_return_key               59.00       -0.85%      -0.50    
57.00   60.00   58.50    1.00
innodb  select_key2_return_prim              57.00       +3.08%       1.81    
56.00   62.00   58.81    1.51
innodb  select_key_prefix                    60.00       +0.52%       0.31    
58.00   62.00   60.31    1.10
innodb  select_key_prefix_join                5.00       -6.67%      -0.31     
4.00    5.00    4.69    0.46
innodb  select_key_return_key                46.00       +2.39%       1.13    
43.00   55.00   47.13    3.20
innodb  select_many_fields                   13.00       -1.96%      -0.25    
12.00   13.00   12.75    0.43
innodb  select_range                         52.00      -10.93%      -5.13    
44.00   52.00   46.88    2.85
innodb  select_range_key2                     8.00       +5.88%       0.50     
7.00    9.00    8.50    0.71
innodb  select_range_prefix                   9.00       -9.09%      -0.75     
7.00    9.00    8.25    0.56
innodb  select_simple                         1.00      +33.33%       0.50     
1.00    2.00    1.50    0.50
innodb  select_simple_cache                   2.00      -28.00%      -0.44     
1.00    2.00    1.56    0.50
innodb  select_simple_join                    0.00     +100.00%       0.69     
0.00    3.00    0.69    0.77
innodb  TOTALS                             3383.00       -0.11%      -3.75  
3076.00 3934.00 3379.25  198.65
innodb  update_autocommit                     3.00       +4.00%       0.13     
3.00    4.00    3.13    0.33
innodb  update_big                           35.00      +22.54%      10.19    
35.00   62.00   45.19    8.69
innodb  update_commit                         1.00      +36.00%       0.56     
1.00    2.00    1.56    0.50
innodb  update_of_key                        24.00       -0.52%      -0.13    
21.00   26.00   23.88    1.32
innodb  update_of_key_big                    16.00      +23.81%       5.00    
16.00   24.00   21.00    2.98
innodb  update_of_primary_key_many_keys     890.00       -0.84%      -7.44   
796.00 1095.00  882.56   71.95
innodb  update_rollback                       1.00      +38.46%       0.63     
1.00    2.00    1.63    0.48
innodb  update_with_key                     105.00       +0.06%       0.06   
100.00  109.00  105.06    2.63
innodb  update_with_key_prefix               37.00       +0.67%       0.25    
36.00   39.00   37.25    0.83
innodb  wisc_benchmark                        2.00      +20.00%       0.50     
2.00    4.00    2.50    0.61

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      17.00      -39.66%      -4.83    
11.00   14.00   12.17    0.87
innodb  alter_table_drop                     15.00      -31.42%      -3.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                  2.00      +14.71%       0.34     
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                        7.00      -15.34%      -0.93     
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                   24.00      -12.44%      -2.66    
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          11.00      -23.64%      -2.10     
8.00   11.00    8.90    1.12
innodb  count_distinct_group_on_key_parts    13.00      -10.56%      -1.24    
10.00   15.00   11.76    1.36
innodb  count_distinct_key_prefix             6.00      -27.01%      -1.28     
4.00    6.00    4.72    0.69
innodb  count_group_on_key_parts             10.00      -22.88%      -1.86     
7.00   10.00    8.14    0.78
innodb  count_on_key                         83.00       -7.46%      -5.76    
73.00   83.00   77.24    2.25
innodb  create+drop                          33.00      -69.08%     -13.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                      27.00      -19.72%      -4.45    
21.00   23.00   22.55    0.56
innodb  create_MANY_tables                   45.00     -163.64%     -27.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                     3.00       -6.10%      -0.17     
2.00    3.00    2.83    0.38
innodb  delete_big                            0.00     +100.00%       0.28     
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                         2.00      -48.72%      -0.66     
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                          6.00      +13.86%       0.97     
6.00    8.00    6.97    0.56
innodb  delete_rollback                       2.00      -52.63%      -0.69     
1.00    2.00    1.31    0.46
innodb  drop_index                            3.00      -52.63%      -1.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          19.00      -40.92%      -5.52    
12.00   15.00   13.48    0.62
innodb  insert                              101.00      -11.37%     -10.31    
88.00   93.00   90.69    1.37
innodb  insert_autocommit                     3.00      -16.00%      -0.41     
2.00    3.00    2.59    0.49
innodb  insert_commit                         1.00       +9.37%       0.10     
1.00    2.00    1.10    0.30
innodb  insert_duplicates                    14.00       -9.14%      -1.17    
12.00   14.00   12.83    0.53
innodb  insert_key                          246.00      +14.47%      41.62   
189.00  345.00  287.62   32.94
innodb  insert_many_fields                    9.00     -121.19%      -4.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                   4.00      -17.17%      -0.59     
3.00    4.00    3.41    0.49
innodb  insert_select_2_keys                  5.00       +3.33%       0.17     
4.00    6.00    5.17    0.59
innodb  min_max                               6.00      +21.62%       1.66     
6.00    9.00    7.66    1.03
innodb  min_max_on_key                       20.00      -18.61%      -3.14    
14.00   20.00   16.86    1.28
innodb  multiple_value_insert                 4.00      +11.45%       0.52     
3.00    5.00    4.52    0.56
innodb  once_prepared_select                 24.00      -14.47%      -3.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                     13.00       -4.72%      -0.59    
11.00   14.00   12.41    1.19
innodb  order_by_big_key2                    13.00      -13.21%      -1.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                           22.00      -26.84%      -4.66    
15.00   21.00   17.34    2.06
innodb  outer_join_found                     21.00      -24.54%      -4.14    
14.00   21.00   16.86    2.19
innodb  outer_join_not_found                 19.00      -26.67%      -4.00    
13.00   18.00   15.00    1.49
innodb  outer_join_on_key                    14.00      -17.00%      -2.03    
10.00   15.00   11.97    1.50
innodb  prepared_select                      32.00      -23.73%      -6.14    
22.00   29.00   25.86    2.10
innodb  select_1_row                          3.00      -22.54%      -0.55     
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                           12.00       -3.26%      -0.38    
10.00   13.00   11.62    1.00
innodb  select_big_str                        1.00       +9.63%       0.11     
0.00    2.00    1.11    0.31
innodb  select_cache                         60.00       -4.19%      -2.41    
51.00   71.00   57.59    5.41
innodb  select_cache2                        66.00      -16.07%      -9.14    
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                       4.00       -1.75%      -0.07     
3.00    5.00    3.93    0.36
innodb  select_group                         17.00      -11.79%      -1.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                           44.00       +1.16%       0.52    
40.00   50.00   44.52    2.50
innodb  select_key2                          62.00      -25.82%     -12.72    
46.00   54.00   49.28    2.41
innodb  select_key2_return_key               59.00      -25.72%     -12.07    
42.00   51.00   46.93    2.32
innodb  select_key2_return_prim              57.00      -17.74%      -8.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                5.00      -19.83%      -0.83     
4.00    5.00    4.17    0.38
innodb  select_key_return_key                46.00       -5.54%      -2.41    
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                     8.00      -10.48%      -0.76     
6.00    8.00    7.24    0.57
innodb  select_range_prefix                   9.00      -28.57%      -2.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                             3383.00     -238.30%   -2383.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                           35.00       +2.87%       1.03    
31.00   40.00   36.03    2.48
innodb  update_commit                         1.00      +25.64%       0.34     
1.00    2.00    1.34    0.48
innodb  update_of_key                        24.00      -24.51%      -4.72    
19.00   20.00   19.28    0.45
innodb  update_of_key_big                    16.00      +12.62%       2.31    
16.00   20.00   18.31    1.18
innodb  update_of_primary_key_many_keys     890.00      -16.59%    -126.67   
661.00  799.00  763.33   39.70
innodb  update_rollback                       1.00      +29.27%       0.41     
1.00    2.00    1.41    0.49
innodb  update_with_key                     105.00      -14.43%     -13.24    
90.00   93.00   91.76    0.97
innodb  update_with_key_prefix               37.00       -4.99%      -1.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:

  1892.2.1: Monty Taylor 2010-10-30 Fixes most of the lintian warnings

_______________________________________________
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