=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   636
RUN DATE: 2010-11-06T17:18:55.091899
SERVER:   drizzled
VERSION:  staging
REVISION: 1911
COMMENT:  1911: Brian Aker 2010-11-06 Additional io_cache encapsulation.

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00      -42.24%      -9.80    
13.00   38.00   23.20   10.24
innodb  alter_table_drop                     25.00      -25.00%      -5.00    
13.00   30.00   20.00    6.54
innodb  connect                               2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  connect+select_1_row                  3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  connect+select_simple                 3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  count                                15.00       +3.85%       0.60    
14.00   17.00   15.60    1.20
innodb  count_distinct                        6.00      +11.76%       0.80     
6.00    8.00    6.80    0.75
innodb  count_distinct_2                     11.00      +19.12%       2.60    
11.00   15.00   13.60    1.74
innodb  count_distinct_big                   19.00       +8.65%       1.80    
19.00   23.00   20.80    1.83
innodb  count_distinct_group                 12.00       +9.09%       1.20    
12.00   15.00   13.20    1.17
innodb  count_distinct_group_on_key           9.00      +11.76%       1.20     
9.00   11.00   10.20    0.98
innodb  count_distinct_group_on_key_parts    10.00      +19.35%       2.40    
10.00   15.00   12.40    2.06
innodb  count_distinct_key_prefix             5.00      +13.79%       0.80     
5.00    7.00    5.80    0.75
innodb  count_group_on_key_parts             10.00       -0.00%       0.00    
10.00   10.00   10.00    0.00
innodb  count_on_key                         85.00       +0.47%       0.40    
83.00   87.00   85.40    1.50
innodb  create+drop                          40.00       -5.26%      -2.00    
26.00   53.00   38.00    9.44
innodb  create_index                          3.00       -0.00%       0.00     
2.00    5.00    3.00    1.10
innodb  create_key+drop                      31.00       +0.64%       0.20    
27.00   42.00   31.20    5.56
innodb  create_MANY_tables                   60.00       -9.09%      -5.00    
28.00   90.00   55.00   22.29
innodb  delete_all_many_keys                349.00      +33.80%     178.20   
302.00 1305.00  527.20  389.28
innodb  delete_autocommit                     3.00      +16.67%       0.60     
3.00    5.00    3.60    0.80
innodb  delete_big_many_keys                349.00      +33.80%     178.20   
302.00 1305.00  527.20  389.28
innodb  delete_commit                         1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  delete_key                            5.00      -31.58%      -1.20     
2.00    6.00    3.80    1.47
innodb  delete_range                          7.00       -6.06%      -0.40     
6.00    7.00    6.60    0.49
innodb  delete_rollback                       1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  drop_index                            4.00      -25.00%      -0.80     
2.00    5.00    3.20    1.17
innodb  drop_table_when_MANY_tables          25.00      -21.36%      -4.40    
14.00   26.00   20.60    4.41
innodb  insert                              106.00       +3.11%       3.40   
102.00  134.00  109.40   12.39
innodb  insert_autocommit                     3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  insert_commit                         1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  insert_duplicates                    14.00       +2.78%       0.40    
14.00   15.00   14.40    0.49
innodb  insert_key                          289.00      +11.13%      36.20   
193.00  650.00  325.20  168.12
innodb  insert_many_fields                    9.00      -36.36%      -2.40     
5.00    9.00    6.60    1.62
innodb  insert_rollback                       1.00      +37.50%       0.60     
1.00    2.00    1.60    0.49
innodb  insert_select_1_key                   4.00       -5.26%      -0.20     
3.00    5.00    3.80    0.75
innodb  insert_select_2_keys                  6.00       -0.00%       0.00     
4.00    9.00    6.00    1.67
innodb  min_max                               8.00       -0.00%       0.00     
7.00    9.00    8.00    0.63
innodb  min_max_on_key                       21.00       -9.38%      -1.80    
18.00   21.00   19.20    0.98
innodb  multiple_value_insert                 6.00      -11.11%      -0.60     
3.00   10.00    5.40    2.50
innodb  once_prepared_select                 23.00       +4.17%       1.00    
23.00   25.00   24.00    0.63
innodb  order_by_big                         15.00       -2.74%      -0.40    
12.00   16.00   14.60    1.36
innodb  order_by_big_key                     14.00       -6.06%      -0.80    
12.00   14.00   13.20    0.98
innodb  order_by_big_key2                    12.00       +3.23%       0.40    
11.00   14.00   12.40    1.02
innodb  order_by_big_key_desc                12.00       +9.09%       1.20    
12.00   15.00   13.20    1.17
innodb  order_by_big_key_diff                13.00       -6.56%      -0.80    
11.00   13.00   12.20    0.75
innodb  order_by_big_key_prefix              11.00       +8.33%       1.00    
11.00   13.00   12.00    0.89
innodb  order_by_key2_diff                    1.00      +37.50%       0.60     
1.00    2.00    1.60    0.49
innodb  order_by_key_prefix                   1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  order_by_range                        1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  outer_join                           22.00      -14.58%      -2.80    
17.00   22.00   19.20    2.04
innodb  outer_join_found                     22.00      -15.79%      -3.00    
15.00   22.00   19.00    2.90
innodb  outer_join_not_found                 19.00      -15.85%      -2.60    
13.00   19.00   16.40    2.42
innodb  outer_join_on_key                    15.00      -17.19%      -2.20    
11.00   15.00   12.80    1.47
innodb  prepared_select                      33.00       -0.61%      -0.20    
32.00   33.00   32.80    0.40
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      -25.00%      -0.60     
2.00    3.00    2.40    0.49
innodb  select_2_rows                         2.00      +28.57%       0.80     
2.00    3.00    2.80    0.40
innodb  select_big                           13.00      -12.07%      -1.40    
10.00   13.00   11.60    1.36
innodb  select_big_str                        1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  select_cache                         64.00       -8.84%      -5.20    
53.00   64.00   58.80    4.17
innodb  select_cache2                        57.00       +2.73%       1.60    
51.00   67.00   58.60    6.02
innodb  select_column+column                  3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  select_distinct                       4.00       +4.76%       0.20     
4.00    5.00    4.20    0.40
innodb  select_group                         15.00       -2.74%      -0.40    
14.00   15.00   14.60    0.49
innodb  select_group_when_MANY_tables         4.00       +9.09%       0.40     
4.00    5.00    4.40    0.49
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           51.00       -5.81%      -2.80    
46.00   51.00   48.20    1.72
innodb  select_key2                          62.00       -0.00%       0.00    
60.00   64.00   62.00    1.41
innodb  select_key2_return_key               59.00       -0.00%       0.00    
57.00   61.00   59.00    1.26
innodb  select_key2_return_prim              61.00       -0.33%      -0.20    
60.00   62.00   60.80    0.75
innodb  select_key_prefix                    59.00       +1.99%       1.20    
58.00   63.00   60.20    1.72
innodb  select_key_prefix_join                4.00      +13.04%       0.60     
4.00    5.00    4.60    0.49
innodb  select_key_return_key                55.00      -12.24%      -6.00    
46.00   55.00   49.00    3.16
innodb  select_many_fields                   12.00       +4.76%       0.60    
12.00   13.00   12.60    0.49
innodb  select_range                         54.00      -15.38%      -7.20    
44.00   54.00   46.80    3.76
innodb  select_range_key2                     8.00       +9.09%       0.80     
8.00    9.00    8.80    0.40
innodb  select_range_prefix                   9.00       -9.76%      -0.80     
8.00    9.00    8.20    0.40
innodb  select_simple                         1.00       -0.00%       0.00     
1.00    1.00    1.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                    0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  update_autocommit                     3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  update_big                           58.00      -21.34%     -10.20    
33.00   59.00   47.80   10.53
innodb  update_commit                         2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  update_of_key                        27.00      +10.00%       3.00    
22.00   48.00   30.00    9.23
innodb  update_of_key_big                    27.00      -15.38%      -3.60    
18.00   32.00   23.40    5.31
innodb  update_of_primary_key_many_keys     904.00      +35.73%     502.60   
816.00 3463.00 1406.60 1,029.04
innodb  update_rollback                       2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  update_with_key                     111.00       -0.36%      -0.40   
101.00  135.00  110.60   12.69
innodb  update_with_key_prefix               38.00       +2.06%       0.80    
36.00   46.00   38.80    3.66
innodb  wisc_benchmark                        3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00      -27.17%      -7.05    
11.00   44.00   25.95    9.64
innodb  alter_table_drop                     25.00      -19.62%      -4.10    
11.00   32.00   20.90    6.02
innodb  connect                               2.00      +11.11%       0.25     
2.00    3.00    2.25    0.43
innodb  connect+select_1_row                  3.00       -1.69%      -0.05     
2.00    3.00    2.95    0.22
innodb  connect+select_simple                 3.00      -20.00%      -0.50     
2.00    3.00    2.50    0.50
innodb  count                                15.00       -1.69%      -0.25    
13.00   17.00   14.75    1.76
innodb  count_distinct                        6.00       +4.00%       0.25     
5.00    8.00    6.25    0.77
innodb  count_distinct_2                     11.00      +11.65%       1.45    
11.00   15.00   12.45    1.72
innodb  count_distinct_big                   19.00      +10.80%       2.30    
19.00   24.00   21.30    1.79
innodb  count_distinct_group                 12.00       +6.98%       0.90    
11.00   15.00   12.90    1.22
innodb  count_distinct_group_on_key           9.00       +4.26%       0.40     
8.00   11.00    9.40    1.11
innodb  count_distinct_group_on_key_parts    10.00      +17.36%       2.10    
10.00   15.00   12.10    1.41
innodb  count_distinct_key_prefix             5.00       +1.96%       0.10     
4.00    7.00    5.10    0.70
innodb  count_group_on_key_parts             10.00       -2.56%      -0.25     
8.00   11.00    9.75    0.83
innodb  count_on_key                         85.00       +0.82%       0.70    
79.00   91.00   85.70    2.88
innodb  create+drop                          40.00       +6.10%       2.60    
26.00   66.00   42.60   12.50
innodb  create_index                          3.00       -3.45%      -0.10     
1.00    5.00    2.90    0.94
innodb  create_key+drop                      31.00       +1.59%       0.50    
26.00   42.00   31.50    5.51
innodb  create_MANY_tables                   60.00       -0.84%      -0.50    
28.00   96.00   59.50   20.99
innodb  create_table                          0.00     +100.00%       0.10     
0.00    2.00    0.10    0.44
innodb  delete_all_many_keys                349.00      +51.44%     369.70   
302.00 2230.00  718.70  601.32
innodb  delete_autocommit                     3.00      +17.81%       0.65     
3.00    5.00    3.65    0.65
innodb  delete_big                            0.00     +100.00%       0.25     
0.00    1.00    0.25    0.43
innodb  delete_big_many_keys                349.00      +51.44%     369.70   
302.00 2230.00  718.70  601.32
innodb  delete_commit                         1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  delete_key                            5.00      -29.87%      -1.15     
2.00    7.00    3.85    1.28
innodb  delete_range                          7.00       +2.10%       0.15     
5.00   10.00    7.15    1.28
innodb  delete_rollback                       1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  drop_index                            4.00      -15.94%      -0.55     
2.00    8.00    3.45    1.63
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  drop_table_when_MANY_tables          25.00      -15.47%      -3.35    
13.00   32.00   21.65    5.40
innodb  insert                              106.00       +4.25%       4.70   
100.00  137.00  110.70   12.78
innodb  insert_autocommit                     3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  insert_commit                         1.00      +20.00%       0.25     
1.00    2.00    1.25    0.43
innodb  insert_duplicates                    14.00       +4.11%       0.60    
13.00   17.00   14.60    0.92
innodb  insert_key                          289.00      +28.04%     112.60   
193.00  932.00  401.60  234.24
innodb  insert_many_fields                    9.00      -28.57%      -2.00     
5.00   11.00    7.00    1.61
innodb  insert_rollback                       1.00      +39.39%       0.65     
1.00    2.00    1.65    0.48
innodb  insert_select_1_key                   4.00       -5.26%      -0.20     
2.00    5.00    3.80    0.81
innodb  insert_select_2_keys                  6.00       +5.51%       0.35     
4.00   11.00    6.35    2.08
innodb  min_max                               8.00      -10.34%      -0.75     
6.00    9.00    7.25    1.04
innodb  min_max_on_key                       21.00      -10.24%      -1.95    
17.00   21.00   19.05    1.36
innodb  multiple_value_insert                 6.00      +17.24%       1.25     
3.00   19.00    7.25    5.03
innodb  once_prepared_select                 23.00       +2.75%       0.65    
22.00   25.00   23.65    0.79
innodb  order_by_big                         15.00       -4.53%      -0.65    
12.00   16.00   14.35    1.28
innodb  order_by_big_key                     14.00       -9.80%      -1.25    
11.00   15.00   12.75    1.18
innodb  order_by_big_key2                    12.00       -0.00%       0.00    
10.00   14.00   12.00    1.18
innodb  order_by_big_key_desc                12.00       +9.77%       1.30    
11.00   15.00   13.30    1.14
innodb  order_by_big_key_diff                13.00       -8.33%      -1.00    
10.00   13.00   12.00    1.00
innodb  order_by_big_key_prefix              11.00      +10.93%       1.35    
11.00   14.00   12.35    1.01
innodb  order_by_key2_diff                    1.00      +35.48%       0.55     
1.00    2.00    1.55    0.50
innodb  order_by_key_prefix                   1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  order_by_range                        1.00      -33.33%      -0.25     
0.00    1.00    0.75    0.43
innodb  outer_join                           22.00      -17.96%      -3.35    
16.00   23.00   18.65    2.26
innodb  outer_join_found                     22.00      -19.57%      -3.60    
15.00   22.00   18.40    2.31
innodb  outer_join_not_found                 19.00      -19.87%      -3.15    
13.00   19.00   15.85    2.08
innodb  outer_join_on_key                    15.00      -19.52%      -2.45    
10.00   15.00   12.55    1.36
innodb  prepared_select                      33.00       -1.85%      -0.60    
31.00   33.00   32.40    0.58
innodb  select_1_row                          2.00      +27.27%       0.75     
2.00    3.00    2.75    0.43
innodb  select_1_row_cache                    3.00      -22.45%      -0.55     
2.00    3.00    2.45    0.50
innodb  select_2_rows                         2.00      +25.93%       0.70     
2.00    3.00    2.70    0.46
innodb  select_big                           13.00      -14.54%      -1.65    
10.00   13.00   11.35    1.06
innodb  select_big_str                        1.00      +13.04%       0.15     
1.00    2.00    1.15    0.36
innodb  select_cache                         64.00      -10.06%      -5.85    
51.00   66.00   58.15    4.29
innodb  select_cache2                        57.00       +3.88%       2.30    
51.00   68.00   59.30    6.17
innodb  select_column+column                  3.00      -11.11%      -0.30     
2.00    3.00    2.70    0.46
innodb  select_diff_key                       0.00     +100.00%       0.25     
0.00    1.00    0.25    0.43
innodb  select_distinct                       4.00      +10.11%       0.45     
4.00    5.00    4.45    0.50
innodb  select_group                         15.00       -0.33%      -0.05    
13.00   18.00   14.95    1.16
innodb  select_group_when_MANY_tables         4.00      +19.19%       0.95     
4.00    7.00    4.95    0.80
innodb  select_join                           1.00      -42.86%      -0.30     
0.00    1.00    0.70    0.46
innodb  select_key                           51.00       -3.76%      -1.85    
46.00   54.00   49.15    2.13
innodb  select_key2                          62.00       -1.89%      -1.15    
59.00   64.00   60.85    1.49
innodb  select_key2_return_key               59.00       -0.34%      -0.20    
57.00   61.00   58.80    0.98
innodb  select_key2_return_prim              61.00       -3.39%      -2.00    
57.00   62.00   59.00    1.45
innodb  select_key_prefix                    59.00       +2.56%       1.55    
58.00   63.00   60.55    1.16
innodb  select_key_prefix_join                4.00      +12.09%       0.55     
4.00    5.00    4.55    0.50
innodb  select_key_return_key                55.00      -16.77%      -7.90    
43.00   55.00   47.10    2.47
innodb  select_many_fields                   12.00       +6.61%       0.85    
12.00   14.00   12.85    0.57
innodb  select_range                         54.00      -14.29%      -6.75    
44.00   54.00   47.25    3.39
innodb  select_range_key2                     8.00       +8.57%       0.75     
8.00    9.00    8.75    0.43
innodb  select_range_prefix                   9.00      -12.50%      -1.00     
7.00    9.00    8.00    0.55
innodb  select_simple                         1.00      +33.33%       0.50     
1.00    2.00    1.50    0.50
innodb  select_simple_cache                   2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  select_simple_join                    0.00     +100.00%       0.55     
0.00    1.00    0.55    0.50
innodb  update_autocommit                     3.00       +9.09%       0.30     
3.00    4.00    3.30    0.46
innodb  update_big                           58.00       -8.51%      -4.55    
33.00   86.00   53.45   14.40
innodb  update_commit                         2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  update_of_key                        27.00      +16.02%       5.15    
22.00   58.00   32.15   11.11
innodb  update_of_key_big                    27.00       -5.06%      -1.30    
17.00   37.00   25.70    6.30
innodb  update_of_primary_key_many_keys     904.00      +52.71%    1007.70   
804.00 5957.00 1911.70 1,597.68
innodb  update_rollback                       2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  update_with_key                     111.00       +1.29%       1.45   
101.00  135.00  112.45   10.91
innodb  update_with_key_prefix               38.00       +3.55%       1.40    
36.00   48.00   39.40    3.54
innodb  wisc_benchmark                        3.00      -25.00%      -0.60     
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                      33.00     -171.10%     -20.83    
11.00   14.00   12.17    0.87
innodb  alter_table_drop                     25.00     -119.03%     -13.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                                15.00       -0.00%       0.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                     11.00       +9.37%       1.14    
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                 12.00       +5.18%       0.66    
11.00   14.00   12.66    0.84
innodb  count_distinct_group_on_key           9.00       -1.16%      -0.10     
8.00   11.00    8.90    1.12
innodb  count_distinct_group_on_key_parts    10.00      +14.96%       1.76    
10.00   15.00   11.76    1.36
innodb  count_distinct_key_prefix             5.00       -5.84%      -0.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                         85.00      -10.04%      -7.76    
73.00   83.00   77.24    2.25
innodb  create+drop                          40.00     -104.95%     -20.48    
19.00   21.00   19.52    0.56
innodb  create_index                          3.00      -58.18%      -1.10     
1.00    3.00    1.90    0.48
innodb  create_key+drop                      31.00      -37.46%      -8.45    
21.00   23.00   22.55    0.56
innodb  create_MANY_tables                   60.00     -251.52%     -42.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                349.00      -17.41%     -51.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                349.00      -17.45%     -51.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                            5.00     -104.23%      -2.55     
2.00    3.00    2.45    0.50
innodb  delete_range                          7.00       -0.50%      -0.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                            4.00     -103.51%      -2.03     
1.00    3.00    1.97    0.32
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.22
innodb  drop_table_when_MANY_tables          25.00      -85.42%     -11.52    
12.00   15.00   13.48    0.62
innodb  insert                              106.00      -16.88%     -15.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                          289.00       -0.48%      -1.38   
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                       1.00      +29.27%       0.41     
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                  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                       21.00      -24.54%      -4.14    
14.00   20.00   16.86    1.28
innodb  multiple_value_insert                 6.00      -32.82%      -1.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                12.00       +6.95%       0.90    
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              11.00       +8.07%       0.97    
11.00   13.00   11.97    0.85
innodb  order_by_key2_diff                    1.00      +14.71%       0.17     
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                        1.00      -38.10%      -0.28     
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                     22.00      -30.47%      -5.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                    15.00      -25.36%      -3.03    
10.00   15.00   11.97    1.50
innodb  prepared_select                      33.00      -27.60%      -7.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                         2.00       +9.38%       0.21     
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.74%       0.11     
0.00    2.00    1.11    0.32
innodb  select_cache                         64.00      -11.14%      -6.41    
51.00   71.00   57.59    5.41
innodb  select_cache2                        57.00       -0.24%      -0.14    
51.00   68.00   56.86    4.88
innodb  select_column+column                  3.00      -12.99%      -0.34     
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                         15.00       +1.36%       0.21    
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                           51.00      -14.56%      -6.48    
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              61.00      -26.00%     -12.59    
43.00   55.00   48.41    2.92
innodb  select_key_prefix                    59.00      -16.16%      -8.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                55.00      -26.19%     -11.41    
39.00   49.00   43.59    2.65
innodb  select_many_fields                   12.00      +27.04%       4.45    
15.00   17.00   16.45    0.62
innodb  select_range                         54.00      -10.52%      -5.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  update_autocommit                     3.00       -7.41%      -0.21     
2.00    3.00    2.79    0.41
innodb  update_big                           58.00      -60.96%     -21.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                        27.00      -40.07%      -7.72    
19.00   20.00   19.28    0.45
innodb  update_of_key_big                    27.00      -47.46%      -8.69    
16.00   20.00   18.31    1.18
innodb  update_of_primary_key_many_keys     904.00      -18.43%    -140.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                     111.00      -20.97%     -19.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                        3.00      -27.94%      -0.66     
2.00    3.00    2.34    0.48

=========================================================================================================================

_______________________________________________
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