=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   949
RUN DATE: 2011-03-09T19:21:53.067096
SERVER:   drizzled
VERSION:  staging
REVISION: 2227
COMMENT:  2227: Monty Taylor 2011-03-09 [merge] Merged Dave - Filtered 
Replication docs

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      35.00      -10.06%      -3.20    
25.00   35.00   31.80    3.54
innodb  alter_table_drop                     23.00       +1.71%       0.40    
22.00   25.00   23.40    1.02
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       +1.16%       0.20    
16.00   18.00   17.20    0.75
innodb  count_distinct                        6.00       +9.09%       0.60     
6.00    8.00    6.60    0.80
innodb  count_distinct_2                     14.00       -0.00%       0.00    
13.00   16.00   14.00    1.10
innodb  count_distinct_big                   25.00       -5.93%      -1.40    
20.00   25.00   23.60    1.85
innodb  count_distinct_group                 15.00       -4.17%      -0.60    
13.00   15.00   14.40    0.80
innodb  count_distinct_group_on_key           9.00       +2.17%       0.20     
8.00   11.00    9.20    0.98
innodb  count_distinct_group_on_key_parts    14.00       -0.00%       0.00    
14.00   14.00   14.00    0.00
innodb  count_distinct_key_prefix             6.00       -7.14%      -0.40     
5.00    6.00    5.60    0.49
innodb  count_group_on_key_parts             11.00       -1.85%      -0.20    
10.00   11.00   10.80    0.40
innodb  count_on_key                         96.00       -3.67%      -3.40    
91.00   96.00   92.60    1.74
innodb  create+drop                          32.00       +2.44%       0.80    
32.00   34.00   32.80    0.75
innodb  create_index                          3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  create_key+drop                      31.00       +1.27%       0.40    
30.00   33.00   31.40    1.02
innodb  create_MANY_tables                   22.00       -4.76%      -1.00    
20.00   22.00   21.00    0.89
innodb  delete_all_many_keys                624.00       +4.00%      26.00   
624.00  692.00  650.00   25.67
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                623.00       +4.01%      26.00   
623.00  691.00  649.00   25.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                          9.00       -0.00%       0.00     
8.00   10.00    9.00    0.63
innodb  delete_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  drop_index                            3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  drop_table_when_MANY_tables          20.00       -6.38%      -1.20    
18.00   20.00   18.80    0.98
innodb  insert                              114.00       -0.53%      -0.60   
111.00  116.00  113.40    1.62
innodb  insert_autocommit                     4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  insert_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  insert_duplicates                    19.00       -0.00%       0.00    
18.00   20.00   19.00    0.63
innodb  insert_key                          275.00       +1.79%       5.00   
273.00  299.00  280.00    9.63
innodb  insert_many_fields                    5.00      +16.67%       1.00     
5.00    7.00    6.00    0.63
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                  7.00      -12.90%      -0.80     
5.00    7.00    6.20    0.75
innodb  min_max                               9.00       -7.14%      -0.60     
7.00    9.00    8.40    0.80
innodb  min_max_on_key                       25.00       -2.46%      -0.60    
23.00   25.00   24.40    0.80
innodb  multiple_value_insert                 7.00       -9.38%      -0.60     
5.00    7.00    6.40    0.80
innodb  once_prepared_select                 29.00       -1.40%      -0.40    
28.00   29.00   28.60    0.49
innodb  order_by_big                         12.00      +14.29%       2.00    
12.00   15.00   14.00    1.26
innodb  order_by_big_key                     12.00      +13.04%       1.80    
12.00   15.00   13.80    1.17
innodb  order_by_big_key2                    11.00      +15.38%       2.00    
11.00   14.00   13.00    1.10
innodb  order_by_big_key_desc                14.00       +7.89%       1.20    
13.00   17.00   15.20    1.47
innodb  order_by_big_key_diff                12.00       +6.25%       0.80    
12.00   13.00   12.80    0.40
innodb  order_by_big_key_prefix              12.00       +9.09%       1.20    
12.00   14.00   13.20    0.75
innodb  order_by_key2_diff                    2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -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       -7.14%      -1.60    
18.00   24.00   22.40    2.24
innodb  outer_join_found                     22.00       -1.85%      -0.40    
17.00   23.00   21.60    2.33
innodb  outer_join_not_found                 21.00       -5.00%      -1.00    
16.00   22.00   20.00    2.10
innodb  outer_join_on_key                    16.00      -11.11%      -1.60    
12.00   16.00   14.40    1.62
innodb  prepared_select                      37.00       -0.54%      -0.20    
36.00   37.00   36.80    0.40
innodb  select_1_row                          3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  select_1_row_cache                    4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_2_rows                         3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_big                           12.00       -0.00%       0.00    
11.00   13.00   12.00    0.89
innodb  select_big_str                        1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  select_cache                         67.00       -6.01%      -3.80    
57.00   67.00   63.20    4.02
innodb  select_cache2                        64.00       -0.00%       0.00    
61.00   67.00   64.00    2.00
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       -8.43%      -1.40    
15.00   18.00   16.60    1.36
innodb  select_group_when_MANY_tables        12.00       +3.23%       0.40    
12.00   14.00   12.40    0.80
innodb  select_join                           0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  select_key                           64.00       -0.31%      -0.20    
63.00   64.00   63.80    0.40
innodb  select_key2                          71.00       -0.85%      -0.60    
70.00   71.00   70.40    0.49
innodb  select_key2_return_key               68.00       -0.59%      -0.40    
67.00   68.00   67.60    0.49
innodb  select_key2_return_prim              69.00       -0.29%      -0.20    
68.00   69.00   68.80    0.40
innodb  select_key_prefix                    71.00       -1.14%      -0.80    
69.00   71.00   70.20    0.75
innodb  select_key_prefix_join                5.00       -0.00%       0.00     
5.00    5.00    5.00    0.00
innodb  select_key_return_key                63.00       -0.32%      -0.20    
62.00   63.00   62.80    0.40
innodb  select_many_fields                   14.00       -6.06%      -0.80    
13.00   14.00   13.20    0.40
innodb  select_range                         41.00       +0.97%       0.40    
39.00   44.00   41.40    2.24
innodb  select_range_key2                    10.00       -0.00%       0.00    
10.00   10.00   10.00    0.00
innodb  select_range_prefix                   9.00       -2.27%      -0.20     
8.00    9.00    8.80    0.40
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       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  update_autocommit                     3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  update_big                           61.00       +0.33%       0.20    
59.00   63.00   61.20    1.33
innodb  update_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  update_of_key                        21.00       +8.70%       2.00    
21.00   24.00   23.00    1.10
innodb  update_of_key_big                    33.00       +5.17%       1.80    
31.00   38.00   34.80    2.48
innodb  update_of_primary_key_many_keys    1336.00       +1.71%      23.20  
1315.00 1464.00 1359.20   53.36
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     119.00       +2.78%       3.40   
118.00  127.00  122.40    3.44
innodb  update_with_key_prefix               47.00       -5.86%      -2.60    
41.00   47.00   44.40    2.15
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                      35.00       -7.53%      -2.45    
25.00   35.00   32.55    2.04
innodb  alter_table_drop                     23.00       +3.56%       0.85    
22.00   26.00   23.85    0.96
innodb  connect                               2.00      +13.04%       0.30     
2.00    3.00    2.30    0.46
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       -2.10%      -0.35    
13.00   19.00   16.65    1.77
innodb  count_distinct                        6.00      +12.41%       0.85     
6.00    8.00    6.85    0.79
innodb  count_distinct_2                     14.00       -1.08%      -0.15    
11.00   16.00   13.85    1.42
innodb  count_distinct_big                   25.00       -8.70%      -2.00    
20.00   25.00   23.00    1.90
innodb  count_distinct_group                 15.00       -1.69%      -0.25    
13.00   16.00   14.75    0.77
innodb  count_distinct_group_on_key           9.00       +5.26%       0.50     
8.00   11.00    9.50    0.97
innodb  count_distinct_group_on_key_parts    14.00       -4.87%      -0.65    
11.00   15.00   13.35    1.06
innodb  count_distinct_key_prefix             6.00      -12.15%      -0.65     
5.00    6.00    5.35    0.48
innodb  count_group_on_key_parts             11.00       -2.33%      -0.25    
10.00   11.00   10.75    0.43
innodb  count_on_key                         96.00       -4.23%      -3.90    
89.00   96.00   92.10    1.70
innodb  create+drop                          32.00       +3.47%       1.15    
32.00   34.00   33.15    0.65
innodb  create_index                          3.00       +3.23%       0.10     
3.00    4.00    3.10    0.30
innodb  create_key+drop                      31.00       +1.27%       0.40    
30.00   33.00   31.40    0.86
innodb  create_MANY_tables                   22.00       -5.52%      -1.15    
20.00   22.00   20.85    0.73
innodb  create_table                          0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  delete_all_many_keys                624.00       +2.98%      19.15   
580.00  721.00  643.15   32.91
innodb  delete_autocommit                     3.00      +18.92%       0.70     
3.00    5.00    3.70    0.56
innodb  delete_big                            0.00     +100.00%       0.50     
0.00    1.00    0.50    0.50
innodb  delete_big_many_keys                623.00       +3.00%      19.25   
580.00  719.00  642.25   32.65
innodb  delete_commit                         2.00       -8.11%      -0.15     
1.00    2.00    1.85    0.36
innodb  delete_key                            3.00      -13.21%      -0.35     
2.00    3.00    2.65    0.48
innodb  delete_range                          9.00       -2.86%      -0.25     
8.00   10.00    8.75    0.62
innodb  delete_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  drop_index                            3.00       -1.69%      -0.05     
2.00    4.00    2.95    0.50
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  drop_table_when_MANY_tables          20.00       -6.67%      -1.25    
17.00   22.00   18.75    1.13
innodb  insert                              114.00       -0.26%      -0.30   
111.00  116.00  113.70    1.38
innodb  insert_autocommit                     4.00      -29.03%      -0.90     
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                          275.00       +1.03%       2.85   
263.00  299.00  277.85    8.82
innodb  insert_many_fields                    5.00      +15.97%       0.95     
5.00    7.00    5.95    0.38
innodb  insert_rollback                       2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  insert_select_1_key                   4.00       -3.90%      -0.15     
3.00    5.00    3.85    0.48
innodb  insert_select_2_keys                  7.00      -13.82%      -0.85     
5.00    8.00    6.15    0.73
innodb  min_max                               9.00      -13.92%      -1.10     
7.00    9.00    7.90    0.94
innodb  min_max_on_key                       25.00       -2.25%      -0.55    
23.00   25.00   24.45    0.59
innodb  multiple_value_insert                 7.00      -10.24%      -0.65     
5.00    8.00    6.35    0.73
innodb  once_prepared_select                 29.00       +0.17%       0.05    
28.00   30.00   29.05    0.50
innodb  order_by_big                         12.00      +17.53%       2.55    
12.00   16.00   14.55    1.07
innodb  order_by_big_key                     12.00      +14.59%       2.05    
12.00   16.00   14.05    1.32
innodb  order_by_big_key2                    11.00      +14.06%       1.80    
11.00   15.00   12.80    0.98
innodb  order_by_big_key_desc                14.00       +5.08%       0.75    
13.00   17.00   14.75    1.26
innodb  order_by_big_key_diff                12.00       +6.61%       0.85    
11.00   14.00   12.85    0.79
innodb  order_by_big_key_prefix              12.00       +8.75%       1.15    
12.00   14.00   13.15    0.65
innodb  order_by_key2_diff                    2.00      -53.85%      -0.70     
1.00    2.00    1.30    0.46
innodb  order_by_key_prefix                   1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           24.00      -11.11%      -2.40    
17.00   24.00   21.60    2.46
innodb  outer_join_found                     22.00       -6.54%      -1.35    
16.00   23.00   20.65    2.50
innodb  outer_join_not_found                 21.00      -10.82%      -2.05    
15.00   23.00   18.95    2.38
innodb  outer_join_on_key                    16.00      -11.11%      -1.60    
11.00   17.00   14.40    1.66
innodb  prepared_select                      37.00       -0.00%       0.00    
36.00   38.00   37.00    0.55
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      +18.92%       0.70     
3.00    4.00    3.70    0.46
innodb  select_big                           12.00       +2.44%       0.30    
11.00   15.00   12.30    1.00
innodb  select_big_str                        1.00      +23.08%       0.30     
1.00    2.00    1.30    0.46
innodb  select_cache                         67.00       -5.10%      -3.25    
57.00   67.00   63.75    2.34
innodb  select_cache2                        64.00       -0.47%      -0.30    
59.00   68.00   63.70    2.57
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.30     
0.00    1.00    0.30    0.46
innodb  select_distinct                       5.00       -9.89%      -0.45     
4.00    5.00    4.55    0.50
innodb  select_group                         18.00       -9.09%      -1.50    
15.00   19.00   16.50    1.53
innodb  select_group_when_MANY_tables        12.00       -0.84%      -0.10    
11.00   14.00   11.90    0.77
innodb  select_join                           0.00     +100.00%       0.50     
0.00    1.00    0.50    0.50
innodb  select_key                           64.00       -0.16%      -0.10    
63.00   66.00   63.90    0.62
innodb  select_key2                          71.00       -0.42%      -0.30    
69.00   73.00   70.70    1.00
innodb  select_key2_return_key               68.00       +0.15%       0.10    
67.00   70.00   68.10    0.77
innodb  select_key2_return_prim              69.00       -0.00%       0.00    
67.00   71.00   69.00    0.89
innodb  select_key_prefix                    71.00       -0.85%      -0.60    
69.00   72.00   70.40    1.02
innodb  select_key_prefix_join                5.00       +0.99%       0.05     
5.00    6.00    5.05    0.22
innodb  select_key_return_key                63.00       -0.32%      -0.20    
62.00   64.00   62.80    0.68
innodb  select_many_fields                   14.00       -5.66%      -0.75    
13.00   14.00   13.25    0.43
innodb  select_range                         41.00       +3.30%       1.40    
39.00   46.00   42.40    2.60
innodb  select_range_key2                    10.00       -4.17%      -0.40     
8.00   10.00    9.60    0.58
innodb  select_range_prefix                   9.00       -0.56%      -0.05     
8.00   10.00    8.95    0.59
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       -5.26%      -0.05     
0.00    1.00    0.95    0.22
innodb  update_autocommit                     3.00      +20.00%       0.75     
3.00    5.00    3.75    0.54
innodb  update_big                           61.00       -3.65%      -2.15    
55.00   63.00   58.85    1.85
innodb  update_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  update_of_key                        21.00       +6.25%       1.40    
21.00   25.00   22.40    1.20
innodb  update_of_key_big                    33.00       +9.47%       3.45    
31.00   45.00   36.45    3.32
innodb  update_of_primary_key_many_keys    1336.00       -0.57%      -7.55  
1217.00 1465.00 1328.45   58.87
innodb  update_rollback                       2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  update_with_key                     119.00       +1.57%       1.90   
115.00  127.00  120.90    2.90
innodb  update_with_key_prefix               47.00       -6.46%      -2.85    
41.00   48.00   44.15    2.06
innodb  wisc_benchmark                        3.00      -17.65%      -0.45     
2.00    3.00    2.55    0.50

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      35.00      -64.26%     -13.69    
11.00   61.00   21.31   10.13
innodb  alter_table_drop                     23.00      -24.22%      -4.48    
10.00   57.00   18.52    6.93
innodb  connect                               2.00       +4.03%       0.08     
1.00    3.00    2.08    0.42
innodb  connect+select_1_row                  3.00      -10.91%      -0.30     
2.00    5.00    2.70    0.47
innodb  connect+select_simple                 3.00      -27.56%      -0.65     
1.00    3.00    2.35    0.48
innodb  count                                17.00       -7.88%      -1.24    
12.00  193.00   15.76    8.73
innodb  count_distinct                        6.00       +8.71%       0.57     
5.00   50.00    6.57    2.25
innodb  count_distinct_2                     14.00       -6.01%      -0.79    
11.00   63.00   13.21    2.93
innodb  count_distinct_big                   25.00      -13.88%      -3.05     
5.00   67.00   21.95    3.00
innodb  count_distinct_group                 15.00      -13.80%      -1.82    
10.00   68.00   13.18    3.06
innodb  count_distinct_group_on_key           9.00       +5.27%       0.50     
7.00   69.00    9.50    2.99
innodb  count_distinct_group_on_key_parts    14.00      -13.39%      -1.65     
9.00   72.00   12.35    3.12
innodb  count_distinct_key_prefix             6.00      -16.94%      -0.87     
3.00   52.00    5.13    2.36
innodb  count_group_on_key_parts             11.00      -10.00%      -1.00     
7.00   72.00   10.00    3.12
innodb  count_on_key                         96.00      -11.45%      -9.86    
68.00  107.00   86.14    7.36
innodb  create+drop                          32.00       +1.40%       0.45    
18.00   75.00   32.45   11.75
innodb  create_index                          3.00       -3.61%      -0.10     
1.00    8.00    2.90    1.13
innodb  create_key+drop                      31.00       -9.67%      -2.73    
21.00   50.00   28.27    4.88
innodb  create_MANY_tables                   22.00      +34.83%      11.76    
14.00  121.00   33.76   17.01
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.36
innodb  delete_all_many_keys                624.00      -33.19%    -155.49   
212.00 1888.00  468.51  361.43
innodb  delete_autocommit                     3.00      +13.01%       0.45     
2.00   14.00    3.45    0.75
innodb  delete_big                            0.00     +100.00%       0.30     
0.00    3.00    0.30    0.47
innodb  delete_big_many_keys                623.00      -31.31%    -148.56   
212.00 2293.00  474.44  375.36
innodb  delete_commit                         2.00      -31.64%      -0.48     
1.00    5.00    1.52    0.53
innodb  delete_key                            3.00       +1.53%       0.05     
2.00   35.00    3.05    1.48
innodb  delete_range                          9.00       -8.16%      -0.68     
5.00   23.00    8.32    3.20
innodb  delete_rollback                       2.00      -14.58%      -0.25     
1.00   12.00    1.75    0.91
innodb  drop_index                            3.00       -1.65%      -0.05     
1.00    9.00    2.95    1.31
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    2.00    0.05    0.23
innodb  drop_table_when_MANY_tables          20.00       -2.28%      -0.44    
11.00   90.00   19.56    7.45
innodb  insert                              114.00       -6.68%      -7.14     
3.00  343.00  106.86   14.47
innodb  insert_autocommit                     4.00      -33.23%      -1.00     
2.00   99.00    3.00    3.28
innodb  insert_commit                         2.00      -44.03%      -0.61     
1.00    3.00    1.39    0.50
innodb  insert_duplicates                    19.00      -22.26%      -3.46    
11.00   21.00   15.54    2.68
innodb  insert_key                          275.00       +9.12%      27.60   
142.00  700.00  302.60  105.81
innodb  insert_many_fields                    5.00      +10.90%       0.61     
3.00   17.00    5.61    1.75
innodb  insert_rollback                       2.00      -19.32%      -0.32     
1.00    3.00    1.68    0.53
innodb  insert_select_1_key                   4.00       -5.71%      -0.22     
2.00   10.00    3.78    0.88
innodb  insert_select_2_keys                  7.00      -15.22%      -0.92     
4.00   16.00    6.08    2.07
innodb  min_max                               9.00      -14.95%      -1.17     
6.00  110.00    7.83    4.50
innodb  min_max_on_key                       25.00      -21.20%      -4.37    
14.00   37.00   20.63    3.11
innodb  multiple_value_insert                 7.00      -27.84%      -1.52     
2.00   50.00    5.48    4.24
innodb  once_prepared_select                 29.00      -19.29%      -4.69    
18.00   32.00   24.31    3.60
innodb  order_by_big                         12.00      +16.19%       2.32    
12.00   31.00   14.32    1.52
innodb  order_by_big_key                     12.00       +9.77%       1.30    
11.00   32.00   13.30    1.64
innodb  order_by_big_key2                    11.00       +9.97%       1.22    
10.00   33.00   12.22    1.54
innodb  order_by_big_key_desc                14.00       -3.46%      -0.47    
11.00   32.00   13.53    1.69
innodb  order_by_big_key_diff                12.00       +2.00%       0.24    
10.00   31.00   12.24    1.50
innodb  order_by_big_key_prefix              12.00       +3.37%       0.42    
10.00   32.00   12.42    1.55
innodb  order_by_key2_diff                    2.00      -43.16%      -0.60     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -26.11%      -0.21     
0.00    2.00    0.79    0.41
innodb  order_by_range                        1.00      -19.92%      -0.17     
0.00    2.00    0.83    0.38
innodb  outer_join                           24.00      -23.79%      -4.61    
15.00   61.00   19.39    3.71
innodb  outer_join_found                     22.00      -16.97%      -3.19    
14.00   58.00   18.81    3.57
innodb  outer_join_not_found                 21.00      -27.15%      -4.48    
12.00   46.00   16.52    3.18
innodb  outer_join_on_key                    16.00      -23.67%      -3.06    
10.00   59.00   12.94    2.76
innodb  prepared_select                      37.00      -17.69%      -5.56    
22.00   40.00   31.44    4.54
innodb  select_1_row                          3.00       -4.76%      -0.14     
2.00    4.00    2.86    0.69
innodb  select_1_row_cache                    4.00      -48.25%      -1.30     
2.00    4.00    2.70    0.69
innodb  select_2_rows                         3.00       -3.73%      -0.11     
2.00    4.00    2.89    0.70
innodb  select_big                           12.00       +1.40%       0.17     
0.00   31.00   12.17    1.54
innodb  select_big_str                        1.00      +14.37%       0.17     
0.00    2.00    1.17    0.38
innodb  select_cache                         67.00      -12.20%      -7.29    
49.00   77.00   59.71    5.62
innodb  select_cache2                        64.00       -6.57%      -3.95    
49.00   75.00   60.05    6.25
innodb  select_column+column                  4.00      -36.06%      -1.06     
2.00    4.00    2.94    0.72
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.41
innodb  select_distinct                       5.00      -17.84%      -0.76     
3.00    8.00    4.24    0.55
innodb  select_group                         18.00      -10.64%      -1.73     
4.00  136.00   16.27    5.38
innodb  select_group_when_MANY_tables        12.00      -26.08%      -2.48     
3.00   49.00    9.52    9.36
innodb  select_join                           0.00     +100.00%       0.58     
0.00    1.00    0.58    0.49
innodb  select_key                           64.00      -20.81%     -11.03    
40.00   66.00   52.97    7.53
innodb  select_key2                          71.00      -18.99%     -11.33    
45.00   75.00   59.67    8.36
innodb  select_key2_return_key               68.00      -19.31%     -11.00    
42.00   71.00   57.00    8.17
innodb  select_key2_return_prim              69.00      -19.46%     -11.24    
42.00   72.00   57.76    8.31
innodb  select_key_prefix                    71.00      -20.48%     -12.07    
44.00   75.00   58.93    8.39
innodb  select_key_prefix_join                5.00       -5.79%      -0.27     
3.00   10.00    4.73    0.65
innodb  select_key_return_key                63.00      -21.16%     -11.00    
38.00   65.00   52.00    7.54
innodb  select_many_fields                   14.00       +6.09%       0.91    
11.00   19.00   14.91    1.79
innodb  select_range                         41.00      +12.67%       5.95    
38.00   76.00   46.95    4.04
innodb  select_range_key2                    10.00      -20.69%      -1.71     
6.00   11.00    8.29    1.05
innodb  select_range_prefix                   9.00      -14.47%      -1.14     
5.00   10.00    7.86    1.12
innodb  select_simple                         2.00      -20.93%      -0.35     
1.00    3.00    1.65    0.51
innodb  select_simple_cache                   2.00      -27.87%      -0.44     
1.00    3.00    1.56    0.51
innodb  select_simple_join                    1.00      -50.86%      -0.34     
0.00    3.00    0.66    0.48
innodb  update_autocommit                     3.00      +10.17%       0.34     
2.00   16.00    3.34    1.01
innodb  update_big                           61.00      -19.25%      -9.85    
31.00  195.00   51.15   24.24
innodb  update_commit                         2.00      -27.35%      -0.43     
1.00   10.00    1.57    0.72
innodb  update_of_key                        21.00      +13.21%       3.20    
18.00  100.00   24.20    6.11
innodb  update_of_key_big                    33.00      -19.47%      -5.38    
15.00   75.00   27.62   10.93
innodb  update_of_primary_key_many_keys    1336.00       -7.48%     -92.99   
647.00 6065.00 1243.01  946.57
innodb  update_rollback                       2.00      -13.26%      -0.23     
1.00   31.00    1.77    1.88
innodb  update_with_key                     119.00       -8.10%      -8.91    
90.00  598.00  110.09   20.64
innodb  update_with_key_prefix               47.00      -18.30%      -7.27    
33.00  202.00   39.73    6.79
innodb  wisc_benchmark                        3.00      -21.32%      -0.53     
2.00    5.00    2.47    0.53

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

  2226.1.14: Monty Taylor 2011-03-09 Removed unused file.
  2226.1.13: Monty Taylor 2011-03-09 Removed blackhole.
  2226.1.12: Monty Taylor 2011-03-09 Removed the last archive test.
  2226.1.11: Monty Taylor 2011-03-09 And a couple of files in potfiles...
  2226.1.10: Monty Taylor 2011-03-08 Got rid of archive engine.
  2226.1.9: Monty Taylor 2011-03-08 Replaced a needed file.
  2226.1.8: Monty Taylor 2011-03-08 Shoved archive back in- killed filesystem 
