=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   1008
RUN DATE: 2011-04-19T14:27:40.091218
SERVER:   drizzled
VERSION:  staging
REVISION: 2282
COMMENT:  2282: Brian Aker 2011-04-19 [merge] Merge of build trees.

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       -3.90%      -1.20    
25.00   35.00   30.80    3.31
innodb  alter_table_drop                     23.00       +3.36%       0.80    
23.00   24.00   23.80    0.40
innodb  connect                               2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  count                                16.00       -6.67%      -1.00    
13.00   18.00   15.00    1.79
innodb  count_distinct                        8.00      -14.29%      -1.00     
6.00    8.00    7.00    0.63
innodb  count_distinct_2                     15.00       -4.17%      -0.60    
14.00   15.00   14.40    0.49
innodb  count_distinct_big                   21.00       +3.67%       0.80    
21.00   25.00   21.80    1.60
innodb  count_distinct_group                 15.00       -7.14%      -1.00    
12.00   15.00   14.00    1.10
innodb  count_distinct_group_on_key          10.00       +5.66%       0.60     
9.00   12.00   10.60    1.02
innodb  count_distinct_group_on_key_parts    14.00       -9.38%      -1.20    
10.00   14.00   12.80    1.47
innodb  count_distinct_key_prefix             5.00       -4.17%      -0.20     
4.00    5.00    4.80    0.40
innodb  count_group_on_key_parts             12.00       -7.14%      -0.80    
11.00   12.00   11.20    0.40
innodb  count_on_key                         99.00       -2.91%      -2.80    
92.00   99.00   96.20    3.06
innodb  create+drop                          33.00       +1.20%       0.40    
33.00   35.00   33.40    0.80
innodb  create_index                          3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  create_key+drop                      30.00       +5.66%       1.80    
30.00   34.00   31.80    1.33
innodb  create_MANY_tables                   21.00       -3.96%      -0.80    
19.00   21.00   20.20    0.75
innodb  create_table                          0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_all_many_keys                765.00      +17.32%     160.20   
765.00 1227.00  925.20  165.49
innodb  delete_autocommit                     3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  delete_big                            1.00     -400.00%      -0.80     
0.00    1.00    0.20    0.40
innodb  delete_big_many_keys                764.00      +17.35%     160.40   
764.00 1226.00  924.40  165.35
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  delete_range                          9.00       -7.14%      -0.60     
8.00    9.00    8.40    0.49
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  drop_table_when_MANY_tables          18.00       +4.26%       0.80    
18.00   20.00   18.80    0.75
innodb  insert                              111.00       +0.89%       1.00   
111.00  113.00  112.00    0.63
innodb  insert_autocommit                     3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  insert_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  insert_duplicates                    19.00       -0.00%       0.00    
19.00   19.00   19.00    0.00
innodb  insert_key                          282.00       +0.70%       2.00   
277.00  296.00  284.00    6.72
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                   4.00      +25.93%       1.40     
4.00    6.00    5.40    0.80
innodb  insert_select_2_keys                  7.00      -12.90%      -0.80     
6.00    7.00    6.20    0.40
innodb  min_max                               8.00       -8.11%      -0.60     
6.00    9.00    7.40    1.02
innodb  min_max_on_key                       25.00       -2.46%      -0.60    
24.00   25.00   24.40    0.49
innodb  multiple_value_insert                 6.00       -7.14%      -0.40     
5.00    6.00    5.60    0.49
innodb  once_prepared_select                 29.00       -0.00%       0.00    
29.00   29.00   29.00    0.00
innodb  order_by_big                         15.00      -10.29%      -1.40    
12.00   15.00   13.60    1.20
innodb  order_by_big_key                     13.00       +9.72%       1.40    
13.00   15.00   14.40    0.80
innodb  order_by_big_key2                    13.00       -1.56%      -0.20    
12.00   14.00   12.80    0.75
innodb  order_by_big_key_desc                14.00       +7.89%       1.20    
14.00   16.00   15.20    0.75
innodb  order_by_big_key_diff                13.00       -1.56%      -0.20    
12.00   14.00   12.80    0.75
innodb  order_by_big_key_prefix              13.00       -0.00%       0.00    
13.00   13.00   13.00    0.00
innodb  order_by_key2_diff                    1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  order_by_key_prefix                   1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           24.00      -10.09%      -2.20    
18.00   24.00   21.80    2.71
innodb  outer_join_found                     24.00      -17.65%      -3.60    
17.00   24.00   20.40    2.58
innodb  outer_join_not_found                 20.00       -8.70%      -1.60    
15.00   21.00   18.40    2.42
innodb  outer_join_on_key                    15.00      -10.29%      -1.40    
11.00   15.00   13.60    1.74
innodb  prepared_select                      37.00       -0.00%       0.00    
37.00   37.00   37.00    0.00
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       -4.84%      -0.60    
12.00   13.00   12.40    0.49
innodb  select_big_str                        2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  select_cache                         63.00       +0.63%       0.40    
57.00   70.00   63.40    5.00
innodb  select_cache2                        64.00       +3.03%       2.00    
63.00   72.00   66.00    3.29
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
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                         18.00       -5.88%      -1.00    
16.00   19.00   17.00    1.26
innodb  select_group_when_MANY_tables        11.00       +9.84%       1.20    
11.00   13.00   12.20    0.75
innodb  select_join                           1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  select_key                           63.00       +1.25%       0.80    
63.00   65.00   63.80    0.75
innodb  select_key2                          70.00       +0.28%       0.20    
70.00   71.00   70.20    0.40
innodb  select_key2_return_key               68.00       -0.29%      -0.20    
67.00   69.00   67.80    0.75
innodb  select_key2_return_prim              68.00       +0.87%       0.60    
68.00   69.00   68.60    0.49
innodb  select_key_prefix                    70.00       -0.00%       0.00    
69.00   71.00   70.00    0.63
innodb  select_key_prefix_join                5.00       +7.41%       0.40     
5.00    6.00    5.40    0.49
innodb  select_key_return_key                62.00       +1.27%       0.80    
62.00   64.00   62.80    0.75
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         46.00       +2.54%       1.20    
41.00   52.00   47.20    3.66
innodb  select_range_key2                     9.00       +2.17%       0.20     
9.00   10.00    9.20    0.40
innodb  select_range_prefix                  10.00       -4.17%      -0.40     
9.00   10.00    9.60    0.49
innodb  select_simple                         3.00      -36.36%      -0.80     
2.00    3.00    2.20    0.40
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  update_autocommit                     4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  update_big                           57.00       +2.06%       1.20    
57.00   60.00   58.20    1.17
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        22.00       -0.92%      -0.20    
21.00   23.00   21.80    0.75
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    1290.00       -0.78%     -10.00  
1246.00 1306.00 1280.00   20.03
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     118.00       -0.17%      -0.20   
116.00  120.00  117.80    1.33
innodb  update_with_key_prefix               44.00       -3.29%      -1.40    
40.00   45.00   42.60    1.85
innodb  wisc_benchmark                        2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       -0.63%      -0.20    
25.00   35.00   31.80    2.06
innodb  alter_table_drop                     23.00       +1.92%       0.45    
22.00   25.00   23.45    0.74
innodb  connect                               2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 2.00      +25.93%       0.70     
2.00    3.00    2.70    0.46
innodb  count                                16.00       -0.95%      -0.15    
13.00   18.00   15.85    1.80
innodb  count_distinct                        8.00      -17.65%      -1.20     
6.00    8.00    6.80    0.75
innodb  count_distinct_2                     15.00       -9.89%      -1.35    
11.00   16.00   13.65    1.49
innodb  count_distinct_big                   21.00       +8.30%       1.90    
20.00   25.00   22.90    1.87
innodb  count_distinct_group                 15.00       -5.63%      -0.80    
11.00   16.00   14.20    1.44
innodb  count_distinct_group_on_key          10.00       +0.50%       0.05     
8.00   12.00   10.05    1.12
innodb  count_distinct_group_on_key_parts    14.00       -7.69%      -1.00    
10.00   15.00   13.00    1.45
innodb  count_distinct_key_prefix             5.00       +2.91%       0.15     
4.00    6.00    5.15    0.65
innodb  count_group_on_key_parts             12.00       -7.14%      -0.80    
10.00   12.00   11.20    0.51
innodb  count_on_key                         99.00       -3.23%      -3.10    
92.00  103.00   95.90    2.96
innodb  create+drop                          33.00       +0.15%       0.05    
31.00   35.00   33.05    0.92
innodb  create_index                          3.00       +1.64%       0.05     
2.00    4.00    3.05    0.38
innodb  create_key+drop                      30.00       +5.51%       1.75    
28.00   36.00   31.75    1.58
innodb  create_MANY_tables                   21.00       -3.19%      -0.65    
19.00   22.00   20.35    0.65
innodb  create_table                          0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  delete_all_many_keys                765.00       +3.99%      31.80   
553.00 1227.00  796.80  176.67
innodb  delete_autocommit                     3.00      +17.81%       0.65     
3.00    4.00    3.65    0.48
innodb  delete_big                            1.00     -300.00%      -0.75     
0.00    1.00    0.25    0.43
innodb  delete_big_many_keys                764.00       +4.03%      32.10   
553.00 1226.00  796.10  176.61
innodb  delete_commit                         2.00       -8.11%      -0.15     
1.00    2.00    1.85    0.36
innodb  delete_key                            3.00       -5.26%      -0.15     
2.00    3.00    2.85    0.36
innodb  delete_range                          9.00       -6.51%      -0.55     
8.00   10.00    8.45    0.59
innodb  delete_rollback                       2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  drop_index                            4.00      -26.98%      -0.85     
2.00    4.00    3.15    0.48
innodb  drop_table_when_MANY_tables          18.00       +3.49%       0.65    
17.00   20.00   18.65    0.79
innodb  insert                              111.00       +1.77%       2.00   
111.00  117.00  113.00    1.55
innodb  insert_autocommit                     3.00       +3.23%       0.10     
3.00    4.00    3.10    0.30
innodb  insert_commit                         2.00       -8.11%      -0.15     
1.00    2.00    1.85    0.36
innodb  insert_duplicates                    19.00       +1.30%       0.25    
19.00   20.00   19.25    0.43
innodb  insert_key                          282.00       -1.22%      -3.40   
260.00  307.00  278.60   10.75
innodb  insert_many_fields                    6.00       -4.35%      -0.25     
5.00    7.00    5.75    0.54
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   4.00      +15.79%       0.75     
3.00    6.00    4.75    0.89
innodb  insert_select_2_keys                  7.00      -14.75%      -0.90     
5.00    7.00    6.10    0.54
innodb  min_max                               8.00       -3.90%      -0.30     
6.00    9.00    7.70    1.14
innodb  min_max_on_key                       25.00       -2.25%      -0.55    
24.00   25.00   24.45    0.50
innodb  multiple_value_insert                 6.00       -0.84%      -0.05     
5.00    7.00    5.95    0.67
innodb  once_prepared_select                 29.00       -0.87%      -0.25    
28.00   29.00   28.75    0.43
innodb  order_by_big                         15.00       -6.76%      -0.95    
12.00   15.00   14.05    1.07
innodb  order_by_big_key                     13.00      +10.34%       1.50    
12.00   16.00   14.50    1.16
innodb  order_by_big_key2                    13.00       -1.56%      -0.20    
11.00   14.00   12.80    1.12
innodb  order_by_big_key_desc                14.00       +6.98%       1.05    
13.00   16.00   15.05    0.97
innodb  order_by_big_key_diff                13.00       -0.39%      -0.05    
12.00   14.00   12.95    0.67
innodb  order_by_big_key_prefix              13.00       -1.17%      -0.15    
12.00   14.00   12.85    0.57
innodb  order_by_key2_diff                    1.00      +35.48%       0.55     
1.00    2.00    1.55    0.50
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       -5.26%      -0.05     
0.00    1.00    0.95    0.22
innodb  outer_join                           24.00       -6.90%      -1.55    
17.00   26.00   22.45    2.85
innodb  outer_join_found                     24.00      -12.68%      -2.70    
17.00   24.00   21.30    2.55
innodb  outer_join_not_found                 20.00       -3.63%      -0.70    
15.00   22.00   19.30    2.33
innodb  outer_join_on_key                    15.00       -3.09%      -0.45    
11.00   17.00   14.55    1.77
innodb  prepared_select                      37.00       -0.68%      -0.25    
36.00   37.00   36.75    0.43
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       -1.96%      -0.25    
11.00   15.00   12.75    0.99
innodb  select_big_str                        2.00      -33.33%      -0.50     
1.00    2.00    1.50    0.50
innodb  select_cache                         63.00       +1.49%       0.95    
57.00   70.00   63.95    2.80
innodb  select_cache2                        64.00       +1.16%       0.75    
61.00   76.00   64.75    3.87
innodb  select_column+column                  4.00       -6.67%      -0.25     
3.00    4.00    3.75    0.43
innodb  select_diff_key                       1.00     -566.67%      -0.85     
0.00    1.00    0.15    0.36
innodb  select_distinct                       5.00      -11.11%      -0.50     
4.00    5.00    4.50    0.50
innodb  select_group                         18.00       -6.51%      -1.10    
15.00   19.00   16.90    1.48
innodb  select_group_when_MANY_tables        11.00       +7.56%       0.90    
11.00   13.00   11.90    0.62
innodb  select_join                           1.00      -53.85%      -0.35     
0.00    1.00    0.65    0.48
innodb  select_key                           63.00       +1.10%       0.70    
63.00   65.00   63.70    0.64
innodb  select_key2                          70.00       +0.43%       0.30    
69.00   71.00   70.30    0.64
innodb  select_key2_return_key               68.00       -0.44%      -0.30    
67.00   69.00   67.70    0.56
innodb  select_key2_return_prim              68.00       +0.66%       0.45    
67.00   70.00   68.45    0.67
innodb  select_key_prefix                    70.00       -0.14%      -0.10    
69.00   71.00   69.90    0.54
innodb  select_key_prefix_join                5.00       +4.76%       0.25     
5.00    6.00    5.25    0.43
innodb  select_key_return_key                62.00       +0.80%       0.50    
61.00   64.00   62.50    0.81
innodb  select_many_fields                   13.00       +3.70%       0.50    
13.00   17.00   13.50    0.92
innodb  select_range                         46.00       -0.44%      -0.20    
41.00   52.00   45.80    3.23
innodb  select_range_key2                     9.00       +4.76%       0.45     
9.00   10.00    9.45    0.50
innodb  select_range_prefix                  10.00       -6.38%      -0.60     
8.00   10.00    9.40    0.58
innodb  select_simple                         3.00      -46.34%      -0.95     
2.00    3.00    2.05    0.22
innodb  select_simple_cache                   2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_join                    1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  update_autocommit                     4.00      -15.94%      -0.55     
3.00    4.00    3.45    0.50
innodb  update_big                           57.00       +2.98%       1.75    
56.00   62.00   58.75    1.58
innodb  update_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  update_of_key                        22.00       +1.57%       0.35    
21.00   24.00   22.35    0.79
innodb  update_of_key_big                    19.00      +27.62%       7.25    
18.00   46.00   26.25    9.18
innodb  update_of_primary_key_many_keys    1290.00       -0.50%      -6.45  
1123.00 1435.00 1283.55   71.07
innodb  update_rollback                       2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  update_with_key                     118.00       +1.26%       1.50   
115.00  125.00  119.50    2.97
innodb  update_with_key_prefix               44.00       -0.80%      -0.35    
40.00   47.00   43.65    2.15
innodb  wisc_benchmark                        2.00      +27.27%       0.75     
2.00    3.00    2.75    0.43

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00      -45.89%     -10.07    
11.00   61.00   21.93   10.16
innodb  alter_table_drop                     23.00      -22.26%      -4.19    
10.00   57.00   18.81    6.84
innodb  connect                               2.00       +4.35%       0.09     
1.00    3.00    2.09    0.42
innodb  connect+select_1_row                  3.00      -10.22%      -0.28     
2.00    5.00    2.72    0.46
innodb  connect+select_simple                 2.00      +15.58%       0.37     
1.00    3.00    2.37    0.49
innodb  count                                16.00       -1.62%      -0.26    
12.00  193.00   15.74    8.48
innodb  count_distinct                        8.00      -21.44%      -1.41     
5.00   50.00    6.59    2.19
innodb  count_distinct_2                     15.00      -13.35%      -1.77    
11.00   63.00   13.23    2.86
innodb  count_distinct_big                   21.00       +4.59%       1.01     
5.00   67.00   22.01    2.96
innodb  count_distinct_group                 15.00      -13.15%      -1.74    
10.00   68.00   13.26    3.01
innodb  count_distinct_group_on_key          10.00       -5.12%      -0.49     
7.00   69.00    9.51    2.91
innodb  count_distinct_group_on_key_parts    14.00      -13.00%      -1.61     
9.00   72.00   12.39    3.05
innodb  count_distinct_key_prefix             5.00       +2.83%       0.15     
3.00   52.00    5.15    2.30
innodb  count_group_on_key_parts             12.00      -19.28%      -1.94     
7.00   72.00   10.06    3.04
innodb  count_on_key                         99.00      -14.24%     -12.34    
68.00  107.00   86.66    7.48
innodb  create+drop                          33.00       -1.55%      -0.50    
18.00   75.00   32.50   11.41
innodb  create_index                          3.00       -3.24%      -0.09     
1.00    8.00    2.91    1.10
innodb  create_key+drop                      30.00       -5.46%      -1.55    
21.00   50.00   28.45    4.80
innodb  create_MANY_tables                   21.00      +36.37%      12.00    
14.00  121.00   33.00   16.80
innodb  create_table                          0.00     +100.00%       0.10     
0.00    3.00    0.10    0.35
innodb  delete_all_many_keys                765.00      -58.61%    -282.67   
212.00 1888.00  482.33  356.07
innodb  delete_autocommit                     3.00      +13.22%       0.46     
2.00   14.00    3.46    0.74
innodb  delete_big                            1.00     -228.87%      -0.70     
0.00    3.00    0.30    0.47
innodb  delete_big_many_keys                764.00      -56.62%    -276.20   
212.00 2293.00  487.80  369.16
innodb  delete_commit                         2.00      -29.90%      -0.46     
1.00    5.00    1.54    0.53
innodb  delete_key                            3.00       +1.13%       0.03     
2.00   35.00    3.03    1.44
innodb  delete_range                          9.00       -8.06%      -0.67     
5.00   23.00    8.33    3.11
innodb  delete_rollback                       2.00      -13.08%      -0.23     
1.00   12.00    1.77    0.89
innodb  drop_index                            4.00      -35.31%      -1.04     
1.00    9.00    2.96    1.27
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.22
innodb  drop_table_when_MANY_tables          18.00       +7.69%       1.50    
11.00   90.00   19.50    7.23
innodb  insert                              111.00       -3.52%      -3.77     
3.00  343.00  107.23   14.13
innodb  insert_autocommit                     3.00       +0.36%       0.01     
2.00   99.00    3.01    3.18
innodb  insert_commit                         2.00      -41.30%      -0.58     
1.00    3.00    1.42    0.50
innodb  insert_duplicates                    19.00      -20.61%      -3.25    
11.00   21.00   15.75    2.74
innodb  insert_key                          282.00       +6.34%      19.10   
142.00  700.00  301.10  102.61
innodb  insert_many_fields                    6.00       -6.76%      -0.38     
3.00   17.00    5.62    1.71
innodb  insert_rollback                       2.00      -18.08%      -0.31     
1.00    3.00    1.69    0.52
innodb  insert_select_1_key                   4.00       -5.01%      -0.19     
2.00   10.00    3.81    0.88
innodb  insert_select_2_keys                  7.00      -15.14%      -0.92     
4.00   16.00    6.08    2.01
innodb  min_max                               8.00       -2.33%      -0.18     
6.00  110.00    7.82    4.37
innodb  min_max_on_key                       25.00      -19.91%      -4.15    
14.00   37.00   20.85    3.15
innodb  multiple_value_insert                 6.00       -8.55%      -0.47     
2.00   50.00    5.53    4.12
innodb  once_prepared_select                 29.00      -17.98%      -4.42    
18.00   32.00   24.58    3.66
innodb  order_by_big                         15.00       -4.89%      -0.70    
12.00   31.00   14.30    1.50
innodb  order_by_big_key                     13.00       +2.60%       0.35    
11.00   32.00   13.35    1.64
innodb  order_by_big_key2                    13.00       -6.14%      -0.75    
10.00   33.00   12.25    1.52
innodb  order_by_big_key_desc                14.00       -2.87%      -0.39    
11.00   32.00   13.61    1.69
innodb  order_by_big_key_diff                13.00       -5.81%      -0.71    
10.00   31.00   12.29    1.48
innodb  order_by_big_key_prefix              13.00       -4.46%      -0.56    
10.00   32.00   12.44    1.52
innodb  order_by_key2_diff                    1.00      +28.62%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -25.57%      -0.20     
0.00    2.00    0.80    0.41
innodb  order_by_range                        1.00      -19.46%      -0.16     
0.00    2.00    0.84    0.38
innodb  outer_join                           24.00      -22.74%      -4.45    
15.00   61.00   19.55    3.72
innodb  outer_join_found                     24.00      -26.63%      -5.05    
14.00   58.00   18.95    3.56
innodb  outer_join_not_found                 20.00      -19.91%      -3.32    
12.00   46.00   16.68    3.20
innodb  outer_join_on_key                    15.00      -15.00%      -1.96    
10.00   59.00   13.04    2.75
innodb  prepared_select                      37.00      -16.52%      -5.25    
22.00   40.00   31.75    4.58
innodb  select_1_row                          3.00       -3.35%      -0.10     
2.00    4.00    2.90    0.70
innodb  select_1_row_cache                    4.00      -45.87%      -1.26     
2.00    4.00    2.74    0.71
innodb  select_2_rows                         3.00       -2.26%      -0.07     
2.00    4.00    2.93    0.71
innodb  select_big                           13.00       -6.62%      -0.81     
0.00   31.00   12.19    1.52
innodb  select_big_str                        2.00      -69.50%      -0.82     
0.00    2.00    1.18    0.39
innodb  select_cache                         63.00       -5.13%      -3.07    
49.00   77.00   59.93    5.57
innodb  select_cache2                        64.00       -6.11%      -3.69    
49.00   76.00   60.31    6.21
innodb  select_column+column                  4.00      -33.81%      -1.01     
2.00    4.00    2.99    0.73
innodb  select_diff_key                       1.00     -350.72%      -0.78     
0.00    1.00    0.22    0.42
innodb  select_distinct                       5.00      -17.37%      -0.74     
3.00    8.00    4.26    0.55
innodb  select_group                         18.00      -10.43%      -1.70     
4.00  136.00   16.30    5.23
innodb  select_group_when_MANY_tables        11.00      -13.94%      -1.35     
3.00   49.00    9.65    9.11
innodb  select_join                           1.00      -72.51%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           63.00      -17.53%      -9.40    
40.00   66.00   53.60    7.74
innodb  select_key2                          70.00      -16.09%      -9.70    
45.00   75.00   60.30    8.51
innodb  select_key2_return_key               68.00      -17.98%     -10.36    
42.00   71.00   57.64    8.34
innodb  select_key2_return_prim              68.00      -16.44%      -9.60    
42.00   72.00   58.40    8.48
innodb  select_key_prefix                    70.00      -17.48%     -10.42    
44.00   75.00   59.58    8.57
innodb  select_key_prefix_join                5.00       -5.20%      -0.25     
3.00   10.00    4.75    0.65
innodb  select_key_return_key                62.00      -17.83%      -9.38    
38.00   65.00   52.62    7.74
innodb  select_many_fields                   13.00      +12.26%       1.82    
11.00   19.00   14.82    1.79
innodb  select_range                         46.00       +1.69%       0.79    
38.00   76.00   46.79    4.06
innodb  select_range_key2                     9.00       -7.75%      -0.65     
6.00   11.00    8.35    1.07
innodb  select_range_prefix                  10.00      -25.84%      -2.05     
5.00   10.00    7.95    1.15
innodb  select_simple                         3.00      -78.78%      -1.32     
1.00    3.00    1.68    0.51
innodb  select_simple_cache                   2.00      -25.76%      -0.41     
1.00    3.00    1.59    0.51
innodb  select_simple_join                    1.00      -49.12%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     4.00      -19.36%      -0.65     
2.00   16.00    3.35    0.99
innodb  update_big                           57.00      -10.46%      -5.40    
31.00  195.00   51.60   23.60
innodb  update_commit                         2.00      -25.62%      -0.41     
1.00   10.00    1.59    0.71
innodb  update_of_key                        22.00       +8.61%       2.07    
18.00  100.00   24.07    5.96
innodb  update_of_key_big                    19.00      +31.91%       8.91    
15.00   75.00   27.91   10.84
innodb  update_of_primary_key_many_keys    1290.00       -3.36%     -41.94   
647.00 6065.00 1248.06  911.71
innodb  update_rollback                       2.00      -11.99%      -0.21     
1.00   31.00    1.79    1.83
innodb  update_with_key                     118.00       -6.61%      -7.32    
90.00  598.00  110.68   20.18
innodb  update_with_key_prefix               44.00      -10.09%      -4.03    
33.00  202.00   39.97    6.68
innodb  wisc_benchmark                        2.00      +19.48%       0.48     
2.00    5.00    2.48    0.52

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

  2281.2.3: Brian Aker 2011-04-19 Argument cleanup on shutdown command.
  2281.2.2: Brian Aker 2011-04-19 [merge] Merge in fix for shortcut for CLI
    2279.3.1: Jay Janssen 2011-04-16 Changed client/drizzle 'shutdown' shortcut 
to 'Q' (i.e., '\Q' on the drizzle command line).
  2281.2.1: Brian Aker 2011-04-19 [merge] Merge in Andrew
    2281.1.1: Andrew Hutchings 2011-04-19 Don't continue if we can't figure out 
what the server is

_______________________________________________
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