=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   991
RUN DATE: 2011-04-06T15:00:11.842024
SERVER:   drizzled
VERSION:  staging
REVISION: 2269
COMMENT:  2269: Monty Taylor 2011-04-06 [merge] Merge Monty: Windows Fixes

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      30.00       +7.41%       2.40    
30.00   33.00   32.40    1.20
innodb  alter_table_drop                     22.00       +5.17%       1.20    
22.00   24.00   23.20    0.75
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                                17.00       -2.41%      -0.40    
14.00   18.00   16.60    1.36
innodb  count_distinct                        6.00      +11.76%       0.80     
6.00    8.00    6.80    0.75
innodb  count_distinct_2                     15.00       -4.17%      -0.60    
12.00   16.00   14.40    1.36
innodb  count_distinct_big                   25.00       -5.04%      -1.20    
21.00   25.00   23.80    1.47
innodb  count_distinct_group                 15.00       -5.63%      -0.80    
11.00   16.00   14.20    1.72
innodb  count_distinct_group_on_key          11.00       -7.84%      -0.80     
9.00   12.00   10.20    1.17
innodb  count_distinct_group_on_key_parts    12.00       +7.69%       1.00    
11.00   15.00   13.00    1.41
innodb  count_distinct_key_prefix             5.00      +10.71%       0.60     
5.00    7.00    5.60    0.80
innodb  count_group_on_key_parts             12.00       -5.26%      -0.60    
11.00   12.00   11.40    0.49
innodb  count_on_key                         93.00       +3.73%       3.60    
93.00  102.00   96.60    3.20
innodb  create+drop                          34.00       -1.80%      -0.60    
33.00   34.00   33.40    0.49
innodb  create_index                          4.00      -25.00%      -0.80     
3.00    4.00    3.20    0.40
innodb  create_key+drop                      32.00       -0.63%      -0.20    
31.00   32.00   31.80    0.40
innodb  create_MANY_tables                   20.00       +2.91%       0.60    
20.00   21.00   20.60    0.49
innodb  delete_all_many_keys                624.00       +4.32%      28.20   
624.00  681.00  652.20   23.42
innodb  delete_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  delete_big                            0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                623.00       +4.33%      28.20   
623.00  680.00  651.20   23.83
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          8.00       +9.09%       0.80     
8.00   10.00    8.80    0.75
innodb  delete_rollback                       3.00      -25.00%      -0.60     
2.00    3.00    2.40    0.49
innodb  drop_index                            3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  drop_table_when_MANY_tables          17.00       +7.61%       1.40    
17.00   19.00   18.40    0.80
innodb  insert                              114.00       +0.52%       0.60   
114.00  116.00  114.60    0.80
innodb  insert_autocommit                     3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  insert_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  insert_duplicates                    20.00       -4.17%      -0.80    
19.00   20.00   19.20    0.40
innodb  insert_key                          270.00       +4.39%      12.40   
270.00  296.00  282.40   11.41
innodb  insert_many_fields                    5.00      +10.71%       0.60     
5.00    6.00    5.60    0.49
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  insert_select_2_keys                  6.00       -0.00%       0.00     
5.00    7.00    6.00    0.63
innodb  min_max                               9.00       -7.14%      -0.60     
7.00    9.00    8.40    0.80
innodb  min_max_on_key                       25.00       -1.63%      -0.40    
24.00   25.00   24.60    0.49
innodb  multiple_value_insert                 5.00      +24.24%       1.60     
5.00    8.00    6.60    1.02
innodb  once_prepared_select                 28.00       +2.78%       0.80    
28.00   29.00   28.80    0.40
innodb  order_by_big                         13.00       +9.72%       1.40    
13.00   15.00   14.40    0.80
innodb  order_by_big_key                     15.00       -8.70%      -1.20    
12.00   16.00   13.80    1.47
innodb  order_by_big_key2                    13.00       -0.00%       0.00    
11.00   14.00   13.00    1.10
innodb  order_by_big_key_desc                16.00       -8.11%      -1.20    
14.00   16.00   14.80    0.98
innodb  order_by_big_key_diff                13.00       -0.00%       0.00    
12.00   14.00   13.00    0.63
innodb  order_by_big_key_prefix              13.00       -0.00%       0.00    
12.00   14.00   13.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                           19.00      +12.84%       2.80    
19.00   24.00   21.80    1.94
innodb  outer_join_found                     19.00       +9.52%       2.00    
18.00   23.00   21.00    2.10
innodb  outer_join_not_found                 17.00      +12.37%       2.40    
17.00   22.00   19.40    2.06
innodb  outer_join_on_key                    13.00       +9.72%       1.40    
13.00   17.00   14.40    1.50
innodb  prepared_select                      37.00       -0.54%      -0.20    
36.00   37.00   36.80    0.40
innodb  select_1_row                          3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  select_1_row_cache                    4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_2_rows                         3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_big                           13.00       -3.17%      -0.40    
11.00   13.00   12.60    0.80
innodb  select_big_str                        2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  select_cache                         62.00       +3.13%       2.00    
62.00   67.00   64.00    1.67
innodb  select_cache2                        61.00       +4.98%       3.20    
61.00   69.00   64.20    2.71
innodb  select_column+column                  4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_diff_key                       1.00     -400.00%      -0.80     
0.00    1.00    0.20    0.40
innodb  select_distinct                       5.00       -8.70%      -0.40     
4.00    5.00    4.60    0.49
innodb  select_group                         15.00      +11.76%       2.00    
15.00   19.00   17.00    1.79
innodb  select_group_when_MANY_tables        12.00       -0.00%       0.00    
12.00   12.00   12.00    0.00
innodb  select_join                           1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  select_key                           64.00       -0.00%       0.00    
63.00   65.00   64.00    0.63
innodb  select_key2                          71.00       -0.85%      -0.60    
69.00   71.00   70.40    0.80
innodb  select_key2_return_key               68.00       -0.29%      -0.20    
67.00   68.00   67.80    0.40
innodb  select_key2_return_prim              69.00       -0.58%      -0.40    
68.00   69.00   68.60    0.49
innodb  select_key_prefix                    70.00       -0.29%      -0.20    
69.00   70.00   69.80    0.40
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.96%      -0.60    
61.00   63.00   62.40    0.80
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         44.00       +0.90%       0.40    
41.00   48.00   44.40    2.24
innodb  select_range_key2                    10.00       -8.70%      -0.80     
9.00   10.00    9.20    0.40
innodb  select_range_prefix                   8.00      +13.04%       1.20     
8.00   10.00    9.20    0.75
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                    0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  update_autocommit                     3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  update_big                           62.00       -3.33%      -2.00    
58.00   62.00   60.00    1.67
innodb  update_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  update_of_key                        22.00       +0.90%       0.20    
21.00   24.00   22.20    0.98
innodb  update_of_key_big                    36.00       +4.26%       1.60    
32.00   46.00   37.60    4.63
innodb  update_of_primary_key_many_keys    1299.00       +4.77%      65.00  
1299.00 1435.00 1364.00   52.15
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     125.00       -2.12%      -2.60   
119.00  125.00  122.40    2.50
innodb  update_with_key_prefix               46.00       -4.55%      -2.00    
41.00   46.00   44.00    2.10
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                      30.00       +6.98%       2.25    
30.00   35.00   32.25    0.99
innodb  alter_table_drop                     22.00       +7.17%       1.70    
22.00   26.00   23.70    1.10
innodb  connect                               2.00      +11.11%       0.25     
2.00    3.00    2.25    0.43
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      -13.21%      -0.35     
2.00    3.00    2.65    0.48
innodb  count                                17.00       -8.63%      -1.35    
13.00   18.00   15.65    1.80
innodb  count_distinct                        6.00      +15.49%       1.10     
6.00    8.00    7.10    0.70
innodb  count_distinct_2                     15.00       -7.14%      -1.00    
12.00   17.00   14.00    1.58
innodb  count_distinct_big                   25.00       -7.07%      -1.65    
21.00   25.00   23.35    1.68
innodb  count_distinct_group                 15.00       -2.39%      -0.35    
11.00   16.00   14.65    1.11
innodb  count_distinct_group_on_key          11.00      -14.58%      -1.40     
8.00   12.00    9.60    1.11
innodb  count_distinct_group_on_key_parts    12.00       +8.40%       1.10    
11.00   15.00   13.10    1.30
innodb  count_distinct_key_prefix             5.00       +9.91%       0.55     
5.00    7.00    5.55    0.59
innodb  count_group_on_key_parts             12.00       -9.59%      -1.05    
10.00   12.00   10.95    0.50
innodb  count_on_key                         93.00       +2.62%       2.50    
91.00  102.00   95.50    2.50
innodb  create+drop                          34.00       -1.64%      -0.55    
32.00   35.00   33.45    0.86
innodb  create_index                          4.00      -33.33%      -1.00     
2.00    4.00    3.00    0.45
innodb  create_key+drop                      32.00       -2.56%      -0.80    
30.00   32.00   31.20    0.75
innodb  create_MANY_tables                   20.00       +2.91%       0.60    
19.00   24.00   20.60    1.11
innodb  delete_all_many_keys                624.00       +2.09%      13.35   
582.00  681.00  637.35   26.36
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.55     
0.00    1.00    0.55    0.50
innodb  delete_big_many_keys                623.00       +2.11%      13.45   
581.00  680.00  636.45   26.48
innodb  delete_commit                         2.00       -5.26%      -0.10     
1.00    2.00    1.90    0.30
innodb  delete_key                            3.00       -5.26%      -0.15     
2.00    4.00    2.85    0.48
innodb  delete_range                          8.00       +6.43%       0.55     
7.00   10.00    8.55    0.80
innodb  delete_rollback                       3.00      -39.53%      -0.85     
2.00    3.00    2.15    0.36
innodb  drop_index                            3.00       +1.64%       0.05     
2.00    4.00    3.05    0.59
innodb  drop_table_when_MANY_tables          17.00       +7.61%       1.40    
17.00   19.00   18.40    0.66
innodb  insert                              114.00       -0.31%      -0.35   
111.00  116.00  113.65    1.15
innodb  insert_autocommit                     3.00       +7.69%       0.25     
3.00    4.00    3.25    0.43
innodb  insert_commit                         2.00      -17.65%      -0.30     
1.00    2.00    1.70    0.46
innodb  insert_duplicates                    20.00       -4.44%      -0.85    
19.00   20.00   19.15    0.36
innodb  insert_key                          270.00       +3.28%       9.15   
265.00  296.00  279.15    8.67
innodb  insert_many_fields                    5.00      +12.28%       0.70     
5.00    7.00    5.70    0.56
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.50
innodb  insert_select_2_keys                  6.00       +2.44%       0.15     
5.00    7.00    6.15    0.73
innodb  min_max                               9.00      -15.38%      -1.20     
6.00    9.00    7.80    0.98
innodb  min_max_on_key                       25.00       -2.04%      -0.50    
24.00   25.00   24.50    0.50
innodb  multiple_value_insert                 5.00      +23.08%       1.50     
5.00    8.00    6.50    0.67
innodb  once_prepared_select                 28.00       +3.61%       1.05    
28.00   30.00   29.05    0.50
innodb  order_by_big                         13.00       +8.13%       1.15    
13.00   15.00   14.15    0.91
innodb  order_by_big_key                     15.00      -10.29%      -1.40    
12.00   16.00   13.60    1.20
innodb  order_by_big_key2                    13.00       -0.78%      -0.10    
11.00   14.00   12.90    0.94
innodb  order_by_big_key_desc                16.00      -10.73%      -1.55    
13.00   16.00   14.45    0.97
innodb  order_by_big_key_diff                13.00       +0.76%       0.10    
11.00   15.00   13.10    0.94
innodb  order_by_big_key_prefix              13.00       -0.39%      -0.05    
12.00   15.00   12.95    0.92
innodb  order_by_key2_diff                    1.00      +31.03%       0.45     
1.00    2.00    1.45    0.50
innodb  order_by_key_prefix                   1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  order_by_range                        1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  outer_join                           19.00      +13.64%       3.00    
18.00   24.00   22.00    1.92
innodb  outer_join_found                     19.00      +10.59%       2.25    
17.00   23.00   21.25    1.97
innodb  outer_join_not_found                 17.00      +12.14%       2.35    
16.00   25.00   19.35    2.15
innodb  outer_join_on_key                    13.00      +10.34%       1.50    
12.00   17.00   14.50    1.36
innodb  prepared_select                      37.00       -0.54%      -0.20    
36.00   38.00   36.80    0.51
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      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_big                           13.00       -5.26%      -0.65    
11.00   15.00   12.35    1.15
innodb  select_big_str                        2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  select_cache                         62.00       +1.90%       1.20    
60.00   72.00   63.20    2.91
innodb  select_cache2                        61.00       +4.84%       3.10    
58.00   73.00   64.10    3.13
innodb  select_column+column                  4.00       -3.90%      -0.15     
3.00    4.00    3.85    0.36
innodb  select_diff_key                       1.00     -233.33%      -0.70     
0.00    1.00    0.30    0.46
innodb  select_distinct                       5.00      -11.11%      -0.50     
4.00    5.00    4.50    0.50
innodb  select_group                         15.00      +12.28%       2.10    
15.00   19.00   17.10    1.51
innodb  select_group_when_MANY_tables        12.00       -1.69%      -0.20    
10.00   13.00   11.80    0.81
innodb  select_join                           1.00      -33.33%      -0.25     
0.00    1.00    0.75    0.43
innodb  select_key                           64.00       -0.00%       0.00    
63.00   66.00   64.00    0.77
innodb  select_key2                          71.00       -0.64%      -0.45    
69.00   72.00   70.55    0.74
innodb  select_key2_return_key               68.00       +0.15%       0.10    
67.00   70.00   68.10    0.77
innodb  select_key2_return_prim              69.00       -0.07%      -0.05    
68.00   71.00   68.95    0.74
innodb  select_key_prefix                    70.00       +0.14%       0.10    
68.00   71.00   70.10    0.77
innodb  select_key_prefix_join                5.00       +2.91%       0.15     
5.00    6.00    5.15    0.36
innodb  select_key_return_key                63.00       -0.40%      -0.25    
61.00   64.00   62.75    0.62
innodb  select_many_fields                   13.00       +1.52%       0.20    
12.00   14.00   13.20    0.51
innodb  select_range                         44.00       -0.34%      -0.15    
39.00   49.00   43.85    3.12
innodb  select_range_key2                    10.00       -6.38%      -0.60     
9.00   10.00    9.40    0.49
innodb  select_range_prefix                   8.00      +13.04%       1.20     
8.00   10.00    9.20    0.68
innodb  select_simple                         2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
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.75     
0.00    1.00    0.75    0.43
innodb  update_autocommit                     3.00      +17.81%       0.65     
3.00    5.00    3.65    0.57
innodb  update_big                           62.00       -4.29%      -2.55    
56.00   65.00   59.45    1.96
innodb  update_commit                         2.00       -5.26%      -0.10     
1.00    2.00    1.90    0.30
innodb  update_of_key                        22.00       -0.46%      -0.10    
21.00   24.00   21.90    0.89
innodb  update_of_key_big                    36.00       -0.14%      -0.05    
30.00   46.00   35.95    3.72
innodb  update_of_primary_key_many_keys    1299.00       +2.31%      30.70  
1228.00 1435.00 1329.70   50.03
innodb  update_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  update_with_key                     125.00       -3.01%      -3.65   
117.00  127.00  121.35    2.57
innodb  update_with_key_prefix               46.00       -4.66%      -2.05    
41.00   46.00   43.95    1.56
innodb  wisc_benchmark                        3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      30.00      -37.84%      -8.24    
11.00   61.00   21.76   10.16
innodb  alter_table_drop                     22.00      -17.46%      -3.27    
10.00   57.00   18.73    6.87
innodb  connect                               2.00       +4.27%       0.09     
1.00    3.00    2.09    0.42
innodb  connect+select_1_row                  3.00      -10.41%      -0.28     
2.00    5.00    2.72    0.46
innodb  connect+select_simple                 3.00      -26.88%      -0.64     
1.00    3.00    2.36    0.49
innodb  count                                17.00       -7.97%      -1.26    
12.00  193.00   15.74    8.55
innodb  count_distinct                        6.00       +8.87%       0.58     
5.00   50.00    6.58    2.21
innodb  count_distinct_2                     15.00      -13.38%      -1.77    
11.00   63.00   13.23    2.88
innodb  count_distinct_big                   25.00      -13.65%      -3.00     
5.00   67.00   22.00    2.97
innodb  count_distinct_group                 15.00      -13.31%      -1.76    
10.00   68.00   13.24    3.02
innodb  count_distinct_group_on_key          11.00      -15.74%      -1.50     
7.00   69.00    9.50    2.93
innodb  count_distinct_group_on_key_parts    12.00       +3.05%       0.38     
9.00   72.00   12.38    3.07
innodb  count_distinct_key_prefix             5.00       +2.84%       0.15     
3.00   52.00    5.15    2.31
innodb  count_group_on_key_parts             12.00      -19.52%      -1.96     
7.00   72.00   10.04    3.06
innodb  count_on_key                         93.00       -7.52%      -6.51    
68.00  107.00   86.49    7.42
innodb  create+drop                          34.00       -4.65%      -1.51    
18.00   75.00   32.49   11.51
innodb  create_index                          4.00      -37.73%      -1.10     
1.00    8.00    2.90    1.11
innodb  create_key+drop                      32.00      -12.71%      -3.61    
21.00   50.00   28.39    4.82
innodb  create_MANY_tables                   20.00      +39.80%      13.22    
14.00  121.00   33.22   16.86
innodb  create_table                          0.00     +100.00%       0.10     
0.00    3.00    0.10    0.35
innodb  delete_all_many_keys                624.00      -31.12%    -148.09   
212.00 1888.00  475.91  355.27
innodb  delete_autocommit                     3.00      +13.12%       0.45     
2.00   14.00    3.45    0.74
innodb  delete_big                            0.00     +100.00%       0.31     
0.00    3.00    0.31    0.47
innodb  delete_big_many_keys                623.00      -29.38%    -141.49   
212.00 2293.00  481.51  368.73
innodb  delete_commit                         2.00      -30.31%      -0.47     
1.00    5.00    1.53    0.53
innodb  delete_key                            3.00       +1.26%       0.04     
2.00   35.00    3.04    1.46
innodb  delete_range                          8.00       +3.94%       0.33     
5.00   23.00    8.33    3.14
innodb  delete_rollback                       3.00      -70.10%      -1.24     
1.00   12.00    1.76    0.90
innodb  drop_index                            3.00       -1.58%      -0.05     
1.00    9.00    2.95    1.28
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.23
innodb  drop_table_when_MANY_tables          17.00      +12.88%       2.51    
11.00   90.00   19.51    7.29
innodb  insert                              114.00       -6.41%      -6.86     
3.00  343.00  107.14   14.23
innodb  insert_autocommit                     3.00       +0.33%       0.01     
2.00   99.00    3.01    3.21
innodb  insert_commit                         2.00      -42.11%      -0.59     
1.00    3.00    1.41    0.50
innodb  insert_duplicates                    20.00      -27.45%      -4.31    
11.00   21.00   15.69    2.72
innodb  insert_key                          270.00      +10.46%      31.53   
142.00  700.00  301.53  103.52
innodb  insert_many_fields                    5.00      +11.00%       0.62     
3.00   17.00    5.62    1.72
innodb  insert_rollback                       2.00      -18.45%      -0.31     
1.00    3.00    1.69    0.53
innodb  insert_select_1_key                   4.00       -5.55%      -0.21     
2.00   10.00    3.79    0.87
innodb  insert_select_2_keys                  6.00       +1.29%       0.08     
4.00   16.00    6.08    2.03
innodb  min_max                               9.00      -15.06%      -1.18     
6.00  110.00    7.82    4.41
innodb  min_max_on_key                       25.00      -20.27%      -4.21    
14.00   37.00   20.79    3.14
innodb  multiple_value_insert                 5.00       +9.44%       0.52     
2.00   50.00    5.52    4.16
innodb  once_prepared_select                 28.00      -14.25%      -3.49    
18.00   32.00   24.51    3.65
innodb  order_by_big                         13.00       +9.14%       1.31    
12.00   31.00   14.31    1.51
innodb  order_by_big_key                     15.00      -12.60%      -1.68    
11.00   32.00   13.32    1.64
innodb  order_by_big_key2                    13.00       -6.22%      -0.76    
10.00   33.00   12.24    1.52
innodb  order_by_big_key_desc                16.00      -17.81%      -2.42    
11.00   32.00   13.58    1.68
innodb  order_by_big_key_diff                13.00       -5.90%      -0.72    
10.00   31.00   12.28    1.48
innodb  order_by_big_key_prefix              13.00       -4.52%      -0.56    
10.00   32.00   12.44    1.53
innodb  order_by_key2_diff                    1.00      +28.47%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -25.62%      -0.20     
0.00    2.00    0.80    0.41
innodb  order_by_range                        1.00      -19.71%      -0.16     
0.00    2.00    0.84    0.38
innodb  outer_join                           19.00       +2.56%       0.50    
15.00   61.00   19.50    3.71
innodb  outer_join_found                     19.00       -0.48%      -0.09    
14.00   58.00   18.91    3.56
innodb  outer_join_not_found                 17.00       -2.22%      -0.37    
12.00   46.00   16.63    3.20
innodb  outer_join_on_key                    13.00       +0.11%       0.01    
10.00   59.00   13.01    2.76
innodb  prepared_select                      37.00      -16.84%      -5.33    
22.00   40.00   31.67    4.58
innodb  select_1_row                          3.00       -3.76%      -0.11     
2.00    4.00    2.89    0.70
innodb  select_1_row_cache                    4.00      -46.51%      -1.27     
2.00    4.00    2.73    0.70
innodb  select_2_rows                         3.00       -2.68%      -0.08     
2.00    4.00    2.92    0.71
innodb  select_big                           13.00       -6.72%      -0.82     
0.00   31.00   12.18    1.53
innodb  select_big_str                        2.00      -70.17%      -0.82     
0.00    2.00    1.18    0.38
innodb  select_cache                         62.00       -3.58%      -2.15    
49.00   77.00   59.85    5.58
innodb  select_cache2                        61.00       -1.28%      -0.77    
49.00   75.00   60.23    6.21
innodb  select_column+column                  4.00      -34.41%      -1.02     
2.00    4.00    2.98    0.73
innodb  select_diff_key                       1.00     -347.32%      -0.78     
0.00    1.00    0.22    0.42
innodb  select_distinct                       5.00      -17.49%      -0.74     
3.00    8.00    4.26    0.55
innodb  select_group                         15.00       +7.91%       1.29     
4.00  136.00   16.29    5.28
innodb  select_group_when_MANY_tables        12.00      -24.79%      -2.38     
3.00   49.00    9.62    9.18
innodb  select_join                           1.00      -73.07%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           64.00      -19.78%     -10.57    
40.00   66.00   53.43    7.69
innodb  select_key2                          71.00      -18.09%     -10.87    
45.00   75.00   60.13    8.48
innodb  select_key2_return_key               68.00      -18.34%     -10.54    
42.00   71.00   57.46    8.30
innodb  select_key2_return_prim              69.00      -18.50%     -10.77    
42.00   72.00   58.23    8.44
innodb  select_key_prefix                    70.00      -17.84%     -10.60    
44.00   75.00   59.40    8.53
innodb  select_key_prefix_join                5.00       -5.39%      -0.26     
3.00   10.00    4.74    0.65
innodb  select_key_return_key                63.00      -20.13%     -10.56    
38.00   65.00   52.44    7.69
innodb  select_many_fields                   13.00      +12.38%       1.84    
11.00   19.00   14.84    1.79
innodb  select_range                         44.00       +5.99%       2.80    
38.00   76.00   46.80    4.07
innodb  select_range_key2                    10.00      -20.01%      -1.67     
6.00   11.00    8.33    1.06
innodb  select_range_prefix                   8.00       -1.01%      -0.08     
5.00   10.00    7.92    1.14
innodb  select_simple                         2.00      -19.66%      -0.33     
1.00    3.00    1.67    0.51
innodb  select_simple_cache                   2.00      -26.41%      -0.42     
1.00    3.00    1.58    0.51
innodb  select_simple_join                    0.00     +100.00%       0.67     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     3.00      +10.44%       0.35     
2.00   16.00    3.35    0.99
innodb  update_big                           62.00      -20.43%     -10.52    
31.00  195.00   51.48   23.79
innodb  update_commit                         2.00      -26.19%      -0.42     
1.00   10.00    1.58    0.71
innodb  update_of_key                        22.00       +8.73%       2.10    
18.00  100.00   24.10    6.01
innodb  update_of_key_big                    36.00      -28.64%      -8.01    
15.00   75.00   27.99   10.88
innodb  update_of_primary_key_many_keys    1299.00       -4.12%     -51.34   
647.00 6065.00 1247.66  921.67
innodb  update_rollback                       2.00      -12.36%      -0.22     
1.00   31.00    1.78    1.84
innodb  update_with_key                     125.00      -13.08%     -14.46    
90.00  598.00  110.54   20.33
innodb  update_with_key_prefix               46.00      -15.28%      -6.10    
33.00  202.00   39.90    6.71
innodb  wisc_benchmark                        3.00      -20.95%      -0.52     
2.00    5.00    2.48    0.53

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

  2268.1.4: Monty Taylor 2011-04-06 Fixed a thing that should have been in a 
comment.
  2268.1.3: Monty Taylor 2011-04-06 [merge] Merged Monty: Fixed libdrizzle sover
    2263.5.1: Monty Taylor 2011-04-04 Updated the sover code in libdrizzle-1.0 
to set the right version.
  2268.1.2: Monty Taylor 2011-04-06 [merge] Merged Monty: Windows fixes
    2263.4.1: Monty Taylor 2011-04-04 Updated the windows/posix error mapping 
as per notes from Marc Isambart.
  2268.1.1: Monty Taylor 2011-04-06 [merge] Merged Olaf: open_tables refactoring
    2263.3.3: Olaf van der Spek 2011-04-05 Use open_tables
    2263.3.2: Olaf van der Spek 2011-04-05 Use open_tables
    2263.3.1: Olaf van der Spek 2011-04-03 Rename Open_tables_state::open_tables

_______________________________________________
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