How to edit Django's settings.py file to use MyISAM MySQL storage engine?

mysql
settings
storage-engine
retag add tags

I want to install askbot on my shared server. The default db engine of this server is InnoDB and .my.cnf is hidden by administrator. I tried to edit the script of askbot to use MyISAM strictly, but I cannot find where to edit. Thanks.

ubi_com

asked 2012-06-07 20:10:17 -0500

13.2k

Evgeny

updated 2012-06-07 21:34:19 -0500

edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

2 Answers

Sort by

oldest

newest

most voted

This stackoverflow post will hopefully help you.

At this time we do not support the "new style" databases settings, use DATABASE_OPTIONS setting instead.

13.2k

Evgeny

answered 2012-06-07 21:23:42 -0500

edit flag offensive 0 remove flag delete link

Comments

Thanks a lot! I have achieved to created MyISAM databases to add DATABASE_OPTIONS at settings.py.

ubi_com (2012-06-12 18:33:38 -0500) edit

add a comment see more comments

-1

If you own the box, why not make MyIsam default globally across all apps?

Add the following directive to /etc/my.cnf

default-storage-engine = MyISAM

185

naavi

answered 2012-06-10 07:02:50 -0500

edit flag offensive 0 remove flag delete link

Comments

I'm not alone to use this machine.

ubi_com (2012-06-12 18:38:23 -0500) edit

add a comment see more comments

How to edit Django's settings.py file to use MyISAM MySQL storage engine? edit

Comments

2 Answers

Comments

Comments

How to edit Django's settings.py file to use MyISAM MySQL storage engine?