=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   957
RUN DATE: 2011-03-14T00:01:32.757984
SERVER:   drizzled
VERSION:  staging
REVISION: 2238
COMMENT:  2238: Brian Aker 2011-03-13 Remove ifdef/define/etc

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00       -2.48%      -0.80    
26.00   34.00   32.20    3.12
innodb  alter_table_drop                     23.00       -0.00%       0.00    
22.00   24.00   23.00    0.63
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       +6.67%       1.00    
14.00   17.00   15.00    1.10
innodb  count_distinct                        6.00      +11.76%       0.80     
6.00    8.00    6.80    0.98
innodb  count_distinct_2                     12.00       +9.09%       1.20    
12.00   14.00   13.20    0.75
innodb  count_distinct_big                   21.00       +9.48%       2.20    
21.00   25.00   23.20    1.83
innodb  count_distinct_group                 15.00       -7.14%      -1.00    
11.00   15.00   14.00    1.55
innodb  count_distinct_group_on_key           9.00       +2.17%       0.20     
8.00   11.00    9.20    1.17
innodb  count_distinct_group_on_key_parts    13.00       -0.00%       0.00    
11.00   14.00   13.00    1.10
innodb  count_distinct_key_prefix             4.00      +23.08%       1.20     
4.00    6.00    5.20    0.75
innodb  count_group_on_key_parts             12.00      -11.11%      -1.20    
10.00   12.00   10.80    0.75
innodb  count_on_key                         94.00       -0.43%      -0.40    
92.00   95.00   93.60    1.36
innodb  create+drop                          33.00       +1.79%       0.60    
32.00   35.00   33.60    1.02
innodb  create_index                          3.00       +6.25%       0.20     
3.00    4.00    3.20    0.40
innodb  create_key+drop                      31.00       +0.64%       0.20    
30.00   32.00   31.20    0.75
innodb  create_MANY_tables                   20.00       +0.99%       0.20    
19.00   21.00   20.20    0.75
innodb  delete_all_many_keys                638.00       +0.31%       2.00   
614.00  667.00  640.00   17.83
innodb  delete_autocommit                     4.00      -11.11%      -0.40     
3.00    4.00    3.60    0.49
innodb  delete_big                            1.00     -400.00%      -0.80     
0.00    1.00    0.20    0.40
innodb  delete_big_many_keys                638.00       +0.25%       1.60   
614.00  667.00  639.60   17.83
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                          8.00       +2.44%       0.20     
7.00    9.00    8.20    0.75
innodb  delete_rollback                       3.00      -25.00%      -0.60     
2.00    3.00    2.40    0.49
innodb  drop_index                            3.00       -0.00%       0.00     
2.00    4.00    3.00    0.63
innodb  drop_table_when_MANY_tables          19.00       -3.26%      -0.60    
17.00   19.00   18.40    0.80
innodb  insert                              114.00       +0.18%       0.20   
113.00  116.00  114.20    1.17
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                    20.00       -4.17%      -0.80    
19.00   20.00   19.20    0.40
innodb  insert_key                          272.00       +2.09%       5.80   
272.00  287.00  277.80    5.15
innodb  insert_many_fields                    5.00      +13.79%       0.80     
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                   3.00      +21.05%       0.80     
3.00    4.00    3.80    0.40
innodb  insert_select_2_keys                  6.00       -0.00%       0.00     
6.00    6.00    6.00    0.00
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       +9.09%       0.60     
6.00    7.00    6.60    0.49
innodb  once_prepared_select                 29.00       -1.40%      -0.40    
28.00   29.00   28.60    0.49
innodb  order_by_big                         13.00       +5.80%       0.80    
13.00   15.00   13.80    0.98
innodb  order_by_big_key                     16.00      -14.29%      -2.00    
12.00   16.00   14.00    1.67
innodb  order_by_big_key2                    13.00       -6.56%      -0.80    
11.00   13.00   12.20    0.75
innodb  order_by_big_key_desc                16.00       -6.67%      -1.00    
13.00   16.00   15.00    1.26
innodb  order_by_big_key_diff                13.00       -3.17%      -0.40    
11.00   14.00   12.60    1.02
innodb  order_by_big_key_prefix              13.00       -4.84%      -0.60    
12.00   13.00   12.40    0.49
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                           24.00       +0.83%       0.20    
22.00   26.00   24.20    1.33
innodb  outer_join_found                     23.00       +1.71%       0.40    
21.00   26.00   23.40    1.62
innodb  outer_join_not_found                 21.00       -3.96%      -0.80    
19.00   21.00   20.20    0.75
innodb  outer_join_on_key                    16.00       +3.61%       0.60    
15.00   18.00   16.60    1.02
innodb  prepared_select                      37.00       +0.54%       0.20    
37.00   38.00   37.20    0.40
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                           13.00       -3.17%      -0.40    
11.00   14.00   12.60    1.02
innodb  select_big_str                        1.00      +16.67%       0.20     
1.00    2.00    1.20    0.40
innodb  select_cache                         61.00       +0.97%       0.60    
59.00   64.00   61.60    1.74
innodb  select_cache2                        61.00       +3.79%       2.40    
61.00   66.00   63.40    2.24
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      -13.64%      -0.60     
4.00    5.00    4.40    0.49
innodb  select_group                         17.00       +1.16%       0.20    
15.00   18.00   17.20    1.17
innodb  select_group_when_MANY_tables        12.00       +1.64%       0.20    
12.00   13.00   12.20    0.40
innodb  select_join                           1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  select_key                           64.00       -0.00%       0.00    
63.00   65.00   64.00    0.63
innodb  select_key2                          71.00       -0.28%      -0.20    
70.00   72.00   70.80    0.75
innodb  select_key2_return_key               70.00       -2.04%      -1.40    
68.00   70.00   68.60    0.80
innodb  select_key2_return_prim              70.00       -0.86%      -0.60    
68.00   71.00   69.40    1.02
innodb  select_key_prefix                    72.00       -1.98%      -1.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                63.00       -0.64%      -0.40    
62.00   63.00   62.60    0.49
innodb  select_many_fields                   14.00       -4.48%      -0.60    
13.00   14.00   13.40    0.49
innodb  select_range                         40.00       +6.10%       2.60    
39.00   47.00   42.60    3.01
innodb  select_range_key2                    10.00       -4.17%      -0.40     
9.00   10.00    9.60    0.49
innodb  select_range_prefix                   8.00      +13.04%       1.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                    0.00     +100.00%       0.40     
0.00    1.00    0.40    0.49
innodb  update_autocommit                     4.00      -17.65%      -0.60     
3.00    4.00    3.40    0.49
innodb  update_big                           56.00       +3.11%       1.80    
56.00   60.00   57.80    1.33
innodb  update_commit                         1.00      +50.00%       1.00     
1.00    3.00    2.00    0.63
innodb  update_of_key                        21.00       +2.78%       0.60    
21.00   22.00   21.60    0.49
innodb  update_of_key_big                    32.00       +4.76%       1.60    
29.00   37.00   33.60    2.87
innodb  update_of_primary_key_many_keys    1351.00       -1.81%     -24.00  
1245.00 1369.00 1327.00   43.04
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     116.00       +4.76%       5.80   
116.00  127.00  121.80    4.17
innodb  update_with_key_prefix               41.00       +5.53%       2.40    
40.00   47.00   43.40    2.58
innodb  wisc_benchmark                        2.00      +28.57%       0.80     
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                      33.00       -1.07%      -0.35    
25.00   35.00   32.65    2.55
innodb  alter_table_drop                     23.00       +2.75%       0.65    
22.00   25.00   23.65    0.91
innodb  connect                               2.00      +11.11%       0.25     
2.00    3.00    2.25    0.43
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      -15.38%      -0.40     
2.00    3.00    2.60    0.49
innodb  count                                14.00      +13.04%       2.10    
13.00   18.00   16.10    1.70
innodb  count_distinct                        6.00      +11.11%       0.75     
5.00    8.00    6.75    0.94
innodb  count_distinct_2                     12.00      +13.36%       1.85    
12.00   16.00   13.85    1.28
innodb  count_distinct_big                   21.00       +9.48%       2.20    
20.00   25.00   23.20    1.91
innodb  count_distinct_group                 15.00       -4.17%      -0.60    
11.00   15.00   14.40    0.97
innodb  count_distinct_group_on_key           9.00       +3.23%       0.30     
8.00   11.00    9.30    0.95
innodb  count_distinct_group_on_key_parts    13.00       +0.76%       0.10    
11.00   14.00   13.10    1.09
innodb  count_distinct_key_prefix             4.00      +26.61%       1.45     
4.00    6.00    5.45    0.59
innodb  count_group_on_key_parts             12.00      -11.63%      -1.25    
10.00   12.00   10.75    0.54
innodb  count_on_key                         94.00       -1.29%      -1.20    
90.00   96.00   92.80    1.83
innodb  create+drop                          33.00       +0.75%       0.25    
32.00   35.00   33.25    0.77
innodb  create_index                          3.00       +4.76%       0.15     
3.00    4.00    3.15    0.36
innodb  create_key+drop                      31.00       +1.12%       0.35    
30.00   33.00   31.35    0.79
innodb  create_MANY_tables                   20.00       +3.15%       0.65    
19.00   22.00   20.65    0.79
innodb  delete_all_many_keys                638.00       -0.02%      -0.15   
608.00  692.00  637.85   20.51
innodb  delete_autocommit                     4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
innodb  delete_big                            1.00     -150.00%      -0.60     
0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                638.00       -0.14%      -0.90   
608.00  691.00  637.10   20.48
innodb  delete_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  delete_key                            3.00      -11.11%      -0.30     
2.00    3.00    2.70    0.46
innodb  delete_range                          8.00       +6.43%       0.55     
7.00   10.00    8.55    0.74
innodb  delete_rollback                       3.00      -33.33%      -0.75     
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          19.00       -2.43%      -0.45    
17.00   20.00   18.55    0.80
innodb  insert                              114.00       -0.26%      -0.30   
111.00  116.00  113.70    1.31
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                    20.00       -4.44%      -0.85    
18.00   20.00   19.15    0.48
innodb  insert_key                          272.00       +2.14%       5.95   
265.00  299.00  277.95    7.98
innodb  insert_many_fields                    5.00      +15.25%       0.90     
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                   3.00      +23.08%       0.90     
3.00    5.00    3.90    0.44
innodb  insert_select_2_keys                  6.00       +1.64%       0.10     
5.00    8.00    6.10    0.62
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.64%       0.40    
23.00   25.00   24.40    0.58
innodb  multiple_value_insert                 6.00       +6.98%       0.45     
5.00    7.00    6.45    0.59
innodb  once_prepared_select                 29.00       -0.35%      -0.10    
28.00   30.00   28.90    0.54
innodb  order_by_big                         13.00       +8.13%       1.15    
12.00   15.00   14.15    1.06
innodb  order_by_big_key                     16.00      -12.28%      -1.75    
12.00   16.00   14.25    1.30
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                16.00       -6.67%      -1.00    
13.00   17.00   15.00    1.22
innodb  order_by_big_key_diff                13.00       -1.96%      -0.25    
11.00   14.00   12.75    0.70
innodb  order_by_big_key_prefix              13.00       -1.56%      -0.20    
12.00   14.00   12.80    0.68
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                           24.00       -6.67%      -1.50    
18.00   26.00   22.50    2.38
innodb  outer_join_found                     23.00       -5.75%      -1.25    
17.00   26.00   21.75    2.45
innodb  outer_join_not_found                 21.00       -7.42%      -1.45    
16.00   22.00   19.55    1.69
innodb  outer_join_on_key                    16.00       -5.96%      -0.90    
12.00   18.00   15.10    1.76
innodb  prepared_select                      37.00       -0.14%      -0.05    
36.00   38.00   36.95    0.50
innodb  select_1_row                          3.00      +15.49%       0.55     
3.00    4.00    3.55    0.50
innodb  select_1_row_cache                    4.00      -15.94%      -0.55     
3.00    4.00    3.45    0.50
innodb  select_2_rows                         3.00      +17.81%       0.65     
3.00    4.00    3.65    0.48
innodb  select_big                           13.00       -4.42%      -0.55    
11.00   15.00   12.45    1.07
innodb  select_big_str                        1.00      +20.00%       0.25     
1.00    2.00    1.25    0.43
innodb  select_cache                         61.00       +3.33%       2.10    
57.00   67.00   63.10    2.86
innodb  select_cache2                        61.00       +4.91%       3.15    
59.00   70.00   64.15    2.69
innodb  select_column+column                  4.00       -5.26%      -0.20     
3.00    4.00    3.80    0.40
innodb  select_diff_key                       1.00     -300.00%      -0.75     
0.00    1.00    0.25    0.43
innodb  select_distinct                       5.00       -8.70%      -0.40     
4.00    5.00    4.60    0.49
innodb  select_group                         17.00       -1.80%      -0.30    
15.00   19.00   16.70    1.42
innodb  select_group_when_MANY_tables        12.00       +0.83%       0.10    
11.00   14.00   12.10    0.77
innodb  select_join                           1.00     -100.00%      -0.50     
0.00    1.00    0.50    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               70.00       -2.41%      -1.65    
67.00   70.00   68.35    0.85
innodb  select_key2_return_prim              70.00       -1.23%      -0.85    
67.00   71.00   69.15    0.91
innodb  select_key_prefix                    72.00       -1.91%      -1.35    
69.00   72.00   70.65    1.01
innodb  select_key_prefix_join                5.00       +0.99%       0.05     
4.00    6.00    5.05    0.38
innodb  select_key_return_key                63.00       -0.16%      -0.10    
62.00   64.00   62.90    0.62
innodb  select_many_fields                   14.00       -5.66%      -0.75    
13.00   14.00   13.25    0.43
innodb  select_range                         40.00       +6.21%       2.65    
38.00   47.00   42.65    2.99
innodb  select_range_key2                    10.00       -3.63%      -0.35     
9.00   10.00    9.65    0.48
innodb  select_range_prefix                   8.00      +12.57%       1.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                    0.00     +100.00%       0.85     
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                           56.00       +4.76%       2.80    
55.00   63.00   58.80    1.89
innodb  update_commit                         1.00      +47.37%       0.90     
1.00    3.00    1.90    0.44
innodb  update_of_key                        21.00       +5.19%       1.15    
21.00   25.00   22.15    1.28
innodb  update_of_key_big                    32.00      +11.85%       4.30    
29.00   46.00   36.30    4.34
innodb  update_of_primary_key_many_keys    1351.00       -1.73%     -23.00  
1233.00 1464.00 1328.00   48.23
innodb  update_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  update_with_key                     116.00       +4.72%       5.75   
116.00  127.00  121.75    3.28
innodb  update_with_key_prefix               41.00       +6.29%       2.75    
40.00   47.00   43.75    1.92
innodb  wisc_benchmark                        2.00      +24.53%       0.65     
2.00    3.00    2.65    0.48

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      33.00      -54.12%     -11.59    
11.00   61.00   21.41   10.15
innodb  alter_table_drop                     23.00      -23.92%      -4.44    
10.00   57.00   18.56    6.92
innodb  connect                               2.00       +4.05%       0.08     
1.00    3.00    2.08    0.42
innodb  connect+select_1_row                  3.00      -10.80%      -0.29     
2.00    5.00    2.71    0.47
innodb  connect+select_simple                 3.00      -27.36%      -0.64     
1.00    3.00    2.36    0.49
innodb  count                                14.00      +11.13%       1.75    
12.00  193.00   15.75    8.69
innodb  count_distinct                        6.00       +8.70%       0.57     
5.00   50.00    6.57    2.24
innodb  count_distinct_2                     12.00       +9.16%       1.21    
11.00   63.00   13.21    2.92
innodb  count_distinct_big                   21.00       +4.39%       0.97     
5.00   67.00   21.97    3.00
innodb  count_distinct_group                 15.00      -13.72%      -1.81    
10.00   68.00   13.19    3.06
innodb  count_distinct_group_on_key           9.00       +5.26%       0.50     
7.00   69.00    9.50    2.98
innodb  count_distinct_group_on_key_parts    13.00       -5.23%      -0.65     
9.00   72.00   12.35    3.11
innodb  count_distinct_key_prefix             4.00      +22.07%       1.13     
3.00   52.00    5.13    2.35
innodb  count_group_on_key_parts             12.00      -19.91%      -1.99     
7.00   72.00   10.01    3.11
innodb  count_on_key                         94.00       -9.04%      -7.79    
68.00  107.00   86.21    7.37
innodb  create+drop                          33.00       -1.65%      -0.54    
18.00   75.00   32.46   11.70
innodb  create_index                          3.00       -3.49%      -0.10     
1.00    8.00    2.90    1.13
innodb  create_key+drop                      31.00       -9.56%      -2.71    
21.00   50.00   28.29    4.87
innodb  create_MANY_tables                   20.00      +40.55%      13.64    
14.00  121.00   33.64   16.98
innodb  create_table                          0.00     +100.00%       0.11     
0.00    3.00    0.11    0.36
innodb  delete_all_many_keys                638.00      -35.71%    -167.89   
212.00 1888.00  470.11  360.10
innodb  delete_autocommit                     4.00      -15.96%      -0.55     
2.00   14.00    3.45    0.74
innodb  delete_big                            1.00     -233.83%      -0.70     
0.00    3.00    0.30    0.47
innodb  delete_big_many_keys                638.00      -34.04%    -162.03   
212.00 2293.00  475.97  373.93
innodb  delete_commit                         2.00      -31.26%      -0.48     
1.00    5.00    1.52    0.53
innodb  delete_key                            3.00       +1.44%       0.04     
2.00   35.00    3.04    1.48
innodb  delete_range                          8.00       +3.87%       0.32     
5.00   23.00    8.32    3.19
innodb  delete_rollback                       3.00      -71.21%      -1.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          19.00       +2.80%       0.55    
11.00   90.00   19.55    7.41
innodb  insert                              114.00       -6.62%      -7.08     
3.00  343.00  106.92   14.42
innodb  insert_autocommit                     3.00       +0.08%       0.00     
2.00   99.00    3.00    3.26
innodb  insert_commit                         2.00      -43.46%      -0.61     
1.00    3.00    1.39    0.50
innodb  insert_duplicates                    20.00      -28.42%      -4.43    
11.00   21.00   15.57    2.69
innodb  insert_key                          272.00      +10.04%      30.36   
142.00  700.00  302.36  105.32
innodb  insert_many_fields                    5.00      +10.94%       0.61     
3.00   17.00    5.61    1.75
innodb  insert_rollback                       2.00      -19.11%      -0.32     
1.00    3.00    1.68    0.53
innodb  insert_select_1_key                   3.00      +20.71%       0.78     
2.00   10.00    3.78    0.88
innodb  insert_select_2_keys                  6.00       +1.22%       0.07     
4.00   16.00    6.07    2.06
innodb  min_max                               7.00      +10.53%       0.82     
6.00  110.00    7.82    4.48
innodb  min_max_on_key                       24.00      -16.16%      -3.34    
14.00   37.00   20.66    3.11
innodb  multiple_value_insert                 6.00       -9.37%      -0.51     
2.00   50.00    5.49    4.22
innodb  once_prepared_select                 29.00      -19.09%      -4.65    
18.00   32.00   24.35    3.61
innodb  order_by_big                         13.00       +9.17%       1.31    
12.00   31.00   14.31    1.52
innodb  order_by_big_key                     16.00      -20.24%      -2.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                16.00      -18.12%      -2.45    
11.00   32.00   13.55    1.69
innodb  order_by_big_key_diff                13.00       -6.15%      -0.75    
10.00   31.00   12.25    1.49
innodb  order_by_big_key_prefix              13.00       -4.68%      -0.58    
10.00   32.00   12.42    1.55
innodb  order_by_key2_diff                    1.00      +28.35%       0.40     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -26.17%      -0.21     
0.00    2.00    0.79    0.41
innodb  order_by_range                        1.00      -19.70%      -0.16     
0.00    2.00    0.84    0.38
innodb  outer_join                           24.00      -23.59%      -4.58    
15.00   61.00   19.42    3.72
innodb  outer_join_found                     23.00      -22.10%      -4.16    
14.00   58.00   18.84    3.58
innodb  outer_join_not_found                 21.00      -26.96%      -4.46    
12.00   46.00   16.54    3.18
innodb  outer_join_on_key                    16.00      -23.43%      -3.04    
10.00   59.00   12.96    2.77
innodb  prepared_select                      37.00      -17.50%      -5.51    
22.00   40.00   31.49    4.55
innodb  select_1_row                          3.00       -4.55%      -0.13     
2.00    4.00    2.87    0.69
innodb  select_1_row_cache                    4.00      -47.86%      -1.29     
2.00    4.00    2.71    0.70
innodb  select_2_rows                         3.00       -3.53%      -0.10     
2.00    4.00    2.90    0.70
innodb  select_big                           13.00       -6.78%      -0.83     
0.00   31.00   12.17    1.54
innodb  select_big_str                        1.00      +14.43%       0.17     
0.00    2.00    1.17    0.38
innodb  select_cache                         61.00       -2.12%      -1.27    
49.00   77.00   59.73    5.60
innodb  select_cache2                        61.00       -1.51%      -0.91    
49.00   75.00   60.09    6.24
innodb  select_column+column                  4.00      -35.73%      -1.05     
2.00    4.00    2.95    0.72
innodb  select_diff_key                       1.00     -350.25%      -0.78     
0.00    1.00    0.22    0.42
innodb  select_distinct                       5.00      -17.78%      -0.75     
3.00    8.00    4.25    0.55
innodb  select_group                         17.00       -4.47%      -0.73     
4.00  136.00   16.27    5.36
innodb  select_group_when_MANY_tables        12.00      -25.74%      -2.46     
3.00   49.00    9.54    9.33
innodb  select_join                           1.00      -73.29%      -0.42     
0.00    1.00    0.58    0.49
innodb  select_key                           64.00      -20.59%     -10.93    
40.00   66.00   53.07    7.57
innodb  select_key2                          71.00      -18.80%     -11.23    
45.00   75.00   59.77    8.39
innodb  select_key2_return_key               70.00      -22.59%     -12.90    
42.00   71.00   57.10    8.20
innodb  select_key2_return_prim              70.00      -20.97%     -12.14    
42.00   72.00   57.86    8.35
innodb  select_key_prefix                    72.00      -21.96%     -12.96    
44.00   75.00   59.04    8.43
innodb  select_key_prefix_join                5.00       -5.73%      -0.27     
3.00   10.00    4.73    0.65
innodb  select_key_return_key                63.00      -20.93%     -10.90    
38.00   65.00   52.10    7.57
innodb  select_many_fields                   14.00       +6.00%       0.89    
11.00   19.00   14.89    1.79
innodb  select_range                         40.00      +14.73%       6.91    
38.00   76.00   46.91    4.06
innodb  select_range_key2                    10.00      -20.53%      -1.70     
6.00   11.00    8.30    1.06
innodb  select_range_prefix                   8.00       -1.59%      -0.13     
5.00   10.00    7.87    1.12
innodb  select_simple                         2.00      -20.71%      -0.34     
1.00    3.00    1.66    0.51
innodb  select_simple_cache                   2.00      -27.55%      -0.43     
1.00    3.00    1.57    0.51
innodb  select_simple_join                    0.00     +100.00%       0.66     
0.00    3.00    0.66    0.48
innodb  update_autocommit                     4.00      -19.72%      -0.66     
2.00   16.00    3.34    1.00
innodb  update_big                           56.00       -9.34%      -4.78    
31.00  195.00   51.22   24.14
innodb  update_commit                         1.00      +36.44%       0.57     
1.00   10.00    1.57    0.72
innodb  update_of_key                        21.00      +13.12%       3.17    
18.00  100.00   24.17    6.09
innodb  update_of_key_big                    32.00      -15.53%      -4.30    
15.00   75.00   27.70   10.91
innodb  update_of_primary_key_many_keys    1351.00       -8.61%    -107.05   
647.00 6065.00 1243.95  941.15
innodb  update_rollback                       2.00      -13.12%      -0.23     
1.00   31.00    1.77    1.87
innodb  update_with_key                     116.00       -5.27%      -5.81    
90.00  598.00  110.19   20.58
innodb  update_with_key_prefix               41.00       -3.10%      -1.23    
33.00  202.00   39.77    6.78
innodb  wisc_benchmark                        2.00      +19.20%       0.48     
2.00    5.00    2.48    0.53

=========================================================================================================================

_______________________________________________
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