=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   906
RUN DATE: 2011-02-18T11:57:03.866485
SERVER:   drizzled
VERSION:  staging
REVISION: 2182
COMMENT:  2182: Brian Aker 2011-02-18 [merge] Rollup of:

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      34.00       -1.80%      -0.60    
32.00   35.00   33.40    1.02
innodb  alter_table_drop                     24.00       -0.00%       0.00    
23.00   26.00   24.00    1.10
innodb  connect                               2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  count                                18.00      -12.50%      -2.00    
13.00   18.00   16.00    2.10
innodb  count_distinct                        7.00       -2.94%      -0.20     
6.00    8.00    6.80    0.75
innodb  count_distinct_2                     15.00       -8.70%      -1.20    
12.00   15.00   13.80    1.17
innodb  count_distinct_big                   25.00       -6.84%      -1.60    
21.00   25.00   23.40    1.96
innodb  count_distinct_group                 15.00       -0.00%       0.00    
15.00   15.00   15.00    0.00
innodb  count_distinct_group_on_key          12.00      -15.38%      -1.60     
9.00   12.00   10.40    1.02
innodb  count_distinct_group_on_key_parts    14.00       -2.94%      -0.40    
13.00   14.00   13.60    0.49
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             12.00       -7.14%      -0.80    
11.00   12.00   11.20    0.40
innodb  count_on_key                        105.00       -6.49%      -6.40    
94.00  105.00   98.60    3.77
innodb  create+drop                          34.00       -2.41%      -0.80    
33.00   34.00   33.20    0.40
innodb  create_index                          2.00      +28.57%       0.80     
2.00    3.00    2.80    0.40
innodb  create_key+drop                      33.00       -4.43%      -1.40    
30.00   33.00   31.60    1.36
innodb  create_MANY_tables                   20.00       +4.76%       1.00    
20.00   23.00   21.00    1.10
innodb  create_table                          0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_all_many_keys                667.00       -1.77%     -11.60   
604.00  711.00  655.40   35.25
innodb  delete_autocommit                     3.00      +16.67%       0.60     
3.00    5.00    3.60    0.80
innodb  delete_big                            1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                667.00       -1.86%     -12.20   
603.00  710.00  654.80   35.22
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                          9.00       -2.27%      -0.20     
8.00   10.00    8.80    0.75
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
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       +2.17%       0.40    
18.00   19.00   18.40    0.49
innodb  insert                              114.00       +0.52%       0.60   
112.00  117.00  114.60    1.62
innodb  insert_autocommit                     4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  insert_commit                         1.00      +44.44%       0.80     
1.00    2.00    1.80    0.40
innodb  insert_duplicates                    19.00       +1.04%       0.20    
19.00   20.00   19.20    0.40
innodb  insert_key                          281.00       -0.00%       0.00   
265.00  304.00  281.00   12.82
innodb  insert_many_fields                    5.00      +16.67%       1.00     
5.00    7.00    6.00    0.63
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  insert_select_2_keys                  6.00       -0.00%       0.00     
6.00    6.00    6.00    0.00
innodb  min_max                               9.00       -7.14%      -0.60     
7.00    9.00    8.40    0.80
innodb  min_max_on_key                       25.00       -1.63%      -0.40    
24.00   25.00   24.60    0.49
innodb  multiple_value_insert                 5.00      +16.67%       1.00     
5.00    7.00    6.00    0.63
innodb  once_prepared_select                 30.00       -2.04%      -0.60    
29.00   30.00   29.40    0.49
innodb  order_by_big                         16.00       -9.59%      -1.40    
13.00   16.00   14.60    1.36
innodb  order_by_big_key                     13.00      +15.58%       2.40    
13.00   16.00   15.40    1.20
innodb  order_by_big_key2                    13.00       +5.80%       0.80    
13.00   15.00   13.80    0.75
innodb  order_by_big_key_desc                14.00      +10.26%       1.60    
14.00   16.00   15.60    0.80
innodb  order_by_big_key_diff                15.00      -10.29%      -1.40    
12.00   15.00   13.60    1.02
innodb  order_by_big_key_prefix              13.00       +2.99%       0.40    
12.00   15.00   13.40    1.02
innodb  order_by_key2_diff                    2.00      -25.00%      -0.40     
1.00    2.00    1.60    0.49
innodb  order_by_key_prefix                   0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           22.00       -2.80%      -0.60    
18.00   24.00   21.40    2.50
innodb  outer_join_found                     23.00      -11.65%      -2.40    
17.00   23.00   20.60    2.58
innodb  outer_join_not_found                 19.00       -0.00%       0.00    
16.00   22.00   19.00    2.28
innodb  outer_join_on_key                    16.00       -8.11%      -1.20    
12.00   17.00   14.80    1.94
innodb  prepared_select                      38.00       -1.60%      -0.60    
37.00   38.00   37.40    0.49
innodb  select_1_row                          3.00      +11.76%       0.40     
3.00    4.00    3.40    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                           12.00      +10.45%       1.40    
12.00   14.00   13.40    0.80
innodb  select_big_str                        1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  select_cache                         64.00       -2.56%      -1.60    
57.00   64.00   62.40    2.73
innodb  select_cache2                        62.00       -0.65%      -0.40    
57.00   64.00   61.60    2.58
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_diff_key                       0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  select_distinct                       4.00      +16.67%       0.80     
4.00    5.00    4.80    0.40
innodb  select_group                         18.00       -2.27%      -0.40    
16.00   18.00   17.60    0.80
innodb  select_group_when_MANY_tables        12.00       +1.64%       0.20    
12.00   13.00   12.20    0.40
innodb  select_join                           1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  select_key                           64.00       -0.31%      -0.20    
63.00   65.00   63.80    0.75
innodb  select_key2                          73.00       -2.53%      -1.80    
69.00   73.00   71.20    1.47
innodb  select_key2_return_key               69.00       -1.17%      -0.80    
67.00   69.00   68.20    0.98
innodb  select_key2_return_prim              70.00       -1.16%      -0.80    
68.00   70.00   69.20    0.98
innodb  select_key_prefix                    72.00       -1.98%      -1.40    
69.00   72.00   70.60    1.02
innodb  select_key_prefix_join                5.00       +3.85%       0.20     
5.00    6.00    5.20    0.40
innodb  select_key_return_key                63.00       -0.64%      -0.40    
62.00   63.00   62.60    0.49
innodb  select_many_fields                   15.00      -10.29%      -1.40    
13.00   15.00   13.60    0.80
innodb  select_range                         40.00       +4.31%       1.80    
39.00   47.00   41.80    2.79
innodb  select_range_key2                    10.00       -4.17%      -0.40     
9.00   10.00    9.60    0.49
innodb  select_range_prefix                  10.00       -6.38%      -0.60     
9.00   10.00    9.40    0.49
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  update_autocommit                     3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  update_big                           57.00       +1.72%       1.00    
57.00   60.00   58.00    1.10
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        22.00       -1.85%      -0.40    
21.00   22.00   21.60    0.49
innodb  update_of_key_big                    35.00       -6.06%      -2.00    
29.00   38.00   33.00    3.29
innodb  update_of_primary_key_many_keys    1367.00       -1.02%     -13.80  
1242.00 1489.00 1353.20   79.87
innodb  update_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  update_with_key                     125.00       -1.46%      -1.80   
120.00  128.00  123.20    2.93
innodb  update_with_key_prefix               45.00       -2.27%      -1.00    
42.00   47.00   44.00    1.90
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                      34.00       -3.50%      -1.15    
31.00   35.00   32.85    1.01
innodb  alter_table_drop                     24.00       -0.63%      -0.15    
23.00   26.00   23.85    0.96
innodb  connect                               2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  connect+select_1_row                  3.00       -1.69%      -0.05     
2.00    3.00    2.95    0.22
innodb  connect+select_simple                 3.00      -13.21%      -0.35     
2.00    3.00    2.65    0.48
innodb  count                                18.00      -14.65%      -2.30    
13.00   18.00   15.70    1.98
innodb  count_distinct                        7.00       -2.94%      -0.20     
6.00    8.00    6.80    0.68
innodb  count_distinct_2                     15.00       -9.09%      -1.25    
12.00   16.00   13.75    1.18
innodb  count_distinct_big                   25.00       -9.65%      -2.20    
20.00   25.00   22.80    1.75
innodb  count_distinct_group                 15.00       -3.09%      -0.45    
11.00   16.00   14.55    1.12
innodb  count_distinct_group_on_key          12.00      -13.21%      -1.40     
9.00   17.00   10.60    2.15
innodb  count_distinct_group_on_key_parts    14.00       -5.26%      -0.70    
11.00   15.00   13.30    1.10
innodb  count_distinct_key_prefix             6.00      -14.29%      -0.75     
4.00    7.00    5.25    0.70
innodb  count_group_on_key_parts             12.00       -8.11%      -0.90    
11.00   12.00   11.10    0.30
innodb  count_on_key                        105.00      -10.70%     -10.15    
91.00  105.00   94.85    3.32
innodb  create+drop                          34.00       -5.43%      -1.75    
30.00   34.00   32.25    1.04
innodb  create_index                          2.00      +33.33%       1.00     
2.00    4.00    3.00    0.45
innodb  create_key+drop                      33.00       -9.63%      -2.90    
28.00   33.00   30.10    1.37
innodb  create_MANY_tables                   20.00       +3.15%       0.65    
19.00   23.00   20.65    0.91
innodb  create_table                          0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_all_many_keys                667.00       -0.84%      -5.55   
604.00  738.00  661.45   37.16
innodb  delete_autocommit                     3.00      +16.67%       0.60     
3.00    5.00    3.60    0.58
innodb  delete_big                            1.00     -185.71%      -0.65     
0.00    1.00    0.35    0.48
innodb  delete_big_many_keys                667.00       -0.97%      -6.40   
603.00  737.00  660.60   37.15
innodb  delete_commit                         2.00       -8.11%      -0.15     
1.00    2.00    1.85    0.36
innodb  delete_key                            3.00       -3.45%      -0.10     
2.00    3.00    2.90    0.30
innodb  delete_range                          9.00       -3.45%      -0.30     
7.00   10.00    8.70    0.78
innodb  delete_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  drop_index                            4.00      -26.98%      -0.85     
2.00    4.00    3.15    0.57
innodb  drop_table_when_MANY_tables          18.00       -7.46%      -1.25    
15.00   19.00   16.75    1.18
innodb  insert                              114.00       +0.35%       0.40   
112.00  117.00  114.40    1.24
innodb  insert_autocommit                     4.00      -21.21%      -0.70     
3.00    4.00    3.30    0.46
innodb  insert_commit                         1.00      +42.86%       0.75     
1.00    2.00    1.75    0.43
innodb  insert_duplicates                    19.00       +0.52%       0.10    
18.00   20.00   19.10    0.54
innodb  insert_key                          281.00       +0.64%       1.80   
265.00  304.00  282.80   12.06
innodb  insert_many_fields                    5.00      +12.28%       0.70     
5.00    7.00    5.70    0.56
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   4.00       -3.90%      -0.15     
3.00    5.00    3.85    0.48
innodb  insert_select_2_keys                  6.00       +3.23%       0.20     
4.00    8.00    6.20    0.87
innodb  min_max                               9.00      -12.50%      -1.00     
6.00    9.00    8.00    1.00
innodb  min_max_on_key                       25.00       -2.04%      -0.50    
24.00   26.00   24.50    0.59
innodb  multiple_value_insert                 5.00      +23.66%       1.55     
5.00    8.00    6.55    0.74
innodb  once_prepared_select                 30.00       -2.21%      -0.65    
29.00   30.00   29.35    0.48
innodb  order_by_big                         16.00      -10.73%      -1.55    
13.00   16.00   14.45    1.28
innodb  order_by_big_key                     13.00      +11.86%       1.75    
12.00   17.00   14.75    1.41
innodb  order_by_big_key2                    13.00       +1.52%       0.20    
12.00   15.00   13.20    0.81
innodb  order_by_big_key_desc                14.00       +8.20%       1.25    
14.00   16.00   15.25    0.83
innodb  order_by_big_key_diff                15.00      -14.94%      -1.95    
11.00   15.00   13.05    1.02
innodb  order_by_big_key_prefix              13.00       +3.70%       0.50    
12.00   15.00   13.50    0.81
innodb  order_by_key2_diff                    2.00      -33.33%      -0.50     
1.00    2.00    1.50    0.50
innodb  order_by_key_prefix                   0.00     +100.00%       0.85     
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                           22.00       +1.12%       0.25    
17.00   26.00   22.25    2.88
innodb  outer_join_found                     23.00       -7.98%      -1.70    
17.00   25.00   21.30    2.67
innodb  outer_join_not_found                 19.00       +1.55%       0.30    
14.00   22.00   19.30    2.57
innodb  outer_join_on_key                    16.00       -7.38%      -1.10    
11.00   17.00   14.90    1.97
innodb  prepared_select                      38.00       -1.88%      -0.70    
37.00   38.00   37.30    0.46
innodb  select_1_row                          3.00      +13.04%       0.45     
3.00    4.00    3.45    0.50
innodb  select_1_row_cache                    4.00      -12.68%      -0.45     
3.00    4.00    3.55    0.50
innodb  select_2_rows                         3.00      +14.29%       0.50     
3.00    4.00    3.50    0.50
innodb  select_big                           12.00       +8.75%       1.15    
12.00   15.00   13.15    0.91
innodb  select_big_str                        1.00      +23.08%       0.30     
1.00    2.00    1.30    0.46
innodb  select_cache                         64.00       -0.16%      -0.10    
57.00   71.00   63.90    3.82
innodb  select_cache2                        62.00       +0.88%       0.55    
57.00   69.00   62.55    2.56
innodb  select_column+column                  4.00       -3.90%      -0.15     
3.00    4.00    3.85    0.36
innodb  select_diff_key                       0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  select_distinct                       4.00      +14.89%       0.70     
4.00    5.00    4.70    0.46
innodb  select_group                         18.00       -3.15%      -0.55    
15.00   19.00   17.45    1.24
innodb  select_group_when_MANY_tables        12.00       +0.83%       0.10    
11.00   14.00   12.10    0.83
innodb  select_join                           1.00      -81.82%      -0.45     
0.00    1.00    0.55    0.50
innodb  select_key                           64.00       -0.23%      -0.15    
63.00   66.00   63.85    0.79
innodb  select_key2                          73.00       -2.53%      -1.80    
69.00   73.00   71.20    1.25
innodb  select_key2_return_key               69.00       -0.73%      -0.50    
67.00   71.00   68.50    1.07
innodb  select_key2_return_prim              70.00       -0.72%      -0.50    
68.00   71.00   69.50    0.97
innodb  select_key_prefix                    72.00       -1.77%      -1.25    
69.00   73.00   70.75    0.94
innodb  select_key_prefix_join                5.00       +3.85%       0.20     
5.00    6.00    5.20    0.40
innodb  select_key_return_key                63.00       -0.00%       0.00    
62.00   65.00   63.00    0.77
innodb  select_many_fields                   15.00      -12.36%      -1.65    
13.00   15.00   13.35    0.57
innodb  select_range                         40.00       +4.65%       1.95    
39.00   49.00   41.95    2.67
innodb  select_range_key2                    10.00       -4.17%      -0.40     
9.00   10.00    9.60    0.49
innodb  select_range_prefix                  10.00       -9.89%      -0.90     
8.00   10.00    9.10    0.62
innodb  select_simple                         2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00      -53.85%      -0.35     
0.00    1.00    0.65    0.48
innodb  update_autocommit                     3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  update_big                           57.00       +3.31%       1.95    
56.00   63.00   58.95    1.96
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        22.00       +0.90%       0.20    
21.00   24.00   22.20    0.98
innodb  update_of_key_big                    35.00       -2.94%      -1.00    
29.00   38.00   34.00    2.98
innodb  update_of_primary_key_many_keys    1367.00       -0.43%      -5.90  
1242.00 1489.00 1361.10   69.41
innodb  update_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  update_with_key                     125.00       -1.75%      -2.15   
118.00  128.00  122.85    2.33
innodb  update_with_key_prefix               45.00       -2.27%      -1.00    
41.00   48.00   44.00    1.84
innodb  wisc_benchmark                        2.00      +24.53%       0.65     
2.00    3.00    2.65    0.48

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      34.00      -64.02%     -13.27    
11.00   61.00   20.73   10.04
innodb  alter_table_drop                     24.00      -31.57%      -5.76    
10.00   57.00   18.24    6.99
innodb  connect                               2.00       +3.79%       0.08     
1.00    3.00    2.08    0.42
innodb  connect+select_1_row                  3.00      -11.29%      -0.30     
2.00    5.00    2.70    0.48
innodb  connect+select_simple                 3.00      -28.40%      -0.66     
1.00    3.00    2.34    0.48
innodb  count                                18.00      -14.26%      -2.25    
12.00  193.00   15.75    8.94
innodb  count_distinct                        7.00       -6.64%      -0.44     
5.00   50.00    6.56    2.30
innodb  count_distinct_2                     15.00      -13.95%      -1.84    
11.00   63.00   13.16    2.98
innodb  count_distinct_big                   25.00      -14.06%      -3.08     
5.00   67.00   21.92    3.04
innodb  count_distinct_group                 15.00      -14.35%      -1.88    
10.00   68.00   13.12    3.12
innodb  count_distinct_group_on_key          12.00      -26.53%      -2.52     
7.00   69.00    9.48    3.05
innodb  count_distinct_group_on_key_parts    14.00      -13.88%      -1.71     
9.00   72.00   12.29    3.19
innodb  count_distinct_key_prefix             6.00      -17.12%      -0.88     
3.00   52.00    5.12    2.42
innodb  count_group_on_key_parts             12.00      -20.56%      -2.05     
7.00   72.00    9.95    3.19
innodb  count_on_key                        105.00      -22.40%     -19.22    
68.00  107.00   85.78    7.36
innodb  create+drop                          34.00       -4.90%      -1.59    
18.00   75.00   32.41   12.05
innodb  create_index                          2.00      +30.43%       0.87     
1.00    8.00    2.87    1.15
innodb  create_key+drop                      33.00      -17.42%      -4.90    
21.00   50.00   28.10    4.94
innodb  create_MANY_tables                   20.00      +41.90%      14.43    
14.00  121.00   34.43   17.18
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.37
innodb  delete_all_many_keys                667.00      -45.36%    -208.13   
212.00 1888.00  458.87  368.52
innodb  delete_autocommit                     3.00      +12.66%       0.43     
2.00   14.00    3.43    0.75
innodb  delete_big                            1.00     -254.66%      -0.72     
0.00    3.00    0.28    0.46
innodb  delete_big_many_keys                667.00      -43.38%    -201.80   
212.00 2293.00  465.20  383.07
innodb  delete_commit                         2.00      -32.96%      -0.50     
1.00    5.00    1.50    0.53
innodb  delete_key                            3.00       +2.22%       0.07     
2.00   35.00    3.07    1.51
innodb  delete_range                          9.00       -8.56%      -0.71     
5.00   23.00    8.29    3.28
innodb  delete_rollback                       2.00      -15.85%      -0.27     
1.00   12.00    1.73    0.92
innodb  drop_index                            4.00      -35.65%      -1.05     
1.00    9.00    2.95    1.34
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    2.00    0.05    0.23
innodb  drop_table_when_MANY_tables          18.00       +8.14%       1.60    
11.00   90.00   19.60    7.63
innodb  insert                              114.00       -7.03%      -7.49     
3.00  343.00  106.51   14.75
innodb  insert_autocommit                     4.00      -33.60%      -1.01     
2.00   99.00    2.99    3.36
innodb  insert_commit                         1.00      +26.64%       0.36     
1.00    3.00    1.36    0.49
innodb  insert_duplicates                    19.00      -23.73%      -3.64    
11.00   21.00   15.36    2.61
innodb  insert_key                          281.00       +7.52%      22.86   
142.00  700.00  303.86  108.61
innodb  insert_many_fields                    5.00      +10.68%       0.60     
3.00   17.00    5.60    1.79
innodb  insert_rollback                       2.00      -20.87%      -0.35     
1.00    3.00    1.65    0.53
innodb  insert_select_1_key                   4.00       -5.82%      -0.22     
2.00   10.00    3.78    0.89
innodb  insert_select_2_keys                  6.00       +1.12%       0.07     
4.00   16.00    6.07    2.12
innodb  min_max                               9.00      -14.99%      -1.17     
6.00  110.00    7.83    4.60
innodb  min_max_on_key                       25.00      -22.41%      -4.58    
14.00   37.00   20.42    3.05
innodb  multiple_value_insert                 5.00       +7.83%       0.42     
2.00   50.00    5.42    4.34
innodb  once_prepared_select                 30.00      -24.67%      -5.94    
18.00   32.00   24.06    3.52
innodb  order_by_big                         16.00      -11.84%      -1.69    
12.00   31.00   14.31    1.54
innodb  order_by_big_key                     13.00       +1.86%       0.25    
11.00   32.00   13.25    1.64
innodb  order_by_big_key2                    13.00       -6.81%      -0.83    
10.00   33.00   12.17    1.55
innodb  order_by_big_key_desc                14.00       -4.04%      -0.54    
11.00   32.00   13.46    1.67
innodb  order_by_big_key_diff                15.00      -22.94%      -2.80    
10.00   31.00   12.20    1.51
innodb  order_by_big_key_prefix              13.00       -5.05%      -0.62    
10.00   32.00   12.38    1.57
innodb  order_by_key2_diff                    2.00      -42.91%      -0.60     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   0.00     +100.00%       0.79     
0.00    2.00    0.79    0.42
innodb  order_by_range                        1.00      -20.63%      -0.17     
0.00    2.00    0.83    0.38
innodb  outer_join                           22.00      -14.18%      -2.73    
15.00   61.00   19.27    3.73
innodb  outer_join_found                     23.00      -23.00%      -4.30    
14.00   58.00   18.70    3.58
innodb  outer_join_not_found                 19.00      -15.94%      -2.61    
12.00   46.00   16.39    3.17
innodb  outer_join_on_key                    16.00      -24.43%      -3.14    
10.00   59.00   12.86    2.79
innodb  prepared_select                      38.00      -22.03%      -6.86    
22.00   40.00   31.14    4.45
innodb  select_1_row                          3.00       -5.90%      -0.17     
2.00    4.00    2.83    0.69
innodb  select_1_row_cache                    4.00      -50.72%      -1.35     
2.00    4.00    2.65    0.67
innodb  select_2_rows                         3.00       -5.14%      -0.15     
2.00    4.00    2.85    0.69
innodb  select_big                           12.00       +1.18%       0.14     
0.00   31.00   12.14    1.55
innodb  select_big_str                        1.00      +13.38%       0.15     
0.00    2.00    1.15    0.36
innodb  select_cache                         64.00       -7.52%      -4.48    
49.00   77.00   59.52    5.64
innodb  select_cache2                        62.00       -3.49%      -2.09    
49.00   75.00   59.91    6.34
innodb  select_column+column                  4.00      -37.83%      -1.10     
2.00    4.00    2.90    0.71
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.41
innodb  select_distinct                       4.00       +5.44%       0.23     
3.00    8.00    4.23    0.54
innodb  select_group                         18.00      -10.73%      -1.74     
4.00  136.00   16.26    5.50
innodb  select_group_when_MANY_tables        12.00      -27.89%      -2.62     
3.00   49.00    9.38    9.58
innodb  select_join                           1.00      -73.14%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           64.00      -22.11%     -11.59    
40.00   66.00   52.41    7.29
innodb  select_key2                          73.00      -23.53%     -13.91    
45.00   75.00   59.09    8.17
innodb  select_key2_return_key               69.00      -22.30%     -12.58    
42.00   71.00   56.42    7.95
innodb  select_key2_return_prim              70.00      -22.42%     -12.82    
42.00   72.00   57.18    8.11
innodb  select_key_prefix                    72.00      -23.43%     -13.67    
44.00   75.00   58.33    8.17
innodb  select_key_prefix_join                5.00       -6.16%      -0.29     
3.00   10.00    4.71    0.66
innodb  select_key_return_key                63.00      -22.47%     -11.56    
38.00   65.00   51.44    7.31
innodb  select_many_fields                   15.00       -0.02%       0.00    
11.00   19.00   15.00    1.79
innodb  select_range                         40.00      +15.26%       7.20    
39.00   76.00   47.20    3.94
innodb  select_range_key2                    10.00      -21.62%      -1.78     
6.00   11.00    8.22    1.03
innodb  select_range_prefix                  10.00      -28.32%      -2.21     
5.00   10.00    7.79    1.09
innodb  select_simple                         2.00      -22.34%      -0.37     
1.00    3.00    1.63    0.51
innodb  select_simple_cache                   2.00      -29.82%      -0.46     
1.00    3.00    1.54    0.51
innodb  select_simple_join                    1.00      -54.04%      -0.35     
0.00    3.00    0.65    0.48
innodb  update_autocommit                     3.00       +9.64%       0.32     
2.00   16.00    3.32    1.02
innodb  update_big                           57.00      -12.34%      -6.26    
31.00  195.00   50.74   24.78
innodb  update_commit                         2.00      -28.97%      -0.45     
1.00   10.00    1.55    0.73
innodb  update_of_key                        22.00       +9.40%       2.28    
18.00  100.00   24.28    6.25
innodb  update_of_key_big                    35.00      -28.79%      -7.82    
15.00   75.00   27.18   10.99
innodb  update_of_primary_key_many_keys    1367.00      -10.54%    -130.36   
647.00 6065.00 1236.64  977.24
innodb  update_rollback                       2.00      -14.34%      -0.25     
1.00   31.00    1.75    1.93
innodb  update_with_key                     125.00      -14.13%     -15.48    
90.00  598.00  109.52   21.00
innodb  update_with_key_prefix               45.00      -14.00%      -5.53    
33.00  202.00   39.47    6.85
innodb  wisc_benchmark                        2.00      +19.17%       0.47     
2.00    5.00    2.47    0.53

=========================================================================================================================
FULL REVISION COMMENTARY:

  2181.1.3: Brian Aker 2011-02-18 [merge] Andrew Hutchings 2011-02-18 Set the 
REPLICATION to FALSE for SYS_REPLICATION_LOG as we don't want to long manual 
changes to it
    2179.4.1: Andrew Hutchings 2011-02-18 Set the REPLICATION to FALSE for 
SYS_REPLICATION_LOG as we don't want to long manual changes to it
  2181.1.2: Brian Aker 2011-02-18 [merge] Andrew Hutchings 2011-02-18 Backport 
fix from http://bugs.mysql.com/bug.php?id=59149 which crashed drizzed
    2179.3.1: Andrew Hutchings 2011-02-18 Backport fix from 
http://bugs.mysql.com/bug.php?id=59149 which crashed drizzed
  2181.1.1: Brian Aker 2011-02-18 [merge] Merge in Andrew's drizzledump docs
    2177.1.1: Andrew Hutchings 2011-02-17 More fixups for drizzledump docs:

_______________________________________________
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