=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   552
RUN DATE: 2010-10-12T16:08:03.978750
SERVER:   drizzled
VERSION:  staging
REVISION: 1843
COMMENT:  1843: lbieber 2010-10-12 [merge] Merge Monty - add valgrind stripping 
program to the tree, suppress size_t signature change

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      13.00       -1.56%      -0.20    
12.00   14.00   12.80    0.75
innodb  alter_table_drop                     15.00       -8.70%      -1.20    
12.00   15.00   13.80    1.17
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      -25.00%      -0.60     
2.00    3.00    2.40    0.49
innodb  count                                13.00      +16.67%       2.60    
13.00   17.00   15.60    1.74
innodb  count_distinct                        7.00      -12.90%      -0.80     
5.00    7.00    6.20    0.75
innodb  count_distinct_2                     14.00      -11.11%      -1.40    
11.00   15.00   12.60    1.62
innodb  count_distinct_big                   21.00       +5.41%       1.20    
20.00   25.00   22.20    1.94
innodb  count_distinct_group                 14.00      -16.67%      -2.00    
10.00   14.00   12.00    1.79
innodb  count_distinct_group_on_key          11.00      -22.22%      -2.00     
8.00   11.00    9.00    1.26
innodb  count_distinct_group_on_key_parts    13.00       -8.33%      -1.00    
11.00   14.00   12.00    1.26
innodb  count_distinct_key_prefix             6.00      -20.00%      -1.00     
4.00    6.00    5.00    0.89
innodb  count_group_on_key_parts             10.00       -0.00%       0.00    
10.00   10.00   10.00    0.00
innodb  count_on_key                         89.00       -0.91%      -0.80    
86.00   91.00   88.20    1.72
innodb  create+drop                          25.00       +0.79%       0.20    
23.00   29.00   25.20    2.04
innodb  create_index                          3.00      -25.00%      -0.60     
2.00    3.00    2.40    0.49
innodb  create_key+drop                      26.00       +2.26%       0.60    
25.00   29.00   26.60    1.36
innodb  create_MANY_tables                   21.00       -2.94%      -0.60    
17.00   28.00   20.40    4.08
innodb  create_table                          0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_all_many_keys                227.00       -2.99%      -6.60   
212.00  227.00  220.40    6.62
innodb  delete_autocommit                     3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  delete_big                            1.00     -400.00%      -0.80     
0.00    1.00    0.20    0.40
innodb  delete_big_many_keys                227.00       -2.99%      -6.60   
212.00  227.00  220.40    6.62
innodb  delete_commit                         1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          6.00       -0.00%       0.00     
6.00    6.00    6.00    0.00
innodb  delete_rollback                       1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  drop_index                            2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  drop_table                            0.00         NULL       0.00     
0.00    0.00    0.00    0.00
innodb  drop_table_when_MANY_tables          14.00       -0.00%       0.00    
13.00   15.00   14.00    0.63
innodb  insert                              102.00       +0.20%       0.20    
99.00  108.00  102.20    3.06
innodb  insert_autocommit                     3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  insert_commit                         1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  insert_duplicates                    14.00       +7.89%       1.20    
14.00   18.00   15.20    1.47
innodb  insert_key                          169.00       -5.10%      -8.20   
148.00  170.00  160.80    9.70
innodb  insert_many_fields                    5.00      +13.79%       0.80     
5.00    8.00    5.80    1.17
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  insert_select_2_keys                  4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  min_max                               6.00      +21.05%       1.60     
6.00    9.00    7.60    1.02
innodb  min_max_on_key                       23.00      -10.58%      -2.20    
19.00   23.00   20.80    1.47
innodb  multiple_value_insert                 3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  once_prepared_select                 22.00       +1.79%       0.40    
22.00   23.00   22.40    0.49
innodb  order_by_big                         12.00      +11.76%       1.60    
12.00   15.00   13.60    1.20
innodb  order_by_big_key                     14.00       -2.94%      -0.40    
11.00   15.00   13.60    1.36
innodb  order_by_big_key2                    11.00       +8.33%       1.00    
11.00   14.00   12.00    1.10
innodb  order_by_big_key_desc                15.00       -5.63%      -0.80    
12.00   15.00   14.20    1.17
innodb  order_by_big_key_diff                11.00       +1.79%       0.20    
10.00   12.00   11.20    0.75
innodb  order_by_big_key_prefix              12.00       +4.76%       0.60    
11.00   14.00   12.60    1.02
innodb  order_by_key2_diff                    1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  order_by_key_prefix                   1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           15.00       +9.64%       1.60    
15.00   20.00   16.60    1.74
innodb  outer_join_found                     15.00       +7.41%       1.20    
15.00   19.00   16.20    1.47
innodb  outer_join_not_found                 13.00       +5.80%       0.80    
13.00   17.00   13.80    1.60
innodb  outer_join_on_key                    11.00       +3.51%       0.40    
11.00   13.00   11.40    0.80
innodb  prepared_select                      30.00       +1.32%       0.40    
28.00   32.00   30.40    1.50
innodb  select_1_row                          3.00      -25.00%      -0.60     
2.00    3.00    2.40    0.49
innodb  select_1_row_cache                    2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  select_2_rows                         3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  select_big                           13.00       -4.84%      -0.60    
11.00   14.00   12.40    1.02
innodb  select_big_str                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  select_cache                         64.00       -4.58%      -2.80    
53.00   64.00   61.20    4.17
innodb  select_cache2                        66.00       -5.43%      -3.40    
53.00   66.00   62.60    4.88
innodb  select_column+column                  2.00      +28.57%       0.80     
2.00    3.00    2.80    0.40
innodb  select_diff_key                       1.00     -400.00%      -0.80     
0.00    1.00    0.20    0.40
innodb  select_distinct                       4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_group                         14.00       +9.09%       1.40    
14.00   17.00   15.40    1.36
innodb  select_group_when_MANY_tables         5.00       -0.00%       0.00     
4.00    6.00    5.00    0.63
innodb  select_join                           0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  select_key                           51.00       +3.04%       1.60    
50.00   61.00   52.60    4.22
innodb  select_key2                          56.00       +7.28%       4.40    
56.00   68.00   60.40    5.43
innodb  select_key2_return_key               54.00       +4.26%       2.40    
54.00   60.00   56.40    2.58
innodb  select_key2_return_prim              54.00       +2.17%       1.20    
54.00   58.00   55.20    1.47
innodb  select_key_prefix                    55.00       +0.72%       0.40    
54.00   56.00   55.40    0.80
innodb  select_key_prefix_join                5.00       -4.17%      -0.20     
4.00    5.00    4.80    0.40
innodb  select_key_return_key                49.00       +6.84%       3.60    
49.00   58.00   52.60    3.38
innodb  select_many_fields                   17.00       -7.59%      -1.20    
14.00   17.00   15.80    1.17
innodb  select_range                         51.00       -8.05%      -3.80    
44.00   53.00   47.20    3.97
innodb  select_range_key2                     8.00       +4.76%       0.40     
8.00    9.00    8.40    0.49
innodb  select_range_prefix                   8.00       -5.26%      -0.40     
7.00    8.00    7.60    0.49
innodb  select_simple                         1.00      +37.50%       0.60     
1.00    2.00    1.60    0.49
innodb  select_simple_cache                   1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  select_simple_join                    1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  TOTALS                             2860.00       -1.89%     -53.00  
2759.00 2860.00 2807.00   43.29
innodb  update_autocommit                     4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  update_big                           35.00       +2.78%       1.00    
35.00   38.00   36.00    1.10
innodb  update_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  update_of_key                        20.00       +4.76%       1.00    
20.00   22.00   21.00    0.63
innodb  update_of_key_big                    17.00       +1.16%       0.20    
16.00   19.00   17.20    0.98
innodb  update_of_primary_key_many_keys     730.00       -5.37%     -37.20   
664.00  730.00  692.80   25.07
innodb  update_rollback                       2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  update_with_key                     109.00       -0.74%      -0.80   
104.00  111.00  108.20    2.79
innodb  update_with_key_prefix               37.00       -1.09%      -0.40    
35.00   37.00   36.60    0.80
innodb  wisc_benchmark                        2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      13.00       +2.62%       0.35    
12.00   15.00   13.35    0.73
innodb  alter_table_drop                     15.00       -9.89%      -1.35    
12.00   16.00   13.65    1.35
innodb  connect                               2.00       +4.76%       0.10     
1.00    3.00    2.10    0.44
innodb  connect+select_1_row                  3.00      -11.11%      -0.30     
2.00    3.00    2.70    0.46
innodb  connect+select_simple                 3.00      -33.33%      -0.75     
2.00    3.00    2.25    0.43
innodb  count                                13.00      +15.58%       2.40    
13.00   18.00   15.40    1.83
innodb  count_distinct                        7.00      -11.11%      -0.70     
5.00    8.00    6.30    0.71
innodb  count_distinct_2                     14.00      -10.67%      -1.35    
11.00   16.00   12.65    1.71
innodb  count_distinct_big                   21.00       +5.41%       1.20    
19.00   25.00   22.20    2.04
innodb  count_distinct_group                 14.00      -14.75%      -1.80    
10.00   15.00   12.20    1.63
innodb  count_distinct_group_on_key          11.00      -21.55%      -1.95     
8.00   11.00    9.05    1.12
innodb  count_distinct_group_on_key_parts    13.00      -13.04%      -1.50     
9.00   14.00   11.50    1.53
innodb  count_distinct_key_prefix             6.00      -25.00%      -1.20     
4.00    6.00    4.80    0.87
innodb  count_group_on_key_parts             10.00       -3.09%      -0.30     
8.00   10.00    9.70    0.71
innodb  count_on_key                         89.00       -4.40%      -3.75    
75.00   93.00   85.25    4.41
innodb  create+drop                          25.00      +10.87%       3.05    
23.00   37.00   28.05    3.75
innodb  create_index                          3.00      -39.53%      -0.85     
2.00    3.00    2.15    0.36
innodb  create_key+drop                      26.00       +2.26%       0.60    
25.00   29.00   26.60    0.92
innodb  create_MANY_tables                   21.00      +17.97%       4.60    
17.00   38.00   25.60    6.11
innodb  create_table                          0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  delete_all_many_keys                227.00       +3.57%       8.40   
212.00  275.00  235.40   17.53
innodb  delete_autocommit                     3.00      +10.45%       0.35     
3.00    4.00    3.35    0.48
innodb  delete_big                            1.00     -400.00%      -0.80     
0.00    1.00    0.20    0.40
innodb  delete_big_many_keys                227.00       +3.57%       8.40   
212.00  275.00  235.40   17.53
innodb  delete_commit                         1.00      +33.33%       0.50     
1.00    2.00    1.50    0.50
innodb  delete_key                            3.00       -3.45%      -0.10     
2.00    4.00    2.90    0.54
innodb  delete_range                          6.00       +1.64%       0.10     
5.00    7.00    6.10    0.44
innodb  delete_rollback                       1.00      +41.18%       0.70     
1.00    2.00    1.70    0.46
innodb  drop_index                            2.00      +11.11%       0.25     
2.00    3.00    2.25    0.43
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  drop_table_when_MANY_tables          14.00       +4.11%       0.60    
13.00   19.00   14.60    1.39
innodb  insert                              102.00       +3.82%       4.05    
97.00  119.00  106.05    5.89
innodb  insert_autocommit                     3.00       -3.45%      -0.10     
2.00    3.00    2.90    0.30
innodb  insert_commit                         1.00      +20.00%       0.25     
1.00    2.00    1.25    0.43
innodb  insert_duplicates                    14.00       +7.59%       1.15    
13.00   18.00   15.15    1.46
innodb  insert_key                          169.00       +7.09%      12.90   
148.00  229.00  181.90   20.49
innodb  insert_many_fields                    5.00      +18.03%       1.10     
5.00    8.00    6.10    0.77
innodb  insert_rollback                       2.00      -21.21%      -0.35     
1.00    2.00    1.65    0.48
innodb  insert_select_1_key                   3.00       +6.25%       0.20     
2.00    4.00    3.20    0.60
innodb  insert_select_2_keys                  4.00      +10.11%       0.45     
4.00    5.00    4.45    0.50
innodb  min_max                               6.00      +22.58%       1.75     
6.00    9.00    7.75    1.04
innodb  min_max_on_key                       23.00      -11.65%      -2.40    
18.00   24.00   20.60    1.96
innodb  multiple_value_insert                 3.00      -17.65%      -0.45     
2.00    3.00    2.55    0.50
innodb  once_prepared_select                 22.00       +6.18%       1.45    
20.00   26.00   23.45    1.66
innodb  order_by_big                         12.00      +13.36%       1.85    
12.00   17.00   13.85    1.39
innodb  order_by_big_key                     14.00       -7.28%      -0.95    
11.00   15.00   13.05    1.16
innodb  order_by_big_key2                    11.00       +9.09%       1.10    
10.00   14.00   12.10    1.26
innodb  order_by_big_key_desc                15.00      -11.11%      -1.50    
12.00   15.00   13.50    1.12
innodb  order_by_big_key_diff                11.00       +6.38%       0.75    
10.00   14.00   11.75    1.13
innodb  order_by_big_key_prefix              12.00       +4.38%       0.55    
11.00   14.00   12.55    0.86
innodb  order_by_key2_diff                    1.00      +25.93%       0.35     
1.00    2.00    1.35    0.48
innodb  order_by_key_prefix                   1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  order_by_range                        1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  outer_join                           15.00       +9.91%       1.65    
15.00   21.00   16.65    1.93
innodb  outer_join_found                     15.00       +8.81%       1.45    
15.00   21.00   16.45    1.96
innodb  outer_join_not_found                 13.00       +8.77%       1.25    
12.00   18.00   14.25    1.79
innodb  outer_join_on_key                    11.00       +5.58%       0.65    
10.00   15.00   11.65    1.31
innodb  prepared_select                      30.00       +0.83%       0.25    
27.00   34.00   30.25    2.17
innodb  select_1_row                          3.00      -11.11%      -0.30     
2.00    3.00    2.70    0.46
innodb  select_1_row_cache                    2.00      +20.00%       0.50     
2.00    3.00    2.50    0.50
innodb  select_2_rows                         3.00       -9.09%      -0.25     
2.00    3.00    2.75    0.43
innodb  select_big                           13.00       -8.79%      -1.05    
10.00   14.00   11.95    1.12
innodb  select_big_str                        1.00      +13.04%       0.15     
1.00    2.00    1.15    0.36
innodb  select_cache                         64.00       -7.38%      -4.40    
50.00   65.00   59.60    4.65
innodb  select_cache2                        66.00       -8.46%      -5.15    
50.00   68.00   60.85    5.52
innodb  select_column+column                  2.00      +24.53%       0.65     
2.00    3.00    2.65    0.48
innodb  select_diff_key                       1.00     -300.00%      -0.75     
0.00    1.00    0.25    0.43
innodb  select_distinct                       4.00       +4.76%       0.20     
4.00    5.00    4.20    0.40
innodb  select_group                         14.00      +11.39%       1.80    
14.00   18.00   15.80    1.40
innodb  select_group_when_MANY_tables         5.00       -7.53%      -0.35     
3.00    6.00    4.65    0.73
innodb  select_join                           0.00     +100.00%       0.50     
0.00    1.00    0.50    0.50
innodb  select_key                           51.00       +1.35%       0.70    
50.00   61.00   51.70    2.83
innodb  select_key2                          56.00       +2.61%       1.50    
55.00   68.00   57.50    3.56
innodb  select_key2_return_key               54.00       +4.17%       2.35    
53.00   65.00   56.35    3.65
innodb  select_key2_return_prim              54.00       +5.26%       3.00    
54.00   66.00   57.00    3.67
innodb  select_key_prefix                    55.00       +1.87%       1.05    
54.00   65.00   56.05    2.20
innodb  select_key_prefix_join                5.00       -9.89%      -0.45     
4.00    5.00    4.55    0.50
innodb  select_key_return_key                49.00       +3.07%       1.55    
48.00   58.00   50.55    2.56
innodb  select_many_fields                   17.00       -6.92%      -1.10    
14.00   18.00   15.90    1.14
innodb  select_range                         51.00       -7.82%      -3.70    
43.00   53.00   47.30    3.66
innodb  select_range_key2                     8.00       +1.84%       0.15     
7.00   10.00    8.15    0.79
innodb  select_range_prefix                   8.00       -8.84%      -0.65     
7.00    8.00    7.35    0.48
innodb  select_simple                         1.00      +35.48%       0.55     
1.00    2.00    1.55    0.50
innodb  select_simple_cache                   1.00      +31.03%       0.45     
1.00    2.00    1.45    0.50
innodb  select_simple_join                    1.00      -42.86%      -0.30     
0.00    1.00    0.70    0.46
innodb  TOTALS                             2860.00       +1.66%      48.40  
2759.00 3118.00 2908.40  106.34
innodb  update_autocommit                     4.00      -23.08%      -0.75     
3.00    4.00    3.25    0.43
innodb  update_big                           35.00       +4.11%       1.50    
34.00   39.00   36.50    1.28
innodb  update_commit                         2.00      -37.93%      -0.55     
1.00    2.00    1.45    0.50
innodb  update_of_key                        20.00      +12.28%       2.80    
19.00   30.00   22.80    2.87
innodb  update_of_key_big                    17.00      +10.29%       1.95    
16.00   26.00   18.95    2.31
innodb  update_of_primary_key_many_keys     730.00       +0.79%       5.85   
664.00  843.00  735.85   55.57
innodb  update_rollback                       2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  update_with_key                     109.00       -0.69%      -0.75   
100.00  113.00  108.25    3.05
innodb  update_with_key_prefix               37.00       -0.41%      -0.15    
33.00   38.00   36.85    1.19
innodb  wisc_benchmark                        2.00      +14.89%       0.35     
2.00    3.00    2.35    0.48

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      13.00       -6.80%      -0.83    
11.00   14.00   12.17    0.87
innodb  alter_table_drop                     15.00      -31.42%      -3.59    
10.00   14.00   11.41    1.07
innodb  connect                               2.00      -18.37%      -0.31     
1.00    2.00    1.69    0.46
innodb  connect+select_1_row                  3.00      -27.94%      -0.66     
2.00    3.00    2.34    0.48
innodb  connect+select_simple                 3.00      -52.63%      -1.03     
1.00    2.00    1.97    0.18
innodb  count                                13.00      +13.33%       2.00    
13.00   18.00   15.00    1.76
innodb  count_distinct                        7.00      -15.34%      -0.93     
5.00    8.00    6.07    0.83
innodb  count_distinct_2                     14.00      -15.34%      -1.86    
11.00   16.00   12.14    1.38
innodb  count_distinct_big                   21.00       +1.62%       0.34    
18.00   25.00   21.34    1.97
innodb  count_distinct_group                 14.00      -10.63%      -1.34    
11.00   14.00   12.66    0.84
innodb  count_distinct_group_on_key          11.00      -23.64%      -2.10     
8.00   11.00    8.90    1.12
innodb  count_distinct_group_on_key_parts    13.00      -10.56%      -1.24    
10.00   15.00   11.76    1.36
innodb  count_distinct_key_prefix             6.00      -27.01%      -1.28     
4.00    6.00    4.72    0.69
innodb  count_group_on_key_parts             10.00      -22.88%      -1.86     
7.00   10.00    8.14    0.78
innodb  count_on_key                         89.00      -15.22%     -11.76    
73.00   83.00   77.24    2.25
innodb  create+drop                          25.00      -28.09%      -5.48    
19.00   21.00   19.52    0.56
innodb  create_index                          3.00      -58.18%      -1.10     
1.00    3.00    1.90    0.48
innodb  create_key+drop                      26.00      -15.29%      -3.45    
21.00   23.00   22.55    0.56
innodb  create_MANY_tables                   21.00      -23.03%      -3.93    
14.00   20.00   17.07    1.70
innodb  create_table                          0.00     +100.00%       0.07     
0.00    1.00    0.07    0.25
innodb  delete_all_many_keys                227.00      +23.63%      70.24   
239.00  345.00  297.24   21.38
innodb  delete_autocommit                     3.00       -6.10%      -0.17     
2.00    3.00    2.83    0.38
innodb  delete_big                            1.00     -262.50%      -0.72     
0.00    1.00    0.28    0.45
innodb  delete_big_many_keys                227.00      +23.60%      70.14   
239.00  345.00  297.14   21.37
innodb  delete_commit                         1.00      +25.64%       0.34     
1.00    2.00    1.34    0.48
innodb  delete_key                            3.00      -22.54%      -0.55     
2.00    3.00    2.45    0.50
innodb  delete_range                          6.00      +13.86%       0.97     
6.00    8.00    6.97    0.56
innodb  delete_rollback                       1.00      +23.68%       0.31     
1.00    2.00    1.31    0.46
innodb  drop_index                            2.00       -1.75%      -0.03     
1.00    3.00    1.97    0.32
innodb  drop_table                            0.00         NULL       0.00     
0.00    0.00    0.00    0.00
innodb  drop_table_when_MANY_tables          14.00       -3.84%      -0.52    
12.00   15.00   13.48    0.62
innodb  insert                              102.00      -12.47%     -11.31    
88.00   93.00   90.69    1.37
innodb  insert_autocommit                     3.00      -16.00%      -0.41     
2.00    3.00    2.59    0.49
innodb  insert_commit                         1.00       +9.37%       0.10     
1.00    2.00    1.10    0.30
innodb  insert_duplicates                    14.00       -9.14%      -1.17    
12.00   14.00   12.83    0.53
innodb  insert_key                          169.00      +41.24%     118.62   
189.00  345.00  287.62   32.94
innodb  insert_many_fields                    5.00      -22.88%      -0.93     
3.00    5.00    4.07    0.36
innodb  insert_rollback                       2.00      -41.46%      -0.59     
1.00    2.00    1.41    0.49
innodb  insert_select_1_key                   3.00      +12.12%       0.41     
3.00    4.00    3.41    0.49
innodb  insert_select_2_keys                  4.00      +22.67%       1.17     
4.00    6.00    5.17    0.59
innodb  min_max                               6.00      +21.62%       1.66     
6.00    9.00    7.66    1.03
innodb  min_max_on_key                       23.00      -36.40%      -6.14    
14.00   20.00   16.86    1.28
innodb  multiple_value_insert                 3.00      +33.59%       1.52     
3.00    5.00    4.52    0.56
innodb  once_prepared_select                 22.00       -4.93%      -1.03    
20.00   22.00   20.97    0.61
innodb  order_by_big                         12.00      +15.12%       2.14    
12.00   15.00   14.14    0.94
innodb  order_by_big_key                     14.00      -12.78%      -1.59    
11.00   14.00   12.41    1.19
innodb  order_by_big_key2                    11.00       +4.20%       0.48    
10.00   13.00   11.48    0.97
innodb  order_by_big_key_desc                15.00      -16.31%      -2.10    
12.00   14.00   12.90    0.92
innodb  order_by_big_key_diff                11.00       +5.06%       0.59    
10.00   13.00   11.59    0.85
innodb  order_by_big_key_prefix              12.00       -0.29%      -0.03    
11.00   13.00   11.97    0.85
innodb  order_by_key2_diff                    1.00      +14.71%       0.17     
1.00    2.00    1.17    0.38
innodb  order_by_key_prefix                   1.00      -61.11%      -0.38     
0.00    1.00    0.62    0.49
innodb  order_by_range                        1.00      -38.10%      -0.28     
0.00    1.00    0.72    0.45
innodb  outer_join                           15.00      +13.52%       2.34    
15.00   21.00   17.34    2.06
innodb  outer_join_found                     15.00      +11.04%       1.86    
14.00   21.00   16.86    2.19
innodb  outer_join_not_found                 13.00      +13.33%       2.00    
13.00   18.00   15.00    1.49
innodb  outer_join_on_key                    11.00       +8.07%       0.97    
10.00   15.00   11.97    1.50
innodb  prepared_select                      30.00      -16.00%      -4.14    
22.00   29.00   25.86    2.10
innodb  select_1_row                          3.00      -22.54%      -0.55     
2.00    3.00    2.45    0.50
innodb  select_1_row_cache                    2.00       +3.33%       0.07     
2.00    3.00    2.07    0.25
innodb  select_2_rows                         3.00      -35.94%      -0.79     
2.00    3.00    2.21    0.41
innodb  select_big                           13.00      -11.87%      -1.38    
10.00   13.00   11.62    1.00
innodb  select_big_str                        1.00       +9.80%       0.11     
0.00    2.00    1.11    0.32
innodb  select_cache                         64.00      -11.14%      -6.41    
51.00   71.00   57.59    5.41
innodb  select_cache2                        66.00      -16.07%      -9.14    
51.00   68.00   56.86    4.88
innodb  select_column+column                  2.00      +24.68%       0.66     
2.00    3.00    2.66    0.48
innodb  select_diff_key                       1.00     -480.00%      -0.83     
0.00    1.00    0.17    0.38
innodb  select_distinct                       4.00       -1.75%      -0.07     
3.00    5.00    3.93    0.36
innodb  select_group                         14.00       +7.94%       1.21    
13.00   18.00   15.21    1.47
innodb  select_group_when_MANY_tables         5.00      -25.00%      -1.00     
3.00    5.00    4.00    0.37
innodb  select_join                           0.00     +100.00%       0.48     
0.00    1.00    0.48    0.50
innodb  select_key                           51.00      -14.56%      -6.48    
40.00   50.00   44.52    2.50
innodb  select_key2                          56.00      -13.65%      -6.72    
46.00   54.00   49.28    2.41
innodb  select_key2_return_key               54.00      -15.06%      -7.07    
42.00   51.00   46.93    2.32
innodb  select_key2_return_prim              54.00      -11.54%      -5.59    
43.00   55.00   48.41    2.92
innodb  select_key_prefix                    55.00       -8.28%      -4.21    
45.00   57.00   50.79    3.46
innodb  select_key_prefix_join                5.00      -19.83%      -0.83     
4.00    5.00    4.17    0.38
innodb  select_key_return_key                49.00      -12.42%      -5.41    
39.00   49.00   43.59    2.65
innodb  select_many_fields                   17.00       -3.35%      -0.55    
15.00   17.00   16.45    0.62
innodb  select_range                         51.00       -4.38%      -2.14    
47.00   57.00   48.86    1.66
innodb  select_range_key2                     8.00      -10.48%      -0.76     
6.00    8.00    7.24    0.57
innodb  select_range_prefix                   8.00      -14.29%      -1.00     
6.00    8.00    7.00    0.64
innodb  select_simple                         1.00      +30.95%       0.45     
1.00    2.00    1.45    0.50
innodb  select_simple_cache                   1.00      +12.12%       0.14     
1.00    2.00    1.14    0.34
innodb  select_simple_join                    1.00      -38.10%      -0.28     
0.00    1.00    0.72    0.45
innodb  TOTALS                             2860.00     -186.00%   -1860.01   
999.99  999.99  999.99    0.00
innodb  update_autocommit                     4.00      -43.21%      -1.21     
2.00    3.00    2.79    0.41
innodb  update_big                           35.00       +2.87%       1.03    
31.00   40.00   36.03    2.48
innodb  update_commit                         2.00      -48.72%      -0.66     
1.00    2.00    1.34    0.48
innodb  update_of_key                        20.00       -3.76%      -0.72    
19.00   20.00   19.28    0.45
innodb  update_of_key_big                    17.00       +7.16%       1.31    
16.00   20.00   18.31    1.18
innodb  update_of_primary_key_many_keys     730.00       +4.37%      33.33   
661.00  799.00  763.33   39.70
innodb  update_rollback                       2.00      -41.46%      -0.59     
1.00    2.00    1.41    0.49
innodb  update_with_key                     109.00      -18.79%     -17.24    
90.00   93.00   91.76    0.97
innodb  update_with_key_prefix               37.00       -4.99%      -1.76    
34.00   36.00   35.24    0.57
innodb  wisc_benchmark                        2.00      +14.71%       0.34     
2.00    3.00    2.34    0.48

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

  1842.1.3: lbieber 2010-10-12 [merge] Merge Monty - add valgrind stripping 
program to the tree, suppress size_t signature change
    1840.1.3: Monty Taylor 2010-10-12 Added support for valgrind suppressions.
    1840.1.2: Monty Taylor 2010-10-12 Added valgrind stripping program to the 
tree.
    1840.1.1: Monty Taylor 2010-10-12 Added suppression for a size_t signature 
change.
  1842.1.2: lbieber 2010-10-12 [merge] Merge Travis - File: /drizzled/xid.h. 
Changed struct name of 'st_drizzle_xid' to 'drizzle_xid', changed it to a C++ 
class and added constructor initialization list
    1836.2.2: tdavies 2010-10-12 File: /drizzled/xid.h. Changed struct name of 
'st_drizzle_xid' to 'drizzle_xid', changed it to a C++ class and added 
constructor initialization list 
    1836.2.1: tdavies 2010-10-12 File: /drizzled/xid.h. Changed struct name of 
'st_drizzle_xid' to 'drizzle_xid', changed it to a C++ class and added 
constructor initialization list 
  1842.1.1: lbieber 2010-10-12 [merge] Merge Brian - adding more documentation
    1838.2.1: Brian Aker 2010-10-11 More docs.

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help   : https://help.launchpad.net/ListHelp

Reply via email to