=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE:   innodb
MACHINE:  orisndriz05
RUN ID:   214
RUN DATE: 2010-03-21T23:57:05.986255
SERVER:   drizzled
VERSION:  staging
REVISION: 1377
COMMENT:  1377: Brian Aker 2010-03-21 [merge] Merge DED

=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine  Test                                 Time   % Diff from Avg   Diff      
 Norm?       Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      13.00       +1.52%       0.20   
within norms   13.00   14.00   13.20    0.40
innodb  alter_table_drop                     14.00       -1.45%      -0.20   
within norms   13.00   14.00   13.80    0.40
innodb  connect                               2.00       -0.00%       0.00   
within norms    2.00    2.00    2.00    0.00
innodb  connect+select_1_row                  2.00      +23.08%       0.60  
outside norms    2.00    3.00    2.60    0.49
innodb  connect+select_simple                 2.00       +9.09%       0.20   
within norms    2.00    3.00    2.20    0.40
innodb  count                                17.00       -4.94%      -0.80   
within norms   13.00   17.00   16.20    1.60
innodb  count_distinct                        6.00       -7.14%      -0.40   
within norms    5.00    6.00    5.60    0.49
innodb  count_distinct_2                     12.00       -3.45%      -0.40   
within norms   11.00   12.00   11.60    0.49
innodb  count_distinct_big                   24.00       -1.69%      -0.40   
within norms   20.00   26.00   23.60    2.06
innodb  count_distinct_group                 10.00      +19.35%       2.40   
within norms   10.00   20.00   12.40    3.83
innodb  count_distinct_group_on_key           8.00       -0.00%       0.00   
within norms    8.00    8.00    8.00    0.00
innodb  count_distinct_group_on_key_parts    10.00      +12.28%       1.40   
within norms    9.00   18.00   11.40    3.32
innodb  count_distinct_key_prefix             4.00       +9.09%       0.40   
within norms    4.00    5.00    4.40    0.49
innodb  count_group_on_key_parts             10.00       -6.38%      -0.60   
within norms    8.00   10.00    9.40    0.80
innodb  count_on_key                         84.00       -1.94%      -1.60   
within norms   75.00   85.00   82.40    3.72
innodb  create+drop                          21.00      +14.63%       3.60  
outside norms   21.00   27.00   24.60    2.24
innodb  create_index                          2.00       +9.09%       0.20   
within norms    2.00    3.00    2.20    0.40
innodb  create_key+drop                      23.00       +3.36%       0.80  
outside norms   23.00   24.00   23.80    0.40
innodb  create_MANY_tables                   19.00      +34.03%       9.80  
outside norms   19.00   40.00   28.80    6.94
innodb  create_table                          0.00         NULL       0.00   
within norms    0.00    0.00    0.00    0.00
innodb  delete_all_many_keys                306.00       -0.26%      -0.80   
within norms  286.00  319.00  305.20   12.25
innodb  delete_autocommit                     3.00       -0.00%       0.00   
within norms    3.00    3.00    3.00    0.00
innodb  delete_big                            0.00     +100.00%       0.40   
within norms    0.00    1.00    0.40    0.49
innodb  delete_big_many_keys                306.00       -0.26%      -0.80   
within norms  286.00  319.00  305.20   12.25
innodb  delete_commit                         1.00      +37.50%       0.60  
outside norms    1.00    2.00    1.60    0.49
innodb  delete_key                            2.00      +23.08%       0.60  
outside norms    2.00    3.00    2.60    0.49
innodb  delete_range                          7.00       +7.89%       0.60   
within norms    6.00   10.00    7.60    1.36
innodb  delete_rollback                       2.00      -25.00%      -0.40   
within norms    1.00    2.00    1.60    0.49
innodb  drop_index                            2.00       +9.09%       0.20   
within norms    2.00    3.00    2.20    0.40
innodb  drop_table                            0.00         NULL       0.00   
within norms    0.00    0.00    0.00    0.00
innodb  drop_table_when_MANY_tables          16.00      +13.98%       2.60   
within norms   16.00   24.00   18.60    2.94
innodb  insert                               95.00       +0.42%       0.40   
within norms   93.00   97.00   95.40    1.50
innodb  insert_autocommit                     3.00      -15.38%      -0.40   
within norms    2.00    3.00    2.60    0.49
innodb  insert_commit                         1.00      +16.67%       0.20   
within norms    1.00    2.00    1.20    0.40
innodb  insert_duplicates                    13.00       -0.00%       0.00   
within norms   12.00   15.00   13.00    1.10
innodb  insert_key                          274.00      +31.60%     126.60  
outside norms  274.00  521.00  400.60   88.43
innodb  insert_many_fields                    4.00       +4.76%       0.20   
within norms    4.00    5.00    4.20    0.40
innodb  insert_rollback                       1.00      +28.57%       0.40   
within norms    1.00    2.00    1.40    0.49
innodb  insert_select_1_key                   4.00       +4.76%       0.20   
within norms    3.00    5.00    4.20    0.75
innodb  insert_select_2_keys                  4.00      +23.08%       1.20   
within norms    4.00    8.00    5.20    1.47
innodb  min_max                               8.00       -0.00%       0.00   
within norms    7.00    9.00    8.00    0.63
innodb  min_max_on_key                       18.00       +3.23%       0.60   
within norms   17.00   22.00   18.60    1.74
innodb  multiple_value_insert                 5.00       +3.85%       0.20   
within norms    5.00    6.00    5.20    0.40
innodb  once_prepared_select                 21.00       +1.87%       0.40   
within norms   19.00   25.00   21.40    2.06
innodb  order_by_big                         14.00       -1.45%      -0.20   
within norms   13.00   15.00   13.80    0.75
innodb  order_by_big_key                     12.00       +1.64%       0.20   
within norms   12.00   13.00   12.20    0.40
innodb  order_by_big_key2                    11.00       +5.17%       0.60  
outside norms   11.00   12.00   11.60    0.49
innodb  order_by_big_key_desc                11.00       +8.33%       1.00  
outside norms   11.00   13.00   12.00    0.63
innodb  order_by_big_key_diff                11.00       +3.51%       0.40   
within norms   11.00   12.00   11.40    0.49
innodb  order_by_big_key_prefix              11.00       +1.79%       0.20   
within norms   10.00   12.00   11.20    0.75
innodb  order_by_key2_diff                    1.00      +16.67%       0.20   
within norms    1.00    2.00    1.20    0.40
innodb  order_by_key_prefix                   1.00      -25.00%      -0.20   
within norms    0.00    1.00    0.80    0.40
innodb  order_by_range                        0.00     +100.00%       0.80  
outside norms    0.00    1.00    0.80    0.40
innodb  outer_join                           15.00      +14.77%       2.60  
outside norms   15.00   21.00   17.60    2.15
innodb  outer_join_found                     15.00      +12.79%       2.20   
within norms   15.00   20.00   17.20    2.32
innodb  outer_join_not_found                 13.00      +10.96%       1.60   
within norms   13.00   18.00   14.60    2.06
innodb  outer_join_on_key                    12.00       +4.76%       0.60   
within norms   11.00   14.00   12.60    1.02
innodb  prepared_select                      31.00       -8.39%      -2.40  
outside norms   26.00   31.00   28.60    2.06
innodb  select_1_row                          2.00       +9.09%       0.20   
within norms    2.00    3.00    2.20    0.40
innodb  select_1_row_cache                    3.00      -25.00%      -0.60  
outside norms    2.00    3.00    2.40    0.49
innodb  select_2_rows                         2.00       +9.09%       0.20   
within norms    2.00    3.00    2.20    0.40
innodb  select_big                           12.00       -3.45%      -0.40   
within norms   11.00   12.00   11.60    0.49
innodb  select_big_str                        1.00       -0.00%       0.00   
within norms    1.00    1.00    1.00    0.00
innodb  select_cache                         66.00      -10.37%      -6.20  
outside norms   53.00   66.00   59.80    5.31
innodb  select_cache2                        66.00       -8.91%      -5.40   
within norms   52.00   66.00   60.60    6.62
innodb  select_column+column                  4.00      -42.86%      -1.20  
outside norms    2.00    4.00    2.80    0.75
innodb  select_diff_key                       1.00     -400.00%      -0.80  
outside norms    0.00    1.00    0.20    0.40
innodb  select_distinct                       4.00       +4.76%       0.20   
within norms    4.00    5.00    4.20    0.40
innodb  select_group                         16.00       +1.23%       0.20   
within norms   15.00   17.00   16.20    0.75
innodb  select_group_when_MANY_tables         4.00      +20.00%       1.00  
outside norms    4.00    6.00    5.00    0.63
innodb  select_join                           1.00     -150.00%      -0.60  
outside norms    0.00    1.00    0.40    0.49
innodb  select_key                           48.00       -2.13%      -1.00  
outside norms   46.00   48.00   47.00    0.63
innodb  select_key2                          52.00       -0.39%      -0.20   
within norms   51.00   52.00   51.80    0.40
innodb  select_key2_return_key               49.00       +3.54%       1.80   
within norms   49.00   58.00   50.80    3.60
innodb  select_key2_return_prim              51.00       +0.78%       0.40   
within norms   50.00   55.00   51.40    1.85
innodb  select_key_prefix                    51.00       +0.39%       0.20   
within norms   51.00   52.00   51.20    0.40
innodb  select_key_prefix_join                4.00      +13.04%       0.60  
outside norms    4.00    5.00    4.60    0.49
innodb  select_key_return_key                46.00       +0.43%       0.20   
within norms   46.00   47.00   46.20    0.40
innodb  select_many_fields                   15.00       +7.41%       1.20  
outside norms   15.00   17.00   16.20    0.98
innodb  select_range                         55.00      -13.17%      -6.40  
outside norms   46.00   55.00   48.60    3.38
innodb  select_range_key2                     8.00       -5.26%      -0.40   
within norms    7.00    8.00    7.60    0.49
innodb  select_range_prefix                   6.00      +14.29%       1.00  
outside norms    6.00    8.00    7.00    0.63
innodb  select_simple                         2.00      -11.11%      -0.20   
within norms    1.00    2.00    1.80    0.40
innodb  select_simple_cache                   1.00       -0.00%       0.00   
within norms    1.00    1.00    1.00    0.00
innodb  select_simple_join                    0.00     +100.00%       0.60  
outside norms    0.00    1.00    0.60    0.49
innodb  update_autocommit                     3.00       -0.00%       0.00   
within norms    3.00    3.00    3.00    0.00
innodb  update_big                           37.00       +2.63%       1.00   
within norms   37.00   40.00   38.00    1.26
innodb  update_commit                         1.00       -0.00%       0.00   
within norms    1.00    1.00    1.00    0.00
innodb  update_of_key                        20.00      +15.97%       3.80  
outside norms   20.00   28.00   23.80    3.25
innodb  update_of_key_big                    18.00      +12.62%       2.60  
outside norms   18.00   24.00   20.60    2.06
innodb  update_of_primary_key_many_keys     805.00       +0.20%       1.60   
within norms  776.00  834.00  806.60   22.01
innodb  update_rollback                       1.00       -0.00%       0.00   
within norms    1.00    1.00    1.00    0.00
innodb  update_with_key                     100.00       +1.57%       1.60   
within norms  100.00  106.00  101.60    2.24
innodb  update_with_key_prefix               36.00       +3.74%       1.40  
outside norms   36.00   39.00   37.40    1.02
innodb  wisc_benchmark                        3.00      -36.36%      -0.80  
outside norms    2.00    3.00    2.20    0.40

