=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   1040
RUN DATE: 2011-06-22T17:20:51.858117
SERVER:   drizzled
VERSION:  staging
REVISION: 2346
COMMENT:  2346: Mark Atwood 2011-06-22 [merge] merge 
lp:~olafvdspek/drizzle/refactor13

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       -0.63%      -0.20    
30.00   34.00   31.80    1.60
innodb  alter_table_drop                     24.00       +1.64%       0.40    
24.00   25.00   24.40    0.49
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                                14.00      +10.26%       1.60    
14.00   18.00   15.60    1.96
innodb  count_distinct                        8.00      -14.29%      -1.00     
6.00    8.00    7.00    0.63
innodb  count_distinct_2                     13.00       +1.52%       0.20    
12.00   16.00   13.20    1.47
innodb  count_distinct_big                   21.00       +3.67%       0.80    
21.00   25.00   21.80    1.60
innodb  count_distinct_group                 15.00       -4.17%      -0.60    
12.00   15.00   14.40    1.20
innodb  count_distinct_group_on_key          10.00      -11.11%      -1.00     
8.00   10.00    9.00    0.63
innodb  count_distinct_group_on_key_parts    13.00       -3.17%      -0.40    
11.00   14.00   12.60    1.02
innodb  count_distinct_key_prefix             6.00      -11.11%      -0.60     
5.00    6.00    5.40    0.49
innodb  count_group_on_key_parts             12.00       -7.14%      -0.80    
11.00   12.00   11.20    0.40
innodb  count_on_key                         94.00       +2.89%       2.80    
94.00  102.00   96.80    3.19
innodb  create+drop                          34.00       -5.59%      -1.80    
31.00   34.00   32.20    0.98
innodb  create_index                          3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  create_key+drop                      30.00       +2.60%       0.80    
29.00   33.00   30.80    1.47
innodb  create_MANY_tables                   21.00       -0.00%       0.00    
20.00   24.00   21.00    1.55
innodb  delete_all_many_keys                858.00       -2.85%     -23.80   
798.00  863.00  834.20   28.60
innodb  delete_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  delete_big                            0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  delete_big_many_keys                858.00       -2.88%     -24.00   
798.00  863.00  834.00   28.49
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  delete_range                          9.00       -4.65%      -0.40     
8.00    9.00    8.60    0.49
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            4.00      -25.00%      -0.80     
3.00    4.00    3.20    0.40
innodb  drop_table_when_MANY_tables          19.00       -0.00%       0.00    
18.00   20.00   19.00    0.63
innodb  insert                              114.00       -2.15%      -2.40   
110.00  114.00  111.60    1.62
innodb  insert_autocommit                     4.00      -25.00%      -0.80     
3.00    4.00    3.20    0.40
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                          278.00       -0.58%      -1.60   
275.00  278.00  276.40    1.02
innodb  insert_many_fields                    6.00       -0.00%       0.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                   5.00       -0.00%       0.00     
5.00    5.00    5.00    0.00
innodb  insert_select_2_keys                  6.00       +3.23%       0.20     
6.00    7.00    6.20    0.40
innodb  min_max                               7.00       +5.41%       0.40     
7.00    9.00    7.40    0.80
innodb  min_max_on_key                       24.00       +2.44%       0.60    
24.00   25.00   24.60    0.49
innodb  multiple_value_insert                 5.00       +7.41%       0.40     
5.00    6.00    5.40    0.49
innodb  once_prepared_select                 29.00       -0.00%       0.00    
28.00   30.00   29.00    0.63
innodb  order_by_big                         12.00      +13.04%       1.80    
12.00   15.00   13.80    1.17
innodb  order_by_big_key                     16.00       -8.11%      -1.20    
13.00   16.00   14.80    1.17
innodb  order_by_big_key2                    12.00       +7.69%       1.00    
12.00   14.00   13.00    0.63
innodb  order_by_big_key_desc                14.00       +4.11%       0.60    
13.00   16.00   14.60    1.20
innodb  order_by_big_key_diff                12.00       +7.69%       1.00    
12.00   14.00   13.00    0.63
innodb  order_by_big_key_prefix              12.00       +7.69%       1.00    
12.00   14.00   13.00    0.63
innodb  order_by_key2_diff                    2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  order_by_key_prefix                   1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  order_by_range                        1.00      -25.00%      -0.20     
0.00    1.00    0.80    0.40
innodb  outer_join                           24.00      -12.15%      -2.60    
18.00   24.00   21.40    2.42
innodb  outer_join_found                     22.00       -7.84%      -1.60    
17.00   23.00   20.40    2.42
innodb  outer_join_not_found                 21.00      -12.90%      -2.40    
16.00   21.00   18.60    2.15
innodb  outer_join_on_key                    15.00       -7.14%      -1.00    
12.00   16.00   14.00    1.67
innodb  prepared_select                      36.00       +1.64%       0.60    
36.00   38.00   36.60    0.80
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                         73.00       -8.31%      -5.60    
63.00   73.00   67.40    3.20
innodb  select_cache2                        72.00       -8.11%      -5.40    
61.00   74.00   66.60    5.35
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_distinct                       5.00       -4.17%      -0.20     
4.00    5.00    4.80    0.40
innodb  select_group                         19.00       -9.20%      -1.60    
15.00   19.00   17.40    1.62
innodb  select_group_when_MANY_tables        12.00       -0.00%       0.00    
12.00   12.00   12.00    0.00
innodb  select_join                           0.00     +100.00%       0.80     
0.00    1.00    0.80    0.40
innodb  select_key                           63.00       +0.94%       0.60    
63.00   65.00   63.60    0.80
innodb  select_key2                          70.00       +1.13%       0.80    
70.00   72.00   70.80    0.75
innodb  select_key2_return_key               67.00       +1.76%       1.20    
67.00   70.00   68.20    0.98
innodb  select_key2_return_prim              68.00       +1.45%       1.00    
68.00   71.00   69.00    1.10
innodb  select_key_prefix                    69.00       +1.43%       1.00    
69.00   72.00   70.00    1.10
innodb  select_key_prefix_join                5.00       -0.00%       0.00     
5.00    5.00    5.00    0.00
innodb  select_key_return_key                62.00       +0.64%       0.40    
61.00   64.00   62.40    1.02
innodb  select_many_fields                   14.00       -2.94%      -0.40    
13.00   14.00   13.60    0.49
innodb  select_range                         49.00       -7.46%      -3.40    
40.00   49.00   45.60    3.32
innodb  select_range_key2                     9.00       +6.25%       0.60     
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       +9.09%       0.20     
2.00    3.00    2.20    0.40
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                           60.00       -1.35%      -0.80    
57.00   61.00   59.20    1.47
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        22.00       -2.80%      -0.60    
21.00   22.00   21.40    0.49
innodb  update_of_key_big                    20.00       -4.17%      -0.80    
18.00   20.00   19.20    0.75
innodb  update_of_primary_key_many_keys    1254.00       +0.82%      10.40  
1245.00 1293.00 1264.40   19.40
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     117.00       +1.52%       1.80   
117.00  121.00  118.80    1.60
innodb  update_with_key_prefix               44.00       -3.77%      -1.60    
41.00   44.00   42.40    1.02
innodb  wisc_benchmark                        3.00      -15.38%      -0.40     
2.00    3.00    2.60    0.49

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       -0.47%      -0.15    
26.00   34.00   31.85    1.88
innodb  alter_table_drop                     24.00       +1.03%       0.25    
23.00   26.00   24.25    0.94
innodb  connect                               2.00      +18.37%       0.45     
2.00    3.00    2.45    0.50
innodb  connect+select_1_row                  3.00       -3.45%      -0.10     
2.00    3.00    2.90    0.30
innodb  connect+select_simple                 3.00      -22.45%      -0.55     
2.00    3.00    2.45    0.50
innodb  count                                14.00      +14.63%       2.40    
13.00   18.00   16.40    1.74
innodb  count_distinct                        8.00      -12.68%      -0.90     
6.00    8.00    7.10    0.83
innodb  count_distinct_2                     13.00       +5.11%       0.70    
12.00   16.00   13.70    1.49
innodb  count_distinct_big                   21.00      +10.26%       2.40    
21.00   25.00   23.40    1.88
innodb  count_distinct_group                 15.00       -6.38%      -0.90    
12.00   15.00   14.10    1.09
innodb  count_distinct_group_on_key          10.00       -3.09%      -0.30     
8.00   11.00    9.70    0.95
innodb  count_distinct_group_on_key_parts    13.00       -2.36%      -0.30    
11.00   15.00   12.70    1.35
innodb  count_distinct_key_prefix             6.00       -8.11%      -0.45     
5.00    7.00    5.55    0.59
innodb  count_group_on_key_parts             12.00       -7.62%      -0.85    
10.00   12.00   11.15    0.48
innodb  count_on_key                         94.00       +2.29%       2.20    
94.00  102.00   96.20    1.96
innodb  create+drop                          34.00       -4.29%      -1.40    
31.00   34.00   32.60    1.02
innodb  create_index                          3.00       +3.23%       0.10     
3.00    4.00    3.10    0.30
innodb  create_key+drop                      30.00       +4.61%       1.45    
29.00   35.00   31.45    1.60
innodb  create_MANY_tables                   21.00       -2.19%      -0.45    
19.00   24.00   20.55    0.97
innodb  delete_all_many_keys                858.00       -1.38%     -11.65   
737.00 1098.00  846.35   91.34
innodb  delete_autocommit                     3.00      +15.49%       0.55     
3.00    4.00    3.55    0.50
innodb  delete_big                            0.00     +100.00%       0.50     
0.00    1.00    0.50    0.50
innodb  delete_big_many_keys                858.00       -1.43%     -12.10   
736.00 1098.00  845.90   91.30
innodb  delete_commit                         2.00       -5.26%      -0.10     
1.00    2.00    1.90    0.30
innodb  delete_key                            3.00       -3.45%      -0.10     
2.00    3.00    2.90    0.30
innodb  delete_range                          9.00       -9.76%      -0.80     
7.00    9.00    8.20    0.51
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            4.00      -29.03%      -0.90     
2.00    4.00    3.10    0.44
innodb  drop_table_when_MANY_tables          19.00       -1.88%      -0.35    
18.00   20.00   18.65    0.73
innodb  insert                              114.00       -1.79%      -2.00   
110.00  114.00  112.00    1.26
innodb  insert_autocommit                     4.00      -29.03%      -0.90     
3.00    4.00    3.10    0.30
innodb  insert_commit                         1.00      +45.95%       0.85     
1.00    2.00    1.85    0.36
innodb  insert_duplicates                    19.00       -0.00%       0.00    
18.00   20.00   19.00    0.45
innodb  insert_key                          278.00       -0.18%      -0.50   
264.00  300.00  277.50    7.28
innodb  insert_many_fields                    6.00       -1.69%      -0.10     
5.00    7.00    5.90    0.54
innodb  insert_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  insert_select_1_key                   5.00       -1.01%      -0.05     
4.00    6.00    4.95    0.59
innodb  insert_select_2_keys                  6.00       +3.23%       0.20     
5.00    7.00    6.20    0.51
innodb  min_max                               7.00      +15.15%       1.25     
6.00   11.00    8.25    1.18
innodb  min_max_on_key                       24.00       +2.04%       0.50    
24.00   26.00   24.50    0.59
innodb  multiple_value_insert                 5.00       +8.26%       0.45     
4.00    7.00    5.45    0.67
innodb  once_prepared_select                 29.00       -0.00%       0.00    
28.00   30.00   29.00    0.45
innodb  order_by_big                         12.00      +15.49%       2.20    
12.00   16.00   14.20    1.03
innodb  order_by_big_key                     16.00      -10.34%      -1.50    
12.00   16.00   14.50    1.20
innodb  order_by_big_key2                    12.00      +10.11%       1.35    
12.00   14.00   13.35    0.57
innodb  order_by_big_key_desc                14.00       +7.59%       1.15    
13.00   16.00   15.15    1.01
innodb  order_by_big_key_diff                12.00       +8.05%       1.05    
12.00   14.00   13.05    0.67
innodb  order_by_big_key_prefix              12.00      +10.11%       1.35    
12.00   14.00   13.35    0.65
innodb  order_by_key2_diff                    2.00      -33.33%      -0.50     
1.00    2.00    1.50    0.50
innodb  order_by_key_prefix                   1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  order_by_range                        1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  outer_join                           24.00       -8.11%      -1.80    
18.00   25.00   22.20    2.27
innodb  outer_join_found                     22.00       -3.53%      -0.75    
17.00   24.00   21.25    2.12
innodb  outer_join_not_found                 21.00      -10.24%      -1.95    
16.00   21.00   19.05    2.04
innodb  outer_join_on_key                    15.00       -5.63%      -0.80    
11.00   16.00   14.20    1.50
innodb  prepared_select                      36.00       +2.17%       0.80    
36.00   38.00   36.80    0.68
innodb  select_1_row                          4.00       -6.67%      -0.25     
3.00    4.00    3.75    0.43
innodb  select_1_row_cache                    3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
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   15.00   12.85    0.96
innodb  select_big_str                        1.00      +25.93%       0.35     
1.00    2.00    1.35    0.48
innodb  select_cache                         73.00       -9.61%      -6.40    
60.00   73.00   66.60    3.04
innodb  select_cache2                        72.00       -7.70%      -5.15    
61.00   74.00   66.85    3.89
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.25     
0.00    1.00    0.25    0.43
innodb  select_distinct                       5.00       -9.89%      -0.45     
4.00    5.00    4.55    0.50
innodb  select_group                         19.00       -9.20%      -1.60    
15.00   19.00   17.40    1.46
innodb  select_group_when_MANY_tables        12.00       -1.69%      -0.20    
11.00   13.00   11.80    0.60
innodb  select_join                           0.00     +100.00%       0.80     
0.00    1.00    0.80    0.40
innodb  select_key                           63.00       +1.18%       0.75    
63.00   65.00   63.75    0.70
innodb  select_key2                          70.00       +0.85%       0.60    
69.00   72.00   70.60    0.86
innodb  select_key2_return_key               67.00       +1.69%       1.15    
67.00   70.00   68.15    0.96
innodb  select_key2_return_prim              68.00       +1.23%       0.85    
68.00   71.00   68.85    0.96
innodb  select_key_prefix                    69.00       +1.50%       1.05    
68.00   72.00   70.05    0.97
innodb  select_key_prefix_join                5.00       +2.91%       0.15     
5.00    6.00    5.15    0.36
innodb  select_key_return_key                62.00       +0.88%       0.55    
61.00   64.00   62.55    0.74
innodb  select_many_fields                   14.00       -4.48%      -0.60    
13.00   14.00   13.40    0.49
innodb  select_range                         49.00      -10.86%      -4.80    
40.00   49.00   44.20    3.31
innodb  select_range_key2                     9.00       +5.76%       0.55     
9.00   10.00    9.55    0.50
innodb  select_range_prefix                  10.00       -7.53%      -0.70     
8.00   10.00    9.30    0.56
innodb  select_simple                         2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
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      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  update_big                           60.00       -3.09%      -1.80    
55.00   61.00   58.20    1.60
innodb  update_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  update_of_key                        22.00       -1.15%      -0.25    
21.00   23.00   21.75    0.62
innodb  update_of_key_big                    20.00       -5.26%      -1.00    
18.00   20.00   19.00    0.63
innodb  update_of_primary_key_many_keys    1254.00       +1.46%      18.55  
1184.00 1379.00 1272.55   46.38
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     117.00       +1.27%       1.50   
116.00  121.00  118.50    1.60
innodb  update_with_key_prefix               44.00       -3.65%      -1.55    
40.00   45.00   42.45    1.20
innodb  wisc_benchmark                        3.00      -20.00%      -0.50     
2.00    3.00    2.50    0.50

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00      -43.80%      -9.75    
11.00   61.00   22.25   10.16
innodb  alter_table_drop                     24.00      -26.43%      -5.02    
10.00   57.00   18.98    6.79
innodb  connect                               2.00       +4.64%       0.10     
1.00    3.00    2.10    0.42
innodb  connect+select_1_row                  3.00       -9.94%      -0.27     
2.00    5.00    2.73    0.46
innodb  connect+select_simple                 3.00      -26.27%      -0.62     
1.00    3.00    2.38    0.49
innodb  count                                14.00      +11.16%       1.76    
12.00  193.00   15.76    8.35
innodb  count_distinct                        8.00      -21.25%      -1.40     
5.00   50.00    6.60    2.16
innodb  count_distinct_2                     13.00       +1.91%       0.25    
11.00   63.00   13.25    2.83
innodb  count_distinct_big                   21.00       +4.74%       1.04     
5.00   67.00   22.04    2.94
innodb  count_distinct_group                 15.00      -12.91%      -1.72    
10.00   68.00   13.28    2.97
innodb  count_distinct_group_on_key          10.00       -5.06%      -0.48     
7.00   69.00    9.52    2.87
innodb  count_distinct_group_on_key_parts    13.00       -4.81%      -0.60     
9.00   72.00   12.40    3.01
innodb  count_distinct_key_prefix             6.00      -16.43%      -0.85     
3.00   52.00    5.15    2.26
innodb  count_group_on_key_parts             12.00      -18.83%      -1.90     
7.00   72.00   10.10    3.00
innodb  count_on_key                         94.00       -8.11%      -7.05    
68.00  107.00   86.95    7.53
innodb  create+drop                          34.00       -4.60%      -1.49    
18.00   75.00   32.51   11.23
innodb  create_index                          3.00       -3.06%      -0.09     
1.00    8.00    2.91    1.09
innodb  create_key+drop                      30.00       -5.14%      -1.47    
21.00   50.00   28.53    4.76
innodb  create_MANY_tables                   21.00      +35.58%      11.60    
14.00  121.00   32.60   16.67
innodb  create_table                          0.00     +100.00%       0.10     
0.00    3.00    0.10    0.35
innodb  delete_all_many_keys                858.00      -73.16%    -362.50   
212.00 1888.00  495.50  357.85
innodb  delete_autocommit                     3.00      +13.25%       0.46     
2.00   14.00    3.46    0.73
innodb  delete_big                            0.00     +100.00%       0.31     
0.00    3.00    0.31    0.47
innodb  delete_big_many_keys                858.00      -71.35%    -357.27   
212.00 2293.00  500.73  370.23
innodb  delete_commit                         2.00      -28.84%      -0.45     
1.00    5.00    1.55    0.52
innodb  delete_key                            3.00       +1.03%       0.03     
2.00   35.00    3.03    1.42
innodb  delete_range                          9.00       -8.14%      -0.68     
5.00   23.00    8.32    3.06
innodb  delete_rollback                       2.00      -12.60%      -0.22     
1.00   12.00    1.78    0.88
innodb  drop_index                            4.00      -35.20%      -1.04     
1.00    9.00    2.96    1.26
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.22
innodb  drop_table_when_MANY_tables          19.00       +2.43%       0.47    
11.00   90.00   19.47    7.12
innodb  insert                              114.00       -6.17%      -6.62     
3.00  343.00  107.38   13.92
innodb  insert_autocommit                     4.00      -32.69%      -0.99     
2.00   99.00    3.01    3.13
innodb  insert_commit                         1.00      +29.97%       0.43     
1.00    3.00    1.43    0.50
innodb  insert_duplicates                    19.00      -19.78%      -3.14    
11.00   21.00   15.86    2.76
innodb  insert_key                          278.00       +7.43%      22.31   
142.00  700.00  300.31  100.90
innodb  insert_many_fields                    6.00       -6.58%      -0.37     
3.00   17.00    5.63    1.68
innodb  insert_rollback                       2.00      -17.33%      -0.30     
1.00    3.00    1.70    0.52
innodb  insert_select_1_key                   5.00      -30.06%      -1.16     
2.00   10.00    3.84    0.90
innodb  insert_select_2_keys                  6.00       +1.41%       0.09     
4.00   16.00    6.09    1.98
innodb  min_max                               7.00      +10.63%       0.83     
6.00  110.00    7.83    4.31
innodb  min_max_on_key                       24.00      -14.45%      -3.03    
14.00   37.00   20.97    3.17
innodb  multiple_value_insert                 5.00       +9.55%       0.53     
2.00   50.00    5.53    4.06
innodb  once_prepared_select                 29.00      -17.30%      -4.28    
18.00   32.00   24.72    3.69
innodb  order_by_big                         12.00      +16.05%       2.29    
12.00   31.00   14.29    1.49
innodb  order_by_big_key                     16.00      -19.58%      -2.62    
11.00   32.00   13.38    1.64
innodb  order_by_big_key2                    12.00       +2.32%       0.29    
10.00   33.00   12.29    1.51
innodb  order_by_big_key_desc                14.00       -2.51%      -0.34    
11.00   32.00   13.66    1.69
innodb  order_by_big_key_diff                12.00       +2.50%       0.31    
10.00   31.00   12.31    1.46
innodb  order_by_big_key_prefix              12.00       +3.77%       0.47    
10.00   32.00   12.47    1.51
innodb  order_by_key2_diff                    2.00      -42.71%      -0.60     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -24.87%      -0.20     
0.00    2.00    0.80    0.40
innodb  order_by_range                        1.00      -19.16%      -0.16     
0.00    2.00    0.84    0.37
innodb  outer_join                           24.00      -22.23%      -4.37    
15.00   61.00   19.63    3.71
innodb  outer_join_found                     22.00      -15.67%      -2.98    
14.00   58.00   19.02    3.55
innodb  outer_join_not_found                 21.00      -25.31%      -4.24    
12.00   46.00   16.76    3.20
innodb  outer_join_on_key                    15.00      -14.67%      -1.92    
10.00   59.00   13.08    2.73
innodb  prepared_select                      36.00      -12.80%      -4.09    
22.00   40.00   31.91    4.60
innodb  select_1_row                          4.00      -36.63%      -1.07     
2.00    4.00    2.93    0.71
innodb  select_1_row_cache                    3.00       -8.54%      -0.24     
2.00    4.00    2.76    0.71
innodb  select_2_rows                         4.00      -35.10%      -1.04     
2.00    4.00    2.96    0.72
innodb  select_big                           13.00       -6.44%      -0.79     
0.00   31.00   12.21    1.51
innodb  select_big_str                        1.00      +15.66%       0.19     
0.00    2.00    1.19    0.39
innodb  select_cache                         73.00      -21.43%     -12.88    
49.00   77.00   60.12    5.60
innodb  select_cache2                        72.00      -19.00%     -11.49    
49.00   76.00   60.51    6.24
innodb  select_column+column                  4.00      -32.74%      -0.99     
2.00    4.00    3.01    0.74
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.42
innodb  select_distinct                       5.00      -17.06%      -0.73     
3.00    8.00    4.27    0.55
innodb  select_group                         19.00      -16.36%      -2.67     
4.00  136.00   16.33    5.16
innodb  select_group_when_MANY_tables        12.00      -23.40%      -2.28     
3.00   49.00    9.72    8.97
innodb  select_join                           0.00     +100.00%       0.59     
0.00    1.00    0.59    0.49
innodb  select_key                           63.00      -16.81%      -9.07    
40.00   66.00   53.93    7.83
innodb  select_key2                          70.00      -15.45%      -9.37    
45.00   75.00   60.63    8.57
innodb  select_key2_return_key               67.00      -15.57%      -9.03    
42.00   71.00   57.97    8.41
innodb  select_key2_return_prim              68.00      -15.77%      -9.26    
42.00   72.00   58.74    8.54
innodb  select_key_prefix                    69.00      -15.15%      -9.08    
44.00   75.00   59.92    8.63
innodb  select_key_prefix_join                5.00       -4.91%      -0.23     
3.00   10.00    4.77    0.64
innodb  select_key_return_key                62.00      -17.11%      -9.06    
38.00   65.00   52.94    7.82
innodb  select_many_fields                   14.00       +5.19%       0.77    
11.00   19.00   14.77    1.78
innodb  select_range                         49.00       -4.91%      -2.29    
38.00   76.00   46.71    4.06
innodb  select_range_key2                     9.00       -7.20%      -0.60     
6.00   11.00    8.40    1.08
innodb  select_range_prefix                  10.00      -25.19%      -2.01     
5.00   10.00    7.99    1.15
innodb  select_simple                         2.00      -18.24%      -0.31     
1.00    3.00    1.69    0.51
innodb  select_simple_cache                   2.00      -24.65%      -0.40     
1.00    3.00    1.60    0.51
innodb  select_simple_join                    1.00      -49.07%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     3.00      +10.48%       0.35     
2.00   16.00    3.35    0.97
innodb  update_big                           60.00      -15.80%      -8.19    
31.00  195.00   51.81   23.25
innodb  update_commit                         2.00      -24.68%      -0.40     
1.00   10.00    1.60    0.70
innodb  update_of_key                        22.00       +8.36%       2.01    
18.00  100.00   24.01    5.88
innodb  update_of_key_big                    20.00      +27.58%       7.62    
15.00   75.00   27.62   10.78
innodb  update_of_primary_key_many_keys    1254.00       -0.38%      -4.81   
647.00 6065.00 1249.19  893.32
innodb  update_rollback                       2.00      -11.56%      -0.21     
1.00   31.00    1.79    1.80
innodb  update_with_key                     117.00       -5.48%      -6.07    
90.00  598.00  110.93   19.91
innodb  update_with_key_prefix               44.00       -9.87%      -3.95    
33.00  202.00   40.05    6.59
innodb  wisc_benchmark                        3.00      -20.73%      -0.52     
2.00    5.00    2.48    0.52

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

  2318.6.39: Olaf van der Spek 2011-06-22 Oops
  2318.6.38: Olaf van der Spek 2011-06-22 [merge] Merge trunk
  2318.6.37: Olaf van der Spek 2011-06-21 Refactor
  2318.6.36: Olaf van der Spek 2011-06-21 Refactor
  2318.6.35: Olaf van der Spek 2011-06-21 [merge] Merge trunk
  2318.6.34: Olaf van der Spek 2011-06-21 Refactor
  2318.6.33: Olaf van der Spek 2011-06-21 Refactor
  2318.6.32: Olaf van der Spek 2011-06-21 Refactor
  2318.6.31: Olaf van der Spek 2011-06-21 Refactor
  2318.6.30: Olaf van der Spek 2011-06-21 Refactor
  2318.6.29: Olaf van der Spek 2011-06-21 Refactor
  2318.6.28: Olaf van der Spek 2011-06-21 Oops
  2318.6.27: Olaf van der Spek 2011-06-21 Refactor
  2318.6.26: Olaf van der Spek 2011-06-21 Refactor
  2318.6.25: Olaf van der Spek 2011-06-21 Refactor
  2318.6.24: Olaf van der Spek 2011-06-21 Refactor
  2318.6.23: Olaf van der Spek 2011-06-21 Refactor
  2318.6.22: Olaf van der Spek 2011-06-21 Refactor
  2318.6.21: Olaf van der Spek 2011-06-21 Refactor
  2318.6.20: Olaf van der Spek 2011-06-21 Refactor
  2318.6.19: Olaf van der Spek 2011-06-21 Refactor
  2318.6.18: Olaf van der Spek 2011-06-21 Refactor

_______________________________________________
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