=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   958
RUN DATE: 2011-03-14T02:38:28.145527
SERVER:   drizzled
VERSION:  staging
REVISION: 2235
COMMENT:  2235: Brian Aker 2011-03-13 [merge] Merge in pcrews.

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      31.00       +6.63%       2.20    
31.00   34.00   33.20    1.17
innodb  alter_table_drop                     24.00       -3.45%      -0.80    
22.00   24.00   23.20    0.75
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       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  count                                14.00       +5.41%       0.80    
14.00   17.00   14.80    1.17
innodb  count_distinct                        7.00       -6.06%      -0.40     
6.00    8.00    6.60    0.80
innodb  count_distinct_2                     15.00      -10.29%      -1.40    
12.00   15.00   13.60    1.02
innodb  count_distinct_big                   21.00       +7.08%       1.60    
21.00   25.00   22.60    1.96
innodb  count_distinct_group                 15.00       -7.14%      -1.00    
11.00   15.00   14.00    1.55
innodb  count_distinct_group_on_key          10.00       -4.17%      -0.40     
8.00   11.00    9.60    1.02
innodb  count_distinct_group_on_key_parts    14.00       -7.69%      -1.00    
11.00   14.00   13.00    1.10
innodb  count_distinct_key_prefix             6.00      -11.11%      -0.60     
4.00    6.00    5.40    0.80
innodb  count_group_on_key_parts             11.00       -1.85%      -0.20    
10.00   12.00   10.80    0.75
innodb  count_on_key                         94.00       -0.00%       0.00    
92.00   95.00   94.00    1.10
innodb  create+drop                          34.00       -0.00%       0.00    
33.00   35.00   34.00    0.63
innodb  create_index                          3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  create_key+drop                      30.00       +2.60%       0.80    
30.00   32.00   30.80    0.75
innodb  create_MANY_tables                   21.00       -2.94%      -0.60    
19.00   21.00   20.40    0.80
innodb  delete_all_many_keys                619.00       +2.34%      14.80   
614.00  667.00  633.80   18.65
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.20     
0.00    1.00    0.20    0.40
innodb  delete_big_many_keys                619.00       +2.30%      14.60   
614.00  667.00  633.60   18.68
innodb  delete_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  delete_key                            4.00      -33.33%      -1.00     
2.00    4.00    3.00    0.63
innodb  delete_range                          8.00       +4.76%       0.40     
8.00    9.00    8.40    0.49
innodb  delete_rollback                       2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  drop_index                            3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  drop_table_when_MANY_tables          18.00       +1.10%       0.20    
17.00   19.00   18.20    0.75
innodb  insert                              114.00       -0.00%       0.00   
113.00  116.00  114.00    1.10
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       +1.04%       0.20    
19.00   20.00   19.20    0.40
innodb  insert_key                          274.00       +1.08%       3.00   
272.00  287.00  277.00    5.37
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      +13.79%       0.80     
5.00    6.00    5.80    0.40
innodb  min_max                               7.00       -0.00%       0.00     
6.00    8.00    7.00    0.63
innodb  min_max_on_key                       24.00       +1.64%       0.40    
24.00   25.00   24.40    0.49
innodb  multiple_value_insert                 6.00       +6.25%       0.40     
6.00    7.00    6.40    0.49
innodb  once_prepared_select                 29.00       -1.40%      -0.40    
28.00   29.00   28.60    0.49
innodb  order_by_big                         15.00       -5.63%      -0.80    
13.00   15.00   14.20    0.98
innodb  order_by_big_key                     15.00       -4.17%      -0.60    
12.00   16.00   14.40    1.62
innodb  order_by_big_key2                    13.00       -4.84%      -0.60    
11.00   13.00   12.40    0.80
innodb  order_by_big_key_desc                14.00       +7.89%       1.20    
14.00   16.00   15.20    0.98
innodb  order_by_big_key_diff                14.00       -6.06%      -0.80    
12.00   14.00   13.20    0.75
innodb  order_by_big_key_prefix              14.00       -9.38%      -1.20    
12.00   14.00   12.80    0.75
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                           19.00      +16.67%       3.80    
19.00   25.00   22.80    2.14
innodb  outer_join_found                     17.00      +21.30%       4.60    
17.00   24.00   21.60    2.50
innodb  outer_join_not_found                 17.00      +12.37%       2.40    
17.00   21.00   19.40    1.36
innodb  outer_join_on_key                    12.00      +22.08%       3.40    
12.00   17.00   15.40    1.85
innodb  prepared_select                      37.00       -0.00%       0.00    
37.00   37.00   37.00    0.00
innodb  select_1_row                          3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  select_1_row_cache                    4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_2_rows                         4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  select_big                           14.00       -6.06%      -0.80    
12.00   14.00   13.20    0.75
innodb  select_big_str                        2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  select_cache                         59.00       +3.59%       2.20    
59.00   64.00   61.20    2.04
innodb  select_cache2                        58.00       +7.64%       4.80    
58.00   66.00   62.80    3.06
innodb  select_column+column                  3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_diff_key                       1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  select_distinct                       5.00      -13.64%      -0.60     
4.00    5.00    4.40    0.49
innodb  select_group                         16.00       +8.05%       1.40    
16.00   18.00   17.40    0.80
innodb  select_group_when_MANY_tables        12.00       +1.64%       0.20    
12.00   13.00   12.20    0.40
innodb  select_join                           0.00     +100.00%       0.80     
0.00    1.00    0.80    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    
70.00   71.00   70.60    0.49
innodb  select_key2_return_key               68.00       +0.58%       0.40    
68.00   70.00   68.40    0.80
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.57%      -0.40    
70.00   72.00   70.60    0.80
innodb  select_key_prefix_join                5.00       -0.00%       0.00     
5.00    5.00    5.00    0.00
innodb  select_key_return_key                64.00       -1.91%      -1.20    
62.00   64.00   62.80    0.75
innodb  select_many_fields                   14.00       -4.48%      -0.60    
13.00   14.00   13.40    0.49
innodb  select_range                         44.00       -3.77%      -1.60    
39.00   47.00   42.40    2.87
innodb  select_range_key2                     9.00       +4.26%       0.40     
9.00   10.00    9.40    0.49
innodb  select_range_prefix                   9.00       +2.17%       0.20     
8.00   10.00    9.20    0.75
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  update_autocommit                     4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  update_big                           58.00       -0.00%       0.00    
56.00   60.00   58.00    1.26
innodb  update_commit                         2.00       -0.00%       0.00     
1.00    3.00    2.00    0.63
innodb  update_of_key                        22.00       -1.85%      -0.40    
21.00   22.00   21.60    0.49
innodb  update_of_key_big                    46.00      -29.21%     -10.40    
29.00   46.00   35.60    5.82
innodb  update_of_primary_key_many_keys    1294.00       +1.79%      23.60  
1245.00 1369.00 1317.60   44.08
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     120.00       +0.33%       0.40   
116.00  126.00  120.40    3.26
innodb  update_with_key_prefix               45.00       -3.21%      -1.40    
40.00   47.00   43.60    2.65
innodb  wisc_benchmark                        3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      31.00       +4.62%       1.50    
25.00   35.00   32.50    2.56
innodb  alter_table_drop                     24.00       -1.27%      -0.30    
22.00   25.00   23.70    0.90
innodb  connect                               2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  connect+select_1_row                  3.00       -1.69%      -0.05     
2.00    3.00    2.95    0.22
innodb  connect+select_simple                 3.00      -13.21%      -0.35     
2.00    3.00    2.65    0.48
innodb  count                                14.00      +11.95%       1.90    
13.00   18.00   15.90    1.70
innodb  count_distinct                        7.00       -3.70%      -0.25     
5.00    8.00    6.75    0.94
innodb  count_distinct_2                     15.00       -8.70%      -1.20    
12.00   16.00   13.80    1.21
innodb  count_distinct_big                   21.00       +8.70%       2.00    
20.00   25.00   23.00    1.92
innodb  count_distinct_group                 15.00       -4.17%      -0.60    
11.00   15.00   14.40    0.97
innodb  count_distinct_group_on_key          10.00       -7.53%      -0.70     
8.00   11.00    9.30    0.95
innodb  count_distinct_group_on_key_parts    14.00       -6.87%      -0.90    
11.00   14.00   13.10    1.09
innodb  count_distinct_key_prefix             6.00       -9.09%      -0.50     
4.00    6.00    5.50    0.59
innodb  count_group_on_key_parts             11.00       -2.33%      -0.25    
10.00   12.00   10.75    0.54
innodb  count_on_key                         94.00       -1.13%      -1.05    
90.00   96.00   92.95    1.80
innodb  create+drop                          34.00       -2.10%      -0.70    
32.00   35.00   33.30    0.78
innodb  create_index                          3.00       +4.76%       0.15     
3.00    4.00    3.15    0.36
innodb  create_key+drop                      30.00       +4.00%       1.25    
30.00   33.00   31.25    0.83
innodb  create_MANY_tables                   21.00       -1.69%      -0.35    
19.00   22.00   20.65    0.79
innodb  delete_all_many_keys                619.00       +2.86%      18.25   
608.00  692.00  637.25   20.88
innodb  delete_autocommit                     3.00      +14.29%       0.50     
3.00    4.00    3.50    0.50
innodb  delete_big                            0.00     +100.00%       0.35     
0.00    1.00    0.35    0.48
innodb  delete_big_many_keys                619.00       +2.76%      17.55   
608.00  691.00  636.55   20.81
innodb  delete_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  delete_key                            4.00      -45.45%      -1.25     
2.00    4.00    2.75    0.54
innodb  delete_range                          8.00       +6.43%       0.55     
7.00   10.00    8.55    0.74
innodb  delete_rollback                       2.00      +11.11%       0.25     
2.00    3.00    2.25    0.43
innodb  drop_index                            3.00       -0.00%       0.00     
2.00    4.00    3.00    0.55
innodb  drop_table_when_MANY_tables          18.00       +2.70%       0.50    
17.00   20.00   18.50    0.81
innodb  insert                              114.00       -0.18%      -0.20   
111.00  116.00  113.80    1.25
innodb  insert_autocommit                     3.00       +3.23%       0.10     
3.00    4.00    3.10    0.30
innodb  insert_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  insert_duplicates                    19.00       +0.52%       0.10    
18.00   20.00   19.10    0.44
innodb  insert_key                          274.00       +1.39%       3.85   
265.00  299.00  277.85    8.01
innodb  insert_many_fields                    6.00       -1.69%      -0.10     
5.00    7.00    5.90    0.44
innodb  insert_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  insert_select_1_key                   5.00      -26.58%      -1.05     
3.00    5.00    3.95    0.50
innodb  insert_select_2_keys                  5.00      +17.36%       1.05     
5.00    8.00    6.05    0.67
innodb  min_max                               7.00       +9.09%       0.70     
6.00    9.00    7.70    0.95
innodb  min_max_on_key                       24.00       +1.44%       0.35    
23.00   25.00   24.35    0.57
innodb  multiple_value_insert                 6.00       +6.25%       0.40     
5.00    7.00    6.40    0.58
innodb  once_prepared_select                 29.00       -0.35%      -0.10    
28.00   30.00   28.90    0.54
innodb  order_by_big                         15.00       -6.01%      -0.85    
12.00   15.00   14.15    1.06
innodb  order_by_big_key                     15.00       -4.53%      -0.65    
12.00   16.00   14.35    1.28
innodb  order_by_big_key2                    13.00       -2.77%      -0.35    
11.00   14.00   12.65    0.79
innodb  order_by_big_key_desc                14.00       +6.98%       1.05    
13.00   17.00   15.05    1.16
innodb  order_by_big_key_diff                14.00       -9.38%      -1.20    
11.00   14.00   12.80    0.75
innodb  order_by_big_key_prefix              14.00       -8.95%      -1.15    
12.00   14.00   12.85    0.73
innodb  order_by_key2_diff                    1.00      +23.08%       0.30     
1.00    2.00    1.30    0.46
innodb  order_by_key_prefix                   1.00      -33.33%      -0.25     
0.00    1.00    0.75    0.43
innodb  order_by_range                        1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  outer_join                           19.00      +15.56%       3.50    
18.00   26.00   22.50    2.38
innodb  outer_join_found                     17.00      +21.66%       4.70    
17.00   26.00   21.70    2.53
innodb  outer_join_not_found                 17.00      +13.04%       2.55    
16.00   22.00   19.55    1.69
innodb  outer_join_on_key                    12.00      +20.27%       3.05    
12.00   18.00   15.05    1.83
innodb  prepared_select                      37.00       -0.14%      -0.05    
36.00   38.00   36.95    0.50
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                         4.00       -9.59%      -0.35     
3.00    4.00    3.65    0.48
innodb  select_big                           14.00      -11.55%      -1.45    
11.00   15.00   12.55    1.12
innodb  select_big_str                        2.00      -53.85%      -0.70     
1.00    2.00    1.30    0.46
innodb  select_cache                         59.00       +6.05%       3.80    
57.00   67.00   62.80    2.96
innodb  select_cache2                        58.00       +9.52%       6.10    
58.00   70.00   64.10    2.79
innodb  select_column+column                  3.00      +20.00%       0.75     
3.00    4.00    3.75    0.43
innodb  select_diff_key                       1.00     -233.33%      -0.70     
0.00    1.00    0.30    0.46
innodb  select_distinct                       5.00       -7.53%      -0.35     
4.00    5.00    4.65    0.48
innodb  select_group                         16.00       +4.48%       0.75    
15.00   19.00   16.75    1.37
innodb  select_group_when_MANY_tables        12.00       +0.83%       0.10    
11.00   14.00   12.10    0.77
innodb  select_join                           0.00     +100.00%       0.45     
0.00    1.00    0.45    0.50
innodb  select_key                           64.00       -0.23%      -0.15    
63.00   65.00   63.85    0.48
innodb  select_key2                          71.00       -0.42%      -0.30    
69.00   72.00   70.70    0.78
innodb  select_key2_return_key               68.00       +0.44%       0.30    
67.00   70.00   68.30    0.84
innodb  select_key2_return_prim              69.00       +0.14%       0.10    
67.00   71.00   69.10    0.89
innodb  select_key_prefix                    71.00       -0.57%      -0.40    
69.00   72.00   70.60    0.97
innodb  select_key_prefix_join                5.00       +0.99%       0.05     
4.00    6.00    5.05    0.38
innodb  select_key_return_key                64.00       -1.75%      -1.10    
62.00   64.00   62.90    0.62
innodb  select_many_fields                   14.00       -5.26%      -0.70    
13.00   14.00   13.30    0.46
innodb  select_range                         44.00       -2.56%      -1.10    
38.00   47.00   42.90    2.88
innodb  select_range_key2                     9.00       +6.25%       0.60     
9.00   10.00    9.60    0.49
innodb  select_range_prefix                   9.00       +1.64%       0.15     
8.00   10.00    9.15    0.57
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      -17.65%      -0.15     
0.00    1.00    0.85    0.36
innodb  update_autocommit                     4.00       -9.59%      -0.35     
3.00    4.00    3.65    0.48
innodb  update_big                           58.00       +1.36%       0.80    
55.00   63.00   58.80    1.89
innodb  update_commit                         2.00       -5.26%      -0.10     
1.00    3.00    1.90    0.44
innodb  update_of_key                        22.00       +0.90%       0.20    
21.00   25.00   22.20    1.25
innodb  update_of_key_big                    46.00      -24.83%      -9.15    
29.00   46.00   36.85    4.81
innodb  update_of_primary_key_many_keys    1294.00       +2.46%      32.65  
1233.00 1464.00 1326.65   48.78
innodb  update_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  update_with_key                     120.00       +1.40%       1.70   
116.00  127.00  121.70    3.30
innodb  update_with_key_prefix               45.00       -2.51%      -1.10    
40.00   47.00   43.90    1.89
innodb  wisc_benchmark                        3.00      -11.11%      -0.30     
2.00    3.00    2.70    0.46

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      31.00      -44.71%      -9.58    
11.00   61.00   21.42   10.15
innodb  alter_table_drop                     24.00      -29.27%      -5.43    
10.00   57.00   18.57    6.91
innodb  connect                               2.00       +4.04%       0.08     
1.00    3.00    2.08    0.42
innodb  connect+select_1_row                  3.00      -10.79%      -0.29     
2.00    5.00    2.71    0.47
innodb  connect+select_simple                 3.00      -27.32%      -0.64     
1.00    3.00    2.36    0.49
innodb  count                                14.00      +11.12%       1.75    
12.00  193.00   15.75    8.68
innodb  count_distinct                        7.00       -6.50%      -0.43     
5.00   50.00    6.57    2.24
innodb  count_distinct_2                     15.00      -13.53%      -1.79    
11.00   63.00   13.21    2.91
innodb  count_distinct_big                   21.00       +4.39%       0.96     
5.00   67.00   21.96    3.00
innodb  count_distinct_group                 15.00      -13.70%      -1.81    
10.00   68.00   13.19    3.05
innodb  count_distinct_group_on_key          10.00       -5.26%      -0.50     
7.00   69.00    9.50    2.97
innodb  count_distinct_group_on_key_parts    14.00      -13.31%      -1.64     
9.00   72.00   12.36    3.11
innodb  count_distinct_key_prefix             6.00      -16.87%      -0.87     
3.00   52.00    5.13    2.35
innodb  count_group_on_key_parts             11.00       -9.90%      -0.99     
7.00   72.00   10.01    3.10
innodb  count_on_key                         94.00       -9.03%      -7.78    
68.00  107.00   86.22    7.37
innodb  create+drop                          34.00       -4.73%      -1.53    
18.00   75.00   32.47   11.69
innodb  create_index                          3.00       -3.49%      -0.10     
1.00    8.00    2.90    1.13
innodb  create_key+drop                      30.00       -6.02%      -1.70    
21.00   50.00   28.30    4.87
innodb  create_MANY_tables                   21.00      +37.55%      12.62    
14.00  121.00   33.62   16.98
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.36
innodb  delete_all_many_keys                619.00      -31.62%    -148.71   
212.00 1888.00  470.29  359.93
innodb  delete_autocommit                     3.00      +13.01%       0.45     
2.00   14.00    3.45    0.74
innodb  delete_big                            0.00     +100.00%       0.30     
0.00    3.00    0.30    0.47
innodb  delete_big_many_keys                619.00      -30.00%    -142.86   
212.00 2293.00  476.14  373.74
innodb  delete_commit                         2.00      -31.22%      -0.48     
1.00    5.00    1.52    0.53
innodb  delete_key                            4.00      -31.36%      -0.95     
2.00   35.00    3.05    1.48
innodb  delete_range                          8.00       +3.87%       0.32     
5.00   23.00    8.32    3.19
innodb  delete_rollback                       2.00      -14.12%      -0.25     
1.00   12.00    1.75    0.91
innodb  drop_index                            3.00       -1.64%      -0.05     
1.00    9.00    2.95    1.30
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.90%       1.54    
11.00   90.00   19.54    7.41
innodb  insert                              114.00       -6.62%      -7.07     
3.00  343.00  106.93   14.41
innodb  insert_autocommit                     3.00       +0.07%       0.00     
2.00   99.00    3.00    3.26
innodb  insert_commit                         2.00      -43.39%      -0.61     
1.00    3.00    1.39    0.50
innodb  insert_duplicates                    19.00      -21.97%      -3.42    
11.00   21.00   15.58    2.69
innodb  insert_key                          274.00       +9.37%      28.33   
142.00  700.00  302.33  105.26
innodb  insert_many_fields                    6.00       -6.86%      -0.39     
3.00   17.00    5.61    1.75
innodb  insert_rollback                       2.00      -19.09%      -0.32     
1.00    3.00    1.68    0.53
innodb  insert_select_1_key                   5.00      -32.10%      -1.22     
2.00   10.00    3.78    0.88
innodb  insert_select_2_keys                  5.00      +17.67%       1.07     
4.00   16.00    6.07    2.06
innodb  min_max                               7.00      +10.52%       0.82     
6.00  110.00    7.82    4.47
innodb  min_max_on_key                       24.00      -16.14%      -3.34    
14.00   37.00   20.66    3.11
innodb  multiple_value_insert                 6.00       -9.36%      -0.51     
2.00   50.00    5.49    4.22
innodb  once_prepared_select                 29.00      -19.07%      -4.64    
18.00   32.00   24.36    3.61
innodb  order_by_big                         15.00       -4.80%      -0.69    
12.00   31.00   14.31    1.52
innodb  order_by_big_key                     15.00      -12.71%      -1.69    
11.00   32.00   13.31    1.64
innodb  order_by_big_key2                    13.00       -6.38%      -0.78    
10.00   33.00   12.22    1.53
innodb  order_by_big_key_desc                14.00       -3.35%      -0.45    
11.00   32.00   13.55    1.69
innodb  order_by_big_key_diff                14.00      -14.30%      -1.75    
10.00   31.00   12.25    1.49
innodb  order_by_big_key_prefix              14.00      -12.72%      -1.58    
10.00   32.00   12.42    1.55
innodb  order_by_key2_diff                    1.00      +28.33%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -26.14%      -0.21     
0.00    2.00    0.79    0.41
innodb  order_by_range                        1.00      -19.68%      -0.16     
0.00    2.00    0.84    0.38
innodb  outer_join                           19.00       +2.15%       0.42    
15.00   61.00   19.42    3.72
innodb  outer_join_found                     17.00       +9.75%       1.84    
14.00   58.00   18.84    3.58
innodb  outer_join_not_found                 17.00       -2.78%      -0.46    
12.00   46.00   16.54    3.18
innodb  outer_join_on_key                    12.00       +7.42%       0.96    
10.00   59.00   12.96    2.77
innodb  prepared_select                      37.00      -17.48%      -5.51    
22.00   40.00   31.49    4.55
innodb  select_1_row                          3.00       -4.54%      -0.13     
2.00    4.00    2.87    0.69
innodb  select_1_row_cache                    4.00      -47.78%      -1.29     
2.00    4.00    2.71    0.70
innodb  select_2_rows                         4.00      -37.98%      -1.10     
2.00    4.00    2.90    0.71
innodb  select_big                           14.00      -14.97%      -1.82     
0.00   31.00   12.18    1.54
innodb  select_big_str                        2.00      -71.00%      -0.83     
0.00    2.00    1.17    0.38
innodb  select_cache                         59.00       +1.22%       0.73    
49.00   77.00   59.73    5.60
innodb  select_cache2                        58.00       +3.47%       2.09    
49.00   75.00   60.09    6.23
innodb  select_column+column                  3.00       -1.79%      -0.05     
2.00    4.00    2.95    0.72
innodb  select_diff_key                       1.00     -348.48%      -0.78     
0.00    1.00    0.22    0.42
innodb  select_distinct                       5.00      -17.76%      -0.75     
3.00    8.00    4.25    0.55
innodb  select_group                         16.00       +1.67%       0.27     
4.00  136.00   16.27    5.35
innodb  select_group_when_MANY_tables        12.00      -25.71%      -2.45     
3.00   49.00    9.55    9.32
innodb  select_join                           0.00     +100.00%       0.58     
0.00    1.00    0.58    0.49
innodb  select_key                           64.00      -20.56%     -10.92    
40.00   66.00   53.08    7.57
innodb  select_key2                          71.00      -18.77%     -11.22    
45.00   75.00   59.78    8.39
innodb  select_key2_return_key               68.00      -19.06%     -10.89    
42.00   71.00   57.11    8.21
innodb  select_key2_return_prim              69.00      -19.22%     -11.12    
42.00   72.00   57.88    8.35
innodb  select_key_prefix                    71.00      -20.24%     -11.95    
44.00   75.00   59.05    8.44
innodb  select_key_prefix_join                5.00       -5.73%      -0.27     
3.00   10.00    4.73    0.65
innodb  select_key_return_key                64.00      -22.82%     -11.89    
38.00   65.00   52.11    7.58
innodb  select_many_fields                   14.00       +5.99%       0.89    
11.00   19.00   14.89    1.79
innodb  select_range                         44.00       +6.19%       2.91    
38.00   76.00   46.91    4.06
innodb  select_range_key2                     9.00       -8.47%      -0.70     
6.00   11.00    8.30    1.06
innodb  select_range_prefix                   9.00      -14.27%      -1.12     
5.00   10.00    7.88    1.12
innodb  select_simple                         2.00      -20.68%      -0.34     
1.00    3.00    1.66    0.51
innodb  select_simple_cache                   2.00      -27.51%      -0.43     
1.00    3.00    1.57    0.51
innodb  select_simple_join                    1.00      -50.85%      -0.34     
0.00    3.00    0.66    0.48
innodb  update_autocommit                     4.00      -19.69%      -0.66     
2.00   16.00    3.34    1.00
innodb  update_big                           58.00      -13.23%      -6.78    
31.00  195.00   51.22   24.13
innodb  update_commit                         2.00      -27.09%      -0.43     
1.00   10.00    1.57    0.72
innodb  update_of_key                        22.00       +8.98%       2.17    
18.00  100.00   24.17    6.09
innodb  update_of_key_big                    46.00      -65.95%     -18.28    
15.00   75.00   27.72   10.92
innodb  update_of_primary_key_many_keys    1294.00       -4.02%     -49.98   
647.00 6065.00 1244.02  940.48
innodb  update_rollback                       2.00      -13.10%      -0.23     
1.00   31.00    1.77    1.87
innodb  update_with_key                     120.00       -8.89%      -9.80    
90.00  598.00  110.20   20.57
innodb  update_with_key_prefix               45.00      -13.15%      -5.23    
33.00  202.00   39.77    6.77
innodb  wisc_benchmark                        3.00      -21.17%      -0.52     
2.00    5.00    2.48    0.53

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

  2232.1.2: patrick crews 2011-03-13 Updates to make this work properly on mac 
- tested on hades
  2232.1.1: patrick crews 2011-03-12 Added top_builddir/libdrizzle/.libs to 
LD_LIBRARY_PATH

_______________________________________________
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