Django: Setting transaction level and autocommit with MySQL

gistfile1.txt

# my.conf
[mysqld]
autocommit = 1
transaction-isolation = READ-COMMITTED

# settings.py
DATABASES = {
  ...,
  'OPTIONS': {
      'init_command': 'SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED',
      'read_default_file': 'path/to/my.cnf',
  }
}

# this in code somewhere to check settings have been applied
from django.db import connection
import logging

cursor = connection.cursor()
cursor.execute("SHOW VARIABLES LIKE 'tx_isolation'")
logging.info(cursor.fetchone())

cursor.execute("SHOW VARIABLES LIKE 'autocommit'")
logging.info(cursor.fetchone())