Posted over 7 years ago. Visible to the public. Repeats.

MySQL: Disable query cache for database profiling

If you want to see how long your database queries actually take, you need to disable MySQL's query cache. This can be done globally by logging into a database console, run

Copy
SET GLOBAL query_cache_type=OFF;

and restart your rails server.

You can also disable the cache on a per query basis by saying

Copy
SELECT SQL_NO_CACHE * FROM ...

You also probably want to disable Rails internal (per-request) cache. For this, wrap your code with a call to ActiveRecord::Base.uncached. For example, as an around_filter:

Copy
def disable_cache
  ActiveRecord::Base.uncached do
    yield
  end
  true
end

Don't forget to re-enable MySQL query caching later with

Copy
SET GLOBAL query_cache_type=ON;

Need to speak with a Rails professional?

makandra has been working exclusively with Ruby on Rails since 2007. Our laser focus on a single technology has made us a leader in this space.

Learn more

Author of this card:

Tobias Kraze

makandra.de

Say thanks

Last edit:

about 3 years ago

by Henning Koch

About this deck:

We are makandra and do test-driven, agile Ruby on Rails software development.

License for source code

MySQL: Disable query cache for database profiling

Author of this card:

Your thanks were sent to !

License for source code

Your thanks were sent
to !