=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   1102
RUN DATE: 2012-03-04T21:53:02.669449
SERVER:   drizzled
VERSION:  staging
REVISION: 2521
COMMENT:  2521: Continuous Integr... 2012-03-04 [merge] Merge build tree to 
staging tree.

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00      -14.58%      -4.20    
24.00   33.00   28.80    3.66
innodb  alter_table_drop                     25.00       -0.81%      -0.20    
24.00   26.00   24.80    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       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  connect+select_simple                 3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  count                                13.00      +16.67%       2.60    
13.00   18.00   15.60    2.24
innodb  count_distinct                        6.00       +9.09%       0.60     
6.00    8.00    6.60    0.80
innodb  count_distinct_2                     12.00       +9.09%       1.20    
12.00   15.00   13.20    0.98
innodb  count_distinct_big                   20.00       +9.09%       2.00    
20.00   25.00   22.00    2.10
innodb  count_distinct_group                 15.00       -1.35%      -0.20    
13.00   16.00   14.80    0.98
innodb  count_distinct_group_on_key          10.00       -2.04%      -0.20     
8.00   12.00    9.80    1.33
innodb  count_distinct_group_on_key_parts    13.00       +5.80%       0.80    
13.00   14.00   13.80    0.40
innodb  count_distinct_key_prefix             5.00       +3.85%       0.20     
4.00    6.00    5.20    0.75
innodb  count_group_on_key_parts             12.00       -5.26%      -0.60    
11.00   12.00   11.40    0.49
innodb  count_on_key                         95.00       -1.28%      -1.20    
91.00   96.00   93.80    1.72
innodb  create+drop                          33.00       +2.94%       1.00    
33.00   35.00   34.00    0.89
innodb  create_index                          4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  create_key+drop                      34.00       -7.59%      -2.40    
30.00   34.00   31.60    1.36
innodb  create_MANY_tables                   21.00       -0.00%       0.00    
20.00   22.00   21.00    0.63
innodb  delete_all_many_keys                931.00       -6.04%     -53.00   
784.00 1080.00  878.00  114.43
innodb  delete_autocommit                     3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  delete_big                            0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_big_many_keys                931.00       -6.08%     -53.40   
784.00 1079.00  877.60  114.21
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  delete_range                          9.00      -12.50%      -1.00     
7.00    9.00    8.00    0.63
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          19.00       -1.06%      -0.20    
18.00   19.00   18.80    0.40
innodb  insert                              115.00       -0.00%       0.00   
114.00  116.00  115.00    0.63
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       -1.01%      -0.20    
19.00   20.00   19.80    0.40
innodb  insert_key                          287.00       -1.85%      -5.20   
277.00  287.00  281.80    3.49
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      +13.04%       0.60     
4.00    5.00    4.60    0.49
innodb  insert_select_2_keys                  7.00       -9.38%      -0.60     
6.00    7.00    6.40    0.49
innodb  min_max                               7.00      +16.67%       1.40     
7.00    9.00    8.40    0.80
innodb  min_max_on_key                       25.00       -0.00%       0.00    
24.00   26.00   25.00    0.63
innodb  multiple_value_insert                 6.00       -3.45%      -0.20     
5.00    6.00    5.80    0.40
innodb  once_prepared_select                 29.00       +0.68%       0.20    
29.00   30.00   29.20    0.40
innodb  order_by_big                         12.00       +6.25%       0.80    
12.00   14.00   12.80    0.75
innodb  order_by_big_key                     15.00       -2.74%      -0.40    
14.00   15.00   14.60    0.49
innodb  order_by_big_key2                    13.00       -6.56%      -0.80    
11.00   13.00   12.20    0.75
innodb  order_by_big_key_desc                16.00       -9.59%      -1.40    
13.00   16.00   14.60    1.02
innodb  order_by_big_key_diff                12.00       -1.69%      -0.20    
11.00   13.00   11.80    0.75
innodb  order_by_big_key_prefix              12.00       +1.64%       0.20    
12.00   13.00   12.20    0.40
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                           23.00       -4.55%      -1.00    
18.00   24.00   22.00    2.10
innodb  outer_join_found                     22.00       -3.77%      -0.80    
17.00   23.00   21.20    2.14
innodb  outer_join_not_found                 21.00       -8.25%      -1.60    
16.00   21.00   19.40    1.74
innodb  outer_join_on_key                    15.00       -7.14%      -1.00    
12.00   15.00   14.00    1.10
innodb  prepared_select                      38.00       -2.15%      -0.80    
36.00   38.00   37.20    0.75
innodb  select_1_row                          3.00      +16.67%       0.60     
3.00    4.00    3.60    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                         4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_big                           13.00       -3.17%      -0.40    
11.00   14.00   12.60    1.02
innodb  select_big_str                        1.00      +44.44%       0.80     
1.00    2.00    1.80    0.40
innodb  select_cache                         62.00       +0.32%       0.20    
59.00   67.00   62.20    2.79
innodb  select_cache2                        62.00       +5.20%       3.40    
62.00   71.00   65.40    3.38
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_diff_key                       1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  select_distinct                       5.00       -4.17%      -0.20     
4.00    5.00    4.80    0.40
innodb  select_group                         15.00       +9.64%       1.60    
15.00   19.00   16.60    1.62
innodb  select_group_when_MANY_tables        12.00       -0.00%       0.00    
11.00   13.00   12.00    0.63
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    
64.00   64.00   64.00    0.00
innodb  select_key2                          73.00       -2.82%      -2.00    
70.00   73.00   71.00    1.26
innodb  select_key2_return_key               69.00       -0.58%      -0.40    
68.00   69.00   68.60    0.49
innodb  select_key2_return_prim              71.00       -1.72%      -1.20    
69.00   71.00   69.80    0.98
innodb  select_key_prefix                    71.00       -0.57%      -0.40    
70.00   72.00   70.60    0.80
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.32%       0.20    
62.00   64.00   63.20    0.75
innodb  select_many_fields                   13.00       -0.00%       0.00    
13.00   13.00   13.00    0.00
innodb  select_range                         47.00       -3.52%      -1.60    
41.00   49.00   45.40    2.73
innodb  select_range_key2                    10.00       -0.00%       0.00    
10.00   10.00   10.00    0.00
innodb  select_range_prefix                   9.00       -2.27%      -0.20     
8.00    9.00    8.80    0.40
innodb  select_simple                         2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  select_simple_cache                   2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  select_simple_join                    0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  update_autocommit                     4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  update_big                           58.00       -1.40%      -0.80    
56.00   58.00   57.20    0.75
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        23.00       -2.68%      -0.60    
22.00   23.00   22.40    0.49
innodb  update_of_key_big                    19.00       -1.06%      -0.20    
18.00   20.00   18.80    0.75
innodb  update_of_primary_key_many_keys    1296.00       -0.31%      -4.00  
1239.00 1311.00 1292.00   27.03
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     123.00       -1.65%      -2.00   
119.00  123.00  121.00    1.79
innodb  update_with_key_prefix               41.00       +5.96%       2.60    
41.00   46.00   43.60    1.62
innodb  wisc_benchmark                        3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00       -7.14%      -2.20    
24.00   34.00   30.80    2.98
innodb  alter_table_drop                     25.00       -0.60%      -0.15    
23.00   26.00   24.85    0.79
innodb  connect                               2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  connect+select_1_row                  3.00       -3.45%      -0.10     
2.00    3.00    2.90    0.30
innodb  connect+select_simple                 3.00      -13.21%      -0.35     
2.00    3.00    2.65    0.48
innodb  count                                13.00      +17.20%       2.70    
13.00   18.00   15.70    1.98
innodb  count_distinct                        6.00       +9.09%       0.60     
6.00    8.00    6.60    0.80
innodb  count_distinct_2                     12.00      +10.11%       1.35    
12.00   16.00   13.35    1.31
innodb  count_distinct_big                   20.00      +11.50%       2.60    
20.00   25.00   22.60    2.06
innodb  count_distinct_group                 15.00       -4.90%      -0.70    
11.00   16.00   14.30    1.14
innodb  count_distinct_group_on_key          10.00       -2.04%      -0.20     
8.00   12.00    9.80    1.25
innodb  count_distinct_group_on_key_parts    13.00       +3.70%       0.50    
11.00   15.00   13.50    1.43
innodb  count_distinct_key_prefix             5.00       +1.96%       0.10     
4.00    6.00    5.10    0.62
innodb  count_group_on_key_parts             12.00       -7.14%      -0.80    
11.00   12.00   11.20    0.40
innodb  count_on_key                         95.00       -0.90%      -0.85    
90.00   99.00   94.15    2.31
innodb  create+drop                          33.00       +1.49%       0.50    
32.00   35.00   33.50    0.87
innodb  create_index                          4.00      -25.00%      -0.80     
3.00    4.00    3.20    0.40
innodb  create_key+drop                      34.00       -7.94%      -2.50    
30.00   34.00   31.50    1.20
innodb  create_MANY_tables                   21.00       -0.24%      -0.05    
20.00   22.00   20.95    0.67
innodb  delete_all_many_keys                931.00       -7.31%     -63.45   
691.00 1080.00  867.55  119.94
innodb  delete_autocommit                     3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  delete_big                            0.00     +100.00%       0.35     
0.00    1.00    0.35    0.48
innodb  delete_big_many_keys                931.00       -7.39%     -64.05   
691.00 1079.00  866.95  119.76
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       +1.64%       0.05     
3.00    4.00    3.05    0.22
innodb  delete_range                          9.00      -17.65%      -1.35     
7.00    9.00    7.65    0.57
innodb  delete_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  drop_index                            3.00       -0.00%       0.00     
2.00    4.00    3.00    0.32
innodb  drop_table_when_MANY_tables          19.00       -0.26%      -0.05    
18.00   20.00   18.95    0.67
innodb  insert                              115.00       -0.52%      -0.60   
112.00  117.00  114.40    1.50
innodb  insert_autocommit                     3.00      +10.45%       0.35     
3.00    4.00    3.35    0.48
innodb  insert_commit                         2.00      -14.29%      -0.25     
1.00    2.00    1.75    0.43
innodb  insert_duplicates                    20.00       -0.76%      -0.15    
19.00   20.00   19.85    0.36
innodb  insert_key                          287.00       -2.63%      -7.35   
265.00  290.00  279.65    5.35
innodb  insert_many_fields                    5.00      +14.53%       0.85     
5.00    7.00    5.85    0.48
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   4.00      +20.79%       1.05     
4.00    6.00    5.05    0.59
innodb  insert_select_2_keys                  7.00       -8.53%      -0.55     
6.00    8.00    6.45    0.59
innodb  min_max                               7.00      +13.58%       1.10     
6.00   10.00    8.10    1.09
innodb  min_max_on_key                       25.00       -0.00%       0.00    
24.00   27.00   25.00    0.77
innodb  multiple_value_insert                 6.00       -1.69%      -0.10     
5.00    7.00    5.90    0.44
innodb  once_prepared_select                 29.00       +1.86%       0.55    
29.00   30.00   29.55    0.50
innodb  order_by_big                         12.00      +10.45%       1.40    
12.00   16.00   13.40    1.32
innodb  order_by_big_key                     15.00       -4.90%      -0.70    
12.00   16.00   14.30    1.00
innodb  order_by_big_key2                    13.00       -3.17%      -0.40    
11.00   14.00   12.60    1.02
innodb  order_by_big_key_desc                16.00       -7.02%      -1.05    
13.00   16.00   14.95    0.67
innodb  order_by_big_key_diff                12.00       +2.04%       0.25    
11.00   14.00   12.25    0.89
innodb  order_by_big_key_prefix              12.00       +7.69%       1.00    
12.00   15.00   13.00    0.77
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       -5.26%      -0.05     
0.00    1.00    0.95    0.22
innodb  order_by_range                        1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  outer_join                           23.00       -5.26%      -1.15    
17.00   24.00   21.85    2.06
innodb  outer_join_found                     22.00       -5.01%      -1.05    
16.00   23.00   20.95    2.16
innodb  outer_join_not_found                 21.00      -12.00%      -2.25    
16.00   21.00   18.75    1.58
innodb  outer_join_on_key                    15.00       -7.91%      -1.10    
11.00   15.00   13.90    1.30
innodb  prepared_select                      38.00       -1.88%      -0.70    
36.00   38.00   37.30    0.64
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      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  select_2_rows                         4.00       -3.90%      -0.15     
3.00    4.00    3.85    0.36
innodb  select_big                           13.00       -4.84%      -0.60    
10.00   14.00   12.40    1.16
innodb  select_big_str                        1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  select_cache                         62.00       +1.74%       1.10    
57.00   67.00   63.10    2.74
innodb  select_cache2                        62.00       +4.69%       3.05    
57.00   72.00   65.05    3.32
innodb  select_column+column                  4.00       -2.56%      -0.10     
3.00    4.00    3.90    0.30
innodb  select_diff_key                       1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  select_distinct                       5.00       -7.53%      -0.35     
4.00    5.00    4.65    0.48
innodb  select_group                         15.00      +11.24%       1.90    
15.00   19.00   16.90    1.61
innodb  select_group_when_MANY_tables        12.00       -0.42%      -0.05    
11.00   14.00   11.95    0.74
innodb  select_join                           1.00      -33.33%      -0.25     
0.00    1.00    0.75    0.43
innodb  select_key                           64.00       +0.93%       0.60    
64.00   66.00   64.60    0.66
innodb  select_key2                          73.00       -2.10%      -1.50    
70.00   73.00   71.50    0.97
innodb  select_key2_return_key               69.00       -0.22%      -0.15    
67.00   70.00   68.85    0.73
innodb  select_key2_return_prim              71.00       -1.43%      -1.00    
69.00   71.00   70.00    0.84
innodb  select_key_prefix                    71.00       -0.00%       0.00    
70.00   73.00   71.00    0.84
innodb  select_key_prefix_join                5.00       -4.17%      -0.20     
4.00    6.00    4.80    0.51
innodb  select_key_return_key                63.00       +0.79%       0.50    
62.00   65.00   63.50    0.81
innodb  select_many_fields                   13.00       -0.39%      -0.05    
12.00   13.00   12.95    0.22
innodb  select_range                         47.00       -6.82%      -3.00    
40.00   49.00   44.00    2.88
innodb  select_range_key2                    10.00       -1.01%      -0.10     
9.00   11.00    9.90    0.44
innodb  select_range_prefix                   9.00       -2.27%      -0.20     
8.00   10.00    8.80    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       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  select_simple_join                    0.00     +100.00%       0.65     
0.00    1.00    0.65    0.48
innodb  update_autocommit                     4.00      -12.68%      -0.45     
3.00    4.00    3.55    0.50
innodb  update_big                           58.00       -1.31%      -0.75    
55.00   61.00   57.25    1.34
innodb  update_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  update_of_key                        23.00       -1.55%      -0.35    
21.00   24.00   22.65    0.85
innodb  update_of_key_big                    19.00       -1.33%      -0.25    
18.00   20.00   18.75    0.70
innodb  update_of_primary_key_many_keys    1296.00       -1.00%     -12.80  
1194.00 1351.00 1283.20   39.08
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     123.00       -2.33%      -2.80   
117.00  124.00  120.20    1.86
innodb  update_with_key_prefix               41.00       +5.31%       2.30    
41.00   46.00   43.30    1.42
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      -44.73%     -10.20    
11.00   61.00   22.80   10.09
innodb  alter_table_drop                     25.00      -29.32%      -5.67    
10.00   57.00   19.33    6.73
innodb  connect                               2.00       +4.86%       0.10     
1.00    3.00    2.10    0.42
innodb  connect+select_1_row                  3.00       -9.56%      -0.26     
2.00    5.00    2.74    0.45
innodb  connect+select_simple                 3.00      -25.57%      -0.61     
1.00    3.00    2.39    0.49
innodb  count                                13.00      +17.58%       2.77    
12.00  193.00   15.77    8.11
innodb  count_distinct                        6.00       +9.36%       0.62     
5.00   50.00    6.62    2.11
innodb  count_distinct_2                     12.00       +9.61%       1.28    
11.00   63.00   13.28    2.76
innodb  count_distinct_big                   20.00       +9.47%       2.09     
5.00   67.00   22.09    2.90
innodb  count_distinct_group                 15.00      -12.25%      -1.64    
10.00   68.00   13.36    2.91
innodb  count_distinct_group_on_key          10.00       -4.71%      -0.45     
7.00   69.00    9.55    2.80
innodb  count_distinct_group_on_key_parts    13.00       -4.24%      -0.53     
9.00   72.00   12.47    2.95
innodb  count_distinct_key_prefix             5.00       +2.99%       0.15     
3.00   52.00    5.15    2.20
innodb  count_group_on_key_parts             12.00      -18.13%      -1.84     
7.00   72.00   10.16    2.92
innodb  count_on_key                         95.00       -8.66%      -7.57    
68.00  107.00   87.43    7.58
innodb  create+drop                          33.00       -1.34%      -0.44    
18.00   75.00   32.56   10.88
innodb  create_index                          4.00      -36.93%      -1.08     
1.00    8.00    2.92    1.06
innodb  create_key+drop                      34.00      -18.35%      -5.27    
21.00   50.00   28.73    4.69
innodb  create_MANY_tables                   21.00      +34.20%      10.92    
14.00  121.00   31.92   16.39
innodb  create_table                          0.00     +100.00%       0.09     
0.00    3.00    0.09    0.34
innodb  delete_all_many_keys                931.00      -79.48%    -412.29   
212.00 1888.00  518.71  358.87
innodb  delete_autocommit                     3.00      +13.55%       0.47     
2.00   14.00    3.47    0.72
innodb  delete_big                            0.00     +100.00%       0.31     
0.00    3.00    0.31    0.47
innodb  delete_big_many_keys                931.00      -77.84%    -407.48   
212.00 2293.00  523.52  370.12
innodb  delete_commit                         2.00      -27.10%      -0.43     
1.00    5.00    1.57    0.52
innodb  delete_key                            3.00       +0.84%       0.03     
2.00   35.00    3.03    1.38
innodb  delete_range                          9.00       -8.42%      -0.70     
5.00   23.00    8.30    2.98
innodb  delete_rollback                       2.00      -11.57%      -0.21     
1.00   12.00    1.79    0.85
innodb  drop_index                            3.00       -1.35%      -0.04     
1.00    9.00    2.96    1.22
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.22
innodb  drop_table_when_MANY_tables          19.00       +2.34%       0.46    
11.00   90.00   19.46    6.91
innodb  insert                              115.00       -6.71%      -7.23     
3.00  343.00  107.77   13.59
innodb  insert_autocommit                     3.00       +0.96%       0.03     
2.00   99.00    3.03    3.04
innodb  insert_commit                         2.00      -37.76%      -0.55     
1.00    3.00    1.45    0.51
innodb  insert_duplicates                    20.00      -24.32%      -3.91    
11.00   21.00   16.09    2.82
innodb  insert_key                          287.00       +4.10%      12.26   
142.00  700.00  299.26   97.64
innodb  insert_many_fields                    5.00      +11.21%       0.63     
3.00   17.00    5.63    1.64
innodb  insert_rollback                       2.00      -16.11%      -0.28     
1.00    3.00    1.72    0.51
innodb  insert_select_1_key                   4.00       -2.32%      -0.09     
2.00   10.00    3.91    0.92
innodb  insert_select_2_keys                  7.00      -14.58%      -0.89     
4.00   16.00    6.11    1.93
innodb  min_max                               7.00      +10.89%       0.86     
6.00  110.00    7.86    4.18
innodb  min_max_on_key                       25.00      -17.89%      -3.79    
14.00   37.00   21.21    3.21
innodb  multiple_value_insert                 6.00       -8.23%      -0.46     
2.00   50.00    5.54    3.94
innodb  once_prepared_select                 29.00      -16.03%      -4.01    
18.00   32.00   24.99    3.73
innodb  order_by_big                         12.00      +15.87%       2.26    
12.00   31.00   14.26    1.47
innodb  order_by_big_key                     15.00      -11.61%      -1.56    
11.00   32.00   13.44    1.63
innodb  order_by_big_key2                    13.00       -5.71%      -0.70    
10.00   33.00   12.30    1.48
innodb  order_by_big_key_desc                16.00      -16.49%      -2.27    
11.00   32.00   13.73    1.68
innodb  order_by_big_key_diff                12.00       +2.63%       0.32    
10.00   31.00   12.32    1.44
innodb  order_by_big_key_prefix              12.00       +4.03%       0.50    
10.00   32.00   12.50    1.48
innodb  order_by_key2_diff                    1.00      +28.55%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -23.91%      -0.19     
0.00    2.00    0.81    0.40
innodb  order_by_range                        1.00      -18.61%      -0.16     
0.00    2.00    0.84    0.37
innodb  outer_join                           23.00      -16.32%      -3.23    
15.00   61.00   19.77    3.69
innodb  outer_join_found                     22.00      -15.01%      -2.87    
14.00   58.00   19.13    3.52
innodb  outer_join_not_found                 21.00      -24.41%      -4.12    
12.00   46.00   16.88    3.19
innodb  outer_join_on_key                    15.00      -14.32%      -1.88    
10.00   59.00   13.12    2.67
innodb  prepared_select                      38.00      -17.89%      -5.77    
22.00   40.00   32.23    4.63
innodb  select_1_row                          3.00       -0.98%      -0.03     
2.00    4.00    2.97    0.72
innodb  select_1_row_cache                    4.00      -42.28%      -1.19     
2.00    4.00    2.81    0.72
innodb  select_2_rows                         4.00      -33.07%      -0.99     
2.00    4.00    3.01    0.73
innodb  select_big                           13.00       -6.18%      -0.76     
0.00   31.00   12.24    1.49
innodb  select_big_str                        1.00      +16.61%       0.20     
0.00    2.00    1.20    0.40
innodb  select_cache                         62.00       -2.72%      -1.64    
49.00   79.00   60.36    5.64
innodb  select_cache2                        62.00       -1.87%      -1.14    
49.00   88.00   60.86    6.34
innodb  select_column+column                  4.00      -30.54%      -0.94     
2.00    4.00    3.06    0.75
innodb  select_diff_key                       1.00     -340.34%      -0.77     
0.00    1.00    0.23    0.42
innodb  select_distinct                       5.00      -16.39%      -0.70     
3.00    8.00    4.30    0.55
innodb  select_group                         15.00       +8.43%       1.38     
4.00  136.00   16.38    5.02
innodb  select_group_when_MANY_tables        12.00      -21.67%      -2.14     
3.00   49.00    9.86    8.71
innodb  select_join                           1.00      -67.97%      -0.40     
0.00    1.00    0.60    0.49
innodb  select_key                           64.00      -17.29%      -9.44    
40.00   67.00   54.56    7.99
innodb  select_key2                          73.00      -19.14%     -11.73    
45.00   75.00   61.27    8.69
innodb  select_key2_return_key               69.00      -17.69%     -10.37    
42.00   71.00   58.63    8.55
innodb  select_key2_return_prim              71.00      -19.54%     -11.60    
42.00   72.00   59.40    8.68
innodb  select_key_prefix                    71.00      -17.19%     -10.41    
44.00   75.00   60.59    8.77
innodb  select_key_prefix_join                5.00       -4.15%      -0.20     
3.00   10.00    4.80    0.66
innodb  select_key_return_key                63.00      -17.60%      -9.43    
38.00   66.00   53.57    7.97
innodb  select_many_fields                   13.00      +11.39%       1.67    
11.00   19.00   14.67    1.77
innodb  select_range                         47.00       -1.00%      -0.46    
38.00   76.00   46.54    4.05
innodb  select_range_key2                    10.00      -18.01%      -1.53     
6.00   11.00    8.47    1.10
innodb  select_range_prefix                   9.00      -11.78%      -0.95     
5.00   10.00    8.05    1.16
innodb  select_simple                         2.00      -16.69%      -0.29     
1.00    3.00    1.71    0.50
innodb  select_simple_cache                   2.00      -22.38%      -0.37     
1.00    3.00    1.63    0.51
innodb  select_simple_join                    0.00     +100.00%       0.67     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     4.00      -19.21%      -0.64     
2.00   16.00    3.36    0.95
innodb  update_big                           58.00      -11.15%      -5.82    
31.00  195.00   52.18   22.59
innodb  update_commit                         2.00      -22.92%      -0.37     
1.00   10.00    1.63    0.69
innodb  update_of_key                        23.00       +3.83%       0.92    
18.00  100.00   23.92    5.71
innodb  update_of_key_big                    19.00      +29.90%       8.10    
15.00   75.00   27.10   10.65
innodb  update_of_primary_key_many_keys    1296.00       -3.48%     -43.60   
647.00 6065.00 1252.40  859.59
innodb  update_rollback                       2.00      -10.67%      -0.19     
1.00   31.00    1.81    1.75
innodb  update_with_key                     123.00      -10.33%     -11.51    
90.00  598.00  111.49   19.43
innodb  update_with_key_prefix               41.00       -1.90%      -0.76    
33.00  202.00   40.24    6.44
innodb  wisc_benchmark                        3.00      -20.45%      -0.51     
2.00    5.00    2.49    0.52

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

  2520.1.1: Continuous Integr... 2012-03-04 [merge] Merging 
lp:~patrick-crews/drizzle/bug946810 to Build branch
    2519.3.2: patrick crews 2012-03-04 Update include.am to include proper file 
name
    2519.3.1: patrick crews 2012-03-04 [merge] Updates to kewpie/dbqp 
infrastructure to account for removal of transaction log plugin.  We now make 
this an optional rather than required part of the tree
      2516.4.1: patrick crews 2012-03-04 Update of test code to make the 
transaction log reader tool, drizzletrx, an optional (not required) part of a 
Drizzle tree

_______________________________________________
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