On Sat, 2008-11-29 at 21:22 -0800, I.A wrote:
> Hi Zeroth,
>
> I'm sorry for missing that information.
> Yes, I'm using MySQL 5.0.x and your question made me check. Turns out
> that mysql was creating MyISAM tables for me when I do syncdb with my
> models. I've added the following line to my settings.py
>
> DATABASE_OPTIONS = {"init_command": "SET storage_engine=INNODB"}
>
> as found on http://risottoinc.blogspot.com/2007/06/django-mysql-innodb.html,
> dropped the whole database and and re-syncd again. It works like a
> charm now.
You only need that particular DATABASE_OPTION when you're creating the
table. Since it adds a little bit of extra overhead each time, it's
probably worth commenting it out for normal operations.
Also, you didn't need to do the full drop and resync dance. You can use
"ALTER TABLE" in MySQL to change the storage engine type on a table.
Regards,
Malcolm
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
