[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