=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   1101
RUN DATE: 2012-03-04T15:48:01.143065
SERVER:   drizzled
VERSION:  staging
REVISION: 2520
COMMENT:  2520: 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                      30.00       -4.90%      -1.40    
24.00   32.00   28.60    3.44
innodb  alter_table_drop                     25.00       -2.46%      -0.60    
23.00   26.00   24.40    1.02
innodb  connect                               2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  connect+select_1_row                  2.00      +28.57%       0.80     
2.00    3.00    2.80    0.40
innodb  connect+select_simple                 2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  count                                18.00       -9.76%      -1.60    
13.00   18.00   16.40    1.85
innodb  count_distinct                        7.00       -2.94%      -0.20     
6.00    8.00    6.80    0.75
innodb  count_distinct_2                     13.00       +7.14%       1.00    
13.00   16.00   14.00    1.26
innodb  count_distinct_big                   24.00       -4.35%      -1.00    
20.00   25.00   23.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           9.00      +10.00%       1.00     
8.00   12.00   10.00    1.41
innodb  count_distinct_group_on_key_parts    14.00       -0.00%       0.00    
14.00   14.00   14.00    0.00
innodb  count_distinct_key_prefix             6.00      -15.38%      -0.80     
4.00    6.00    5.20    0.75
innodb  count_group_on_key_parts             12.00       -7.14%      -0.80    
11.00   12.00   11.20    0.40
innodb  count_on_key                         96.00       -3.00%      -2.80    
91.00   96.00   93.20    1.72
innodb  create+drop                          33.00       +2.94%       1.00    
33.00   35.00   34.00    0.89
innodb  create_index                          4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  create_key+drop                      32.00       -2.56%      -0.80    
30.00   32.00   31.20    0.75
innodb  create_MANY_tables                   21.00       -0.96%      -0.20    
20.00   22.00   20.80    0.75
innodb  delete_all_many_keys                784.00       +7.48%      63.40   
778.00 1080.00  847.40  116.60
innodb  delete_autocommit                     4.00       -5.26%      -0.20     
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                784.00       +7.44%      63.00   
778.00 1079.00  847.00  116.28
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            4.00      -25.00%      -0.80     
3.00    4.00    3.20    0.40
innodb  delete_range                          8.00       -2.56%      -0.20     
7.00    8.00    7.80    0.40
innodb  delete_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
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       -2.15%      -0.40    
18.00   19.00   18.60    0.49
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                    19.00       +4.04%       0.80    
19.00   20.00   19.80    0.40
innodb  insert_key                          283.00       -0.86%      -2.40   
277.00  283.00  280.60    2.33
innodb  insert_many_fields                    6.00       -7.14%      -0.40     
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                   5.00       -8.70%      -0.40     
4.00    5.00    4.60    0.49
innodb  insert_select_2_keys                  6.00       +6.25%       0.40     
6.00    7.00    6.40    0.49
innodb  min_max                               8.00       +9.09%       0.80     
8.00    9.00    8.80    0.40
innodb  min_max_on_key                       25.00       -0.81%      -0.20    
24.00   26.00   24.80    0.75
innodb  multiple_value_insert                 6.00       -3.45%      -0.20     
5.00    6.00    5.80    0.40
innodb  once_prepared_select                 29.00       +1.36%       0.40    
29.00   30.00   29.40    0.49
innodb  order_by_big                         14.00       -9.38%      -1.20    
12.00   14.00   12.80    0.75
innodb  order_by_big_key                     15.00       -5.63%      -0.80    
13.00   15.00   14.20    0.75
innodb  order_by_big_key2                    11.00       +8.33%       1.00    
11.00   13.00   12.00    0.63
innodb  order_by_big_key_desc                14.00       +2.78%       0.40    
13.00   15.00   14.40    0.80
innodb  order_by_big_key_diff                11.00       +5.17%       0.60    
11.00   13.00   11.60    0.80
innodb  order_by_big_key_prefix              12.00       +3.23%       0.40    
12.00   13.00   12.40    0.49
innodb  order_by_key2_diff                    2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  order_by_key_prefix                   0.00     +100.00%       0.80     
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                           24.00      -10.09%      -2.20    
18.00   24.00   21.80    2.04
innodb  outer_join_found                     22.00       -3.77%      -0.80    
17.00   23.00   21.20    2.14
innodb  outer_join_not_found                 20.00       -5.26%      -1.00    
16.00   20.00   19.00    1.55
innodb  outer_join_on_key                    14.00       -1.45%      -0.20    
12.00   15.00   13.80    0.98
innodb  prepared_select                      37.00       -0.00%       0.00    
36.00   38.00   37.00    0.63
innodb  select_1_row                          4.00       -5.26%      -0.20     
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                         3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  select_big                           14.00      -11.11%      -1.40    
11.00   14.00   12.60    1.02
innodb  select_big_str                        2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  select_cache                         63.00       -1.61%      -1.00    
59.00   67.00   62.00    2.83
innodb  select_cache2                        67.00       -2.45%      -1.60    
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                       0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  select_distinct                       4.00      +16.67%       0.80     
4.00    5.00    4.80    0.40
innodb  select_group                         19.00      -10.47%      -1.80    
15.00   19.00   17.20    1.47
innodb  select_group_when_MANY_tables        13.00       -8.33%      -1.00    
11.00   13.00   12.00    0.63
innodb  select_join                           0.00     +100.00%       0.60     
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                          70.00       +0.57%       0.40    
70.00   72.00   70.40    0.80
innodb  select_key2_return_key               68.00       +0.29%       0.20    
67.00   69.00   68.20    0.75
innodb  select_key2_return_prim              69.00       +0.58%       0.40    
69.00   71.00   69.40    0.80
innodb  select_key_prefix                    70.00       +0.57%       0.40    
70.00   72.00   70.40    0.80
innodb  select_key_prefix_join                6.00      -15.38%      -0.80     
5.00    6.00    5.20    0.40
innodb  select_key_return_key                64.00       -1.59%      -1.00    
62.00   64.00   63.00    0.89
innodb  select_many_fields                   13.00       -0.00%       0.00    
13.00   13.00   13.00    0.00
innodb  select_range                         49.00       -7.46%      -3.40    
41.00   49.00   45.60    2.87
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                   3.00      -36.36%      -0.80     
2.00    3.00    2.20    0.40
innodb  select_simple_join                    1.00      -66.67%      -0.40     
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       -2.47%      -1.40    
55.00   58.00   56.60    1.02
innodb  update_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  update_of_key                        23.00       -4.55%      -1.00    
21.00   23.00   22.00    0.63
innodb  update_of_key_big                    18.00       +5.26%       1.00    
18.00   20.00   19.00    0.89
innodb  update_of_primary_key_many_keys    1310.00       -1.08%     -14.00  
1239.00 1316.00 1296.00   28.75
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     119.00       +1.33%       1.60   
119.00  123.00  120.60    1.50
innodb  update_with_key_prefix               44.00       -0.00%       0.00    
43.00   46.00   44.00    1.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       +2.28%       0.70    
24.00   34.00   30.70    2.93
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                  2.00      +31.03%       0.90     
2.00    3.00    2.90    0.30
innodb  connect+select_simple                 2.00      +24.53%       0.65     
2.00    3.00    2.65    0.48
innodb  count                                18.00      -13.21%      -2.10    
13.00   18.00   15.90    1.89
innodb  count_distinct                        7.00       -5.26%      -0.35     
6.00    8.00    6.65    0.79
innodb  count_distinct_2                     13.00       +4.41%       0.60    
12.00   17.00   13.60    1.50
innodb  count_distinct_big                   24.00       -5.03%      -1.15    
20.00   25.00   22.85    2.03
innodb  count_distinct_group                 15.00       -4.53%      -0.65    
11.00   16.00   14.35    1.19
innodb  count_distinct_group_on_key           9.00       +8.63%       0.85     
8.00   12.00    9.85    1.28
innodb  count_distinct_group_on_key_parts    14.00       -2.94%      -0.40    
11.00   15.00   13.60    1.46
innodb  count_distinct_key_prefix             6.00      -16.50%      -0.85     
4.00    6.00    5.15    0.65
innodb  count_group_on_key_parts             12.00       -7.62%      -0.85    
11.00   12.00   11.15    0.36
innodb  count_on_key                         96.00       -1.80%      -1.70    
90.00   99.00   94.30    2.45
innodb  create+drop                          33.00       +1.49%       0.50    
32.00   35.00   33.50    0.87
innodb  create_index                          4.00      -26.98%      -0.85     
3.00    4.00    3.15    0.36
innodb  create_key+drop                      32.00       -1.43%      -0.45    
30.00   35.00   31.55    1.32
innodb  create_MANY_tables                   21.00       -0.24%      -0.05    
20.00   22.00   20.95    0.67
innodb  delete_all_many_keys                784.00      +10.62%      93.15   
691.00 1123.00  877.15  131.73
innodb  delete_autocommit                     4.00       -9.59%      -0.35     
3.00    4.00    3.65    0.48
innodb  delete_big                            0.00     +100.00%       0.35     
0.00    1.00    0.35    0.48
innodb  delete_big_many_keys                784.00      +10.55%      92.50   
691.00 1122.00  876.50  131.52
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            4.00      -31.15%      -0.95     
3.00    4.00    3.05    0.22
innodb  delete_range                          8.00       -5.26%      -0.40     
7.00    8.00    7.60    0.49
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   21.00   19.05    0.80
innodb  insert                              115.00       -0.52%      -0.60   
112.00  117.00  114.40    1.50
innodb  insert_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  insert_commit                         2.00      -14.29%      -0.25     
1.00    2.00    1.75    0.43
innodb  insert_duplicates                    19.00       +4.28%       0.85    
19.00   20.00   19.85    0.36
innodb  insert_key                          283.00       -1.31%      -3.65   
265.00  290.00  279.35    5.09
innodb  insert_many_fields                    6.00       -2.56%      -0.15     
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                   5.00       +1.96%       0.10     
4.00    6.00    5.10    0.54
innodb  insert_select_2_keys                  6.00       +6.98%       0.45     
6.00    8.00    6.45    0.59
innodb  min_max                               8.00       +1.84%       0.15     
6.00   10.00    8.15    1.06
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       -2.56%      -0.15     
5.00    7.00    5.85    0.48
innodb  once_prepared_select                 29.00       +1.86%       0.55    
29.00   30.00   29.55    0.50
innodb  order_by_big                         14.00       -4.09%      -0.55    
12.00   16.00   13.45    1.28
innodb  order_by_big_key                     15.00       -5.26%      -0.75    
12.00   16.00   14.25    0.99
innodb  order_by_big_key2                    11.00      +12.70%       1.60    
11.00   14.00   12.60    1.02
innodb  order_by_big_key_desc                14.00       +5.41%       0.80    
13.00   16.00   14.80    0.75
innodb  order_by_big_key_diff                11.00       +9.84%       1.20    
11.00   14.00   12.20    0.93
innodb  order_by_big_key_prefix              12.00       +8.05%       1.05    
12.00   15.00   13.05    0.74
innodb  order_by_key2_diff                    2.00      -37.93%      -0.55     
1.00    2.00    1.45    0.50
innodb  order_by_key_prefix                   0.00     +100.00%       0.95     
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                           24.00       -9.84%      -2.15    
17.00   24.00   21.85    2.06
innodb  outer_join_found                     22.00       -4.76%      -1.00    
16.00   23.00   21.00    2.19
innodb  outer_join_not_found                 20.00       -6.95%      -1.30    
16.00   20.00   18.70    1.52
innodb  outer_join_on_key                    14.00       -1.08%      -0.15    
11.00   15.00   13.85    1.28
innodb  prepared_select                      37.00       +0.67%       0.25    
36.00   38.00   37.25    0.62
innodb  select_1_row                          4.00       -5.26%      -0.20     
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                         3.00      +22.08%       0.85     
3.00    4.00    3.85    0.36
innodb  select_big                           14.00      -13.36%      -1.65    
10.00   14.00   12.35    1.15
innodb  select_big_str                        2.00      -37.93%      -0.55     
1.00    2.00    1.45    0.50
innodb  select_cache                         63.00       +0.24%       0.15    
57.00   67.00   63.15    2.73
innodb  select_cache2                        67.00       -2.29%      -1.50    
57.00   72.00   65.50    3.49
innodb  select_column+column                  4.00       -3.90%      -0.15     
3.00    4.00    3.85    0.36
innodb  select_diff_key                       0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  select_distinct                       4.00      +13.04%       0.60     
4.00    5.00    4.60    0.49
innodb  select_group                         19.00      -11.11%      -1.90    
15.00   19.00   17.10    1.61
innodb  select_group_when_MANY_tables        13.00       -8.79%      -1.05    
11.00   14.00   11.95    0.74
innodb  select_join                           0.00     +100.00%       0.75     
0.00    1.00    0.75    0.43
innodb  select_key                           64.00       +1.01%       0.65    
64.00   66.00   64.65    0.65
innodb  select_key2                          70.00       +1.96%       1.40    
70.00   73.00   71.40    0.92
innodb  select_key2_return_key               68.00       +1.23%       0.85    
67.00   70.00   68.85    0.73
innodb  select_key2_return_prim              69.00       +1.36%       0.95    
69.00   71.00   69.95    0.80
innodb  select_key_prefix                    70.00       +1.41%       1.00    
70.00   73.00   71.00    0.84
innodb  select_key_prefix_join                6.00      -25.00%      -1.20     
4.00    6.00    4.80    0.51
innodb  select_key_return_key                64.00       -0.71%      -0.45    
62.00   65.00   63.55    0.80
innodb  select_many_fields                   13.00       -0.39%      -0.05    
12.00   13.00   12.95    0.22
innodb  select_range                         49.00      -11.49%      -5.05    
40.00   49.00   43.95    2.84
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.86%      -0.25     
8.00   10.00    8.75    0.70
innodb  select_simple                         2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  select_simple_cache                   3.00      -42.86%      -0.90     
2.00    3.00    2.10    0.30
innodb  select_simple_join                    1.00      -42.86%      -0.30     
0.00    1.00    0.70    0.46
innodb  update_autocommit                     4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
innodb  update_big                           58.00       -1.49%      -0.85    
55.00   61.00   57.15    1.35
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                    18.00       +4.26%       0.80    
18.00   20.00   18.80    0.75
innodb  update_of_primary_key_many_keys    1310.00       -2.15%     -27.55  
1194.00 1351.00 1282.45   38.97
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     119.00       +0.96%       1.15   
117.00  124.00  120.15    1.80
innodb  update_with_key_prefix               44.00       -1.38%      -0.60    
41.00   46.00   43.40    1.32
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                      30.00      -31.63%      -7.21    
11.00   61.00   22.79   10.09
innodb  alter_table_drop                     25.00      -29.36%      -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                  2.00      +26.96%       0.74     
2.00    5.00    2.74    0.45
innodb  connect+select_simple                 2.00      +16.27%       0.39     
1.00    3.00    2.39    0.49
innodb  count                                18.00      -14.10%      -2.22    
12.00  193.00   15.78    8.11
innodb  count_distinct                        7.00       -5.74%      -0.38     
5.00   50.00    6.62    2.11
innodb  count_distinct_2                     13.00       +2.08%       0.28    
11.00   63.00   13.28    2.77
innodb  count_distinct_big                   24.00       -8.62%      -1.91     
5.00   67.00   22.09    2.90
innodb  count_distinct_group                 15.00      -12.26%      -1.64    
10.00   68.00   13.36    2.91
innodb  count_distinct_group_on_key           9.00       +5.76%       0.55     
7.00   69.00    9.55    2.80
innodb  count_distinct_group_on_key_parts    14.00      -12.26%      -1.53     
9.00   72.00   12.47    2.95
innodb  count_distinct_key_prefix             6.00      -16.41%      -0.85     
3.00   52.00    5.15    2.20
innodb  count_group_on_key_parts             12.00      -18.15%      -1.84     
7.00   72.00   10.16    2.92
innodb  count_on_key                         96.00       -9.81%      -8.58    
68.00  107.00   87.42    7.58
innodb  create+drop                          33.00       -1.35%      -0.44    
18.00   75.00   32.56   10.89
innodb  create_index                          4.00      -36.98%      -1.08     
1.00    8.00    2.92    1.06
innodb  create_key+drop                      32.00      -11.41%      -3.28    
21.00   50.00   28.72    4.69
innodb  create_MANY_tables                   21.00      +34.22%      10.93    
14.00  121.00   31.93   16.39
innodb  create_table                          0.00     +100.00%       0.09     
0.00    3.00    0.09    0.34
innodb  delete_all_many_keys                784.00      -51.26%    -265.70   
212.00 1888.00  518.30  358.81
innodb  delete_autocommit                     4.00      -15.25%      -0.53     
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                784.00      -49.87%    -260.89   
212.00 2293.00  523.11  370.08
innodb  delete_commit                         2.00      -27.14%      -0.43     
1.00    5.00    1.57    0.52
innodb  delete_key                            4.00      -32.22%      -0.97     
2.00   35.00    3.03    1.38
innodb  delete_range                          8.00       +3.62%       0.30     
5.00   23.00    8.30    2.98
innodb  delete_rollback                       2.00      -11.58%      -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.72%      -7.24     
3.00  343.00  107.76   13.59
innodb  insert_autocommit                     3.00       +0.97%       0.03     
2.00   99.00    3.03    3.04
innodb  insert_commit                         2.00      -37.81%      -0.55     
1.00    3.00    1.45    0.51
innodb  insert_duplicates                    19.00      -18.13%      -2.92    
11.00   21.00   16.08    2.82
innodb  insert_key                          283.00       +5.44%      16.27   
142.00  700.00  299.27   97.69
innodb  insert_many_fields                    6.00       -6.54%      -0.37     
3.00   17.00    5.63    1.64
innodb  insert_rollback                       2.00      -16.13%      -0.28     
1.00    3.00    1.72    0.51
innodb  insert_select_1_key                   5.00      -27.90%      -1.09     
2.00   10.00    3.91    0.92
innodb  insert_select_2_keys                  6.00       +1.77%       0.11     
4.00   16.00    6.11    1.93
innodb  min_max                               8.00       -1.83%      -0.14     
6.00  110.00    7.86    4.18
innodb  min_max_on_key                       25.00      -17.91%      -3.80    
14.00   37.00   21.20    3.21
innodb  multiple_value_insert                 6.00       -8.24%      -0.46     
2.00   50.00    5.54    3.94
innodb  once_prepared_select                 29.00      -16.05%      -4.01    
18.00   32.00   24.99    3.73
innodb  order_by_big                         14.00       +1.87%       0.27    
12.00   31.00   14.27    1.47
innodb  order_by_big_key                     15.00      -11.62%      -1.56    
11.00   32.00   13.44    1.63
innodb  order_by_big_key2                    11.00      +10.55%       1.30    
10.00   33.00   12.30    1.48
innodb  order_by_big_key_desc                14.00       -1.95%      -0.27    
11.00   32.00   13.73    1.68
innodb  order_by_big_key_diff                11.00      +10.75%       1.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                    2.00      -42.86%      -0.60     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   0.00     +100.00%       0.81     
0.00    2.00    0.81    0.40
innodb  order_by_range                        1.00      -18.63%      -0.16     
0.00    2.00    0.84    0.37
innodb  outer_join                           24.00      -21.40%      -4.23    
15.00   61.00   19.77    3.69
innodb  outer_join_found                     22.00      -15.03%      -2.87    
14.00   58.00   19.13    3.52
innodb  outer_join_not_found                 20.00      -18.51%      -3.12    
12.00   46.00   16.88    3.19
innodb  outer_join_on_key                    14.00       -6.72%      -0.88    
10.00   59.00   13.12    2.67
innodb  prepared_select                      37.00      -14.81%      -4.77    
22.00   40.00   32.23    4.63
innodb  select_1_row                          4.00      -34.64%      -1.03     
2.00    4.00    2.97    0.72
innodb  select_1_row_cache                    4.00      -42.34%      -1.19     
2.00    4.00    2.81    0.72
innodb  select_2_rows                         3.00       +0.16%       0.00     
2.00    4.00    3.00    0.73
innodb  select_big                           14.00      -14.35%      -1.76     
0.00   31.00   12.24    1.49
innodb  select_big_str                        2.00      -66.75%      -0.80     
0.00    2.00    1.20    0.40
innodb  select_cache                         63.00       -4.38%      -2.64    
49.00   79.00   60.36    5.64
innodb  select_cache2                        67.00      -10.08%      -6.14    
49.00   88.00   60.86    6.34
innodb  select_column+column                  4.00      -30.58%      -0.94     
2.00    4.00    3.06    0.75
innodb  select_diff_key                       0.00     +100.00%       0.23     
0.00    1.00    0.23    0.42
innodb  select_distinct                       4.00       +6.87%       0.30     
3.00    8.00    4.30    0.55
innodb  select_group                         19.00      -15.98%      -2.62     
4.00  136.00   16.38    5.02
innodb  select_group_when_MANY_tables        13.00      -31.84%      -3.14     
3.00   49.00    9.86    8.72
innodb  select_join                           0.00     +100.00%       0.59     
0.00    1.00    0.59    0.49
innodb  select_key                           64.00      -17.31%      -9.45    
40.00   67.00   54.55    7.99
innodb  select_key2                          70.00      -14.26%      -8.74    
45.00   75.00   61.26    8.69
innodb  select_key2_return_key               68.00      -16.01%      -9.38    
42.00   71.00   58.62    8.55
innodb  select_key2_return_prim              69.00      -16.19%      -9.62    
42.00   72.00   59.38    8.68
innodb  select_key_prefix                    70.00      -15.55%      -9.42    
44.00   75.00   60.58    8.77
innodb  select_key_prefix_join                6.00      -24.99%      -1.20     
3.00   10.00    4.80    0.66
innodb  select_key_return_key                64.00      -19.49%     -10.44    
38.00   66.00   53.56    7.97
innodb  select_many_fields                   13.00      +11.40%       1.67    
11.00   19.00   14.67    1.77
innodb  select_range                         49.00       -5.30%      -2.46    
38.00   76.00   46.54    4.05
innodb  select_range_key2                    10.00      -18.03%      -1.53     
6.00   11.00    8.47    1.10
innodb  select_range_prefix                   9.00      -11.79%      -0.95     
5.00   10.00    8.05    1.16
innodb  select_simple                         2.00      -16.70%      -0.29     
1.00    3.00    1.71    0.50
innodb  select_simple_cache                   3.00      -83.61%      -1.37     
1.00    3.00    1.63    0.51
innodb  select_simple_join                    1.00      -49.06%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     4.00      -19.23%      -0.65     
2.00   16.00    3.35    0.95
innodb  update_big                           58.00      -11.16%      -5.82    
31.00  195.00   52.18   22.60
innodb  update_commit                         2.00      -22.95%      -0.37     
1.00   10.00    1.63    0.69
innodb  update_of_key                        23.00       +3.84%       0.92    
18.00  100.00   23.92    5.71
innodb  update_of_key_big                    18.00      +33.61%       9.11    
15.00   75.00   27.11   10.65
innodb  update_of_primary_key_many_keys    1310.00       -4.60%     -57.65   
647.00 6065.00 1252.35  860.11
innodb  update_rollback                       2.00      -10.68%      -0.19     
1.00   31.00    1.81    1.75
innodb  update_with_key                     119.00       -6.75%      -7.52    
90.00  598.00  111.48   19.44
innodb  update_with_key_prefix               44.00       -9.36%      -3.76    
33.00  202.00   40.24    6.44
innodb  wisc_benchmark                        3.00      -20.47%      -0.51     
2.00    5.00    2.49    0.52

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

  2519.1.1: Brian Aker 2012-03-04 [merge] Merge Joe
    2514.5.1: Joseph Daly 2012-03-04 fix 946058 slave plugin applies own 
changes in master master setup

_______________________________________________
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