=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   823
RUN DATE: 2011-01-17T04:04:12.192087
SERVER:   drizzled
VERSION:  staging
REVISION: 2093
COMMENT:  2093: Brian Aker 2011-01-17 I'm not sure how this wasn't found in a 
previous build, it probably means a

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00       -0.76%      -0.25    
32.00   34.00   32.75    0.83
innodb  alter_table_drop                     25.00       +1.96%       0.50    
25.00   27.00   25.50    0.87
innodb  connect                               3.00       -9.09%      -0.25     
2.00    3.00    2.75    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                                18.00      -16.13%      -2.50    
14.00   18.00   15.50    1.66
innodb  count_distinct                        6.00       +7.69%       0.50     
6.00    7.00    6.50    0.50
innodb  count_distinct_2                     12.00      +11.11%       1.50    
12.00   15.00   13.50    1.50
innodb  count_distinct_big                   23.00       -2.22%      -0.50    
20.00   25.00   22.50    1.80
innodb  count_distinct_group                 15.00      +21.05%       4.00    
15.00   24.00   19.00    3.67
innodb  count_distinct_group_on_key          10.00       -0.00%       0.00     
9.00   11.00   10.00    0.71
innodb  count_distinct_group_on_key_parts    14.00      +20.00%       3.50    
12.00   25.00   17.50    5.02
innodb  count_distinct_key_prefix             5.00       +9.09%       0.50     
5.00    6.00    5.50    0.50
innodb  count_group_on_key_parts             11.00       -0.00%       0.00    
10.00   12.00   11.00    0.71
innodb  count_on_key                         95.00       +1.30%       1.25    
93.00  102.00   96.25    3.42
innodb  create+drop                          42.00       -5.66%      -2.25    
33.00   42.00   39.75    3.90
innodb  create_index                          3.00      +14.29%       0.50     
3.00    4.00    3.50    0.50
innodb  create_key+drop                      49.00      -15.29%      -6.50    
28.00   49.00   42.50    8.44
innodb  create_MANY_tables                   62.00      -25.25%     -12.50    
19.00   62.00   49.50   17.84
innodb  delete_all_many_keys                288.00      +23.66%      89.25   
281.00  648.00  377.25  156.37
innodb  delete_autocommit                     4.00      -23.08%      -0.75     
3.00    4.00    3.25    0.43
innodb  delete_big                            0.00     +100.00%       0.25     
0.00    1.00    0.25    0.43
innodb  delete_big_many_keys                288.00      +23.61%      89.00   
281.00  647.00  377.00  155.93
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       -9.09%      -0.25     
2.00    3.00    2.75    0.43
innodb  delete_range                          7.00      +12.50%       1.00     
7.00    9.00    8.00    0.71
innodb  delete_rollback                      12.00      -26.32%      -2.50     
2.00   12.00    9.50    4.33
innodb  drop_index                            4.00      -23.08%      -0.75     
2.00    4.00    3.25    0.83
innodb  drop_table_when_MANY_tables          90.00      -38.46%     -25.00    
15.00   90.00   65.00   29.67
innodb  insert                              125.00       -2.88%      -3.50   
111.00  125.00  121.50    6.06
innodb  insert_autocommit                     4.00       -0.00%       0.00     
3.00    5.00    4.00    0.71
innodb  insert_commit                         2.00      +11.11%       0.25     
2.00    3.00    2.25    0.43
innodb  insert_duplicates                    19.00       -0.00%       0.00    
18.00   20.00   19.00    0.71
innodb  insert_key                          427.00       -8.17%     -32.25   
275.00  445.00  394.75   69.45
innodb  insert_many_fields                    6.00       -0.00%       0.00     
6.00    6.00    6.00    0.00
innodb  insert_rollback                       3.00      -33.33%      -0.75     
2.00    3.00    2.25    0.43
innodb  insert_select_1_key                   6.00       -9.09%      -0.50     
4.00    6.00    5.50    0.87
innodb  insert_select_2_keys                 10.00      -14.29%      -1.25     
5.00   10.00    8.75    2.17
innodb  min_max                               9.00      -20.00%      -1.50     
7.00    9.00    7.50    0.87
innodb  min_max_on_key                       24.00       +2.04%       0.50    
24.00   25.00   24.50    0.50
innodb  multiple_value_insert                 5.00       -0.00%       0.00     
4.00    6.00    5.00    0.71
innodb  once_prepared_select                 29.00       +0.85%       0.25    
29.00   30.00   29.25    0.43
innodb  order_by_big                         13.00       +8.77%       1.25    
13.00   16.00   14.25    1.30
innodb  order_by_big_key                     16.00       -3.23%      -0.50    
13.00   17.00   15.50    1.50
innodb  order_by_big_key2                    12.00       +7.69%       1.00    
12.00   14.00   13.00    0.71
innodb  order_by_big_key_desc                17.00       -9.68%      -1.50    
14.00   17.00   15.50    1.12
innodb  order_by_big_key_diff                12.00       +9.43%       1.25    
12.00   14.00   13.25    0.83
innodb  order_by_big_key_prefix              14.00       -5.66%      -0.75    
13.00   14.00   13.25    0.43
innodb  order_by_key2_diff                    1.00      +33.33%       0.50     
1.00    2.00    1.50    0.50
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                           22.00       -1.15%      -0.25    
19.00   24.00   21.75    1.79
innodb  outer_join_found                     21.00       -0.00%       0.00    
19.00   22.00   21.00    1.22
innodb  outer_join_not_found                 19.00       -2.70%      -0.50    
16.00   20.00   18.50    1.50
innodb  outer_join_on_key                    14.00      +11.11%       1.75    
14.00   17.00   15.75    1.09
innodb  prepared_select                      38.00       -1.33%      -0.50    
36.00   38.00   37.50    0.87
innodb  select_1_row                          4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_1_row_cache                    3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  select_2_rows                         4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_big                           11.00       +8.33%       1.00    
11.00   13.00   12.00    0.71
innodb  select_big_str                        1.00      +20.00%       0.25     
1.00    2.00    1.25    0.43
innodb  select_cache                         57.00       +3.39%       2.00    
57.00   62.00   59.00    1.87
innodb  select_cache2                        59.00       +2.88%       1.75    
59.00   63.00   60.75    1.48
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.25     
0.00    1.00    0.25    0.43
innodb  select_distinct                       4.00       +5.88%       0.25     
4.00    5.00    4.25    0.43
innodb  select_group                         17.00       -3.03%      -0.50    
15.00   19.00   16.50    1.66
innodb  select_group_when_MANY_tables        49.00      -34.25%     -12.50    
12.00   49.00   36.50   14.60
innodb  select_join                           1.00     -300.00%      -0.75     
0.00    1.00    0.25    0.43
innodb  select_key                           63.00       +0.79%       0.50    
63.00   64.00   63.50    0.50
innodb  select_key2                          71.00       -0.35%      -0.25    
70.00   71.00   70.75    0.43
innodb  select_key2_return_key               68.00       -0.37%      -0.25    
67.00   69.00   67.75    0.83
innodb  select_key2_return_prim              68.00       +1.45%       1.00    
68.00   70.00   69.00    0.71
innodb  select_key_prefix                    70.00       +0.71%       0.50    
70.00   71.00   70.50    0.50
innodb  select_key_prefix_join                5.00       +9.09%       0.50     
5.00    6.00    5.50    0.50
innodb  select_key_return_key                62.00       +0.80%       0.50    
62.00   63.00   62.50    0.50
innodb  select_many_fields                   14.00       -5.66%      -0.75    
13.00   14.00   13.25    0.43
innodb  select_range                         45.00       -2.27%      -1.00    
41.00   46.00   44.00    1.87
innodb  select_range_key2                     9.00       +7.69%       0.75     
9.00   10.00    9.75    0.43
innodb  select_range_prefix                  10.00      -14.29%      -1.25     
8.00   10.00    8.75    0.83
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       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  update_autocommit                    16.00      -25.49%      -3.25     
4.00   16.00   12.75    5.07
innodb  update_big                          112.00      -16.97%     -16.25    
59.00  112.00   95.75   21.37
innodb  update_commit                         9.00      -24.14%      -1.75     
2.00    9.00    7.25    3.03
innodb  update_of_key                        25.00       -4.17%      -1.00    
23.00   25.00   24.00    0.71
innodb  update_of_key_big                    58.00      -21.47%     -10.25    
36.00   58.00   47.75    8.44
innodb  update_of_primary_key_many_keys     728.00      +16.54%     144.25   
688.00 1330.00  872.25  265.05
innodb  update_rollback                      28.00      -33.33%      -7.00     
2.00   28.00   21.00   10.98
innodb  update_with_key                     122.00       -0.00%       0.00   
118.00  124.00  122.00    2.45
innodb  update_with_key_prefix               44.00       -0.57%      -0.25    
43.00   45.00   43.75    0.83
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                      33.00       -2.79%      -0.89    
29.00   35.00   32.11    1.37
innodb  alter_table_drop                     25.00       -2.81%      -0.68    
23.00   27.00   24.32    0.98
innodb  connect                               3.00      -18.75%      -0.47     
2.00    3.00    2.53    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                 2.00      +15.56%       0.37     
2.00    3.00    2.37    0.48
innodb  count                                18.00       -8.57%      -1.42    
14.00   23.00   16.58    2.30
innodb  count_distinct                        6.00      +10.94%       0.74     
6.00    8.00    6.74    0.71
innodb  count_distinct_2                     12.00      +16.18%       2.32    
12.00   16.00   14.32    1.30
innodb  count_distinct_big                   23.00       -0.46%      -0.11    
20.00   25.00   22.89    1.77
innodb  count_distinct_group                 15.00      +10.38%       1.74    
13.00   24.00   16.74    3.23
innodb  count_distinct_group_on_key          10.00       +4.52%       0.47     
9.00   12.00   10.47    0.75
innodb  count_distinct_group_on_key_parts    14.00      +11.63%       1.84    
12.00   25.00   15.84    3.41
innodb  count_distinct_key_prefix             5.00      +10.38%       0.58     
4.00    7.00    5.58    0.67
innodb  count_group_on_key_parts             11.00       +1.42%       0.16    
10.00   12.00   11.16    0.59
innodb  count_on_key                         95.00       +0.44%       0.42    
92.00  102.00   95.42    2.28
innodb  create+drop                          42.00      -26.47%      -8.79    
30.00   42.00   33.21    3.91
innodb  create_index                          3.00       +6.56%       0.21     
2.00    4.00    3.21    0.61
innodb  create_key+drop                      49.00      -50.16%     -16.37    
28.00   49.00   32.63    6.51
innodb  create_MANY_tables                   62.00     -133.27%     -35.42    
19.00   62.00   26.58   14.41
innodb  create_table                          0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  delete_all_many_keys                288.00      +52.11%     313.32   
281.00  744.00  601.32  140.13
innodb  delete_autocommit                     4.00      -13.43%      -0.47     
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                288.00      +52.06%     312.74   
281.00  743.00  600.74  139.90
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                          7.00      +16.35%       1.37     
7.00    9.00    8.37    0.67
innodb  delete_rollback                      12.00     -230.43%      -8.37     
2.00   12.00    3.63    3.63
innodb  drop_index                            4.00      -22.58%      -0.74     
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          90.00     -229.48%     -62.68    
15.00   90.00   27.32   23.78
innodb  insert                              125.00       -8.00%      -9.26   
111.00  125.00  115.74    4.33
innodb  insert_autocommit                     4.00      -16.92%      -0.58     
3.00    5.00    3.42    0.59
innodb  insert_commit                         2.00      -11.76%      -0.21     
1.00    3.00    1.79    0.52
innodb  insert_duplicates                    19.00       +0.28%       0.05    
18.00   20.00   19.05    0.51
innodb  insert_key                          427.00      -39.18%    -120.21   
270.00  445.00  306.79   56.38
innodb  insert_many_fields                    6.00       -3.64%      -0.21     
5.00    6.00    5.79    0.41
innodb  insert_rollback                       3.00      -46.15%      -0.95     
1.00    3.00    2.05    0.39
innodb  insert_select_1_key                   6.00      -40.74%      -1.74     
3.00    6.00    4.26    0.91
innodb  insert_select_2_keys                 10.00      -50.79%      -3.37     
5.00   10.00    6.63    1.63
innodb  min_max                               9.00      -13.25%      -1.05     
7.00   10.00    7.95    1.10
innodb  min_max_on_key                       24.00       +1.94%       0.47    
24.00   25.00   24.47    0.50
innodb  multiple_value_insert                 5.00      +21.49%       1.37     
4.00    8.00    6.37    0.93
innodb  once_prepared_select                 29.00       +1.61%       0.47    
29.00   30.00   29.47    0.50
innodb  order_by_big                         13.00      +11.47%       1.68    
13.00   16.00   14.68    1.08
innodb  order_by_big_key                     16.00      -10.14%      -1.47    
12.00   17.00   14.53    1.50
innodb  order_by_big_key2                    12.00       +7.69%       1.00    
12.00   15.00   13.00    0.86
innodb  order_by_big_key_desc                17.00      -10.62%      -1.63    
13.00   17.00   15.37    1.13
innodb  order_by_big_key_diff                12.00       +9.52%       1.26    
11.00   15.00   13.26    0.96
innodb  order_by_big_key_prefix              14.00       -3.50%      -0.47    
12.00   15.00   13.53    0.75
innodb  order_by_key2_diff                    1.00      +29.63%       0.42     
1.00    2.00    1.42    0.49
innodb  order_by_key_prefix                   1.00      -18.75%      -0.16     
0.00    1.00    0.84    0.36
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           22.00       +1.88%       0.42    
18.00   30.00   22.42    2.78
innodb  outer_join_found                     21.00       +3.39%       0.74    
17.00   30.00   21.74    2.90
innodb  outer_join_not_found                 19.00       -0.00%       0.00    
15.00   21.00   19.00    1.89
innodb  outer_join_on_key                    14.00       +6.01%       0.89    
11.00   17.00   14.89    1.48
innodb  prepared_select                      38.00       -1.83%      -0.68    
36.00   38.00   37.32    0.65
innodb  select_1_row                          4.00       -5.56%      -0.21     
3.00    4.00    3.79    0.41
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       -4.11%      -0.16     
3.00    4.00    3.84    0.36
innodb  select_big                           11.00      +15.38%       2.00    
11.00   15.00   13.00    1.26
innodb  select_big_str                        1.00      +26.92%       0.37     
1.00    2.00    1.37    0.48
innodb  select_cache                         57.00       +8.61%       5.37    
57.00   70.00   62.37    3.34
innodb  select_cache2                        59.00       +6.74%       4.26    
56.00   69.00   63.26    3.35
innodb  select_column+column                  4.00       -7.04%      -0.26     
3.00    4.00    3.74    0.44
innodb  select_diff_key                       0.00     +100.00%       0.26     
0.00    1.00    0.26    0.44
innodb  select_distinct                       4.00       +7.32%       0.32     
4.00    5.00    4.32    0.46
innodb  select_group                         17.00       +0.62%       0.11    
15.00   19.00   17.11    1.52
innodb  select_group_when_MANY_tables        49.00     -183.84%     -31.74    
11.00   49.00   17.26   12.00
innodb  select_join                           1.00      -72.73%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           63.00       +1.07%       0.68    
63.00   65.00   63.68    0.57
innodb  select_key2                          71.00       -0.00%       0.00    
70.00   72.00   71.00    0.56
innodb  select_key2_return_key               68.00       +0.62%       0.42    
67.00   70.00   68.42    0.94
innodb  select_key2_return_prim              68.00       +1.75%       1.21    
68.00   71.00   69.21    0.77
innodb  select_key_prefix                    70.00       +0.97%       0.68    
70.00   72.00   70.68    0.73
innodb  select_key_prefix_join                5.00       +4.04%       0.21     
5.00    6.00    5.21    0.41
innodb  select_key_return_key                62.00       +1.09%       0.68    
61.00   64.00   62.68    0.80
innodb  select_many_fields                   14.00       -5.98%      -0.79    
13.00   14.00   13.21    0.41
innodb  select_range                         45.00       -3.76%      -1.63    
39.00   47.00   43.37    2.64
innodb  select_range_key2                     9.00       +5.52%       0.53     
8.00   10.00    9.53    0.60
innodb  select_range_prefix                  10.00       -9.20%      -0.84     
8.00   10.00    9.16    0.59
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      -11.76%      -0.11     
0.00    1.00    0.89    0.31
innodb  update_autocommit                    16.00     -181.48%     -10.32     
3.00   16.00    5.68    4.34
innodb  update_big                          112.00      -66.51%     -44.74    
57.00  112.00   67.26   17.75
innodb  update_commit                         9.00     -194.83%      -5.95     
1.00    9.00    3.05    2.58
innodb  update_of_key                        25.00       -9.95%      -2.26    
21.00   25.00   22.74    1.12
innodb  update_of_key_big                    58.00      -51.37%     -19.68    
29.00   58.00   38.32    7.23
innodb  update_of_primary_key_many_keys     728.00      +42.53%     538.79   
688.00 1505.00 1266.79  243.76
innodb  update_rollback                      28.00     -358.62%     -21.89     
2.00   28.00    6.11    9.20
innodb  update_with_key                     122.00       -0.65%      -0.79   
118.00  127.00  121.21    2.57
innodb  update_with_key_prefix               44.00       -0.60%      -0.26    
40.00   47.00   43.74    1.92
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                      33.00      -69.62%     -13.54    
11.00   61.00   19.46    9.75
innodb  alter_table_drop                     25.00      -41.92%      -7.38    
10.00   57.00   17.62    7.08
innodb  connect                               3.00      -45.01%      -0.93     
1.00    3.00    2.07    0.42
innodb  connect+select_1_row                  3.00      -12.28%      -0.33     
2.00    5.00    2.67    0.49
innodb  connect+select_simple                 2.00      +13.30%       0.31     
1.00    3.00    2.31    0.47
innodb  count                                18.00      -14.38%      -2.26    
12.00  193.00   15.74    9.39
innodb  count_distinct                        6.00       +8.17%       0.53     
5.00   50.00    6.53    2.41
innodb  count_distinct_2                     12.00       +8.29%       1.08    
11.00   63.00   13.08    3.11
innodb  count_distinct_big                   23.00       -5.49%      -1.20     
5.00   67.00   21.80    3.13
innodb  count_distinct_group                 15.00      -15.75%      -2.04    
10.00   68.00   12.96    3.23
innodb  count_distinct_group_on_key          10.00       -6.05%      -0.57     
7.00   69.00    9.43    3.17
innodb  count_distinct_group_on_key_parts    14.00      -14.89%      -1.81     
9.00   72.00   12.19    3.31
innodb  count_distinct_key_prefix             5.00       +1.80%       0.09     
3.00   52.00    5.09    2.53
innodb  count_group_on_key_parts             11.00      -12.03%      -1.18     
7.00   72.00    9.82    3.32
innodb  count_on_key                         95.00      -12.04%     -10.21    
68.00  107.00   84.79    7.02
innodb  create+drop                          42.00      -29.41%      -9.54    
18.00   75.00   32.46   12.68
innodb  create_index                          3.00       -5.49%      -0.16     
1.00    8.00    2.84    1.20
innodb  create_key+drop                      49.00      -75.16%     -21.03    
21.00   50.00   27.97    5.13
innodb  create_MANY_tables                   62.00      -72.71%     -26.10    
14.00  121.00   35.90   17.40
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.37
innodb  delete_all_many_keys                288.00      +34.05%     148.66   
212.00 1888.00  436.66  382.43
innodb  delete_autocommit                     4.00      -17.19%      -0.59     
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                288.00      +35.12%     155.91   
212.00 2293.00  443.91  398.42
innodb  delete_commit                         2.00      -36.28%      -0.53     
1.00    5.00    1.47    0.53
innodb  delete_key                            3.00       +2.96%       0.09     
2.00   35.00    3.09    1.58
innodb  delete_range                          7.00      +15.28%       1.26     
5.00   23.00    8.26    3.44
innodb  delete_rollback                      12.00     -617.34%     -10.33     
1.00   12.00    1.67    0.88
innodb  drop_index                            4.00      -36.40%      -1.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          90.00     -352.85%     -70.13    
11.00   90.00   19.87    7.67
innodb  insert                              125.00      -18.28%     -19.32     
3.00  343.00  105.68   15.29
innodb  insert_autocommit                     4.00      -35.00%      -1.04     
2.00   99.00    2.96    3.53
innodb  insert_commit                         2.00      -51.61%      -0.68     
1.00    3.00    1.32    0.48
innodb  insert_duplicates                    19.00      -27.12%      -4.05    
11.00   21.00   14.95    2.42
innodb  insert_key                          427.00      -39.43%    -120.75   
142.00  700.00  306.25  114.56
innodb  insert_many_fields                    6.00       -7.56%      -0.42     
3.00   17.00    5.58    1.88
innodb  insert_rollback                       3.00      -84.90%      -1.38     
1.00    3.00    1.62    0.55
innodb  insert_select_1_key                   6.00      -59.30%      -2.23     
2.00   10.00    3.77    0.92
innodb  insert_select_2_keys                 10.00      -65.50%      -3.96     
4.00   16.00    6.04    2.21
innodb  min_max                               9.00      -15.15%      -1.18     
6.00  110.00    7.82    4.83
innodb  min_max_on_key                       24.00      -20.18%      -4.03    
14.00   37.00   19.97    2.86
innodb  multiple_value_insert                 5.00       +5.80%       0.31     
2.00   50.00    5.31    4.55
innodb  once_prepared_select                 29.00      -23.33%      -5.49    
18.00   32.00   23.51    3.26
innodb  order_by_big                         13.00       +8.94%       1.28    
12.00   31.00   14.28    1.58
innodb  order_by_big_key                     16.00      -21.92%      -2.88    
11.00   32.00   13.12    1.63
innodb  order_by_big_key2                    12.00       +0.60%       0.07    
10.00   33.00   12.07    1.58
innodb  order_by_big_key_desc                17.00      -28.21%      -3.74    
11.00   32.00   13.26    1.61
innodb  order_by_big_key_diff                12.00       +0.84%       0.10    
10.00   31.00   12.10    1.53
innodb  order_by_big_key_prefix              14.00      -14.16%      -1.74    
10.00   32.00   12.26    1.60
innodb  order_by_key2_diff                    1.00      +28.46%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -27.58%      -0.22     
0.00    2.00    0.78    0.42
innodb  order_by_range                        1.00      -22.80%      -0.19     
0.00    2.00    0.81    0.40
innodb  outer_join                           22.00      -15.81%      -3.00    
15.00   61.00   19.00    3.73
innodb  outer_join_found                     21.00      -13.76%      -2.54    
14.00   58.00   18.46    3.60
innodb  outer_join_not_found                 19.00      -17.75%      -2.86    
12.00   46.00   16.14    3.14
innodb  outer_join_on_key                    14.00      -10.59%      -1.34    
10.00   59.00   12.66    2.79
innodb  prepared_select                      38.00      -24.63%      -7.51    
22.00   40.00   30.49    4.20
innodb  select_1_row                          4.00      -45.38%      -1.25     
2.00    4.00    2.75    0.66
innodb  select_1_row_cache                    3.00      -16.79%      -0.43     
2.00    4.00    2.57    0.63
innodb  select_2_rows                         4.00      -44.48%      -1.23     
2.00    4.00    2.77    0.66
innodb  select_big                           11.00       +8.60%       1.03     
0.00   31.00   12.03    1.57
innodb  select_big_str                        1.00      +12.09%       0.14     
0.00    2.00    1.14    0.35
innodb  select_cache                         57.00       +3.49%       2.06    
49.00   77.00   59.06    5.63
innodb  select_cache2                        59.00       +0.94%       0.56    
49.00   73.00   59.56    6.48
innodb  select_column+column                  4.00      -42.57%      -1.19     
2.00    4.00    2.81    0.67
innodb  select_diff_key                       0.00     +100.00%       0.21     
0.00    1.00    0.21    0.41
innodb  select_distinct                       4.00       +4.67%       0.20     
3.00    8.00    4.20    0.54
innodb  select_group                         17.00       -5.22%      -0.84     
4.00  136.00   16.16    5.77
innodb  select_group_when_MANY_tables        49.00     -441.10%     -39.94     
3.00   49.00    9.06    9.96
innodb  select_join                           1.00      -77.46%      -0.44     
0.00    1.00    0.56    0.50
innodb  select_key                           63.00      -23.04%     -11.80    
40.00   66.00   51.20    6.63
innodb  select_key2                          71.00      -22.78%     -13.17    
45.00   75.00   57.83    7.58
innodb  select_key2_return_key               68.00      -23.31%     -12.85    
42.00   70.00   55.15    7.32
innodb  select_key2_return_prim              68.00      -21.67%     -12.11    
42.00   72.00   55.89    7.47
innodb  select_key_prefix                    70.00      -22.75%     -12.97    
44.00   75.00   57.03    7.52
innodb  select_key_prefix_join                5.00       -7.33%      -0.34     
3.00   10.00    4.66    0.66
innodb  select_key_return_key                62.00      -23.45%     -11.78    
38.00   65.00   50.22    6.63
innodb  select_many_fields                   14.00       +7.83%       1.19    
11.00   19.00   15.19    1.78
innodb  select_range                         45.00       +5.69%       2.72    
39.00   76.00   47.72    3.72
innodb  select_range_key2                     9.00      -11.34%      -0.92     
6.00   10.00    8.08    0.98
innodb  select_range_prefix                  10.00      -30.90%      -2.36     
5.00   10.00    7.64    1.02
innodb  select_simple                         2.00      -25.48%      -0.41     
1.00    3.00    1.59    0.52
innodb  select_simple_cache                   2.00      -34.28%      -0.51     
1.00    3.00    1.49    0.52
innodb  select_simple_join                    1.00      -55.24%      -0.36     
0.00    3.00    0.64    0.49
innodb  update_autocommit                    16.00     -390.06%     -12.74     
2.00   16.00    3.26    0.95
innodb  update_big                          112.00     -125.01%     -62.23    
31.00  195.00   49.77   25.84
innodb  update_commit                         9.00     -499.74%      -7.50     
1.00    9.00    1.50    0.69
innodb  update_of_key                        25.00       -2.10%      -0.51    
18.00  100.00   24.49    6.54
innodb  update_of_key_big                    58.00     -121.19%     -31.78    
15.00   75.00   26.22   11.07
innodb  update_of_primary_key_many_keys     728.00      +40.34%     492.26   
647.00 6065.00 1220.26 1,044.60
innodb  update_rollback                      28.00    -1567.19%     -26.32     
1.00   28.00    1.68    1.72
innodb  update_with_key                     122.00      -12.82%     -13.86    
90.00  598.00  108.14   21.64
innodb  update_with_key_prefix               44.00      -12.88%      -5.02    
33.00  202.00   38.98    6.99
innodb  wisc_benchmark                        3.00      -21.64%      -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