SQLAlchemy: How to change a MySQL server system variable using SQLAlchemy?

Question

I want to set the general_log and general_log_file variables using SQLAlchemy, is there a way to do this? I've been Googling around and can't find anything on the topic.

Answer 1

You can execute any raw SQL query which you need (of course you have to get appropriate rights in the session). To change a variable run something like this:

# change variable name and values to what you need
connection.execute("SET SESSION query_cache_type = OFF")