Silence ActiveRecord / MySQL log output in Rails 3.1?

Question

Is there a way to silence/disable mysql output in the development.log?

For example this stuff:

SQL (0.4ms)  INSERT INTO `billing_infos` (`billing_method`, `city`, `company_id`, `country`, `created_at`, `email`, `fax_number`, `phone_number`, `postal_code`, `province`, `street`, `updated_at`) VALUES (NULL, 'Montreal', NULL, 'Canada', '2011-10-26 20:53:45', NULL, NULL, '(123) 456 7890', 'H1H1H1', 'QC', '1111 Temp', '2011-10-26 20:53:45')
 (0.3ms)  COMMIT
 (0.2ms)  BEGIN
 (0.1ms)  COMMIT
 (0.1ms)  BEGIN
 (0.4ms)  SELECT 1 FROM `sectors` WHERE (`sectors`.`name` = BINARY 'General 25' AND `sectors`.`id` != 1) LIMIT 1

fearless_fool · Accepted Answer · 2012-03-09 20:46:20Z

4

If you want to suppress almost all log output, @Shirjeel's approach will work, though I find it a bit heavy handed.

If you prefer to suppress output for a single ActiveRecord class, and only within a specific block, you can use silence:

BillingInfo.silence do
  BillingInfo.create(:city => "Montreal")
  BillingInfo.create(:city => "Ottawa")
  ... etc
end

If you want to suppress output for all ActiveRecord subclasses, you can do

ActiveRecord::Base.silence do
  ... manipulate database quietly here...
end

I use this when I'm importing a large block of records or generating large test cases.

answered Mar 9, 2012 at 20:46

fearless_fool

35.6k26 gold badges147 silver badges236 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

aNoble Over a year ago

Turns out this is deprecated in Rails 4.0 due to thread safety issues. There's no alternative that I know of.

Shirjeel Alam · Accepted Answer · 2011-10-27 08:19:17Z

1

Add following line to your config/environments/development.rb file

config.log_level = :info

answered Oct 27, 2011 at 8:19

Shirjeel Alam

1547 bronze badges

Collectives™ on Stack Overflow

Silence ActiveRecord / MySQL log output in Rails 3.1?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related