mysql - 为什么在创建表后删除 django DATABASE_OPTIONS 的 "init_command set engine=INNODB"？

Question

关于 creating your database tables 的文档说:

另一种选择是在创建表之前使用 MySQLdb 的 init_command 选项:

DATABASE_OPTIONS = {
   "init_command": "SET storage_engine=INNODB",
}

This sets the default storage engine upon connecting to the database. After your tables have been created, you should remove this option as it adds a query that is only needed during table creation to each database connection.

有谁知道为什么在创建表后需要删除这个选项？

Answer 1

从 django 1.2 开始，语法发生了变化

DATABASES = { 
  'default': {
    'ENGINE': 'django.db.backends.mysql',
    'NAME': '',                      
    'USER': '',     
    'PASSWORD': '',
    'OPTIONS': {
           "init_command": "SET storage_engine=INNODB",
    }   
  }   
}