=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   1069
RUN DATE: 2011-12-27T23:23:07.964074
SERVER:   drizzled
VERSION:  staging
REVISION: 2481
COMMENT:  2481: Mark Atwood 2011-12-27 fix tests/r/basic.result

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      30.00       +5.06%       1.60    
30.00   33.00   31.60    1.02
innodb  alter_table_drop                     24.00       +3.23%       0.80    
24.00   26.00   24.80    0.75
innodb  connect                               2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  connect+select_1_row                  3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  connect+select_simple                 3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  count                                19.00      -20.25%      -3.20    
14.00   19.00   15.80    2.23
innodb  count_distinct                        7.00       -0.00%       0.00     
6.00    8.00    7.00    0.63
innodb  count_distinct_2                     16.00      -11.11%      -1.60    
13.00   16.00   14.40    1.02
innodb  count_distinct_big                   26.00      -17.12%      -3.80    
20.00   26.00   22.20    2.40
innodb  count_distinct_group                 18.00      -21.62%      -3.20    
12.00   18.00   14.80    1.94
innodb  count_distinct_group_on_key          11.00      -12.24%      -1.20     
9.00   11.00    9.80    0.75
innodb  count_distinct_group_on_key_parts    15.00      -19.05%      -2.40    
11.00   15.00   12.60    1.36
innodb  count_distinct_key_prefix             4.00      +13.04%       0.60     
4.00    5.00    4.60    0.49
innodb  count_group_on_key_parts             12.00      -11.11%      -1.20    
10.00   12.00   10.80    0.75
innodb  count_on_key                         97.00       -4.08%      -3.80    
92.00   97.00   93.20    1.94
innodb  create+drop                          33.00       +2.37%       0.80    
33.00   35.00   33.80    0.75
innodb  create_index                          3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  create_key+drop                      31.00       +2.52%       0.80    
30.00   33.00   31.80    1.17
innodb  create_MANY_tables                   22.00       -2.80%      -0.60    
20.00   22.00   21.40    0.80
innodb  delete_all_many_keys                917.00       +2.13%      20.00   
750.00 1107.00  937.00  113.98
innodb  delete_autocommit                     4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  delete_big                            0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_big_many_keys                917.00       +2.07%      19.40   
750.00 1106.00  936.40  113.61
innodb  delete_commit                         1.00      +44.44%       0.80     
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                          8.00       -2.56%      -0.20     
7.00    9.00    7.80    0.75
innodb  delete_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  drop_index                            4.00      -25.00%      -0.80     
3.00    4.00    3.20    0.40
innodb  drop_table_when_MANY_tables          18.00       +4.26%       0.80    
18.00   20.00   18.80    0.75
innodb  insert                              114.00       -0.00%       0.00   
113.00  115.00  114.00    0.63
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                    20.00       -1.01%      -0.20    
19.00   20.00   19.80    0.40
innodb  insert_key                          286.00       +1.24%       3.60   
286.00  294.00  289.60    3.14
innodb  insert_many_fields                    5.00      +10.71%       0.60     
5.00    6.00    5.60    0.49
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   5.00       -0.00%       0.00     
4.00    6.00    5.00    0.63
innodb  insert_select_2_keys                  6.00       +9.09%       0.60     
6.00    7.00    6.60    0.49
innodb  min_max                               9.00      -15.38%      -1.20     
7.00    9.00    7.80    0.98
innodb  min_max_on_key                       26.00       -3.17%      -0.80    
24.00   26.00   25.20    0.75
innodb  multiple_value_insert                 6.00      -11.11%      -0.60     
5.00    6.00    5.40    0.49
innodb  once_prepared_select                 30.00       -2.74%      -0.80    
29.00   30.00   29.20    0.40
innodb  order_by_big                         13.00       +4.41%       0.60    
12.00   15.00   13.60    1.20
innodb  order_by_big_key                     13.00       +2.99%       0.40    
12.00   15.00   13.40    1.02
innodb  order_by_big_key2                    14.00       -9.38%      -1.20    
11.00   14.00   12.80    0.98
innodb  order_by_big_key_desc                16.00       -5.26%      -0.80    
14.00   16.00   15.20    0.98
innodb  order_by_big_key_diff                14.00       -9.38%      -1.20    
11.00   14.00   12.80    1.17
innodb  order_by_big_key_prefix              14.00       -7.69%      -1.00    
11.00   14.00   13.00    1.26
innodb  order_by_key2_diff                    2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           20.00      +12.28%       2.80    
19.00   26.00   22.80    2.79
innodb  outer_join_found                     19.00      +11.21%       2.40    
18.00   24.00   21.40    2.42
innodb  outer_join_not_found                 15.00      +22.68%       4.40    
15.00   22.00   19.40    2.87
innodb  outer_join_on_key                    11.00      +19.12%       2.60    
11.00   15.00   13.60    1.74
innodb  prepared_select                      37.00       -0.00%       0.00    
36.00   38.00   37.00    0.63
innodb  select_1_row                          3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_1_row_cache                    4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_2_rows                         3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  select_big                           13.00       -3.17%      -0.40    
12.00   14.00   12.60    0.80
innodb  select_big_str                        2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  select_cache                         60.00       +7.69%       5.00    
60.00   73.00   65.00    4.69
innodb  select_cache2                        69.00       -3.29%      -2.20    
62.00   72.00   66.80    3.76
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_distinct                       5.00       -4.17%      -0.20     
4.00    5.00    4.80    0.40
innodb  select_group                         15.00      +16.67%       3.00    
15.00   19.00   18.00    1.55
innodb  select_group_when_MANY_tables        11.00       +5.17%       0.60    
11.00   12.00   11.60    0.49
innodb  select_join                           0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  select_key                           65.00       -0.00%       0.00    
64.00   66.00   65.00    0.63
innodb  select_key2                          71.00       +0.28%       0.20    
71.00   72.00   71.20    0.40
innodb  select_key2_return_key               68.00       +0.87%       0.60    
68.00   70.00   68.60    0.80
innodb  select_key2_return_prim              69.00       +0.58%       0.40    
69.00   70.00   69.40    0.49
innodb  select_key_prefix                    71.00       -0.28%      -0.20    
70.00   72.00   70.80    0.75
innodb  select_key_prefix_join                7.00       -9.38%      -0.60     
6.00    7.00    6.40    0.49
innodb  select_key_return_key                63.00       +0.32%       0.20    
63.00   64.00   63.20    0.40
innodb  select_many_fields                   17.00      -21.43%      -3.00    
13.00   17.00   14.00    1.55
innodb  select_range                         40.00       +7.83%       3.40    
40.00   48.00   43.40    2.80
innodb  select_range_key2                     9.00       +6.25%       0.60     
9.00   10.00    9.60    0.49
innodb  select_range_prefix                  10.00       -8.70%      -0.80     
9.00   10.00    9.20    0.40
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  select_simple_join                    1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  update_autocommit                     4.00      -25.00%      -0.80     
3.00    4.00    3.20    0.40
innodb  update_big                           61.00       -5.17%      -3.00    
57.00   61.00   58.00    1.55
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        23.00       -1.77%      -0.40    
22.00   24.00   22.60    0.80
innodb  update_of_key_big                    20.00       -4.17%      -0.80    
17.00   21.00   19.20    1.33
innodb  update_of_primary_key_many_keys    1259.00       +2.34%      30.20  
1259.00 1317.00 1289.20   21.98
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     119.00       -0.00%       0.00   
116.00  122.00  119.00    2.00
innodb  update_with_key_prefix               44.00       -3.29%      -1.40    
41.00   44.00   42.60    1.02
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                      30.00       +4.31%       1.35    
25.00   34.00   31.35    1.96
innodb  alter_table_drop                     24.00       +3.61%       0.90    
23.00   27.00   24.90    0.94
innodb  connect                               2.00      +13.04%       0.30     
2.00    3.00    2.30    0.46
innodb  connect+select_1_row                  3.00       -3.45%      -0.10     
2.00    3.00    2.90    0.30
innodb  connect+select_simple                 3.00      -20.00%      -0.50     
2.00    3.00    2.50    0.50
innodb  count                                19.00      -21.41%      -3.35    
13.00   19.00   15.65    2.29
innodb  count_distinct                        7.00       -0.72%      -0.05     
6.00    8.00    6.95    0.80
innodb  count_distinct_2                     16.00      -19.40%      -2.60    
11.00   16.00   13.40    1.36
innodb  count_distinct_big                   26.00      -15.56%      -3.50    
20.00   26.00   22.50    1.88
innodb  count_distinct_group                 18.00      -22.45%      -3.30    
12.00   18.00   14.70    1.35
innodb  count_distinct_group_on_key          11.00      -11.11%      -1.10     
8.00   12.00    9.90    1.14
innodb  count_distinct_group_on_key_parts    15.00      -13.21%      -1.75    
11.00   15.00   13.25    1.26
innodb  count_distinct_key_prefix             4.00      +20.79%       1.05     
4.00    6.00    5.05    0.67
innodb  count_group_on_key_parts             12.00       -8.11%      -0.90    
10.00   12.00   11.10    0.62
innodb  count_on_key                         97.00       -3.08%      -2.90    
91.00  101.00   94.10    2.90
innodb  create+drop                          33.00       +1.93%       0.65    
32.00   35.00   33.65    0.79
innodb  create_index                          3.00       -0.00%       0.00     
2.00    4.00    3.00    0.55
innodb  create_key+drop                      31.00       +3.43%       1.10    
30.00   34.00   32.10    1.22
innodb  create_MANY_tables                   22.00       -3.53%      -0.75    
19.00   25.00   21.25    1.30
innodb  delete_all_many_keys                917.00       -6.09%     -52.60   
735.00 1107.00  864.40  105.22
innodb  delete_autocommit                     4.00       -9.59%      -0.35     
3.00    4.00    3.65    0.48
innodb  delete_big                            0.00     +100.00%       0.35     
0.00    1.00    0.35    0.48
innodb  delete_big_many_keys                917.00       -6.15%     -53.10   
735.00 1106.00  863.90  104.99
innodb  delete_commit                         1.00      +44.44%       0.80     
1.00    2.00    1.80    0.40
innodb  delete_key                            3.00       -3.45%      -0.10     
2.00    3.00    2.90    0.30
innodb  delete_range                          8.00       +0.62%       0.05     
7.00   10.00    8.05    0.80
innodb  delete_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  drop_index                            4.00      -33.33%      -1.00     
2.00    4.00    3.00    0.63
innodb  drop_table_when_MANY_tables          18.00       +4.76%       0.90    
17.00   20.00   18.90    0.83
innodb  insert                              114.00       -0.31%      -0.35   
111.00  116.00  113.65    1.31
innodb  insert_autocommit                     3.00       +4.76%       0.15     
3.00    4.00    3.15    0.36
innodb  insert_commit                         2.00       -5.26%      -0.10     
1.00    2.00    1.90    0.30
innodb  insert_duplicates                    20.00       -2.83%      -0.55    
19.00   20.00   19.45    0.50
innodb  insert_key                          286.00       +1.17%       3.40   
280.00  305.00  289.40    4.97
innodb  insert_many_fields                    5.00      +13.04%       0.75     
5.00    6.00    5.75    0.43
innodb  insert_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  insert_select_1_key                   5.00       -0.00%       0.00     
4.00    6.00    5.00    0.71
innodb  insert_select_2_keys                  6.00       +6.98%       0.45     
5.00    7.00    6.45    0.59
innodb  min_max                               9.00      -12.50%      -1.00     
7.00    9.00    8.00    0.95
innodb  min_max_on_key                       26.00       -4.63%      -1.15    
24.00   26.00   24.85    0.65
innodb  multiple_value_insert                 6.00       -6.19%      -0.35     
5.00    7.00    5.65    0.65
innodb  once_prepared_select                 30.00       -3.27%      -0.95    
28.00   30.00   29.05    0.50
innodb  order_by_big                         13.00       +6.81%       0.95    
12.00   16.00   13.95    1.07
innodb  order_by_big_key                     13.00       +8.13%       1.15    
12.00   16.00   14.15    1.31
innodb  order_by_big_key2                    14.00      -12.00%      -1.50    
11.00   14.00   12.50    0.81
innodb  order_by_big_key_desc                16.00       -5.96%      -0.90    
13.00   16.00   15.10    1.04
innodb  order_by_big_key_diff                14.00       -8.53%      -1.10    
11.00   14.00   12.90    0.77
innodb  order_by_big_key_prefix              14.00       -6.46%      -0.85    
11.00   15.00   13.15    0.96
innodb  order_by_key2_diff                    2.00      -37.93%      -0.55     
1.00    2.00    1.45    0.50
innodb  order_by_key_prefix                   1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  order_by_range                        1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  outer_join                           20.00      +10.51%       2.35    
19.00   26.00   22.35    2.55
innodb  outer_join_found                     19.00       +8.65%       1.80    
17.00   24.00   20.80    2.34
innodb  outer_join_not_found                 15.00      +21.47%       4.10    
15.00   22.00   19.10    2.47
innodb  outer_join_on_key                    11.00      +18.82%       2.55    
11.00   16.00   13.55    1.47
innodb  prepared_select                      37.00       +0.40%       0.15    
36.00   38.00   37.15    0.57
innodb  select_1_row                          3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_1_row_cache                    4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_2_rows                         3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_big                           13.00       -0.78%      -0.10    
11.00   14.00   12.90    1.04
innodb  select_big_str                        2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  select_cache                         60.00       +6.18%       3.95    
54.00   73.00   63.95    4.75
innodb  select_cache2                        69.00       -4.86%      -3.20    
61.00   73.00   65.80    3.20
innodb  select_column+column                  4.00       -2.56%      -0.10     
3.00    4.00    3.90    0.30
innodb  select_diff_key                       0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  select_distinct                       5.00       -3.09%      -0.15     
4.00    5.00    4.85    0.36
innodb  select_group                         15.00      +10.98%       1.85    
15.00   19.00   16.85    1.35
innodb  select_group_when_MANY_tables        11.00       +7.95%       0.95    
11.00   13.00   11.95    0.67
innodb  select_join                           0.00     +100.00%       0.70     
0.00    1.00    0.70    0.46
innodb  select_key                           65.00       -0.78%      -0.50    
63.00   66.00   64.50    0.97
innodb  select_key2                          71.00       +0.56%       0.40    
70.00   73.00   71.40    0.73
innodb  select_key2_return_key               68.00       +1.38%       0.95    
67.00   71.00   68.95    0.97
innodb  select_key2_return_prim              69.00       +0.93%       0.65    
68.00   71.00   69.65    0.73
innodb  select_key_prefix                    71.00       -0.00%       0.00    
69.00   72.00   71.00    0.89
innodb  select_key_prefix_join                7.00      -17.65%      -1.05     
5.00    7.00    5.95    0.50
innodb  select_key_return_key                63.00       +0.47%       0.30    
62.00   65.00   63.30    0.78
innodb  select_many_fields                   17.00      -27.34%      -3.65    
13.00   17.00   13.35    0.91
innodb  select_range                         40.00       +8.68%       3.80    
40.00   49.00   43.80    2.82
innodb  select_range_key2                     9.00       +6.74%       0.65     
9.00   10.00    9.65    0.48
innodb  select_range_prefix                  10.00       -8.11%      -0.75     
9.00   10.00    9.25    0.43
innodb  select_simple                         2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_cache                   2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_join                    1.00      -33.33%      -0.25     
0.00    1.00    0.75    0.43
innodb  update_autocommit                     4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  update_big                           61.00       -4.54%      -2.65    
54.00   61.00   58.35    1.49
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        23.00       -1.77%      -0.40    
21.00   25.00   22.60    1.11
innodb  update_of_key_big                    20.00       -3.09%      -0.60    
17.00   21.00   19.40    0.92
innodb  update_of_primary_key_many_keys    1259.00       +3.44%      44.85  
1259.00 1442.00 1303.85   42.77
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     119.00       +0.67%       0.80   
115.00  125.00  119.80    2.68
innodb  update_with_key_prefix               44.00       -2.44%      -1.05    
40.00   46.00   42.95    1.69
innodb  wisc_benchmark                        2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      30.00      -33.22%      -7.48    
11.00   61.00   22.52   10.13
innodb  alter_table_drop                     24.00      -25.34%      -4.85    
10.00   57.00   19.15    6.76
innodb  connect                               2.00       +4.88%       0.10     
1.00    3.00    2.10    0.42
innodb  connect+select_1_row                  3.00       -9.74%      -0.27     
2.00    5.00    2.73    0.46
innodb  connect+select_simple                 3.00      -26.11%      -0.62     
1.00    3.00    2.38    0.49
innodb  count                                19.00      -20.54%      -3.24    
12.00  193.00   15.76    8.24
innodb  count_distinct                        7.00       -5.86%      -0.39     
5.00   50.00    6.61    2.14
innodb  count_distinct_2                     16.00      -20.63%      -2.74    
11.00   63.00   13.26    2.80
innodb  count_distinct_big                   26.00      -17.85%      -3.94     
5.00   67.00   22.06    2.91
innodb  count_distinct_group                 18.00      -35.13%      -4.68    
10.00   68.00   13.32    2.94
innodb  count_distinct_group_on_key          11.00      -15.33%      -1.46     
7.00   69.00    9.54    2.84
innodb  count_distinct_group_on_key_parts    15.00      -20.69%      -2.57     
9.00   72.00   12.43    2.98
innodb  count_distinct_key_prefix             4.00      +22.40%       1.15     
3.00   52.00    5.15    2.23
innodb  count_group_on_key_parts             12.00      -18.50%      -1.87     
7.00   72.00   10.13    2.96
innodb  count_on_key                         97.00      -11.28%      -9.83    
68.00  107.00   87.17    7.54
innodb  create+drop                          33.00       -1.44%      -0.47    
18.00   75.00   32.53   11.06
innodb  create_index                          3.00       -2.97%      -0.09     
1.00    8.00    2.91    1.07
innodb  create_key+drop                      31.00       -8.27%      -2.37    
21.00   50.00   28.63    4.73
innodb  create_MANY_tables                   22.00      +31.83%      10.27    
14.00  121.00   32.27   16.54
innodb  create_table                          0.00     +100.00%       0.10     
0.00    3.00    0.10    0.34
innodb  delete_all_many_keys                917.00      -81.10%    -410.65   
212.00 1888.00  506.35  358.07
innodb  delete_autocommit                     4.00      -15.45%      -0.54     
2.00   14.00    3.46    0.72
innodb  delete_big                            0.00     +100.00%       0.31     
0.00    3.00    0.31    0.47
innodb  delete_big_many_keys                917.00      -79.32%    -405.62   
212.00 2293.00  511.38  369.91
innodb  delete_commit                         1.00      +35.91%       0.56     
1.00    5.00    1.56    0.52
innodb  delete_key                            3.00       +0.87%       0.03     
2.00   35.00    3.03    1.40
innodb  delete_range                          8.00       +3.83%       0.32     
5.00   23.00    8.32    3.02
innodb  delete_rollback                       2.00      -12.13%      -0.22     
1.00   12.00    1.78    0.86
innodb  drop_index                            4.00      -35.19%      -1.04     
1.00    9.00    2.96    1.24
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.22
innodb  drop_table_when_MANY_tables          18.00       +7.52%       1.46    
11.00   90.00   19.46    7.02
innodb  insert                              114.00       -6.00%      -6.45     
3.00  343.00  107.55   13.76
innodb  insert_autocommit                     3.00       +0.60%       0.02     
2.00   99.00    3.02    3.09
innodb  insert_commit                         2.00      -38.73%      -0.56     
1.00    3.00    1.44    0.50
innodb  insert_duplicates                    20.00      -25.28%      -4.04    
11.00   21.00   15.96    2.78
innodb  insert_key                          286.00       +4.63%      13.89   
142.00  700.00  299.89   99.32
innodb  insert_many_fields                    5.00      +11.16%       0.63     
3.00   17.00    5.63    1.66
innodb  insert_rollback                       2.00      -16.74%      -0.29     
1.00    3.00    1.71    0.52
innodb  insert_select_1_key                   5.00      -28.99%      -1.12     
2.00   10.00    3.88    0.91
innodb  insert_select_2_keys                  6.00       +1.62%       0.10     
4.00   16.00    6.10    1.96
innodb  min_max                               9.00      -14.75%      -1.16     
6.00  110.00    7.84    4.25
innodb  min_max_on_key                       26.00      -23.33%      -4.92    
14.00   37.00   21.08    3.19
innodb  multiple_value_insert                 6.00       -8.39%      -0.46     
2.00   50.00    5.54    4.00
innodb  once_prepared_select                 30.00      -20.75%      -5.16    
18.00   32.00   24.84    3.70
innodb  order_by_big                         13.00       +9.00%       1.29    
12.00   31.00   14.29    1.48
innodb  order_by_big_key                     13.00       +3.03%       0.41    
11.00   32.00   13.41    1.63
innodb  order_by_big_key2                    14.00      -13.89%      -1.71    
10.00   33.00   12.29    1.49
innodb  order_by_big_key_desc                16.00      -16.81%      -2.30    
11.00   32.00   13.70    1.69
innodb  order_by_big_key_diff                14.00      -13.61%      -1.68    
10.00   31.00   12.32    1.45
innodb  order_by_big_key_prefix              14.00      -12.10%      -1.51    
10.00   32.00   12.49    1.50
innodb  order_by_key2_diff                    2.00      -42.77%      -0.60     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -24.44%      -0.20     
0.00    2.00    0.80    0.40
innodb  order_by_range                        1.00      -18.78%      -0.16     
0.00    2.00    0.84    0.37
innodb  outer_join                           20.00       -1.51%      -0.30    
15.00   61.00   19.70    3.70
innodb  outer_join_found                     19.00       +0.36%       0.07    
14.00   58.00   19.07    3.53
innodb  outer_join_not_found                 15.00      +10.81%       1.82    
12.00   46.00   16.82    3.20
innodb  outer_join_on_key                    11.00      +16.00%       2.09    
10.00   59.00   13.09    2.70
innodb  prepared_select                      37.00      -15.39%      -4.93    
22.00   40.00   32.07    4.61
innodb  select_1_row                          3.00       -1.84%      -0.05     
2.00    4.00    2.95    0.71
innodb  select_1_row_cache                    4.00      -43.48%      -1.21     
2.00    4.00    2.79    0.72
innodb  select_2_rows                         3.00       -0.71%      -0.02     
2.00    4.00    2.98    0.72
innodb  select_big                           13.00       -6.29%      -0.77     
0.00   31.00   12.23    1.50
innodb  select_big_str                        2.00      -67.85%      -0.81     
0.00    2.00    1.19    0.40
innodb  select_cache                         60.00       +0.43%       0.26    
49.00   78.00   60.26    5.66
innodb  select_cache2                        69.00      -13.68%      -8.30    
49.00   84.00   60.70    6.31
innodb  select_column+column                  4.00      -31.66%      -0.96     
2.00    4.00    3.04    0.74
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.42
innodb  select_distinct                       5.00      -16.65%      -0.71     
3.00    8.00    4.29    0.55
innodb  select_group                         15.00       +8.26%       1.35     
4.00  136.00   16.35    5.09
innodb  select_group_when_MANY_tables        11.00      -12.37%      -1.21     
3.00   49.00    9.79    8.85
innodb  select_join                           0.00     +100.00%       0.59     
0.00    1.00    0.59    0.49
innodb  select_key                           65.00      -19.86%     -10.77    
40.00   66.00   54.23    7.90
innodb  select_key2                          71.00      -16.52%     -10.07    
45.00   75.00   60.93    8.62
innodb  select_key2_return_key               68.00      -16.67%      -9.72    
42.00   71.00   58.28    8.48
innodb  select_key2_return_prim              69.00      -16.86%      -9.95    
42.00   72.00   59.05    8.60
innodb  select_key_prefix                    71.00      -17.86%     -10.76    
44.00   75.00   60.24    8.70
innodb  select_key_prefix_join                7.00      -45.99%      -2.21     
3.00   10.00    4.79    0.66
innodb  select_key_return_key                63.00      -18.34%      -9.76    
38.00   65.00   53.24    7.89
innodb  select_many_fields                   17.00      -15.45%      -2.28    
11.00   19.00   14.72    1.78
innodb  select_range                         40.00      +14.23%       6.63    
38.00   76.00   46.63    4.05
innodb  select_range_key2                     9.00       -6.75%      -0.57     
6.00   11.00    8.43    1.09
innodb  select_range_prefix                  10.00      -24.65%      -1.98     
5.00   10.00    8.02    1.16
innodb  select_simple                         2.00      -17.47%      -0.30     
1.00    3.00    1.70    0.51
innodb  select_simple_cache                   2.00      -23.60%      -0.38     
1.00    3.00    1.62    0.51
innodb  select_simple_join                    1.00      -49.18%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     4.00      -19.33%      -0.65     
2.00   16.00    3.35    0.96
innodb  update_big                           61.00      -17.30%      -9.00    
31.00  195.00   52.00   22.94
innodb  update_commit                         2.00      -23.86%      -0.39     
1.00   10.00    1.61    0.70
innodb  update_of_key                        23.00       +4.03%       0.96    
18.00  100.00   23.96    5.80
innodb  update_of_key_big                    20.00      +26.95%       7.38    
15.00   75.00   27.38   10.72
innodb  update_of_primary_key_many_keys    1259.00       -0.64%      -8.01   
647.00 6065.00 1250.99  877.06
innodb  update_rollback                       2.00      -11.12%      -0.20     
1.00   31.00    1.80    1.77
innodb  update_with_key                     119.00       -7.01%      -7.80    
90.00  598.00  111.20   19.69
innodb  update_with_key_prefix               44.00       -9.63%      -3.87    
33.00  202.00   40.13    6.52
innodb  wisc_benchmark                        2.00      +19.51%       0.48     
2.00    5.00    2.48    0.52

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

_______________________________________________
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