title: How to turn off MySQL query cache while using SQLAlchemy?
body: <p>I am working with a fairly large MySQL database via the SQLAlchemy library, and I'd love to turn off MySQL's query caching to debug performance issues on a per-session basis. It's difficult to debug slow queries when repeating them results in much faster execution. With the CLI MySQL client, I can execute <code>SET SESSION query_cache_type = OFF;</code> to achieve the result I'm looking for, and I would like to run this on every SQLAlchemy session (when I'm debugging).</p>
  
  <p>But I can't figure out how to configure SQLAlchemy such that it runs <code>SET SESSION query_cache_type = OFF</code> when it instantiates a new database session.</p>
  
  <p>I've looked at the <a href="http://docs.sqlalchemy.org/en/latest/core/connections.html#sqlalchemy.engine.Connection.execution_options" rel="nofollow">Engine and Connection docs</a>, but can't seem to find anything.</p>
  
  <p>Is there something obvious that I'm missing, or a better way of doing this?</p>