=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   1087
RUN DATE: 2012-02-03T03:55:51.622195
SERVER:   drizzled
VERSION:  staging
REVISION: 2500
COMMENT:  2500: Mark Atwood 2012-02-02 must have license text on all files

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       +2.44%       0.80    
32.00   34.00   32.80    0.98
innodb  alter_table_drop                     25.00       -0.81%      -0.20    
24.00   25.00   24.80    0.40
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      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  count                                18.00      -15.38%      -2.40    
14.00   18.00   15.60    1.96
innodb  count_distinct                        8.00      -21.21%      -1.40     
6.00    8.00    6.60    0.80
innodb  count_distinct_2                     13.00       -3.17%      -0.40    
12.00   13.00   12.60    0.49
innodb  count_distinct_big                   24.00       -3.45%      -0.80    
21.00   25.00   23.20    1.83
innodb  count_distinct_group                 13.00       +5.80%       0.80    
13.00   15.00   13.80    0.75
innodb  count_distinct_group_on_key           8.00      +16.67%       1.60     
8.00   12.00    9.60    1.36
innodb  count_distinct_group_on_key_parts    11.00      +20.29%       2.80    
11.00   15.00   13.80    1.47
innodb  count_distinct_key_prefix             6.00      -15.38%      -0.80     
5.00    6.00    5.20    0.40
innodb  count_group_on_key_parts             11.00       -0.00%       0.00    
11.00   11.00   11.00    0.00
innodb  count_on_key                         93.00       +0.43%       0.40    
90.00   98.00   93.40    2.65
innodb  create+drop                          34.00       -0.59%      -0.20    
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                      33.00       -2.48%      -0.80    
31.00   34.00   32.20    1.17
innodb  create_MANY_tables                   21.00       +2.78%       0.60    
21.00   22.00   21.60    0.49
innodb  delete_all_many_keys               1049.00      -22.23%    -190.80   
691.00 1049.00  858.20  119.63
innodb  delete_autocommit                     3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  delete_big                            1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys               1049.00      -22.32%    -191.40   
691.00 1049.00  857.60  119.67
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       -8.11%      -0.60     
7.00    8.00    7.40    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          20.00       -7.53%      -1.40    
18.00   20.00   18.60    0.80
innodb  insert                              112.00       +1.75%       2.00   
112.00  116.00  114.00    1.41
innodb  insert_autocommit                     4.00      -11.11%      -0.40     
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       -2.04%      -0.40    
19.00   20.00   19.60    0.49
innodb  insert_key                          283.00       -2.31%      -6.40   
265.00  283.00  276.60    6.15
innodb  insert_many_fields                    6.00       -0.00%       0.00     
6.00    6.00    6.00    0.00
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   6.00       -3.45%      -0.20     
5.00    6.00    5.80    0.40
innodb  insert_select_2_keys                  6.00       -0.00%       0.00     
6.00    6.00    6.00    0.00
innodb  min_max                               8.00       -8.11%      -0.60     
6.00    9.00    7.40    1.02
innodb  min_max_on_key                       25.00       +0.79%       0.20    
25.00   26.00   25.20    0.40
innodb  multiple_value_insert                 6.00       -0.00%       0.00     
5.00    7.00    6.00    0.63
innodb  once_prepared_select                 30.00       -1.35%      -0.40    
29.00   30.00   29.60    0.49
innodb  order_by_big                         13.00       +8.45%       1.20    
13.00   15.00   14.20    0.98
innodb  order_by_big_key                     13.00       +5.80%       0.80    
13.00   15.00   13.80    0.75
innodb  order_by_big_key2                    13.00       +1.52%       0.20    
11.00   14.00   13.20    1.17
innodb  order_by_big_key_desc                15.00       +2.60%       0.40    
15.00   16.00   15.40    0.49
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              14.00       -0.00%       0.00    
13.00   15.00   14.00    0.63
innodb  order_by_key2_diff                    1.00      +37.50%       0.60     
1.00    2.00    1.60    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       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           24.00       -8.11%      -1.80    
17.00   24.00   22.20    2.64
innodb  outer_join_found                     22.00       -4.76%      -1.00    
17.00   23.00   21.00    2.10
innodb  outer_join_not_found                 20.00       -4.17%      -0.80    
16.00   20.00   19.20    1.60
innodb  outer_join_on_key                    15.00       -7.14%      -1.00    
12.00   15.00   14.00    1.10
innodb  prepared_select                      37.00       -0.00%       0.00    
36.00   38.00   37.00    0.63
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      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  select_2_rows                         4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_big                           11.00       +6.78%       0.80    
11.00   14.00   11.80    1.17
innodb  select_big_str                        1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  select_cache                         62.00       -0.98%      -0.60    
57.00   65.00   61.40    2.58
innodb  select_cache2                        62.00       +3.13%       2.00    
62.00   67.00   64.00    1.67
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_diff_key                       1.00     -400.00%      -0.80     
0.00    1.00    0.20    0.40
innodb  select_distinct                       5.00       -8.70%      -0.40     
4.00    5.00    4.60    0.49
innodb  select_group                         15.00       +9.64%       1.60    
15.00   19.00   16.60    1.62
innodb  select_group_when_MANY_tables        12.00       -0.00%       0.00    
11.00   13.00   12.00    0.63
innodb  select_join                           1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  select_key                           66.00       -1.23%      -0.80    
64.00   66.00   65.20    0.75
innodb  select_key2                          73.00       -1.39%      -1.00    
71.00   73.00   72.00    0.63
innodb  select_key2_return_key               70.00       -0.86%      -0.60    
69.00   70.00   69.40    0.49
innodb  select_key2_return_prim              71.00       -1.14%      -0.80    
69.00   71.00   70.20    0.75
innodb  select_key_prefix                    71.00       -0.00%       0.00    
70.00   72.00   71.00    0.63
innodb  select_key_prefix_join                4.00      +16.67%       0.80     
4.00    5.00    4.80    0.40
innodb  select_key_return_key                63.00       +1.25%       0.80    
63.00   65.00   63.80    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       +6.54%       2.80    
40.00   46.00   42.80    2.48
innodb  select_range_key2                    11.00       -7.84%      -0.80    
10.00   11.00   10.20    0.40
innodb  select_range_prefix                   8.00       +9.09%       0.80     
8.00    9.00    8.80    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      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  update_autocommit                     3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  update_big                           58.00       -1.40%      -0.80    
56.00   58.00   57.20    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       +1.79%       0.40    
22.00   23.00   22.40    0.49
innodb  update_of_key_big                    19.00       -1.06%      -0.20    
18.00   19.00   18.80    0.40
innodb  update_of_primary_key_many_keys    1339.00       -4.02%     -51.80  
1194.00 1351.00 1287.20   56.71
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     119.00       +0.50%       0.60   
117.00  122.00  119.60    1.74
innodb  update_with_key_prefix               43.00       +1.38%       0.60    
42.00   45.00   43.60    1.20
innodb  wisc_benchmark                        2.00      +23.08%       0.60     
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                      32.00       +0.78%       0.25    
30.00   34.00   32.25    0.89
innodb  alter_table_drop                     25.00       -0.60%      -0.15    
23.00   26.00   24.85    0.73
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                                18.00       -8.43%      -1.40    
13.00   19.00   16.60    1.88
innodb  count_distinct                        8.00      -14.29%      -1.00     
6.00    8.00    7.00    0.77
innodb  count_distinct_2                     13.00       +5.45%       0.75    
12.00   17.00   13.75    1.48
innodb  count_distinct_big                   24.00       -1.27%      -0.30    
20.00   26.00   23.70    1.90
innodb  count_distinct_group                 13.00      +12.75%       1.90    
13.00   18.00   14.90    1.09
innodb  count_distinct_group_on_key           8.00      +19.60%       1.95     
8.00   12.00    9.95    1.12
innodb  count_distinct_group_on_key_parts    11.00      +21.15%       2.95    
11.00   15.00   13.95    1.20
innodb  count_distinct_key_prefix             6.00      -17.65%      -0.90     
4.00    6.00    5.10    0.62
innodb  count_group_on_key_parts             11.00       -0.00%       0.00    
10.00   12.00   11.00    0.63
innodb  count_on_key                         93.00       +3.13%       3.00    
90.00  104.00   96.00    2.95
innodb  create+drop                          34.00       -1.49%      -0.50    
32.00   35.00   33.50    0.74
innodb  create_index                          3.00       +1.64%       0.05     
3.00    4.00    3.05    0.22
innodb  create_key+drop                      33.00       -3.45%      -1.10    
30.00   35.00   31.90    1.45
innodb  create_MANY_tables                   21.00       +2.55%       0.55    
20.00   24.00   21.55    0.86
innodb  delete_all_many_keys               1049.00      -18.36%    -162.75   
691.00 1123.00  886.25  106.64
innodb  delete_autocommit                     3.00      +18.92%       0.70     
3.00    4.00    3.70    0.46
innodb  delete_big                            1.00     -300.00%      -0.75     
0.00    1.00    0.25    0.43
innodb  delete_big_many_keys               1049.00      -18.43%    -163.25   
691.00 1122.00  885.75  106.51
innodb  delete_commit                         2.00       -5.26%      -0.10     
1.00    2.00    1.90    0.30
innodb  delete_key                            3.00       -1.69%      -0.05     
2.00    3.00    2.95    0.22
innodb  delete_range                          8.00       -2.56%      -0.20     
7.00    9.00    7.80    0.51
innodb  delete_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  drop_index                            3.00       +1.64%       0.05     
2.00    4.00    3.05    0.38
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  drop_table_when_MANY_tables          20.00       -3.90%      -0.75    
18.00   21.00   19.25    0.94
innodb  insert                              112.00       +1.80%       2.05   
112.00  116.00  114.05    1.12
innodb  insert_autocommit                     4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  insert_commit                         2.00      -14.29%      -0.25     
1.00    2.00    1.75    0.43
innodb  insert_duplicates                    20.00       -1.27%      -0.25    
19.00   21.00   19.75    0.54
innodb  insert_key                          283.00       -0.07%      -0.20   
265.00  297.00  282.80    7.49
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                   6.00      -20.00%      -1.00     
3.00    6.00    5.00    0.77
innodb  insert_select_2_keys                  6.00       +4.76%       0.30     
6.00    7.00    6.30    0.46
innodb  min_max                               8.00       +3.03%       0.25     
6.00    9.00    8.25    0.99
innodb  min_max_on_key                       25.00       -0.00%       0.00    
24.00   26.00   25.00    0.63
innodb  multiple_value_insert                 6.00       -5.26%      -0.30     
5.00    7.00    5.70    0.56
innodb  once_prepared_select                 30.00       -2.04%      -0.60    
29.00   30.00   29.40    0.49
innodb  order_by_big                         13.00       +7.14%       1.00    
13.00   16.00   14.00    1.00
innodb  order_by_big_key                     13.00       +8.77%       1.25    
13.00   16.00   14.25    1.22
innodb  order_by_big_key2                    13.00       -2.77%      -0.35    
11.00   14.00   12.65    1.01
innodb  order_by_big_key_desc                15.00       -0.00%       0.00    
13.00   16.00   15.00    1.00
innodb  order_by_big_key_diff                12.00       +5.51%       0.70    
11.00   14.00   12.70    0.95
innodb  order_by_big_key_prefix              14.00       -5.26%      -0.70    
12.00   15.00   13.30    0.84
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      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           24.00       -8.60%      -1.90    
17.00   26.00   22.10    2.75
innodb  outer_join_found                     22.00       -5.26%      -1.10    
17.00   24.00   20.90    2.36
innodb  outer_join_not_found                 20.00       -6.67%      -1.25    
15.00   22.00   18.75    2.32
innodb  outer_join_on_key                    15.00       -8.30%      -1.15    
11.00   16.00   13.85    1.62
innodb  prepared_select                      37.00       +0.40%       0.15    
36.00   38.00   37.15    0.57
innodb  select_1_row                          4.00       -9.59%      -0.35     
3.00    4.00    3.65    0.48
innodb  select_1_row_cache                    3.00      +17.81%       0.65     
3.00    4.00    3.65    0.48
innodb  select_2_rows                         4.00       -6.67%      -0.25     
3.00    4.00    3.75    0.43
innodb  select_big                           11.00      +13.04%       1.65    
11.00   14.00   12.65    1.24
innodb  select_big_str                        1.00      +31.03%       0.45     
1.00    2.00    1.45    0.50
innodb  select_cache                         62.00       +1.43%       0.90    
57.00   79.00   62.90    4.38
innodb  select_cache2                        62.00       +6.34%       4.20    
60.00   88.00   66.20    5.66
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       -9.89%      -0.45     
4.00    5.00    4.55    0.50
innodb  select_group                         15.00      +14.04%       2.45    
15.00   20.00   17.45    1.66
innodb  select_group_when_MANY_tables        12.00       +0.83%       0.10    
11.00   14.00   12.10    0.77
innodb  select_join                           1.00      -33.33%      -0.25     
0.00    1.00    0.75    0.43
innodb  select_key                           66.00       -1.93%      -1.25    
63.00   67.00   64.75    0.89
innodb  select_key2                          73.00       -1.96%      -1.40    
70.00   74.00   71.60    0.97
innodb  select_key2_return_key               70.00       -1.23%      -0.85    
68.00   71.00   69.15    0.85
innodb  select_key2_return_prim              71.00       -1.65%      -1.15    
69.00   72.00   69.85    0.85
innodb  select_key_prefix                    71.00       +0.21%       0.15    
70.00   73.00   71.15    0.79
innodb  select_key_prefix_join                4.00      +23.81%       1.25     
4.00    7.00    5.25    0.62
innodb  select_key_return_key                63.00       +1.18%       0.75    
63.00   66.00   63.75    0.83
innodb  select_many_fields                   13.00       +1.89%       0.25    
12.00   17.00   13.25    0.94
innodb  select_range                         40.00       +6.43%       2.75    
39.00   49.00   42.75    2.55
innodb  select_range_key2                    11.00      -13.40%      -1.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.70
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                     3.00       +9.09%       0.30     
3.00    4.00    3.30    0.46
innodb  update_big                           58.00       -0.00%       0.00    
56.00   61.00   58.00    1.52
innodb  update_commit                         2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  update_of_key                        22.00       +1.35%       0.30    
21.00   24.00   22.30    0.71
innodb  update_of_key_big                    19.00       +0.26%       0.05    
18.00   21.00   19.05    0.86
innodb  update_of_primary_key_many_keys    1339.00       -3.79%     -48.95  
1173.00 1452.00 1290.05   56.30
innodb  update_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  update_with_key                     119.00       +0.46%       0.55   
116.00  122.00  119.55    1.50
innodb  update_with_key_prefix               43.00       +0.92%       0.40    
41.00   46.00   43.40    1.24
innodb  wisc_benchmark                        2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00      -41.01%      -9.31    
11.00   61.00   22.69   10.12
innodb  alter_table_drop                     25.00      -29.87%      -5.75    
10.00   57.00   19.25    6.75
innodb  connect                               2.00       +4.84%       0.10     
1.00    3.00    2.10    0.42
innodb  connect+select_1_row                  3.00       -9.67%      -0.26     
2.00    5.00    2.74    0.45
innodb  connect+select_simple                 3.00      -25.79%      -0.62     
1.00    3.00    2.38    0.49
innodb  count                                18.00      -14.12%      -2.23    
12.00  193.00   15.77    8.17
innodb  count_distinct                        8.00      -20.85%      -1.38     
5.00   50.00    6.62    2.12
innodb  count_distinct_2                     13.00       +2.04%       0.27    
11.00   63.00   13.27    2.78
innodb  count_distinct_big                   24.00       -8.66%      -1.91     
5.00   67.00   22.09    2.91
innodb  count_distinct_group                 13.00       +2.60%       0.35    
10.00   68.00   13.35    2.92
innodb  count_distinct_group_on_key           8.00      +16.19%       1.55     
7.00   69.00    9.55    2.82
innodb  count_distinct_group_on_key_parts    11.00      +11.70%       1.46     
9.00   72.00   12.46    2.97
innodb  count_distinct_key_prefix             6.00      -16.39%      -0.84     
3.00   52.00    5.16    2.21
innodb  count_group_on_key_parts             11.00       -8.46%      -0.86     
7.00   72.00   10.14    2.94
innodb  count_on_key                         93.00       -6.50%      -5.67    
68.00  107.00   87.33    7.58
innodb  create+drop                          34.00       -4.46%      -1.45    
18.00   75.00   32.55   10.96
innodb  create_index                          3.00       -2.88%      -0.08     
1.00    8.00    2.92    1.07
innodb  create_key+drop                      33.00      -15.02%      -4.31    
21.00   50.00   28.69    4.71
innodb  create_MANY_tables                   21.00      +34.54%      11.08    
14.00  121.00   32.08   16.45
innodb  create_table                          0.00     +100.00%       0.09     
0.00    3.00    0.09    0.34
innodb  delete_all_many_keys               1049.00     -104.37%    -535.72   
212.00 1888.00  513.28  358.63
innodb  delete_autocommit                     3.00      +13.50%       0.47     
2.00   14.00    3.47    0.72
innodb  delete_big                            1.00     -224.36%      -0.69     
0.00    3.00    0.31    0.47
innodb  delete_big_many_keys               1049.00     -102.44%    -530.81   
212.00 2293.00  518.19  370.14
innodb  delete_commit                         2.00      -27.62%      -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.73%       0.31     
5.00   23.00    8.31    3.00
innodb  delete_rollback                       2.00      -11.82%      -0.21     
1.00   12.00    1.79    0.86
innodb  drop_index                            3.00       -1.37%      -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          20.00       -2.77%      -0.54    
11.00   90.00   19.46    6.96
innodb  insert                              112.00       -4.03%      -4.33     
3.00  343.00  107.67   13.66
innodb  insert_autocommit                     4.00      -32.20%      -0.97     
2.00   99.00    3.03    3.06
innodb  insert_commit                         2.00      -38.25%      -0.55     
1.00    3.00    1.45    0.51
innodb  insert_duplicates                    20.00      -24.76%      -3.97    
11.00   21.00   16.03    2.80
innodb  insert_key                          283.00       +5.53%      16.56   
142.00  700.00  299.56   98.39
innodb  insert_many_fields                    6.00       -6.59%      -0.37     
3.00   17.00    5.63    1.65
innodb  insert_rollback                       2.00      -16.39%      -0.28     
1.00    3.00    1.72    0.51
innodb  insert_select_1_key                   6.00      -54.00%      -2.10     
2.00   10.00    3.90    0.92
innodb  insert_select_2_keys                  6.00       +1.67%       0.10     
4.00   16.00    6.10    1.94
innodb  min_max                               8.00       -1.93%      -0.15     
6.00  110.00    7.85    4.21
innodb  min_max_on_key                       25.00      -18.20%      -3.85    
14.00   37.00   21.15    3.20
innodb  multiple_value_insert                 6.00       -8.32%      -0.46     
2.00   50.00    5.54    3.97
innodb  once_prepared_select                 30.00      -20.36%      -5.07    
18.00   32.00   24.93    3.72
innodb  order_by_big                         13.00       +8.97%       1.28    
12.00   31.00   14.28    1.47
innodb  order_by_big_key                     13.00       +3.16%       0.42    
11.00   32.00   13.42    1.63
innodb  order_by_big_key2                    13.00       -5.72%      -0.70    
10.00   33.00   12.30    1.49
innodb  order_by_big_key_desc                15.00       -9.34%      -1.28    
11.00   32.00   13.72    1.69
innodb  order_by_big_key_diff                12.00       +2.66%       0.33    
10.00   31.00   12.33    1.44
innodb  order_by_big_key_prefix              14.00      -11.99%      -1.50    
10.00   32.00   12.50    1.49
innodb  order_by_key2_diff                    1.00      +28.55%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -24.20%      -0.19     
0.00    2.00    0.81    0.40
innodb  order_by_range                        1.00      -18.38%      -0.16     
0.00    2.00    0.84    0.37
innodb  outer_join                           24.00      -21.56%      -4.26    
15.00   61.00   19.74    3.70
innodb  outer_join_found                     22.00      -15.17%      -2.90    
14.00   58.00   19.10    3.53
innodb  outer_join_not_found                 20.00      -18.66%      -3.15    
12.00   46.00   16.85    3.20
innodb  outer_join_on_key                    15.00      -14.42%      -1.89    
10.00   59.00   13.11    2.69
innodb  prepared_select                      37.00      -15.06%      -4.84    
22.00   40.00   32.16    4.62
innodb  select_1_row                          4.00      -35.16%      -1.04     
2.00    4.00    2.96    0.71
innodb  select_1_row_cache                    3.00       -7.04%      -0.20     
2.00    4.00    2.80    0.72
innodb  select_2_rows                         4.00      -33.64%      -1.01     
2.00    4.00    2.99    0.73
innodb  select_big                           11.00      +10.12%       1.24     
0.00   31.00   12.24    1.50
innodb  select_big_str                        1.00      +16.40%       0.20     
0.00    2.00    1.20    0.40
innodb  select_cache                         62.00       -2.80%      -1.69    
49.00   79.00   60.31    5.66
innodb  select_cache2                        62.00       -1.98%      -1.20    
49.00   88.00   60.80    6.34
innodb  select_column+column                  4.00      -31.09%      -0.95     
2.00    4.00    3.05    0.74
innodb  select_diff_key                       1.00     -347.35%      -0.78     
0.00    1.00    0.22    0.42
innodb  select_distinct                       5.00      -16.54%      -0.71     
3.00    8.00    4.29    0.55
innodb  select_group                         15.00       +8.38%       1.37     
4.00  136.00   16.37    5.05
innodb  select_group_when_MANY_tables        12.00      -22.05%      -2.17     
3.00   49.00    9.83    8.77
innodb  select_join                           1.00      -68.55%      -0.41     
0.00    1.00    0.59    0.49
innodb  select_key                           66.00      -21.28%     -11.58    
40.00   67.00   54.42    7.96
innodb  select_key2                          73.00      -19.43%     -11.87    
45.00   75.00   61.13    8.66
innodb  select_key2_return_key               70.00      -19.70%     -11.52    
42.00   71.00   58.48    8.53
innodb  select_key2_return_prim              71.00      -19.85%     -11.76    
42.00   72.00   59.24    8.65
innodb  select_key_prefix                    71.00      -17.49%     -10.57    
44.00   75.00   60.43    8.74
innodb  select_key_prefix_join                4.00      +16.68%       0.80     
3.00   10.00    4.80    0.66
innodb  select_key_return_key                63.00      -17.92%      -9.57    
38.00   66.00   53.43    7.94
innodb  select_many_fields                   13.00      +11.53%       1.69    
11.00   19.00   14.69    1.78
innodb  select_range                         40.00      +14.10%       6.57    
38.00   76.00   46.57    4.06
innodb  select_range_key2                    11.00      -30.12%      -2.55     
6.00   11.00    8.45    1.09
innodb  select_range_prefix                   8.00       +0.50%       0.04     
5.00   10.00    8.04    1.16
innodb  select_simple                         2.00      -17.11%      -0.29     
1.00    3.00    1.71    0.50
innodb  select_simple_cache                   2.00      -22.86%      -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                     3.00      +10.47%       0.35     
2.00   16.00    3.35    0.96
innodb  update_big                           58.00      -11.31%      -5.89    
31.00  195.00   52.11   22.75
innodb  update_commit                         2.00      -23.26%      -0.38     
1.00   10.00    1.62    0.69
innodb  update_of_key                        22.00       +8.08%       1.93    
18.00  100.00   23.93    5.75
innodb  update_of_key_big                    19.00      +30.22%       8.23    
15.00   75.00   27.23   10.68
innodb  update_of_primary_key_many_keys    1339.00       -6.96%     -87.14   
647.00 6065.00 1251.86  867.42
innodb  update_rollback                       2.00      -10.84%      -0.20     
1.00   31.00    1.80    1.76
innodb  update_with_key                     119.00       -6.86%      -7.64    
90.00  598.00  111.36   19.54
innodb  update_with_key_prefix               43.00       -6.99%      -2.81    
33.00  202.00   40.19    6.48
innodb  wisc_benchmark                        2.00      +19.62%       0.49     
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