=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   839
RUN DATE: 2011-01-23T16:38:04.003456
SERVER:   drizzled
VERSION:  staging
REVISION: 2106
COMMENT:  2106: Brian Aker 2011-01-23 Additional fix for lcov.

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      31.00       +1.90%       0.60    
30.00   33.00   31.60    1.02
innodb  alter_table_drop                     25.00       -4.17%      -1.00    
23.00   25.00   24.00    0.63
innodb  connect                               2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  connect+select_1_row                  2.00      +28.57%       0.80     
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                                17.00      -14.86%      -2.20    
13.00   18.00   14.80    2.23
innodb  count_distinct                        7.00       +2.78%       0.20     
6.00    8.00    7.20    0.75
innodb  count_distinct_2                     13.00       +7.14%       1.00    
12.00   16.00   14.00    1.41
innodb  count_distinct_big                   25.00      -10.62%      -2.40    
20.00   25.00   22.60    1.85
innodb  count_distinct_group                 16.00       -5.26%      -0.80    
14.00   16.00   15.20    0.75
innodb  count_distinct_group_on_key          11.00      -17.02%      -1.60     
8.00   11.00    9.40    1.20
innodb  count_distinct_group_on_key_parts    15.00      -15.38%      -2.00    
11.00   15.00   13.00    1.41
innodb  count_distinct_key_prefix             7.00      -25.00%      -1.40     
5.00    7.00    5.60    0.80
innodb  count_group_on_key_parts             12.00       -7.14%      -0.80    
11.00   12.00   11.20    0.40
innodb  count_on_key                        103.00       -5.97%      -5.80    
92.00  103.00   97.20    3.87
innodb  create+drop                          31.00       +2.52%       0.80    
31.00   33.00   31.80    0.75
innodb  create_index                          3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  create_key+drop                      29.00       +1.36%       0.40    
29.00   30.00   29.40    0.49
innodb  create_MANY_tables                   20.00       -1.01%      -0.20    
19.00   20.00   19.80    0.40
innodb  create_table                          0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_all_many_keys                645.00       +0.43%       2.80   
634.00  664.00  647.80   10.32
innodb  delete_autocommit                     3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  delete_big                            1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  delete_big_many_keys                644.00       +0.43%       2.80   
633.00  663.00  646.80   10.32
innodb  delete_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  delete_key                            3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  delete_range                          9.00       -2.27%      -0.20     
8.00    9.00    8.80    0.40
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            4.00      -25.00%      -0.80     
3.00    4.00    3.20    0.40
innodb  drop_table_when_MANY_tables          16.00       -5.26%      -0.80    
14.00   16.00   15.20    0.75
innodb  insert                              113.00       +0.53%       0.60   
112.00  115.00  113.60    1.20
innodb  insert_autocommit                     3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  insert_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  insert_duplicates                    19.00       +1.04%       0.20    
19.00   20.00   19.20    0.40
innodb  insert_key                          278.00       -0.22%      -0.60   
274.00  280.00  277.40    2.15
innodb  insert_many_fields                    5.00      +13.79%       0.80     
5.00    7.00    5.80    0.75
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  insert_select_2_keys                  6.00       +9.09%       0.60     
6.00    7.00    6.60    0.49
innodb  min_max                               7.00       +2.78%       0.20     
7.00    8.00    7.20    0.40
innodb  min_max_on_key                       25.00       -0.00%       0.00    
24.00   26.00   25.00    0.63
innodb  multiple_value_insert                 7.00       -2.94%      -0.20     
6.00    7.00    6.80    0.40
innodb  once_prepared_select                 29.00       +0.68%       0.20    
29.00   30.00   29.20    0.40
innodb  order_by_big                         15.00       -5.63%      -0.80    
13.00   15.00   14.20    0.98
innodb  order_by_big_key                     13.00       -0.00%       0.00    
13.00   13.00   13.00    0.00
innodb  order_by_big_key2                    13.00       -4.84%      -0.60    
12.00   13.00   12.40    0.49
innodb  order_by_big_key_desc                15.00       -2.74%      -0.40    
14.00   16.00   14.60    0.80
innodb  order_by_big_key_diff                13.00       -1.56%      -0.20    
12.00   13.00   12.80    0.40
innodb  order_by_big_key_prefix              14.00       -9.38%      -1.20    
12.00   14.00   12.80    0.75
innodb  order_by_key2_diff                    1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
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                           21.00       +7.08%       1.60    
21.00   24.00   22.60    1.36
innodb  outer_join_found                     17.00      +16.67%       3.40    
17.00   23.00   20.40    2.33
innodb  outer_join_not_found                 15.00      +17.58%       3.20    
15.00   22.00   18.20    2.56
innodb  outer_join_on_key                    15.00       +3.85%       0.60    
14.00   17.00   15.60    1.02
innodb  prepared_select                      37.00       -0.00%       0.00    
37.00   37.00   37.00    0.00
innodb  select_1_row                          4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_1_row_cache                    3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  select_2_rows                         4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_big                           13.00       -3.17%      -0.40    
12.00   13.00   12.60    0.49
innodb  select_big_str                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  select_cache                         65.00       -0.93%      -0.60    
62.00   67.00   64.40    1.74
innodb  select_cache2                        70.00      -12.18%      -7.60    
58.00   70.00   62.40    4.13
innodb  select_column+column                  4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_diff_key                       0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  select_distinct                       4.00      +16.67%       0.80     
4.00    5.00    4.80    0.40
innodb  select_group                         16.00       +3.61%       0.60    
15.00   19.00   16.60    1.36
innodb  select_group_when_MANY_tables        13.00      -10.17%      -1.20    
11.00   13.00   11.80    0.75
innodb  select_join                           1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  select_key                           63.00       +1.25%       0.80    
63.00   65.00   63.80    0.75
innodb  select_key2                          70.00       +0.85%       0.60    
70.00   71.00   70.60    0.49
innodb  select_key2_return_key               68.00       -0.00%       0.00    
67.00   69.00   68.00    0.63
innodb  select_key2_return_prim              69.00       +0.58%       0.40    
69.00   70.00   69.40    0.49
innodb  select_key_prefix                    70.00       +0.28%       0.20    
69.00   72.00   70.20    0.98
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       -0.00%       0.00    
62.00   64.00   63.00    0.63
innodb  select_many_fields                   14.00       -2.94%      -0.40    
13.00   14.00   13.60    0.49
innodb  select_range                         41.00       +5.53%       2.40    
41.00   46.00   43.40    1.62
innodb  select_range_key2                     9.00       +2.17%       0.20     
9.00   10.00    9.20    0.40
innodb  select_range_prefix                   9.00       -0.00%       0.00     
8.00   10.00    9.00    0.63
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  update_autocommit                     4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  update_big                           58.00       +1.36%       0.80    
57.00   61.00   58.80    1.47
innodb  update_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  update_of_key                        24.00       -4.35%      -1.00    
22.00   24.00   23.00    0.89
innodb  update_of_key_big                    38.00       -7.95%      -2.80    
32.00   38.00   35.20    2.48
innodb  update_of_primary_key_many_keys    1340.00       -0.37%      -5.00  
1311.00 1356.00 1335.00   15.11
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     123.00       -0.49%      -0.60   
120.00  125.00  122.40    1.74
innodb  update_with_key_prefix               42.00       +4.98%       2.20    
42.00   47.00   44.20    1.94
innodb  wisc_benchmark                        2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      31.00       +5.46%       1.79    
30.00   34.00   32.79    1.15
innodb  alter_table_drop                     25.00       -1.50%      -0.37    
23.00   27.00   24.63    0.93
innodb  connect                               2.00       +9.52%       0.21     
2.00    3.00    2.21    0.41
innodb  connect+select_1_row                  2.00      +32.14%       0.95     
2.00    3.00    2.95    0.22
innodb  connect+select_simple                 3.00      -11.76%      -0.32     
2.00    3.00    2.68    0.46
innodb  count                                17.00       -8.03%      -1.26    
13.00   18.00   15.74    2.10
innodb  count_distinct                        7.00       +2.21%       0.16     
6.00    8.00    7.16    0.74
innodb  count_distinct_2                     13.00       +8.18%       1.16    
12.00   16.00   14.16    1.39
innodb  count_distinct_big                   25.00       -9.45%      -2.16    
20.00   25.00   22.84    1.87
innodb  count_distinct_group                 16.00       -5.19%      -0.79    
12.00   24.00   15.21    2.37
innodb  count_distinct_group_on_key          11.00      -11.76%      -1.16     
8.00   11.00    9.84    0.99
innodb  count_distinct_group_on_key_parts    15.00      -10.47%      -1.42    
11.00   19.00   13.58    1.73
innodb  count_distinct_key_prefix             7.00      -22.02%      -1.26     
5.00    7.00    5.74    0.64
innodb  count_group_on_key_parts             12.00       -7.55%      -0.84    
10.00   12.00   11.16    0.49
innodb  count_on_key                        103.00       -7.59%      -7.26    
92.00  103.00   95.74    3.08
innodb  create+drop                          31.00       +8.54%       2.89    
31.00   42.00   33.89    4.22
innodb  create_index                          3.00       +5.00%       0.16     
3.00    4.00    3.16    0.36
innodb  create_key+drop                      29.00      +11.84%       3.89    
27.00   49.00   32.89    7.61
innodb  create_MANY_tables                   20.00      +30.15%       8.63    
19.00   62.00   28.63   16.27
innodb  create_table                          0.00     +100.00%       0.11     
0.00    1.00    0.11    0.31
innodb  delete_all_many_keys                645.00      -10.38%     -60.63   
281.00  749.00  584.37  157.42
innodb  delete_autocommit                     3.00      +16.18%       0.58     
3.00    4.00    3.58    0.49
innodb  delete_big                            1.00     -137.50%      -0.58     
0.00    1.00    0.42    0.49
innodb  delete_big_many_keys                644.00      -10.35%     -60.42   
281.00  748.00  583.58  156.99
innodb  delete_commit                         2.00      -11.76%      -0.21     
1.00    2.00    1.79    0.41
innodb  delete_key                            3.00       -5.56%      -0.16     
2.00    3.00    2.84    0.36
innodb  delete_range                          9.00       -9.62%      -0.79     
6.00   10.00    8.21    0.89
innodb  delete_rollback                       2.00      +52.50%       2.21     
2.00   12.00    4.21    4.03
innodb  drop_index                            4.00      -26.67%      -0.84     
3.00    4.00    3.16    0.36
innodb  drop_table_when_MANY_tables          16.00      +45.91%      13.58    
14.00   90.00   29.58   26.51
innodb  insert                              113.00       +2.45%       2.84   
112.00  125.00  115.84    4.58
innodb  insert_autocommit                     3.00      +13.64%       0.47     
3.00    5.00    3.47    0.60
innodb  insert_commit                         2.00       -8.57%      -0.16     
1.00    3.00    1.84    0.49
innodb  insert_duplicates                    19.00       +0.55%       0.11    
18.00   20.00   19.11    0.45
innodb  insert_key                          278.00      +12.19%      38.58   
274.00  445.00  316.58   62.29
innodb  insert_many_fields                    5.00      +15.18%       0.89     
5.00    7.00    5.89    0.55
innodb  insert_rollback                       2.00       +2.56%       0.05     
2.00    3.00    2.05    0.22
innodb  insert_select_1_key                   4.00       +6.17%       0.26     
3.00    7.00    4.26    1.16
innodb  insert_select_2_keys                  6.00      +14.93%       1.05     
5.00   10.00    7.05    1.61
innodb  min_max                               7.00       +9.52%       0.74     
6.00    9.00    7.74    0.96
innodb  min_max_on_key                       25.00       -1.06%      -0.26    
24.00   26.00   24.74    0.64
innodb  multiple_value_insert                 7.00      -11.76%      -0.74     
4.00    7.00    6.26    1.02
innodb  once_prepared_select                 29.00       +0.72%       0.21    
29.00   30.00   29.21    0.41
innodb  order_by_big                         15.00       -4.01%      -0.58    
13.00   16.00   14.42    1.14
innodb  order_by_big_key                     13.00       +8.86%       1.26    
13.00   17.00   14.26    1.41
innodb  order_by_big_key2                    13.00       -2.92%      -0.37    
11.00   14.00   12.63    0.87
innodb  order_by_big_key_desc                15.00       -0.00%       0.00    
13.00   17.00   15.00    1.21
innodb  order_by_big_key_diff                13.00       +1.98%       0.26    
12.00   15.00   13.26    0.85
innodb  order_by_big_key_prefix              14.00       -5.98%      -0.79    
12.00   15.00   13.21    0.83
innodb  order_by_key2_diff                    1.00      +20.83%       0.26     
1.00    2.00    1.26    0.44
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                           21.00       +6.56%       1.47    
18.00   25.00   22.47    1.79
innodb  outer_join_found                     17.00      +20.44%       4.37    
17.00   23.00   21.37    1.98
innodb  outer_join_not_found                 15.00      +21.05%       4.00    
15.00   22.00   19.00    1.92
innodb  outer_join_on_key                    15.00       +3.06%       0.47    
12.00   17.00   15.47    1.31
innodb  prepared_select                      37.00       +0.42%       0.16    
36.00   38.00   37.16    0.49
innodb  select_1_row                          4.00       -8.57%      -0.32     
3.00    4.00    3.68    0.46
innodb  select_1_row_cache                    3.00       +9.52%       0.32     
3.00    4.00    3.32    0.46
innodb  select_2_rows                         4.00       -7.04%      -0.26     
3.00    4.00    3.74    0.44
innodb  select_big                           13.00       -0.82%      -0.11    
11.00   15.00   12.89    1.07
innodb  select_big_str                        1.00      +24.00%       0.32     
1.00    2.00    1.32    0.46
innodb  select_cache                         65.00       -0.73%      -0.47    
57.00   76.00   64.53    4.46
innodb  select_cache2                        70.00      -10.47%      -6.63    
58.00   75.00   63.37    5.00
innodb  select_column+column                  4.00       -4.11%      -0.16     
3.00    4.00    3.84    0.36
innodb  select_diff_key                       0.00     +100.00%       0.42     
0.00    1.00    0.42    0.49
innodb  select_distinct                       4.00      +13.64%       0.63     
4.00    5.00    4.63    0.48
innodb  select_group                         16.00       +3.80%       0.63    
15.00   19.00   16.63    1.46
innodb  select_group_when_MANY_tables        13.00      +31.77%       6.05    
11.00   49.00   19.05   13.26
innodb  select_join                           1.00      -46.15%      -0.32     
0.00    1.00    0.68    0.46
innodb  select_key                           63.00       +1.07%       0.68    
63.00   65.00   63.68    0.57
innodb  select_key2                          70.00       +0.89%       0.63    
69.00   72.00   70.63    0.81
innodb  select_key2_return_key               68.00       -0.00%       0.00    
67.00   69.00   68.00    0.65
innodb  select_key2_return_prim              69.00       -0.15%      -0.11    
67.00   70.00   68.89    0.91
innodb  select_key_prefix                    70.00       +0.45%       0.32    
69.00   72.00   70.32    0.73
innodb  select_key_prefix_join                5.00       +2.06%       0.11     
5.00    6.00    5.11    0.31
innodb  select_key_return_key                63.00       -0.42%      -0.26    
62.00   64.00   62.74    0.64
innodb  select_many_fields                   14.00       -5.56%      -0.74    
13.00   14.00   13.26    0.44
innodb  select_range                         41.00       +3.47%       1.47    
39.00   46.00   42.47    2.16
innodb  select_range_key2                     9.00       +3.93%       0.37     
9.00   10.00    9.37    0.48
innodb  select_range_prefix                   9.00       +2.29%       0.21     
8.00   10.00    9.21    0.61
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      -46.15%      -0.32     
0.00    1.00    0.68    0.46
innodb  update_autocommit                     4.00      +36.67%       2.32     
3.00   16.00    6.32    4.89
innodb  update_big                           58.00      +16.77%      11.68    
57.00  112.00   69.68   20.18
innodb  update_commit                         2.00      +40.62%       1.37     
1.00   10.00    3.37    3.06
innodb  update_of_key                        24.00       -3.87%      -0.89    
21.00   25.00   23.11    1.17
innodb  update_of_key_big                    38.00       +1.63%       0.63    
29.00   58.00   38.63    7.97
innodb  update_of_primary_key_many_keys    1340.00       -8.67%    -106.89   
688.00 1513.00 1233.11  270.54
innodb  update_rollback                       2.00      +73.43%       5.53     
2.00   31.00    7.53   10.73
innodb  update_with_key                     123.00       -0.60%      -0.74   
119.00  125.00  122.26    1.65
innodb  update_with_key_prefix               42.00       +5.45%       2.42    
41.00   50.00   44.42    2.32
innodb  wisc_benchmark                        2.00      +20.83%       0.53     
2.00    3.00    2.53    0.50

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      31.00      -57.12%     -11.27    
11.00   61.00   19.73    9.83
innodb  alter_table_drop                     25.00      -40.79%      -7.24    
10.00   57.00   17.76    7.07
innodb  connect                               2.00       +3.38%       0.07     
1.00    3.00    2.07    0.42
innodb  connect+select_1_row                  2.00      +25.30%       0.68     
2.00    5.00    2.68    0.48
innodb  connect+select_simple                 3.00      -29.46%      -0.68     
1.00    3.00    2.32    0.47
innodb  count                                17.00       -8.03%      -1.26    
12.00  193.00   15.74    9.29
innodb  count_distinct                        7.00       -6.87%      -0.45     
5.00   50.00    6.55    2.39
innodb  count_distinct_2                     13.00       +0.85%       0.11    
11.00   63.00   13.11    3.08
innodb  count_distinct_big                   25.00      -14.55%      -3.18     
5.00   67.00   21.82    3.11
innodb  count_distinct_group                 16.00      -23.14%      -3.01    
10.00   68.00   12.99    3.21
innodb  count_distinct_group_on_key          11.00      -16.56%      -1.56     
7.00   69.00    9.44    3.14
innodb  count_distinct_group_on_key_parts    15.00      -22.86%      -2.79     
9.00   72.00   12.21    3.28
innodb  count_distinct_key_prefix             7.00      -37.12%      -1.89     
3.00   52.00    5.11    2.51
innodb  count_group_on_key_parts             12.00      -21.88%      -2.15     
7.00   72.00    9.85    3.30
innodb  count_on_key                        103.00      -21.16%     -17.99    
68.00  107.00   85.01    7.13
innodb  create+drop                          31.00       +4.48%       1.45    
18.00   75.00   32.45   12.55
innodb  create_index                          3.00       -5.27%      -0.15     
1.00    8.00    2.85    1.19
innodb  create_key+drop                      29.00       -3.49%      -0.98    
21.00   50.00   28.02    5.13
innodb  create_MANY_tables                   20.00      +43.86%      15.63    
14.00  121.00   35.63   17.38
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.37
innodb  delete_all_many_keys                645.00      -46.22%    -203.88   
212.00 1888.00  441.12  379.67
innodb  delete_autocommit                     3.00      +12.22%       0.42     
2.00   14.00    3.42    0.77
innodb  delete_big                            1.00     -274.27%      -0.73     
0.00    3.00    0.27    0.46
innodb  delete_big_many_keys                644.00      -43.70%    -195.83   
212.00 2293.00  448.17  395.36
innodb  delete_commit                         2.00      -35.74%      -0.53     
1.00    5.00    1.47    0.53
innodb  delete_key                            3.00       +2.82%       0.09     
2.00   35.00    3.09    1.57
innodb  delete_range                          9.00       -8.91%      -0.74     
5.00   23.00    8.26    3.41
innodb  delete_rollback                       2.00      -17.98%      -0.30     
1.00   12.00    1.70    0.95
innodb  drop_index                            4.00      -36.28%      -1.06     
1.00    9.00    2.94    1.38
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    2.00    0.05    0.24
innodb  drop_table_when_MANY_tables          16.00      +19.49%       3.87    
11.00   90.00   19.87    7.88
innodb  insert                              113.00       -6.75%      -7.14     
3.00  343.00  105.86   15.18
innodb  insert_autocommit                     3.00       -1.00%      -0.03     
2.00   99.00    2.97    3.50
innodb  insert_commit                         2.00      -50.59%      -0.67     
1.00    3.00    1.33    0.48
innodb  insert_duplicates                    19.00      -26.37%      -3.96    
11.00   21.00   15.04    2.47
innodb  insert_key                          278.00       +9.14%      27.98   
142.00  700.00  305.98  113.39
innodb  insert_many_fields                    5.00      +10.46%       0.58     
3.00   17.00    5.58    1.86
innodb  insert_rollback                       2.00      -22.67%      -0.37     
1.00    3.00    1.63    0.54
innodb  insert_select_1_key                   4.00       -6.10%      -0.23     
2.00   10.00    3.77    0.92
innodb  insert_select_2_keys                  6.00       +0.86%       0.05     
4.00   16.00    6.05    2.20
innodb  min_max                               7.00      +10.42%       0.81     
6.00  110.00    7.81    4.79
innodb  min_max_on_key                       25.00      -24.56%      -4.93    
14.00   37.00   20.07    2.91
innodb  multiple_value_insert                 7.00      -31.24%      -1.67     
2.00   50.00    5.33    4.50
innodb  once_prepared_select                 29.00      -22.71%      -5.37    
18.00   32.00   23.63    3.33
innodb  order_by_big                         15.00       -5.06%      -0.72    
12.00   31.00   14.28    1.57
innodb  order_by_big_key                     13.00       +1.09%       0.14    
11.00   32.00   13.14    1.63
innodb  order_by_big_key2                    13.00       -7.58%      -0.92    
10.00   33.00   12.08    1.57
innodb  order_by_big_key_desc                15.00      -12.83%      -1.71    
11.00   32.00   13.29    1.62
innodb  order_by_big_key_diff                13.00       -7.20%      -0.87    
10.00   31.00   12.13    1.53
innodb  order_by_big_key_prefix              14.00      -13.98%      -1.72    
10.00   32.00   12.28    1.59
innodb  order_by_key2_diff                    1.00      +28.31%       0.39     
1.00    3.00    1.39    0.49
innodb  order_by_key_prefix                   1.00      -27.27%      -0.21     
0.00    2.00    0.79    0.42
innodb  order_by_range                        1.00      -22.22%      -0.18     
0.00    2.00    0.82    0.39
innodb  outer_join                           21.00      -10.11%      -1.93    
15.00   61.00   19.07    3.74
innodb  outer_join_found                     17.00       +8.22%       1.52    
14.00   58.00   18.52    3.60
innodb  outer_join_not_found                 15.00       +7.39%       1.20    
12.00   46.00   16.20    3.15
innodb  outer_join_on_key                    15.00      -17.95%      -2.28    
10.00   59.00   12.72    2.80
innodb  prepared_select                      37.00      -20.82%      -6.38    
22.00   40.00   30.62    4.25
innodb  select_1_row                          4.00      -44.43%      -1.23     
2.00    4.00    2.77    0.66
innodb  select_1_row_cache                    3.00      -16.03%      -0.41     
2.00    4.00    2.59    0.64
innodb  select_2_rows                         4.00      -43.49%      -1.21     
2.00    4.00    2.79    0.67
innodb  select_big                           13.00       -7.82%      -0.94     
0.00   31.00   12.06    1.57
innodb  select_big_str                        1.00      +12.38%       0.14     
0.00    2.00    1.14    0.35
innodb  select_cache                         65.00       -9.81%      -5.80    
49.00   77.00   59.20    5.67
innodb  select_cache2                        70.00      -17.34%     -10.35    
49.00   75.00   59.65    6.49
innodb  select_column+column                  4.00      -41.52%      -1.17     
2.00    4.00    2.83    0.68
innodb  select_diff_key                       0.00     +100.00%       0.21     
0.00    1.00    0.21    0.41
innodb  select_distinct                       4.00       +4.90%       0.21     
3.00    8.00    4.21    0.54
innodb  select_group                         16.00       +1.05%       0.17     
4.00  136.00   16.17    5.71
innodb  select_group_when_MANY_tables        13.00      -41.87%      -3.84     
3.00   49.00    9.16    9.95
innodb  select_join                           1.00      -76.26%      -0.43     
0.00    1.00    0.57    0.50
innodb  select_key                           63.00      -22.42%     -11.54    
40.00   66.00   51.46    6.80
innodb  select_key2                          70.00      -20.50%     -11.91    
45.00   75.00   58.09    7.72
innodb  select_key2_return_key               68.00      -22.71%     -12.59    
42.00   70.00   55.41    7.47
innodb  select_key2_return_prim              69.00      -22.86%     -12.84    
42.00   72.00   56.16    7.62
innodb  select_key_prefix                    70.00      -22.16%     -12.70    
44.00   75.00   57.30    7.68
innodb  select_key_prefix_join                5.00       -7.13%      -0.33     
3.00   10.00    4.67    0.66
innodb  select_key_return_key                63.00      -24.79%     -12.52    
38.00   65.00   50.48    6.80
innodb  select_many_fields                   14.00       +7.58%       1.15    
11.00   19.00   15.15    1.78
innodb  select_range                         41.00      +13.87%       6.60    
39.00   76.00   47.60    3.77
innodb  select_range_key2                     9.00      -10.99%      -0.89     
6.00   10.00    8.11    0.99
innodb  select_range_prefix                   9.00      -17.30%      -1.33     
5.00   10.00    7.67    1.04
innodb  select_simple                         2.00      -24.82%      -0.40     
1.00    3.00    1.60    0.52
innodb  select_simple_cache                   2.00      -33.33%      -0.50     
1.00    3.00    1.50    0.52
innodb  select_simple_join                    1.00      -55.33%      -0.36     
0.00    3.00    0.64    0.49
innodb  update_autocommit                     4.00      -21.51%      -0.71     
2.00   16.00    3.29    1.05
innodb  update_big                           58.00      -15.91%      -7.96    
31.00  195.00   50.04   25.70
innodb  update_commit                         2.00      -31.79%      -0.48     
1.00   10.00    1.52    0.75
innodb  update_of_key                        24.00       +1.85%       0.45    
18.00  100.00   24.45    6.48
innodb  update_of_key_big                    38.00      -43.78%     -11.57    
15.00   75.00   26.43   11.08
innodb  update_of_primary_key_many_keys    1340.00       -9.54%    -116.71   
647.00 6065.00 1223.29 1,030.55
innodb  update_rollback                       2.00      -16.03%      -0.28     
1.00   31.00    1.72    2.00
innodb  update_with_key                     123.00      -13.44%     -14.57    
90.00  598.00  108.43   21.51
innodb  update_with_key_prefix               42.00       -7.43%      -2.91    
33.00  202.00   39.09    6.97
innodb  wisc_benchmark                        2.00      +18.88%       0.47     
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