[Owncloud] [mysql] drop MyISAM support, get better database
Daniel Danger
owncloud at danger-it.de
Mon Aug 6 16:54:08 UTC 2012
Hi,
I suggest, that we drop support for MyISAM and switch to InnoDB. There
are a few reasons for that:
- we get support for foreign keys
- better performance if we let the database do the database stuff
- cleaner db schema possible
And there are two drawbacks (afaik):
- changing existing MyISAM tables to InnoDB might take a little time
(depending on db size)
- we lose fast full-text search in the db
I do have the code for that ready for any dev who wants to give it a
try. I have not tested that code enough to push it to master, yet.
Cheers,
Daniel
Ps.: InnoDB is the default engine in recent MySQL versions. It is also
supported in all older versions of mysql that I know of.
More information about the Owncloud
mailing list