=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   879
RUN DATE: 2011-02-07T20:49:23.424092
SERVER:   drizzled
VERSION:  staging
REVISION: 2151
COMMENT:  2151: Lee Bieber 2011-02-07 [merge] Merge Patrick - 714911: dbqp 
needs valgrind to work

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00       -1.85%      -0.60    
31.00   33.00   32.40    0.80
innodb  alter_table_drop                     25.00       -0.81%      -0.20    
24.00   25.00   24.80    0.40
innodb  connect                               3.00      -36.36%      -0.80     
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                 2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  count                                14.00       +9.09%       1.40    
14.00   18.00   15.40    1.74
innodb  count_distinct                        6.00       +3.23%       0.20     
6.00    7.00    6.20    0.40
innodb  count_distinct_2                     16.00      -12.68%      -1.80    
13.00   16.00   14.20    0.98
innodb  count_distinct_big                   21.00       +6.25%       1.40    
20.00   25.00   22.40    2.15
innodb  count_distinct_group                 15.00       -7.14%      -1.00    
13.00   15.00   14.00    0.63
innodb  count_distinct_group_on_key          10.00       -0.00%       0.00     
9.00   11.00   10.00    0.89
innodb  count_distinct_group_on_key_parts    14.00       -6.06%      -0.80    
11.00   14.00   13.20    1.17
innodb  count_distinct_key_prefix             5.00       +3.85%       0.20     
5.00    6.00    5.20    0.40
innodb  count_group_on_key_parts             11.00       +1.79%       0.20    
11.00   12.00   11.20    0.40
innodb  count_on_key                         94.00       +1.05%       1.00    
93.00   98.00   95.00    2.10
innodb  create+drop                          33.00       -5.10%      -1.60    
30.00   33.00   31.40    1.02
innodb  create_index                          4.00      -25.00%      -0.80     
3.00    4.00    3.20    0.40
innodb  create_key+drop                      28.00       +2.10%       0.60    
28.00   30.00   28.60    0.80
innodb  create_MANY_tables                   22.00       -3.77%      -0.80    
20.00   22.00   21.20    0.75
innodb  delete_all_many_keys                706.00       -6.58%     -43.60   
637.00  706.00  662.40   25.06
innodb  delete_autocommit                     3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  delete_big                            0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  delete_big_many_keys                704.00       -6.44%     -42.60   
636.00  704.00  661.40   24.70
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       -7.14%      -0.20     
2.00    4.00    2.80    0.75
innodb  delete_range                          9.00       -7.14%      -0.60     
8.00    9.00    8.40    0.49
innodb  delete_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  drop_index                            3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  drop_table                            0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  drop_table_when_MANY_tables          16.00       +2.44%       0.40    
16.00   17.00   16.40    0.49
innodb  insert                              113.00       +1.22%       1.40   
113.00  116.00  114.40    1.36
innodb  insert_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  insert_commit                         2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  insert_duplicates                    19.00       -0.00%       0.00    
19.00   19.00   19.00    0.00
innodb  insert_key                          304.00       -6.59%     -18.80   
277.00  304.00  285.20   10.23
innodb  insert_many_fields                    6.00      -11.11%      -0.60     
5.00    6.00    5.40    0.49
innodb  insert_rollback                       2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
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       +3.23%       0.20     
6.00    7.00    6.20    0.40
innodb  min_max                               7.00       +5.41%       0.40     
6.00    9.00    7.40    1.02
innodb  min_max_on_key                       25.00       -0.00%       0.00    
24.00   26.00   25.00    0.63
innodb  multiple_value_insert                 8.00      -21.21%      -1.40     
6.00    8.00    6.60    0.80
innodb  once_prepared_select                 29.00       -0.00%       0.00    
29.00   29.00   29.00    0.00
innodb  order_by_big                         15.00       -4.17%      -0.60    
13.00   15.00   14.40    0.80
innodb  order_by_big_key                     14.00       +4.11%       0.60    
14.00   15.00   14.60    0.49
innodb  order_by_big_key2                    13.00       -0.00%       0.00    
12.00   14.00   13.00    0.63
innodb  order_by_big_key_desc                15.00       -2.74%      -0.40    
14.00   15.00   14.60    0.49
innodb  order_by_big_key_diff                14.00       -9.38%      -1.20    
12.00   14.00   12.80    0.75
innodb  order_by_big_key_prefix              15.00      -13.64%      -1.80    
12.00   15.00   13.20    1.17
innodb  order_by_key2_diff                    1.00      +28.57%       0.40     
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      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  outer_join                           18.00      +12.62%       2.60    
17.00   23.00   20.60    2.58
innodb  outer_join_found                     17.00      +15.84%       3.20    
16.00   24.00   20.20    3.12
innodb  outer_join_not_found                 15.00      +14.77%       2.60    
15.00   21.00   17.60    2.33
innodb  outer_join_on_key                    13.00       +8.45%       1.20    
11.00   16.00   14.20    1.94
innodb  prepared_select                      37.00       +1.07%       0.40    
37.00   38.00   37.40    0.49
innodb  select_1_row                          4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_1_row_cache                    3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  select_2_rows                         4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_big                           13.00       +2.99%       0.40    
12.00   14.00   13.40    0.80
innodb  select_big_str                        1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  select_cache                         58.00       +7.35%       4.60    
58.00   66.00   62.60    2.65
innodb  select_cache2                        60.00       +3.85%       2.40    
60.00   65.00   62.40    1.62
innodb  select_column+column                  4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_diff_key                       1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  select_distinct                       4.00       +4.76%       0.20     
4.00    5.00    4.20    0.40
innodb  select_group                         16.00       +4.76%       0.80    
15.00   19.00   16.80    1.83
innodb  select_group_when_MANY_tables        12.00       -5.26%      -0.60    
11.00   12.00   11.40    0.49
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           63.00       +0.94%       0.60    
63.00   65.00   63.60    0.80
innodb  select_key2                          70.00       +1.69%       1.20    
70.00   72.00   71.20    0.75
innodb  select_key2_return_key               67.00       +2.05%       1.40    
67.00   70.00   68.40    1.02
innodb  select_key2_return_prim              68.00       +2.02%       1.40    
68.00   71.00   69.40    1.02
innodb  select_key_prefix                    70.00       +0.85%       0.60    
70.00   72.00   70.60    0.80
innodb  select_key_prefix_join                5.00       +7.41%       0.40     
5.00    6.00    5.40    0.49
innodb  select_key_return_key                62.00       +1.27%       0.80    
62.00   65.00   62.80    1.17
innodb  select_many_fields                   13.00       -0.00%       0.00    
13.00   13.00   13.00    0.00
innodb  select_range                         40.00       +2.91%       1.20    
39.00   44.00   41.20    1.72
innodb  select_range_key2                    10.00       -2.04%      -0.20     
9.00   11.00    9.80    0.75
innodb  select_range_prefix                   8.00       +9.09%       0.80     
8.00   10.00    8.80    0.75
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      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  update_autocommit                     4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  update_big                           60.00       -0.00%       0.00    
58.00   62.00   60.00    1.26
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        21.00       +7.89%       1.80    
21.00   25.00   22.80    1.60
innodb  update_of_key_big                    38.00       +5.47%       2.20    
38.00   43.00   40.20    2.04
innodb  update_of_primary_key_many_keys    1482.00       -8.44%    -115.40  
1307.00 1482.00 1366.60   64.59
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     121.00       +0.66%       0.80   
119.00  126.00  121.80    2.32
innodb  update_with_key_prefix               45.00       +0.44%       0.20    
43.00   49.00   45.20    2.04
innodb  wisc_benchmark                        3.00      -25.00%      -0.60     
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                      33.00       -2.01%      -0.65    
26.00   34.00   32.35    1.71
innodb  alter_table_drop                     25.00       -4.60%      -1.10    
23.00   25.00   23.90    0.77
innodb  connect                               3.00      -33.33%      -0.75     
2.00    3.00    2.25    0.43
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  count                                14.00      +13.85%       2.25    
14.00   18.00   16.25    1.61
innodb  count_distinct                        6.00      +11.76%       0.80     
5.00    8.00    6.80    0.87
innodb  count_distinct_2                     16.00      -13.48%      -1.90    
12.00   16.00   14.10    1.09
innodb  count_distinct_big                   21.00       +9.87%       2.30    
20.00   25.00   23.30    1.79
innodb  count_distinct_group                 15.00       -4.90%      -0.70    
11.00   16.00   14.30    1.14
innodb  count_distinct_group_on_key          10.00       +2.44%       0.25     
9.00   12.00   10.25    0.99
innodb  count_distinct_group_on_key_parts    14.00       -6.87%      -0.90    
10.00   14.00   13.10    1.30
innodb  count_distinct_key_prefix             5.00       +4.76%       0.25     
5.00    6.00    5.25    0.43
innodb  count_group_on_key_parts             11.00       +2.65%       0.30    
10.00   12.00   11.30    0.56
innodb  count_on_key                         94.00       +0.27%       0.25    
92.00   98.00   94.25    1.79
innodb  create+drop                          33.00       -4.60%      -1.45    
30.00   33.00   31.55    0.92
innodb  create_index                          4.00      -19.40%      -0.65     
3.00    4.00    3.35    0.48
innodb  create_key+drop                      28.00       +1.06%       0.30    
27.00   30.00   28.30    0.71
innodb  create_MANY_tables                   22.00       -8.11%      -1.65    
19.00   22.00   20.35    0.96
innodb  create_table                          0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  delete_all_many_keys                706.00       -8.57%     -55.75   
583.00  715.00  650.25   29.86
innodb  delete_autocommit                     3.00      +20.00%       0.75     
3.00    4.00    3.75    0.43
innodb  delete_big                            0.00     +100.00%       0.50     
0.00    1.00    0.50    0.50
innodb  delete_big_many_keys                704.00       -8.42%     -54.65   
582.00  714.00  649.35   29.75
innodb  delete_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  delete_key                            3.00       -7.14%      -0.20     
2.00    4.00    2.80    0.60
innodb  delete_range                          9.00       -6.51%      -0.55     
7.00   10.00    8.45    0.67
innodb  delete_rollback                       2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  drop_index                            3.00       +3.23%       0.10     
2.00    4.00    3.10    0.44
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  drop_table_when_MANY_tables          16.00       +1.54%       0.25    
15.00   17.00   16.25    0.54
innodb  insert                              113.00       +1.05%       1.20   
112.00  117.00  114.20    1.36
innodb  insert_autocommit                     3.00       +7.69%       0.25     
3.00    4.00    3.25    0.43
innodb  insert_commit                         2.00      -14.29%      -0.25     
1.00    2.00    1.75    0.43
innodb  insert_duplicates                    19.00       +0.52%       0.10    
19.00   20.00   19.10    0.30
innodb  insert_key                          304.00       -8.44%     -23.65   
270.00  304.00  280.35    9.19
innodb  insert_many_fields                    6.00       -6.19%      -0.35     
5.00    7.00    5.65    0.57
innodb  insert_rollback                       2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  insert_select_1_key                   4.00       -2.56%      -0.10     
3.00    5.00    3.90    0.44
innodb  insert_select_2_keys                  6.00       +3.23%       0.20     
5.00    7.00    6.20    0.51
innodb  min_max                               7.00      +10.26%       0.80     
6.00   10.00    7.80    1.36
innodb  min_max_on_key                       25.00       -1.63%      -0.40    
23.00   26.00   24.60    0.66
innodb  multiple_value_insert                 8.00      -21.21%      -1.40     
6.00    8.00    6.60    0.66
innodb  once_prepared_select                 29.00       -0.35%      -0.10    
28.00   30.00   28.90    0.44
innodb  order_by_big                         15.00       -2.74%      -0.40    
13.00   16.00   14.60    0.97
innodb  order_by_big_key                     14.00       +2.44%       0.35    
13.00   16.00   14.35    0.85
innodb  order_by_big_key2                    13.00       +1.89%       0.25    
12.00   15.00   13.25    0.77
innodb  order_by_big_key_desc                15.00       +3.23%       0.50    
14.00   17.00   15.50    0.92
innodb  order_by_big_key_diff                14.00       -7.69%      -1.00    
12.00   14.00   13.00    0.71
innodb  order_by_big_key_prefix              15.00      -11.52%      -1.55    
12.00   15.00   13.45    0.74
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      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  order_by_range                        1.00       -5.26%      -0.05     
0.00    1.00    0.95    0.22
innodb  outer_join                           18.00      +15.69%       3.35    
17.00   25.00   21.35    2.39
innodb  outer_join_found                     17.00      +17.87%       3.70    
16.00   24.00   20.70    2.55
innodb  outer_join_not_found                 15.00      +19.57%       3.65    
15.00   22.00   18.65    2.39
innodb  outer_join_on_key                    13.00       +9.41%       1.35    
11.00   17.00   14.35    1.96
innodb  prepared_select                      37.00       +0.54%       0.20    
36.00   39.00   37.20    0.68
innodb  select_1_row                          4.00       -8.11%      -0.30     
3.00    4.00    3.70    0.46
innodb  select_1_row_cache                    3.00       +9.09%       0.30     
3.00    4.00    3.30    0.46
innodb  select_2_rows                         4.00       -6.67%      -0.25     
3.00    4.00    3.75    0.43
innodb  select_big                           13.00       +3.70%       0.50    
12.00   15.00   13.50    0.92
innodb  select_big_str                        1.00      +25.93%       0.35     
1.00    2.00    1.35    0.48
innodb  select_cache                         58.00       +7.27%       4.55    
56.00   67.00   62.55    2.73
innodb  select_cache2                        60.00       +3.69%       2.30    
57.00   68.00   62.30    2.93
innodb  select_column+column                  4.00       -6.67%      -0.25     
3.00    4.00    3.75    0.43
innodb  select_diff_key                       1.00     -233.33%      -0.70     
0.00    1.00    0.30    0.46
innodb  select_distinct                       4.00       +6.98%       0.30     
4.00    5.00    4.30    0.46
innodb  select_group                         16.00       +8.05%       1.40    
15.00   20.00   17.40    1.43
innodb  select_group_when_MANY_tables        12.00       -2.13%      -0.25    
11.00   14.00   11.75    0.77
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           63.00       +0.40%       0.25    
62.00   65.00   63.25    0.77
innodb  select_key2                          70.00       +0.85%       0.60    
69.00   73.00   70.60    1.02
innodb  select_key2_return_key               67.00       +1.18%       0.80    
67.00   70.00   67.80    0.81
innodb  select_key2_return_prim              68.00       +1.38%       0.95    
67.00   71.00   68.95    0.97
innodb  select_key_prefix                    70.00       +0.21%       0.15    
69.00   72.00   70.15    1.01
innodb  select_key_prefix_join                5.00       +4.76%       0.25     
5.00    6.00    5.25    0.43
innodb  select_key_return_key                62.00       +0.56%       0.35    
61.00   65.00   62.35    0.91
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         40.00       +7.08%       3.05    
39.00   46.00   43.05    2.06
innodb  select_range_key2                    10.00       -3.63%      -0.35     
9.00   11.00    9.65    0.57
innodb  select_range_prefix                   8.00      +12.09%       1.10     
8.00   10.00    9.10    0.62
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      -42.86%      -0.30     
0.00    1.00    0.70    0.46
innodb  update_autocommit                     4.00       -9.59%      -0.35     
3.00    4.00    3.65    0.48
innodb  update_big                           60.00       -1.95%      -1.15    
56.00   62.00   58.85    1.77
innodb  update_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  update_of_key                        21.00       +5.41%       1.20    
21.00   25.00   22.20    1.21
innodb  update_of_key_big                    38.00       -1.60%      -0.60    
33.00   43.00   37.40    2.78
innodb  update_of_primary_key_many_keys    1482.00      -10.03%    -135.10  
1284.00 1482.00 1346.90   51.15
innodb  update_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  update_with_key                     121.00       +0.90%       1.10   
118.00  127.00  122.10    2.66
innodb  update_with_key_prefix               45.00       -3.21%      -1.40    
40.00   49.00   43.60    2.15
innodb  wisc_benchmark                        3.00      -20.00%      -0.50     
2.00    3.00    2.50    0.50

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00      -62.32%     -12.67    
11.00   61.00   20.33    9.96
innodb  alter_table_drop                     25.00      -38.50%      -6.95    
10.00   57.00   18.05    7.03
innodb  connect                               3.00      -44.39%      -0.92     
1.00    3.00    2.08    0.42
innodb  connect+select_1_row                  3.00      -11.61%      -0.31     
2.00    5.00    2.69    0.48
innodb  connect+select_simple                 2.00      +13.95%       0.32     
1.00    3.00    2.32    0.48
innodb  count                                14.00      +11.19%       1.76    
12.00  193.00   15.76    9.08
innodb  count_distinct                        6.00       +8.54%       0.56     
5.00   50.00    6.56    2.34
innodb  count_distinct_2                     16.00      -21.71%      -2.85    
11.00   63.00   13.15    3.02
innodb  count_distinct_big                   21.00       +4.08%       0.89     
5.00   67.00   21.89    3.07
innodb  count_distinct_group                 15.00      -14.76%      -1.93    
10.00   68.00   13.07    3.16
innodb  count_distinct_group_on_key          10.00       -5.77%      -0.55     
7.00   69.00    9.45    3.08
innodb  count_distinct_group_on_key_parts    14.00      -14.20%      -1.74     
9.00   72.00   12.26    3.23
innodb  count_distinct_key_prefix             5.00       +2.27%       0.12     
3.00   52.00    5.12    2.45
innodb  count_group_on_key_parts             11.00      -10.90%      -1.08     
7.00   72.00    9.92    3.23
innodb  count_on_key                         94.00       -9.96%      -8.51    
68.00  107.00   85.49    7.29
innodb  create+drop                          33.00       -1.78%      -0.58    
18.00   75.00   32.42   12.25
innodb  create_index                          4.00      -39.47%      -1.13     
1.00    8.00    2.87    1.17
innodb  create_key+drop                      28.00       +0.17%       0.05    
21.00   50.00   28.05    5.01
innodb  create_MANY_tables                   22.00      +36.94%      12.89    
14.00  121.00   34.89   17.28
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.36
innodb  delete_all_many_keys                706.00      -56.26%    -254.19   
212.00 1888.00  451.81  372.88
innodb  delete_autocommit                     3.00      +12.59%       0.43     
2.00   14.00    3.43    0.76
innodb  delete_big                            0.00     +100.00%       0.28     
0.00    3.00    0.28    0.46
innodb  delete_big_many_keys                704.00      -53.57%    -245.58   
212.00 2293.00  458.42  387.87
innodb  delete_commit                         2.00      -34.11%      -0.51     
1.00    5.00    1.49    0.53
innodb  delete_key                            3.00       +2.45%       0.08     
2.00   35.00    3.08    1.54
innodb  delete_range                          9.00       -8.74%      -0.72     
5.00   23.00    8.28    3.33
innodb  delete_rollback                       2.00      -16.71%      -0.29     
1.00   12.00    1.71    0.93
innodb  drop_index                            3.00       -1.97%      -0.06     
1.00    9.00    2.94    1.35
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    2.00    0.05    0.23
innodb  drop_table_when_MANY_tables          16.00      +18.76%       3.70    
11.00   90.00   19.70    7.73
innodb  insert                              113.00       -6.35%      -6.75     
3.00  343.00  106.25   14.92
innodb  insert_autocommit                     3.00       -0.50%      -0.01     
2.00   99.00    2.99    3.41
innodb  insert_commit                         2.00      -48.35%      -0.65     
1.00    3.00    1.35    0.49
innodb  insert_duplicates                    19.00      -24.74%      -3.77    
11.00   21.00   15.23    2.56
innodb  insert_key                          304.00       +0.20%       0.62   
142.00  700.00  304.62  110.50
innodb  insert_many_fields                    6.00       -7.30%      -0.41     
3.00   17.00    5.59    1.82
innodb  insert_rollback                       2.00      -21.62%      -0.36     
1.00    3.00    1.64    0.54
innodb  insert_select_1_key                   4.00       -5.96%      -0.22     
2.00   10.00    3.78    0.90
innodb  insert_select_2_keys                  6.00       +1.04%       0.06     
4.00   16.00    6.06    2.15
innodb  min_max                               7.00      +10.52%       0.82     
6.00  110.00    7.82    4.68
innodb  min_max_on_key                       25.00      -23.22%      -4.71    
14.00   37.00   20.29    3.00
innodb  multiple_value_insert                 8.00      -48.44%      -2.61     
2.00   50.00    5.39    4.40
innodb  once_prepared_select                 29.00      -21.40%      -5.11    
18.00   32.00   23.89    3.44
innodb  order_by_big                         15.00       -4.89%      -0.70    
12.00   31.00   14.30    1.55
innodb  order_by_big_key                     14.00       -6.08%      -0.80    
11.00   32.00   13.20    1.63
innodb  order_by_big_key2                    13.00       -7.09%      -0.86    
10.00   33.00   12.14    1.56
innodb  order_by_big_key_desc                15.00      -11.99%      -1.61    
11.00   32.00   13.39    1.66
innodb  order_by_big_key_diff                14.00      -15.00%      -1.83    
10.00   31.00   12.17    1.52
innodb  order_by_big_key_prefix              15.00      -21.54%      -2.66    
10.00   32.00   12.34    1.58
innodb  order_by_key2_diff                    1.00      +28.28%       0.39     
1.00    3.00    1.39    0.49
innodb  order_by_key_prefix                   1.00      -27.20%      -0.21     
0.00    2.00    0.79    0.42
innodb  order_by_range                        1.00      -21.29%      -0.18     
0.00    2.00    0.82    0.39
innodb  outer_join                           18.00       +6.11%       1.17    
15.00   61.00   19.17    3.71
innodb  outer_join_found                     17.00       +8.65%       1.61    
14.00   58.00   18.61    3.57
innodb  outer_join_not_found                 15.00       +7.96%       1.30    
12.00   46.00   16.30    3.15
innodb  outer_join_on_key                    13.00       -1.61%      -0.21    
10.00   59.00   12.79    2.78
innodb  prepared_select                      37.00      -19.59%      -6.06    
22.00   40.00   30.94    4.38
innodb  select_1_row                          4.00      -42.28%      -1.19     
2.00    4.00    2.81    0.68
innodb  select_1_row_cache                    3.00      -14.28%      -0.37     
2.00    4.00    2.63    0.66
innodb  select_2_rows                         4.00      -41.35%      -1.17     
2.00    4.00    2.83    0.68
innodb  select_big                           13.00       -7.34%      -0.89     
0.00   31.00   12.11    1.56
innodb  select_big_str                        1.00      +13.01%       0.15     
0.00    2.00    1.15    0.36
innodb  select_cache                         58.00       +2.34%       1.39    
49.00   77.00   59.39    5.65
innodb  select_cache2                        60.00       -0.31%      -0.19    
49.00   75.00   59.81    6.40
innodb  select_column+column                  4.00      -39.23%      -1.13     
2.00    4.00    2.87    0.70
innodb  select_diff_key                       1.00     -364.94%      -0.78     
0.00    1.00    0.22    0.41
innodb  select_distinct                       4.00       +5.15%       0.22     
3.00    8.00    4.22    0.54
innodb  select_group                         16.00       +1.35%       0.22     
4.00  136.00   16.22    5.59
innodb  select_group_when_MANY_tables        12.00      -29.17%      -2.71     
3.00   49.00    9.29    9.72
innodb  select_join                           1.00      -73.66%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           63.00      -21.07%     -10.96    
40.00   66.00   52.04    7.11
innodb  select_key2                          70.00      -19.27%     -11.31    
45.00   75.00   58.69    8.00
innodb  select_key2_return_key               67.00      -19.61%     -10.99    
42.00   70.00   56.01    7.76
innodb  select_key2_return_prim              68.00      -19.78%     -11.23    
42.00   72.00   56.77    7.92
innodb  select_key_prefix                    70.00      -20.85%     -12.08    
44.00   75.00   57.92    7.98
innodb  select_key_prefix_join                5.00       -6.51%      -0.31     
3.00   10.00    4.69    0.66
innodb  select_key_return_key                62.00      -21.43%     -10.94    
38.00   65.00   51.06    7.11
innodb  select_many_fields                   13.00      +13.65%       2.05    
11.00   19.00   15.05    1.79
innodb  select_range                         40.00      +15.57%       7.38    
39.00   76.00   47.38    3.86
innodb  select_range_key2                    10.00      -22.26%      -1.82     
6.00   11.00    8.18    1.02
innodb  select_range_prefix                   8.00       -3.30%      -0.26     
5.00   10.00    7.74    1.07
innodb  select_simple                         2.00      -23.35%      -0.38     
1.00    3.00    1.62    0.51
innodb  select_simple_cache                   2.00      -31.12%      -0.47     
1.00    3.00    1.53    0.52
innodb  select_simple_join                    1.00      -54.18%      -0.35     
0.00    3.00    0.65    0.49
innodb  update_autocommit                     4.00      -20.90%      -0.69     
2.00   16.00    3.31    1.03
innodb  update_big                           60.00      -18.91%      -9.54    
31.00  195.00   50.46   25.14
innodb  update_commit                         2.00      -30.12%      -0.46     
1.00   10.00    1.54    0.74
innodb  update_of_key                        21.00      +13.77%       3.35    
18.00  100.00   24.35    6.34
innodb  update_of_key_big                    38.00      -41.15%     -11.08    
15.00   75.00   26.92   11.06
innodb  update_of_primary_key_many_keys    1482.00      -20.36%    -250.74   
647.00 6065.00 1231.26  997.95
innodb  update_rollback                       2.00      -14.98%      -0.26     
1.00   31.00    1.74    1.96
innodb  update_with_key                     121.00      -10.92%     -11.91    
90.00  598.00  109.09   21.20
innodb  update_with_key_prefix               45.00      -14.46%      -5.68    
33.00  202.00   39.32    6.89
innodb  wisc_benchmark                        3.00      -21.44%      -0.53     
2.00    5.00    2.47    0.53

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

  2148.1.6: patrick crews 2011-02-07 Last bit of work to get valgrind working

_______________________________________________
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