=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   926
RUN DATE: 2011-02-26T15:47:04.613068
SERVER:   drizzled
VERSION:  staging
REVISION: 2205
COMMENT:  2205: Lee Bieber 2011-02-26 [merge] Merge Monty - 725586: sphinx 
commandline option docs need support dots in option names 

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      30.00       +5.06%       1.60    
30.00   33.00   31.60    1.02
innodb  alter_table_drop                     23.00       +1.71%       0.40    
23.00   24.00   23.40    0.49
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       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  count                                14.00       +2.78%       0.40    
13.00   18.00   14.40    1.85
innodb  count_distinct                        8.00       -8.11%      -0.60     
6.00    8.00    7.40    0.80
innodb  count_distinct_2                     15.00       -2.74%      -0.40    
14.00   15.00   14.60    0.49
innodb  count_distinct_big                   22.00       -0.00%       0.00    
21.00   25.00   22.00    1.55
innodb  count_distinct_group                 15.00       -5.63%      -0.80    
13.00   15.00   14.20    0.75
innodb  count_distinct_group_on_key          10.00       +1.96%       0.20     
9.00   12.00   10.20    0.98
innodb  count_distinct_group_on_key_parts    15.00       -5.63%      -0.80    
12.00   15.00   14.20    1.17
innodb  count_distinct_key_prefix             6.00      -11.11%      -0.60     
5.00    6.00    5.40    0.49
innodb  count_group_on_key_parts             11.00       +1.79%       0.20    
11.00   12.00   11.20    0.40
innodb  count_on_key                         94.00       +1.67%       1.60    
92.00  100.00   95.60    2.73
innodb  create+drop                          35.00       -2.34%      -0.80    
33.00   35.00   34.20    0.75
innodb  create_index                          4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  create_key+drop                      31.00       +3.73%       1.20    
30.00   37.00   32.20    2.48
innodb  create_MANY_tables                   21.00       -2.94%      -0.60    
20.00   21.00   20.40    0.49
innodb  delete_all_many_keys                689.00       -5.97%     -38.80   
624.00  689.00  650.20   25.18
innodb  delete_autocommit                     4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  delete_big                            1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  delete_big_many_keys                688.00       -5.91%     -38.40   
624.00  688.00  649.60   24.78
innodb  delete_commit                         1.00      +37.50%       0.60     
1.00    2.00    1.60    0.49
innodb  delete_key                            3.00      -36.36%      -0.80     
2.00    3.00    2.20    0.40
innodb  delete_range                          9.00       -0.00%       0.00     
8.00   11.00    9.00    1.10
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                            1.00     -400.00%      -0.80     
0.00    1.00    0.20    0.40
innodb  drop_table_when_MANY_tables          19.00       -4.40%      -0.80    
18.00   19.00   18.20    0.40
innodb  insert                              113.00       +0.18%       0.20   
113.00  114.00  113.20    0.40
innodb  insert_autocommit                     3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  insert_commit                         2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  insert_duplicates                    19.00       +1.04%       0.20    
19.00   20.00   19.20    0.40
innodb  insert_key                          300.00       -5.19%     -14.80   
277.00  300.00  285.20    7.98
innodb  insert_many_fields                    6.00       -7.14%      -0.40     
5.00    7.00    5.60    0.80
innodb  insert_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  insert_select_1_key                   4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  insert_select_2_keys                  6.00       +9.09%       0.60     
6.00    7.00    6.60    0.49
innodb  min_max                               7.00       +7.89%       0.60     
7.00    9.00    7.60    0.80
innodb  min_max_on_key                       24.00       +2.44%       0.60    
24.00   25.00   24.60    0.49
innodb  multiple_value_insert                 6.00       +3.23%       0.20     
6.00    7.00    6.20    0.40
innodb  once_prepared_select                 29.00       +1.36%       0.40    
29.00   30.00   29.40    0.49
innodb  order_by_big                         13.00       +7.14%       1.00    
13.00   16.00   14.00    1.10
innodb  order_by_big_key                     16.00       -9.59%      -1.40    
13.00   16.00   14.60    1.36
innodb  order_by_big_key2                    13.00       +5.80%       0.80    
13.00   15.00   13.80    0.75
innodb  order_by_big_key_desc                16.00       -2.56%      -0.40    
14.00   17.00   15.60    1.02
innodb  order_by_big_key_diff                13.00       -0.00%       0.00    
12.00   14.00   13.00    0.63
innodb  order_by_big_key_prefix              15.00       -8.70%      -1.20    
13.00   15.00   13.80    0.75
innodb  order_by_key2_diff                    2.00      -42.86%      -0.60     
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      -18.81%      -3.80    
18.00   24.00   20.20    2.40
innodb  outer_join_found                     23.00      -15.00%      -3.00    
18.00   23.00   20.00    2.10
innodb  outer_join_not_found                 21.00      -20.69%      -3.60    
16.00   21.00   17.40    1.96
innodb  outer_join_on_key                    16.00      -19.40%      -2.60    
12.00   16.00   13.40    1.50
innodb  prepared_select                      38.00       -1.60%      -0.60    
37.00   38.00   37.40    0.49
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       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_2_rows                         3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  select_big                           15.00      -11.94%      -1.60    
12.00   15.00   13.40    1.20
innodb  select_big_str                        1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  select_cache                         64.00       +1.54%       1.00    
57.00   70.00   65.00    4.47
innodb  select_cache2                        62.00       +4.32%       2.80    
61.00   68.00   64.80    2.79
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_distinct                       4.00       +4.76%       0.20     
4.00    5.00    4.20    0.40
innodb  select_group                         16.00       +2.44%       0.40    
15.00   18.00   16.40    1.02
innodb  select_group_when_MANY_tables        13.00       -6.56%      -0.80    
12.00   13.00   12.20    0.40
innodb  select_join                           1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  select_key                           64.00       -0.31%      -0.20    
63.00   65.00   63.80    0.75
innodb  select_key2                          71.00       -0.28%      -0.20    
70.00   72.00   70.80    0.75
innodb  select_key2_return_key               68.00       +0.58%       0.40    
68.00   69.00   68.40    0.49
innodb  select_key2_return_prim              70.00       -0.86%      -0.60    
68.00   70.00   69.40    0.80
innodb  select_key_prefix                    71.00       -0.28%      -0.20    
70.00   71.00   70.80    0.40
innodb  select_key_prefix_join                5.00       -0.00%       0.00     
5.00    5.00    5.00    0.00
innodb  select_key_return_key                63.00       -0.00%       0.00    
62.00   64.00   63.00    0.63
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         40.00       +6.98%       3.00    
40.00   47.00   43.00    2.97
innodb  select_range_key2                    10.00       -4.17%      -0.40     
9.00   10.00    9.60    0.49
innodb  select_range_prefix                   9.00       +4.26%       0.40     
9.00   10.00    9.40    0.49
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    0.00     +100.00%       0.80     
0.00    1.00    0.80    0.40
innodb  update_autocommit                     4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  update_big                           64.00       -6.67%      -4.00    
58.00   64.00   60.00    2.28
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        23.00       -1.77%      -0.40    
21.00   24.00   22.60    1.02
innodb  update_of_key_big                    31.00       +7.74%       2.60    
29.00   40.00   33.60    3.77
innodb  update_of_primary_key_many_keys    1406.00       -5.29%     -70.60  
1307.00 1406.00 1335.40   36.34
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   
118.00  123.00  121.00    1.79
innodb  update_with_key_prefix               45.00       -0.45%      -0.20    
42.00   48.00   44.80    2.14
innodb  wisc_benchmark                        2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      30.00       +7.98%       2.60    
30.00   34.00   32.60    1.11
innodb  alter_table_drop                     23.00       +3.56%       0.85    
23.00   26.00   23.85    0.85
innodb  connect                               2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  connect+select_1_row                  3.00       -5.26%      -0.15     
2.00    3.00    2.85    0.36
innodb  connect+select_simple                 3.00       -9.09%      -0.25     
2.00    3.00    2.75    0.43
innodb  count                                14.00       +7.59%       1.15    
13.00   18.00   15.15    1.98
innodb  count_distinct                        8.00      -19.40%      -1.30     
6.00    8.00    6.70    0.78
innodb  count_distinct_2                     15.00       -5.63%      -0.80    
12.00   16.00   14.20    1.03
innodb  count_distinct_big                   22.00       +1.35%       0.30    
20.00   25.00   22.30    1.98
innodb  count_distinct_group                 15.00       -6.38%      -0.90    
12.00   15.00   14.10    0.99
innodb  count_distinct_group_on_key          10.00       +0.50%       0.05     
8.00   12.00   10.05    0.97
innodb  count_distinct_group_on_key_parts    15.00      -11.52%      -1.55    
11.00   15.00   13.45    1.12
innodb  count_distinct_key_prefix             6.00      -15.38%      -0.80     
4.00    6.00    5.20    0.51
innodb  count_group_on_key_parts             11.00       +0.90%       0.10    
10.00   12.00   11.10    0.62
innodb  count_on_key                         94.00       -0.05%      -0.05    
91.00  100.00   93.95    2.22
innodb  create+drop                          35.00       -4.63%      -1.55    
32.00   35.00   33.45    0.92
innodb  create_index                          4.00      -12.68%      -0.45     
3.00    4.00    3.55    0.50
innodb  create_key+drop                      31.00       +1.43%       0.45    
29.00   37.00   31.45    1.56
innodb  create_MANY_tables                   21.00       -1.69%      -0.35    
20.00   22.00   20.65    0.73
innodb  create_table                          0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  delete_all_many_keys                689.00       -6.34%     -41.10   
574.00  714.00  647.90   31.67
innodb  delete_autocommit                     4.00       -5.26%      -0.20     
3.00    5.00    3.80    0.51
innodb  delete_big                            1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  delete_big_many_keys                688.00       -6.35%     -41.05   
573.00  713.00  646.95   31.51
innodb  delete_commit                         1.00      +42.86%       0.75     
1.00    2.00    1.75    0.43
innodb  delete_key                            3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  delete_range                          9.00       +0.55%       0.05     
8.00   11.00    9.05    0.80
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.32
innodb  drop_table                            1.00    -1900.00%      -0.95     
0.00    1.00    0.05    0.22
innodb  drop_table_when_MANY_tables          19.00       -1.06%      -0.20    
18.00   21.00   18.80    0.98
innodb  insert                              113.00       +0.53%       0.60   
112.00  116.00  113.60    0.97
innodb  insert_autocommit                     3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  insert_commit                         2.00       -8.11%      -0.15     
1.00    2.00    1.85    0.36
innodb  insert_duplicates                    19.00       +0.78%       0.15    
19.00   20.00   19.15    0.36
innodb  insert_key                          300.00       -6.21%     -17.55   
255.00  302.00  282.45   11.32
innodb  insert_many_fields                    6.00       -3.45%      -0.20     
5.00    7.00    5.80    0.60
innodb  insert_rollback                       2.00       +4.76%       0.10     
1.00    3.00    2.10    0.44
innodb  insert_select_1_key                   4.00       -5.26%      -0.20     
3.00    5.00    3.80    0.51
innodb  insert_select_2_keys                  6.00       +3.23%       0.20     
5.00    7.00    6.20    0.60
innodb  min_max                               7.00       +9.68%       0.75     
6.00    9.00    7.75    0.94
innodb  min_max_on_key                       24.00       +2.83%       0.70    
24.00   26.00   24.70    0.56
innodb  multiple_value_insert                 6.00       +8.40%       0.55     
5.00    8.00    6.55    0.80
innodb  once_prepared_select                 29.00       +0.68%       0.20    
29.00   30.00   29.20    0.40
innodb  order_by_big                         13.00       +9.72%       1.40    
13.00   16.00   14.40    1.20
innodb  order_by_big_key                     16.00       -9.59%      -1.40    
12.00   16.00   14.60    1.28
innodb  order_by_big_key2                    13.00       +2.99%       0.40    
11.00   15.00   13.40    0.92
innodb  order_by_big_key_desc                16.00       -5.26%      -0.80    
13.00   17.00   15.20    1.17
innodb  order_by_big_key_diff                13.00       +1.89%       0.25    
12.00   14.00   13.25    0.70
innodb  order_by_big_key_prefix              15.00      -12.78%      -1.70    
12.00   15.00   13.30    0.64
innodb  order_by_key2_diff                    2.00      -53.85%      -0.70     
1.00    2.00    1.30    0.46
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      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  outer_join                           24.00      -11.11%      -2.40    
17.00   25.00   21.60    2.62
innodb  outer_join_found                     23.00       -9.79%      -2.05    
17.00   25.00   20.95    2.36
innodb  outer_join_not_found                 21.00      -12.00%      -2.25    
15.00   21.00   18.75    2.02
innodb  outer_join_on_key                    16.00      -11.50%      -1.65    
11.00   17.00   14.35    1.74
innodb  prepared_select                      38.00       -1.60%      -0.60    
37.00   38.00   37.40    0.49
innodb  select_1_row                          3.00      +13.04%       0.45     
3.00    4.00    3.45    0.50
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      +17.81%       0.65     
3.00    4.00    3.65    0.48
innodb  select_big                           15.00      -16.28%      -2.10    
11.00   15.00   12.90    1.14
innodb  select_big_str                        1.00      +35.48%       0.55     
1.00    2.00    1.55    0.50
innodb  select_cache                         64.00       -0.47%      -0.30    
57.00   70.00   63.70    4.44
innodb  select_cache2                        62.00       +0.80%       0.50    
56.00   68.00   62.50    3.20
innodb  select_column+column                  4.00      -12.68%      -0.45     
3.00    4.00    3.55    0.50
innodb  select_diff_key                       0.00     +100.00%       0.25     
0.00    1.00    0.25    0.43
innodb  select_distinct                       4.00       +9.09%       0.40     
4.00    5.00    4.40    0.49
innodb  select_group                         16.00       +4.48%       0.75    
15.00   19.00   16.75    1.44
innodb  select_group_when_MANY_tables        13.00       -5.26%      -0.65    
11.00   14.00   12.35    0.85
innodb  select_join                           1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  select_key                           64.00       -0.23%      -0.15    
63.00   65.00   63.85    0.57
innodb  select_key2                          71.00       -0.14%      -0.10    
69.00   72.00   70.90    0.83
innodb  select_key2_return_key               68.00       +0.51%       0.35    
67.00   69.00   68.35    0.57
innodb  select_key2_return_prim              70.00       -1.30%      -0.90    
68.00   70.00   69.10    0.83
innodb  select_key_prefix                    71.00       -0.50%      -0.35    
69.00   72.00   70.65    0.65
innodb  select_key_prefix_join                5.00       +0.99%       0.05     
5.00    6.00    5.05    0.22
innodb  select_key_return_key                63.00       -0.24%      -0.15    
62.00   64.00   62.85    0.65
innodb  select_many_fields                   13.00       +0.76%       0.10    
12.00   14.00   13.10    0.44
innodb  select_range                         40.00       +4.42%       1.85    
38.00   47.00   41.85    2.76
innodb  select_range_key2                    10.00       -5.82%      -0.55     
8.00   10.00    9.45    0.59
innodb  select_range_prefix                   9.00       +4.26%       0.40     
8.00   10.00    9.40    0.58
innodb  select_simple                         2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    0.00     +100.00%       0.90     
0.00    1.00    0.90    0.30
innodb  update_autocommit                     4.00       -9.59%      -0.35     
3.00    4.00    3.65    0.48
innodb  update_big                           64.00       -7.56%      -4.50    
57.00   64.00   59.50    2.01
innodb  update_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  update_of_key                        23.00       -1.77%      -0.40    
21.00   24.00   22.60    0.73
innodb  update_of_key_big                    31.00      +14.36%       5.20    
29.00   46.00   36.20    3.88
innodb  update_of_primary_key_many_keys    1406.00       -4.68%     -62.80  
1219.00 1470.00 1343.20   61.06
innodb  update_rollback                       2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  update_with_key                     123.00       -1.36%      -1.65   
117.00  126.00  121.35    2.37
innodb  update_with_key_prefix               45.00       +0.44%       0.20    
40.00   49.00   45.20    2.56
innodb  wisc_benchmark                        2.00      +13.04%       0.30     
2.00    3.00    2.30    0.46

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      30.00      -42.82%      -8.99    
11.00   61.00   21.01   10.09
innodb  alter_table_drop                     23.00      -25.19%      -4.63    
10.00   57.00   18.37    6.96
innodb  connect                               2.00       +3.81%       0.08     
1.00    3.00    2.08    0.42
innodb  connect+select_1_row                  3.00      -11.14%      -0.30     
2.00    5.00    2.70    0.47
innodb  connect+select_simple                 3.00      -27.87%      -0.65     
1.00    3.00    2.35    0.48
innodb  count                                14.00      +11.05%       1.74    
12.00  193.00   15.74    8.84
innodb  count_distinct                        8.00      -21.82%      -1.43     
5.00   50.00    6.57    2.28
innodb  count_distinct_2                     15.00      -13.74%      -1.81    
11.00   63.00   13.19    2.95
innodb  count_distinct_big                   22.00       -0.34%      -0.07     
5.00   67.00   21.93    3.02
innodb  count_distinct_group                 15.00      -14.16%      -1.86    
10.00   68.00   13.14    3.09
innodb  count_distinct_group_on_key          10.00       -5.30%      -0.50     
7.00   69.00    9.50    3.02
innodb  count_distinct_group_on_key_parts    15.00      -21.74%      -2.68     
9.00   72.00   12.32    3.16
innodb  count_distinct_key_prefix             6.00      -17.08%      -0.88     
3.00   52.00    5.12    2.39
innodb  count_group_on_key_parts             11.00      -10.22%      -1.02     
7.00   72.00    9.98    3.16
innodb  count_on_key                         94.00       -9.34%      -8.03    
68.00  107.00   85.97    7.39
innodb  create+drop                          35.00       -7.90%      -2.56    
18.00   75.00   32.44   11.91
innodb  create_index                          4.00      -38.39%      -1.11     
1.00    8.00    2.89    1.14
innodb  create_key+drop                      31.00      -10.00%      -2.82    
21.00   50.00   28.18    4.92
innodb  create_MANY_tables                   21.00      +38.43%      13.10    
14.00  121.00   34.10   17.11
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.36
innodb  delete_all_many_keys                689.00      -48.65%    -225.50   
212.00 1888.00  463.50  365.19
innodb  delete_autocommit                     4.00      -16.16%      -0.56     
2.00   14.00    3.44    0.75
innodb  delete_big                            1.00     -240.08%      -0.71     
0.00    3.00    0.29    0.47
innodb  delete_big_many_keys                688.00      -46.50%    -218.37   
212.00 2293.00  469.63  379.44
innodb  delete_commit                         1.00      +33.77%       0.51     
1.00    5.00    1.51    0.53
innodb  delete_key                            3.00       +1.87%       0.06     
2.00   35.00    3.06    1.50
innodb  delete_range                          9.00       -8.32%      -0.69     
5.00   23.00    8.31    3.24
innodb  delete_rollback                       2.00      -15.11%      -0.26     
1.00   12.00    1.74    0.92
innodb  drop_index                            3.00       -1.70%      -0.05     
1.00    9.00    2.95    1.32
innodb  drop_table                            1.00    -2099.98%      -0.95     
0.00    2.00    0.05    0.23
innodb  drop_table_when_MANY_tables          19.00       +2.95%       0.58    
11.00   90.00   19.58    7.54
innodb  insert                              113.00       -5.93%      -6.33     
3.00  343.00  106.67   14.61
innodb  insert_autocommit                     3.00       -0.04%       0.00     
2.00   99.00    3.00    3.32
innodb  insert_commit                         2.00      -45.50%      -0.63     
1.00    3.00    1.37    0.49
innodb  insert_duplicates                    19.00      -23.02%      -3.55    
11.00   21.00   15.45    2.65
innodb  insert_key                          300.00       +1.09%       3.31   
142.00  700.00  303.31  107.27
innodb  insert_many_fields                    6.00       -7.09%      -0.40     
3.00   17.00    5.60    1.78
innodb  insert_rollback                       2.00      -20.11%      -0.33     
1.00    3.00    1.67    0.53
innodb  insert_select_1_key                   4.00       -5.81%      -0.22     
2.00   10.00    3.78    0.89
innodb  insert_select_2_keys                  6.00       +1.17%       0.07     
4.00   16.00    6.07    2.09
innodb  min_max                               7.00      +10.54%       0.82     
6.00  110.00    7.82    4.55
innodb  min_max_on_key                       24.00      -16.94%      -3.48    
14.00   37.00   20.52    3.08
innodb  multiple_value_insert                 6.00      -10.07%      -0.55     
2.00   50.00    5.45    4.29
innodb  once_prepared_select                 29.00      -19.92%      -4.82    
18.00   32.00   24.18    3.56
innodb  order_by_big                         13.00       +9.14%       1.31    
12.00   31.00   14.31    1.53
innodb  order_by_big_key                     16.00      -20.50%      -2.72    
11.00   32.00   13.28    1.65
innodb  order_by_big_key2                    13.00       -6.56%      -0.80    
10.00   33.00   12.20    1.55
innodb  order_by_big_key_desc                16.00      -18.55%      -2.50    
11.00   32.00   13.50    1.68
innodb  order_by_big_key_diff                13.00       -6.34%      -0.77    
10.00   31.00   12.23    1.51
innodb  order_by_big_key_prefix              15.00      -21.00%      -2.60    
10.00   32.00   12.40    1.56
innodb  order_by_key2_diff                    2.00      -43.14%      -0.60     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -26.44%      -0.21     
0.00    2.00    0.79    0.41
innodb  order_by_range                        1.00      -20.39%      -0.17     
0.00    2.00    0.83    0.38
innodb  outer_join                           24.00      -24.21%      -4.68    
15.00   61.00   19.32    3.72
innodb  outer_join_found                     23.00      -22.66%      -4.25    
14.00   58.00   18.75    3.58
innodb  outer_join_not_found                 21.00      -27.72%      -4.56    
12.00   46.00   16.44    3.17
innodb  outer_join_on_key                    16.00      -24.09%      -3.11    
10.00   59.00   12.89    2.77
innodb  prepared_select                      38.00      -21.45%      -6.71    
22.00   40.00   31.29    4.50
innodb  select_1_row                          3.00       -5.36%      -0.15     
2.00    4.00    2.85    0.69
innodb  select_1_row_cache                    4.00      -49.48%      -1.32     
2.00    4.00    2.68    0.68
innodb  select_2_rows                         3.00       -4.46%      -0.13     
2.00    4.00    2.87    0.70
innodb  select_big                           15.00      -23.34%      -2.84     
0.00   31.00   12.16    1.55
innodb  select_big_str                        1.00      +14.09%       0.16     
0.00    2.00    1.16    0.37
innodb  select_cache                         64.00       -7.34%      -4.38    
49.00   77.00   59.62    5.65
innodb  select_cache2                        62.00       -3.39%      -2.03    
49.00   75.00   59.97    6.29
innodb  select_column+column                  4.00      -37.12%      -1.08     
2.00    4.00    2.92    0.71
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.41
innodb  select_distinct                       4.00       +5.53%       0.23     
3.00    8.00    4.23    0.54
innodb  select_group                         16.00       +1.64%       0.27     
4.00  136.00   16.27    5.44
innodb  select_group_when_MANY_tables        13.00      -37.53%      -3.55     
3.00   49.00    9.45    9.48
innodb  select_join                           1.00      -72.98%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           64.00      -21.49%     -11.32    
40.00   66.00   52.68    7.41
innodb  select_key2                          71.00      -19.59%     -11.63    
45.00   75.00   59.37    8.27
innodb  select_key2_return_key               68.00      -19.94%     -11.30    
42.00   71.00   56.70    8.06
innodb  select_key2_return_prim              70.00      -21.83%     -12.54    
42.00   72.00   57.46    8.21
innodb  select_key_prefix                    71.00      -21.11%     -12.38    
44.00   75.00   58.62    8.29
innodb  select_key_prefix_join                5.00       -5.98%      -0.28     
3.00   10.00    4.72    0.65
innodb  select_key_return_key                63.00      -21.84%     -11.29    
38.00   65.00   51.71    7.43
innodb  select_many_fields                   13.00      +13.06%       1.95    
11.00   19.00   14.95    1.79
innodb  select_range                         40.00      +15.03%       7.08    
38.00   76.00   47.08    4.00
innodb  select_range_key2                    10.00      -21.19%      -1.75     
6.00   11.00    8.25    1.04
innodb  select_range_prefix                   9.00      -14.93%      -1.17     
5.00   10.00    7.83    1.11
innodb  select_simple                         2.00      -21.62%      -0.36     
1.00    3.00    1.64    0.51
innodb  select_simple_cache                   2.00      -28.93%      -0.45     
1.00    3.00    1.55    0.51
innodb  select_simple_join                    0.00     +100.00%       0.66     
0.00    3.00    0.66    0.48
innodb  update_autocommit                     4.00      -20.20%      -0.67     
2.00   16.00    3.33    1.01
innodb  update_big                           64.00      -25.63%     -13.06    
31.00  195.00   50.94   24.53
innodb  update_commit                         2.00      -28.20%      -0.44     
1.00   10.00    1.56    0.73
innodb  update_of_key                        23.00       +5.13%       1.24    
18.00  100.00   24.24    6.19
innodb  update_of_key_big                    31.00      -13.19%      -3.61    
15.00   75.00   27.39   10.96
innodb  update_of_primary_key_many_keys    1406.00      -13.40%    -166.15   
647.00 6065.00 1239.85  962.62
innodb  update_rollback                       2.00      -13.81%      -0.24     
1.00   31.00    1.76    1.90
innodb  update_with_key                     123.00      -12.03%     -13.20    
90.00  598.00  109.80   20.83
innodb  update_with_key_prefix               45.00      -13.62%      -5.39    
33.00  202.00   39.61    6.83
innodb  wisc_benchmark                        2.00      +19.04%       0.47     
2.00    5.00    2.47    0.53

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

  2203.1.1: Monty Taylor 2011-02-26 Adds support for '.' in option:: names.

_______________________________________________
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