=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   646
RUN DATE: 2010-11-09T15:08:21.993462
SERVER:   drizzled
VERSION:  staging
REVISION: 1920
COMMENT:  1920: patrick crews 2010-11-09 [merge] Rollup merge of Andrew's 
patches

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      46.00      -29.21%     -10.40    
19.00   46.00   35.60    8.91
innodb  alter_table_drop                     32.00       -9.59%      -2.80    
14.00   37.00   29.20    7.93
innodb  connect                               2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  connect+select_1_row                  3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  connect+select_simple                 3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  count                                13.00       +4.41%       0.60    
13.00   15.00   13.60    0.80
innodb  count_distinct                        8.00      -21.21%      -1.40     
6.00    8.00    6.60    0.80
innodb  count_distinct_2                     14.00       -7.69%      -1.00    
12.00   15.00   13.00    1.26
innodb  count_distinct_big                   21.00       +2.78%       0.60    
20.00   24.00   21.60    1.62
innodb  count_distinct_group                 13.00       -3.17%      -0.40    
11.00   14.00   12.60    1.36
innodb  count_distinct_group_on_key           8.00      +13.04%       1.20     
8.00   10.00    9.20    0.75
innodb  count_distinct_group_on_key_parts    10.00      +13.79%       1.60    
10.00   14.00   11.60    1.36
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       -4.17%      -0.40     
9.00   10.00    9.60    0.49
innodb  count_on_key                         83.00       +0.24%       0.20    
81.00   86.00   83.20    1.72
innodb  create+drop                          56.00       +4.76%       2.80    
36.00   76.00   58.80   13.17
innodb  create_index                          5.00      -13.64%      -0.60     
2.00    7.00    4.40    1.62
innodb  create_key+drop                      43.00      -12.57%      -4.80    
28.00   43.00   38.20    5.71
innodb  create_MANY_tables                   72.00       +4.51%       3.40    
51.00   93.00   75.40   14.09
innodb  delete_all_many_keys               1588.00      -13.30%    -186.40   
299.00 1766.00 1401.60  554.35
innodb  delete_autocommit                     5.00      -19.05%      -0.80     
3.00    6.00    4.20    1.17
innodb  delete_big                            0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_big_many_keys               1588.00      -13.30%    -186.40   
299.00 1766.00 1401.60  554.35
innodb  delete_commit                         1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  delete_key                            5.00       -0.00%       0.00     
3.00    6.00    5.00    1.10
innodb  delete_range                          9.00       -9.76%      -0.80     
6.00   10.00    8.20    1.33
innodb  delete_rollback                       1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  drop_index                            3.00      +42.31%       2.20     
3.00    7.00    5.20    1.33
innodb  drop_table_when_MANY_tables          23.00       +6.50%       1.60    
19.00   29.00   24.60    3.88
innodb  insert                              132.00       -2.17%      -2.80   
105.00  140.00  129.20   12.48
innodb  insert_autocommit                     3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  insert_commit                         1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  insert_duplicates                    15.00       +2.60%       0.40    
14.00   16.00   15.40    0.80
innodb  insert_key                          636.00       +4.90%      32.80   
276.00  819.00  668.80  207.79
innodb  insert_many_fields                    9.00       +4.26%       0.40     
8.00   11.00    9.40    1.02
innodb  insert_rollback                       2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  insert_select_1_key                   5.00      -13.64%      -0.60     
3.00    6.00    4.40    1.20
innodb  insert_select_2_keys                  9.00      -15.38%      -1.20     
5.00    9.00    7.80    1.47
innodb  min_max                               7.00       -6.06%      -0.40     
6.00    7.00    6.60    0.49
innodb  min_max_on_key                       19.00       -1.06%      -0.20    
17.00   20.00   18.80    0.98
innodb  multiple_value_insert                19.00      -55.74%      -6.80     
3.00   19.00   12.20    5.84
innodb  once_prepared_select                 24.00       -0.84%      -0.20    
23.00   24.00   23.80    0.40
innodb  order_by_big                         13.00      +12.16%       1.80    
13.00   16.00   14.80    0.98
innodb  order_by_big_key                     12.00       +4.76%       0.60    
11.00   14.00   12.60    1.20
innodb  order_by_big_key2                    10.00      +18.03%       2.20    
10.00   13.00   12.20    1.17
innodb  order_by_big_key_desc                12.00       +7.69%       1.00    
12.00   14.00   13.00    0.89
innodb  order_by_big_key_diff                11.00       +9.84%       1.20    
11.00   13.00   12.20    0.75
innodb  order_by_big_key_prefix              12.00       -0.00%       0.00    
11.00   13.00   12.00    0.89
innodb  order_by_key2_diff                    2.00      -25.00%      -0.40     
1.00    2.00    1.60    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                        0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  outer_join                           17.00      +15.00%       3.00    
17.00   25.00   20.00    2.97
innodb  outer_join_found                     16.00      +17.53%       3.40    
16.00   23.00   19.40    2.87
innodb  outer_join_not_found                 13.00      +18.75%       3.00    
13.00   19.00   16.00    2.28
innodb  outer_join_on_key                    11.00      +15.38%       2.00    
11.00   17.00   13.00    2.19
innodb  prepared_select                      32.00       -0.63%      -0.20    
31.00   33.00   31.80    0.75
innodb  select_1_row                          3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  select_1_row_cache                    2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  select_2_rows                         3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  select_big                           10.00       +7.41%       0.80    
10.00   13.00   10.80    1.17
innodb  select_big_str                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  select_cache                         64.00       -6.67%      -4.00    
52.00   64.00   60.00    5.06
innodb  select_cache2                        65.00       -8.33%      -5.00    
53.00   65.00   60.00    4.20
innodb  select_column+column                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  select_distinct                       4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_group                         15.00       +7.41%       1.20    
15.00   18.00   16.20    1.17
innodb  select_group_when_MANY_tables         5.00      +10.71%       0.60     
5.00    7.00    5.60    0.80
innodb  select_join                           0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  select_key                           48.00       +4.00%       2.00    
48.00   52.00   50.00    1.41
innodb  select_key2                          62.00       +0.64%       0.40    
61.00   64.00   62.40    1.02
innodb  select_key2_return_key               60.00       -3.09%      -1.80    
56.00   60.00   58.20    1.60
innodb  select_key2_return_prim              61.00       -0.99%      -0.60    
59.00   61.00   60.40    0.80
innodb  select_key_prefix                    63.00       -3.96%      -2.40    
59.00   63.00   60.60    1.36
innodb  select_key_prefix_join                5.00       -0.00%       0.00     
5.00    5.00    5.00    0.00
innodb  select_key_return_key                49.00       -4.26%      -2.00    
44.00   49.00   47.00    2.10
innodb  select_many_fields                   12.00       +4.76%       0.60    
12.00   13.00   12.60    0.49
innodb  select_range                         48.00       -3.90%      -1.80    
44.00   48.00   46.20    1.33
innodb  select_range_key2                     8.00       +6.98%       0.60     
8.00    9.00    8.60    0.49
innodb  select_range_prefix                   9.00       -4.65%      -0.40     
8.00    9.00    8.60    0.49
innodb  select_simple                         1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  select_simple_cache                   2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  select_simple_join                    1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  update_autocommit                     4.00       +4.76%       0.20     
4.00    5.00    4.20    0.40
innodb  update_big                           70.00       -8.70%      -5.60    
46.00   71.00   64.40    9.35
innodb  update_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  update_of_key                        51.00       -8.51%      -4.00    
25.00   56.00   47.00   11.37
innodb  update_of_key_big                    34.00       +1.16%       0.40    
22.00   41.00   34.40    6.59
innodb  update_of_primary_key_many_keys    4327.00      -15.98%    -596.20   
804.00 4680.00 3730.80 1,468.38
innodb  update_rollback                       2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  update_with_key                     132.00       -3.13%      -4.00   
106.00  137.00  128.00   11.37
innodb  update_with_key_prefix               45.00       +1.75%       0.80    
38.00   50.00   45.80    4.26
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                      46.00      -52.07%     -15.75    
11.00   54.00   30.25   11.14
innodb  alter_table_drop                     32.00      -25.98%      -6.60    
13.00   41.00   25.40    7.84
innodb  connect                               2.00      +11.11%       0.25     
2.00    3.00    2.25    0.43
innodb  connect+select_1_row                  3.00       -3.45%      -0.10     
2.00    3.00    2.90    0.30
innodb  connect+select_simple                 3.00      -13.21%      -0.35     
2.00    3.00    2.65    0.48
innodb  count                                13.00      +12.46%       1.85    
13.00   17.00   14.85    1.71
innodb  count_distinct                        8.00      -24.03%      -1.55     
5.00    8.00    6.45    0.86
innodb  count_distinct_2                     14.00       -7.69%      -1.00    
11.00   15.00   13.00    1.58
innodb  count_distinct_big                   21.00       +2.78%       0.60    
19.00   24.00   21.60    1.80
innodb  count_distinct_group                 13.00       -4.42%      -0.55    
11.00   15.00   12.45    1.28
innodb  count_distinct_group_on_key           8.00      +15.79%       1.50     
8.00   12.00    9.50    1.24
innodb  count_distinct_group_on_key_parts    10.00      +15.25%       1.80    
10.00   15.00   11.80    1.50
innodb  count_distinct_key_prefix             6.00      -13.21%      -0.70     
4.00    7.00    5.30    0.84
innodb  count_group_on_key_parts             10.00       +0.99%       0.10     
9.00   13.00   10.10    0.83
innodb  count_on_key                         83.00       +2.52%       2.15    
81.00   91.00   85.15    2.85
innodb  create+drop                          56.00      -13.82%      -6.80    
26.00   76.00   49.20   14.44
innodb  create_index                          5.00      -38.89%      -1.40     
2.00    7.00    3.60    1.24
innodb  create_key+drop                      43.00      -24.64%      -8.50    
27.00   44.00   34.50    6.57
innodb  create_MANY_tables                   72.00      -10.60%      -6.90    
28.00  105.00   65.10   20.89
innodb  create_table                          0.00     +100.00%       0.15     
0.00    1.00    0.15    0.36
innodb  delete_all_many_keys               1588.00      -64.74%    -624.05   
299.00 1828.00  963.95  653.48
innodb  delete_autocommit                     5.00      -31.58%      -1.20     
3.00    6.00    3.80    0.87
innodb  delete_big                            0.00     +100.00%       0.10     
0.00    1.00    0.10    0.30
innodb  delete_big_many_keys               1588.00      -64.74%    -624.05   
299.00 1828.00  963.95  653.48
innodb  delete_commit                         1.00      +31.03%       0.45     
1.00    2.00    1.45    0.50
innodb  delete_key                            5.00      -11.11%      -0.50     
2.00    7.00    4.50    1.47
innodb  delete_range                          9.00      -15.38%      -1.20     
6.00   13.00    7.80    1.66
innodb  delete_rollback                       1.00      +35.48%       0.55     
1.00    2.00    1.55    0.50
innodb  drop_index                            3.00      +30.23%       1.30     
2.00    7.00    4.30    1.62
innodb  drop_table_when_MANY_tables          23.00       -2.00%      -0.45    
14.00   33.00   22.55    5.34
innodb  insert                              132.00      -10.69%     -12.75   
100.00  142.00  119.25   15.98
innodb  insert_autocommit                     3.00       -5.26%      -0.15     
2.00    4.00    2.85    0.48
innodb  insert_commit                         1.00      +23.08%       0.30     
1.00    2.00    1.30    0.46
innodb  insert_duplicates                    15.00       -1.01%      -0.15    
14.00   16.00   14.85    0.79
innodb  insert_key                          636.00      -27.74%    -138.10   
193.00  827.00  497.90  252.99
innodb  insert_many_fields                    9.00      -10.43%      -0.85     
5.00   11.00    8.15    1.85
innodb  insert_rollback                       2.00      -17.65%      -0.30     
1.00    3.00    1.70    0.56
innodb  insert_select_1_key                   5.00      -17.65%      -0.75     
3.00    6.00    4.25    1.04
innodb  insert_select_2_keys                  9.00      -29.50%      -2.05     
4.00   12.00    6.95    2.18
innodb  min_max                               7.00       +2.78%       0.20     
6.00    9.00    7.20    0.87
innodb  min_max_on_key                       19.00       +0.78%       0.15    
17.00   21.00   19.15    1.19
innodb  multiple_value_insert                19.00     -100.00%      -9.50     
3.00   25.00    9.50    6.41
innodb  once_prepared_select                 24.00       -0.84%      -0.20    
23.00   25.00   23.80    0.60
innodb  order_by_big                         13.00       +9.72%       1.40    
12.00   16.00   14.40    1.32
innodb  order_by_big_key                     12.00       +7.69%       1.00    
11.00   15.00   13.00    1.22
innodb  order_by_big_key2                    10.00      +17.36%       2.10    
10.00   14.00   12.10    1.18
innodb  order_by_big_key_desc                12.00       +9.43%       1.25    
11.00   15.00   13.25    1.18
innodb  order_by_big_key_diff                11.00       +9.84%       1.20    
11.00   14.00   12.20    0.93
innodb  order_by_big_key_prefix              12.00       +2.04%       0.25    
11.00   14.00   12.25    1.04
innodb  order_by_key2_diff                    2.00      -29.03%      -0.45     
1.00    2.00    1.55    0.50
innodb  order_by_key_prefix                   1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  order_by_range                        0.00     +100.00%       0.80     
0.00    1.00    0.80    0.40
innodb  outer_join                           17.00      +11.46%       2.20    
16.00   25.00   19.20    2.56
innodb  outer_join_found                     16.00      +13.51%       2.50    
15.00   23.00   18.50    2.66
innodb  outer_join_not_found                 13.00      +19.75%       3.20    
13.00   21.00   16.20    2.27
innodb  outer_join_on_key                    11.00      +14.40%       1.85    
10.00   17.00   12.85    1.71
innodb  prepared_select                      32.00       +0.93%       0.30    
31.00   33.00   32.30    0.78
innodb  select_1_row                          3.00      -13.21%      -0.35     
2.00    3.00    2.65    0.48
innodb  select_1_row_cache                    2.00      +21.57%       0.55     
2.00    3.00    2.55    0.50
innodb  select_2_rows                         3.00      -11.11%      -0.30     
2.00    3.00    2.70    0.46
innodb  select_big                           10.00      +14.89%       1.75    
10.00   14.00   11.75    1.34
innodb  select_big_str                        1.00       +9.09%       0.10     
1.00    2.00    1.10    0.30
innodb  select_cache                         64.00       -9.22%      -5.40    
52.00   69.00   58.60    5.09
innodb  select_cache2                        65.00       -6.91%      -4.20    
51.00   71.00   60.80    5.46
innodb  select_column+column                  3.00       -9.09%      -0.25     
2.00    3.00    2.75    0.43
innodb  select_diff_key                       0.00     +100.00%       0.10     
0.00    1.00    0.10    0.30
innodb  select_distinct                       4.00       +4.76%       0.20     
4.00    5.00    4.20    0.40
innodb  select_group                         15.00       +4.76%       0.75    
14.00   18.00   15.75    1.37
innodb  select_group_when_MANY_tables         5.00       +7.41%       0.40     
4.00    9.00    5.40    1.24
innodb  select_join                           0.00     +100.00%       0.50     
0.00    1.00    0.50    0.50
innodb  select_key                           48.00       +2.24%       1.10    
45.00   54.00   49.10    2.32
innodb  select_key2                          62.00       -0.32%      -0.20    
59.00   64.00   61.80    1.29
innodb  select_key2_return_key               60.00       -2.56%      -1.50    
56.00   61.00   58.50    1.32
innodb  select_key2_return_prim              61.00       -2.35%      -1.40    
57.00   62.00   59.60    1.43
innodb  select_key_prefix                    63.00       -3.70%      -2.25    
58.00   64.00   60.75    1.55
innodb  select_key_prefix_join                5.00       -5.26%      -0.25     
4.00    5.00    4.75    0.43
innodb  select_key_return_key                49.00       -4.37%      -2.05    
43.00   55.00   46.95    2.78
innodb  select_many_fields                   12.00       +6.98%       0.90    
12.00   14.00   12.90    0.54
innodb  select_range                         48.00       -1.05%      -0.50    
44.00   54.00   47.50    3.14
innodb  select_range_key2                     8.00       +7.51%       0.65     
8.00    9.00    8.65    0.48
innodb  select_range_prefix                   9.00       -9.09%      -0.75     
7.00    9.00    8.25    0.62
innodb  select_simple                         1.00      +23.08%       0.30     
1.00    2.00    1.30    0.46
innodb  select_simple_cache                   2.00      -21.21%      -0.35     
1.00    2.00    1.65    0.48
innodb  select_simple_join                    1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  update_autocommit                     4.00      -12.68%      -0.45     
3.00    5.00    3.55    0.59
innodb  update_big                           70.00      -20.90%     -12.10    
33.00   89.00   57.90   12.56
innodb  update_commit                         2.00      -29.03%      -0.45     
1.00    2.00    1.55    0.50
innodb  update_of_key                        51.00      -36.91%     -13.75    
22.00   56.00   37.25   12.70
innodb  update_of_key_big                    34.00      -16.64%      -4.85    
17.00   41.00   29.15    7.84
innodb  update_of_primary_key_many_keys    4327.00      -68.77%   -1763.10   
804.00 4874.00 2563.90 1,737.15
innodb  update_rollback                       2.00      -17.65%      -0.30     
1.00    2.00    1.70    0.46
innodb  update_with_key                     132.00      -11.39%     -13.50   
101.00  137.00  118.50   13.43
innodb  update_with_key_prefix               45.00       -8.04%      -3.35    
36.00   50.00   41.65    4.90
innodb  wisc_benchmark                        3.00      -11.11%      -0.30     
2.00    4.00    2.70    0.56

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      46.00     -277.90%     -33.83    
11.00   14.00   12.17    0.87
innodb  alter_table_drop                     32.00     -180.36%     -20.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                        8.00      -31.82%      -1.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                 13.00       -2.72%      -0.34    
11.00   14.00   12.66    0.84
innodb  count_distinct_group_on_key           8.00      +10.08%       0.90     
8.00   11.00    8.90    1.12
innodb  count_distinct_group_on_key_parts    10.00      +14.96%       1.76    
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                         83.00       -7.46%      -5.76    
73.00   83.00   77.24    2.25
innodb  create+drop                          56.00     -186.93%     -36.48    
19.00   21.00   19.52    0.56
innodb  create_index                          5.00     -163.64%      -3.10     
1.00    3.00    1.90    0.48
innodb  create_key+drop                      43.00      -90.67%     -20.45    
21.00   23.00   22.55    0.56
innodb  create_MANY_tables                   72.00     -321.82%     -54.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               1588.00     -434.25%   -1290.76   
239.00  345.00  297.24   21.38
innodb  delete_autocommit                     5.00      -76.83%      -2.17     
2.00    3.00    2.83    0.38
innodb  delete_big                            0.00     +100.00%       0.28     
0.00    1.00    0.28    0.45
innodb  delete_big_many_keys               1588.00     -434.43%   -1290.86   
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                            5.00     -104.23%      -2.55     
2.00    3.00    2.45    0.50
innodb  delete_range                          9.00      -29.21%      -2.03     
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                            3.00      -52.63%      -1.03     
1.00    3.00    1.97    0.32
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.22
innodb  drop_table_when_MANY_tables          23.00      -70.59%      -9.52    
12.00   15.00   13.48    0.62
innodb  insert                              132.00      -45.55%     -41.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                    15.00      -16.94%      -2.17    
12.00   14.00   12.83    0.53
innodb  insert_key                          636.00     -121.12%    -348.38   
189.00  345.00  287.62   32.94
innodb  insert_many_fields                    9.00     -121.19%      -4.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                   5.00      -46.46%      -1.59     
3.00    4.00    3.41    0.49
innodb  insert_select_2_keys                  9.00      -74.00%      -3.83     
4.00    6.00    5.17    0.59
innodb  min_max                               7.00       +8.56%       0.66     
6.00    9.00    7.66    1.03
innodb  min_max_on_key                       19.00      -12.68%      -2.14    
14.00   20.00   16.86    1.28
innodb  multiple_value_insert                19.00     -320.61%     -14.48     
3.00    5.00    4.52    0.56
innodb  once_prepared_select                 24.00      -14.47%      -3.03    
20.00   22.00   20.97    0.61
innodb  order_by_big                         13.00       +8.05%       1.14    
12.00   15.00   14.14    0.94
innodb  order_by_big_key                     12.00       +3.33%       0.41    
11.00   14.00   12.41    1.19
innodb  order_by_big_key2                    10.00      +12.91%       1.48    
10.00   13.00   11.48    0.97
innodb  order_by_big_key_desc                12.00       +6.95%       0.90    
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                    2.00      -70.59%      -0.83     
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                        0.00     +100.00%       0.72     
0.00    1.00    0.72    0.45
innodb  outer_join                           17.00       +1.99%       0.34    
15.00   21.00   17.34    2.06
innodb  outer_join_found                     16.00       +5.11%       0.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                      32.00      -23.73%      -6.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                           10.00      +13.95%       1.62    
10.00   13.00   11.62    1.00
innodb  select_big_str                        1.00       +9.58%       0.11     
0.00    2.00    1.11    0.31
innodb  select_cache                         64.00      -11.14%      -6.41    
51.00   71.00   57.59    5.41
innodb  select_cache2                        65.00      -14.31%      -8.14    
51.00   68.00   56.86    4.88
innodb  select_column+column                  3.00      -12.99%      -0.34     
2.00    3.00    2.66    0.48
innodb  select_diff_key                       0.00     +100.00%       0.17     
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                         15.00       +1.36%       0.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                           48.00       -7.82%      -3.48    
40.00   50.00   44.52    2.50
innodb  select_key2                          62.00      -25.82%     -12.72    
46.00   54.00   49.28    2.41
innodb  select_key2_return_key               60.00      -27.85%     -13.07    
42.00   51.00   46.93    2.32
innodb  select_key2_return_prim              61.00      -26.00%     -12.59    
43.00   55.00   48.41    2.92
innodb  select_key_prefix                    63.00      -24.03%     -12.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                   12.00      +27.04%       4.45    
15.00   17.00   16.45    0.62
innodb  select_range                         48.00       +1.76%       0.86    
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                   9.00      -28.57%      -2.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                   2.00      -75.76%      -0.86     
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  update_autocommit                     4.00      -43.21%      -1.21     
2.00    3.00    2.79    0.41
innodb  update_big                           70.00      -94.26%     -33.97    
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                        51.00     -164.58%     -31.72    
19.00   20.00   19.28    0.45
innodb  update_of_key_big                    34.00      -85.69%     -15.69    
16.00   20.00   18.31    1.18
innodb  update_of_primary_key_many_keys    4327.00     -466.86%   -3563.67   
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                     132.00      -43.86%     -40.24    
90.00   93.00   91.76    0.97
innodb  update_with_key_prefix               45.00      -27.69%      -9.76    
34.00   36.00   35.24    0.57
innodb  wisc_benchmark                        3.00      -27.94%      -0.66     
2.00    3.00    2.34    0.48

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

  1919.1.3: Brian Aker 2010-11-09 [merge] Merge in Andrew's fix
    1900.3.3: Andrew Hutchings 2010-11-09 Fix warning in test case
  1919.1.2: Brian Aker 2010-11-09 [merge] Merge in Andrew.
    1900.3.2: Andrew Hutchings 2010-11-09 Add test cases
    1900.3.1: Andrew Hutchings 2010-11-09 Add FLUSH GLOBAL STATUS; command
  1919.1.1: Brian Aker 2010-11-09 [merge] Merge in Andrew.
    1914.1.2: Andrew Hutchings 2010-11-08 Another attempt at fixing this
    1914.1.1: Andrew Hutchings 2010-11-08 Fix deprecated boost function

_______________________________________________
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