=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   571
RUN DATE: 2010-10-18T17:38:29.730608
SERVER:   drizzled
VERSION:  staging
REVISION: 1861
COMMENT:  1861: lbieber 2010-10-18 [merge] Merge Andrew - fix bug 661431: 
libdrizzle drizzle_escape_string does not function correctly

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      17.00      -23.64%      -3.25    
12.00   17.00   13.75    2.05
innodb  alter_table_drop                     12.00       +4.00%       0.50    
11.00   15.00   12.50    1.50
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       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  count                                13.00       +8.77%       1.25    
13.00   18.00   14.25    2.17
innodb  count_distinct                        7.00       -0.00%       0.00     
5.00    8.00    7.00    1.22
innodb  count_distinct_2                     14.00       -1.82%      -0.25    
12.00   15.00   13.75    1.09
innodb  count_distinct_big                   21.00       +2.33%       0.50    
21.00   23.00   21.50    0.87
innodb  count_distinct_group                 14.00      -12.00%      -1.50    
11.00   14.00   12.50    1.12
innodb  count_distinct_group_on_key          11.00       -7.32%      -0.75     
9.00   11.00   10.25    0.83
innodb  count_distinct_group_on_key_parts    12.00       +2.04%       0.25    
10.00   14.00   12.25    1.48
innodb  count_distinct_key_prefix             6.00      -14.29%      -0.75     
5.00    6.00    5.25    0.43
innodb  count_group_on_key_parts             10.00       -5.26%      -0.50     
8.00   10.00    9.50    0.87
innodb  count_on_key                         84.00       +1.75%       1.50    
84.00   88.00   85.50    1.66
innodb  create+drop                          30.00       +6.98%       2.25    
23.00   40.00   32.25    6.42
innodb  create_index                          4.00      -23.08%      -0.75     
2.00    5.00    3.25    1.30
innodb  create_key+drop                      26.00       +3.70%       1.00    
25.00   29.00   27.00    1.58
innodb  create_MANY_tables                   29.00      +18.31%       6.50    
15.00   51.00   35.50   14.45
innodb  create_table                          0.00         NULL       0.00     
0.00    0.00    0.00    0.00
innodb  delete_all_many_keys                296.00       +0.50%       1.50   
292.00  301.00  297.50    3.77
innodb  delete_autocommit                     3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_big                            0.00     +100.00%       0.50     
0.00    1.00    0.50    0.50
innodb  delete_big_many_keys                296.00       +0.50%       1.50   
292.00  301.00  297.50    3.77
innodb  delete_commit                         1.00      +20.00%       0.25     
1.00    2.00    1.25    0.43
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          6.00       +7.69%       0.50     
5.00    8.00    6.50    1.12
innodb  delete_rollback                       2.00      -14.29%      -0.25     
1.00    2.00    1.75    0.43
innodb  drop_index                            1.00      +42.86%       0.75     
1.00    2.00    1.75    0.43
innodb  drop_table                            0.00         NULL       0.00     
0.00    0.00    0.00    0.00
innodb  drop_table_when_MANY_tables          14.00       +6.67%       1.00    
12.00   19.00   15.00    2.55
innodb  insert                              105.00       -0.24%      -0.25    
95.00  113.00  104.75    6.42
innodb  insert_autocommit                     3.00       -9.09%      -0.25     
2.00    3.00    2.75    0.43
innodb  insert_commit                         1.00      +20.00%       0.25     
1.00    2.00    1.25    0.43
innodb  insert_duplicates                    16.00      -10.34%      -1.50    
14.00   16.00   14.50    0.87
innodb  insert_key                          185.00      +12.11%      25.50   
142.00  276.00  210.50   51.10
innodb  insert_many_fields                    5.00       +4.76%       0.25     
5.00    6.00    5.25    0.43
innodb  insert_rollback                       2.00      -14.29%      -0.25     
1.00    2.00    1.75    0.43
innodb  insert_select_1_key                   3.00       +7.69%       0.25     
3.00    4.00    3.25    0.43
innodb  insert_select_2_keys                  4.00      +15.79%       0.75     
4.00    6.00    4.75    0.83
innodb  min_max                               7.00       -0.00%       0.00     
7.00    7.00    7.00    0.00
innodb  min_max_on_key                       17.00       +2.86%       0.50    
17.00   18.00   17.50    0.50
innodb  multiple_value_insert                 4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
innodb  once_prepared_select                 24.00       -1.05%      -0.25    
23.00   24.00   23.75    0.43
innodb  order_by_big                         13.00       +5.45%       0.75    
13.00   15.00   13.75    0.83
innodb  order_by_big_key                     13.00       -0.00%       0.00    
11.00   14.00   13.00    1.22
innodb  order_by_big_key2                    11.00       +8.33%       1.00    
11.00   13.00   12.00    1.00
innodb  order_by_big_key_desc                12.00       +7.69%       1.00    
12.00   14.00   13.00    1.00
innodb  order_by_big_key_diff                11.00       +4.35%       0.50    
10.00   13.00   11.50    1.12
innodb  order_by_big_key_prefix              11.00      +10.20%       1.25    
11.00   13.00   12.25    0.83
innodb  order_by_key2_diff                    2.00      -33.33%      -0.50     
1.00    2.00    1.50    0.50
innodb  order_by_key_prefix                   0.00     +100.00%       0.75     
0.00    1.00    0.75    0.43
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           23.00       -5.75%      -1.25    
21.00   23.00   21.75    0.83
innodb  outer_join_found                     21.00       -0.00%       0.00    
20.00   22.00   21.00    0.71
innodb  outer_join_not_found                 19.00       -4.11%      -0.75    
18.00   19.00   18.25    0.43
innodb  outer_join_on_key                    15.00       -1.69%      -0.25    
14.00   15.00   14.75    0.43
innodb  prepared_select                      31.00       -1.64%      -0.50    
29.00   32.00   30.50    1.12
innodb  select_1_row                          3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  select_1_row_cache                    2.00      +11.11%       0.25     
2.00    3.00    2.25    0.43
innodb  select_2_rows                         3.00       -9.09%      -0.25     
2.00    3.00    2.75    0.43
innodb  select_big                           13.00       -4.00%      -0.50    
11.00   13.00   12.50    0.87
innodb  select_big_str                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  select_cache                         65.00       -9.24%      -5.50    
57.00   65.00   59.50    3.20
innodb  select_cache2                        65.00       -4.84%      -3.00    
53.00   66.00   62.00    5.24
innodb  select_column+column                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  select_diff_key                       0.00     +100.00%       0.25     
0.00    1.00    0.25    0.43
innodb  select_distinct                       4.00      +11.11%       0.50     
4.00    5.00    4.50    0.50
innodb  select_group                         15.00       +4.76%       0.75    
14.00   18.00   15.75    1.48
innodb  select_group_when_MANY_tables         4.00      +15.79%       0.75     
4.00    6.00    4.75    0.83
innodb  select_join                           0.00     +100.00%       0.50     
0.00    1.00    0.50    0.50
innodb  select_key                           51.00       -3.03%      -1.50    
46.00   52.00   49.50    2.29
innodb  select_key2                          60.00       +0.41%       0.25    
60.00   61.00   60.25    0.43
innodb  select_key2_return_key               58.00       +0.85%       0.50    
58.00   59.00   58.50    0.50
innodb  select_key2_return_prim              57.00       +0.87%       0.50    
57.00   59.00   57.50    0.87
innodb  select_key_prefix                    59.00       +2.48%       1.50    
59.00   62.00   60.50    1.12
innodb  select_key_prefix_join                5.00      -11.11%      -0.50     
4.00    5.00    4.50    0.50
innodb  select_key_return_key                51.00       -5.70%      -2.75    
46.00   51.00   48.25    1.92
innodb  select_many_fields                   13.00       -4.00%      -0.50    
12.00   13.00   12.50    0.50
innodb  select_range                         45.00       +2.70%       1.25    
43.00   52.00   46.25    3.42
innodb  select_range_key2                     9.00       -5.88%      -0.50     
8.00    9.00    8.50    0.50
innodb  select_range_prefix                   8.00       -6.67%      -0.50     
7.00    8.00    7.50    0.50
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  select_simple_join                    1.00      -33.33%      -0.25     
0.00    1.00    0.75    0.43
innodb  TOTALS                             3148.00       +0.73%      23.25  
3017.00 3292.00 3171.25  102.63
innodb  update_autocommit                     4.00      -23.08%      -0.75     
3.00    4.00    3.25    0.43
innodb  update_big                           34.00       +9.33%       3.50    
34.00   42.00   37.50    2.87
innodb  update_commit                         1.00      +20.00%       0.25     
1.00    2.00    1.25    0.43
innodb  update_of_key                        21.00       +7.69%       1.75    
18.00   27.00   22.75    3.49
innodb  update_of_key_big                    19.00      +16.48%       3.75    
19.00   28.00   22.75    3.27
innodb  update_of_primary_key_many_keys     830.00       -1.59%     -13.00   
809.00  830.00  817.00    8.22
innodb  update_rollback                       1.00      +20.00%       0.25     
1.00    2.00    1.25    0.43
innodb  update_with_key                     103.00       -1.23%      -1.25    
98.00  103.00  101.75    2.17
innodb  update_with_key_prefix               36.00       -0.00%       0.00    
35.00   37.00   36.00    0.71
innodb  wisc_benchmark                        2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      17.00       -0.31%      -0.05    
12.00   32.00   16.95    5.99
innodb  alter_table_drop                     12.00      +19.43%       2.89    
11.00   19.00   14.89    2.57
innodb  connect                               3.00      -29.55%      -0.68     
2.00    3.00    2.32    0.46
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      +17.39%       0.42     
2.00    3.00    2.42    0.49
innodb  count                                13.00      +10.51%       1.53    
13.00   18.00   14.53    1.82
innodb  count_distinct                        7.00       -5.56%      -0.37     
5.00    8.00    6.63    0.93
innodb  count_distinct_2                     14.00       -6.83%      -0.89    
11.00   15.00   13.11    1.65
innodb  count_distinct_big                   21.00       -0.25%      -0.05    
19.00   24.00   20.95    1.88
innodb  count_distinct_group                 14.00       -8.57%      -1.11    
11.00   14.00   12.89    1.02
innodb  count_distinct_group_on_key          11.00      -17.42%      -1.63     
8.00   11.00    9.37    1.27
innodb  count_distinct_group_on_key_parts    12.00       -1.79%      -0.21    
10.00   14.00   11.79    1.44
innodb  count_distinct_key_prefix             6.00      -22.58%      -1.11     
4.00    6.00    4.89    0.72
innodb  count_group_on_key_parts             10.00       -4.40%      -0.42     
8.00   11.00    9.58    0.88
innodb  count_on_key                         84.00       +1.42%       1.21    
80.00   89.00   85.21    2.12
innodb  create+drop                          30.00       +3.23%       1.00    
22.00   41.00   31.00    5.69
innodb  create_index                          4.00      -61.70%      -1.53     
2.00    5.00    2.47    0.82
innodb  create_key+drop                      26.00       +5.73%       1.58    
25.00   34.00   27.58    2.03
innodb  create_MANY_tables                   29.00      +12.12%       4.00    
15.00   69.00   33.00   14.39
innodb  create_table                          0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  delete_all_many_keys                296.00       +2.31%       7.00   
227.00  359.00  303.00   23.51
innodb  delete_autocommit                     3.00       +5.00%       0.16     
3.00    4.00    3.16    0.36
innodb  delete_big                            0.00     +100.00%       0.26     
0.00    1.00    0.26    0.44
innodb  delete_big_many_keys                296.00       +2.31%       7.00   
227.00  359.00  303.00   23.51
innodb  delete_commit                         1.00      +32.14%       0.47     
1.00    2.00    1.47    0.50
innodb  delete_key                            3.00       -5.56%      -0.16     
2.00    4.00    2.84    0.49
innodb  delete_range                          6.00       +5.00%       0.32     
5.00    8.00    6.32    0.80
innodb  delete_rollback                       2.00      -26.67%      -0.42     
1.00    2.00    1.58    0.49
innodb  drop_index                            1.00      +54.76%       1.21     
1.00    6.00    2.21    1.10
innodb  drop_table                            0.00         NULL       0.00     
0.00    0.00    0.00    0.00
innodb  drop_table_when_MANY_tables          14.00      +10.74%       1.68    
12.00   26.00   15.68    3.26
innodb  insert                              105.00       +1.34%       1.42    
95.00  114.00  106.42    4.15
innodb  insert_autocommit                     3.00       -9.62%      -0.26     
2.00    3.00    2.74    0.44
innodb  insert_commit                         1.00      +24.00%       0.32     
1.00    2.00    1.32    0.46
innodb  insert_duplicates                    16.00       -9.75%      -1.42    
13.00   17.00   14.58    0.88
innodb  insert_key                          185.00       +8.42%      17.00   
142.00  281.00  202.00   41.13
innodb  insert_many_fields                    5.00      +15.18%       0.89     
5.00   11.00    5.89    1.37
innodb  insert_rollback                       2.00      -15.15%      -0.26     
1.00    2.00    1.74    0.44
innodb  insert_select_1_key                   3.00       +1.72%       0.05     
2.00    4.00    3.05    0.39
innodb  insert_select_2_keys                  4.00      +14.61%       0.68     
4.00    6.00    4.68    0.65
innodb  min_max                               7.00       +4.32%       0.32     
6.00    9.00    7.32    0.86
innodb  min_max_on_key                       17.00       +9.78%       1.84    
17.00   23.00   18.84    1.42
innodb  multiple_value_insert                 4.00      -15.15%      -0.53     
3.00    5.00    3.47    0.60
innodb  once_prepared_select                 24.00       -2.01%      -0.47    
22.00   26.00   23.53    0.99
innodb  order_by_big                         13.00       +4.26%       0.58    
12.00   16.00   13.58    1.23
innodb  order_by_big_key                     13.00       +0.40%       0.05    
11.00   14.00   13.05    1.10
innodb  order_by_big_key2                    11.00       +5.86%       0.68    
10.00   13.00   11.68    1.03
innodb  order_by_big_key_desc                12.00       +9.88%       1.32    
12.00   16.00   13.32    1.17
innodb  order_by_big_key_diff                11.00       +2.79%       0.32    
10.00   13.00   11.32    1.22
innodb  order_by_big_key_prefix              11.00       +8.73%       1.05    
11.00   14.00   12.05    1.00
innodb  order_by_key2_diff                    2.00      -31.03%      -0.47     
1.00    2.00    1.53    0.50
innodb  order_by_key_prefix                   0.00     +100.00%       0.79     
0.00    1.00    0.79    0.41
innodb  order_by_range                        1.00      -35.71%      -0.26     
0.00    1.00    0.74    0.44
innodb  outer_join                           23.00      -15.61%      -3.11    
15.00   26.00   19.89    2.77
innodb  outer_join_found                     21.00       -9.02%      -1.74    
15.00   26.00   19.26    2.79
innodb  outer_join_not_found                 19.00      -16.45%      -2.68    
13.00   21.00   16.32    2.25
innodb  outer_join_on_key                    15.00      -13.55%      -1.79    
11.00   15.00   13.21    1.47
innodb  prepared_select                      31.00       -1.03%      -0.32    
27.00   33.00   30.68    1.42
innodb  select_1_row                          3.00      -11.76%      -0.32     
2.00    3.00    2.68    0.46
innodb  select_1_row_cache                    2.00      +17.39%       0.42     
2.00    3.00    2.42    0.49
innodb  select_2_rows                         3.00       -9.62%      -0.26     
2.00    3.00    2.74    0.44
innodb  select_big                           13.00       -7.86%      -0.95    
10.00   14.00   12.05    1.19
innodb  select_big_str                        1.00       +5.00%       0.05     
1.00    2.00    1.05    0.22
innodb  select_cache                         65.00       -8.05%      -4.84    
53.00   65.00   60.16    3.77
innodb  select_cache2                        65.00       -4.13%      -2.58    
53.00   66.00   62.42    3.90
innodb  select_column+column                  3.00       -5.56%      -0.16     
2.00    3.00    2.84    0.36
innodb  select_diff_key                       0.00     +100.00%       0.16     
0.00    1.00    0.16    0.36
innodb  select_distinct                       4.00       +5.00%       0.21     
4.00    5.00    4.21    0.41
innodb  select_group                         15.00       +4.04%       0.63    
14.00   18.00   15.63    1.35
innodb  select_group_when_MANY_tables         4.00      +16.48%       0.79     
4.00    6.00    4.79    0.69
innodb  select_join                           0.00     +100.00%       0.58     
0.00    1.00    0.58    0.49
innodb  select_key                           51.00       -3.64%      -1.79    
46.00   52.00   49.21    1.79
innodb  select_key2                          60.00       +0.26%       0.16    
56.00   62.00   60.16    1.78
innodb  select_key2_return_key               58.00       +0.81%       0.47    
54.00   64.00   58.47    1.87
innodb  select_key2_return_prim              57.00       +2.70%       1.58    
54.00   62.00   58.58    1.82
innodb  select_key_prefix                    59.00       +1.67%       1.00    
55.00   62.00   60.00    1.78
innodb  select_key_prefix_join                5.00      -10.47%      -0.47     
4.00    5.00    4.53    0.50
innodb  select_key_return_key                51.00       -7.91%      -3.74    
43.00   52.00   47.26    2.42
innodb  select_many_fields                   13.00       +1.20%       0.16    
12.00   18.00   13.16    1.60
innodb  select_range                         45.00       +7.57%       3.68    
43.00   52.00   48.68    3.04
innodb  select_range_key2                     9.00       -6.21%      -0.53     
7.00    9.00    8.47    0.60
innodb  select_range_prefix                   8.00       -2.70%      -0.21     
7.00    9.00    7.79    0.52
innodb  select_simple                         2.00      -26.67%      -0.42     
1.00    2.00    1.58    0.49
innodb  select_simple_cache                   1.00      +26.92%       0.37     
1.00    2.00    1.37    0.48
innodb  select_simple_join                    1.00      -46.15%      -0.32     
0.00    1.00    0.68    0.46
innodb  TOTALS                             3148.00       +1.04%      33.05  
2860.00 3469.00 3181.05  133.23
innodb  update_autocommit                     4.00      -28.81%      -0.89     
3.00    4.00    3.11    0.31
innodb  update_big                           34.00      +10.53%       4.00    
32.00   54.00   38.00    4.79
innodb  update_commit                         1.00      +24.00%       0.32     
1.00    2.00    1.32    0.46
innodb  update_of_key                        21.00       +8.28%       1.89    
18.00   27.00   22.89    2.61
innodb  update_of_key_big                    19.00       +5.00%       1.00    
16.00   28.00   20.00    3.04
innodb  update_of_primary_key_many_keys     830.00       -0.45%      -3.68   
730.00 1004.00  826.32   51.84
innodb  update_rollback                       1.00      +29.63%       0.42     
1.00    2.00    1.42    0.49
innodb  update_with_key                     103.00       -0.31%      -0.32    
98.00  112.00  102.68    3.67
innodb  update_with_key_prefix               36.00       +0.15%       0.05    
35.00   38.00   36.05    0.83
innodb  wisc_benchmark                        2.00      +17.39%       0.42     
2.00    3.00    2.42    0.49

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      17.00      -39.66%      -4.83    
11.00   14.00   12.17    0.87
innodb  alter_table_drop                     12.00       -5.14%      -0.59    
10.00   14.00   11.41    1.07
innodb  connect                               3.00      -77.55%      -1.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                 2.00       -1.75%      -0.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    12.00       -2.05%      -0.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                         84.00       -8.75%      -6.76    
73.00   83.00   77.24    2.25
innodb  create+drop                          30.00      -53.71%     -10.48    
19.00   21.00   19.52    0.56
innodb  create_index                          4.00     -110.91%      -2.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                   29.00      -69.90%     -11.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                296.00       +0.42%       1.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                            0.00     +100.00%       0.28     
0.00    1.00    0.28    0.45
innodb  delete_big_many_keys                296.00       +0.38%       1.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                       2.00      -52.63%      -0.69     
1.00    2.00    1.31    0.46
innodb  drop_index                            1.00      +49.12%       0.97     
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                              105.00      -15.78%     -14.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                    16.00      -24.73%      -3.17    
12.00   14.00   12.83    0.53
innodb  insert_key                          185.00      +35.68%     102.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                               7.00       +8.56%       0.66     
6.00    9.00    7.66    1.03
innodb  min_max_on_key                       17.00       -0.82%      -0.14    
14.00   20.00   16.86    1.28
innodb  multiple_value_insert                 4.00      +11.45%       0.52     
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                     13.00       -4.72%      -0.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                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              11.00       +8.07%       0.97    
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                   0.00     +100.00%       0.62     
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                           23.00      -32.60%      -5.66    
15.00   21.00   17.34    2.06
innodb  outer_join_found                     21.00      -24.54%      -4.14    
14.00   21.00   16.86    2.19
innodb  outer_join_not_found                 19.00      -26.67%      -4.00    
13.00   18.00   15.00    1.49
innodb  outer_join_on_key                    15.00      -25.36%      -3.03    
10.00   15.00   11.97    1.50
innodb  prepared_select                      31.00      -19.87%      -5.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.64%       0.11     
0.00    2.00    1.11    0.32
innodb  select_cache                         65.00      -12.87%      -7.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         4.00       -0.00%       0.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                          60.00      -21.76%     -10.72    
46.00   54.00   49.28    2.41
innodb  select_key2_return_key               58.00      -23.59%     -11.07    
42.00   51.00   46.93    2.32
innodb  select_key2_return_prim              57.00      -17.74%      -8.59    
43.00   55.00   48.41    2.92
innodb  select_key_prefix                    59.00      -16.16%      -8.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                51.00      -17.01%      -7.41    
39.00   49.00   43.59    2.65
innodb  select_many_fields                   13.00      +20.96%       3.45    
15.00   17.00   16.45    0.62
innodb  select_range                         45.00       +7.90%       3.86    
47.00   57.00   48.86    1.66
innodb  select_range_key2                     9.00      -24.29%      -1.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                         2.00      -38.10%      -0.55     
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                             3148.00     -214.80%   -2148.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                           34.00       +5.65%       2.03    
31.00   40.00   36.03    2.48
innodb  update_commit                         1.00      +25.64%       0.34     
1.00    2.00    1.34    0.48
innodb  update_of_key                        21.00       -8.94%      -1.72    
19.00   20.00   19.28    0.45
innodb  update_of_key_big                    19.00       -3.77%      -0.69    
16.00   20.00   18.31    1.18
innodb  update_of_primary_key_many_keys     830.00       -8.73%     -66.67   
661.00  799.00  763.33   39.70
innodb  update_rollback                       1.00      +29.27%       0.41     
1.00    2.00    1.41    0.49
innodb  update_with_key                     103.00      -12.25%     -11.24    
90.00   93.00   91.76    0.97
innodb  update_with_key_prefix               36.00       -2.15%      -0.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:

  1857.5.1: Andrew Hutchings 2010-10-17 Add unit tests for libdrizzle utility 
functions

_______________________________________________
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