=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   956
RUN DATE: 2011-03-13T14:02:05.590835
SERVER:   drizzled
VERSION:  staging
REVISION: 2233
COMMENT:  2233: Lee Bieber 2011-03-13 [merge] Merge Olaf - Refactor Session

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      34.00       -4.94%      -1.60    
26.00   34.00   32.40    3.20
innodb  alter_table_drop                     22.00       +5.17%       1.20    
22.00   24.00   23.20    0.75
innodb  connect                               2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
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                                17.00       -8.97%      -1.40    
14.00   17.00   15.60    1.20
innodb  count_distinct                        6.00      +11.76%       0.80     
6.00    8.00    6.80    0.98
innodb  count_distinct_2                     14.00       -0.00%       0.00    
13.00   16.00   14.00    1.10
innodb  count_distinct_big                   25.00       -4.17%      -1.00    
21.00   25.00   24.00    1.55
innodb  count_distinct_group                 15.00       -7.14%      -1.00    
11.00   15.00   14.00    1.55
innodb  count_distinct_group_on_key          10.00       -4.17%      -0.40     
8.00   11.00    9.60    1.36
innodb  count_distinct_group_on_key_parts    13.00       +1.52%       0.20    
11.00   14.00   13.20    1.17
innodb  count_distinct_key_prefix             5.00      +10.71%       0.60     
5.00    6.00    5.60    0.49
innodb  count_group_on_key_parts             11.00       -3.77%      -0.40    
10.00   11.00   10.60    0.49
innodb  count_on_key                         95.00       -1.28%      -1.20    
92.00   95.00   93.80    1.47
innodb  create+drop                          34.00       -0.59%      -0.20    
32.00   35.00   33.80    0.98
innodb  create_index                          3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  create_key+drop                      30.00       +4.46%       1.40    
30.00   32.00   31.40    0.80
innodb  create_MANY_tables                   21.00       -1.94%      -0.40    
19.00   22.00   20.60    1.02
innodb  delete_all_many_keys                667.00       -3.67%     -23.60   
614.00  667.00  643.40   18.73
innodb  delete_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  delete_big                            0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_big_many_keys                667.00       -3.76%     -24.20   
614.00  667.00  642.80   18.67
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  delete_range                          8.00       +6.98%       0.60     
7.00   10.00    8.60    1.02
innodb  delete_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  drop_index                            3.00       -0.00%       0.00     
2.00    4.00    3.00    0.63
innodb  drop_table_when_MANY_tables          19.00       -2.15%      -0.40    
17.00   20.00   18.60    1.02
innodb  insert                              113.00       +0.70%       0.80   
112.00  116.00  113.80    1.47
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       -0.00%       0.00    
19.00   19.00   19.00    0.00
innodb  insert_key                          287.00       -1.56%      -4.40   
274.00  296.00  282.60    7.94
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                   4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  insert_select_2_keys                  6.00       -0.00%       0.00     
6.00    6.00    6.00    0.00
innodb  min_max                               8.00      -14.29%      -1.00     
6.00    8.00    7.00    0.63
innodb  min_max_on_key                       25.00       -2.46%      -0.60    
24.00   25.00   24.40    0.49
innodb  multiple_value_insert                 6.00      +11.76%       0.80     
6.00    7.00    6.80    0.40
innodb  once_prepared_select                 28.00       +2.10%       0.60    
28.00   29.00   28.60    0.49
innodb  order_by_big                         13.00       +5.80%       0.80    
13.00   15.00   13.80    0.98
innodb  order_by_big_key                     16.00      -15.94%      -2.20    
12.00   16.00   13.80    1.47
innodb  order_by_big_key2                    12.00       +1.64%       0.20    
11.00   13.00   12.20    0.75
innodb  order_by_big_key_desc                16.00       -6.67%      -1.00    
13.00   16.00   15.00    1.26
innodb  order_by_big_key_diff                12.00       +4.76%       0.60    
11.00   14.00   12.60    1.02
innodb  order_by_big_key_prefix              12.00       +1.64%       0.20    
12.00   13.00   12.20    0.40
innodb  order_by_key2_diff                    2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  order_by_key_prefix                   0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           22.00       +9.84%       2.40    
22.00   26.00   24.40    1.36
innodb  outer_join_found                     21.00      +11.76%       2.80    
21.00   26.00   23.80    1.72
innodb  outer_join_not_found                 20.00       -0.00%       0.00    
19.00   21.00   20.00    0.63
innodb  outer_join_on_key                    15.00      +11.76%       2.00    
15.00   18.00   17.00    1.10
innodb  prepared_select                      37.00       +0.54%       0.20    
37.00   38.00   37.20    0.40
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                           14.00      -11.11%      -1.40    
11.00   14.00   12.60    1.02
innodb  select_big_str                        2.00      -66.67%      -0.80     
1.00    2.00    1.20    0.40
innodb  select_cache                         64.00       -4.92%      -3.00    
58.00   64.00   61.00    2.28
innodb  select_cache2                        66.00       -3.45%      -2.20    
61.00   66.00   63.80    1.94
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_diff_key                       0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  select_distinct                       4.00       +4.76%       0.20     
4.00    5.00    4.20    0.40
innodb  select_group                         18.00       -5.88%      -1.00    
15.00   18.00   17.00    1.26
innodb  select_group_when_MANY_tables        13.00       -3.17%      -0.40    
12.00   14.00   12.60    0.80
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           63.00       +1.25%       0.80    
63.00   65.00   63.80    0.75
innodb  select_key2                          70.00       +1.13%       0.80    
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              68.00       +1.73%       1.20    
68.00   71.00   69.20    0.98
innodb  select_key_prefix                    70.00       +0.57%       0.40    
70.00   71.00   70.40    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.96%       0.60    
62.00   63.00   62.60    0.49
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         39.00      +11.36%       5.00    
39.00   47.00   44.00    3.10
innodb  select_range_key2                     9.00       +4.26%       0.40     
9.00   10.00    9.40    0.49
innodb  select_range_prefix                  10.00       -4.17%      -0.40     
9.00   10.00    9.60    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                    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                           58.00       +1.02%       0.60    
57.00   60.00   58.60    1.20
innodb  update_commit                         3.00      -36.36%      -0.80     
2.00    3.00    2.20    0.40
innodb  update_of_key                        21.00       +3.67%       0.80    
21.00   22.00   21.80    0.40
innodb  update_of_key_big                    29.00      +20.33%       7.40    
29.00   46.00   36.40    5.54
innodb  update_of_primary_key_many_keys    1369.00       -2.41%     -32.20  
1245.00 1400.00 1336.80   52.03
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     121.00       +0.98%       1.20   
118.00  127.00  122.20    3.66
innodb  update_with_key_prefix               47.00       -6.82%      -3.00    
40.00   47.00   44.00    2.28
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                      34.00       -4.45%      -1.45    
25.00   35.00   32.55    2.58
innodb  alter_table_drop                     22.00       +7.56%       1.80    
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       -3.45%      -0.10     
2.00    3.00    2.90    0.30
innodb  connect+select_simple                 3.00      -17.65%      -0.45     
2.00    3.00    2.55    0.50
innodb  count                                17.00       -5.59%      -0.90    
13.00   18.00   16.10    1.70
innodb  count_distinct                        6.00      +11.11%       0.75     
5.00    8.00    6.75    0.94
innodb  count_distinct_2                     14.00       -0.72%      -0.10    
12.00   16.00   13.90    1.22
innodb  count_distinct_big                   25.00       -7.99%      -1.85    
20.00   25.00   23.15    1.98
innodb  count_distinct_group                 15.00       -4.17%      -0.60    
11.00   15.00   14.40    0.97
innodb  count_distinct_group_on_key          10.00       -6.95%      -0.65     
8.00   11.00    9.35    0.96
innodb  count_distinct_group_on_key_parts    13.00       +0.76%       0.10    
11.00   14.00   13.10    1.09
innodb  count_distinct_key_prefix             5.00       +9.09%       0.50     
5.00    6.00    5.50    0.50
innodb  count_group_on_key_parts             11.00       -2.80%      -0.30    
10.00   11.00   10.70    0.46
innodb  count_on_key                         95.00       -2.59%      -2.40    
90.00   96.00   92.60    1.91
innodb  create+drop                          34.00       -2.26%      -0.75    
32.00   35.00   33.25    0.77
innodb  create_index                          3.00       +4.76%       0.15     
3.00    4.00    3.15    0.36
innodb  create_key+drop                      30.00       +4.46%       1.40    
30.00   33.00   31.40    0.80
innodb  create_MANY_tables                   21.00       -1.45%      -0.30    
19.00   22.00   20.70    0.78
innodb  delete_all_many_keys                667.00       -3.96%     -25.40   
608.00  713.00  641.60   26.25
innodb  delete_autocommit                     3.00      +14.29%       0.50     
3.00    4.00    3.50    0.50
innodb  delete_big                            0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                667.00       -4.09%     -26.20   
608.00  712.00  640.80   26.20
innodb  delete_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  delete_key                            3.00      -11.11%      -0.30     
2.00    3.00    2.70    0.46
innodb  delete_range                          8.00       +6.98%       0.60     
7.00   10.00    8.60    0.73
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.55
innodb  drop_table_when_MANY_tables          19.00       -1.60%      -0.30    
17.00   22.00   18.70    1.10
innodb  insert                              113.00       +0.62%       0.70   
111.00  116.00  113.70    1.31
innodb  insert_autocommit                     3.00       +3.23%       0.10     
3.00    4.00    3.10    0.30
innodb  insert_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  insert_duplicates                    19.00       +0.52%       0.10    
18.00   20.00   19.10    0.44
innodb  insert_key                          287.00       -2.90%      -8.10   
265.00  299.00  278.90    8.34
innodb  insert_many_fields                    6.00       -0.84%      -0.05     
5.00    7.00    5.95    0.38
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   4.00       -1.27%      -0.05     
3.00    5.00    3.95    0.38
innodb  insert_select_2_keys                  6.00       +1.64%       0.10     
5.00    8.00    6.10    0.62
innodb  min_max                               8.00       -3.90%      -0.30     
6.00    9.00    7.70    0.95
innodb  min_max_on_key                       25.00       -2.25%      -0.55    
23.00   25.00   24.45    0.59
innodb  multiple_value_insert                 6.00       +7.69%       0.50     
5.00    7.00    6.50    0.59
innodb  once_prepared_select                 28.00       +3.11%       0.90    
28.00   30.00   28.90    0.54
innodb  order_by_big                         13.00       +8.13%       1.15    
12.00   15.00   14.15    1.06
innodb  order_by_big_key                     16.00      -13.88%      -1.95    
12.00   16.00   14.05    1.32
innodb  order_by_big_key2                    12.00       +4.76%       0.60    
11.00   14.00   12.60    0.80
innodb  order_by_big_key_desc                16.00       -7.38%      -1.10    
13.00   17.00   14.90    1.22
innodb  order_by_big_key_diff                12.00       +5.14%       0.65    
11.00   14.00   12.65    0.79
innodb  order_by_big_key_prefix              12.00       +6.25%       0.80    
12.00   14.00   12.80    0.68
innodb  order_by_key2_diff                    2.00      -53.85%      -0.70     
1.00    2.00    1.30    0.46
innodb  order_by_key_prefix                   0.00     +100.00%       0.75     
0.00    1.00    0.75    0.43
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           22.00       +0.90%       0.20    
18.00   26.00   22.20    2.54
innodb  outer_join_found                     21.00       +2.10%       0.45    
17.00   26.00   21.45    2.64
innodb  outer_join_not_found                 20.00       -3.90%      -0.75    
15.00   22.00   19.25    1.92
innodb  outer_join_on_key                    15.00       -0.67%      -0.10    
12.00   18.00   14.90    1.87
innodb  prepared_select                      37.00       -0.14%      -0.05    
36.00   38.00   36.95    0.50
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      +18.92%       0.70     
3.00    4.00    3.70    0.46
innodb  select_big                           14.00      -13.36%      -1.65    
11.00   15.00   12.35    1.11
innodb  select_big_str                        2.00      -60.00%      -0.75     
1.00    2.00    1.25    0.43
innodb  select_cache                         64.00       -1.27%      -0.80    
57.00   67.00   63.20    2.82
innodb  select_cache2                        66.00       -2.56%      -1.65    
59.00   70.00   64.35    2.59
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.25     
0.00    1.00    0.25    0.43
innodb  select_distinct                       4.00      +12.09%       0.55     
4.00    5.00    4.55    0.50
innodb  select_group                         18.00       -8.43%      -1.40    
15.00   19.00   16.60    1.46
innodb  select_group_when_MANY_tables        13.00       -7.00%      -0.85    
11.00   14.00   12.15    0.79
innodb  select_join                           1.00     -100.00%      -0.50     
0.00    1.00    0.50    0.50
innodb  select_key                           63.00       +1.33%       0.85    
63.00   65.00   63.85    0.48
innodb  select_key2                          70.00       +0.92%       0.65    
69.00   72.00   70.65    0.79
innodb  select_key2_return_key               68.00       +0.37%       0.25    
67.00   70.00   68.25    0.77
innodb  select_key2_return_prim              68.00       +1.59%       1.10    
67.00   71.00   69.10    0.89
innodb  select_key_prefix                    70.00       +0.78%       0.55    
69.00   72.00   70.55    0.97
innodb  select_key_prefix_join                5.00       +0.99%       0.05     
4.00    6.00    5.05    0.38
innodb  select_key_return_key                62.00       +1.43%       0.90    
62.00   64.00   62.90    0.62
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         39.00       +8.77%       3.75    
38.00   47.00   42.75    2.93
innodb  select_range_key2                     9.00       +6.25%       0.60     
9.00   10.00    9.60    0.49
innodb  select_range_prefix                  10.00       -9.29%      -0.85     
8.00   10.00    9.15    0.57
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_join                    1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  update_autocommit                     3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  update_big                           58.00       +1.78%       1.05    
55.00   63.00   59.05    1.83
innodb  update_commit                         3.00      -53.85%      -1.05     
1.00    3.00    1.95    0.38
innodb  update_of_key                        21.00       +5.41%       1.20    
21.00   25.00   22.20    1.25
innodb  update_of_key_big                    29.00      +20.66%       7.55    
29.00   46.00   36.55    4.22
innodb  update_of_primary_key_many_keys    1369.00       -2.78%     -37.05  
1233.00 1464.00 1331.95   52.96
innodb  update_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  update_with_key                     121.00       +0.58%       0.70   
115.00  127.00  121.70    3.38
innodb  update_with_key_prefix               47.00       -6.70%      -2.95    
40.00   47.00   44.05    1.94
innodb  wisc_benchmark                        3.00      -13.21%      -0.35     
2.00    3.00    2.65    0.48

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      34.00      -58.89%     -12.60    
11.00   61.00   21.40   10.14
innodb  alter_table_drop                     22.00      -18.57%      -3.44    
10.00   57.00   18.56    6.92
innodb  connect                               2.00       +4.05%       0.08     
1.00    3.00    2.08    0.42
innodb  connect+select_1_row                  3.00      -10.82%      -0.29     
2.00    5.00    2.71    0.47
innodb  connect+select_simple                 3.00      -27.40%      -0.65     
1.00    3.00    2.35    0.49
innodb  count                                17.00       -7.90%      -1.24    
12.00  193.00   15.76    8.69
innodb  count_distinct                        6.00       +8.71%       0.57     
5.00   50.00    6.57    2.24
innodb  count_distinct_2                     14.00       -5.96%      -0.79    
11.00   63.00   13.21    2.92
innodb  count_distinct_big                   25.00      -13.81%      -3.03     
5.00   67.00   21.97    3.00
innodb  count_distinct_group                 15.00      -13.74%      -1.81    
10.00   68.00   13.19    3.06
innodb  count_distinct_group_on_key          10.00       -5.26%      -0.50     
7.00   69.00    9.50    2.98
innodb  count_distinct_group_on_key_parts    13.00       -5.24%      -0.65     
9.00   72.00   12.35    3.11
innodb  count_distinct_key_prefix             5.00       +2.61%       0.13     
3.00   52.00    5.13    2.35
innodb  count_group_on_key_parts             11.00       -9.94%      -0.99     
7.00   72.00   10.01    3.11
innodb  count_on_key                         95.00      -10.21%      -8.80    
68.00  107.00   86.20    7.37
innodb  create+drop                          34.00       -4.73%      -1.54    
18.00   75.00   32.46   11.71
innodb  create_index                          3.00       -3.50%      -0.10     
1.00    8.00    2.90    1.13
innodb  create_key+drop                      30.00       -6.04%      -1.71    
21.00   50.00   28.29    4.87
innodb  create_MANY_tables                   21.00      +37.60%      12.65    
14.00  121.00   33.65   16.99
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.36
innodb  delete_all_many_keys                667.00      -41.94%    -197.09   
212.00 1888.00  469.91  360.27
innodb  delete_autocommit                     3.00      +13.01%       0.45     
2.00   14.00    3.45    0.74
innodb  delete_big                            0.00     +100.00%       0.30     
0.00    3.00    0.30    0.47
innodb  delete_big_many_keys                667.00      -40.19%    -191.22   
212.00 2293.00  475.78  374.11
innodb  delete_commit                         2.00      -31.31%      -0.48     
1.00    5.00    1.52    0.53
innodb  delete_key                            3.00       +1.45%       0.04     
2.00   35.00    3.04    1.48
innodb  delete_range                          8.00       +3.88%       0.32     
5.00   23.00    8.32    3.19
innodb  delete_rollback                       2.00      -14.23%      -0.25     
1.00   12.00    1.75    0.91
innodb  drop_index                            3.00       -1.64%      -0.05     
1.00    9.00    2.95    1.30
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    2.00    0.05    0.23
innodb  drop_table_when_MANY_tables          19.00       +2.80%       0.55    
11.00   90.00   19.55    7.42
innodb  insert                              113.00       -5.70%      -6.09     
3.00  343.00  106.91   14.42
innodb  insert_autocommit                     3.00       +0.08%       0.00     
2.00   99.00    3.00    3.27
innodb  insert_commit                         2.00      -43.53%      -0.61     
1.00    3.00    1.39    0.50
innodb  insert_duplicates                    19.00      -22.04%      -3.43    
11.00   21.00   15.57    2.68
innodb  insert_key                          287.00       +5.09%      15.40   
142.00  700.00  302.40  105.38
innodb  insert_many_fields                    6.00       -6.86%      -0.39     
3.00   17.00    5.61    1.75
innodb  insert_rollback                       2.00      -19.14%      -0.32     
1.00    3.00    1.68    0.53
innodb  insert_select_1_key                   4.00       -5.70%      -0.22     
2.00   10.00    3.78    0.88
innodb  insert_select_2_keys                  6.00       +1.23%       0.07     
4.00   16.00    6.07    2.06
innodb  min_max                               8.00       -2.24%      -0.17     
6.00  110.00    7.83    4.48
innodb  min_max_on_key                       25.00      -21.02%      -4.34    
14.00   37.00   20.66    3.11
innodb  multiple_value_insert                 6.00       -9.38%      -0.51     
2.00   50.00    5.49    4.23
innodb  once_prepared_select                 28.00      -15.01%      -3.65    
18.00   32.00   24.35    3.61
innodb  order_by_big                         13.00       +9.18%       1.31    
12.00   31.00   14.31    1.52
innodb  order_by_big_key                     16.00      -20.27%      -2.70    
11.00   32.00   13.30    1.64
innodb  order_by_big_key2                    12.00       +1.79%       0.22    
10.00   33.00   12.22    1.53
innodb  order_by_big_key_desc                16.00      -18.14%      -2.46    
11.00   32.00   13.54    1.69
innodb  order_by_big_key_diff                12.00       +2.01%       0.25    
10.00   31.00   12.25    1.49
innodb  order_by_big_key_prefix              12.00       +3.36%       0.42    
10.00   32.00   12.42    1.55
innodb  order_by_key2_diff                    2.00      -43.25%      -0.60     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   0.00     +100.00%       0.79     
0.00    2.00    0.79    0.41
innodb  order_by_range                        1.00      -19.73%      -0.16     
0.00    2.00    0.84    0.38
innodb  outer_join                           22.00      -13.33%      -2.59    
15.00   61.00   19.41    3.72
innodb  outer_join_found                     21.00      -11.51%      -2.17    
14.00   58.00   18.83    3.58
innodb  outer_join_not_found                 20.00      -20.96%      -3.47    
12.00   46.00   16.53    3.18
innodb  outer_join_on_key                    15.00      -15.75%      -2.04    
10.00   59.00   12.96    2.77
innodb  prepared_select                      37.00      -17.53%      -5.52    
22.00   40.00   31.48    4.54
innodb  select_1_row                          3.00       -4.55%      -0.13     
2.00    4.00    2.87    0.69
innodb  select_1_row_cache                    4.00      -47.94%      -1.30     
2.00    4.00    2.70    0.70
innodb  select_2_rows                         3.00       -3.54%      -0.10     
2.00    4.00    2.90    0.71
innodb  select_big                           14.00      -15.00%      -1.83     
0.00   31.00   12.17    1.54
innodb  select_big_str                        2.00      -71.12%      -0.83     
0.00    2.00    1.17    0.38
innodb  select_cache                         64.00       -7.15%      -4.27    
49.00   77.00   59.73    5.60
innodb  select_cache2                        66.00       -9.84%      -5.91    
49.00   75.00   60.09    6.24
innodb  select_column+column                  4.00      -35.78%      -1.05     
2.00    4.00    2.95    0.72
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.42
innodb  select_distinct                       4.00       +5.76%       0.24     
3.00    8.00    4.24    0.55
innodb  select_group                         18.00      -10.62%      -1.73     
4.00  136.00   16.27    5.36
innodb  select_group_when_MANY_tables        13.00      -36.26%      -3.46     
3.00   49.00    9.54    9.33
innodb  select_join                           1.00      -73.44%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           63.00      -18.73%      -9.94    
40.00   66.00   53.06    7.56
innodb  select_key2                          70.00      -17.15%     -10.25    
45.00   75.00   59.75    8.39
innodb  select_key2_return_key               68.00      -19.11%     -10.91    
42.00   71.00   57.09    8.20
innodb  select_key2_return_prim              68.00      -17.55%     -10.15    
42.00   72.00   57.85    8.34
innodb  select_key_prefix                    70.00      -18.60%     -10.98    
44.00   75.00   59.02    8.42
innodb  select_key_prefix_join                5.00       -5.74%      -0.27     
3.00   10.00    4.73    0.65
innodb  select_key_return_key                62.00      -19.04%      -9.92    
38.00   65.00   52.08    7.57
innodb  select_many_fields                   13.00      +12.72%       1.89    
11.00   19.00   14.89    1.79
innodb  select_range                         39.00      +16.87%       7.92    
38.00   76.00   46.92    4.06
innodb  select_range_key2                     9.00       -8.50%      -0.71     
6.00   11.00    8.29    1.06
innodb  select_range_prefix                  10.00      -26.99%      -2.13     
5.00   10.00    7.87    1.12
innodb  select_simple                         2.00      -20.73%      -0.34     
1.00    3.00    1.66    0.51
innodb  select_simple_cache                   2.00      -27.59%      -0.43     
1.00    3.00    1.57    0.51
innodb  select_simple_join                    1.00      -50.76%      -0.34     
0.00    3.00    0.66    0.48
innodb  update_autocommit                     3.00      +10.19%       0.34     
2.00   16.00    3.34    1.00
innodb  update_big                           58.00      -13.26%      -6.79    
31.00  195.00   51.21   24.16
innodb  update_commit                         3.00      -90.62%      -1.43     
1.00   10.00    1.57    0.72
innodb  update_of_key                        21.00      +13.14%       3.18    
18.00  100.00   24.18    6.09
innodb  update_of_key_big                    29.00       -4.72%      -1.31    
15.00   75.00   27.69   10.92
innodb  update_of_primary_key_many_keys    1369.00      -10.07%    -125.21   
647.00 6065.00 1243.79  941.82
innodb  update_rollback                       2.00      -13.14%      -0.23     
1.00   31.00    1.77    1.87
innodb  update_with_key                     121.00       -9.82%     -10.81    
90.00  598.00  110.19   20.59
innodb  update_with_key_prefix               47.00      -18.20%      -7.24    
33.00  202.00   39.76    6.78
innodb  wisc_benchmark                        3.00      -21.17%      -0.52     
2.00    5.00    2.48    0.53

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

  2227.4.18: Olaf van der Spek 2011-03-13 Fix include
  2227.4.17: Olaf van der Spek 2011-03-13 [merge] Merge trunk
  2227.4.16: Olaf van der Spek 2011-03-12 [merge] Merge trunk
  2227.4.15: Olaf van der Spek 2011-03-11 [merge] Merge trunk
  2227.4.14: Olaf van der Spek 2011-03-10 Refactor Session
  2227.4.13: Olaf van der Spek 2011-03-10 Refactor Session
  2227.4.12: Olaf van der Spek 2011-03-10 Refactor Session
  2227.4.11: Olaf van der Spek 2011-03-10 Refactor Session
  2227.4.10: Olaf van der Spek 2011-03-10 Session::lex()
  2227.4.9: Olaf van der Spek 2011-03-10 Session::lex()
  2227.4.8: Olaf van der Spek 2011-03-10 Session::lex()
  2227.4.7: Olaf van der Spek 2011-03-10 
plugin::TableFunction::Generator::statement()
  2227.4.6: Olaf van der Spek 2011-03-10 plugin::TableFunction::Generator::lex()
  2227.4.5: Olaf van der Spek 2011-03-10 plugin::TableFunction::Generator::lex()
  2227.4.4: Olaf van der Spek 2011-03-10 Remove unused includes
  2227.4.3: Olaf van der Spek 2011-03-10 Remove unnecessary statement.h include
  2227.4.2: Olaf van der Spek 2011-03-10 Statement::session()
  2227.4.1: Olaf van der Spek 2011-03-10 Statement::session()

_______________________________________________
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