Hi,
Can you get the same result with "default-storage-engine=InnoDB" in your
my.cnf?
- Haavikko
Rob Hudson wrote:
> Hi Django Users,
>
> I'm using MySQL with Django but I dislike MySQL's default MyISAM
> tables because there is no referential integrity. So I googled how to
> force Django to create InnoDB tables with MySQL and I found that I
> need to add this to my settings.py:
>
> DATABASE_OPTIONS = {
> "init_command": "SET storage_engine=INNODB",
> }
>
> I also saw that there was a comment stating to only do this when you
> run syncdb and not when running in general. I can understand that
> it's only really needed when you run the CREATE statements, but does
> anyone know if it adds any overhead if it's left in? It's somewhat of
> a PITA to have to remember to alter my settings if I'm adjusting my
> data models.
>
> Thanks,
> Rob
>
> >
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
