=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   1090
RUN DATE: 2012-02-13T19:44:40.255340
SERVER:   drizzled
VERSION:  staging
REVISION: 2511
COMMENT:  2511: Mark Atwood 2012-02-13 update and sort po/POTFILES.in

=========================================================================================================================
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    
31.00   32.00   31.60    0.49
innodb  alter_table_drop                     24.00       +4.76%       1.20    
24.00   26.00   25.20    0.75
innodb  connect                               2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
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       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  count                                14.00      +10.26%       1.60    
14.00   18.00   15.60    1.96
innodb  count_distinct                        7.00       -0.00%       0.00     
6.00    8.00    7.00    0.89
innodb  count_distinct_2                     15.00      -15.38%      -2.00    
12.00   15.00   13.00    1.10
innodb  count_distinct_big                   21.00       +6.25%       1.40    
21.00   25.00   22.40    1.74
innodb  count_distinct_group                 11.00      +19.12%       2.60    
11.00   16.00   13.60    1.62
innodb  count_distinct_group_on_key          11.00      -10.00%      -1.00     
8.00   11.00   10.00    1.26
innodb  count_distinct_group_on_key_parts    11.00      +14.06%       1.80    
11.00   14.00   12.80    1.47
innodb  count_distinct_key_prefix             5.00       +3.85%       0.20     
4.00    6.00    5.20    0.75
innodb  count_group_on_key_parts             12.00       -5.26%      -0.60    
11.00   12.00   11.40    0.49
innodb  count_on_key                         95.00       -1.06%      -1.00    
90.00   99.00   94.00    2.97
innodb  create+drop                          33.00       +0.60%       0.20    
33.00   34.00   33.20    0.40
innodb  create_index                          3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  create_key+drop                      31.00       +1.27%       0.40    
30.00   33.00   31.40    1.02
innodb  create_MANY_tables                   21.00       -0.96%      -0.20    
20.00   22.00   20.80    0.75
innodb  delete_all_many_keys                882.00       +7.72%      73.80   
825.00 1049.00  955.80   87.03
innodb  delete_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  delete_big                            0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                881.00       +7.75%      74.00   
824.00 1049.00  955.00   87.24
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          8.00       -5.26%      -0.40     
7.00    8.00    7.60    0.49
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  drop_table_when_MANY_tables          19.00       +1.04%       0.20    
19.00   20.00   19.20    0.40
innodb  insert                              112.00       +0.88%       1.00   
112.00  115.00  113.00    1.26
innodb  insert_autocommit                     3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  insert_commit                         2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  insert_duplicates                    20.00       -0.00%       0.00    
20.00   20.00   20.00    0.00
innodb  insert_key                          281.00       -0.00%       0.00   
277.00  284.00  281.00    2.45
innodb  insert_many_fields                    6.00       -3.45%      -0.20     
5.00    6.00    5.80    0.40
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   5.00       +7.41%       0.40     
5.00    6.00    5.40    0.49
innodb  insert_select_2_keys                  6.00       +6.25%       0.40     
6.00    7.00    6.40    0.49
innodb  min_max                              10.00      -21.95%      -1.80     
7.00   10.00    8.20    1.17
innodb  min_max_on_key                       25.00       +1.57%       0.40    
25.00   27.00   25.40    0.80
innodb  multiple_value_insert                 6.00       -0.00%       0.00     
6.00    6.00    6.00    0.00
innodb  once_prepared_select                 30.00       -0.67%      -0.20    
29.00   30.00   29.80    0.40
innodb  order_by_big                         13.00      +10.96%       1.60    
13.00   16.00   14.60    1.36
innodb  order_by_big_key                     15.00       -5.63%      -0.80    
13.00   16.00   14.20    1.17
innodb  order_by_big_key2                    14.00       -4.48%      -0.60    
13.00   14.00   13.40    0.49
innodb  order_by_big_key_desc                15.00       -0.00%       0.00    
15.00   15.00   15.00    0.00
innodb  order_by_big_key_diff                12.00       +4.76%       0.60    
12.00   14.00   12.60    0.80
innodb  order_by_big_key_prefix              13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  order_by_key2_diff                    1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
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      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  outer_join                           22.00       +0.90%       0.20    
19.00   24.00   22.20    1.72
innodb  outer_join_found                     22.00       -5.77%      -1.20    
17.00   22.00   20.80    1.94
innodb  outer_join_not_found                 19.00       -1.06%      -0.20    
16.00   20.00   18.80    1.47
innodb  outer_join_on_key                    15.00       -8.70%      -1.20    
11.00   15.00   13.80    1.47
innodb  prepared_select                      37.00       +1.07%       0.40    
37.00   38.00   37.40    0.49
innodb  select_1_row                          4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
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       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_big                           14.00      -16.67%      -2.00    
11.00   14.00   12.00    1.10
innodb  select_big_str                        1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  select_cache                         65.00       -3.17%      -2.00    
61.00   65.00   63.00    1.67
innodb  select_cache2                        67.00       -1.21%      -0.80    
62.00   72.00   66.20    3.54
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_diff_key                       1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  select_distinct                       5.00       -8.70%      -0.40     
4.00    5.00    4.60    0.49
innodb  select_group                         18.00       -3.45%      -0.60    
15.00   19.00   17.40    1.62
innodb  select_group_when_MANY_tables        12.00       -3.45%      -0.40    
11.00   12.00   11.60    0.49
innodb  select_join                           1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  select_key                           65.00       +0.61%       0.40    
65.00   66.00   65.40    0.49
innodb  select_key2                          72.00       +0.28%       0.20    
71.00   73.00   72.20    0.75
innodb  select_key2_return_key               69.00       +0.58%       0.40    
69.00   70.00   69.40    0.49
innodb  select_key2_return_prim              71.00       -0.28%      -0.20    
70.00   71.00   70.80    0.40
innodb  select_key_prefix                    72.00       -0.28%      -0.20    
71.00   73.00   71.80    0.75
innodb  select_key_prefix_join                4.00       +9.09%       0.40     
4.00    5.00    4.40    0.49
innodb  select_key_return_key                64.00       +0.31%       0.20    
63.00   65.00   64.20    0.75
innodb  select_many_fields                   13.00       -1.56%      -0.20    
12.00   13.00   12.80    0.40
innodb  select_range                         40.00       +3.38%       1.40    
40.00   43.00   41.40    1.36
innodb  select_range_key2                    10.00       -2.04%      -0.20     
9.00   11.00    9.80    0.75
innodb  select_range_prefix                   8.00      +11.11%       1.00     
8.00   10.00    9.00    0.89
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      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  update_autocommit                     4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  update_big                           57.00       -0.35%      -0.20    
56.00   58.00   56.80    0.75
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        22.00       +2.65%       0.60    
22.00   24.00   22.60    0.80
innodb  update_of_key_big                    20.00       -5.26%      -1.00    
18.00   20.00   19.00    0.63
innodb  update_of_primary_key_many_keys    1313.00       -1.06%     -13.80  
1247.00 1339.00 1299.20   30.48
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     120.00       -0.00%       0.00   
119.00  122.00  120.00    1.10
innodb  update_with_key_prefix               44.00       -0.92%      -0.40    
43.00   45.00   43.60    0.80
innodb  wisc_benchmark                        3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      31.00       +3.73%       1.20    
31.00   34.00   32.20    0.81
innodb  alter_table_drop                     24.00       +3.61%       0.90    
23.00   26.00   24.90    0.77
innodb  connect                               2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  connect+select_1_row                  3.00       -5.26%      -0.15     
2.00    3.00    2.85    0.36
innodb  connect+select_simple                 3.00       -9.09%      -0.25     
2.00    3.00    2.75    0.43
innodb  count                                14.00      +13.58%       2.20    
13.00   18.00   16.20    1.94
innodb  count_distinct                        7.00       -0.72%      -0.05     
6.00    8.00    6.95    0.80
innodb  count_distinct_2                     15.00      -10.70%      -1.45    
12.00   17.00   13.55    1.43
innodb  count_distinct_big                   21.00       +9.87%       2.30    
20.00   25.00   23.30    1.98
innodb  count_distinct_group                 11.00      +24.66%       3.60    
11.00   16.00   14.60    1.20
innodb  count_distinct_group_on_key          11.00       -9.45%      -0.95     
8.00   12.00   10.05    1.12
innodb  count_distinct_group_on_key_parts    11.00      +21.15%       2.95    
11.00   15.00   13.95    1.16
innodb  count_distinct_key_prefix             5.00       +1.96%       0.10     
4.00    6.00    5.10    0.62
innodb  count_group_on_key_parts             12.00       -7.62%      -0.85    
10.00   12.00   11.15    0.57
innodb  count_on_key                         95.00       +0.99%       0.95    
90.00  104.00   95.95    2.89
innodb  create+drop                          33.00       +1.35%       0.45    
32.00   35.00   33.45    0.74
innodb  create_index                          3.00       +1.64%       0.05     
3.00    4.00    3.05    0.22
innodb  create_key+drop                      31.00       +2.36%       0.75    
30.00   35.00   31.75    1.48
innodb  create_MANY_tables                   21.00       +1.64%       0.35    
20.00   24.00   21.35    0.96
innodb  delete_all_many_keys                882.00       +1.02%       9.10   
691.00 1123.00  891.10  111.95
innodb  delete_autocommit                     3.00      +17.81%       0.65     
3.00    4.00    3.65    0.48
innodb  delete_big                            0.00     +100.00%       0.25     
0.00    1.00    0.25    0.43
innodb  delete_big_many_keys                881.00       +1.07%       9.50   
691.00 1122.00  890.50  111.77
innodb  delete_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          8.00       -3.23%      -0.25     
7.00    8.00    7.75    0.43
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            3.00       -0.00%       0.00     
2.00    4.00    3.00    0.32
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  drop_table_when_MANY_tables          19.00       +1.30%       0.25    
18.00   21.00   19.25    0.89
innodb  insert                              112.00       +1.62%       1.85   
112.00  116.00  113.85    1.28
innodb  insert_autocommit                     3.00      +13.04%       0.45     
3.00    4.00    3.45    0.50
innodb  insert_commit                         2.00      -17.65%      -0.30     
1.00    2.00    1.70    0.46
innodb  insert_duplicates                    20.00       -1.01%      -0.20    
19.00   21.00   19.80    0.51
innodb  insert_key                          281.00       +0.23%       0.65   
265.00  297.00  281.65    6.75
innodb  insert_many_fields                    6.00       -6.19%      -0.35     
5.00    6.00    5.65    0.48
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.99%       0.05     
3.00    6.00    5.05    0.74
innodb  insert_select_2_keys                  6.00       +5.51%       0.35     
6.00    7.00    6.35    0.48
innodb  min_max                              10.00      -21.95%      -1.80     
6.00   10.00    8.20    1.08
innodb  min_max_on_key                       25.00       +0.20%       0.05    
24.00   27.00   25.05    0.74
innodb  multiple_value_insert                 6.00       -3.45%      -0.20     
5.00    7.00    5.80    0.51
innodb  once_prepared_select                 30.00       -2.04%      -0.60    
29.00   30.00   29.40    0.49
innodb  order_by_big                         13.00       +8.45%       1.20    
13.00   16.00   14.20    1.12
innodb  order_by_big_key                     15.00       -3.45%      -0.50    
13.00   16.00   14.50    1.20
innodb  order_by_big_key2                    14.00      -10.67%      -1.35    
11.00   14.00   12.65    1.01
innodb  order_by_big_key_desc                15.00       -0.33%      -0.05    
13.00   16.00   14.95    0.92
innodb  order_by_big_key_diff                12.00       +4.38%       0.55    
11.00   14.00   12.55    0.86
innodb  order_by_big_key_prefix              13.00       +1.14%       0.15    
12.00   15.00   13.15    0.79
innodb  order_by_key2_diff                    1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  order_by_range                        1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  outer_join                           22.00       -1.15%      -0.25    
17.00   24.00   21.75    2.57
innodb  outer_join_found                     22.00       -6.54%      -1.35    
17.00   23.00   20.65    2.35
innodb  outer_join_not_found                 19.00       -1.88%      -0.35    
15.00   22.00   18.65    2.17
innodb  outer_join_on_key                    15.00       -8.70%      -1.20    
11.00   16.00   13.80    1.60
innodb  prepared_select                      37.00       +0.80%       0.30    
36.00   38.00   37.30    0.56
innodb  select_1_row                          4.00       -6.67%      -0.25     
3.00    4.00    3.75    0.43
innodb  select_1_row_cache                    3.00      +15.49%       0.55     
3.00    4.00    3.55    0.50
innodb  select_2_rows                         4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_big                           14.00       -9.80%      -1.25    
11.00   14.00   12.75    1.22
innodb  select_big_str                        1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  select_cache                         65.00       -3.01%      -1.90    
57.00   79.00   63.10    4.32
innodb  select_cache2                        67.00       -0.53%      -0.35    
60.00   88.00   66.65    5.71
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_diff_key                       1.00     -233.33%      -0.70     
0.00    1.00    0.30    0.46
innodb  select_distinct                       5.00      -11.11%      -0.50     
4.00    5.00    4.50    0.50
innodb  select_group                         18.00       -2.56%      -0.45    
15.00   20.00   17.55    1.60
innodb  select_group_when_MANY_tables        12.00       +0.83%       0.10    
11.00   14.00   12.10    0.70
innodb  select_join                           1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  select_key                           65.00       -0.39%      -0.25    
63.00   67.00   64.75    0.89
innodb  select_key2                          72.00       -0.35%      -0.25    
70.00   74.00   71.75    0.99
innodb  select_key2_return_key               69.00       +0.36%       0.25    
68.00   71.00   69.25    0.83
innodb  select_key2_return_prim              71.00       -1.36%      -0.95    
69.00   72.00   70.05    0.86
innodb  select_key_prefix                    72.00       -0.98%      -0.70    
70.00   73.00   71.30    0.90
innodb  select_key_prefix_join                4.00      +19.19%       0.95     
4.00    6.00    4.95    0.50
innodb  select_key_return_key                64.00       -0.08%      -0.05    
63.00   66.00   63.95    0.80
innodb  select_many_fields                   13.00       +0.38%       0.05    
12.00   14.00   13.05    0.38
innodb  select_range                         40.00       +6.10%       2.60    
39.00   49.00   42.60    2.56
innodb  select_range_key2                    10.00       -3.09%      -0.30     
9.00   11.00    9.70    0.64
innodb  select_range_prefix                   8.00      +12.09%       1.10     
8.00   10.00    9.10    0.77
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  select_simple_join                    1.00      -42.86%      -0.30     
0.00    1.00    0.70    0.46
innodb  update_autocommit                     4.00      -19.40%      -0.65     
3.00    4.00    3.35    0.48
innodb  update_big                           57.00       +1.13%       0.65    
56.00   61.00   57.65    1.39
innodb  update_commit                         2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  update_of_key                        22.00       +1.79%       0.40    
21.00   24.00   22.40    0.80
innodb  update_of_key_big                    20.00       -5.54%      -1.05    
18.00   20.00   18.95    0.74
innodb  update_of_primary_key_many_keys    1313.00       -1.79%     -23.05  
1173.00 1452.00 1289.95   56.73
innodb  update_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  update_with_key                     120.00       -0.17%      -0.20   
117.00  122.00  119.80    1.25
innodb  update_with_key_prefix               44.00       -0.92%      -0.40    
42.00   46.00   43.60    1.16
innodb  wisc_benchmark                        3.00      -11.11%      -0.30     
2.00    3.00    2.70    0.46

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      31.00      -36.45%      -8.28    
11.00   61.00   22.72   10.12
innodb  alter_table_drop                     24.00      -24.56%      -4.73    
10.00   57.00   19.27    6.74
innodb  connect                               2.00       +4.82%       0.10     
1.00    3.00    2.10    0.42
innodb  connect+select_1_row                  3.00       -9.64%      -0.26     
2.00    5.00    2.74    0.45
innodb  connect+select_simple                 3.00      -25.69%      -0.61     
1.00    3.00    2.39    0.49
innodb  count                                14.00      +11.24%       1.77    
12.00  193.00   15.77    8.16
innodb  count_distinct                        7.00       -5.73%      -0.38     
5.00   50.00    6.62    2.12
innodb  count_distinct_2                     15.00      -13.03%      -1.73    
11.00   63.00   13.27    2.78
innodb  count_distinct_big                   21.00       +4.93%       1.09     
5.00   67.00   22.09    2.90
innodb  count_distinct_group                 11.00      +17.59%       2.35    
10.00   68.00   13.35    2.92
innodb  count_distinct_group_on_key          11.00      -15.19%      -1.45     
7.00   69.00    9.55    2.81
innodb  count_distinct_group_on_key_parts    11.00      +11.71%       1.46     
9.00   72.00   12.46    2.96
innodb  count_distinct_key_prefix             5.00       +3.00%       0.15     
3.00   52.00    5.15    2.21
innodb  count_group_on_key_parts             12.00      -18.26%      -1.85     
7.00   72.00   10.15    2.94
innodb  count_on_key                         95.00       -8.76%      -7.65    
68.00  107.00   87.35    7.58
innodb  create+drop                          33.00       -1.38%      -0.45    
18.00   75.00   32.55   10.95
innodb  create_index                          3.00       -2.87%      -0.08     
1.00    8.00    2.92    1.06
innodb  create_key+drop                      31.00       -8.03%      -2.30    
21.00   50.00   28.70    4.70
innodb  create_MANY_tables                   21.00      +34.47%      11.05    
14.00  121.00   32.05   16.44
innodb  create_table                          0.00     +100.00%       0.09     
0.00    3.00    0.09    0.34
innodb  delete_all_many_keys                882.00      -71.37%    -367.32   
212.00 1888.00  514.68  358.98
innodb  delete_autocommit                     3.00      +13.49%       0.47     
2.00   14.00    3.47    0.72
innodb  delete_big                            0.00     +100.00%       0.31     
0.00    3.00    0.31    0.47
innodb  delete_big_many_keys                881.00      -69.57%    -361.44   
212.00 2293.00  519.56  370.42
innodb  delete_commit                         2.00      -27.51%      -0.43     
1.00    5.00    1.57    0.52
innodb  delete_key                            3.00       +0.82%       0.02     
2.00   35.00    3.02    1.39
innodb  delete_range                          8.00       +3.70%       0.31     
5.00   23.00    8.31    2.99
innodb  delete_rollback                       2.00      -11.78%      -0.21     
1.00   12.00    1.79    0.86
innodb  drop_index                            3.00       -1.36%      -0.04     
1.00    9.00    2.96    1.23
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.22
innodb  drop_table_when_MANY_tables          19.00       +2.36%       0.46    
11.00   90.00   19.46    6.95
innodb  insert                              112.00       -4.01%      -4.32     
3.00  343.00  107.68   13.65
innodb  insert_autocommit                     3.00       +0.88%       0.03     
2.00   99.00    3.03    3.06
innodb  insert_commit                         2.00      -38.19%      -0.55     
1.00    3.00    1.45    0.51
innodb  insert_duplicates                    20.00      -24.67%      -3.96    
11.00   21.00   16.04    2.81
innodb  insert_key                          281.00       +6.18%      18.50   
142.00  700.00  299.50   98.24
innodb  insert_many_fields                    6.00       -6.59%      -0.37     
3.00   17.00    5.63    1.65
innodb  insert_rollback                       2.00      -16.33%      -0.28     
1.00    3.00    1.72    0.51
innodb  insert_select_1_key                   5.00      -28.22%      -1.10     
2.00   10.00    3.90    0.92
innodb  insert_select_2_keys                  6.00       +1.70%       0.10     
4.00   16.00    6.10    1.94
innodb  min_max                              10.00      -27.37%      -2.15     
6.00  110.00    7.85    4.20
innodb  min_max_on_key                       25.00      -18.13%      -3.84    
14.00   37.00   21.16    3.21
innodb  multiple_value_insert                 6.00       -8.29%      -0.46     
2.00   50.00    5.54    3.96
innodb  once_prepared_select                 30.00      -20.29%      -5.06    
18.00   32.00   24.94    3.72
innodb  order_by_big                         13.00       +8.98%       1.28    
12.00   31.00   14.28    1.47
innodb  order_by_big_key                     15.00      -11.71%      -1.57    
11.00   32.00   13.43    1.63
innodb  order_by_big_key2                    14.00      -13.82%      -1.70    
10.00   33.00   12.30    1.49
innodb  order_by_big_key_desc                15.00       -9.31%      -1.28    
11.00   32.00   13.72    1.69
innodb  order_by_big_key_diff                12.00       +2.67%       0.33    
10.00   31.00   12.33    1.44
innodb  order_by_big_key_prefix              13.00       -3.98%      -0.50    
10.00   32.00   12.50    1.49
innodb  order_by_key2_diff                    1.00      +28.59%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -24.11%      -0.19     
0.00    2.00    0.81    0.40
innodb  order_by_range                        1.00      -18.60%      -0.16     
0.00    2.00    0.84    0.37
innodb  outer_join                           22.00      -11.40%      -2.25    
15.00   61.00   19.75    3.70
innodb  outer_join_found                     22.00      -15.15%      -2.89    
14.00   58.00   19.11    3.52
innodb  outer_join_not_found                 19.00      -12.71%      -2.14    
12.00   46.00   16.86    3.20
innodb  outer_join_on_key                    15.00      -14.41%      -1.89    
10.00   59.00   13.11    2.68
innodb  prepared_select                      37.00      -15.00%      -4.83    
22.00   40.00   32.17    4.63
innodb  select_1_row                          4.00      -35.06%      -1.04     
2.00    4.00    2.96    0.72
innodb  select_1_row_cache                    3.00       -6.98%      -0.20     
2.00    4.00    2.80    0.72
innodb  select_2_rows                         4.00      -33.51%      -1.00     
2.00    4.00    3.00    0.73
innodb  select_big                           14.00      -14.38%      -1.76     
0.00   31.00   12.24    1.50
innodb  select_big_str                        1.00      +16.36%       0.20     
0.00    2.00    1.20    0.40
innodb  select_cache                         65.00       -7.76%      -4.68    
49.00   79.00   60.32    5.65
innodb  select_cache2                        67.00      -10.16%      -6.18    
49.00   88.00   60.82    6.35
innodb  select_column+column                  4.00      -30.97%      -0.95     
2.00    4.00    3.05    0.75
innodb  select_diff_key                       1.00     -346.70%      -0.78     
0.00    1.00    0.22    0.42
innodb  select_distinct                       5.00      -16.51%      -0.71     
3.00    8.00    4.29    0.55
innodb  select_group                         18.00       -9.92%      -1.63     
4.00  136.00   16.38    5.04
innodb  select_group_when_MANY_tables        12.00      -21.98%      -2.16     
3.00   49.00    9.84    8.76
innodb  select_join                           1.00      -68.21%      -0.41     
0.00    1.00    0.59    0.49
innodb  select_key                           65.00      -19.38%     -10.55    
40.00   67.00   54.45    7.96
innodb  select_key2                          72.00      -17.73%     -10.84    
45.00   75.00   61.16    8.67
innodb  select_key2_return_key               69.00      -17.93%     -10.49    
42.00   71.00   58.51    8.54
innodb  select_key2_return_prim              71.00      -19.78%     -11.73    
42.00   72.00   59.27    8.66
innodb  select_key_prefix                    72.00      -19.07%     -11.53    
44.00   75.00   60.47    8.75
innodb  select_key_prefix_join                4.00      +16.65%       0.80     
3.00   10.00    4.80    0.66
innodb  select_key_return_key                64.00      -19.72%     -10.54    
38.00   66.00   53.46    7.95
innodb  select_many_fields                   13.00      +11.50%       1.69    
11.00   19.00   14.69    1.78
innodb  select_range                         40.00      +14.07%       6.55    
38.00   76.00   46.55    4.06
innodb  select_range_key2                    10.00      -18.25%      -1.54     
6.00   11.00    8.46    1.09
innodb  select_range_prefix                   8.00       +0.55%       0.04     
5.00   10.00    8.04    1.16
innodb  select_simple                         2.00      -17.05%      -0.29     
1.00    3.00    1.71    0.50
innodb  select_simple_cache                   2.00      -22.78%      -0.37     
1.00    3.00    1.63    0.51
innodb  select_simple_join                    1.00      -49.19%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     4.00      -19.34%      -0.65     
2.00   16.00    3.35    0.95
innodb  update_big                           57.00       -9.36%      -4.88    
31.00  195.00   52.12   22.71
innodb  update_commit                         2.00      -23.18%      -0.38     
1.00   10.00    1.62    0.69
innodb  update_of_key                        22.00       +8.07%       1.93    
18.00  100.00   23.93    5.74
innodb  update_of_key_big                    20.00      +26.48%       7.20    
15.00   75.00   27.20   10.67
innodb  update_of_primary_key_many_keys    1313.00       -4.87%     -61.01   
647.00 6065.00 1251.99  865.84
innodb  update_rollback                       2.00      -10.81%      -0.20     
1.00   31.00    1.80    1.76
innodb  update_with_key                     120.00       -7.74%      -8.62    
90.00  598.00  111.38   19.52
innodb  update_with_key_prefix               44.00       -9.44%      -3.80    
33.00  202.00   40.20    6.47
innodb  wisc_benchmark                        3.00      -20.55%      -0.51     
2.00    5.00    2.49    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