engine.
  2226.1.7: Monty Taylor 2011-03-08 Removed some plugins that we're just really 
not using anymore.
  2226.1.6: Monty Taylor 2011-03-08 Moved drizzle/drizzle.h to 
libdrizzle/libdrizzle.h - we don't have a drizzle
  2226.1.5: Monty Taylor 2011-03-08 [merge] Merged David - Filtered Replication 
Docs.
    2224.3.3: David Shrewsbury 2011-03-08 Fix option name.
    2224.3.2: David Shrewsbury 2011-03-08 Add filtered replicator plugin docs.
    2224.3.1: David Shrewsbury 2011-03-08 Add documentation about replication 
streams.
  2226.1.4: Monty Taylor 2011-03-08 [merge] Merged Olaf - Statement refactor.
    2224.2.9: Olaf van der Spek 2011-03-08 Statement::set_command
    2224.2.8: Olaf van der Spek 2011-03-08 Statement::lex()
    2224.2.7: Olaf van der Spek 2011-03-08 Statement::set_command
    2224.2.6: Olaf van der Spek 2011-03-08 Statement::set_command
    2224.2.5: Olaf van der Spek 2011-03-08 Undo partial commit
    2224.2.4: Olaf van der Spek 2011-03-08 Undo partial commit
    2224.2.3: Olaf van der Spek 2011-03-08 Refactor
    2224.2.2: Olaf van der Spek 2011-03-08 Refactor
    2224.2.1: Olaf van der Spek 2011-03-08 Refactor
  2226.1.3: Monty Taylor 2011-03-08 [merge] Merge Olaf - XID refactor.
    2224.1.1: Olaf van der Spek 2011-03-08 Finish removing XID cache
  2226.1.2: Monty Taylor 2011-03-08 [merge] Merged Olaf - refactor 
Session::getLex
    2221.11.1: Olaf van der Spek 2011-03-08 Session::getLex()
  2226.1.1: Monty Taylor 2011-03-08 [merge] Merged drizzle/drizzle.h from Olaf.
    2221.10.1: Olaf van der Spek 2011-03-06 Provide drizzle/drizzle.h

_______________________________________________
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