=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   975
RUN DATE: 2011-03-24T19:40:08.226346
SERVER:   drizzled
VERSION:  staging
REVISION: 2251
COMMENT:  2251: Brian Aker 2011-03-24 [merge] Merge in XTF

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00       -3.13%      -1.00    
31.00   33.00   32.00    0.63
innodb  alter_table_drop                     23.00       +2.54%       0.60    
23.00   25.00   23.60    0.80
innodb  connect                               2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
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       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  count                                17.00       -8.97%      -1.40    
13.00   17.00   15.60    1.74
innodb  count_distinct                        8.00       -5.26%      -0.40     
7.00    8.00    7.60    0.49
innodb  count_distinct_2                     17.00      -16.44%      -2.40    
12.00   17.00   14.60    1.85
innodb  count_distinct_big                   25.00       -7.76%      -1.80    
21.00   25.00   23.20    1.83
innodb  count_distinct_group                 16.00       -3.90%      -0.60    
15.00   16.00   15.40    0.49
innodb  count_distinct_group_on_key           9.00      +13.46%       1.40     
9.00   12.00   10.40    1.02
innodb  count_distinct_group_on_key_parts    13.00       +4.41%       0.60    
13.00   14.00   13.60    0.49
innodb  count_distinct_key_prefix             6.00       -7.14%      -0.40     
5.00    6.00    5.60    0.49
innodb  count_group_on_key_parts             11.00       -3.77%      -0.40    
10.00   11.00   10.60    0.49
innodb  count_on_key                         96.00       -1.48%      -1.40    
91.00   96.00   94.60    1.85
innodb  create+drop                          34.00       -0.00%       0.00    
33.00   35.00   34.00    0.63
innodb  create_index                          2.00      +28.57%       0.80     
2.00    3.00    2.80    0.40
innodb  create_key+drop                      32.00       -3.23%      -1.00    
30.00   32.00   31.00    0.89
innodb  create_MANY_tables                   20.00       +3.85%       0.80    
20.00   23.00   20.80    1.17
innodb  delete_all_many_keys                660.00       -4.23%     -26.80   
582.00  660.00  633.20   27.20
innodb  delete_autocommit                     3.00      +21.05%       0.80     
3.00    5.00    3.80    0.75
innodb  delete_big                            0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  delete_big_many_keys                660.00       -4.33%     -27.40   
581.00  660.00  632.60   27.38
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  delete_range                          9.00       -2.27%      -0.20     
8.00   10.00    8.80    0.75
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            3.00       -0.00%       0.00     
2.00    4.00    3.00    0.63
innodb  drop_table_when_MANY_tables          18.00       +1.10%       0.20    
17.00   19.00   18.20    0.75
innodb  insert                              113.00       +0.18%       0.20   
112.00  114.00  113.20    0.75
innodb  insert_autocommit                     3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  insert_commit                         2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  insert_duplicates                    19.00       -0.00%       0.00    
19.00   19.00   19.00    0.00
innodb  insert_key                          284.00       -2.45%      -6.80   
267.00  284.00  277.20    6.73
innodb  insert_many_fields                    5.00      +16.67%       1.00     
5.00    7.00    6.00    0.63
innodb  insert_rollback                       2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  insert_select_1_key                   4.00       +4.76%       0.20     
3.00    5.00    4.20    0.75
innodb  insert_select_2_keys                  6.00       -3.45%      -0.20     
5.00    6.00    5.80    0.40
innodb  min_max                               8.00       -2.56%      -0.20     
7.00    8.00    7.80    0.40
innodb  min_max_on_key                       25.00       -1.63%      -0.40    
24.00   25.00   24.60    0.49
innodb  multiple_value_insert                 6.00       +6.25%       0.40     
6.00    7.00    6.40    0.49
innodb  once_prepared_select                 30.00       -2.74%      -0.80    
28.00   30.00   29.20    0.75
innodb  order_by_big                         13.00       +2.99%       0.40    
13.00   15.00   13.40    0.80
innodb  order_by_big_key                     13.00       +7.14%       1.00    
13.00   15.00   14.00    0.89
innodb  order_by_big_key2                    13.00       -3.17%      -0.40    
12.00   14.00   12.60    0.80
innodb  order_by_big_key_desc                15.00       -8.70%      -1.20    
13.00   15.00   13.80    0.98
innodb  order_by_big_key_diff                13.00       +1.52%       0.20    
12.00   14.00   13.20    0.75
innodb  order_by_big_key_prefix              14.00       -7.69%      -1.00    
12.00   14.00   13.00    0.89
innodb  order_by_key2_diff                    1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  order_by_key_prefix                   1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  order_by_range                        1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  outer_join                           24.00       -9.09%      -2.00    
18.00   24.00   22.00    2.19
innodb  outer_join_found                     23.00       -8.49%      -1.80    
17.00   23.00   21.20    2.14
innodb  outer_join_not_found                 20.00       -5.26%      -1.00    
16.00   21.00   19.00    1.67
innodb  outer_join_on_key                    16.00      -11.11%      -1.60    
12.00   16.00   14.40    1.36
innodb  prepared_select                      37.00       -0.00%       0.00    
37.00   37.00   37.00    0.00
innodb  select_1_row                          3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  select_1_row_cache                    4.00      -25.00%      -0.80     
3.00    4.00    3.20    0.40
innodb  select_2_rows                         3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  select_big                           13.00       -0.00%       0.00    
11.00   14.00   13.00    1.10
innodb  select_big_str                        2.00      -66.67%      -0.80     
1.00    2.00    1.20    0.40
innodb  select_cache                         64.00       -1.91%      -1.20    
61.00   65.00   62.80    1.47
innodb  select_cache2                        63.00       +1.56%       1.00    
63.00   66.00   64.00    1.10
innodb  select_column+column                  4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_diff_key                       1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  select_distinct                       4.00       +9.09%       0.40     
4.00    5.00    4.40    0.49
innodb  select_group                         16.00      +11.11%       2.00    
16.00   19.00   18.00    1.10
innodb  select_group_when_MANY_tables        11.00       +1.79%       0.20    
10.00   12.00   11.20    0.75
innodb  select_join                           1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  select_key                           64.00       -0.31%      -0.20    
63.00   65.00   63.80    0.75
innodb  select_key2                          72.00       -1.41%      -1.00    
70.00   72.00   71.00    0.63
innodb  select_key2_return_key               70.00       -2.34%      -1.60    
67.00   70.00   68.40    1.02
innodb  select_key2_return_prim              71.00       -2.01%      -1.40    
69.00   71.00   69.60    0.80
innodb  select_key_prefix                    71.00       -0.57%      -0.40    
70.00   71.00   70.60    0.49
innodb  select_key_prefix_join                5.00       +3.85%       0.20     
5.00    6.00    5.20    0.40
innodb  select_key_return_key                63.00       -0.00%       0.00    
63.00   63.00   63.00    0.00
innodb  select_many_fields                   13.00       -1.56%      -0.20    
12.00   13.00   12.80    0.40
innodb  select_range                         39.00       +8.88%       3.80    
39.00   46.00   42.80    2.79
innodb  select_range_key2                    10.00       -4.17%      -0.40     
9.00   10.00    9.60    0.49
innodb  select_range_prefix                   9.00       +2.17%       0.20     
9.00   10.00    9.20    0.40
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  update_autocommit                     4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  update_big                           59.00       +0.67%       0.40    
59.00   61.00   59.40    0.80
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        22.00       -0.92%      -0.20    
21.00   22.00   21.80    0.40
innodb  update_of_key_big                    39.00      -11.43%      -4.00    
30.00   39.00   35.00    3.03
innodb  update_of_primary_key_many_keys    1321.00       -1.20%     -15.60  
1232.00 1329.00 1305.40   36.82
innodb  update_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  update_with_key                     120.00       +1.48%       1.80   
117.00  127.00  121.80    3.31
innodb  update_with_key_prefix               43.00       +2.71%       1.20    
42.00   46.00   44.20    1.47
innodb  wisc_benchmark                        3.00      -25.00%      -0.60     
2.00    3.00    2.40    0.49

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00       -1.69%      -0.55    
29.00   34.00   32.45    1.28
innodb  alter_table_drop                     23.00       +2.13%       0.50    
22.00   25.00   23.50    0.87
innodb  connect                               2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
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      -11.11%      -0.30     
2.00    3.00    2.70    0.46
innodb  count                                17.00      -10.75%      -1.65    
13.00   19.00   15.35    1.90
innodb  count_distinct                        8.00      -16.79%      -1.15     
6.00    8.00    6.85    0.73
innodb  count_distinct_2                     17.00      -23.64%      -3.25    
11.00   17.00   13.75    1.41
innodb  count_distinct_big                   25.00       -9.89%      -2.25    
21.00   25.00   22.75    1.87
innodb  count_distinct_group                 16.00       -9.22%      -1.35    
11.00   16.00   14.65    1.19
innodb  count_distinct_group_on_key           9.00       +8.16%       0.80     
8.00   12.00    9.80    0.93
innodb  count_distinct_group_on_key_parts    13.00       +1.52%       0.20    
11.00   15.00   13.20    1.17
innodb  count_distinct_key_prefix             6.00       -9.09%      -0.50     
4.00    6.00    5.50    0.67
innodb  count_group_on_key_parts             11.00       -1.38%      -0.15    
10.00   12.00   10.85    0.65
innodb  count_on_key                         96.00       -2.13%      -2.00    
91.00   97.00   94.00    1.92
innodb  create+drop                          34.00       -2.26%      -0.75    
31.00   35.00   33.25    1.04
innodb  create_index                          2.00      +35.48%       1.10     
2.00    4.00    3.10    0.44
innodb  create_key+drop                      32.00       -2.73%      -0.85    
30.00   34.00   31.15    1.01
innodb  create_MANY_tables                   20.00       +5.44%       1.15    
19.00   24.00   21.15    1.35
innodb  delete_all_many_keys                660.00       -3.38%     -21.55   
582.00  705.00  638.45   24.89
innodb  delete_autocommit                     3.00      +16.67%       0.60     
3.00    5.00    3.60    0.58
innodb  delete_big                            0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                660.00       -3.48%     -22.20   
581.00  704.00  637.80   24.91
innodb  delete_commit                         2.00       -8.11%      -0.15     
1.00    2.00    1.85    0.36
innodb  delete_key                            3.00       -7.14%      -0.20     
2.00    4.00    2.80    0.51
innodb  delete_range                          9.00       -5.88%      -0.50     
8.00   10.00    8.50    0.59
innodb  delete_rollback                       2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  drop_index                            3.00       -3.45%      -0.10     
2.00    4.00    2.90    0.44
innodb  drop_table_when_MANY_tables          18.00       +2.70%       0.50    
17.00   21.00   18.50    0.92
innodb  insert                              113.00       +0.53%       0.60   
111.00  116.00  113.60    1.24
innodb  insert_autocommit                     3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  insert_commit                         2.00       -8.11%      -0.15     
1.00    2.00    1.85    0.36
innodb  insert_duplicates                    19.00       +1.04%       0.20    
19.00   20.00   19.20    0.40
innodb  insert_key                          284.00       -2.07%      -5.75   
267.00  296.00  278.25    6.43
innodb  insert_many_fields                    5.00      +14.53%       0.85     
5.00    7.00    5.85    0.48
innodb  insert_rollback                       2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  insert_select_1_key                   4.00       -1.27%      -0.05     
3.00    5.00    3.95    0.74
innodb  insert_select_2_keys                  6.00       +2.44%       0.15     
5.00    8.00    6.15    0.73
innodb  min_max                               8.00       -4.58%      -0.35     
6.00   10.00    7.65    0.96
innodb  min_max_on_key                       25.00       -2.04%      -0.50    
24.00   25.00   24.50    0.50
innodb  multiple_value_insert                 6.00       +8.40%       0.55     
6.00    7.00    6.55    0.50
innodb  once_prepared_select                 30.00       -3.09%      -0.90    
28.00   31.00   29.10    0.77
innodb  order_by_big                         13.00       +6.47%       0.90    
13.00   16.00   13.90    1.14
innodb  order_by_big_key                     13.00       +7.47%       1.05    
12.00   16.00   14.05    1.47
innodb  order_by_big_key2                    13.00       -4.42%      -0.55    
11.00   14.00   12.45    0.86
innodb  order_by_big_key_desc                15.00       -1.69%      -0.25    
13.00   16.00   14.75    1.18
innodb  order_by_big_key_diff                13.00       +0.76%       0.10    
12.00   14.00   13.10    0.70
innodb  order_by_big_key_prefix              14.00       -8.53%      -1.10    
12.00   14.00   12.90    0.89
innodb  order_by_key2_diff                    1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  order_by_range                        1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  outer_join                           24.00       -9.09%      -2.00    
18.00   25.00   22.00    2.51
innodb  outer_join_found                     23.00       -9.52%      -2.00    
17.00   24.00   21.00    2.45
innodb  outer_join_not_found                 20.00       -3.90%      -0.75    
16.00   23.00   19.25    2.17
innodb  outer_join_on_key                    16.00       -8.47%      -1.25    
12.00   17.00   14.75    1.89
innodb  prepared_select                      37.00       +0.27%       0.10    
37.00   39.00   37.10    0.44
innodb  select_1_row                          3.00      +15.49%       0.55     
3.00    4.00    3.55    0.50
innodb  select_1_row_cache                    4.00      -15.94%      -0.55     
3.00    4.00    3.45    0.50
innodb  select_2_rows                         3.00      +17.81%       0.65     
3.00    4.00    3.65    0.48
innodb  select_big                           13.00       -2.36%      -0.30    
11.00   14.00   12.70    1.05
innodb  select_big_str                        2.00      -53.85%      -0.70     
1.00    2.00    1.30    0.46
innodb  select_cache                         64.00       -1.27%      -0.80    
59.00   71.00   63.20    2.89
innodb  select_cache2                        63.00       +2.17%       1.40    
58.00   71.00   64.40    2.99
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_diff_key                       1.00     -300.00%      -0.75     
0.00    1.00    0.25    0.43
innodb  select_distinct                       4.00      +12.09%       0.55     
4.00    5.00    4.55    0.50
innodb  select_group                         16.00       +5.88%       1.00    
15.00   19.00   17.00    1.34
innodb  select_group_when_MANY_tables        11.00       +5.58%       0.65    
10.00   13.00   11.65    0.79
innodb  select_join                           1.00      -81.82%      -0.45     
0.00    1.00    0.55    0.50
innodb  select_key                           64.00       -0.16%      -0.10    
63.00   65.00   63.90    0.54
innodb  select_key2                          72.00       -1.48%      -1.05    
70.00   72.00   70.95    0.67
innodb  select_key2_return_key               70.00       -2.56%      -1.75    
67.00   70.00   68.25    0.89
innodb  select_key2_return_prim              71.00       -2.75%      -1.90    
68.00   71.00   69.10    0.77
innodb  select_key_prefix                    71.00       -0.64%      -0.45    
69.00   72.00   70.55    0.80
innodb  select_key_prefix_join                5.00       +4.76%       0.25     
5.00    6.00    5.25    0.43
innodb  select_key_return_key                63.00       -0.32%      -0.20    
61.00   64.00   62.80    0.75
innodb  select_many_fields                   13.00       +0.76%       0.10    
12.00   14.00   13.10    0.44
innodb  select_range                         39.00       +8.67%       3.70    
39.00   47.00   42.70    2.97
innodb  select_range_key2                    10.00       -5.82%      -0.55     
9.00   10.00    9.45    0.50
innodb  select_range_prefix                   9.00       +3.74%       0.35     
8.00   10.00    9.35    0.57
innodb  select_simple                         2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  update_autocommit                     4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
innodb  update_big                           59.00       -0.25%      -0.15    
56.00   62.00   58.85    1.53
innodb  update_commit                         2.00       -0.00%       0.00     
1.00    3.00    2.00    0.32
innodb  update_of_key                        22.00       +0.23%       0.05    
21.00   24.00   22.05    0.80
innodb  update_of_key_big                    39.00       -8.48%      -3.05    
29.00   46.00   35.95    4.49
innodb  update_of_primary_key_many_keys    1321.00       +0.39%       5.20  
1232.00 1469.00 1326.20   46.43
innodb  update_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  update_with_key                     120.00       +0.54%       0.65   
116.00  127.00  120.65    2.71
innodb  update_with_key_prefix               43.00       +1.94%       0.85    
40.00   47.00   43.85    1.96
innodb  wisc_benchmark                        3.00      -13.21%      -0.35     
2.00    3.00    2.65    0.48

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00      -52.77%     -11.40    
11.00   61.00   21.60   10.16
innodb  alter_table_drop                     23.00      -23.33%      -4.35    
10.00   57.00   18.65    6.89
innodb  connect                               2.00       +4.13%       0.09     
1.00    3.00    2.09    0.42
innodb  connect+select_1_row                  3.00      -10.59%      -0.29     
2.00    5.00    2.71    0.47
innodb  connect+select_simple                 3.00      -27.05%      -0.64     
1.00    3.00    2.36    0.49
innodb  count                                17.00       -7.95%      -1.25    
12.00  193.00   15.75    8.62
innodb  count_distinct                        8.00      -21.61%      -1.42     
5.00   50.00    6.58    2.22
innodb  count_distinct_2                     17.00      -28.57%      -3.78    
11.00   63.00   13.22    2.90
innodb  count_distinct_big                   25.00      -13.75%      -3.02     
5.00   67.00   21.98    2.98
innodb  count_distinct_group                 16.00      -21.03%      -2.78    
10.00   68.00   13.22    3.04
innodb  count_distinct_group_on_key           9.00       +5.33%       0.51     
7.00   69.00    9.51    2.95
innodb  count_distinct_group_on_key_parts    13.00       -5.09%      -0.63     
9.00   72.00   12.37    3.09
innodb  count_distinct_key_prefix             6.00      -16.72%      -0.86     
3.00   52.00    5.14    2.33
innodb  count_group_on_key_parts             11.00       -9.75%      -0.98     
7.00   72.00   10.02    3.08
innodb  count_on_key                         96.00      -11.18%      -9.65    
68.00  107.00   86.35    7.38
innodb  create+drop                          34.00       -4.70%      -1.53    
18.00   75.00   32.47   11.60
innodb  create_index                          2.00      +31.07%       0.90     
1.00    8.00    2.90    1.12
innodb  create_key+drop                      32.00      -12.89%      -3.65    
21.00   50.00   28.35    4.84
innodb  create_MANY_tables                   20.00      +40.16%      13.42    
14.00  121.00   33.42   16.91
innodb  create_table                          0.00     +100.00%       0.10     
0.00    3.00    0.10    0.36
innodb  delete_all_many_keys                660.00      -39.47%    -186.77   
212.00 1888.00  473.23  357.49
innodb  delete_autocommit                     3.00      +13.10%       0.45     
2.00   14.00    3.45    0.74
innodb  delete_big                            0.00     +100.00%       0.30     
0.00    3.00    0.30    0.47
innodb  delete_big_many_keys                660.00      -37.80%    -181.04   
212.00 2293.00  478.96  371.12
innodb  delete_commit                         2.00      -30.82%      -0.47     
1.00    5.00    1.53    0.53
innodb  delete_key                            3.00       +1.31%       0.04     
2.00   35.00    3.04    1.47
innodb  delete_range                          9.00       -8.10%      -0.67     
5.00   23.00    8.33    3.16
innodb  delete_rollback                       2.00      -13.85%      -0.24     
1.00   12.00    1.76    0.90
innodb  drop_index                            3.00       -1.65%      -0.05     
1.00    9.00    2.95    1.29
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    2.00    0.05    0.23
innodb  drop_table_when_MANY_tables          18.00       +7.83%       1.53    
11.00   90.00   19.53    7.35
innodb  insert                              113.00       -5.57%      -5.97     
3.00  343.00  107.03   14.32
innodb  insert_autocommit                     3.00       +0.22%       0.01     
2.00   99.00    3.01    3.23
innodb  insert_commit                         2.00      -42.70%      -0.60     
1.00    3.00    1.40    0.50
innodb  insert_duplicates                    19.00      -21.50%      -3.36    
11.00   21.00   15.64    2.71
innodb  insert_key                          284.00       +5.93%      17.90   
142.00  700.00  301.90  104.35
innodb  insert_many_fields                    5.00      +11.01%       0.62     
3.00   17.00    5.62    1.73
innodb  insert_rollback                       2.00      -18.79%      -0.32     
1.00    3.00    1.68    0.53
innodb  insert_select_1_key                   4.00       -5.61%      -0.21     
2.00   10.00    3.79    0.88
innodb  insert_select_2_keys                  6.00       +1.26%       0.08     
4.00   16.00    6.08    2.04
innodb  min_max                               8.00       -2.25%      -0.18     
6.00  110.00    7.82    4.44
innodb  min_max_on_key                       25.00      -20.60%      -4.27    
14.00   37.00   20.73    3.13
innodb  multiple_value_insert                 6.00       -8.99%      -0.50     
2.00   50.00    5.50    4.19
innodb  once_prepared_select                 30.00      -22.76%      -5.56    
18.00   32.00   24.44    3.64
innodb  order_by_big                         13.00       +9.12%       1.30    
12.00   31.00   14.30    1.52
innodb  order_by_big_key                     13.00       +2.39%       0.32    
11.00   32.00   13.32    1.64
innodb  order_by_big_key2                    13.00       -6.34%      -0.78    
10.00   33.00   12.22    1.53
innodb  order_by_big_key_desc                15.00      -10.59%      -1.44    
11.00   32.00   13.56    1.69
innodb  order_by_big_key_diff                13.00       -6.01%      -0.74    
10.00   31.00   12.26    1.49
innodb  order_by_big_key_prefix              14.00      -12.64%      -1.57    
10.00   32.00   12.43    1.54
innodb  order_by_key2_diff                    1.00      +28.33%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -25.77%      -0.20     
0.00    2.00    0.80    0.41
innodb  order_by_range                        1.00      -19.76%      -0.17     
0.00    2.00    0.83    0.38
innodb  outer_join                           24.00      -23.35%      -4.54    
15.00   61.00   19.46    3.72
innodb  outer_join_found                     23.00      -21.90%      -4.13    
14.00   58.00   18.87    3.57
innodb  outer_join_not_found                 20.00      -20.59%      -3.42    
12.00   46.00   16.58    3.19
innodb  outer_join_on_key                    16.00      -23.19%      -3.01    
10.00   59.00   12.99    2.76
innodb  prepared_select                      37.00      -17.13%      -5.41    
22.00   40.00   31.59    4.57
innodb  select_1_row                          3.00       -4.06%      -0.12     
2.00    4.00    2.88    0.70
innodb  select_1_row_cache                    4.00      -47.21%      -1.28     
2.00    4.00    2.72    0.70
innodb  select_2_rows                         3.00       -3.00%      -0.09     
2.00    4.00    2.91    0.71
innodb  select_big                           13.00       -6.71%      -0.82     
0.00   31.00   12.18    1.53
innodb  select_big_str                        2.00      -70.76%      -0.83     
0.00    2.00    1.17    0.38
innodb  select_cache                         64.00       -7.02%      -4.20    
49.00   77.00   59.80    5.59
innodb  select_cache2                        63.00       -4.71%      -2.83    
49.00   75.00   60.17    6.22
innodb  select_column+column                  4.00      -35.02%      -1.04     
2.00    4.00    2.96    0.73
innodb  select_diff_key                       1.00     -349.25%      -0.78     
0.00    1.00    0.22    0.42
innodb  select_distinct                       4.00       +5.93%       0.25     
3.00    8.00    4.25    0.55
innodb  select_group                         16.00       +1.73%       0.28     
4.00  136.00   16.28    5.31
innodb  select_group_when_MANY_tables        11.00      -14.85%      -1.42     
3.00   49.00    9.58    9.25
innodb  select_join                           1.00      -74.04%      -0.43     
0.00    1.00    0.57    0.49
innodb  select_key                           64.00      -20.15%     -10.74    
40.00   66.00   53.26    7.64
innodb  select_key2                          72.00      -20.07%     -12.03    
45.00   75.00   59.97    8.45
innodb  select_key2_return_key               70.00      -22.17%     -12.70    
42.00   71.00   57.30    8.26
innodb  select_key2_return_prim              71.00      -22.28%     -12.94    
42.00   72.00   58.06    8.41
innodb  select_key_prefix                    71.00      -19.85%     -11.76    
44.00   75.00   59.24    8.49
innodb  select_key_prefix_join                5.00       -5.50%      -0.26     
3.00   10.00    4.74    0.65
innodb  select_key_return_key                63.00      -20.49%     -10.71    
38.00   65.00   52.29    7.64
innodb  select_many_fields                   13.00      +12.52%       1.86    
11.00   19.00   14.86    1.79
innodb  select_range                         39.00      +16.73%       7.84    
38.00   76.00   46.84    4.08
innodb  select_range_key2                    10.00      -20.24%      -1.68     
6.00   11.00    8.32    1.06
innodb  select_range_prefix                   9.00      -13.90%      -1.10     
5.00   10.00    7.90    1.13
innodb  select_simple                         2.00      -20.19%      -0.34     
1.00    3.00    1.66    0.51
innodb  select_simple_cache                   2.00      -26.93%      -0.42     
1.00    3.00    1.58    0.51
innodb  select_simple_join                    1.00      -50.08%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     4.00      -19.62%      -0.66     
2.00   16.00    3.34    1.00
innodb  update_big                           59.00      -14.89%      -7.65    
31.00  195.00   51.35   23.95
innodb  update_commit                         2.00      -26.52%      -0.42     
1.00   10.00    1.58    0.72
innodb  update_of_key                        22.00       +8.85%       2.14    
18.00  100.00   24.14    6.04
innodb  update_of_key_big                    39.00      -40.00%     -11.14    
15.00   75.00   27.86   10.90
innodb  update_of_primary_key_many_keys    1321.00       -6.03%     -75.18   
647.00 6065.00 1245.82  930.60
innodb  update_rollback                       2.00      -12.58%      -0.22     
1.00   31.00    1.78    1.86
innodb  update_with_key                     120.00       -8.72%      -9.62    
90.00  598.00  110.38   20.44
innodb  update_with_key_prefix               43.00       -7.93%      -3.16    
33.00  202.00   39.84    6.74
innodb  wisc_benchmark                        3.00      -21.07%      -0.52     
2.00    5.00    2.48    0.53

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

  2246.4.12: Olaf van der Spek 2011-03-24 Remove const_reference and reference 
from Session
  2246.4.11: Olaf van der Spek 2011-03-24 Remove const_reference and reference 
from identifier::User
  2246.4.10: Olaf van der Spek 2011-03-24 Remove const_reference and reference 
from identifier::Table
  2246.4.9: Olaf van der Spek 2011-03-24 Remove const_reference and reference 
from identifier::Schema
  2246.4.8: Olaf van der Spek 2011-03-24 Remove const_reference and reference 
from identifier::Catalog
  2246.4.7: Olaf van der Spek 2011-03-24 [merge] Merge trunk

_______________________________________________
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