=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   826
RUN DATE: 2011-01-17T23:50:28.859142
SERVER:   drizzled
VERSION:  staging
REVISION: 2092
COMMENT:  2092: Brian Aker 2011-01-17 Add in reorder and see if this will speed 
up builds at all.

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       +3.76%       1.25    
32.00   34.00   33.25    0.83
innodb  alter_table_drop                     26.00       -4.00%      -1.00    
24.00   26.00   25.00    0.71
innodb  connect                               2.00      +11.11%       0.25     
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                 3.00      -20.00%      -0.50     
2.00    3.00    2.50    0.50
innodb  count                                18.00      -14.29%      -2.25    
13.00   18.00   15.75    2.28
innodb  count_distinct                        8.00      -18.52%      -1.25     
6.00    8.00    6.75    0.83
innodb  count_distinct_2                     16.00      -12.28%      -1.75    
12.00   16.00   14.25    1.48
innodb  count_distinct_big                   23.00       -4.55%      -1.00    
21.00   23.00   22.00    1.00
innodb  count_distinct_group                 16.00      -12.28%      -1.75    
12.00   16.00   14.25    1.48
innodb  count_distinct_group_on_key           9.00       +2.70%       0.25     
9.00   10.00    9.25    0.43
innodb  count_distinct_group_on_key_parts    14.00       -7.69%      -1.00    
11.00   14.00   13.00    1.22
innodb  count_distinct_key_prefix             5.00       +9.09%       0.50     
5.00    7.00    5.50    0.87
innodb  count_group_on_key_parts             11.00       -2.33%      -0.25    
10.00   11.00   10.75    0.43
innodb  count_on_key                         94.00       +1.05%       1.00    
92.00   99.00   95.00    2.55
innodb  create+drop                          32.00      +13.51%       5.00    
32.00   42.00   37.00    5.00
innodb  create_index                          3.00       +7.69%       0.25     
3.00    4.00    3.25    0.43
innodb  create_key+drop                      28.00      +26.80%      10.25    
28.00   49.00   38.25   10.26
innodb  create_MANY_tables                   21.00      +49.40%      20.50    
21.00   62.00   41.50   20.01
innodb  delete_all_many_keys                739.00      -48.32%    -240.75   
287.00  739.00  498.25  211.82
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.25     
0.00    1.00    0.25    0.43
innodb  delete_big_many_keys                737.00      -48.14%    -239.50   
287.00  737.00  497.50  211.03
innodb  delete_commit                         2.00      -14.29%      -0.25     
1.00    2.00    1.75    0.43
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          9.00      -20.00%      -1.50     
6.00    9.00    7.50    1.12
innodb  delete_rollback                       2.00      +71.43%       5.00     
2.00   12.00    7.00    5.00
innodb  drop_index                            3.00       +7.69%       0.25     
3.00    4.00    3.25    0.43
innodb  drop_table_when_MANY_tables          17.00      +66.17%      33.25    
17.00   90.00   50.25   33.57
innodb  insert                              113.00       +5.04%       6.00   
113.00  125.00  119.00    5.10
innodb  insert_autocommit                     3.00      +20.00%       0.75     
3.00    4.00    3.75    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.00%       0.00    
19.00   19.00   19.00    0.00
innodb  insert_key                          304.00      +17.28%      63.50   
301.00  438.00  367.50   65.12
innodb  insert_many_fields                    6.00       +4.00%       0.25     
6.00    7.00    6.25    0.43
innodb  insert_rollback                       2.00      +11.11%       0.25     
2.00    3.00    2.25    0.43
innodb  insert_select_1_key                   4.00      +23.81%       1.25     
4.00    7.00    5.25    1.30
innodb  insert_select_2_keys                  6.00      +25.00%       2.00     
6.00   10.00    8.00    2.00
innodb  min_max                               8.00       -6.67%      -0.50     
6.00    9.00    7.50    1.12
innodb  min_max_on_key                       25.00       -2.04%      -0.50    
24.00   25.00   24.50    0.50
innodb  multiple_value_insert                 7.00      -21.74%      -1.25     
4.00    7.00    5.75    1.30
innodb  once_prepared_select                 29.00       -0.00%       0.00    
29.00   29.00   29.00    0.00
innodb  order_by_big                         16.00      -12.28%      -1.75    
13.00   16.00   14.25    1.30
innodb  order_by_big_key                     14.00       +9.68%       1.50    
14.00   16.00   15.50    0.87
innodb  order_by_big_key2                    13.00       -4.00%      -0.50    
12.00   13.00   12.50    0.50
innodb  order_by_big_key_desc                13.00      +17.46%       2.75    
13.00   17.00   15.75    1.64
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              13.00       +3.70%       0.50    
13.00   14.00   13.50    0.50
innodb  order_by_key2_diff                    1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  order_by_key_prefix                   1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           23.00       -1.10%      -0.25    
22.00   24.00   22.75    0.83
innodb  outer_join_found                     23.00       -3.37%      -0.75    
21.00   23.00   22.25    0.83
innodb  outer_join_not_found                 20.00       -1.27%      -0.25    
19.00   21.00   19.75    0.83
innodb  outer_join_on_key                    16.00       -6.67%      -1.00    
14.00   16.00   15.00    1.00
innodb  prepared_select                      37.00       +1.33%       0.50    
37.00   38.00   37.50    0.50
innodb  select_1_row                          3.00      +20.00%       0.75     
3.00    4.00    3.75    0.43
innodb  select_1_row_cache                    4.00      -23.08%      -0.75     
3.00    4.00    3.25    0.43
innodb  select_2_rows                         4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_big                           12.00       +7.69%       1.00    
11.00   15.00   13.00    1.58
innodb  select_big_str                        2.00      -33.33%      -0.50     
1.00    2.00    1.50    0.50
innodb  select_cache                         64.00       -3.64%      -2.25    
57.00   65.00   61.75    3.11
innodb  select_cache2                        62.00       -2.48%      -1.50    
59.00   62.00   60.50    1.50
innodb  select_column+column                  3.00      +20.00%       0.75     
3.00    4.00    3.75    0.43
innodb  select_diff_key                       1.00      -33.33%      -0.25     
0.00    1.00    0.75    0.43
innodb  select_distinct                       4.00       +5.88%       0.25     
4.00    5.00    4.25    0.43
innodb  select_group                         15.00       +9.09%       1.50    
15.00   18.00   16.50    1.12
innodb  select_group_when_MANY_tables        13.00      +56.30%      16.75    
13.00   49.00   29.75   16.84
innodb  select_join                           1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  select_key                           64.00       -1.19%      -0.75    
63.00   64.00   63.25    0.43
innodb  select_key2                          70.00       -0.00%       0.00    
69.00   71.00   70.00    0.71
innodb  select_key2_return_key               68.00       -0.00%       0.00    
68.00   68.00   68.00    0.00
innodb  select_key2_return_prim              69.00       -1.47%      -1.00    
67.00   69.00   68.00    0.71
innodb  select_key_prefix                    70.00       -0.00%       0.00    
70.00   70.00   70.00    0.00
innodb  select_key_prefix_join                5.00       -0.00%       0.00     
5.00    5.00    5.00    0.00
innodb  select_key_return_key                63.00       -1.20%      -0.75    
62.00   63.00   62.25    0.43
innodb  select_many_fields                   13.00       +1.89%       0.25    
13.00   14.00   13.25    0.43
innodb  select_range                         41.00       +4.65%       2.00    
41.00   45.00   43.00    2.00
innodb  select_range_key2                    10.00       -8.11%      -0.75     
9.00   10.00    9.25    0.43
innodb  select_range_prefix                   9.00       +2.70%       0.25     
9.00   10.00    9.25    0.43
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      -33.33%      -0.25     
0.00    1.00    0.75    0.43
innodb  update_autocommit                     4.00      +60.00%       6.00     
4.00   16.00   10.00    6.00
innodb  update_big                           65.00      +25.07%      21.75    
60.00  112.00   86.75   24.32
innodb  update_commit                         2.00      +65.22%       3.75     
2.00   10.00    5.75    3.77
innodb  update_of_key                        23.00       +3.16%       0.75    
22.00   25.00   23.75    1.30
innodb  update_of_key_big                    37.00      +17.78%       8.00    
34.00   58.00   45.00    9.87
innodb  update_of_primary_key_many_keys    1513.00      -37.58%    -413.25   
728.00 1513.00 1099.75  372.44
innodb  update_rollback                       2.00      +87.30%      13.75     
2.00   31.00   15.75   13.79
innodb  update_with_key                     122.00       -0.21%      -0.25   
121.00  122.00  121.75    0.43
innodb  update_with_key_prefix               45.00       -2.86%      -1.25    
42.00   45.00   43.75    1.09
innodb  wisc_benchmark                        3.00       -9.09%      -0.25     
2.00    3.00    2.75    0.43

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       +0.49%       0.16    
29.00   34.00   32.16    1.31
innodb  alter_table_drop                     26.00       -6.01%      -1.47    
23.00   27.00   24.53    0.94
innodb  connect                               2.00      +19.15%       0.47     
2.00    3.00    2.47    0.50
innodb  connect+select_1_row                  3.00       -3.64%      -0.11     
2.00    3.00    2.89    0.31
innodb  connect+select_simple                 3.00      -26.67%      -0.63     
2.00    3.00    2.37    0.48
innodb  count                                18.00      -11.04%      -1.79    
13.00   23.00   16.21    2.46
innodb  count_distinct                        8.00      -19.69%      -1.32     
6.00    8.00    6.68    0.65
innodb  count_distinct_2                     16.00      -10.14%      -1.47    
12.00   16.00   14.53    1.27
innodb  count_distinct_big                   23.00       -2.34%      -0.53    
20.00   25.00   22.47    1.73
innodb  count_distinct_group                 16.00       +2.56%       0.42    
12.00   24.00   16.42    3.42
innodb  count_distinct_group_on_key           9.00      +12.31%       1.26     
9.00   12.00   10.26    0.85
innodb  count_distinct_group_on_key_parts    14.00       +9.83%       1.53    
11.00   25.00   15.53    3.62
innodb  count_distinct_key_prefix             5.00      +11.21%       0.63     
5.00    7.00    5.63    0.58
innodb  count_group_on_key_parts             11.00       +1.42%       0.16    
10.00   12.00   11.16    0.59
innodb  count_on_key                         94.00       +1.33%       1.26    
92.00  102.00   95.26    2.47
innodb  create+drop                          32.00       +4.70%       1.58    
30.00   42.00   33.58    4.40
innodb  create_index                          3.00       +6.56%       0.21     
2.00    4.00    3.21    0.61
innodb  create_key+drop                      28.00      +15.69%       5.21    
28.00   49.00   33.21    7.49
innodb  create_MANY_tables                   21.00      +27.19%       7.84    
19.00   62.00   28.84   16.17
innodb  create_table                          0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  delete_all_many_keys                739.00      -26.19%    -153.37   
281.00  744.00  585.63  158.06
innodb  delete_autocommit                     3.00      +14.93%       0.53     
3.00    4.00    3.53    0.50
innodb  delete_big                            0.00     +100.00%       0.32     
0.00    1.00    0.32    0.46
innodb  delete_big_many_keys                737.00      -25.98%    -152.00   
281.00  743.00  585.00  157.73
innodb  delete_commit                         2.00      -18.75%      -0.32     
1.00    2.00    1.68    0.46
innodb  delete_key                            3.00       -3.64%      -0.11     
2.00    4.00    2.89    0.45
innodb  delete_range                          9.00       -9.62%      -0.79     
6.00    9.00    8.21    0.83
innodb  delete_rollback                       2.00      +51.90%       2.16     
2.00   12.00    4.16    4.06
innodb  drop_index                            3.00       +8.06%       0.26     
2.00    4.00    3.26    0.55
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  drop_table_when_MANY_tables          17.00      +43.83%      13.26    
15.00   90.00   30.26   26.17
innodb  insert                              113.00       +2.76%       3.21   
111.00  125.00  116.21    4.56
innodb  insert_autocommit                     3.00      +14.93%       0.53     
3.00    5.00    3.53    0.60
innodb  insert_commit                         2.00      -15.15%      -0.26     
1.00    3.00    1.74    0.55
innodb  insert_duplicates                    19.00       -0.00%       0.00    
18.00   20.00   19.00    0.46
innodb  insert_key                          304.00       +4.15%      13.16   
270.00  445.00  317.16   62.18
innodb  insert_many_fields                    6.00       -1.79%      -0.11     
5.00    7.00    5.89    0.45
innodb  insert_rollback                       2.00       -0.00%       0.00     
1.00    3.00    2.00    0.32
innodb  insert_select_1_key                   4.00       +9.52%       0.42     
3.00    7.00    4.42    1.04
innodb  insert_select_2_keys                  6.00      +11.63%       0.79     
5.00   10.00    6.79    1.79
innodb  min_max                               8.00       -1.33%      -0.11     
6.00   10.00    7.89    1.17
innodb  min_max_on_key                       25.00       -1.93%      -0.47    
24.00   25.00   24.53    0.50
innodb  multiple_value_insert                 7.00      -12.71%      -0.79     
4.00    7.00    6.21    1.00
innodb  once_prepared_select                 29.00       +1.43%       0.42    
29.00   30.00   29.42    0.49
innodb  order_by_big                         16.00       -8.96%      -1.32    
13.00   16.00   14.68    1.08
innodb  order_by_big_key                     14.00       +3.97%       0.58    
12.00   17.00   14.58    1.46
innodb  order_by_big_key2                    13.00       -0.41%      -0.05    
12.00   15.00   12.95    0.83
innodb  order_by_big_key_desc                13.00      +15.41%       2.37    
13.00   17.00   15.37    1.31
innodb  order_by_big_key_diff                14.00       -5.14%      -0.68    
11.00   15.00   13.32    0.98
innodb  order_by_big_key_prefix              13.00       +4.63%       0.63    
13.00   15.00   13.63    0.67
innodb  order_by_key2_diff                    1.00      +26.92%       0.37     
1.00    2.00    1.37    0.48
innodb  order_by_key_prefix                   1.00      -11.76%      -0.11     
0.00    1.00    0.89    0.31
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           23.00       -0.00%       0.00    
19.00   30.00   23.00    2.34
innodb  outer_join_found                     23.00       -2.82%      -0.63    
17.00   30.00   22.37    2.41
innodb  outer_join_not_found                 20.00       -2.70%      -0.53    
16.00   21.00   19.47    1.50
innodb  outer_join_on_key                    16.00       -4.47%      -0.68    
13.00   17.00   15.32    0.98
innodb  prepared_select                      37.00       +0.85%       0.32    
36.00   38.00   37.32    0.65
innodb  select_1_row                          3.00      +21.92%       0.84     
3.00    4.00    3.84    0.36
innodb  select_1_row_cache                    4.00      -22.58%      -0.74     
3.00    4.00    3.26    0.44
innodb  select_2_rows                         4.00       -2.70%      -0.11     
3.00    4.00    3.89    0.31
innodb  select_big                           12.00       +8.06%       1.05    
11.00   15.00   13.05    1.32
innodb  select_big_str                        2.00      -52.00%      -0.68     
1.00    2.00    1.32    0.46
innodb  select_cache                         64.00       -2.96%      -1.84    
57.00   67.00   62.16    2.92
innodb  select_cache2                        62.00       +1.34%       0.84    
56.00   69.00   62.84    3.22
innodb  select_column+column                  3.00      +20.83%       0.79     
3.00    4.00    3.79    0.41
innodb  select_diff_key                       1.00     -137.50%      -0.58     
0.00    1.00    0.42    0.49
innodb  select_distinct                       4.00       +6.17%       0.26     
4.00    5.00    4.26    0.44
innodb  select_group                         15.00      +11.76%       2.00    
15.00   19.00   17.00    1.52
innodb  select_group_when_MANY_tables        13.00      +31.58%       6.00    
11.00   49.00   19.00   13.29
innodb  select_join                           1.00      -46.15%      -0.32     
0.00    1.00    0.68    0.46
innodb  select_key                           64.00       -0.58%      -0.37    
63.00   65.00   63.63    0.58
innodb  select_key2                          70.00       +1.12%       0.79    
69.00   72.00   70.79    0.77
innodb  select_key2_return_key               68.00       +0.39%       0.26    
67.00   70.00   68.26    0.91
innodb  select_key2_return_prim              69.00       -0.00%       0.00    
67.00   71.00   69.00    0.92
innodb  select_key_prefix                    70.00       +0.82%       0.58    
70.00   72.00   70.58    0.75
innodb  select_key_prefix_join                5.00       +4.04%       0.21     
5.00    6.00    5.21    0.41
innodb  select_key_return_key                63.00       -0.67%      -0.42    
61.00   64.00   62.58    0.82
innodb  select_many_fields                   13.00       +1.59%       0.21    
13.00   14.00   13.21    0.41
innodb  select_range                         41.00       +4.42%       1.89    
39.00   47.00   42.89    2.57
innodb  select_range_key2                    10.00       -5.56%      -0.53     
8.00   10.00    9.47    0.60
innodb  select_range_prefix                   9.00       +1.16%       0.11     
8.00   10.00    9.11    0.55
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      -18.75%      -0.16     
0.00    1.00    0.84    0.36
innodb  update_autocommit                     4.00      +37.19%       2.37     
3.00   16.00    6.37    4.86
innodb  update_big                           65.00       +7.28%       5.11    
57.00  112.00   70.11   19.95
innodb  update_commit                         2.00      +42.42%       1.47     
1.00   10.00    3.47    3.00
innodb  update_of_key                        23.00       -0.92%      -0.21    
21.00   25.00   22.79    1.10
innodb  update_of_key_big                    37.00       +7.01%       2.79    
29.00   58.00   39.79    7.16
innodb  update_of_primary_key_many_keys    1513.00      -21.66%    -269.37   
688.00 1513.00 1243.63  276.77
innodb  update_rollback                       2.00      +73.79%       5.63     
2.00   31.00    7.63   10.68
innodb  update_with_key                     122.00       -0.65%      -0.79   
118.00  127.00  121.21    2.26
innodb  update_with_key_prefix               45.00       -3.64%      -1.58    
40.00   47.00   43.42    1.73
innodb  wisc_benchmark                        3.00       -9.62%      -0.26     
2.00    3.00    2.74    0.44

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00      -64.02%     -12.49    
11.00   61.00   19.51    9.77
innodb  alter_table_drop                     26.00      -47.36%      -8.36    
10.00   57.00   17.64    7.08
innodb  connect                               2.00       +3.31%       0.07     
1.00    3.00    2.07    0.42
innodb  connect+select_1_row                  3.00      -12.22%      -0.33     
2.00    5.00    2.67    0.49
innodb  connect+select_simple                 3.00      -29.97%      -0.69     
1.00    3.00    2.31    0.47
innodb  count                                18.00      -14.40%      -2.27    
12.00  193.00   15.73    9.37
innodb  count_distinct                        8.00      -22.41%      -1.46     
5.00   50.00    6.54    2.40
innodb  count_distinct_2                     16.00      -22.21%      -2.91    
11.00   63.00   13.09    3.10
innodb  count_distinct_big                   23.00       -5.49%      -1.20     
5.00   67.00   21.80    3.12
innodb  count_distinct_group                 16.00      -23.43%      -3.04    
10.00   68.00   12.96    3.23
innodb  count_distinct_group_on_key           9.00       +4.53%       0.43     
7.00   69.00    9.43    3.17
innodb  count_distinct_group_on_key_parts    14.00      -14.87%      -1.81     
9.00   72.00   12.19    3.30
innodb  count_distinct_key_prefix             5.00       +1.84%       0.09     
3.00   52.00    5.09    2.53
innodb  count_group_on_key_parts             11.00      -11.99%      -1.18     
7.00   72.00    9.82    3.32
innodb  count_on_key                         94.00      -10.81%      -9.17    
68.00  107.00   84.83    7.04
innodb  create+drop                          32.00       +1.44%       0.47    
18.00   75.00   32.47   12.66
innodb  create_index                          3.00       -5.42%      -0.15     
1.00    8.00    2.85    1.19
innodb  create_key+drop                      28.00       +0.00%       0.00    
21.00   50.00   28.00    5.17
innodb  create_MANY_tables                   21.00      +41.49%      14.89    
14.00  121.00   35.89   17.41
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.37
innodb  delete_all_many_keys                739.00      -69.02%    -301.79   
212.00 1888.00  437.21  381.94
innodb  delete_autocommit                     3.00      +12.13%       0.41     
2.00   14.00    3.41    0.77
innodb  delete_big                            0.00     +100.00%       0.26     
0.00    3.00    0.26    0.45
innodb  delete_big_many_keys                737.00      -65.83%    -292.58   
212.00 2293.00  444.42  397.88
innodb  delete_commit                         2.00      -36.21%      -0.53     
1.00    5.00    1.47    0.53
innodb  delete_key                            3.00       +2.95%       0.09     
2.00   35.00    3.09    1.58
innodb  delete_range                          9.00       -8.96%      -0.74     
5.00   23.00    8.26    3.43
innodb  delete_rollback                       2.00      -18.53%      -0.31     
1.00   12.00    1.69    0.96
innodb  drop_index                            3.00       -2.29%      -0.07     
1.00    9.00    2.93    1.40
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    2.00    0.05    0.24
innodb  drop_table_when_MANY_tables          17.00      +14.75%       2.94    
11.00   90.00   19.94    7.93
innodb  insert                              113.00       -6.88%      -7.27     
3.00  343.00  105.73   15.28
innodb  insert_autocommit                     3.00       -1.16%      -0.03     
2.00   99.00    2.97    3.53
innodb  insert_commit                         2.00      -51.45%      -0.68     
1.00    3.00    1.32    0.48
innodb  insert_duplicates                    19.00      -26.98%      -4.04    
11.00   21.00   14.96    2.42
innodb  insert_key                          304.00       +0.80%       2.44   
142.00  700.00  306.44  114.42
innodb  insert_many_fields                    6.00       -7.51%      -0.42     
3.00   17.00    5.58    1.87
innodb  insert_rollback                       2.00      -23.15%      -0.38     
1.00    3.00    1.62    0.55
innodb  insert_select_1_key                   4.00       -6.06%      -0.23     
2.00   10.00    3.77    0.92
innodb  insert_select_2_keys                  6.00       +0.79%       0.05     
4.00   16.00    6.05    2.21
innodb  min_max                               8.00       -2.40%      -0.19     
6.00  110.00    7.81    4.83
innodb  min_max_on_key                       25.00      -25.07%      -5.01    
14.00   37.00   19.99    2.87
innodb  multiple_value_insert                 7.00      -31.82%      -1.69     
2.00   50.00    5.31    4.54
innodb  once_prepared_select                 29.00      -23.21%      -5.46    
18.00   32.00   23.54    3.27
innodb  order_by_big                         16.00      -12.07%      -1.72    
12.00   31.00   14.28    1.57
innodb  order_by_big_key                     14.00       -6.61%      -0.87    
11.00   32.00   13.13    1.63
innodb  order_by_big_key2                    13.00       -7.66%      -0.92    
10.00   33.00   12.08    1.57
innodb  order_by_big_key_desc                13.00       +2.02%       0.27    
11.00   32.00   13.27    1.62
innodb  order_by_big_key_diff                14.00      -15.64%      -1.89    
10.00   31.00   12.11    1.53
innodb  order_by_big_key_prefix              13.00       -5.97%      -0.73    
10.00   32.00   12.27    1.60
innodb  order_by_key2_diff                    1.00      +28.38%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -27.44%      -0.22     
0.00    2.00    0.78    0.42
innodb  order_by_range                        1.00      -22.69%      -0.18     
0.00    2.00    0.82    0.39
innodb  outer_join                           23.00      -20.98%      -3.99    
15.00   61.00   19.01    3.73
innodb  outer_join_found                     23.00      -24.48%      -4.52    
14.00   58.00   18.48    3.60
innodb  outer_join_not_found                 20.00      -23.83%      -3.85    
12.00   46.00   16.15    3.15
innodb  outer_join_on_key                    16.00      -26.29%      -3.33    
10.00   59.00   12.67    2.79
innodb  prepared_select                      37.00      -21.25%      -6.48    
22.00   40.00   30.52    4.21
innodb  select_1_row                          3.00       -8.90%      -0.25     
2.00    4.00    2.75    0.66
innodb  select_1_row_cache                    4.00      -55.53%      -1.43     
2.00    4.00    2.57    0.63
innodb  select_2_rows                         4.00      -44.23%      -1.23     
2.00    4.00    2.77    0.66
innodb  select_big                           12.00       +0.34%       0.04     
0.00   31.00   12.04    1.57
innodb  select_big_str                        2.00      -75.48%      -0.86     
0.00    2.00    1.14    0.35
innodb  select_cache                         64.00       -8.33%      -4.92    
49.00   77.00   59.08    5.62
innodb  select_cache2                        62.00       -4.08%      -2.43    
49.00   73.00   59.57    6.47
innodb  select_column+column                  3.00       -6.80%      -0.19     
2.00    4.00    2.81    0.67
innodb  select_diff_key                       1.00     -376.10%      -0.79     
0.00    1.00    0.21    0.41
innodb  select_distinct                       4.00       +4.68%       0.20     
3.00    8.00    4.20    0.54
innodb  select_group                         15.00       +7.16%       1.16     
4.00  136.00   16.16    5.76
innodb  select_group_when_MANY_tables        13.00      -42.67%      -3.89     
3.00   49.00    9.11   10.02
innodb  select_join                           1.00      -76.92%      -0.43     
0.00    1.00    0.57    0.50
innodb  select_key                           64.00      -24.88%     -12.75    
40.00   66.00   51.25    6.66
innodb  select_key2                          70.00      -20.95%     -12.13    
45.00   75.00   57.87    7.61
innodb  select_key2_return_key               68.00      -23.20%     -12.80    
42.00   70.00   55.20    7.35
innodb  select_key2_return_prim              69.00      -23.35%     -13.06    
42.00   72.00   55.94    7.50
innodb  select_key_prefix                    70.00      -22.64%     -12.92    
44.00   75.00   57.08    7.55
innodb  select_key_prefix_join                5.00       -7.29%      -0.34     
3.00   10.00    4.66    0.66
innodb  select_key_return_key                63.00      -25.32%     -12.73    
38.00   65.00   50.27    6.66
innodb  select_many_fields                   13.00      +14.36%       2.18    
11.00   19.00   15.18    1.78
innodb  select_range                         41.00      +14.04%       6.69    
39.00   76.00   47.69    3.73
innodb  select_range_key2                    10.00      -23.63%      -1.91     
6.00   10.00    8.09    0.98
innodb  select_range_prefix                   9.00      -17.73%      -1.36     
5.00   10.00    7.64    1.02
innodb  select_simple                         2.00      -25.35%      -0.40     
1.00    3.00    1.60    0.52
innodb  select_simple_cache                   2.00      -34.10%      -0.51     
1.00    3.00    1.49    0.52
innodb  select_simple_join                    1.00      -55.21%      -0.36     
0.00    3.00    0.64    0.49
innodb  update_autocommit                     4.00      -21.82%      -0.72     
2.00   16.00    3.28    1.06
innodb  update_big                           65.00      -30.29%     -15.11    
31.00  195.00   49.89   25.89
innodb  update_commit                         2.00      -32.17%      -0.49     
1.00   10.00    1.51    0.76
innodb  update_of_key                        23.00       +6.05%       1.48    
18.00  100.00   24.48    6.53
innodb  update_of_key_big                    37.00      -40.80%     -10.72    
15.00   75.00   26.28   11.10
innodb  update_of_primary_key_many_keys    1513.00      -23.99%    -292.72   
647.00 6065.00 1220.28 1,042.14
innodb  update_rollback                       2.00      -16.35%      -0.28     
1.00   31.00    1.72    2.02
innodb  update_with_key                     122.00      -12.76%     -13.81    
90.00  598.00  108.19   21.62
innodb  update_with_key_prefix               45.00      -15.39%      -6.00    
33.00  202.00   39.00    6.99
innodb  wisc_benchmark                        3.00      -21.60%      -0.53     
2.00    5.00    2.47    0.53

=========================================================================================================================

_______________________________________________
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