=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   679
RUN DATE: 2010-11-21T13:40:37.631572
SERVER:   drizzled
VERSION:  staging
REVISION: 1945
COMMENT:  1945: Brian Aker 2010-11-21 [merge] Merge in simple change such that 
we use the KEY we already have, instead of

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      36.00       +1.10%       0.40    
33.00   41.00   36.40    2.65
innodb  alter_table_drop                     32.00       -6.67%      -2.00    
26.00   34.00   30.00    2.83
innodb  connect                               2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  count                                13.00       +7.14%       1.00    
13.00   17.00   14.00    1.55
innodb  count_distinct                        8.00      -29.03%      -1.80     
5.00    8.00    6.20    1.17
innodb  count_distinct_2                     14.00      -11.11%      -1.40    
11.00   14.00   12.60    1.20
innodb  count_distinct_big                   20.00       +3.85%       0.80    
20.00   23.00   20.80    1.17
innodb  count_distinct_group                 14.00       -6.06%      -0.80    
11.00   14.00   13.20    1.17
innodb  count_distinct_group_on_key          11.00      -19.57%      -1.80     
8.00   11.00    9.20    1.47
innodb  count_distinct_group_on_key_parts    14.00      -20.69%      -2.40    
10.00   14.00   11.60    1.36
innodb  count_distinct_key_prefix             6.00      -11.11%      -0.60     
5.00    6.00    5.40    0.49
innodb  count_group_on_key_parts              9.00       +2.17%       0.20     
8.00   11.00    9.20    1.17
innodb  count_on_key                         88.00       +0.23%       0.20    
84.00   96.00   88.20    4.12
innodb  create+drop                          51.00      +17.21%      10.60    
51.00   67.00   61.60    5.64
innodb  create_index                          7.00      -20.69%      -1.20     
4.00    8.00    5.80    1.47
innodb  create_key+drop                      31.00       +7.19%       2.40    
31.00   34.00   33.40    1.20
innodb  create_MANY_tables                   41.00      +17.67%       8.80    
41.00   57.00   49.80    6.18
innodb  create_table                          1.00     -400.00%      -0.80     
0.00    1.00    0.20    0.40
innodb  delete_all_many_keys               1040.00      +39.00%     664.80  
1040.00 2293.00 1704.80  407.58
innodb  delete_autocommit                     3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  delete_big                            0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys               1040.00      +39.00%     664.80  
1040.00 2293.00 1704.80  407.58
innodb  delete_commit                         2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  delete_key                            3.00       -7.14%      -0.20     
2.00    4.00    2.80    0.75
innodb  delete_range                         20.00       -3.09%      -0.60    
18.00   22.00   19.40    1.50
innodb  delete_rollback                       1.00      +50.00%       1.00     
1.00    3.00    2.00    0.63
innodb  drop_index                            6.00       -7.14%      -0.40     
5.00    6.00    5.60    0.49
innodb  drop_table_when_MANY_tables          23.00      +28.13%       9.00    
23.00   36.00   32.00    4.77
innodb  insert                              111.00       +1.07%       1.20   
109.00  114.00  112.20    1.94
innodb  insert_autocommit                     3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  insert_commit                         1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  insert_duplicates                    15.00       +6.25%       1.00    
15.00   17.00   16.00    0.89
innodb  insert_key                          577.00      +25.63%     198.80   
577.00  944.00  775.80  117.48
innodb  insert_many_fields                    8.00       +9.09%       0.80     
8.00   11.00    8.80    1.17
innodb  insert_rollback                       2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  insert_select_1_key                   4.00      +16.67%       0.80     
4.00    6.00    4.80    0.98
innodb  insert_select_2_keys                 10.00      +10.71%       1.20    
10.00   13.00   11.20    1.17
innodb  min_max                               6.00       +9.09%       0.60     
6.00    8.00    6.60    0.80
innodb  min_max_on_key                       19.00       -1.06%      -0.20    
18.00   20.00   18.80    0.75
innodb  multiple_value_insert                 6.00      +48.28%       5.60     
6.00   17.00   11.60    3.50
innodb  once_prepared_select                 25.00       -2.46%      -0.60    
23.00   25.00   24.40    0.80
innodb  order_by_big                         13.00       +9.72%       1.40    
13.00   17.00   14.40    1.50
innodb  order_by_big_key                     12.00       +1.64%       0.20    
11.00   14.00   12.20    0.98
innodb  order_by_big_key2                    11.00       +6.78%       0.80    
11.00   13.00   11.80    0.98
innodb  order_by_big_key_desc                13.00       -1.56%      -0.20    
11.00   14.00   12.80    1.17
innodb  order_by_big_key_diff                11.00       +5.17%       0.60    
10.00   13.00   11.60    1.20
innodb  order_by_big_key_prefix              11.00       +9.84%       1.20    
11.00   14.00   12.20    1.17
innodb  order_by_key2_diff                    2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  order_by_key_prefix                   0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           16.00      +15.79%       3.00    
16.00   22.00   19.00    2.28
innodb  outer_join_found                     16.00      +18.37%       3.60    
16.00   22.00   19.60    2.94
innodb  outer_join_not_found                 14.00      +14.63%       2.40    
14.00   19.00   16.40    2.06
innodb  outer_join_on_key                    13.00       +1.52%       0.20    
11.00   15.00   13.20    1.33
innodb  prepared_select                      33.00       -0.00%       0.00    
32.00   34.00   33.00    0.63
innodb  select_1_row                          3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  select_1_row_cache                    2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  select_2_rows                         3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  select_big                           11.00       +6.78%       0.80    
11.00   15.00   11.80    1.60
innodb  select_big_str                        1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  select_cache                         53.00       +2.57%       1.40    
52.00   57.00   54.40    1.85
innodb  select_cache2                        55.00       -0.00%       0.00    
52.00   61.00   55.00    3.29
innodb  select_column+column                  3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  select_distinct                       4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_group                         17.00       -6.25%      -1.00    
15.00   17.00   16.00    0.89
innodb  select_group_when_MANY_tables        31.00      +22.89%       9.20    
31.00   45.00   40.20    4.83
innodb  select_join                           0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  select_key                           52.00       -2.36%      -1.20    
48.00   55.00   50.80    2.48
innodb  select_key2                          64.00       -1.27%      -0.80    
62.00   65.00   63.20    1.17
innodb  select_key2_return_key               61.00       -2.35%      -1.40    
58.00   61.00   59.60    1.02
innodb  select_key2_return_prim              64.00       -3.90%      -2.40    
59.00   64.00   61.60    1.85
innodb  select_key_prefix                    62.00       -0.65%      -0.40    
60.00   63.00   61.60    1.02
innodb  select_key_prefix_join                5.00       -4.17%      -0.20     
4.00    5.00    4.80    0.40
innodb  select_key_return_key                50.00       +0.40%       0.20    
48.00   52.00   50.20    1.33
innodb  select_many_fields                   15.00      -10.29%      -1.40    
12.00   15.00   13.60    1.02
innodb  select_range                         50.00       -8.70%      -4.00    
44.00   50.00   46.00    2.28
innodb  select_range_key2                     9.00       -0.00%       0.00     
9.00    9.00    9.00    0.00
innodb  select_range_prefix                   8.00       -0.00%       0.00     
7.00    9.00    8.00    0.63
innodb  select_simple                         1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  select_simple_cache                   2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  select_simple_join                    1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  update_autocommit                     3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  update_big                           79.00       -1.02%      -0.80    
70.00   85.00   78.20    4.79
innodb  update_commit                         2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  update_of_key                        24.00       -0.00%       0.00    
23.00   25.00   24.00    0.63
innodb  update_of_key_big                    66.00      -11.49%      -6.80    
53.00   66.00   59.20    4.66
innodb  update_of_primary_key_many_keys    2805.00      +38.00%    1719.00  
2805.00 6065.00 4524.00 1,060.17
innodb  update_rollback                       2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  update_with_key                     121.00       +1.14%       1.40   
112.00  128.00  122.40    5.68
innodb  update_with_key_prefix               41.00       +4.65%       2.00    
41.00   44.00   43.00    1.26
innodb  wisc_benchmark                        3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      36.00       -5.73%      -1.95    
16.00   41.00   34.05    4.82
innodb  alter_table_drop                     32.00      -15.32%      -4.25    
12.00   34.00   27.75    4.38
innodb  connect                               2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
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                                13.00       +6.47%       0.90    
13.00   18.00   13.90    1.61
innodb  count_distinct                        8.00      -28.00%      -1.75     
5.00    8.00    6.25    0.89
innodb  count_distinct_2                     14.00       -9.80%      -1.25    
11.00   15.00   12.75    1.61
innodb  count_distinct_big                   20.00       +4.08%       0.85    
19.00   25.00   20.85    1.59
innodb  count_distinct_group                 14.00       -8.53%      -1.10    
11.00   16.00   12.90    1.45
innodb  count_distinct_group_on_key          11.00      -17.65%      -1.65     
8.00   12.00    9.35    1.35
innodb  count_distinct_group_on_key_parts    14.00      -18.14%      -2.15    
10.00   15.00   11.85    1.53
innodb  count_distinct_key_prefix             6.00      -20.00%      -1.00     
4.00    6.00    5.00    0.77
innodb  count_group_on_key_parts              9.00       +9.09%       0.90     
8.00   12.00    9.90    1.04
innodb  count_on_key                         88.00       -0.86%      -0.75    
82.00   96.00   87.25    3.10
innodb  create+drop                          51.00       +6.51%       3.55    
33.00   67.00   54.55   10.36
innodb  create_index                          7.00      -70.73%      -2.90     
2.00    8.00    4.10    1.45
innodb  create_key+drop                      31.00       +6.20%       2.05    
27.00   37.00   33.05    2.56
innodb  create_MANY_tables                   41.00      +19.45%       9.90    
35.00   62.00   50.90    7.39
innodb  create_table                          1.00     -233.33%      -0.70     
0.00    2.00    0.30    0.64
innodb  delete_all_many_keys               1040.00      +18.56%     237.00   
313.00 2293.00 1277.00  634.59
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.55     
0.00    1.00    0.55    0.50
innodb  delete_big_many_keys               1040.00      +18.56%     236.95   
313.00 2293.00 1276.95  634.56
innodb  delete_commit                         2.00      -14.29%      -0.25     
1.00    2.00    1.75    0.43
innodb  delete_key                            3.00       -5.26%      -0.15     
2.00    4.00    2.85    0.57
innodb  delete_range                         20.00      -25.39%      -4.05     
6.00   22.00   15.95    3.97
innodb  delete_rollback                       1.00      +41.18%       0.70     
1.00    3.00    1.70    0.56
innodb  drop_index                            6.00      -18.81%      -0.95     
3.00    7.00    5.05    1.07
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  drop_table_when_MANY_tables          23.00      +24.47%       7.45    
18.00   38.00   30.45    6.21
innodb  insert                              111.00       -3.21%      -3.45    
97.00  114.00  107.55    5.61
innodb  insert_autocommit                     3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  insert_commit                         1.00      +23.08%       0.30     
1.00    2.00    1.30    0.46
innodb  insert_duplicates                    15.00       +2.28%       0.35    
14.00   17.00   15.35    0.85
innodb  insert_key                          577.00       +6.79%      42.00   
236.00  944.00  619.00  230.69
innodb  insert_many_fields                    8.00       +1.84%       0.15     
5.00   11.00    8.15    1.39
innodb  insert_rollback                       2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  insert_select_1_key                   4.00      +13.98%       0.65     
3.00    6.00    4.65    1.01
innodb  insert_select_2_keys                 10.00       +0.50%       0.05     
6.00   13.00   10.05    1.96
innodb  min_max                               6.00      +11.76%       0.80     
6.00    9.00    6.80    0.93
innodb  min_max_on_key                       19.00       -2.43%      -0.45    
17.00   20.00   18.55    0.86
innodb  multiple_value_insert                 6.00      +40.59%       4.10     
3.00   21.00   10.10    5.80
innodb  once_prepared_select                 25.00       -4.82%      -1.15    
23.00   25.00   23.85    0.73
innodb  order_by_big                         13.00       +1.89%       0.25    
12.00   17.00   13.25    1.37
innodb  order_by_big_key                     12.00       +4.00%       0.50    
11.00   15.00   12.50    1.20
innodb  order_by_big_key2                    11.00       +2.65%       0.30    
10.00   13.00   11.30    1.10
innodb  order_by_big_key_desc                13.00       -0.78%      -0.10    
11.00   15.00   12.90    1.09
innodb  order_by_big_key_diff                11.00       +3.51%       0.40    
10.00   13.00   11.40    1.11
innodb  order_by_big_key_prefix              11.00       +5.98%       0.70    
10.00   14.00   11.70    1.00
innodb  order_by_key2_diff                    2.00      -37.93%      -0.55     
1.00    2.00    1.45    0.50
innodb  order_by_key_prefix                   0.00     +100.00%       0.75     
0.00    1.00    0.75    0.43
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           16.00      +16.23%       3.10    
16.00   22.00   19.10    2.00
innodb  outer_join_found                     16.00      +13.98%       2.60    
15.00   22.00   18.60    2.52
innodb  outer_join_not_found                 14.00      +13.58%       2.20    
14.00   19.00   16.20    1.83
innodb  outer_join_on_key                    13.00       -0.39%      -0.05    
11.00   15.00   12.95    1.24
innodb  prepared_select                      33.00       -1.07%      -0.35    
31.00   34.00   32.65    0.85
innodb  select_1_row                          3.00       -3.45%      -0.10     
2.00    3.00    2.90    0.30
innodb  select_1_row_cache                    2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  select_2_rows                         3.00       -3.45%      -0.10     
2.00    3.00    2.90    0.30
innodb  select_big                           11.00       +4.76%       0.55    
10.00   15.00   11.55    1.20
innodb  select_big_str                        1.00      +13.04%       0.15     
1.00    2.00    1.15    0.36
innodb  select_cache                         53.00       +7.02%       4.00    
52.00   65.00   57.00    3.22
innodb  select_cache2                        55.00       +2.83%       1.60    
51.00   66.00   56.60    4.29
innodb  select_column+column                  3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  select_diff_key                       0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  select_distinct                       4.00       +3.61%       0.15     
4.00    5.00    4.15    0.36
innodb  select_group                         17.00       -5.92%      -0.95    
14.00   18.00   16.05    1.36
innodb  select_group_when_MANY_tables        31.00       +8.28%       2.80    
16.00   45.00   33.80    8.79
innodb  select_join                           0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  select_key                           52.00       -6.23%      -3.05    
45.00   55.00   48.95    2.36
innodb  select_key2                          64.00       -3.23%      -2.00    
60.00   65.00   62.00    1.30
innodb  select_key2_return_key               61.00       -2.87%      -1.70    
57.00   62.00   59.30    1.19
innodb  select_key2_return_prim              64.00       -6.58%      -3.95    
57.00   64.00   60.05    1.91
innodb  select_key_prefix                    62.00       -1.72%      -1.05    
59.00   63.00   60.95    1.24
innodb  select_key_prefix_join                5.00       -6.38%      -0.30     
4.00    5.00    4.70    0.46
innodb  select_key_return_key                50.00       -3.20%      -1.55    
44.00   53.00   48.45    2.22
innodb  select_many_fields                   15.00      -12.78%      -1.70    
12.00   15.00   13.30    0.84
innodb  select_range                         50.00       -4.49%      -2.15    
44.00   53.00   47.85    3.26
innodb  select_range_key2                     9.00       -2.86%      -0.25     
7.00    9.00    8.75    0.54
innodb  select_range_prefix                   8.00       +0.62%       0.05     
7.00    9.00    8.05    0.59
innodb  select_simple                         1.00      +39.39%       0.65     
1.00    2.00    1.65    0.48
innodb  select_simple_cache                   2.00      -48.15%      -0.65     
1.00    2.00    1.35    0.48
innodb  select_simple_join                    1.00      -53.85%      -0.35     
0.00    1.00    0.65    0.48
innodb  update_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  update_big                           79.00      -15.24%     -10.45    
38.00   85.00   68.55    9.77
innodb  update_commit                         2.00      -37.93%      -0.55     
1.00    2.00    1.45    0.50
innodb  update_of_key                        24.00       -5.73%      -1.30    
20.00   25.00   22.70    1.68
innodb  update_of_key_big                    66.00      -23.71%     -12.65    
27.00   66.00   53.35    8.86
innodb  update_of_primary_key_many_keys    2805.00      +17.06%     576.80   
829.00 6065.00 3381.80 1,685.12
innodb  update_rollback                       2.00      -21.21%      -0.35     
1.00    2.00    1.65    0.48
innodb  update_with_key                     121.00       -3.95%      -4.60   
103.00  128.00  116.40    7.43
innodb  update_with_key_prefix               41.00       +0.49%       0.20    
38.00   44.00   41.20    2.14
innodb  wisc_benchmark                        3.00      -27.66%      -0.65     
2.00    3.00    2.35    0.48

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      36.00     -195.75%     -23.83    
11.00   14.00   12.17    0.87
innodb  alter_table_drop                     32.00     -180.36%     -20.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                                13.00      +13.33%       2.00    
13.00   18.00   15.00    1.76
innodb  count_distinct                        8.00      -31.82%      -1.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                   20.00       +6.30%       1.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          11.00      -23.64%      -2.10     
8.00   11.00    8.90    1.12
innodb  count_distinct_group_on_key_parts    14.00      -19.06%      -2.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              9.00      -10.59%      -0.86     
7.00   10.00    8.14    0.78
innodb  count_on_key                         88.00      -13.93%     -10.76    
73.00   83.00   77.24    2.25
innodb  create+drop                          51.00     -161.31%     -31.48    
19.00   21.00   19.52    0.56
innodb  create_index                          7.00     -269.09%      -5.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                   41.00     -140.20%     -23.93    
14.00   20.00   17.07    1.70
innodb  create_table                          1.00    -1349.99%      -0.93     
0.00    1.00    0.07    0.25
innodb  delete_all_many_keys               1040.00     -249.88%    -742.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               1040.00     -250.01%    -742.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                         20.00     -187.13%     -13.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     +100.00%       0.04     
0.00    2.00    0.04    0.22
innodb  drop_table_when_MANY_tables          23.00      -70.59%      -9.52    
12.00   15.00   13.48    0.62
innodb  insert                              111.00      -22.40%     -20.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                    15.00      -16.94%      -2.17    
12.00   14.00   12.83    0.53
innodb  insert_key                          577.00     -100.61%    -289.38   
189.00  345.00  287.62   32.94
innodb  insert_many_fields                    8.00      -96.61%      -3.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                 10.00      -93.33%      -4.83     
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                       19.00      -12.68%      -2.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                 25.00      -19.24%      -4.03    
20.00   22.00   20.97    0.61
innodb  order_by_big                         13.00       +8.05%       1.14    
12.00   15.00   14.14    0.94
innodb  order_by_big_key                     12.00       +3.33%       0.41    
11.00   14.00   12.41    1.19
innodb  order_by_big_key2                    11.00       +4.20%       0.48    
10.00   13.00   11.48    0.97
innodb  order_by_big_key_desc                13.00       -0.80%      -0.10    
12.00   14.00   12.90    0.92
innodb  order_by_big_key_diff                11.00       +5.06%       0.59    
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                    2.00      -70.59%      -0.83     
1.00    2.00    1.17    0.38
innodb  order_by_key_prefix                   0.00     +100.00%       0.62     
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                           16.00       +7.75%       1.34    
15.00   21.00   17.34    2.06
innodb  outer_join_found                     16.00       +5.11%       0.86    
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                      33.00      -27.60%      -7.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                    2.00       +3.33%       0.07     
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                           11.00       +5.34%       0.62    
10.00   13.00   11.62    1.00
innodb  select_big_str                        1.00       +9.60%       0.11     
0.00    2.00    1.11    0.31
innodb  select_cache                         53.00       +7.96%       4.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                  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                         17.00      -11.79%      -1.79    
13.00   18.00   15.21    1.47
innodb  select_group_when_MANY_tables        31.00     -675.00%     -27.00     
3.00    5.00    4.00    0.37
innodb  select_join                           0.00     +100.00%       0.48     
0.00    1.00    0.48    0.50
innodb  select_key                           52.00      -16.81%      -7.48    
40.00   50.00   44.52    2.50
innodb  select_key2                          64.00      -29.88%     -14.72    
46.00   54.00   49.28    2.41
innodb  select_key2_return_key               61.00      -29.98%     -14.07    
42.00   51.00   46.93    2.32
innodb  select_key2_return_prim              64.00      -32.19%     -15.59    
43.00   55.00   48.41    2.92
innodb  select_key_prefix                    62.00      -22.06%     -11.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                50.00      -14.72%      -6.41    
39.00   49.00   43.59    2.65
innodb  select_many_fields                   15.00       +8.81%       1.45    
15.00   17.00   16.45    0.62
innodb  select_range                         50.00       -2.33%      -1.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                    1.00      -38.10%      -0.28     
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                           79.00     -119.23%     -42.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                        24.00      -24.51%      -4.72    
19.00   20.00   19.28    0.45
innodb  update_of_key_big                    66.00     -260.45%     -47.69    
16.00   20.00   18.31    1.18
innodb  update_of_primary_key_many_keys    2805.00     -267.47%   -2041.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                     121.00      -31.87%     -29.24    
90.00   93.00   91.76    0.97
innodb  update_with_key_prefix               41.00      -16.34%      -5.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

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

  1938.4.9: Brian Aker 2010-11-19 There is no need to calculate the identifier 
since we have a key.

_______________________________________________
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