=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   993
RUN DATE: 2011-04-11T00:20:02.201091
SERVER:   drizzled
VERSION:  staging
REVISION: 2271
COMMENT:  2271: Brian Aker 2011-04-10 [merge] Merge of all doc patches.

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      31.00       +3.13%       1.00    
30.00   33.00   32.00    1.26
innodb  alter_table_drop                     24.00       -4.35%      -1.00    
22.00   24.00   23.00    0.63
innodb  connect                               2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  count                                14.00       +7.89%       1.20    
14.00   17.00   15.20    1.47
innodb  count_distinct                        6.00      +11.76%       0.80     
6.00    8.00    6.80    0.75
innodb  count_distinct_2                     13.00       +9.72%       1.40    
13.00   16.00   14.40    1.20
innodb  count_distinct_big                   21.00       +6.25%       1.40    
21.00   25.00   22.40    1.74
innodb  count_distinct_group                 16.00      -11.11%      -1.60    
12.00   16.00   14.40    1.36
innodb  count_distinct_group_on_key          11.00       -3.77%      -0.40     
9.00   12.00   10.60    1.02
innodb  count_distinct_group_on_key_parts    14.00       -7.69%      -1.00    
12.00   14.00   13.00    0.89
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             11.00       +3.51%       0.40    
11.00   12.00   11.40    0.49
innodb  count_on_key                         94.00       +0.21%       0.20    
92.00   98.00   94.20    2.04
innodb  create+drop                          33.00       -0.00%       0.00    
32.00   34.00   33.00    0.63
innodb  create_index                          3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  create_key+drop                      31.00       +1.90%       0.60    
31.00   32.00   31.60    0.49
innodb  create_MANY_tables                   20.00       +0.99%       0.20    
20.00   21.00   20.20    0.40
innodb  delete_all_many_keys                643.00       -3.01%     -18.80   
553.00  674.00  624.20   39.78
innodb  delete_autocommit                     4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  delete_big                            0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                643.00       -3.11%     -19.40   
553.00  674.00  623.60   39.76
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          8.00       +9.09%       0.80     
8.00   10.00    8.80    0.75
innodb  delete_rollback                       2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  drop_index                            3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  drop_table_when_MANY_tables          19.00       -2.15%      -0.40    
17.00   19.00   18.60    0.80
innodb  insert                              114.00       -0.18%      -0.20   
112.00  115.00  113.80    0.98
innodb  insert_autocommit                     3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  insert_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_duplicates                    20.00       -3.09%      -0.60    
19.00   20.00   19.40    0.49
innodb  insert_key                          280.00       -1.16%      -3.20   
260.00  296.00  276.80   11.91
innodb  insert_many_fields                    5.00       +7.41%       0.40     
5.00    6.00    5.40    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       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  insert_select_2_keys                  6.00       -3.45%      -0.20     
5.00    6.00    5.80    0.40
innodb  min_max                               7.00       +5.41%       0.40     
6.00    9.00    7.40    1.02
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       -0.00%       0.00     
5.00    7.00    6.00    0.89
innodb  once_prepared_select                 29.00       -1.40%      -0.40    
28.00   29.00   28.60    0.49
innodb  order_by_big                         13.00       +8.45%       1.20    
13.00   15.00   14.20    0.98
innodb  order_by_big_key                     13.00       +2.99%       0.40    
12.00   15.00   13.40    1.02
innodb  order_by_big_key2                    11.00      +12.70%       1.60    
11.00   14.00   12.60    1.36
innodb  order_by_big_key_desc                13.00      +10.96%       1.60    
13.00   16.00   14.60    1.20
innodb  order_by_big_key_diff                12.00       +7.69%       1.00    
12.00   14.00   13.00    0.63
innodb  order_by_big_key_prefix              13.00       -3.17%      -0.40    
12.00   13.00   12.60    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                   1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           24.00       -8.11%      -1.80    
19.00   25.00   22.20    2.32
innodb  outer_join_found                     22.00       -3.77%      -0.80    
18.00   24.00   21.20    2.32
innodb  outer_join_not_found                 20.00       -3.09%      -0.60    
17.00   22.00   19.40    2.06
innodb  outer_join_on_key                    15.00       -4.17%      -0.60    
13.00   16.00   14.40    1.20
innodb  prepared_select                      36.00       +1.64%       0.60    
36.00   37.00   36.60    0.49
innodb  select_1_row                          3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_1_row_cache                    4.00      -17.65%      -0.60     
3.00    4.00    3.40    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    
11.00   13.00   12.40    0.80
innodb  select_big_str                        2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  select_cache                         64.00       -0.95%      -0.60    
62.00   64.00   63.40    0.80
innodb  select_cache2                        61.00       +3.79%       2.40    
61.00   67.00   63.40    2.33
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                       5.00       -4.17%      -0.20     
4.00    5.00    4.80    0.40
innodb  select_group                         18.00       -9.76%      -1.60    
15.00   19.00   16.40    1.74
innodb  select_group_when_MANY_tables        12.00       -1.69%      -0.20    
11.00   12.00   11.80    0.40
innodb  select_join                           1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  select_key                           63.00       +0.94%       0.60    
63.00   65.00   63.60    0.80
innodb  select_key2                          70.00       +0.28%       0.20    
69.00   71.00   70.20    0.75
innodb  select_key2_return_key               67.00       +0.89%       0.60    
67.00   68.00   67.60    0.49
innodb  select_key2_return_prim              68.00       +0.58%       0.40    
68.00   69.00   68.40    0.49
innodb  select_key_prefix                    69.00       +0.86%       0.60    
69.00   70.00   69.60    0.49
innodb  select_key_prefix_join                5.00       +3.85%       0.20     
5.00    6.00    5.20    0.40
innodb  select_key_return_key                62.00       +0.64%       0.40    
61.00   63.00   62.40    0.80
innodb  select_many_fields                   14.00       -4.48%      -0.60    
13.00   14.00   13.40    0.49
innodb  select_range                         45.00       -0.90%      -0.40    
41.00   48.00   44.60    2.24
innodb  select_range_key2                    10.00       -4.17%      -0.40     
9.00   10.00    9.60    0.49
innodb  select_range_prefix                   9.00       -0.00%       0.00     
8.00   10.00    9.00    0.63
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.40     
0.00    1.00    0.40    0.49
innodb  update_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  update_big                           59.00       +0.67%       0.40    
56.00   62.00   59.40    2.33
innodb  update_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  update_of_key                        24.00       -5.26%      -1.20    
22.00   24.00   22.80    0.98
innodb  update_of_key_big                    33.00       +7.30%       2.60    
32.00   39.00   35.60    2.73
innodb  update_of_primary_key_many_keys    1350.00       -2.46%     -32.40  
1182.00 1435.00 1317.60   81.96
innodb  update_rollback                       3.00      -36.36%      -0.80     
2.00    3.00    2.20    0.40
innodb  update_with_key                     121.00       -0.17%      -0.20   
115.00  125.00  120.80    3.37
innodb  update_with_key_prefix               43.00       +1.83%       0.80    
41.00   47.00   43.80    2.32
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                      31.00       +3.88%       1.25    
30.00   35.00   32.25    1.04
innodb  alter_table_drop                     24.00       -0.84%      -0.20    
22.00   26.00   23.80    1.03
innodb  connect                               2.00      +11.11%       0.25     
2.00    3.00    2.25    0.43
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  count                                14.00       +9.97%       1.55    
13.00   18.00   15.55    1.75
innodb  count_distinct                        6.00      +14.89%       1.05     
6.00    8.00    7.05    0.74
innodb  count_distinct_2                     13.00       +6.81%       0.95    
12.00   17.00   13.95    1.53
innodb  count_distinct_big                   21.00       +9.29%       2.15    
21.00   25.00   23.15    1.71
innodb  count_distinct_group                 16.00       -9.59%      -1.40    
11.00   16.00   14.60    1.28
innodb  count_distinct_group_on_key          11.00      -13.40%      -1.30     
8.00   12.00    9.70    1.14
innodb  count_distinct_group_on_key_parts    14.00       -8.11%      -1.05    
11.00   15.00   12.95    1.24
innodb  count_distinct_key_prefix             5.00       +8.26%       0.45     
4.00    7.00    5.45    0.67
innodb  count_group_on_key_parts             11.00       +0.90%       0.10    
10.00   12.00   11.10    0.44
innodb  count_on_key                         94.00       +1.52%       1.45    
92.00  102.00   95.45    2.44
innodb  create+drop                          33.00       +1.35%       0.45    
32.00   35.00   33.45    0.86
innodb  create_index                          3.00       -0.00%       0.00     
2.00    4.00    3.00    0.45
innodb  create_key+drop                      31.00       +0.64%       0.20    
30.00   32.00   31.20    0.75
innodb  create_MANY_tables                   20.00       +1.23%       0.25    
19.00   21.00   20.25    0.54
innodb  delete_all_many_keys                643.00       -1.36%      -8.65   
553.00  681.00  634.35   31.65
innodb  delete_autocommit                     4.00       -9.59%      -0.35     
3.00    5.00    3.65    0.57
innodb  delete_big                            0.00     +100.00%       0.50     
0.00    1.00    0.50    0.50
innodb  delete_big_many_keys                643.00       -1.49%      -9.45   
553.00  680.00  633.55   31.65
innodb  delete_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  delete_key                            3.00       -3.45%      -0.10     
2.00    4.00    2.90    0.44
innodb  delete_range                          8.00       +6.43%       0.55     
7.00   10.00    8.55    0.80
innodb  delete_rollback                       2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  drop_index                            3.00       +1.64%       0.05     
2.00    4.00    3.05    0.59
innodb  drop_table_when_MANY_tables          19.00       -3.26%      -0.60    
17.00   19.00   18.40    0.66
innodb  insert                              114.00       -0.44%      -0.50   
111.00  116.00  113.50    1.16
innodb  insert_autocommit                     3.00       +7.69%       0.25     
3.00    4.00    3.25    0.43
innodb  insert_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  insert_duplicates                    20.00       -4.17%      -0.80    
19.00   20.00   19.20    0.40
innodb  insert_key                          280.00       -0.59%      -1.65   
260.00  296.00  278.35    9.63
innodb  insert_many_fields                    5.00      +10.71%       0.60     
5.00    7.00    5.60    0.58
innodb  insert_rollback                       2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  insert_select_1_key                   4.00       -0.00%       0.00     
3.00    5.00    4.00    0.45
innodb  insert_select_2_keys                  6.00       +1.64%       0.10     
5.00    7.00    6.10    0.70
innodb  min_max                               7.00       +7.89%       0.60     
6.00    9.00    7.60    1.02
innodb  min_max_on_key                       24.00       +2.04%       0.50    
24.00   25.00   24.50    0.50
innodb  multiple_value_insert                 6.00       +6.98%       0.45     
5.00    8.00    6.45    0.74
innodb  once_prepared_select                 29.00       -0.17%      -0.05    
28.00   30.00   28.95    0.50
innodb  order_by_big                         13.00       +8.77%       1.25    
13.00   15.00   14.25    0.89
innodb  order_by_big_key                     13.00       +4.76%       0.65    
12.00   16.00   13.65    1.19
innodb  order_by_big_key2                    11.00      +15.38%       2.00    
11.00   14.00   13.00    0.95
innodb  order_by_big_key_desc                13.00      +10.65%       1.55    
13.00   16.00   14.55    1.02
innodb  order_by_big_key_diff                12.00       +8.75%       1.15    
11.00   15.00   13.15    0.91
innodb  order_by_big_key_prefix              13.00       +0.38%       0.05    
12.00   15.00   13.05    0.86
innodb  order_by_key2_diff                    2.00      -29.03%      -0.45     
1.00    2.00    1.55    0.50
innodb  order_by_key_prefix                   1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  order_by_range                        1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  outer_join                           24.00       -7.14%      -1.60    
18.00   25.00   22.40    1.93
innodb  outer_join_found                     22.00       -2.09%      -0.45    
17.00   24.00   21.55    1.91
innodb  outer_join_not_found                 20.00       -1.78%      -0.35    
16.00   25.00   19.65    2.15
innodb  outer_join_on_key                    15.00       -1.69%      -0.25    
12.00   17.00   14.75    1.26
innodb  prepared_select                      36.00       +2.04%       0.75    
36.00   38.00   36.75    0.54
innodb  select_1_row                          3.00      +14.29%       0.50     
3.00    4.00    3.50    0.50
innodb  select_1_row_cache                    4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
innodb  select_2_rows                         3.00      +15.49%       0.55     
3.00    4.00    3.55    0.50
innodb  select_big                           13.00       -4.42%      -0.55    
11.00   15.00   12.45    1.12
innodb  select_big_str                        2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  select_cache                         64.00       -0.95%      -0.60    
60.00   72.00   63.40    2.89
innodb  select_cache2                        61.00       +4.76%       3.05    
58.00   73.00   64.05    3.26
innodb  select_column+column                  4.00       -2.56%      -0.10     
3.00    4.00    3.90    0.30
innodb  select_diff_key                       0.00     +100.00%       0.30     
0.00    1.00    0.30    0.46
innodb  select_distinct                       5.00      -11.11%      -0.50     
4.00    5.00    4.50    0.50
innodb  select_group                         18.00       -6.19%      -1.05    
15.00   19.00   16.95    1.56
innodb  select_group_when_MANY_tables        12.00       -1.69%      -0.20    
10.00   13.00   11.80    0.81
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           63.00       +1.33%       0.85    
63.00   66.00   63.85    0.79
innodb  select_key2                          70.00       +0.71%       0.50    
69.00   72.00   70.50    0.74
innodb  select_key2_return_key               67.00       +1.47%       1.00    
67.00   70.00   68.00    0.77
innodb  select_key2_return_prim              68.00       +1.23%       0.85    
68.00   71.00   68.85    0.73
innodb  select_key_prefix                    69.00       +1.43%       1.00    
68.00   71.00   70.00    0.77
innodb  select_key_prefix_join                5.00       +0.99%       0.05     
5.00    6.00    5.05    0.22
innodb  select_key_return_key                62.00       +1.12%       0.70    
61.00   64.00   62.70    0.64
innodb  select_many_fields                   14.00       -5.66%      -0.75    
12.00   14.00   13.25    0.54
innodb  select_range                         45.00       -1.47%      -0.65    
39.00   49.00   44.35    2.83
innodb  select_range_key2                    10.00       -5.26%      -0.50     
9.00   10.00    9.50    0.50
innodb  select_range_prefix                   9.00       +1.10%       0.10     
8.00   10.00    9.10    0.62
innodb  select_simple                         2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    0.00     +100.00%       0.70     
0.00    1.00    0.70    0.46
innodb  update_autocommit                     3.00      +15.49%       0.55     
3.00    5.00    3.55    0.59
innodb  update_big                           59.00       +0.76%       0.45    
56.00   65.00   59.45    1.96
innodb  update_commit                         2.00       -5.26%      -0.10     
1.00    2.00    1.90    0.30
innodb  update_of_key                        24.00       -9.09%      -2.00    
21.00   24.00   22.00    1.00
innodb  update_of_key_big                    33.00       +8.08%       2.90    
30.00   46.00   35.90    3.83
innodb  update_of_primary_key_many_keys    1350.00       -1.88%     -24.85  
1182.00 1435.00 1325.15   59.42
innodb  update_rollback                       3.00      -42.86%      -0.90     
2.00    3.00    2.10    0.30
innodb  update_with_key                     121.00       -0.21%      -0.25   
115.00  125.00  120.75    2.59
innodb  update_with_key_prefix               43.00       +2.49%       1.10    
41.00   47.00   44.10    1.64
innodb  wisc_benchmark                        3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      31.00      -42.29%      -9.21    
11.00   61.00   21.79   10.16
innodb  alter_table_drop                     24.00      -28.07%      -5.26    
10.00   57.00   18.74    6.86
innodb  connect                               2.00       +4.26%       0.09     
1.00    3.00    2.09    0.42
innodb  connect+select_1_row                  3.00      -10.39%      -0.28     
2.00    5.00    2.72    0.46
innodb  connect+select_simple                 3.00      -26.86%      -0.64     
1.00    3.00    2.36    0.49
innodb  count                                14.00      +11.06%       1.74    
12.00  193.00   15.74    8.54
innodb  count_distinct                        6.00       +8.87%       0.58     
5.00   50.00    6.58    2.21
innodb  count_distinct_2                     13.00       +1.73%       0.23    
11.00   63.00   13.23    2.88
innodb  count_distinct_big                   21.00       +4.53%       1.00     
5.00   67.00   22.00    2.97
innodb  count_distinct_group                 16.00      -20.84%      -2.76    
10.00   68.00   13.24    3.02
innodb  count_distinct_group_on_key          11.00      -15.71%      -1.49     
7.00   69.00    9.51    2.93
innodb  count_distinct_group_on_key_parts    14.00      -13.10%      -1.62     
9.00   72.00   12.38    3.07
innodb  count_distinct_key_prefix             5.00       +2.81%       0.14     
3.00   52.00    5.14    2.31
innodb  count_group_on_key_parts             11.00       -9.52%      -0.96     
7.00   72.00   10.04    3.06
innodb  count_on_key                         94.00       -8.66%      -7.49    
68.00  107.00   86.51    7.42
innodb  create+drop                          33.00       -1.58%      -0.51    
18.00   75.00   32.49   11.50
innodb  create_index                          3.00       -3.29%      -0.10     
1.00    8.00    2.90    1.11
innodb  create_key+drop                      31.00       -9.17%      -2.60    
21.00   50.00   28.40    4.82
innodb  create_MANY_tables                   20.00      +39.75%      13.19    
14.00  121.00   33.19   16.85
innodb  create_table                          0.00     +100.00%       0.10     
0.00    3.00    0.10    0.35
innodb  delete_all_many_keys                643.00      -35.03%    -166.82   
212.00 1888.00  476.18  354.92
innodb  delete_autocommit                     4.00      -15.80%      -0.55     
2.00   14.00    3.45    0.74
innodb  delete_big                            0.00     +100.00%       0.31     
0.00    3.00    0.31    0.47
innodb  delete_big_many_keys                643.00      -33.46%    -161.22   
212.00 2293.00  481.78  368.36
innodb  delete_commit                         2.00      -30.22%      -0.46     
1.00    5.00    1.54    0.53
innodb  delete_key                            3.00       +1.25%       0.04     
2.00   35.00    3.04    1.45
innodb  delete_range                          8.00       +3.95%       0.33     
5.00   23.00    8.33    3.14
innodb  delete_rollback                       2.00      -13.37%      -0.24     
1.00   12.00    1.76    0.89
innodb  drop_index                            3.00       -1.58%      -0.05     
1.00    9.00    2.95    1.28
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.23
innodb  drop_table_when_MANY_tables          19.00       +2.62%       0.51    
11.00   90.00   19.51    7.29
innodb  insert                              114.00       -6.39%      -6.85     
3.00  343.00  107.15   14.22
innodb  insert_autocommit                     3.00       +0.36%       0.01     
2.00   99.00    3.01    3.21
innodb  insert_commit                         2.00      -41.98%      -0.59     
1.00    3.00    1.41    0.50
innodb  insert_duplicates                    20.00      -27.38%      -4.30    
11.00   21.00   15.70    2.72
innodb  insert_key                          280.00       +7.12%      21.46   
142.00  700.00  301.46  103.41
innodb  insert_many_fields                    5.00      +10.98%       0.62     
3.00   17.00    5.62    1.72
innodb  insert_rollback                       2.00      -18.40%      -0.31     
1.00    3.00    1.69    0.53
innodb  insert_select_1_key                   4.00       -5.57%      -0.21     
2.00   10.00    3.79    0.87
innodb  insert_select_2_keys                  6.00       +1.29%       0.08     
4.00   16.00    6.08    2.03
innodb  min_max                               7.00      +10.48%       0.82     
6.00  110.00    7.82    4.40
innodb  min_max_on_key                       24.00      -15.41%      -3.21    
14.00   37.00   20.79    3.14
innodb  multiple_value_insert                 6.00       -8.67%      -0.48     
2.00   50.00    5.52    4.15
innodb  once_prepared_select                 29.00      -18.29%      -4.48    
18.00   32.00   24.52    3.65
innodb  order_by_big                         13.00       +9.13%       1.31    
12.00   31.00   14.31    1.51
innodb  order_by_big_key                     13.00       +2.42%       0.32    
11.00   32.00   13.32    1.64
innodb  order_by_big_key2                    11.00      +10.13%       1.24    
10.00   33.00   12.24    1.52
innodb  order_by_big_key_desc                13.00       +4.29%       0.58    
11.00   32.00   13.58    1.69
innodb  order_by_big_key_diff                12.00       +2.25%       0.28    
10.00   31.00   12.28    1.48
innodb  order_by_big_key_prefix              13.00       -4.51%      -0.56    
10.00   32.00   12.44    1.53
innodb  order_by_key2_diff                    2.00      -42.92%      -0.60     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -25.55%      -0.20     
0.00    2.00    0.80    0.41
innodb  order_by_range                        1.00      -19.66%      -0.16     
0.00    2.00    0.84    0.38
innodb  outer_join                           24.00      -23.02%      -4.49    
15.00   61.00   19.51    3.71
innodb  outer_join_found                     22.00      -16.30%      -3.08    
14.00   58.00   18.92    3.56
innodb  outer_join_not_found                 20.00      -20.19%      -3.36    
12.00   46.00   16.64    3.20
innodb  outer_join_on_key                    15.00      -15.21%      -1.98    
10.00   59.00   13.02    2.76
innodb  prepared_select                      36.00      -13.65%      -4.32    
22.00   40.00   31.68    4.58
innodb  select_1_row                          3.00       -3.72%      -0.11     
2.00    4.00    2.89    0.70
innodb  select_1_row_cache                    4.00      -46.42%      -1.27     
2.00    4.00    2.73    0.70
innodb  select_2_rows                         3.00       -2.64%      -0.08     
2.00    4.00    2.92    0.71
innodb  select_big                           13.00       -6.71%      -0.82     
0.00   31.00   12.18    1.53
innodb  select_big_str                        2.00      -70.07%      -0.82     
0.00    2.00    1.18    0.38
innodb  select_cache                         64.00       -6.91%      -4.14    
49.00   77.00   59.86    5.58
innodb  select_cache2                        61.00       -1.27%      -0.76    
49.00   75.00   60.24    6.21
innodb  select_column+column                  4.00      -34.31%      -1.02     
2.00    4.00    2.98    0.73
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.42
innodb  select_distinct                       5.00      -17.44%      -0.74     
3.00    8.00    4.26    0.55
innodb  select_group                         18.00      -10.51%      -1.71     
4.00  136.00   16.29    5.27
innodb  select_group_when_MANY_tables        12.00      -24.74%      -2.38     
3.00   49.00    9.62    9.17
innodb  select_join                           1.00      -72.80%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           63.00      -17.87%      -9.55    
40.00   66.00   53.45    7.70
innodb  select_key2                          70.00      -16.38%      -9.85    
45.00   75.00   60.15    8.48
innodb  select_key2_return_key               67.00      -16.55%      -9.52    
42.00   71.00   57.48    8.31
innodb  select_key2_return_prim              68.00      -16.74%      -9.75    
42.00   72.00   58.25    8.45
innodb  select_key_prefix                    69.00      -16.11%      -9.57    
44.00   75.00   59.43    8.53
innodb  select_key_prefix_join                5.00       -5.38%      -0.26     
3.00   10.00    4.74    0.64
innodb  select_key_return_key                62.00      -18.17%      -9.53    
38.00   65.00   52.47    7.69
innodb  select_many_fields                   14.00       +5.63%       0.83    
11.00   19.00   14.83    1.79
innodb  select_range                         45.00       +3.84%       1.80    
38.00   76.00   46.80    4.07
innodb  select_range_key2                    10.00      -19.96%      -1.66     
6.00   11.00    8.34    1.06
innodb  select_range_prefix                   9.00      -13.60%      -1.08     
5.00   10.00    7.92    1.14
innodb  select_simple                         2.00      -19.61%      -0.33     
1.00    3.00    1.67    0.51
innodb  select_simple_cache                   2.00      -26.34%      -0.42     
1.00    3.00    1.58    0.51
innodb  select_simple_join                    0.00     +100.00%       0.67     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     3.00      +10.42%       0.35     
2.00   16.00    3.35    0.99
innodb  update_big                           59.00      -14.57%      -7.50    
31.00  195.00   51.50   23.77
innodb  update_commit                         2.00      -26.11%      -0.41     
1.00   10.00    1.59    0.71
innodb  update_of_key                        24.00       +0.42%       0.10    
18.00  100.00   24.10    6.00
innodb  update_of_key_big                    33.00      -17.84%      -5.00    
15.00   75.00   28.00   10.87
innodb  update_of_primary_key_many_keys    1350.00       -8.20%    -102.29   
647.00 6065.00 1247.71  920.42
innodb  update_rollback                       3.00      -68.40%      -1.22     
1.00   31.00    1.78    1.84
innodb  update_with_key                     121.00       -9.44%     -10.44    
90.00  598.00  110.56   20.31
innodb  update_with_key_prefix               43.00       -7.73%      -3.08    
33.00  202.00   39.92    6.71
innodb  wisc_benchmark                        3.00      -20.95%      -0.52     
2.00    5.00    2.48    0.53

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

  2270.1.2: Brian Aker 2011-04-10 Remove dead document.
  2270.1.1: Brian Aker 2011-04-10 Update docs.

_______________________________________________
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