diff options
| author | Xavier Noria <fxn@hashref.com> | 2011-12-02 04:32:18 -0800 |
|---|---|---|
| committer | Xavier Noria <fxn@hashref.com> | 2011-12-02 04:35:43 -0800 |
| commit | 0306f82e0c3cda3aad1b45eb0c3a359c254b62cc (patch) | |
| tree | 08ddebf4733e3b3c2b24d4ee1db8313c4a447f71 /railties/guides | |
| parent | 4d20de8a50d889a09e6f5642984775fe796ca943 (diff) | |
| download | rails-0306f82e0c3cda3aad1b45eb0c3a359c254b62cc.tar.gz rails-0306f82e0c3cda3aad1b45eb0c3a359c254b62cc.tar.bz2 rails-0306f82e0c3cda3aad1b45eb0c3a359c254b62cc.zip | |
implements automatic EXPLAIN logging for slow queries
Diffstat (limited to 'railties/guides')
3 files changed, 13 insertions, 0 deletions
diff --git a/railties/guides/code/getting_started/config/environments/development.rb b/railties/guides/code/getting_started/config/environments/development.rb index 89932bf19b..d60a10568b 100644 --- a/railties/guides/code/getting_started/config/environments/development.rb +++ b/railties/guides/code/getting_started/config/environments/development.rb @@ -22,6 +22,13 @@ Blog::Application.configure do # Only use best-standards-support built into browsers config.action_dispatch.best_standards_support = :builtin + # Raise exception on mass assignment protection for ActiveRecord models + config.active_record.mass_assignment_sanitizer = :strict + + # Log the query plan for queries taking more than this (works + # with SQLite, MySQL, and PostgreSQL) + config.active_record.auto_explain_threshold_in_seconds = 0.5 + # Do not compress assets config.assets.compress = false diff --git a/railties/guides/code/getting_started/config/environments/production.rb b/railties/guides/code/getting_started/config/environments/production.rb index dee8acfdfe..c9b2f41c39 100644 --- a/railties/guides/code/getting_started/config/environments/production.rb +++ b/railties/guides/code/getting_started/config/environments/production.rb @@ -60,4 +60,8 @@ Blog::Application.configure do # Send deprecation notices to registered listeners config.active_support.deprecation = :notify + + # Log the query plan for queries taking more than this (works + # with SQLite, MySQL, and PostgreSQL) + # config.active_record.auto_explain_threshold_in_seconds = 0.5 end diff --git a/railties/guides/source/configuring.textile b/railties/guides/source/configuring.textile index d91011c370..24bf9d863b 100644 --- a/railties/guides/source/configuring.textile +++ b/railties/guides/source/configuring.textile @@ -268,6 +268,8 @@ h4. Configuring Active Record * +config.active_record.identity_map+ controls whether the identity map is enabled, and is false by default. +* +config.active_record.auto_explain_threshold_in_seconds+ configures the threshold for automatic EXPLAINs (+nil+ disables this feature). Queries taking more than those many seconds get their query plan logged. Default is 0.5 in development mode. + The MySQL adapter adds one additional configuration option: * +ActiveRecord::ConnectionAdapters::MysqlAdapter.emulate_booleans+ controls whether Active Record will consider all +tinyint(1)+ columns in a MySQL database to be booleans and is true by default. |