=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   893
RUN DATE: 2011-02-12T19:34:42.344604
SERVER:   drizzled
VERSION:  staging
REVISION: 2165
COMMENT:  2165: Brian Aker 2011-02-12 [merge] Merge in Olaf's work.

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       +2.44%       0.80    
32.00   34.00   32.80    0.75
innodb  alter_table_drop                     23.00       +2.54%       0.60    
23.00   25.00   23.60    0.80
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       +9.09%       1.40    
13.00   18.00   15.40    1.85
innodb  count_distinct                        7.00       -0.00%       0.00     
6.00    8.00    7.00    0.89
innodb  count_distinct_2                     13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  count_distinct_big                   23.00       +0.86%       0.20    
21.00   25.00   23.20    1.33
innodb  count_distinct_group                 11.00      +22.54%       3.20    
11.00   16.00   14.20    1.72
innodb  count_distinct_group_on_key          16.00      -50.94%      -5.40     
9.00   16.00   10.60    2.73
innodb  count_distinct_group_on_key_parts    11.00      +15.38%       2.00    
11.00   15.00   13.00    1.41
innodb  count_distinct_key_prefix             6.00      -25.00%      -1.20     
4.00    6.00    4.80    0.75
innodb  count_group_on_key_parts             11.00       +1.79%       0.20    
11.00   12.00   11.20    0.40
innodb  count_on_key                         96.00       -0.84%      -0.80    
92.00   97.00   95.20    1.72
innodb  create+drop                          30.00       +6.25%       2.00    
30.00   33.00   32.00    1.26
innodb  create_index                          3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  create_key+drop                      30.00       -3.45%      -1.00    
28.00   30.00   29.00    0.63
innodb  create_MANY_tables                   19.00       +5.00%       1.00    
19.00   21.00   20.00    0.89
innodb  create_table                          0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  delete_all_many_keys                632.00       +4.70%      31.20   
614.00  709.00  663.20   38.19
innodb  delete_autocommit                     4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  delete_big                            1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  delete_big_many_keys                630.00       +4.83%      32.00   
613.00  708.00  662.00   38.35
innodb  delete_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  delete_key                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  delete_range                          9.00       -7.14%      -0.60     
8.00    9.00    8.40    0.49
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  drop_table_when_MANY_tables          15.00       +6.25%       1.00    
15.00   17.00   16.00    0.89
innodb  insert                              114.00       -0.00%       0.00   
112.00  116.00  114.00    1.41
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                    20.00       -4.17%      -0.80    
18.00   20.00   19.20    0.75
innodb  insert_key                          269.00       +4.88%      13.80   
269.00  299.00  282.80   12.24
innodb  insert_many_fields                    5.00      +10.71%       0.60     
5.00    6.00    5.60    0.49
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   5.00      -25.00%      -1.00     
3.00    5.00    4.00    0.63
innodb  insert_select_2_keys                  4.00      +35.48%       2.20     
4.00    8.00    6.20    1.33
innodb  min_max                               7.00      +10.26%       0.80     
6.00    9.00    7.80    1.17
innodb  min_max_on_key                       24.00       +1.64%       0.40    
24.00   25.00   24.40    0.49
innodb  multiple_value_insert                 7.00       -6.06%      -0.40     
6.00    7.00    6.60    0.49
innodb  once_prepared_select                 29.00       +0.68%       0.20    
29.00   30.00   29.20    0.40
innodb  order_by_big                         13.00       +4.41%       0.60    
13.00   15.00   13.60    0.80
innodb  order_by_big_key                     16.00       -3.90%      -0.60    
13.00   17.00   15.40    1.36
innodb  order_by_big_key2                    13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  order_by_big_key_desc                16.00       -3.90%      -0.60    
15.00   16.00   15.40    0.49
innodb  order_by_big_key_diff                12.00       +9.09%       1.20    
12.00   14.00   13.20    0.98
innodb  order_by_big_key_prefix              14.00       -0.00%       0.00    
14.00   14.00   14.00    0.00
innodb  order_by_key2_diff                    1.00      +37.50%       0.60     
1.00    2.00    1.60    0.49
innodb  order_by_key_prefix                   1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           24.00       -9.09%      -2.00    
17.00   25.00   22.00    3.35
innodb  outer_join_found                     23.00      -10.58%      -2.20    
17.00   24.00   20.80    2.79
innodb  outer_join_not_found                 21.00      -15.38%      -2.80    
15.00   22.00   18.20    2.79
innodb  outer_join_on_key                    16.00       -9.59%      -1.40    
11.00   17.00   14.60    2.24
innodb  prepared_select                      37.00       -0.00%       0.00    
37.00   37.00   37.00    0.00
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      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  select_big                           14.00       -9.38%      -1.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                         64.00       -0.00%       0.00    
57.00   71.00   64.00    4.43
innodb  select_cache2                        65.00       -1.88%      -1.20    
60.00   65.00   63.80    1.94
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_diff_key                       1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  select_distinct                       5.00       -0.00%       0.00     
5.00    5.00    5.00    0.00
innodb  select_group                         18.00       +1.10%       0.20    
18.00   19.00   18.20    0.40
innodb  select_group_when_MANY_tables        12.00       -0.00%       0.00    
11.00   13.00   12.00    0.63
innodb  select_join                           0.00     +100.00%       0.60     
0.00    1.00    0.60    0.49
innodb  select_key                           64.00       -0.63%      -0.40    
63.00   64.00   63.60    0.49
innodb  select_key2                          71.00       -0.85%      -0.60    
70.00   71.00   70.40    0.49
innodb  select_key2_return_key               68.00       +0.58%       0.40    
68.00   69.00   68.40    0.49
innodb  select_key2_return_prim              69.00       -0.00%       0.00    
68.00   70.00   69.00    0.63
innodb  select_key_prefix                    71.00       -0.85%      -0.60    
70.00   71.00   70.40    0.49
innodb  select_key_prefix_join                5.00       -0.00%       0.00     
5.00    5.00    5.00    0.00
innodb  select_key_return_key                63.00       +0.32%       0.20    
63.00   64.00   63.20    0.40
innodb  select_many_fields                   13.00       +2.99%       0.40    
13.00   14.00   13.40    0.49
innodb  select_range                         49.00      -15.02%      -6.40    
39.00   49.00   42.60    3.38
innodb  select_range_key2                    10.00       -4.17%      -0.40     
9.00   10.00    9.60    0.49
innodb  select_range_prefix                   8.00      +11.11%       1.00     
8.00   10.00    9.00    0.63
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       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  update_big                           59.00       -1.72%      -1.00    
56.00   60.00   58.00    1.41
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        24.00       -6.19%      -1.40    
21.00   24.00   22.60    1.02
innodb  update_of_key_big                    38.00       -8.57%      -3.00    
31.00   38.00   35.00    2.37
innodb  update_of_primary_key_many_keys    1319.00       +3.00%      40.80  
1299.00 1442.00 1359.80   61.14
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     124.00       -1.31%      -1.60   
118.00  127.00  122.40    3.01
innodb  update_with_key_prefix               45.00       -2.74%      -1.20    
42.00   46.00   43.80    1.47
innodb  wisc_benchmark                        2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       +1.23%       0.40    
31.00   34.00   32.40    0.73
innodb  alter_table_drop                     23.00       +4.56%       1.10    
23.00   25.00   24.10    0.77
innodb  connect                               2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
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       -9.09%      -0.25     
2.00    3.00    2.75    0.43
innodb  count                                14.00       +8.50%       1.30    
13.00   18.00   15.30    1.76
innodb  count_distinct                        7.00       -6.06%      -0.40     
6.00    8.00    6.60    0.73
innodb  count_distinct_2                     13.00       +5.11%       0.70    
12.00   16.00   13.70    1.00
innodb  count_distinct_big                   23.00       -1.55%      -0.35    
20.00   25.00   22.65    1.74
innodb  count_distinct_group                 11.00      +23.08%       3.30    
11.00   16.00   14.30    1.14
innodb  count_distinct_group_on_key          16.00      -60.00%      -6.00     
8.00   16.00   10.00    1.61
innodb  count_distinct_group_on_key_parts    11.00      +16.98%       2.25    
11.00   15.00   13.25    0.99
innodb  count_distinct_key_prefix             6.00      -15.38%      -0.80     
4.00    6.00    5.20    0.60
innodb  count_group_on_key_parts             11.00       -0.00%       0.00    
10.00   12.00   11.00    0.45
innodb  count_on_key                         96.00       -1.80%      -1.70    
91.00   98.00   94.30    1.85
innodb  create+drop                          30.00       +5.51%       1.75    
30.00   34.00   31.75    1.26
innodb  create_index                          3.00       +3.23%       0.10     
2.00    4.00    3.10    0.44
innodb  create_key+drop                      30.00       -3.81%      -1.10    
28.00   30.00   28.90    0.77
innodb  create_MANY_tables                   19.00       +7.77%       1.60    
19.00   22.00   20.60    0.80
innodb  create_table                          0.00     +100.00%       0.15     
0.00    1.00    0.15    0.36
innodb  delete_all_many_keys                632.00       +4.75%      31.50   
569.00  738.00  663.50   44.60
innodb  delete_autocommit                     4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  delete_big                            1.00      -81.82%      -0.45     
0.00    1.00    0.55    0.50
innodb  delete_big_many_keys                630.00       +4.92%      32.60   
569.00  737.00  662.60   44.46
innodb  delete_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  delete_key                            3.00       -7.14%      -0.20     
2.00    4.00    2.80    0.51
innodb  delete_range                          9.00       -3.45%      -0.30     
8.00   10.00    8.70    0.71
innodb  delete_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  drop_index                            3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  drop_table_when_MANY_tables          15.00       +7.41%       1.20    
15.00   17.00   16.20    0.68
innodb  insert                              114.00       +0.22%       0.25   
112.00  116.00  114.25    1.18
innodb  insert_autocommit                     4.00      -23.08%      -0.75     
3.00    4.00    3.25    0.43
innodb  insert_commit                         1.00      +42.86%       0.75     
1.00    2.00    1.75    0.43
innodb  insert_duplicates                    20.00       -4.44%      -0.85    
18.00   20.00   19.15    0.48
innodb  insert_key                          269.00       +5.51%      15.70   
266.00  304.00  284.70   12.00
innodb  insert_many_fields                    5.00      +12.28%       0.70     
5.00    6.00    5.70    0.46
innodb  insert_rollback                       2.00       -5.26%      -0.10     
1.00    2.00    1.90    0.30
innodb  insert_select_1_key                   5.00      -21.95%      -0.90     
3.00    5.00    4.10    0.54
innodb  insert_select_2_keys                  4.00      +36.51%       2.30     
4.00    8.00    6.30    0.84
innodb  min_max                               7.00       +9.09%       0.70     
6.00    9.00    7.70    1.00
innodb  min_max_on_key                       24.00       +2.04%       0.50    
24.00   26.00   24.50    0.59
innodb  multiple_value_insert                 7.00       -7.69%      -0.50     
5.00    8.00    6.50    0.74
innodb  once_prepared_select                 29.00       +0.51%       0.15    
29.00   30.00   29.15    0.36
innodb  order_by_big                         13.00       +8.13%       1.15    
13.00   16.00   14.15    1.06
innodb  order_by_big_key                     16.00       -8.84%      -1.30    
13.00   17.00   14.70    1.05
innodb  order_by_big_key2                    13.00       -0.39%      -0.05    
12.00   14.00   12.95    0.59
innodb  order_by_big_key_desc                16.00       -4.92%      -0.75    
14.00   17.00   15.25    0.77
innodb  order_by_big_key_diff                12.00       +7.69%       1.00    
12.00   14.00   13.00    0.77
innodb  order_by_big_key_prefix              14.00       -4.09%      -0.55    
12.00   15.00   13.45    0.80
innodb  order_by_key2_diff                    1.00      +33.33%       0.50     
1.00    2.00    1.50    0.50
innodb  order_by_key_prefix                   1.00      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  order_by_range                        1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  outer_join                           24.00       -9.34%      -2.05    
17.00   25.00   21.95    2.96
innodb  outer_join_found                     23.00       -8.75%      -1.85    
16.00   25.00   21.15    3.02
innodb  outer_join_not_found                 21.00      -12.90%      -2.40    
14.00   22.00   18.60    2.69
innodb  outer_join_on_key                    16.00       -8.84%      -1.30    
11.00   18.00   14.70    2.17
innodb  prepared_select                      37.00       +0.40%       0.15    
37.00   38.00   37.15    0.36
innodb  select_1_row                          3.00      +14.29%       0.50     
3.00    4.00    3.50    0.50
innodb  select_1_row_cache                    4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
innodb  select_2_rows                         3.00      +15.49%       0.55     
3.00    4.00    3.55    0.50
innodb  select_big                           14.00       -7.69%      -1.00    
12.00   14.00   13.00    0.84
innodb  select_big_str                        1.00      +25.93%       0.35     
1.00    2.00    1.35    0.48
innodb  select_cache                         64.00       -2.32%      -1.45    
57.00   71.00   62.55    3.28
innodb  select_cache2                        65.00       -3.59%      -2.25    
60.00   67.00   62.75    2.00
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_diff_key                       1.00     -185.71%      -0.65     
0.00    1.00    0.35    0.48
innodb  select_distinct                       5.00       -9.89%      -0.45     
4.00    5.00    4.55    0.50
innodb  select_group                         18.00       -4.05%      -0.70    
15.00   19.00   17.30    1.49
innodb  select_group_when_MANY_tables        12.00       +0.83%       0.10    
11.00   14.00   12.10    0.89
innodb  select_join                           0.00     +100.00%       0.75     
0.00    1.00    0.75    0.43
innodb  select_key                           64.00       -0.87%      -0.55    
62.00   65.00   63.45    0.67
innodb  select_key2                          71.00       -0.14%      -0.10    
69.00   73.00   70.90    0.99
innodb  select_key2_return_key               68.00       +0.51%       0.35    
67.00   70.00   68.35    0.85
innodb  select_key2_return_prim              69.00       +0.22%       0.15    
68.00   71.00   69.15    0.91
innodb  select_key_prefix                    71.00       -0.71%      -0.50    
69.00   72.00   70.50    0.81
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.24%      -0.15    
62.00   65.00   62.85    0.79
innodb  select_many_fields                   13.00       +1.14%       0.15    
13.00   14.00   13.15    0.36
innodb  select_range                         49.00      -16.11%      -6.80    
39.00   49.00   42.20    2.38
innodb  select_range_key2                    10.00       -4.71%      -0.45     
9.00   11.00    9.55    0.59
innodb  select_range_prefix                   8.00      +13.04%       1.20     
8.00   10.00    9.20    0.68
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      -42.86%      -0.30     
0.00    1.00    0.70    0.46
innodb  update_autocommit                     3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  update_big                           59.00       +0.76%       0.45    
56.00   64.00   59.45    2.29
innodb  update_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  update_of_key                        24.00       -7.62%      -1.70    
21.00   25.00   22.30    1.23
innodb  update_of_key_big                    38.00       -3.68%      -1.35    
31.00   47.00   36.65    4.10
innodb  update_of_primary_key_many_keys    1319.00       +3.27%      44.60  
1203.00 1482.00 1363.60   78.21
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     124.00       -1.64%      -2.00   
117.00  127.00  122.00    2.74
innodb  update_with_key_prefix               45.00       -1.01%      -0.45    
40.00   50.00   44.55    2.42
innodb  wisc_benchmark                        2.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      -55.82%     -11.46    
11.00   61.00   20.54   10.00
innodb  alter_table_drop                     23.00      -26.72%      -4.85    
10.00   57.00   18.15    7.01
innodb  connect                               2.00       +3.79%       0.08     
1.00    3.00    2.08    0.42
innodb  connect+select_1_row                  3.00      -11.44%      -0.31     
2.00    5.00    2.69    0.48
innodb  connect+select_simple                 3.00      -28.64%      -0.67     
1.00    3.00    2.33    0.48
innodb  count                                14.00      +11.13%       1.75    
12.00  193.00   15.75    9.00
innodb  count_distinct                        7.00       -6.68%      -0.44     
5.00   50.00    6.56    2.32
innodb  count_distinct_2                     13.00       +1.15%       0.15    
11.00   63.00   13.15    3.00
innodb  count_distinct_big                   23.00       -5.00%      -1.09     
5.00   67.00   21.91    3.06
innodb  count_distinct_group                 11.00      +15.98%       2.09    
10.00   68.00   13.09    3.14
innodb  count_distinct_group_on_key          16.00      -69.05%      -6.54     
7.00   69.00    9.46    3.06
innodb  count_distinct_group_on_key_parts    11.00      +10.39%       1.28     
9.00   72.00   12.28    3.20
innodb  count_distinct_key_prefix             6.00      -17.24%      -0.88     
3.00   52.00    5.12    2.43
innodb  count_group_on_key_parts             11.00      -10.71%      -1.06     
7.00   72.00    9.94    3.21
innodb  count_on_key                         96.00      -12.10%     -10.37    
68.00  107.00   85.63    7.31
innodb  create+drop                          30.00       +7.45%       2.41    
18.00   75.00   32.41   12.14
innodb  create_index                          3.00       -4.47%      -0.13     
1.00    8.00    2.87    1.16
innodb  create_key+drop                      30.00       -6.90%      -1.94    
21.00   50.00   28.06    4.97
innodb  create_MANY_tables                   19.00      +45.15%      15.64    
14.00  121.00   34.64   17.23
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.37
innodb  delete_all_many_keys                632.00      -38.71%    -176.37   
212.00 1888.00  455.63  370.68
innodb  delete_autocommit                     4.00      -16.51%      -0.57     
2.00   14.00    3.43    0.75
innodb  delete_big                            1.00     -255.17%      -0.72     
0.00    3.00    0.28    0.46
innodb  delete_big_many_keys                630.00      -36.34%    -167.91   
212.00 2293.00  462.09  385.43
innodb  delete_commit                         2.00      -33.44%      -0.50     
1.00    5.00    1.50    0.53
innodb  delete_key                            3.00       +2.30%       0.07     
2.00   35.00    3.07    1.52
innodb  delete_range                          9.00       -8.64%      -0.72     
5.00   23.00    8.28    3.30
innodb  delete_rollback                       2.00      -16.14%      -0.28     
1.00   12.00    1.72    0.93
innodb  drop_index                            3.00       -1.81%      -0.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          15.00      +23.60%       4.63    
11.00   90.00   19.63    7.68
innodb  insert                              114.00       -7.16%      -7.61     
3.00  343.00  106.39   14.83
innodb  insert_autocommit                     4.00      -33.82%      -1.01     
2.00   99.00    2.99    3.39
innodb  insert_commit                         1.00      +26.30%       0.36     
1.00    3.00    1.36    0.49
innodb  insert_duplicates                    20.00      -30.73%      -4.70    
11.00   21.00   15.30    2.59
innodb  insert_key                          269.00      +11.59%      35.26   
142.00  700.00  304.26  109.50
innodb  insert_many_fields                    5.00      +10.64%       0.60     
3.00   17.00    5.60    1.81
innodb  insert_rollback                       2.00      -21.27%      -0.35     
1.00    3.00    1.65    0.53
innodb  insert_select_1_key                   5.00      -32.27%      -1.22     
2.00   10.00    3.78    0.90
innodb  insert_select_2_keys                  4.00      +34.08%       2.07     
4.00   16.00    6.07    2.13
innodb  min_max                               7.00      +10.50%       0.82     
6.00  110.00    7.82    4.64
innodb  min_max_on_key                       24.00      -17.89%      -3.64    
14.00   37.00   20.36    3.02
innodb  multiple_value_insert                 7.00      -29.43%      -1.59     
2.00   50.00    5.41    4.37
innodb  once_prepared_select                 29.00      -20.94%      -5.02    
18.00   32.00   23.98    3.48
innodb  order_by_big                         13.00       +9.08%       1.30    
12.00   31.00   14.30    1.54
innodb  order_by_big_key                     16.00      -21.00%      -2.78    
11.00   32.00   13.22    1.63
innodb  order_by_big_key2                    13.00       -6.97%      -0.85    
10.00   33.00   12.15    1.55
innodb  order_by_big_key_desc                16.00      -19.16%      -2.57    
11.00   32.00   13.43    1.67
innodb  order_by_big_key_diff                12.00       +1.56%       0.19    
10.00   31.00   12.19    1.51
innodb  order_by_big_key_prefix              14.00      -13.26%      -1.64    
10.00   32.00   12.36    1.58
innodb  order_by_key2_diff                    1.00      +28.43%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -27.01%      -0.21     
0.00    2.00    0.79    0.42
innodb  order_by_range                        1.00      -21.03%      -0.17     
0.00    2.00    0.83    0.39
innodb  outer_join                           24.00      -24.85%      -4.78    
15.00   61.00   19.22    3.72
innodb  outer_join_found                     23.00      -23.28%      -4.34    
14.00   58.00   18.66    3.58
innodb  outer_join_not_found                 21.00      -28.52%      -4.66    
12.00   46.00   16.34    3.16
innodb  outer_join_on_key                    16.00      -24.74%      -3.17    
10.00   59.00   12.83    2.78
innodb  prepared_select                      37.00      -19.19%      -5.96    
22.00   40.00   31.04    4.42
innodb  select_1_row                          3.00       -6.27%      -0.18     
2.00    4.00    2.82    0.69
innodb  select_1_row_cache                    4.00      -51.52%      -1.36     
2.00    4.00    2.64    0.67
innodb  select_2_rows                         3.00       -5.54%      -0.16     
2.00    4.00    2.84    0.69
innodb  select_big                           14.00      -15.46%      -1.88     
0.00   31.00   12.13    1.56
innodb  select_big_str                        1.00      +13.20%       0.15     
0.00    2.00    1.15    0.36
innodb  select_cache                         64.00       -7.66%      -4.55    
49.00   77.00   59.45    5.63
innodb  select_cache2                        65.00       -8.57%      -5.13    
49.00   75.00   59.87    6.37
innodb  select_column+column                  4.00      -38.54%      -1.11     
2.00    4.00    2.89    0.70
innodb  select_diff_key                       1.00     -362.36%      -0.78     
0.00    1.00    0.22    0.41
innodb  select_distinct                       5.00      -18.33%      -0.77     
3.00    8.00    4.23    0.54
innodb  select_group                         18.00      -10.84%      -1.76     
4.00  136.00   16.24    5.54
innodb  select_group_when_MANY_tables        12.00      -28.44%      -2.66     
3.00   49.00    9.34    9.65
innodb  select_join                           0.00     +100.00%       0.58     
0.00    1.00    0.58    0.49
innodb  select_key                           64.00      -22.53%     -11.77    
40.00   66.00   52.23    7.20
innodb  select_key2                          71.00      -20.54%     -12.10    
45.00   75.00   58.90    8.09
innodb  select_key2_return_key               68.00      -20.94%     -11.77    
42.00   70.00   56.23    7.86
innodb  select_key2_return_prim              69.00      -21.09%     -12.02    
42.00   72.00   56.98    8.02
innodb  select_key_prefix                    71.00      -22.12%     -12.86    
44.00   75.00   58.14    8.08
innodb  select_key_prefix_join                5.00       -6.34%      -0.30     
3.00   10.00    4.70    0.66
innodb  select_key_return_key                63.00      -22.91%     -11.74    
38.00   65.00   51.26    7.22
innodb  select_many_fields                   13.00      +13.47%       2.02    
11.00   19.00   15.02    1.79
innodb  select_range                         49.00       -3.61%      -1.71    
39.00   76.00   47.29    3.90
innodb  select_range_key2                    10.00      -21.94%      -1.80     
6.00   11.00    8.20    1.03
innodb  select_range_prefix                   8.00       -2.94%      -0.23     
5.00   10.00    7.77    1.08
innodb  select_simple                         2.00      -22.86%      -0.37     
1.00    3.00    1.63    0.51
innodb  select_simple_cache                   2.00      -30.43%      -0.47     
1.00    3.00    1.53    0.52
innodb  select_simple_join                    1.00      -54.21%      -0.35     
0.00    3.00    0.65    0.48
innodb  update_autocommit                     3.00       +9.45%       0.31     
2.00   16.00    3.31    1.03
innodb  update_big                           59.00      -16.57%      -8.39    
31.00  195.00   50.61   24.96
innodb  update_commit                         2.00      -29.56%      -0.46     
1.00   10.00    1.54    0.74
innodb  update_of_key                        24.00       +1.30%       0.32    
18.00  100.00   24.32    6.30
innodb  update_of_key_big                    38.00      -40.37%     -10.93    
15.00   75.00   27.07   11.04
innodb  update_of_primary_key_many_keys    1319.00       -6.87%     -84.78   
647.00 6065.00 1234.22  987.07
innodb  update_rollback                       2.00      -14.68%      -0.26     
1.00   31.00    1.74    1.94
innodb  update_with_key                     124.00      -13.44%     -14.69    
90.00  598.00  109.31   21.09
innodb  update_with_key_prefix               45.00      -14.21%      -5.60    
33.00  202.00   39.40    6.87
innodb  wisc_benchmark                        2.00      +19.06%       0.47     
2.00    5.00    2.47    0.53

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

  2160.1.1: Olaf van der Spek 2011-02-12 casts

_______________________________________________
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