=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine  Test                                 Time   % Diff from Avg   Diff      
 Norm?       Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      13.00       +0.76%       0.10   
within norms   12.00   14.00   13.10    0.62
innodb  alter_table_drop                     14.00       -2.19%      -0.30   
within norms   12.00   14.00   13.70    0.56
innodb  connect                               2.00       -0.00%       0.00   
within norms    2.00    2.00    2.00    0.00
innodb  connect+select_1_row                  2.00      +23.08%       0.60  
outside norms    2.00    3.00    2.60    0.49
innodb  connect+select_simple                 2.00      +20.00%       0.50   
within norms    2.00    3.00    2.50    0.50
innodb  count                                17.00      -11.11%      -1.70   
within norms   13.00   17.00   15.30    1.90
innodb  count_distinct                        6.00       +4.00%       0.25   
within norms    5.00    8.00    6.25    0.83
innodb  count_distinct_2                     12.00       +4.38%       0.55   
within norms   11.00   15.00   12.55    1.66
innodb  count_distinct_big                   24.00       -9.09%      -2.00   
within norms   19.00   26.00   22.00    2.19
innodb  count_distinct_group                 10.00      +16.32%       1.95   
within norms   10.00   20.00   11.95    2.31
innodb  count_distinct_group_on_key           8.00       +8.57%       0.75   
within norms    8.00   10.00    8.75    0.94
innodb  count_distinct_group_on_key_parts    10.00      +13.04%       1.50   
within norms    9.00   18.00   11.50    2.09
innodb  count_distinct_key_prefix             4.00      +16.67%       0.80   
within norms    4.00    6.00    4.80    0.81
innodb  count_group_on_key_parts             10.00       -6.38%      -0.60   
within norms    7.00   11.00    9.40    1.02
innodb  count_on_key                         84.00       -3.96%      -3.20   
within norms   68.00   88.00   80.80    6.53
innodb  create+drop                          21.00      +10.64%       2.50  
outside norms   20.00   27.00   23.50    1.96
innodb  create_index                          2.00      +13.04%       0.30   
within norms    2.00    4.00    2.30    0.56
innodb  create_key+drop                      23.00       +4.17%       1.00  
outside norms   23.00   26.00   24.00    0.63
innodb  create_MANY_tables                   19.00      +35.48%      10.45  
outside norms   19.00   44.00   29.45    6.65
innodb  create_table                          0.00     +100.00%       0.10   
within norms    0.00    1.00    0.10    0.30
innodb  delete_all_many_keys                306.00       -4.85%     -14.15   
within norms  266.00  321.00  291.85   17.11
innodb  delete_autocommit                     3.00       +7.69%       0.25   
within norms    3.00    4.00    3.25    0.43
innodb  delete_big                            0.00     +100.00%       0.35   
within norms    0.00    1.00    0.35    0.48
innodb  delete_big_many_keys                306.00       -4.85%     -14.15   
within norms  266.00  321.00  291.85   17.11
innodb  delete_commit                         1.00      +28.57%       0.40   
within norms    1.00    2.00    1.40    0.49
innodb  delete_key                            2.00      +20.00%       0.50   
within norms    2.00    3.00    2.50    0.50
innodb  delete_range                          7.00       +9.09%       0.70   
within norms    6.00   11.00    7.70    1.35
innodb  delete_rollback                       2.00      -42.86%      -0.60  
outside norms    1.00    2.00    1.40    0.49
innodb  drop_index                            2.00       +9.09%       0.20   
within norms    2.00    3.00    2.20    0.40
innodb  drop_table                            0.00     +100.00%       0.10   
within norms    0.00    1.00    0.10    0.30
innodb  drop_table_when_MANY_tables          16.00      +17.53%       3.40  
outside norms   16.00   25.00   19.40    2.27
innodb  insert                               95.00       +0.99%       0.95   
within norms   92.00  102.00   95.95    3.50
innodb  insert_autocommit                     3.00      -17.65%      -0.45   
within norms    2.00    3.00    2.55    0.50
innodb  insert_commit                         1.00      +13.04%       0.15   
within norms    1.00    2.00    1.15    0.36
innodb  insert_duplicates                    13.00       -0.78%      -0.10   
within norms   12.00   15.00   12.90    0.94
innodb  insert_key                          274.00      +28.86%     111.15  
outside norms  274.00  553.00  385.15   78.73
innodb  insert_many_fields                    4.00       +5.88%       0.25   
within norms    4.00    6.00    4.25    0.62
innodb  insert_rollback                       1.00      +31.03%       0.45   
within norms    1.00    2.00    1.45    0.50
innodb  insert_select_1_key                   4.00       -8.11%      -0.30   
within norms    3.00    5.00    3.70    0.71
innodb  insert_select_2_keys                  4.00      +27.27%       1.50  
outside norms    4.00    8.00    5.50    1.12
innodb  min_max                               8.00       -8.11%      -0.60   
within norms    6.00    9.00    7.40    0.92
innodb  min_max_on_key                       18.00       +5.26%       1.00   
within norms   16.00   22.00   19.00    1.70
innodb  multiple_value_insert                 5.00       -0.00%       0.00   
within norms    4.00    6.00    5.00    0.55
innodb  once_prepared_select                 21.00       +0.47%       0.10   
within norms   18.00   25.00   21.10    1.97
innodb  order_by_big                         14.00       -1.45%      -0.20   
within norms   13.00   16.00   13.80    0.93
innodb  order_by_big_key                     12.00       +5.51%       0.70   
within norms   12.00   15.00   12.70    0.90
innodb  order_by_big_key2                    11.00       +5.17%       0.60   
within norms   11.00   14.00   11.60    0.80
innodb  order_by_big_key_desc                11.00       +8.33%       1.00  
outside norms   11.00   14.00   12.00    0.71
innodb  order_by_big_key_diff                11.00       +4.76%       0.55   
within norms   10.00   15.00   11.55    1.16
innodb  order_by_big_key_prefix              11.00       +3.08%       0.35   
within norms   10.00   15.00   11.35    1.11
innodb  order_by_key2_diff                    1.00      +28.57%       0.40   
within norms    1.00    2.00    1.40    0.49
innodb  order_by_key_prefix                   1.00      -42.86%      -0.30   
within norms    0.00    1.00    0.70    0.46
innodb  order_by_range                        0.00     +100.00%       0.85  
outside norms    0.00    1.00    0.85    0.36
innodb  outer_join                           15.00      +13.54%       2.35  
outside norms   15.00   21.00   17.35    1.65
innodb  outer_join_found                     15.00       +9.37%       1.55   
within norms   15.00   20.00   16.55    1.83
innodb  outer_join_not_found                 13.00       +9.72%       1.40   
within norms   13.00   18.00   14.40    1.62
innodb  outer_join_on_key                    12.00       -0.84%      -0.10   
within norms   10.00   14.00   11.90    1.14
innodb  prepared_select                      31.00       -9.54%      -2.70  
outside norms   25.00   31.00   28.30    1.82
innodb  select_1_row                          2.00      +11.11%       0.25   
within norms    2.00    3.00    2.25    0.43
innodb  select_1_row_cache                    3.00      -36.36%      -0.80  
outside norms    2.00    3.00    2.20    0.40
innodb  select_2_rows                         2.00      +14.89%       0.35   
within norms    2.00    3.00    2.35    0.48
innodb  select_big                           12.00       -2.13%      -0.25   
within norms   11.00   14.00   11.75    0.83
innodb  select_big_str                        1.00      +13.04%       0.15   
within norms    1.00    2.00    1.15    0.36
innodb  select_cache                         66.00      -12.63%      -7.40  
outside norms   51.00   66.00   58.60    6.22
innodb  select_cache2                        66.00      -10.55%      -6.30   
within norms   51.00   66.00   59.70    6.88
innodb  select_column+column                  4.00      -63.27%      -1.55  
outside norms    2.00    4.00    2.45    0.59
innodb  select_diff_key                       1.00     -400.00%      -0.80  
outside norms    0.00    1.00    0.20    0.40
innodb  select_distinct                       4.00       +4.76%       0.20   
within norms    4.00    5.00    4.20    0.40
innodb  select_group                         16.00       -0.95%      -0.15   
within norms   13.00   18.00   15.85    1.35
innodb  select_group_when_MANY_tables         4.00      +14.89%       0.70  
outside norms    4.00    6.00    4.70    0.64
innodb  select_join                           1.00     -185.71%      -0.65  
outside norms    0.00    1.00    0.35    0.48
innodb  select_key                           48.00       -2.45%      -1.15  
outside norms   45.00   48.00   46.85    0.57
innodb  select_key2                          52.00       +0.10%       0.05   
within norms   51.00   57.00   52.05    1.28
innodb  select_key2_return_key               49.00       +1.61%       0.80   
within norms   49.00   58.00   49.80    1.94
innodb  select_key2_return_prim              51.00       -0.89%      -0.45   
within norms   49.00   55.00   50.55    1.16
innodb  select_key_prefix                    51.00       +0.58%       0.30   
within norms   51.00   52.00   51.30    0.46
innodb  select_key_prefix_join                4.00      +12.09%       0.55   
within norms    4.00    6.00    4.55    0.59
innodb  select_key_return_key                46.00       +0.76%       0.35   
within norms   44.00   53.00   46.35    1.62
innodb  select_many_fields                   15.00       +5.06%       0.80   
within norms   13.00   17.00   15.80    1.40
innodb  select_range                         55.00      -11.90%      -5.85  
outside norms   45.00   55.00   49.15    3.41
innodb  select_range_key2                     8.00       -8.11%      -0.60  
outside norms    7.00    8.00    7.40    0.49
innodb  select_range_prefix                   6.00      +14.89%       1.05  
outside norms    6.00    8.00    7.05    0.50
innodb  select_simple                         2.00      -33.33%      -0.50   
within norms    1.00    2.00    1.50    0.50
innodb  select_simple_cache                   1.00      +23.08%       0.30   
within norms    1.00    2.00    1.30    0.46
innodb  select_simple_join                    0.00     +100.00%       0.75  
outside norms    0.00    1.00    0.75    0.43
innodb  update_autocommit                     3.00       -0.00%       0.00   
within norms    3.00    3.00    3.00    0.00
innodb  update_big                           37.00       +1.60%       0.60   
within norms   35.00   40.00   37.60    1.32
innodb  update_commit                         1.00      +16.67%       0.20   
within norms    1.00    2.00    1.20    0.40
innodb  update_of_key                        20.00      +12.09%       2.75   
within norms   20.00   31.00   22.75    3.19
innodb  update_of_key_big                    18.00      +11.11%       2.25   
within norms   17.00   26.00   20.25    2.32
innodb  update_of_primary_key_many_keys     805.00       -4.38%     -33.80   
within norms  707.00  852.00  771.20   44.04
innodb  update_rollback                       1.00      +20.00%       0.25   
within norms    1.00    2.00    1.25    0.43
innodb  update_with_key                     100.00       +1.48%       1.50   
within norms   96.00  106.00  101.50    2.64
innodb  update_with_key_prefix               36.00       +1.91%       0.70   
within norms   34.00   39.00   36.70    1.23
innodb  wisc_benchmark                        3.00      -30.43%      -0.70  
outside norms    2.00    3.00    2.30    0.46

