=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   1061
RUN DATE: 2011-12-06T22:36:56.542352
SERVER:   drizzled
VERSION:  staging
REVISION: 2467
COMMENT:  2467: Mark Atwood 2011-12-06 [merge] merge 
lp:~stewart/drizzle/i_s-docs

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00       -6.67%      -2.00    
25.00   34.00   30.00    3.16
innodb  alter_table_drop                     26.00       -4.84%      -1.20    
23.00   26.00   24.80    0.98
innodb  connect                               2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  connect+select_1_row                  3.00       -0.00%       0.00     
3.00    3.00    3.00    0.00
innodb  connect+select_simple                 2.00      +16.67%       0.40     
2.00    3.00    2.40    0.49
innodb  count                                19.00      -23.38%      -3.60    
13.00   19.00   15.40    2.24
innodb  count_distinct                        7.00       +5.41%       0.40     
6.00    8.00    7.40    0.80
innodb  count_distinct_2                     13.00       -1.56%      -0.20    
11.00   15.00   12.80    1.33
innodb  count_distinct_big                   24.00       -8.11%      -1.80    
21.00   24.00   22.20    1.47
innodb  count_distinct_group                 15.00       -1.35%      -0.20    
14.00   15.00   14.80    0.40
innodb  count_distinct_group_on_key          11.00      -12.24%      -1.20     
9.00   11.00    9.80    0.98
innodb  count_distinct_group_on_key_parts    14.00       -1.45%      -0.20    
13.00   15.00   13.80    0.75
innodb  count_distinct_key_prefix             6.00      -11.11%      -0.60     
5.00    6.00    5.40    0.49
innodb  count_group_on_key_parts             10.00       +9.09%       1.00    
10.00   12.00   11.00    0.63
innodb  count_on_key                         95.00       -0.85%      -0.80    
92.00   96.00   94.20    1.33
innodb  create+drop                          35.00       -3.55%      -1.20    
33.00   35.00   33.80    0.75
innodb  create_index                          3.00       -0.00%       0.00     
2.00    4.00    3.00    0.63
innodb  create_key+drop                      31.00       +3.13%       1.00    
31.00   33.00   32.00    0.63
innodb  create_MANY_tables                   21.00       -2.94%      -0.60    
19.00   22.00   20.40    1.02
innodb  delete_all_many_keys                886.00       -5.30%     -44.60   
749.00  886.00  841.40   48.94
innodb  delete_autocommit                     4.00      -11.11%      -0.40     
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                886.00       -5.35%     -45.00   
748.00  886.00  841.00   49.34
innodb  delete_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  delete_key                            3.00       -7.14%      -0.20     
2.00    3.00    2.80    0.40
innodb  delete_range                          8.00       +4.76%       0.40     
8.00   10.00    8.40    0.80
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    4.00    2.60    0.80
innodb  drop_table_when_MANY_tables          18.00       +1.10%       0.20    
17.00   19.00   18.20    0.75
innodb  insert                              115.00       -0.88%      -1.00   
112.00  115.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                    20.00       -1.01%      -0.20    
19.00   20.00   19.80    0.40
innodb  insert_key                          290.00       -0.00%       0.00   
288.00  292.00  290.00    1.26
innodb  insert_many_fields                    5.00      +13.79%       0.80     
5.00    6.00    5.80    0.40
innodb  insert_rollback                       2.00       +9.09%       0.20     
2.00    3.00    2.20    0.40
innodb  insert_select_1_key                   4.00      +16.67%       0.80     
4.00    6.00    4.80    0.75
innodb  insert_select_2_keys                  7.00       -9.38%      -0.60     
5.00    7.00    6.40    0.80
innodb  min_max                               9.00      -15.38%      -1.20     
7.00    9.00    7.80    0.98
innodb  min_max_on_key                       26.00       -4.00%      -1.00    
24.00   26.00   25.00    0.63
innodb  multiple_value_insert                 6.00       -7.14%      -0.40     
5.00    6.00    5.60    0.49
innodb  once_prepared_select                 29.00       +0.68%       0.20    
29.00   30.00   29.20    0.40
innodb  order_by_big                         15.00       -5.63%      -0.80    
13.00   15.00   14.20    0.75
innodb  order_by_big_key                     13.00       +8.45%       1.20    
13.00   16.00   14.20    1.17
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                15.00       -0.00%       0.00    
13.00   16.00   15.00    1.10
innodb  order_by_big_key_diff                13.00       -0.00%       0.00    
13.00   13.00   13.00    0.00
innodb  order_by_big_key_prefix              14.00       -6.06%      -0.80    
13.00   14.00   13.20    0.40
innodb  order_by_key2_diff                    2.00      -42.86%      -0.60     
1.00    2.00    1.40    0.49
innodb  order_by_key_prefix                   1.00       -0.00%       0.00     
1.00    1.00    1.00    0.00
innodb  order_by_range                        0.00     +100.00%       0.80     
0.00    1.00    0.80    0.40
innodb  outer_join                           19.00      +14.41%       3.20    
19.00   25.00   22.20    2.64
innodb  outer_join_found                     18.00      +14.29%       3.00    
18.00   23.00   21.00    2.10
innodb  outer_join_not_found                 17.00      +12.37%       2.40    
17.00   21.00   19.40    1.96
innodb  outer_join_on_key                    12.00      +14.29%       2.00    
12.00   16.00   14.00    1.67
innodb  prepared_select                      37.00       +0.54%       0.20    
37.00   38.00   37.20    0.40
innodb  select_1_row                          4.00      -11.11%      -0.40     
3.00    4.00    3.60    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      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_big                           12.00       +3.23%       0.40    
11.00   14.00   12.40    1.02
innodb  select_big_str                        2.00      -66.67%      -0.80     
1.00    2.00    1.20    0.40
innodb  select_cache                         59.00       +3.28%       2.00    
56.00   66.00   61.00    3.41
innodb  select_cache2                        61.00       +4.98%       3.20    
61.00   67.00   64.20    2.04
innodb  select_column+column                  4.00       -0.00%       0.00     
4.00    4.00    4.00    0.00
innodb  select_distinct                       5.00       -0.00%       0.00     
5.00    5.00    5.00    0.00
innodb  select_group                         16.00       -0.00%       0.00    
16.00   16.00   16.00    0.00
innodb  select_group_when_MANY_tables        12.00       -1.69%      -0.20    
11.00   12.00   11.80    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   65.00   64.20    0.75
innodb  select_key2                          71.00       +0.84%       0.60    
71.00   73.00   71.60    0.80
innodb  select_key2_return_key               69.00       +0.29%       0.20    
68.00   71.00   69.20    0.98
innodb  select_key2_return_prim              69.00       +1.15%       0.80    
69.00   71.00   69.80    0.75
innodb  select_key_prefix                    71.00       +0.84%       0.60    
71.00   72.00   71.60    0.49
innodb  select_key_prefix_join                6.00       -0.00%       0.00     
6.00    6.00    6.00    0.00
innodb  select_key_return_key                63.00       +1.25%       0.80    
63.00   65.00   63.80    0.75
innodb  select_many_fields                   13.00       -0.00%       0.00    
13.00   13.00   13.00    0.00
innodb  select_range                         40.00      +10.71%       4.80    
40.00   49.00   44.80    3.31
innodb  select_range_key2                    10.00       -2.04%      -0.20     
9.00   10.00    9.80    0.40
innodb  select_range_prefix                   9.00       +2.17%       0.20     
9.00   10.00    9.20    0.40
innodb  select_simple                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  update_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  update_big                           58.00       +1.69%       1.00    
58.00   60.00   59.00    0.89
innodb  update_commit                         2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_of_key                        21.00       +4.55%       1.00    
21.00   24.00   22.00    1.10
innodb  update_of_key_big                    20.00       -2.04%      -0.40    
19.00   20.00   19.60    0.49
innodb  update_of_primary_key_many_keys    1276.00       +1.05%      13.60  
1271.00 1352.00 1289.60   31.24
innodb  update_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  update_with_key                     118.00       -0.34%      -0.40   
115.00  121.00  117.60    2.33
innodb  update_with_key_prefix               41.00       +1.91%       0.80    
40.00   43.00   41.80    1.17
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                      32.00       -2.24%      -0.70    
25.00   34.00   31.30    2.03
innodb  alter_table_drop                     26.00       -5.26%      -1.30    
23.00   27.00   24.70    1.00
innodb  connect                               2.00      +13.04%       0.30     
2.00    3.00    2.30    0.46
innodb  connect+select_1_row                  3.00       -1.69%      -0.05     
2.00    3.00    2.95    0.22
innodb  connect+select_simple                 2.00      +20.00%       0.50     
2.00    3.00    2.50    0.50
innodb  count                                19.00      -17.28%      -2.80    
13.00   19.00   16.20    2.06
innodb  count_distinct                        7.00       +3.45%       0.25     
6.00    8.00    7.25    0.77
innodb  count_distinct_2                     13.00       +4.06%       0.55    
11.00   16.00   13.55    1.24
innodb  count_distinct_big                   24.00       -4.80%      -1.10    
20.00   26.00   22.90    1.95
innodb  count_distinct_group                 15.00       -2.04%      -0.30    
12.00   16.00   14.70    0.95
innodb  count_distinct_group_on_key          11.00       -4.76%      -0.50     
9.00   12.00   10.50    1.12
innodb  count_distinct_group_on_key_parts    14.00       -1.82%      -0.25    
10.00   15.00   13.75    1.26
innodb  count_distinct_key_prefix             6.00      -13.21%      -0.70     
4.00    7.00    5.30    0.71
innodb  count_group_on_key_parts             10.00      +10.71%       1.20    
10.00   12.00   11.20    0.60
innodb  count_on_key                         95.00       +0.05%       0.05    
91.00  101.00   95.05    2.48
innodb  create+drop                          35.00       -4.79%      -1.60    
32.00   35.00   33.40    0.97
innodb  create_index                          3.00       -1.69%      -0.05     
2.00    4.00    2.95    0.59
innodb  create_key+drop                      31.00       +2.36%       0.75    
29.00   34.00   31.75    1.26
innodb  create_MANY_tables                   21.00       +1.87%       0.40    
19.00   25.00   21.40    1.43
innodb  create_table                          0.00     +100.00%       0.05     
0.00    1.00    0.05    0.22
innodb  delete_all_many_keys                886.00       -6.41%     -53.40   
735.00 1051.00  832.60   80.93
innodb  delete_autocommit                     4.00       -6.67%      -0.25     
3.00    4.00    3.75    0.43
innodb  delete_big                            1.00     -122.22%      -0.55     
0.00    1.00    0.45    0.50
innodb  delete_big_many_keys                886.00       -6.47%     -53.85   
735.00 1050.00  832.15   80.73
innodb  delete_commit                         2.00      -11.11%      -0.20     
1.00    2.00    1.80    0.40
innodb  delete_key                            3.00       -5.26%      -0.15     
2.00    3.00    2.85    0.36
innodb  delete_range                          8.00       +4.19%       0.35     
7.00   10.00    8.35    0.85
innodb  delete_rollback                       2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  drop_index                            2.00      +31.03%       0.90     
2.00    4.00    2.90    0.54
innodb  drop_table_when_MANY_tables          18.00       +6.25%       1.20    
17.00   21.00   19.20    1.12
innodb  insert                              115.00       -1.72%      -1.95   
110.00  116.00  113.05    1.53
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       -3.63%      -0.70    
19.00   20.00   19.30    0.46
innodb  insert_key                          290.00       -1.15%      -3.30   
279.00  305.00  286.70    6.07
innodb  insert_many_fields                    5.00       +9.91%       0.55     
5.00    6.00    5.55    0.50
innodb  insert_rollback                       2.00       -0.00%       0.00     
1.00    3.00    2.00    0.32
innodb  insert_select_1_key                   4.00      +18.37%       0.90     
4.00    6.00    4.90    0.70
innodb  insert_select_2_keys                  7.00       -6.87%      -0.45     
5.00    7.00    6.55    0.59
innodb  min_max                               9.00       -9.09%      -0.75     
7.00   10.00    8.25    0.99
innodb  min_max_on_key                       26.00       -5.05%      -1.25    
24.00   26.00   24.75    0.54
innodb  multiple_value_insert                 6.00       -2.56%      -0.15     
5.00    7.00    5.85    0.65
innodb  once_prepared_select                 29.00       -0.69%      -0.20    
28.00   30.00   28.80    0.60
innodb  order_by_big                         15.00       -5.63%      -0.80    
13.00   16.00   14.20    0.87
innodb  order_by_big_key                     13.00       +9.72%       1.40    
12.00   16.00   14.40    1.16
innodb  order_by_big_key2                    13.00       -4.42%      -0.55    
11.00   14.00   12.45    0.74
innodb  order_by_big_key_desc                15.00       +0.33%       0.05    
13.00   16.00   15.05    1.07
innodb  order_by_big_key_diff                13.00       -0.00%       0.00    
12.00   14.00   13.00    0.63
innodb  order_by_big_key_prefix              14.00       -6.46%      -0.85    
12.00   15.00   13.15    0.85
innodb  order_by_key2_diff                    2.00      -37.93%      -0.55     
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                        0.00     +100.00%       0.90     
0.00    1.00    0.90    0.30
innodb  outer_join                           19.00      +12.04%       2.60    
18.00   25.00   21.60    2.35
innodb  outer_join_found                     18.00      +11.98%       2.45    
17.00   24.00   20.45    2.58
innodb  outer_join_not_found                 17.00       +8.11%       1.50    
15.00   21.00   18.50    2.29
innodb  outer_join_on_key                    12.00      +10.78%       1.45    
12.00   16.00   13.45    1.32
innodb  prepared_select                      37.00       -0.14%      -0.05    
36.00   38.00   36.95    0.50
innodb  select_1_row                          4.00      -12.68%      -0.45     
3.00    4.00    3.55    0.50
innodb  select_1_row_cache                    4.00      -14.29%      -0.50     
3.00    4.00    3.50    0.50
innodb  select_2_rows                         3.00      +16.67%       0.60     
3.00    4.00    3.60    0.49
innodb  select_big                           12.00       +5.51%       0.70    
11.00   14.00   12.70    1.00
innodb  select_big_str                        2.00      -53.85%      -0.70     
1.00    2.00    1.30    0.46
innodb  select_cache                         59.00       +9.85%       6.45    
56.00   78.00   65.45    5.61
innodb  select_cache2                        61.00       +9.70%       6.55    
61.00   84.00   67.55    5.66
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.15     
0.00    1.00    0.15    0.36
innodb  select_distinct                       5.00       -4.17%      -0.20     
4.00    5.00    4.80    0.40
innodb  select_group                         16.00       +5.33%       0.90    
15.00   19.00   16.90    1.30
innodb  select_group_when_MANY_tables        12.00       +0.41%       0.05    
11.00   13.00   12.05    0.67
innodb  select_join                           0.00     +100.00%       0.70     
0.00    1.00    0.70    0.46
innodb  select_key                           64.00       -0.39%      -0.25    
62.00   66.00   63.75    1.09
innodb  select_key2                          71.00       -0.35%      -0.25    
69.00   73.00   70.75    1.13
innodb  select_key2_return_key               69.00       -0.66%      -0.45    
67.00   71.00   68.55    1.16
innodb  select_key2_return_prim              69.00       +0.14%       0.10    
67.00   71.00   69.10    0.99
innodb  select_key_prefix                    71.00       -0.64%      -0.45    
69.00   72.00   70.55    1.02
innodb  select_key_prefix_join                6.00       -7.14%      -0.40     
5.00    6.00    5.60    0.49
innodb  select_key_return_key                63.00       -0.16%      -0.10    
61.00   65.00   62.90    0.94
innodb  select_many_fields                   13.00       +1.52%       0.20    
13.00   14.00   13.20    0.40
innodb  select_range                         40.00      +10.21%       4.55    
40.00   49.00   44.55    2.85
innodb  select_range_key2                    10.00       -4.17%      -0.40     
9.00   10.00    9.60    0.49
innodb  select_range_prefix                   9.00       +2.17%       0.20     
8.00   10.00    9.20    0.51
innodb  select_simple                         2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  select_simple_cache                   2.00       -0.00%       0.00     
2.00    2.00    2.00    0.00
innodb  select_simple_join                    1.00      -66.67%      -0.40     
0.00    1.00    0.60    0.49
innodb  update_autocommit                     3.00      +11.76%       0.40     
3.00    4.00    3.40    0.49
innodb  update_big                           58.00       +0.26%       0.15    
54.00   60.00   58.15    1.46
innodb  update_commit                         2.00       -2.56%      -0.05     
1.00    2.00    1.95    0.22
innodb  update_of_key                        21.00       +6.87%       1.55    
21.00   24.00   22.55    1.07
innodb  update_of_key_big                    20.00       -2.56%      -0.50    
18.00   21.00   19.50    0.67
innodb  update_of_primary_key_many_keys    1276.00       +2.03%      26.40  
1226.00 1442.00 1302.40   45.62
innodb  update_rollback                       2.00       +2.44%       0.05     
2.00    3.00    2.05    0.22
innodb  update_with_key                     118.00       +2.28%       2.75   
115.00  128.00  120.75    3.81
innodb  update_with_key_prefix               41.00       +5.09%       2.20    
40.00   48.00   43.20    2.09
innodb  wisc_benchmark                        2.00      +21.57%       0.55     
2.00    3.00    2.55    0.50

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff     
Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      32.00      -42.57%      -9.56    
11.00   61.00   22.44   10.13
innodb  alter_table_drop                     26.00      -36.10%      -6.90    
10.00   57.00   19.10    6.77
innodb  connect                               2.00       +4.87%       0.10     
1.00    3.00    2.10    0.42
innodb  connect+select_1_row                  3.00       -9.79%      -0.27     
2.00    5.00    2.73    0.46
innodb  connect+select_simple                 2.00      +15.89%       0.38     
1.00    3.00    2.38    0.49
innodb  count                                19.00      -20.49%      -3.23    
12.00  193.00   15.77    8.27
innodb  count_distinct                        7.00       -5.88%      -0.39     
5.00   50.00    6.61    2.15
innodb  count_distinct_2                     13.00       +1.97%       0.26    
11.00   63.00   13.26    2.81
innodb  count_distinct_big                   24.00       -8.77%      -1.94     
5.00   67.00   22.06    2.92
innodb  count_distinct_group                 15.00      -12.68%      -1.69    
10.00   68.00   13.31    2.95
innodb  count_distinct_group_on_key          11.00      -15.31%      -1.46     
7.00   69.00    9.54    2.85
innodb  count_distinct_group_on_key_parts    14.00      -12.64%      -1.57     
9.00   72.00   12.43    2.99
innodb  count_distinct_key_prefix             6.00      -16.34%      -0.84     
3.00   52.00    5.16    2.24
innodb  count_group_on_key_parts             10.00       +1.19%       0.12     
7.00   72.00   10.12    2.97
innodb  count_on_key                         95.00       -9.04%      -7.88    
68.00  107.00   87.12    7.56
innodb  create+drop                          35.00       -7.61%      -2.48    
18.00   75.00   32.52   11.11
innodb  create_index                          3.00       -3.03%      -0.09     
1.00    8.00    2.91    1.08
innodb  create_key+drop                      31.00       -8.38%      -2.40    
21.00   50.00   28.60    4.73
innodb  create_MANY_tables                   21.00      +35.11%      11.36    
14.00  121.00   32.36   16.58
innodb  create_table                          0.00     +100.00%       0.10     
0.00    3.00    0.10    0.34
innodb  delete_all_many_keys                886.00      -76.16%    -383.04   
212.00 1888.00  502.96  357.50
innodb  delete_autocommit                     4.00      -15.49%      -0.54     
2.00   14.00    3.46    0.73
innodb  delete_big                            1.00     -222.22%      -0.69     
0.00    3.00    0.31    0.47
innodb  delete_big_many_keys                886.00      -74.39%    -377.95   
212.00 2293.00  508.05  369.51
innodb  delete_commit                         2.00      -28.39%      -0.44     
1.00    5.00    1.56    0.52
innodb  delete_key                            3.00       +0.91%       0.03     
2.00   35.00    3.03    1.41
innodb  delete_range                          8.00       +3.89%       0.32     
5.00   23.00    8.32    3.03
innodb  delete_rollback                       2.00      -12.30%      -0.22     
1.00   12.00    1.78    0.87
innodb  drop_index                            2.00      +32.37%       0.96     
1.00    9.00    2.96    1.25
innodb  drop_table                            0.00     +100.00%       0.04     
0.00    2.00    0.04    0.22
innodb  drop_table_when_MANY_tables          18.00       +7.55%       1.47    
11.00   90.00   19.47    7.04
innodb  insert                              115.00       -6.98%      -7.50     
3.00  343.00  107.50   13.80
innodb  insert_autocommit                     3.00       +0.54%       0.02     
2.00   99.00    3.02    3.10
innodb  insert_commit                         2.00      -38.97%      -0.56     
1.00    3.00    1.44    0.50
innodb  insert_duplicates                    20.00      -25.51%      -4.06    
11.00   21.00   15.94    2.77
innodb  insert_key                          290.00       +3.33%       9.99   
142.00  700.00  299.99   99.75
innodb  insert_many_fields                    5.00      +11.16%       0.63     
3.00   17.00    5.63    1.67
innodb  insert_rollback                       2.00      -16.89%      -0.29     
1.00    3.00    1.71    0.52
innodb  insert_select_1_key                   4.00       -3.44%      -0.13     
2.00   10.00    3.87    0.90
innodb  insert_select_2_keys                  7.00      -14.84%      -0.90     
4.00   16.00    6.10    1.97
innodb  min_max                               9.00      -14.76%      -1.16     
6.00  110.00    7.84    4.26
innodb  min_max_on_key                       26.00      -23.51%      -4.95    
14.00   37.00   21.05    3.18
innodb  multiple_value_insert                 6.00       -8.40%      -0.46     
2.00   50.00    5.54    4.02
innodb  once_prepared_select                 29.00      -16.89%      -4.19    
18.00   32.00   24.81    3.70
innodb  order_by_big                         15.00       -4.96%      -0.71    
12.00   31.00   14.29    1.48
innodb  order_by_big_key                     13.00       +3.01%       0.40    
11.00   32.00   13.40    1.64
innodb  order_by_big_key2                    13.00       -5.79%      -0.71    
10.00   33.00   12.29    1.50
innodb  order_by_big_key_desc                15.00       -9.60%      -1.31    
11.00   32.00   13.69    1.69
innodb  order_by_big_key_diff                13.00       -5.51%      -0.68    
10.00   31.00   12.32    1.46
innodb  order_by_big_key_prefix              14.00      -12.14%      -1.52    
10.00   32.00   12.48    1.50
innodb  order_by_key2_diff                    2.00      -42.65%      -0.60     
1.00    3.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -24.53%      -0.20     
0.00    2.00    0.80    0.40
innodb  order_by_range                        0.00     +100.00%       0.84     
0.00    2.00    0.84    0.37
innodb  outer_join                           19.00       +3.44%       0.68    
15.00   61.00   19.68    3.70
innodb  outer_join_found                     18.00       +5.52%       1.05    
14.00   58.00   19.05    3.54
innodb  outer_join_not_found                 17.00       -1.21%      -0.20    
12.00   46.00   16.80    3.20
innodb  outer_join_on_key                    12.00       +8.33%       1.09    
10.00   59.00   13.09    2.71
innodb  prepared_select                      37.00      -15.54%      -4.98    
22.00   40.00   32.02    4.61
innodb  select_1_row                          4.00      -36.00%      -1.06     
2.00    4.00    2.94    0.71
innodb  select_1_row_cache                    4.00      -43.88%      -1.22     
2.00    4.00    2.78    0.72
innodb  select_2_rows                         3.00       -0.89%      -0.03     
2.00    4.00    2.97    0.72
innodb  select_big                           12.00       +1.84%       0.23     
0.00   31.00   12.23    1.50
innodb  select_big_str                        2.00      -68.22%      -0.81     
0.00    2.00    1.19    0.39
innodb  select_cache                         59.00       +2.04%       1.23    
49.00   78.00   60.23    5.65
innodb  select_cache2                        61.00       -0.57%      -0.34    
49.00   84.00   60.66    6.31
innodb  select_column+column                  4.00      -31.95%      -0.97     
2.00    4.00    3.03    0.74
innodb  select_diff_key                       0.00     +100.00%       0.22     
0.00    1.00    0.22    0.42
innodb  select_distinct                       5.00      -16.78%      -0.72     
3.00    8.00    4.28    0.55
innodb  select_group                         16.00       +2.09%       0.34     
4.00  136.00   16.34    5.11
innodb  select_group_when_MANY_tables        12.00      -22.79%      -2.23     
3.00   49.00    9.77    8.88
innodb  select_join                           0.00     +100.00%       0.59     
0.00    1.00    0.59    0.49
innodb  select_key                           64.00      -18.21%      -9.86    
40.00   66.00   54.14    7.88
innodb  select_key2                          71.00      -16.68%     -10.15    
45.00   75.00   60.85    8.61
innodb  select_key2_return_key               69.00      -18.56%     -10.80    
42.00   71.00   58.20    8.46
innodb  select_key2_return_prim              69.00      -17.03%     -10.04    
42.00   72.00   58.96    8.58
innodb  select_key_prefix                    71.00      -18.04%     -10.85    
44.00   75.00   60.15    8.68
innodb  select_key_prefix_join                6.00      -25.44%      -1.22     
3.00   10.00    4.78    0.65
innodb  select_key_return_key                63.00      -18.52%      -9.85    
38.00   65.00   53.15    7.87
innodb  select_many_fields                   13.00      +11.76%       1.73    
11.00   19.00   14.73    1.78
innodb  select_range                         40.00      +14.28%       6.67    
38.00   76.00   46.67    4.05
innodb  select_range_key2                    10.00      -18.76%      -1.58     
6.00   11.00    8.42    1.08
innodb  select_range_prefix                   9.00      -12.31%      -0.99     
5.00   10.00    8.01    1.16
innodb  select_simple                         2.00      -17.71%      -0.30     
1.00    3.00    1.70    0.50
innodb  select_simple_cache                   2.00      -23.92%      -0.39     
1.00    3.00    1.61    0.51
innodb  select_simple_join                    1.00      -49.32%      -0.33     
0.00    3.00    0.67    0.48
innodb  update_autocommit                     3.00      +10.50%       0.35     
2.00   16.00    3.35    0.97
innodb  update_big                           58.00      -11.64%      -6.05    
31.00  195.00   51.95   23.02
innodb  update_commit                         2.00      -24.10%      -0.39     
1.00   10.00    1.61    0.70
innodb  update_of_key                        21.00      +12.41%       2.97    
18.00  100.00   23.97    5.82
innodb  update_of_key_big                    20.00      +27.13%       7.44    
15.00   75.00   27.44   10.73
innodb  update_of_primary_key_many_keys    1276.00       -2.03%     -25.44   
647.00 6065.00 1250.56  881.46
innodb  update_rollback                       2.00      -11.22%      -0.20     
1.00   31.00    1.80    1.78
innodb  update_with_key                     118.00       -6.18%      -6.86    
90.00  598.00  111.14   19.75
innodb  update_with_key_prefix               41.00       -2.20%      -0.88    
33.00  202.00   40.12    6.54
innodb  wisc_benchmark                        2.00      +19.54%       0.49     
2.00    5.00    2.49    0.52

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

  2466.1.2: Stewart Smith 2011-12-05 add a bit more information on some I_S 
tables in docs
  2466.1.1: Stewart Smith 2011-12-05 Add a list of all INFORMATION_SCEMA tables 
to documentation, along with SHOW CREATE TABLE output for them.

_______________________________________________
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