=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   1027
RUN DATE: 2011-06-15T15:11:09.225457
SERVER:   drizzled
VERSION:  staging
REVISION: 2335
COMMENT:  2335: Mark Atwood 2011-06-14 [merge] merge 
lp:~olafvdspek/drizzle/refactor7

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00       -0.00%       0.00    
32.00   34.00   33.00    0.89
innodb  alter_table_drop                     23.00       +3.36%       0.80    
23.00   25.00   23.80    0.75
innodb  connect                               3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  connect+select_1_row                  3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  connect+select_simple                 2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  count                                18.00       -7.14%      -1.20    
14.00   18.00   16.80    1.47
innodb  count_distinct                        8.00       -2.56%      -0.20     
7.00    8.00    7.80    0.40
innodb  count_distinct_2                     13.00       +7.14%       1.00    
12.00   16.00   14.00    1.41
innodb  count_distinct_big                   24.00       -3.45%      -0.80    
21.00   25.00   23.20    1.83
innodb  count_distinct_group                 12.00      +14.29%       2.00    
12.00   15.00   14.00    1.10
innodb  count_distinct_group_on_key           9.00      +10.00%       1.00     
9.00   11.00   10.00    0.89
innodb  count_distinct_group_on_key_parts    11.00       +9.84%       1.20    
11.00   14.00   12.20    1.17
innodb  count_distinct_key_prefix             5.00       +7.41%       0.40     
5.00    6.00    5.40    0.49
innodb  count_group_on_key_parts             11.00       -0.00%       0.00    
11.00   11.00   11.00    0.00
innodb  count_on_key                         95.00       +1.04%       1.00    
95.00   97.00   96.00    0.63
innodb  create+drop                          32.00       +1.23%       0.40    
31.00   34.00   32.40    1.02
innodb  create_index                          3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  create_key+drop                      33.00       -6.45%      -2.00    
30.00   33.00   31.00    1.10
innodb  create_MANY_tables                   21.00       -3.96%      -0.80    
19.00   21.00   20.20    0.75
innodb  delete_all_many_keys                805.00       +5.09%      43.20   
805.00  889.00  848.20   26.72
innodb  delete_autocommit                     4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  delete_big                            1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                804.00       +5.14%      43.60   
804.00  888.00  847.60   26.78
innodb  delete_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          8.00       -0.00%       0.00     
8.00    8.00    8.00    0.00
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            3.00      +11.76%       0.40     
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                              112.00       +1.06%       1.20   
112.00  114.00  113.20    0.75
innodb  insert_autocommit                     3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  insert_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_duplicates                    19.00       -1.06%      -0.20    
18.00   19.00   18.80    0.40
innodb  insert_key                          279.00       -0.72%      -2.00   
274.00  279.00  277.00    1.67
innodb  insert_many_fields                    6.00       -0.00%       0.00     
6.00    6.00    6.00    0.00
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   5.00       -0.00%       0.00     
4.00    6.00    5.00    0.63
innodb  insert_select_2_keys                  7.00      -12.90%      -0.80     
5.00    7.00    6.20    0.75
innodb  min_max                               9.00      -12.50%      -1.00     
6.00    9.00    8.00    1.26
innodb  min_max_on_key                       25.00       -0.81%      -0.20    
24.00   26.00   24.80    0.75
innodb  multiple_value_insert                 6.00      -11.11%      -0.60     
4.00    6.00    5.40    0.80
innodb  once_prepared_select                 29.00       +0.68%       0.20    
29.00   30.00   29.20    0.40
innodb  order_by_big                         14.00       +2.78%       0.40    
13.00   15.00   14.40    0.80
innodb  order_by_big_key                     16.00       -8.11%      -1.20    
13.00   16.00   14.80    1.17
innodb  order_by_big_key2                    13.00       +2.99%       0.40    
13.00   14.00   13.40    0.49
innodb  order_by_big_key_desc                16.00       -2.56%      -0.40    
14.00   16.00   15.60    0.80
innodb  order_by_big_key_diff                14.00       -7.69%      -1.00    
12.00   14.00   13.00    0.63
innodb  order_by_big_key_prefix              14.00       -1.45%      -0.20    
13.00   14.00   13.80    0.40
innodb  order_by_key2_diff                    2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  order_by_key_prefix                   1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  order_by_range                        0.00     +100.00%       0.80     
0.00    1.00    0.80    0.40
innodb  outer_join                           24.00       -7.14%      -1.60    
19.00   24.00   22.40    1.74
innodb  outer_join_found                     24.00      -11.11%      -2.40    
18.00   24.00   21.60    1.96
innodb  outer_join_not_found                 20.00       -4.17%      -0.80    
16.00   20.00   19.20    1.60
innodb  outer_join_on_key                    16.00      -11.11%      -1.60    
11.00   16.00   14.40    1.74
innodb  prepared_select                      38.00       -3.83%      -1.40    
36.00   38.00   36.60    0.80
innodb  select_1_row                          4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
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      +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.02
innodb  select_big_str                        1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  select_cache                         71.00       -6.29%      -4.20    
60.00   71.00   66.80    3.76
innodb  select_cache2                        65.00       +3.27%       2.20    
63.00   73.00   67.20    3.49
innodb  select_column+column                  4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_diff_key                       0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  select_distinct                       4.00       +4.76%       0.20     
4.00    5.00    4.20    0.40
innodb  select_group                         16.00      +11.11%       2.00    
16.00   19.00   18.00    1.10
innodb  select_group_when_MANY_tables        12.00       -5.26%      -0.60    
11.00   12.00   11.40    0.49
innodb  select_join                           0.00     +100.00%       0.60     
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                          72.00       -1.69%      -1.20    
69.00   72.00   70.80    1.17
innodb  select_key2_return_key               70.00       -2.04%      -1.40    
67.00   70.00   68.60    1.20
innodb  select_key2_return_prim              70.00       -1.45%      -1.00    
68.00   71.00   69.00    1.26
innodb  select_key_prefix                    72.00       -2.86%      -2.00    
68.00   72.00   70.00    1.41
innodb  select_key_prefix_join                6.00      -11.11%      -0.60     
5.00    6.00    5.40    0.49
innodb  select_key_return_key                64.00       -2.24%      -1.40    
62.00   64.00   62.60    0.80
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         41.00       +5.96%       2.60    
40.00   49.00   43.60    3.67
innodb  select_range_key2                    10.00       -2.04%      -0.20     
9.00   10.00    9.80    0.40
innodb  select_range_prefix                   9.00       +2.17%       0.20     
9.00   10.00    9.20    0.40
innodb  select_simple                         2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  update_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  update_big                           57.00       +0.35%       0.20    
55.00   60.00   57.20    1.60
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        22.00       -0.00%       0.00    
22.00   22.00   22.00    0.00
innodb  update_of_key_big                    19.00       -1.06%      -0.20    
18.00   19.00   18.80    0.40
innodb  update_of_primary_key_many_keys    1277.00       -0.69%      -8.80  
1252.00 1290.00 1268.20   13.57
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     121.00       -1.51%      -1.80   
117.00  121.00  119.20    1.60
innodb  update_with_key_prefix               42.00       +0.47%       0.20    
41.00   43.00   42.20    0.75
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                      33.00       -2.48%      -0.80    
31.00   34.00   32.20    0.98
innodb  alter_table_drop                     23.00       +4.17%       1.00    
23.00   26.00   24.00    0.84
innodb  connect                               3.00      -36.36%      -0.80     
2.00    3.00    2.20    0.40
innodb  connect+select_1_row                  3.00       -3.45%      -0.10     
2.00    3.00    2.90    0.30
innodb  connect+select_simple                 2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  count                                18.00      -10.09%      -1.65    
14.00   18.00   16.35    1.71
innodb  count_distinct                        8.00      -13.48%      -0.95     
6.00    8.00    7.05    0.86
innodb  count_distinct_2                     13.00       +7.80%       1.10    
12.00   16.00   14.10    1.34
innodb  count_distinct_big                   24.00       -4.35%      -1.00    
20.00   25.00   23.00    1.95
innodb  count_distinct_group                 12.00      +15.79%       2.25    
12.00   15.00   14.25    1.09
innodb  count_distinct_group_on_key           9.00       +7.69%       0.75     
9.00   11.00    9.75    0.89
innodb  count_distinct_group_on_key_parts    11.00      +13.73%       1.75    
11.00   14.00   12.75    1.13
innodb  count_distinct_key_prefix             5.00       +3.85%       0.20     
4.00    6.00    5.20    0.60
innodb  count_group_on_key_parts             11.00       +2.65%       0.30    
11.00   13.00   11.30    0.56
innodb  count_on_key                         95.00       +0.52%       0.50    
91.00   99.00   95.50    2.16
innodb  create+drop                          32.00       +2.44%       0.80    
31.00   35.00   32.80    1.08
innodb  create_index                          3.00       -1.69%      -0.05     
2.00    4.00    2.95    0.38
innodb  create_key+drop                      33.00       -7.32%      -2.25    
29.00   33.00   30.75    1.18
innodb  create_MANY_tables                   21.00       -2.69%      -0.55    
19.00   23.00   20.45    1.07
innodb  delete_all_many_keys                805.00       +9.59%      85.40   
640.00 1152.00  890.40  129.91
innodb  delete_autocommit                     4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
innodb  delete_big                            1.00     -185.71%      -0.65     
0.00    1.00    0.35    0.48
innodb  delete_big_many_keys                804.00       +9.64%      85.80   
639.00 1151.00  889.80  129.82
innodb  delete_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  delete_key                            3.00       -0.00%       0.00     
2.00    4.00    3.00    0.32
innodb  delete_range                          8.00       +1.23%       0.10     
7.00    9.00    8.10    0.62
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            3.00       +4.76%       0.15     
2.00    4.00    3.15    0.57
innodb  drop_table_when_MANY_tables          18.00       +4.00%       0.75    
18.00   21.00   18.75    0.83
innodb  insert                              112.00       -0.00%       0.00   
110.00  114.00  112.00    1.14
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       +0.78%       0.15    
18.00   20.00   19.15    0.48
innodb  insert_key                          279.00       +0.11%       0.30   
264.00  305.00  279.30   10.01
innodb  insert_many_fields                    6.00       -1.69%      -0.10     
5.00    7.00    5.90    0.62
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   5.00       -2.04%      -0.10     
4.00    6.00    4.90    0.54
innodb  insert_select_2_keys                  7.00       -9.38%      -0.60     
5.00    7.00    6.40    0.58
innodb  min_max                               9.00       -8.43%      -0.70     
6.00    9.00    8.30    0.90
innodb  min_max_on_key                       25.00       -1.01%      -0.25    
24.00   26.00   24.75    0.62
innodb  multiple_value_insert                 6.00       -8.11%      -0.45     
4.00    7.00    5.55    0.74
innodb  once_prepared_select                 29.00       +0.17%       0.05    
28.00   30.00   29.05    0.38
innodb  order_by_big                         14.00       +1.06%       0.15    
13.00   15.00   14.15    0.91
innodb  order_by_big_key                     16.00      -12.68%      -1.80    
12.00   16.00   14.20    1.17
innodb  order_by_big_key2                    13.00       +2.99%       0.40    
12.00   14.00   13.40    0.66
innodb  order_by_big_key_desc                16.00       -5.61%      -0.85    
14.00   16.00   15.15    0.91
innodb  order_by_big_key_diff                14.00       -8.11%      -1.05    
11.00   15.00   12.95    0.92
innodb  order_by_big_key_prefix              14.00       -5.66%      -0.75    
12.00   14.00   13.25    0.70
innodb  order_by_key2_diff                    2.00      -48.15%      -0.65     
1.00    2.00    1.35    0.48
innodb  order_by_key_prefix                   1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  order_by_range                        0.00     +100.00%       0.90     
0.00    1.00    0.90    0.30
innodb  outer_join                           24.00       -8.35%      -1.85    
18.00   24.00   22.15    2.13
innodb  outer_join_found                     24.00      -13.48%      -2.85    
16.00   24.00   21.15    2.37
innodb  outer_join_not_found                 20.00       -3.63%      -0.70    
16.00   21.00   19.30    1.95
innodb  outer_join_on_key                    16.00      -12.28%      -1.75    
11.00   16.00   14.25    1.58
innodb  prepared_select                      38.00       -3.54%      -1.30    
36.00   38.00   36.70    0.56
innodb  select_1_row                          4.00       -9.59%      -0.35     
3.00    4.00    3.65    0.48
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      +18.92%       0.70     
3.00    4.00    3.70    0.46
innodb  select_big                           15.00      -15.38%      -2.00    
11.00   15.00   13.00    0.89
innodb  select_big_str                        1.00      +25.93%       0.35     
1.00    2.00    1.35    0.48
innodb  select_cache                         71.00       -8.98%      -5.85    
60.00   71.00   65.15    3.02
innodb  select_cache2                        65.00       +0.76%       0.50    
61.00   73.00   65.50    3.31
innodb  select_column+column                  4.00       -6.67%      -0.25     
3.00    4.00    3.75    0.43
innodb  select_diff_key                       0.00     +100.00%       0.35     
0.00    1.00    0.35    0.48
innodb  select_distinct                       4.00      +13.04%       0.60     
4.00    5.00    4.60    0.49
innodb  select_group                         16.00       +6.98%       1.20    
15.00   19.00   17.20    1.40
innodb  select_group_when_MANY_tables        12.00       -2.56%      -0.30    
11.00   14.00   11.70    0.84
innodb  select_join                           0.00     +100.00%       0.75     
0.00    1.00    0.75    0.43
innodb  select_key                           64.00       -0.16%      -0.10    
63.00   65.00   63.90    0.77
innodb  select_key2                          72.00       -1.98%      -1.40    
69.00   72.00   70.60    0.92
innodb  select_key2_return_key               70.00       -2.79%      -1.90    
67.00   70.00   68.10    0.94
innodb  select_key2_return_prim              70.00       -1.52%      -1.05    
68.00   71.00   68.95    0.97
innodb  select_key_prefix                    72.00       -2.71%      -1.90    
68.00   72.00   70.10    0.89
innodb  select_key_prefix_join                6.00      -15.38%      -0.80     
5.00    6.00    5.20    0.40
innodb  select_key_return_key                64.00       -1.99%      -1.25    
62.00   64.00   62.75    0.70
innodb  select_many_fields                   13.00       +0.76%       0.10    
12.00   14.00   13.10    0.44
innodb  select_range                         41.00       +7.66%       3.40    
40.00   49.00   44.40    2.92
innodb  select_range_key2                    10.00       -2.56%      -0.25     
9.00   11.00    9.75    0.62
innodb  select_range_prefix                   9.00       +2.70%       0.25     
8.00   10.00    9.25    0.62
innodb  select_simple                         2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  select_simple_cache                   2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_join                    1.00      -33.33%      -0.25     
0.00    1.00    0.75    0.43
innodb  update_autocommit                     3.00      +10.45%       0.35     
3.00    4.00    3.35    0.48
innodb  update_big                           57.00       +1.72%       1.00    
55.00   61.00   58.00    1.67
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        22.00       +0.90%       0.20    
21.00   24.00   22.20    0.68
innodb  update_of_key_big                    19.00       -0.80%      -0.15    
18.00   20.00   18.85    0.73
innodb  update_of_primary_key_many_keys    1277.00       +0.01%       0.10  
1105.00 1458.00 1277.10   72.41
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     121.00       -2.46%      -2.90   
115.00  121.00  118.10    1.92
innodb  update_with_key_prefix               42.00       +0.83%       0.35    
41.00   44.00   42.35    1.19
innodb  wisc_benchmark                        2.00      +18.37%       0.45     
2.00    3.00    2.45    0.50

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00      -49.13%     -10.87    
11.00   61.00   22.13   10.16
innodb  alter_table_drop                     23.00      -21.62%      -4.09    
10.00   57.00   18.91    6.81
innodb  connect                               3.00      -43.31%      -0.91     
1.00    3.00    2.09    0.42
innodb  connect+select_1_row                  3.00      -10.09%      -0.27     
2.00    5.00    2.73    0.46
innodb  connect+select_simple                 2.00      +15.74%       0.37     
1.00    3.00    2.37    0.49
innodb  count                                18.00      -14.25%      -2.25    
12.00  193.00   15.75    8.41
innodb  count_distinct                        8.00      -21.29%      -1.40     
5.00   50.00    6.60    2.18
innodb  count_distinct_2                     13.00       +1.88%       0.25    
11.00   63.00   13.25    2.84
innodb  count_distinct_big                   24.00       -8.95%      -1.97     
5.00   67.00   22.03    2.94
innodb  count_distinct_group                 12.00       +9.61%       1.28    
10.00   68.00   13.28    2.98
innodb  count_distinct_group_on_key           9.00       +5.42%       0.52     
7.00   69.00    9.52    2.89
innodb  count_distinct_group_on_key_parts    11.00      +11.25%       1.39     
9.00   72.00   12.39    3.03
innodb  count_distinct_key_prefix             5.00       +2.86%       0.15     
3.00   52.00    5.15    2.28
innodb  count_group_on_key_parts             11.00       -9.09%      -0.92     
7.00   72.00   10.08    3.02
innodb  count_on_key                         95.00       -9.43%      -8.18    
68.00  107.00   86.82    7.50
innodb  create+drop                          32.00       +1.54%       0.50    
18.00   75.00   32.50   11.30
innodb  create_index                          3.00       -3.18%      -0.09     
1.00    8.00    2.91    1.09
innodb  create_key+drop                      33.00      -15.83%      -4.51    
21.00   50.00   28.49    4.77
innodb  create_MANY_tables                   21.00      +35.91%      11.76    
14.00  121.00   32.76   16.73
innodb  create_table                          0.00     +100.00%       0.10     
0.00    3.00    0.10    0.35
innodb  delete_all_many_keys                805.00      -64.10%    -314.45   
212.00 1888.00  490.55  357.76
innodb  delete_autocommit                     4.00      -15.67%      -0.54     
2.00   14.00    3.46    0.73
innodb  delete_big                            1.00     -228.28%      -0.70     
0.00    3.00    0.30    0.47
innodb  delete_big_many_keys                804.00      -62.14%    -308.12   
212.00 2293.00  495.88  370.40
innodb  delete_commit                         2.00      -29.26%      -0.45     
1.00    5.00    1.55    0.52
innodb  delete_key                            3.00       +1.11%       0.03     
2.00   35.00    3.03    1.43
innodb  delete_range                          8.00       +3.88%       0.32     
5.00   23.00    8.32    3.08
innodb  delete_rollback                       2.00      -12.80%      -0.23     
1.00   12.00    1.77    0.88
innodb  drop_index                            3.00       -1.42%      -0.04     
1.00    9.00    2.96    1.26
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.63%       1.49    
11.00   90.00   19.49    7.17
innodb  insert                              112.00       -4.36%      -4.68     
3.00  343.00  107.32   14.01
innodb  insert_autocommit                     3.00       +0.42%       0.01     
2.00   99.00    3.01    3.15
innodb  insert_commit                         2.00      -40.52%      -0.58     
1.00    3.00    1.42    0.50
innodb  insert_duplicates                    19.00      -20.12%      -3.18    
11.00   21.00   15.82    2.75
innodb  insert_key                          279.00       +7.20%      21.64   
142.00  700.00  300.64  101.60
innodb  insert_many_fields                    6.00       -6.64%      -0.37     
3.00   17.00    5.63    1.69
innodb  insert_rollback                       2.00      -17.68%      -0.30     
1.00    3.00    1.70    0.52
innodb  insert_select_1_key                   5.00      -30.56%      -1.17     
2.00   10.00    3.83    0.89
innodb  insert_select_2_keys                  7.00      -15.03%      -0.91     
4.00   16.00    6.09    2.00
innodb  min_max                               9.00      -14.99%      -1.17     
6.00  110.00    7.83    4.33
innodb  min_max_on_key                       25.00      -19.48%      -4.08    
14.00   37.00   20.92    3.17
innodb  multiple_value_insert                 6.00       -8.54%      -0.47     
2.00   50.00    5.53    4.09
innodb  once_prepared_select                 29.00      -17.58%      -4.34    
18.00   32.00   24.66    3.68
innodb  order_by_big                         14.00       +2.09%       0.30    
12.00   31.00   14.30    1.49
innodb  order_by_big_key                     16.00      -19.73%      -2.64    
11.00   32.00   13.36    1.64
innodb  order_by_big_key2                    13.00       -5.94%      -0.73    
10.00   33.00   12.27    1.51
innodb  order_by_big_key_desc                16.00      -17.32%      -2.36    
11.00   32.00   13.64    1.69
innodb  order_by_big_key_diff                14.00      -13.84%      -1.70    
10.00   31.00   12.30    1.47
innodb  order_by_big_key_prefix              14.00      -12.35%      -1.54    
10.00   32.00   12.46    1.52
innodb  order_by_key2_diff                    2.00      -42.79%      -0.60     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -24.97%      -0.20     
0.00    2.00    0.80    0.41
innodb  order_by_range                        0.00     +100.00%       0.84     
0.00    2.00    0.84    0.37
innodb  outer_join                           24.00      -22.42%      -4.40    
15.00   61.00   19.60    3.72
innodb  outer_join_found                     24.00      -26.35%      -5.01    
14.00   58.00   18.99    3.56
innodb  outer_join_not_found                 20.00      -19.53%      -3.27    
12.00   46.00   16.73    3.21
innodb  outer_join_on_key                    16.00      -22.43%      -2.93    
10.00   59.00   13.07    2.74
innodb  prepared_select                      38.00      -19.32%      -6.15    
22.00   40.00   31.85    4.59
innodb  select_1_row                          4.00      -37.07%      -1.08     
2.00    4.00    2.92    0.71
innodb  select_1_row_cache                    4.00      -45.16%      -1.24     
2.00    4.00    2.76    0.71
innodb  select_2_rows                         3.00       -1.74%      -0.05     
2.00    4.00    2.95    0.72
innodb  select_big                           15.00      -22.87%      -2.79     
0.00   31.00   12.21    1.52
innodb  select_big_str                        1.00      +15.38%       0.18     
0.00    2.00    1.18    0.39
innodb  select_cache                         71.00      -18.29%     -10.98    
49.00   77.00   60.02    5.58
innodb  select_cache2                        65.00       -7.59%      -4.58    
49.00   76.00   60.42    6.22
innodb  select_column+column                  4.00      -33.15%      -1.00     
2.00    4.00    3.00    0.74
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.42
innodb  select_distinct                       4.00       +6.22%       0.27     
3.00    8.00    4.27    0.55
innodb  select_group                         16.00       +1.93%       0.31     
4.00  136.00   16.31    5.19
innodb  select_group_when_MANY_tables        12.00      -23.81%      -2.31     
3.00   49.00    9.69    9.03
innodb  select_join                           0.00     +100.00%       0.58     
0.00    1.00    0.58    0.49
innodb  select_key                           64.00      -18.96%     -10.20    
40.00   66.00   53.80    7.80
innodb  select_key2                          72.00      -19.02%     -11.50    
45.00   75.00   60.50    8.55
innodb  select_key2_return_key               70.00      -21.03%     -12.16    
42.00   71.00   57.84    8.38
innodb  select_key2_return_prim              70.00      -19.45%     -11.40    
42.00   72.00   58.60    8.52
innodb  select_key_prefix                    72.00      -20.43%     -12.22    
44.00   75.00   59.78    8.61
innodb  select_key_prefix_join                6.00      -26.00%      -1.24     
3.00   10.00    4.76    0.65
innodb  select_key_return_key                64.00      -21.19%     -11.19    
38.00   65.00   52.81    7.79
innodb  select_many_fields                   13.00      +12.07%       1.78    
11.00   19.00   14.78    1.79
innodb  select_range                         41.00      +12.28%       5.74    
38.00   76.00   46.74    4.06
innodb  select_range_key2                    10.00      -19.32%      -1.62     
6.00   11.00    8.38    1.08
innodb  select_range_prefix                   9.00      -12.93%      -1.03     
5.00   10.00    7.97    1.15
innodb  select_simple                         2.00      -18.61%      -0.31     
1.00    3.00    1.69    0.51
innodb  select_simple_cache                   2.00      -25.07%      -0.40     
1.00    3.00    1.60    0.51
innodb  select_simple_join                    1.00      -48.91%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     3.00      +10.47%       0.35     
2.00   16.00    3.35    0.98
innodb  update_big                           57.00      -10.20%      -5.28    
31.00  195.00   51.72   23.40
innodb  update_commit                         2.00      -25.02%      -0.40     
1.00   10.00    1.60    0.71
innodb  update_of_key                        22.00       +8.48%       2.04    
18.00  100.00   24.04    5.91
innodb  update_of_key_big                    19.00      +31.49%       8.74    
15.00   75.00   27.74   10.81
innodb  update_of_primary_key_many_keys    1277.00       -2.26%     -28.27   
647.00 6065.00 1248.73  900.91
innodb  update_rollback                       2.00      -11.74%      -0.21     
1.00   31.00    1.79    1.81
innodb  update_with_key                     121.00       -9.18%     -10.18    
90.00  598.00  110.82   20.02
innodb  update_with_key_prefix               42.00       -4.97%      -1.99    
33.00  202.00   40.01    6.62
innodb  wisc_benchmark                        2.00      +19.46%       0.48     
2.00    5.00    2.48    0.52

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

  2318.2.47: Olaf van der Spek 2011-06-14 Oops
  2318.2.46: Olaf van der Spek 2011-06-14 [merge] Merge trunk
  2318.2.45: Olaf van der Spek 2011-06-13 Refactor
  2318.2.44: Olaf van der Spek 2011-06-13 Refactor
  2318.2.43: Olaf van der Spek 2011-06-13 Refactor
  2318.2.42: Olaf van der Spek 2011-06-13 Refactor

_______________________________________________
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