SQLAlchemy: How To Change A MySQL Server System Variable Using SQLAlchemy?

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.

Solution 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")