=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   943
RUN DATE: 2011-03-05T14:15:24.722288
SERVER:   drizzled
VERSION:  staging
REVISION: 2221
COMMENT:  2221: Lee Bieber 2011-03-05 [merge] Merge Andrew - 729425: 
mysql-unix-socket-protocol plugin needs documenting        

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      34.00       -3.66%      -1.20    
31.00   34.00   32.80    0.98
innodb  alter_table_drop                     25.00       -2.46%      -0.60    
24.00   25.00   24.40    0.49
innodb  connect                               2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  connect+select_1_row                  2.00      +28.57%       0.80     
2.00    3.00    2.80    0.40
innodb  connect+select_simple                 3.00      -25.00%      -0.60     
2.00    3.00    2.40    0.49
innodb  count                                18.00      -13.92%      -2.20    
13.00   18.00   15.80    2.04
innodb  count_distinct                        6.00      +16.67%       1.20     
6.00    8.00    7.20    0.98
innodb  count_distinct_2                     13.00       +1.52%       0.20    
12.00   15.00   13.20    1.17
innodb  count_distinct_big                   24.00       -5.26%      -1.20    
21.00   25.00   22.80    1.60
innodb  count_distinct_group                 14.00       +2.78%       0.40    
14.00   15.00   14.40    0.49
innodb  count_distinct_group_on_key           8.00      +13.04%       1.20     
8.00   10.00    9.20    0.75
innodb  count_distinct_group_on_key_parts    11.00      +11.29%       1.40    
11.00   14.00   12.40    1.02
innodb  count_distinct_key_prefix             5.00       +7.41%       0.40     
5.00    6.00    5.40    0.49
innodb  count_group_on_key_parts             10.00       +3.85%       0.40    
10.00   11.00   10.40    0.49
innodb  count_on_key                         92.00       -0.66%      -0.60    
90.00   92.00   91.40    0.80
innodb  create+drop                          33.00       +1.20%       0.40    
33.00   34.00   33.40    0.49
innodb  create_index                          3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  create_key+drop                      31.00       -0.00%       0.00    
30.00   32.00   31.00    0.63
innodb  create_MANY_tables                   21.00       -1.94%      -0.40    
20.00   21.00   20.60    0.49
innodb  delete_all_many_keys                618.00       +2.31%      14.60   
618.00  648.00  632.60   10.58
innodb  delete_autocommit                     3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  delete_big                            1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  delete_big_many_keys                617.00       +2.34%      14.80   
617.00  648.00  631.80   10.87
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
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                            2.00      +23.08%       0.60     
2.00    3.00    2.60    0.49
innodb  drop_table_when_MANY_tables          18.00       +1.10%       0.20    
18.00   19.00   18.20    0.40
innodb  insert                              114.00       +0.35%       0.40   
113.00  115.00  114.40    0.80
innodb  insert_autocommit                     3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  insert_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_duplicates                    19.00       -0.00%       0.00    
19.00   19.00   19.00    0.00
innodb  insert_key                          268.00       +2.76%       7.60   
268.00  283.00  275.60    4.84
innodb  insert_many_fields                    6.00       -3.45%      -0.20     
5.00    6.00    5.80    0.40
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                  5.00      +19.35%       1.20     
5.00    8.00    6.20    0.98
innodb  min_max                               9.00      -15.38%      -1.20     
7.00    9.00    7.80    0.98
innodb  min_max_on_key                       24.00       +0.83%       0.20    
24.00   25.00   24.20    0.40
innodb  multiple_value_insert                 6.00       +3.23%       0.20     
6.00    7.00    6.20    0.40
innodb  once_prepared_select                 29.00       +1.36%       0.40    
29.00   30.00   29.40    0.49
innodb  order_by_big                         13.00      +10.96%       1.60    
13.00   15.00   14.60    0.80
innodb  order_by_big_key                     16.00       -8.11%      -1.20    
14.00   16.00   14.80    0.75
innodb  order_by_big_key2                    13.00       -3.17%      -0.40    
12.00   13.00   12.60    0.49
innodb  order_by_big_key_desc                15.00       -0.00%       0.00    
14.00   16.00   15.00    0.89
innodb  order_by_big_key_diff                13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  order_by_big_key_prefix              14.00       -7.69%      -1.00    
12.00   14.00   13.00    0.63
innodb  order_by_key2_diff                    1.00      +28.57%       0.40     
1.00    2.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           22.00       +4.35%       1.00    
22.00   24.00   23.00    0.89
innodb  outer_join_found                     21.00       +4.55%       1.00    
21.00   23.00   22.00    0.89
innodb  outer_join_not_found                 20.00       +0.99%       0.20    
20.00   21.00   20.20    0.40
innodb  outer_join_on_key                    14.00       +7.89%       1.20    
14.00   16.00   15.20    0.75
innodb  prepared_select                      37.00       -0.54%      -0.20    
36.00   37.00   36.80    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                           15.00      -15.38%      -2.00    
11.00   15.00   13.00    1.26
innodb  select_big_str                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  select_cache                         63.00       +2.17%       1.40    
63.00   66.00   64.40    1.02
innodb  select_cache2                        66.00       -1.23%      -0.80    
62.00   68.00   65.20    2.32
innodb  select_column+column                  4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_distinct                       5.00       -8.70%      -0.40     
4.00    5.00    4.60    0.49
innodb  select_group                         18.00       -2.27%      -0.40    
16.00   19.00   17.60    1.36
innodb  select_group_when_MANY_tables        12.00       -5.26%      -0.60    
11.00   12.00   11.40    0.49
innodb  select_join                           0.00     +100.00%       0.20     
0.00    1.00    0.20    0.40
innodb  select_key                           64.00       -0.31%      -0.20    
63.00   64.00   63.80    0.40
innodb  select_key2                          71.00       -0.57%      -0.40    
69.00   72.00   70.60    1.02
innodb  select_key2_return_key               69.00       -1.17%      -0.80    
67.00   69.00   68.20    0.75
innodb  select_key2_return_prim              70.00       -1.74%      -1.20    
67.00   70.00   68.80    1.17
innodb  select_key_prefix                    71.00       -0.85%      -0.60    
69.00   72.00   70.40    1.20
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.32%      -0.20    
62.00   64.00   62.80    0.75
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         44.00       +0.90%       0.40    
41.00   46.00   44.40    1.85
innodb  select_range_key2                    10.00       -6.38%      -0.60     
9.00   10.00    9.40    0.49
innodb  select_range_prefix                   9.00       +4.26%       0.40     
9.00   10.00    9.40    0.49
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  update_autocommit                     4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  update_big                           58.00       -0.35%      -0.20    
55.00   59.00   57.80    1.47
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        25.00       -9.65%      -2.20    
21.00   25.00   22.80    1.60
innodb  update_of_key_big                    45.00      -17.19%      -6.60    
32.00   45.00   38.40    5.24
innodb  update_of_primary_key_many_keys    1284.00       +1.67%      21.80  
1284.00 1330.00 1305.80   16.03
innodb  update_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  update_with_key                     119.00       +2.14%       2.60   
119.00  126.00  121.60    2.58
innodb  update_with_key_prefix               43.00       -0.00%       0.00    
42.00   44.00   43.00    0.89
innodb  wisc_benchmark                        2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      34.00       -4.45%      -1.45    
30.00   34.00   32.55    1.24
innodb  alter_table_drop                     25.00       -4.38%      -1.05    
23.00   26.00   23.95    0.86
innodb  connect                               2.00      +11.11%       0.25     
2.00    3.00    2.25    0.43
innodb  connect+select_1_row                  2.00      +29.82%       0.85     
2.00    3.00    2.85    0.36
innodb  connect+select_simple                 3.00      -17.65%      -0.45     
2.00    3.00    2.55    0.50
innodb  count                                18.00      -12.15%      -1.95    
13.00   19.00   16.05    2.11
innodb  count_distinct                        6.00      +14.29%       1.00     
6.00    8.00    7.00    0.84
innodb  count_distinct_2                     13.00       +6.47%       0.90    
11.00   16.00   13.90    1.37
innodb  count_distinct_big                   24.00       -5.03%      -1.15    
20.00   25.00   22.85    1.71
innodb  count_distinct_group                 14.00       +4.76%       0.70    
13.00   16.00   14.70    0.84
innodb  count_distinct_group_on_key           8.00      +19.60%       1.95     
8.00   12.00    9.95    1.12
innodb  count_distinct_group_on_key_parts    11.00      +17.60%       2.35    
11.00   15.00   13.35    1.11
innodb  count_distinct_key_prefix             5.00       +5.66%       0.30     
5.00    6.00    5.30    0.46
innodb  count_group_on_key_parts             10.00       +6.98%       0.75    
10.00   11.00   10.75    0.43
innodb  count_on_key                         92.00       +0.65%       0.60    
89.00   97.00   92.60    2.06
innodb  create+drop                          33.00       +1.35%       0.45    
32.00   35.00   33.45    0.80
innodb  create_index                          3.00       +7.69%       0.25     
3.00    4.00    3.25    0.43
innodb  create_key+drop                      31.00       +1.27%       0.40    
30.00   33.00   31.40    0.73
innodb  create_MANY_tables                   21.00       -1.20%      -0.25    
20.00   22.00   20.75    0.62
innodb  create_table                          0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  delete_all_many_keys                618.00       +4.73%      30.65   
580.00  721.00  648.65   33.85
innodb  delete_autocommit                     3.00      +20.00%       0.75     
3.00    5.00    3.75    0.54
innodb  delete_big                            1.00      -53.85%      -0.35     
0.00    1.00    0.65    0.48
innodb  delete_big_many_keys                617.00       +4.75%      30.75   
580.00  719.00  647.75   33.60
innodb  delete_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  delete_key                            3.00      -13.21%      -0.35     
2.00    3.00    2.65    0.48
innodb  delete_range                          9.00       -2.86%      -0.25     
8.00   10.00    8.75    0.54
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            2.00      +32.20%       0.95     
2.00    4.00    2.95    0.50
innodb  drop_table                            0.00     +100.00%       0.15     
0.00    1.00    0.15    0.36
innodb  drop_table_when_MANY_tables          18.00       +3.74%       0.70    
17.00   22.00   18.70    1.05
innodb  insert                              114.00       -0.35%      -0.40   
112.00  116.00  113.60    1.16
innodb  insert_autocommit                     3.00       +1.64%       0.05     
3.00    4.00    3.05    0.22
innodb  insert_commit                         2.00       -5.26%      -0.10     
1.00    2.00    1.90    0.30
innodb  insert_duplicates                    19.00       +0.78%       0.15    
19.00   20.00   19.15    0.36
innodb  insert_key                          268.00       +4.22%      11.80   
263.00  300.00  279.80   10.03
innodb  insert_many_fields                    6.00       -2.56%      -0.15     
5.00    6.00    5.85    0.36
innodb  insert_rollback                       2.00       +6.98%       0.15     
2.00    3.00    2.15    0.36
innodb  insert_select_1_key                   5.00      -29.87%      -1.15     
3.00    5.00    3.85    0.57
innodb  insert_select_2_keys                  5.00      +20.00%       1.25     
5.00    8.00    6.25    0.70
innodb  min_max                               9.00      -13.92%      -1.10     
7.00    9.00    7.90    0.94
innodb  min_max_on_key                       24.00       +2.24%       0.55    
24.00   26.00   24.55    0.59
innodb  multiple_value_insert                 6.00       +6.25%       0.40     
5.00    8.00    6.40    0.66
innodb  once_prepared_select                 29.00       +0.68%       0.20    
28.00   30.00   29.20    0.51
innodb  order_by_big                         13.00      +11.86%       1.75    
13.00   16.00   14.75    0.99
innodb  order_by_big_key                     16.00      -11.89%      -1.70    
12.00   16.00   14.30    1.35
innodb  order_by_big_key2                    13.00       -0.39%      -0.05    
11.00   15.00   12.95    0.92
innodb  order_by_big_key_desc                15.00       -0.33%      -0.05    
13.00   17.00   14.95    1.24
innodb  order_by_big_key_diff                13.00       -0.00%       0.00    
11.00   14.00   13.00    0.84
innodb  order_by_big_key_prefix              14.00       -4.87%      -0.65    
12.00   15.00   13.35    0.73
innodb  order_by_key2_diff                    1.00      +31.03%       0.45     
1.00    2.00    1.45    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       -5.26%      -0.05     
0.00    1.00    0.95    0.22
innodb  outer_join                           22.00       -1.85%      -0.40    
17.00   24.00   21.60    2.48
innodb  outer_join_found                     21.00       -1.20%      -0.25    
16.00   23.00   20.75    2.38
innodb  outer_join_not_found                 20.00       -5.82%      -1.10    
15.00   23.00   18.90    2.43
innodb  outer_join_on_key                    14.00       +3.78%       0.55    
11.00   17.00   14.55    1.60
innodb  prepared_select                      37.00       +0.27%       0.10    
36.00   38.00   37.10    0.54
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      +14.29%       0.50     
3.00    4.00    3.50    0.50
innodb  select_2_rows                         4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  select_big                           15.00      -15.38%      -2.00    
11.00   15.00   13.00    1.18
innodb  select_big_str                        1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  select_cache                         63.00       +0.63%       0.40    
57.00   68.00   63.40    2.54
innodb  select_cache2                        66.00       -4.35%      -2.75    
57.00   68.00   63.25    3.06
innodb  select_column+column                  4.00       -3.90%      -0.15     
3.00    4.00    3.85    0.36
innodb  select_diff_key                       0.00     +100.00%       0.25     
0.00    1.00    0.25    0.43
innodb  select_distinct                       5.00      -12.36%      -0.55     
4.00    5.00    4.45    0.50
innodb  select_group                         18.00      -10.77%      -1.75    
15.00   19.00   16.25    1.44
innodb  select_group_when_MANY_tables        12.00       -0.84%      -0.10    
11.00   13.00   11.90    0.70
innodb  select_join                           0.00     +100.00%       0.55     
0.00    1.00    0.55    0.50
innodb  select_key                           64.00       -0.31%      -0.20    
63.00   66.00   63.80    0.68
innodb  select_key2                          71.00       -0.42%      -0.30    
69.00   73.00   70.70    1.00
innodb  select_key2_return_key               69.00       -1.02%      -0.70    
67.00   70.00   68.30    0.71
innodb  select_key2_return_prim              70.00       -1.45%      -1.00    
67.00   71.00   69.00    0.95
innodb  select_key_prefix                    71.00       -0.92%      -0.65    
69.00   72.00   70.35    0.96
innodb  select_key_prefix_join                5.00       +0.99%       0.05     
5.00    6.00    5.05    0.22
innodb  select_key_return_key                63.00       -0.40%      -0.25    
62.00   64.00   62.75    0.70
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         44.00       -4.14%      -1.75    
39.00   46.00   42.25    2.45
innodb  select_range_key2                    10.00       -5.82%      -0.55     
8.00   10.00    9.45    0.59
innodb  select_range_prefix                   9.00       +1.64%       0.15     
8.00   10.00    9.15    0.65
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_join                    1.00      -11.11%      -0.10     
0.00    1.00    0.90    0.30
innodb  update_autocommit                     4.00       -6.67%      -0.25     
3.00    5.00    3.75    0.54
innodb  update_big                           58.00       +1.02%       0.60    
55.00   64.00   58.60    1.85
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        25.00      -11.11%      -2.50    
21.00   25.00   22.50    1.12
innodb  update_of_key_big                    45.00      -23.29%      -8.50    
31.00   45.00   36.50    3.50
innodb  update_of_primary_key_many_keys    1284.00       +3.47%      46.20  
1217.00 1465.00 1330.20   61.36
innodb  update_rollback                       2.00       +4.76%       0.10     
2.00    3.00    2.10    0.30
innodb  update_with_key                     119.00       +1.37%       1.65   
115.00  126.00  120.65    2.33
innodb  update_with_key_prefix               43.00       +2.71%       1.20    
41.00   48.00   44.20    1.89
innodb  wisc_benchmark                        2.00      +18.37%       0.45     
2.00    3.00    2.45    0.50

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      34.00      -60.12%     -12.77    
11.00   61.00   21.23   10.12
innodb  alter_table_drop                     25.00      -35.26%      -6.52    
10.00   57.00   18.48    6.94
innodb  connect                               2.00       +4.00%       0.08     
1.00    3.00    2.08    0.42
innodb  connect+select_1_row                  2.00      +26.00%       0.70     
2.00    5.00    2.70    0.47
innodb  connect+select_simple                 3.00      -27.68%      -0.65     
1.00    3.00    2.35    0.48
innodb  count                                18.00      -14.30%      -2.25    
12.00  193.00   15.75    8.76
innodb  count_distinct                        6.00       +8.70%       0.57     
5.00   50.00    6.57    2.26
innodb  count_distinct_2                     13.00       +1.51%       0.20    
11.00   63.00   13.20    2.93
innodb  count_distinct_big                   24.00       -9.36%      -2.05     
5.00   67.00   21.95    3.01
innodb  count_distinct_group                 14.00       -6.29%      -0.83    
10.00   68.00   13.17    3.07
innodb  count_distinct_group_on_key           8.00      +15.82%       1.50     
7.00   69.00    9.50    3.00
innodb  count_distinct_group_on_key_parts    11.00      +10.85%       1.34     
9.00   72.00   12.34    3.13
innodb  count_distinct_key_prefix             5.00       +2.48%       0.13     
3.00   52.00    5.13    2.37
innodb  count_group_on_key_parts             10.00       -0.06%      -0.01     
7.00   72.00    9.99    3.13
innodb  count_on_key                         92.00       -6.86%      -5.91    
68.00  107.00   86.09    7.37
innodb  create+drop                          33.00       -1.69%      -0.55    
18.00   75.00   32.45   11.79
innodb  create_index                          3.00       -3.63%      -0.11     
1.00    8.00    2.89    1.13
innodb  create_key+drop                      31.00       -9.76%      -2.76    
21.00   50.00   28.24    4.89
innodb  create_MANY_tables                   21.00      +37.96%      12.85    
14.00  121.00   33.85   17.04
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.36
innodb  delete_all_many_keys                618.00      -32.26%    -150.74   
212.00 1888.00  467.26  362.42
innodb  delete_autocommit                     3.00      +13.01%       0.45     
2.00   14.00    3.45    0.75
innodb  delete_big                            1.00     -233.59%      -0.70     
0.00    3.00    0.30    0.47
innodb  delete_big_many_keys                617.00      -30.38%    -143.77   
212.00 2293.00  473.23  376.43
innodb  delete_commit                         2.00      -31.83%      -0.48     
1.00    5.00    1.52    0.53
innodb  delete_key                            3.00       +1.65%       0.05     
2.00   35.00    3.05    1.49
innodb  delete_range                          9.00       -8.21%      -0.68     
5.00   23.00    8.32    3.21
innodb  delete_rollback                       2.00      -14.77%      -0.26     
1.00   12.00    1.74    0.91
innodb  drop_index                            2.00      +32.17%       0.95     
1.00    9.00    2.95    1.31
innodb  drop_table                            0.00     +100.00%       0.05     
0.00    2.00    0.05    0.23
innodb  drop_table_when_MANY_tables          18.00       +7.98%       1.56    
11.00   90.00   19.56    7.47
innodb  insert                              114.00       -6.73%      -7.19     
3.00  343.00  106.81   14.51
innodb  insert_autocommit                     3.00       -0.00%       0.00     
2.00   99.00    3.00    3.29
innodb  insert_commit                         2.00      -44.34%      -0.61     
1.00    3.00    1.39    0.50
innodb  insert_duplicates                    19.00      -22.45%      -3.48    
11.00   21.00   15.52    2.67
innodb  insert_key                          268.00      +11.49%      34.77   
142.00  700.00  302.77  106.19
innodb  insert_many_fields                    6.00       -6.97%      -0.39     
3.00   17.00    5.61    1.76
innodb  insert_rollback                       2.00      -19.48%      -0.33     
1.00    3.00    1.67    0.53
innodb  insert_select_1_key                   5.00      -32.19%      -1.22     
2.00   10.00    3.78    0.88
innodb  insert_select_2_keys                  5.00      +17.69%       1.07     
4.00   16.00    6.07    2.08
innodb  min_max                               9.00      -15.00%      -1.17     
6.00  110.00    7.83    4.51
innodb  min_max_on_key                       24.00      -16.50%      -3.40    
14.00   37.00   20.60    3.10
innodb  multiple_value_insert                 6.00       -9.70%      -0.53     
2.00   50.00    5.47    4.25
innodb  once_prepared_select                 29.00      -19.44%      -4.72    
18.00   32.00   24.28    3.59
innodb  order_by_big                         13.00       +9.21%       1.32    
12.00   31.00   14.32    1.53
innodb  order_by_big_key                     16.00      -20.36%      -2.71    
11.00   32.00   13.29    1.64
innodb  order_by_big_key2                    13.00       -6.44%      -0.79    
10.00   33.00   12.21    1.54
innodb  order_by_big_key_desc                15.00      -10.95%      -1.48    
11.00   32.00   13.52    1.68
innodb  order_by_big_key_diff                13.00       -6.19%      -0.76    
10.00   31.00   12.24    1.50
innodb  order_by_big_key_prefix              14.00      -12.78%      -1.59    
10.00   32.00   12.41    1.56
innodb  order_by_key2_diff                    1.00      +28.44%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -26.16%      -0.21     
0.00    2.00    0.79    0.41
innodb  order_by_range                        1.00      -20.08%      -0.17     
0.00    2.00    0.83    0.38
innodb  outer_join                           22.00      -13.59%      -2.63    
15.00   61.00   19.37    3.72
innodb  outer_join_found                     21.00      -11.77%      -2.21    
14.00   58.00   18.79    3.57
innodb  outer_join_not_found                 20.00      -21.27%      -3.51    
12.00   46.00   16.49    3.18
innodb  outer_join_on_key                    14.00       -8.30%      -1.07    
10.00   59.00   12.93    2.77
innodb  prepared_select                      37.00      -17.84%      -5.60    
22.00   40.00   31.40    4.53
innodb  select_1_row                          4.00      -39.83%      -1.14     
2.00    4.00    2.86    0.69
innodb  select_1_row_cache                    3.00      -11.46%      -0.31     
2.00    4.00    2.69    0.69
innodb  select_2_rows                         4.00      -38.56%      -1.11     
2.00    4.00    2.89    0.70
innodb  select_big                           15.00      -23.23%      -2.83     
0.00   31.00   12.17    1.55
innodb  select_big_str                        1.00      +14.20%       0.17     
0.00    2.00    1.17    0.37
innodb  select_cache                         63.00       -5.55%      -3.31    
49.00   77.00   59.69    5.62
innodb  select_cache2                        66.00       -9.95%      -5.97    
49.00   75.00   60.03    6.26
innodb  select_column+column                  4.00      -36.29%      -1.07     
2.00    4.00    2.93    0.72
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.41
innodb  select_distinct                       5.00      -17.96%      -0.76     
3.00    8.00    4.24    0.54
innodb  select_group                         18.00      -10.64%      -1.73     
4.00  136.00   16.27    5.40
innodb  select_group_when_MANY_tables        12.00      -26.34%      -2.50     
3.00   49.00    9.50    9.39
innodb  select_join                           0.00     +100.00%       0.58     
0.00    1.00    0.58    0.49
innodb  select_key                           64.00      -20.98%     -11.10    
40.00   66.00   52.90    7.50
innodb  select_key2                          71.00      -19.15%     -11.41    
45.00   75.00   59.59    8.34
innodb  select_key2_return_key               69.00      -21.22%     -12.08    
42.00   71.00   56.92    8.14
innodb  select_key2_return_prim              70.00      -21.36%     -12.32    
42.00   72.00   57.68    8.29
innodb  select_key_prefix                    71.00      -20.65%     -12.15    
44.00   75.00   58.85    8.37
innodb  select_key_prefix_join                5.00       -5.83%      -0.28     
3.00   10.00    4.72    0.65
innodb  select_key_return_key                63.00      -21.33%     -11.08    
38.00   65.00   51.92    7.51
innodb  select_many_fields                   13.00      +12.86%       1.92    
11.00   19.00   14.92    1.79
innodb  select_range                         44.00       +6.35%       2.98    
38.00   76.00   46.98    4.03
innodb  select_range_key2                    10.00      -20.86%      -1.73     
6.00   11.00    8.27    1.05
innodb  select_range_prefix                   9.00      -14.57%      -1.14     
5.00   10.00    7.86    1.12
innodb  select_simple                         2.00      -21.11%      -0.35     
1.00    3.00    1.65    0.51
innodb  select_simple_cache                   2.00      -28.11%      -0.44     
1.00    3.00    1.56    0.51
innodb  select_simple_join                    1.00      -51.38%      -0.34     
0.00    3.00    0.66    0.48
innodb  update_autocommit                     4.00      -19.89%      -0.66     
2.00   16.00    3.34    1.01
innodb  update_big                           58.00      -13.53%      -6.91    
31.00  195.00   51.09   24.31
innodb  update_commit                         2.00      -27.50%      -0.43     
1.00   10.00    1.57    0.72
innodb  update_of_key                        25.00       -3.27%      -0.79    
18.00  100.00   24.21    6.13
innodb  update_of_key_big                    45.00      -63.22%     -17.43    
15.00   75.00   27.57   10.94
innodb  update_of_primary_key_many_keys    1284.00       -3.38%     -41.96   
647.00 6065.00 1242.04  950.66
innodb  update_rollback                       2.00      -13.36%      -0.24     
1.00   31.00    1.76    1.89
innodb  update_with_key                     119.00       -8.18%      -9.00    
90.00  598.00  110.00   20.68
innodb  update_with_key_prefix               43.00       -8.33%      -3.30    
33.00  202.00   39.70    6.80
innodb  wisc_benchmark                        2.00      +19.04%       0.47     
2.00    5.00    2.47    0.53

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

  2220.1.2: Lee Bieber 2011-03-05 [merge] Merge Andrew - 729425: 
mysql-unix-socket-protocol plugin needs documenting    
    2220.2.1: Andrew Hutchings 2011-03-05 Add documentation for the MySQL Unix 
Socket Protocol plugin
  2220.1.1: Lee Bieber 2011-03-05 [merge] Merge Andrew - 729340: Need 
drizzledump to output InnoDB replication log information for slave provisioning
    2219.3.1: Andrew Hutchings 2011-03-04 If drizzledump is run with 
--single-transaction it will now try and probe the sys_replication_log table.  
If successful it will output something like:

_______________________________________________
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