=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   1021
RUN DATE: 2011-06-08T16:51:11.639586
SERVER:   drizzled
VERSION:  staging
REVISION: 2327
COMMENT:  2327: Mark Atwood 2011-06-08 [merge] merge 
lp:~linuxjedi/drizzle/trunk-remove-drizzleadmin

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      31.00       +1.27%       0.40    
31.00   32.00   31.40    0.49
innodb  alter_table_drop                     25.00       -5.04%      -1.20    
23.00   25.00   23.80    0.75
innodb  connect                               3.00      -36.36%      -0.80     
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                 2.00      +28.57%       0.80     
2.00    3.00    2.80    0.40
innodb  count                                18.00      -11.11%      -1.80    
14.00   18.00   16.20    1.83
innodb  count_distinct                        8.00      -14.29%      -1.00     
6.00    8.00    7.00    0.89
innodb  count_distinct_2                     12.00      +13.04%       1.80    
12.00   15.00   13.80    1.47
innodb  count_distinct_big                   25.00       -7.76%      -1.80    
21.00   25.00   23.20    1.83
innodb  count_distinct_group                 15.00       -4.17%      -0.60    
13.00   15.00   14.40    0.80
innodb  count_distinct_group_on_key           9.00       +6.25%       0.60     
9.00   11.00    9.60    0.80
innodb  count_distinct_group_on_key_parts    12.00      +10.45%       1.40    
12.00   14.00   13.40    0.80
innodb  count_distinct_key_prefix             5.00       +3.85%       0.20     
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                         94.00       +0.84%       0.80    
91.00   99.00   94.80    2.56
innodb  create+drop                          31.00       +3.13%       1.00    
31.00   33.00   32.00    0.89
innodb  create_index                          3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  create_key+drop                      30.00       -0.00%       0.00    
29.00   32.00   30.00    1.10
innodb  create_MANY_tables                   21.00       -2.94%      -0.60    
19.00   21.00   20.40    0.80
innodb  delete_all_many_keys                991.00       -2.42%     -23.40   
855.00 1049.00  967.60   72.79
innodb  delete_autocommit                     4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  delete_big                            1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                990.00       -2.38%     -23.00   
854.00 1049.00  967.00   72.87
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       -0.00%       0.00     
7.00    9.00    8.00    0.63
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  drop_table_when_MANY_tables          18.00       +5.26%       1.00    
18.00   21.00   19.00    1.10
innodb  insert                              110.00       +1.08%       1.20   
110.00  113.00  111.20    1.17
innodb  insert_autocommit                     3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  insert_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  insert_duplicates                    19.00       +1.04%       0.20    
19.00   20.00   19.20    0.40
innodb  insert_key                          272.00       +2.72%       7.60   
272.00  302.00  279.60   11.36
innodb  insert_many_fields                    5.00      +13.79%       0.80     
5.00    7.00    5.80    0.75
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   5.00       -4.17%      -0.20     
4.00    5.00    4.80    0.40
innodb  insert_select_2_keys                  6.00       +6.25%       0.40     
6.00    7.00    6.40    0.49
innodb  min_max                               9.00       -9.76%      -0.80     
7.00    9.00    8.20    0.75
innodb  min_max_on_key                       24.00       +1.64%       0.40    
24.00   25.00   24.40    0.49
innodb  multiple_value_insert                 5.00      +13.79%       0.80     
5.00    7.00    5.80    0.75
innodb  once_prepared_select                 29.00       -0.69%      -0.20    
28.00   29.00   28.80    0.40
innodb  order_by_big                         15.00       -5.63%      -0.80    
13.00   15.00   14.20    0.98
innodb  order_by_big_key                     12.00      +14.29%       2.00    
12.00   16.00   14.00    1.41
innodb  order_by_big_key2                    13.00       +2.99%       0.40    
13.00   14.00   13.40    0.49
innodb  order_by_big_key_desc                16.00       -6.67%      -1.00    
14.00   16.00   15.00    0.89
innodb  order_by_big_key_diff                13.00       +1.52%       0.20    
11.00   15.00   13.20    1.33
innodb  order_by_big_key_prefix              14.00       -6.06%      -0.80    
12.00   14.00   13.20    0.75
innodb  order_by_key2_diff                    1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
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      -13.21%      -2.80    
18.00   24.00   21.20    2.64
innodb  outer_join_found                     23.00      -16.16%      -3.20    
16.00   23.00   19.80    2.79
innodb  outer_join_not_found                 21.00      -10.53%      -2.00    
16.00   21.00   19.00    2.45
innodb  outer_join_on_key                    15.00      -10.29%      -1.40    
11.00   15.00   13.60    1.74
innodb  prepared_select                      36.00       +0.55%       0.20    
36.00   37.00   36.20    0.40
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       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  select_2_rows                         4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_big                           13.00       -1.56%      -0.20    
12.00   14.00   12.80    0.75
innodb  select_big_str                        1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  select_cache                         65.00       -0.93%      -0.60    
61.00   67.00   64.40    1.96
innodb  select_cache2                        62.00       +4.91%       3.20    
62.00   72.00   65.20    3.87
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.60     
0.00    1.00    0.60    0.49
innodb  select_distinct                       5.00       -8.70%      -0.40     
4.00    5.00    4.60    0.49
innodb  select_group                         16.00       +6.98%       1.20    
15.00   19.00   17.20    1.47
innodb  select_group_when_MANY_tables        11.00       +5.17%       0.60    
11.00   13.00   11.60    0.80
innodb  select_join                           1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  select_key                           63.00       +0.63%       0.40    
63.00   64.00   63.40    0.49
innodb  select_key2                          69.00       +1.43%       1.00    
69.00   71.00   70.00    0.89
innodb  select_key2_return_key               67.00       +0.59%       0.40    
67.00   68.00   67.40    0.49
innodb  select_key2_return_prim              68.00       +0.87%       0.60    
68.00   69.00   68.60    0.49
innodb  select_key_prefix                    69.00       +1.15%       0.80    
69.00   71.00   69.80    0.75
innodb  select_key_prefix_join                5.00       +3.85%       0.20     
5.00    6.00    5.20    0.40
innodb  select_key_return_key                62.00       +0.96%       0.60    
62.00   63.00   62.60    0.49
innodb  select_many_fields                   14.00       -6.06%      -0.80    
13.00   14.00   13.20    0.40
innodb  select_range                         41.00       +7.24%       3.20    
41.00   48.00   44.20    2.23
innodb  select_range_key2                     9.00       +6.25%       0.60     
9.00   10.00    9.60    0.49
innodb  select_range_prefix                  10.00       -8.70%      -0.80     
8.00   10.00    9.20    0.75
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      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  update_autocommit                     3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  update_big                           58.00       +1.02%       0.60    
57.00   60.00   58.60    1.02
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        21.00       +7.08%       1.60    
21.00   24.00   22.60    1.02
innodb  update_of_key_big                    20.00       -5.26%      -1.00    
18.00   20.00   19.00    0.89
innodb  update_of_primary_key_many_keys    1249.00       +3.09%      39.80  
1236.00 1432.00 1288.80   72.91
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     116.00       +0.51%       0.60   
116.00  119.00  116.60    1.20
innodb  update_with_key_prefix               42.00       +0.47%       0.20    
41.00   44.00   42.20    1.17
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                      31.00       +1.43%       0.45    
25.00   35.00   31.45    1.88
innodb  alter_table_drop                     25.00       -5.04%      -1.20    
23.00   25.00   23.80    0.68
innodb  connect                               3.00      -39.53%      -0.85     
2.00    3.00    2.15    0.36
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 2.00      +25.93%       0.70     
2.00    3.00    2.70    0.46
innodb  count                                18.00      -14.65%      -2.30    
13.00   18.00   15.70    1.90
innodb  count_distinct                        8.00      -18.52%      -1.25     
6.00    8.00    6.75    0.83
innodb  count_distinct_2                     12.00      +14.89%       2.10    
12.00   16.00   14.10    1.26
innodb  count_distinct_big                   25.00      -10.62%      -2.40    
20.00   25.00   22.60    2.01
innodb  count_distinct_group                 15.00       -5.26%      -0.75    
12.00   16.00   14.25    1.30
innodb  count_distinct_group_on_key           9.00       +9.55%       0.95     
9.00   12.00    9.95    1.02
innodb  count_distinct_group_on_key_parts    12.00       +7.34%       0.95    
10.00   15.00   12.95    1.24
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             11.00       +3.08%       0.35    
11.00   13.00   11.35    0.57
innodb  count_on_key                         94.00       +1.42%       1.35    
91.00  100.00   95.35    2.76
innodb  create+drop                          31.00       +6.20%       2.05    
31.00   35.00   33.05    1.02
innodb  create_index                          3.00       -0.00%       0.00     
2.00    4.00    3.00    0.45
innodb  create_key+drop                      30.00       +3.38%       1.05    
29.00   34.00   31.05    1.40
innodb  create_MANY_tables                   21.00       -2.94%      -0.60    
19.00   23.00   20.40    1.07
innodb  create_table                          0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  delete_all_many_keys                991.00       -8.06%     -73.95   
640.00 1227.00  917.05  156.15
innodb  delete_autocommit                     4.00      -15.94%      -0.55     
3.00    4.00    3.45    0.50
innodb  delete_big                            1.00     -233.33%      -0.70     
0.00    1.00    0.30    0.46
innodb  delete_big_many_keys                990.00       -8.03%     -73.55   
639.00 1226.00  916.45  156.06
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       -3.45%      -0.10     
2.00    4.00    2.90    0.44
innodb  delete_range                          8.00       +1.84%       0.15     
7.00    9.00    8.15    0.65
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            3.00       +1.64%       0.05     
2.00    4.00    3.05    0.50
innodb  drop_table_when_MANY_tables          18.00       +4.26%       0.80    
18.00   21.00   18.80    0.81
innodb  insert                              110.00       +1.57%       1.75   
110.00  113.00  111.75    0.94
innodb  insert_autocommit                     3.00       +3.23%       0.10     
3.00    4.00    3.10    0.30
innodb  insert_commit                         2.00      -11.11%      -0.20     
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                          272.00       +2.93%       8.20   
264.00  305.00  280.20   10.74
innodb  insert_many_fields                    5.00      +13.79%       0.80     
5.00    7.00    5.80    0.60
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     
4.00    6.00    5.05    0.59
innodb  insert_select_2_keys                  6.00       +4.00%       0.25     
5.00    7.00    6.25    0.54
innodb  min_max                               9.00      -11.80%      -0.95     
6.00    9.00    8.05    1.02
innodb  min_max_on_key                       24.00       +2.64%       0.65    
24.00   26.00   24.65    0.57
innodb  multiple_value_insert                 5.00      +13.79%       0.80     
5.00    7.00    5.80    0.75
innodb  once_prepared_select                 29.00       -0.35%      -0.10    
28.00   30.00   28.90    0.44
innodb  order_by_big                         15.00       -7.53%      -1.05    
12.00   15.00   13.95    0.97
innodb  order_by_big_key                     12.00      +16.08%       2.30    
12.00   16.00   14.30    1.10
innodb  order_by_big_key2                    13.00       +1.89%       0.25    
12.00   14.00   13.25    0.77
innodb  order_by_big_key_desc                16.00       -4.92%      -0.75    
14.00   16.00   15.25    0.83
innodb  order_by_big_key_diff                13.00       -1.17%      -0.15    
11.00   15.00   12.85    0.96
innodb  order_by_big_key_prefix              14.00       -6.87%      -0.90    
12.00   14.00   13.10    0.62
innodb  order_by_key2_diff                    1.00      +25.93%       0.35     
1.00    2.00    1.35    0.48
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       -5.26%      -0.05     
0.00    1.00    0.95    0.22
innodb  outer_join                           24.00       -9.09%      -2.00    
17.00   25.00   22.00    2.63
innodb  outer_join_found                     23.00      -10.58%      -2.20    
16.00   24.00   20.80    2.58
innodb  outer_join_not_found                 21.00       -9.38%      -1.80    
15.00   22.00   19.20    2.40
innodb  outer_join_on_key                    15.00       -5.63%      -0.80    
11.00   17.00   14.20    1.75
innodb  prepared_select                      36.00       +2.04%       0.75    
36.00   37.00   36.75    0.43
innodb  select_1_row                          4.00      -12.68%      -0.45     
3.00    4.00    3.55    0.50
innodb  select_1_row_cache                    3.00      +13.04%       0.45     
3.00    4.00    3.45    0.50
innodb  select_2_rows                         4.00       -6.67%      -0.25     
3.00    4.00    3.75    0.43
innodb  select_big                           13.00       -1.17%      -0.15    
11.00   14.00   12.85    0.85
innodb  select_big_str                        1.00      +23.08%       0.30     
1.00    2.00    1.30    0.46
innodb  select_cache                         65.00       -1.72%      -1.10    
57.00   70.00   63.90    3.10
innodb  select_cache2                        62.00       +5.63%       3.70    
61.00   76.00   65.70    3.94
innodb  select_column+column                  4.00       -6.67%      -0.25     
3.00    4.00    3.75    0.43
innodb  select_diff_key                       0.00     +100.00%       0.25     
0.00    1.00    0.25    0.43
innodb  select_distinct                       5.00       -8.70%      -0.40     
4.00    5.00    4.60    0.49
innodb  select_group                         16.00       +5.04%       0.85    
15.00   19.00   16.85    1.39
innodb  select_group_when_MANY_tables        11.00       +7.56%       0.90    
11.00   14.00   11.90    0.83
innodb  select_join                           1.00      -42.86%      -0.30     
0.00    1.00    0.70    0.46
innodb  select_key                           63.00       +1.41%       0.90    
63.00   65.00   63.90    0.70
innodb  select_key2                          69.00       +2.13%       1.50    
69.00   72.00   70.50    0.74
innodb  select_key2_return_key               67.00       +1.25%       0.85    
67.00   69.00   67.85    0.73
innodb  select_key2_return_prim              68.00       +1.09%       0.75    
68.00   71.00   68.75    0.77
innodb  select_key_prefix                    69.00       +1.57%       1.10    
69.00   71.00   70.10    0.62
innodb  select_key_prefix_join                5.00       +3.85%       0.20     
5.00    6.00    5.20    0.40
innodb  select_key_return_key                62.00       +1.20%       0.75    
62.00   64.00   62.75    0.70
innodb  select_many_fields                   14.00       -6.46%      -0.85    
12.00   14.00   13.15    0.48
innodb  select_range                         41.00       +9.39%       4.25    
41.00   52.00   45.25    3.13
innodb  select_range_key2                     9.00       +6.25%       0.60     
9.00   11.00    9.60    0.66
innodb  select_range_prefix                  10.00       -6.95%      -0.65     
8.00   10.00    9.35    0.65
innodb  select_simple                         2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  select_simple_cache                   2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_join                    1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  update_autocommit                     3.00      +10.45%       0.35     
3.00    4.00    3.35    0.48
innodb  update_big                           58.00       +0.77%       0.45    
56.00   61.00   58.45    1.47
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        21.00       +5.83%       1.30    
21.00   24.00   22.30    0.84
innodb  update_of_key_big                    20.00       -5.54%      -1.05    
18.00   20.00   18.95    0.80
innodb  update_of_primary_key_many_keys    1249.00       +1.95%      24.90  
1105.00 1458.00 1273.90   76.74
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     116.00       +1.49%       1.75   
115.00  121.00  117.75    1.76
innodb  update_with_key_prefix               42.00       +1.52%       0.65    
40.00   46.00   42.65    1.59
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                      31.00      -40.52%      -8.94    
11.00   61.00   22.06   10.16
innodb  alter_table_drop                     25.00      -32.43%      -6.12    
10.00   57.00   18.88    6.82
innodb  connect                               3.00      -43.48%      -0.91     
1.00    3.00    2.09    0.42
innodb  connect+select_1_row                  3.00      -10.07%      -0.27     
2.00    5.00    2.73    0.46
innodb  connect+select_simple                 2.00      +15.75%       0.37     
1.00    3.00    2.37    0.49
innodb  count                                18.00      -14.30%      -2.25    
12.00  193.00   15.75    8.43
innodb  count_distinct                        8.00      -21.42%      -1.41     
5.00   50.00    6.59    2.18
innodb  count_distinct_2                     12.00       +9.38%       1.24    
11.00   63.00   13.24    2.85
innodb  count_distinct_big                   25.00      -13.54%      -2.98     
5.00   67.00   22.02    2.95
innodb  count_distinct_group                 15.00      -13.04%      -1.73    
10.00   68.00   13.27    2.99
innodb  count_distinct_group_on_key           9.00       +5.40%       0.51     
7.00   69.00    9.51    2.89
innodb  count_distinct_group_on_key_parts    12.00       +3.20%       0.40     
9.00   72.00   12.40    3.04
innodb  count_distinct_key_prefix             5.00       +2.81%       0.14     
3.00   52.00    5.14    2.28
innodb  count_group_on_key_parts             11.00       -9.16%      -0.92     
7.00   72.00   10.08    3.02
innodb  count_on_key                         94.00       -8.35%      -7.24    
68.00  107.00   86.76    7.49
innodb  create+drop                          31.00       +4.62%       1.50    
18.00   75.00   32.50   11.34
innodb  create_index                          3.00       -3.20%      -0.09     
1.00    8.00    2.91    1.10
innodb  create_key+drop                      30.00       -5.36%      -1.53    
21.00   50.00   28.47    4.78
innodb  create_MANY_tables                   21.00      +36.06%      11.84    
14.00  121.00   32.84   16.75
innodb  create_table                          0.00     +100.00%       0.10     
0.00    3.00    0.10    0.35
innodb  delete_all_many_keys                991.00     -102.95%    -502.70   
212.00 1888.00  488.30  357.85
innodb  delete_autocommit                     4.00      -15.72%      -0.54     
2.00   14.00    3.46    0.73
innodb  delete_big                            1.00     -228.47%      -0.70     
0.00    3.00    0.30    0.47
innodb  delete_big_many_keys                990.00     -100.54%    -496.32   
212.00 2293.00  493.68  370.60
innodb  delete_commit                         2.00      -29.41%      -0.45     
1.00    5.00    1.55    0.52
innodb  delete_key                            3.00       +1.12%       0.03     
2.00   35.00    3.03    1.44
innodb  delete_range                          8.00       +3.90%       0.32     
5.00   23.00    8.32    3.09
innodb  delete_rollback                       2.00      -12.89%      -0.23     
1.00   12.00    1.77    0.88
innodb  drop_index                            3.00       -1.50%      -0.04     
1.00    9.00    2.96    1.27
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.22
innodb  drop_table_when_MANY_tables          18.00       +7.64%       1.49    
11.00   90.00   19.49    7.19
innodb  insert                              110.00       -2.53%      -2.72     
3.00  343.00  107.28   14.05
innodb  insert_autocommit                     3.00       +0.42%       0.01     
2.00   99.00    3.01    3.16
innodb  insert_commit                         2.00      -40.88%      -0.58     
1.00    3.00    1.42    0.50
innodb  insert_duplicates                    19.00      -20.26%      -3.20    
11.00   21.00   15.80    2.75
innodb  insert_key                          272.00       +9.58%      28.81   
142.00  700.00  300.81  101.93
innodb  insert_many_fields                    5.00      +11.08%       0.62     
3.00   17.00    5.62    1.70
innodb  insert_rollback                       2.00      -17.81%      -0.30     
1.00    3.00    1.70    0.52
innodb  insert_select_1_key                   5.00      -30.81%      -1.18     
2.00   10.00    3.82    0.89
innodb  insert_select_2_keys                  6.00       +1.37%       0.08     
4.00   16.00    6.08    2.00
innodb  min_max                               9.00      -15.01%      -1.17     
6.00  110.00    7.83    4.34
innodb  min_max_on_key                       24.00      -14.84%      -3.10    
14.00   37.00   20.90    3.16
innodb  multiple_value_insert                 5.00       +9.57%       0.53     
2.00   50.00    5.53    4.10
innodb  once_prepared_select                 29.00      -17.71%      -4.36    
18.00   32.00   24.64    3.67
innodb  order_by_big                         15.00       -4.91%      -0.70    
12.00   31.00   14.30    1.50
innodb  order_by_big_key                     12.00      +10.15%       1.36    
11.00   32.00   13.36    1.64
innodb  order_by_big_key2                    13.00       -6.01%      -0.74    
10.00   33.00   12.26    1.52
innodb  order_by_big_key_desc                16.00      -17.41%      -2.37    
11.00   32.00   13.63    1.69
innodb  order_by_big_key_diff                13.00       -5.75%      -0.71    
10.00   31.00   12.29    1.47
innodb  order_by_big_key_prefix              14.00      -12.42%      -1.55    
10.00   32.00   12.45    1.52
innodb  order_by_key2_diff                    1.00      +28.52%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -25.17%      -0.20     
0.00    2.00    0.80    0.41
innodb  order_by_range                        1.00      -19.32%      -0.16     
0.00    2.00    0.84    0.37
innodb  outer_join                           24.00      -22.54%      -4.41    
15.00   61.00   19.59    3.72
innodb  outer_join_found                     23.00      -21.20%      -4.02    
14.00   58.00   18.98    3.56
innodb  outer_join_not_found                 21.00      -25.64%      -4.29    
12.00   46.00   16.71    3.21
innodb  outer_join_on_key                    15.00      -14.86%      -1.94    
10.00   59.00   13.06    2.74
innodb  prepared_select                      36.00      -13.15%      -4.18    
22.00   40.00   31.82    4.59
innodb  select_1_row                          4.00      -37.40%      -1.09     
2.00    4.00    2.91    0.70
innodb  select_1_row_cache                    3.00       -9.06%      -0.25     
2.00    4.00    2.75    0.71
innodb  select_2_rows                         4.00      -35.82%      -1.05     
2.00    4.00    2.95    0.72
innodb  select_big                           13.00       -6.55%      -0.80     
0.00   31.00   12.20    1.52
innodb  select_big_str                        1.00      +15.39%       0.18     
0.00    2.00    1.18    0.39
innodb  select_cache                         65.00       -8.36%      -5.02    
49.00   77.00   59.98    5.56
innodb  select_cache2                        62.00       -2.70%      -1.63    
49.00   76.00   60.37    6.21
innodb  select_column+column                  4.00      -33.43%      -1.00     
2.00    4.00    3.00    0.73
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.42
innodb  select_distinct                       5.00      -17.20%      -0.73     
3.00    8.00    4.27    0.55
innodb  select_group                         16.00       +1.88%       0.31     
4.00  136.00   16.31    5.20
innodb  select_group_when_MANY_tables        11.00      -13.61%      -1.32     
3.00   49.00    9.68    9.05
innodb  select_join                           1.00      -71.87%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           63.00      -17.24%      -9.26    
40.00   66.00   53.74    7.78
innodb  select_key2                          69.00      -14.18%      -8.57    
45.00   75.00   60.43    8.54
innodb  select_key2_return_key               67.00      -15.98%      -9.23    
42.00   71.00   57.77    8.37
innodb  select_key2_return_prim              68.00      -16.17%      -9.46    
42.00   72.00   58.54    8.50
innodb  select_key_prefix                    69.00      -15.54%      -9.28    
44.00   75.00   59.72    8.60
innodb  select_key_prefix_join                5.00       -5.08%      -0.24     
3.00   10.00    4.76    0.64
innodb  select_key_return_key                62.00      -17.54%      -9.25    
38.00   65.00   52.75    7.77
innodb  select_many_fields                   14.00       +5.37%       0.79    
11.00   19.00   14.79    1.79
innodb  select_range                         41.00      +12.31%       5.76    
38.00   76.00   46.76    4.06
innodb  select_range_key2                     9.00       -7.51%      -0.63     
6.00   11.00    8.37    1.07
innodb  select_range_prefix                  10.00      -25.60%      -2.04     
5.00   10.00    7.96    1.15
innodb  select_simple                         2.00      -18.82%      -0.32     
1.00    3.00    1.68    0.51
innodb  select_simple_cache                   2.00      -25.26%      -0.40     
1.00    3.00    1.60    0.51
innodb  select_simple_join                    1.00      -48.90%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     3.00      +10.44%       0.35     
2.00   16.00    3.35    0.98
innodb  update_big                           58.00      -12.22%      -6.31    
31.00  195.00   51.69   23.47
innodb  update_commit                         2.00      -25.22%      -0.40     
1.00   10.00    1.60    0.71
innodb  update_of_key                        21.00      +12.68%       3.05    
18.00  100.00   24.05    5.93
innodb  update_of_key_big                    20.00      +28.04%       7.79    
15.00   75.00   27.79   10.82
innodb  update_of_primary_key_many_keys    1249.00       -0.03%      -0.43   
647.00 6065.00 1248.57  904.49
innodb  update_rollback                       2.00      -11.82%      -0.21     
1.00   31.00    1.79    1.82
innodb  update_with_key                     116.00       -4.72%      -5.23    
90.00  598.00  110.77   20.07
innodb  update_with_key_prefix               42.00       -5.00%      -2.00    
33.00  202.00   40.00    6.64
innodb  wisc_benchmark                        2.00      +19.49%       0.48     
2.00    5.00    2.48    0.52

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

  2325.1.1: Andrew Hutchings 2011-06-07 Remove all drizzleadmin code (hopefully)

_______________________________________________
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