=========================================================================================================================
TRENDING OVER ALL runs
Engine  Test                                 Time   % Diff from Avg   Diff      
 Norm?       Min     Max     Avg     STD    
=========================================================================================================================
innodb  alter_table_add                      13.00       -6.80%      -0.83   
within norms   11.00   14.00   12.17    0.87
innodb  alter_table_drop                     14.00      -22.66%      -2.59  
outside norms   10.00   14.00   11.41    1.07
innodb  connect                               2.00      -18.37%      -0.31   
within norms    1.00    2.00    1.69    0.46
innodb  connect+select_1_row                  2.00      +14.71%       0.34   
within norms    2.00    3.00    2.34    0.48
innodb  connect+select_simple                 2.00       -1.75%      -0.03   
within norms    1.00    2.00    1.97    0.18
innodb  count                                17.00      -13.33%      -2.00  
outside norms   13.00   18.00   15.00    1.76
innodb  count_distinct                        6.00       +1.14%       0.07   
within norms    5.00    8.00    6.07    0.83
innodb  count_distinct_2                     12.00       +1.14%       0.14   
within norms   11.00   16.00   12.14    1.38
innodb  count_distinct_big                   24.00      -12.44%      -2.66  
outside norms   18.00   25.00   21.34    1.97
innodb  count_distinct_group                 10.00      +20.98%       2.66  
outside norms   11.00   14.00   12.66    0.84
innodb  count_distinct_group_on_key           8.00      +10.08%       0.90   
within norms    8.00   11.00    8.90    1.12
innodb  count_distinct_group_on_key_parts    10.00      +14.96%       1.76  
outside norms   10.00   15.00   11.76    1.36
innodb  count_distinct_key_prefix             4.00      +15.33%       0.72  
outside norms    4.00    6.00    4.72    0.69
innodb  count_group_on_key_parts             10.00      -22.88%      -1.86  
outside norms    7.00   10.00    8.14    0.78
innodb  count_on_key                         84.00       -8.75%      -6.76  
outside norms   73.00   83.00   77.24    2.25
innodb  create+drop                          21.00       -7.60%      -1.48  
outside norms   19.00   21.00   19.52    0.56
innodb  create_index                          2.00       -5.45%      -0.10   
within norms    1.00    3.00    1.90    0.48
innodb  create_key+drop                      23.00       -1.99%      -0.45   
within norms   21.00   23.00   22.55    0.56
innodb  create_MANY_tables                   19.00      -11.31%      -1.93  
outside norms   14.00   20.00   17.07    1.70
innodb  create_table                          0.00     +100.00%       0.07   
within norms    0.00    1.00    0.07    0.25
innodb  delete_all_many_keys                306.00       -2.95%      -8.76   
within norms  239.00  345.00  297.24   21.38
innodb  delete_autocommit                     3.00       -6.10%      -0.17   
within norms    2.00    3.00    2.83    0.38
innodb  delete_big                            0.00     +100.00%       0.28   
within norms    0.00    1.00    0.28    0.45
innodb  delete_big_many_keys                306.00       -2.98%      -8.86   
within norms  239.00  345.00  297.14   21.37
innodb  delete_commit                         1.00      +25.64%       0.34   
within norms    1.00    2.00    1.34    0.48
innodb  delete_key                            2.00      +18.31%       0.45   
within norms    2.00    3.00    2.45    0.50
innodb  delete_range                          7.00       -0.50%      -0.03   
within norms    6.00    8.00    6.97    0.56
innodb  delete_rollback                       2.00      -52.63%      -0.69  
outside norms    1.00    2.00    1.31    0.46
innodb  drop_index                            2.00       -1.75%      -0.03   
within norms    1.00    3.00    1.97    0.32
innodb  drop_table                            0.00         NULL       0.00   
within norms    0.00    0.00    0.00    0.00
innodb  drop_table_when_MANY_tables          16.00      -18.67%      -2.52  
outside norms   12.00   15.00   13.48    0.62
innodb  insert                               95.00       -4.75%      -4.31  
outside norms   88.00   93.00   90.69    1.37
innodb  insert_autocommit                     3.00      -16.00%      -0.41   
within norms    2.00    3.00    2.59    0.49
innodb  insert_commit                         1.00       +9.37%       0.10   
within norms    1.00    2.00    1.10    0.30
innodb  insert_duplicates                    13.00       -1.34%      -0.17   
within norms   12.00   14.00   12.83    0.53
innodb  insert_key                          274.00       +4.74%      13.62   
within norms  189.00  345.00  287.62   32.94
innodb  insert_many_fields                    4.00       +1.69%       0.07   
within norms    3.00    5.00    4.07    0.36
innodb  insert_rollback                       1.00      +29.27%       0.41   
within norms    1.00    2.00    1.41    0.49
innodb  insert_select_1_key                   4.00      -17.17%      -0.59  
outside norms    3.00    4.00    3.41    0.49
innodb  insert_select_2_keys                  4.00      +22.67%       1.17  
outside norms    4.00    6.00    5.17    0.59
innodb  min_max                               8.00       -4.50%      -0.34   
within norms    6.00    9.00    7.66    1.03
innodb  min_max_on_key                       18.00       -6.75%      -1.14   
within norms   14.00   20.00   16.86    1.28
innodb  multiple_value_insert                 5.00      -10.69%      -0.48   
within norms    3.00    5.00    4.52    0.56
innodb  once_prepared_select                 21.00       -0.16%      -0.03   
within norms   20.00   22.00   20.97    0.61
innodb  order_by_big                         14.00       +0.98%       0.14   
within norms   12.00   15.00   14.14    0.94
innodb  order_by_big_key                     12.00       +3.33%       0.41   
within norms   11.00   14.00   12.41    1.19
innodb  order_by_big_key2                    11.00       +4.20%       0.48   
within norms   10.00   13.00   11.48    0.97
innodb  order_by_big_key_desc                11.00      +14.71%       1.90  
outside norms   12.00   14.00   12.90    0.92
innodb  order_by_big_key_diff                11.00       +5.06%       0.59   
within norms   10.00   13.00   11.59    0.85
innodb  order_by_big_key_prefix              11.00       +8.07%       0.97  
outside norms   11.00   13.00   11.97    0.85
innodb  order_by_key2_diff                    1.00      +14.71%       0.17   
within norms    1.00    2.00    1.17    0.38
innodb  order_by_key_prefix                   1.00      -61.11%      -0.38   
within norms    0.00    1.00    0.62    0.49
innodb  order_by_range                        0.00     +100.00%       0.72  
outside norms    0.00    1.00    0.72    0.45
innodb  outer_join                           15.00      +13.52%       2.34  
outside norms   15.00   21.00   17.34    2.06
innodb  outer_join_found                     15.00      +11.04%       1.86   
within norms   14.00   21.00   16.86    2.19
innodb  outer_join_not_found                 13.00      +13.33%       2.00  
outside norms   13.00   18.00   15.00    1.49
innodb  outer_join_on_key                    12.00       -0.29%      -0.03   
within norms   10.00   15.00   11.97    1.50
innodb  prepared_select                      31.00      -19.87%      -5.14  
outside norms   22.00   29.00   25.86    2.10
innodb  select_1_row                          2.00      +18.31%       0.45   
within norms    2.00    3.00    2.45    0.50
innodb  select_1_row_cache                    3.00      -45.00%      -0.93  
outside norms    2.00    3.00    2.07    0.25
innodb  select_2_rows                         2.00       +9.38%       0.21   
within norms    2.00    3.00    2.21    0.41
innodb  select_big                           12.00       -3.26%      -0.38   
within norms   10.00   13.00   11.62    1.00
innodb  select_big_str                        1.00       +7.82%       0.08   
within norms    1.00    2.00    1.08    0.28
innodb  select_cache                         66.00      -14.61%      -8.41  
outside norms   51.00   71.00   57.59    5.41
innodb  select_cache2                        66.00      -16.07%      -9.14  
outside norms   51.00   68.00   56.86    4.88
innodb  select_column+column                  4.00      -50.65%      -1.34  
outside norms    2.00    3.00    2.66    0.48
innodb  select_diff_key                       1.00     -480.00%      -0.83  
outside norms    0.00    1.00    0.17    0.38
innodb  select_distinct                       4.00       -1.75%      -0.07   
within norms    3.00    5.00    3.93    0.36
innodb  select_group                         16.00       -5.22%      -0.79   
within norms   13.00   18.00   15.21    1.47
innodb  select_group_when_MANY_tables         4.00       -0.00%       0.00   
within norms    3.00    5.00    4.00    0.37
innodb  select_join                           1.00     -107.14%      -0.52  
outside norms    0.00    1.00    0.48    0.50
innodb  select_key                           48.00       -7.82%      -3.48  
outside norms   40.00   50.00   44.52    2.50
innodb  select_key2                          52.00       -5.53%      -2.72  
outside norms   46.00   54.00   49.28    2.41
innodb  select_key2_return_key               49.00       -4.41%      -2.07   
within norms   42.00   51.00   46.93    2.32
innodb  select_key2_return_prim              51.00       -5.34%      -2.59   
within norms   43.00   55.00   48.41    2.92
innodb  select_key_prefix                    51.00       -0.41%      -0.21   
within norms   45.00   57.00   50.79    3.46
innodb  select_key_prefix_join                4.00       +4.13%       0.17   
within norms    4.00    5.00    4.17    0.38
innodb  select_key_return_key                46.00       -5.54%      -2.41   
within norms   39.00   49.00   43.59    2.65
innodb  select_many_fields                   15.00       +8.81%       1.45  
outside norms   15.00   17.00   16.45    0.62
innodb  select_range                         55.00      -12.56%      -6.14  
outside norms   47.00   57.00   48.86    1.66
innodb  select_range_key2                     8.00      -10.48%      -0.76  
outside norms    6.00    8.00    7.24    0.57
innodb  select_range_prefix                   6.00      +14.29%       1.00  
outside norms    6.00    8.00    7.00    0.64
innodb  select_simple                         2.00      -38.10%      -0.55  
outside norms    1.00    2.00    1.45    0.50
innodb  select_simple_cache                   1.00      +12.12%       0.14   
within norms    1.00    2.00    1.14    0.34
innodb  select_simple_join                    0.00     +100.00%       0.72  
outside norms    0.00    1.00    0.72    0.45
innodb  update_autocommit                     3.00       -7.41%      -0.21   
within norms    2.00    3.00    2.79    0.41
innodb  update_big                           37.00       -2.68%      -0.97   
within norms   31.00   40.00   36.03    2.48
innodb  update_commit                         1.00      +25.64%       0.34   
within norms    1.00    2.00    1.34    0.48
innodb  update_of_key                        20.00       -3.76%      -0.72  
outside norms   19.00   20.00   19.28    0.45
innodb  update_of_key_big                    18.00       +1.69%       0.31   
within norms   16.00   20.00   18.31    1.18
innodb  update_of_primary_key_many_keys     805.00       +1.48%      12.07   
within norms  661.00  947.00  817.07   54.24
innodb  update_rollback                       1.00      +29.27%       0.41   
within norms    1.00    2.00    1.41    0.49
innodb  update_with_key                     100.00       -8.98%      -8.24  
outside norms   90.00   93.00   91.76    0.97
innodb  update_with_key_prefix               36.00       -2.15%      -0.76  
outside norms   34.00   36.00   35.24    0.57
innodb  wisc_benchmark                        3.00      -27.94%      -0.66  
outside norms    2.00    3.00    2.34    0.48

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

  1336.3.3: Djellel E. Difallah 2010-03-19 add file ./drizzled/optimizer/cos...
  1336.3.2: Djellel E. Difallah 2010-03-19 rename class COST_VECT to CostVec...
  1336.3.1: Djellel E. Difallah 2010-03-16 Cleanup & Encapsulate the COST_VE...

_______________________________________________
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