[Owncloud] [mysql] drop MyISAM support, get better database
Philip Taffner
sabel at altmuehlnet.de
Mon Aug 6 17:08:41 UTC 2012
full-text search (FTS) for innodb is available since MySQL 5.6.4
(http://blogs.innodb.com/wp/2011/12/innodb-full-text-search-in-mysql-5-6-4/).
I know, it's still dev, but it will be available someday ;)
Am 06.08.2012 18:54, schrieb Daniel Danger:
> 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.
> _______________________________________________
> Owncloud mailing list
> Owncloud at kde.org
> https://mail.kde.org/mailman/listinfo/owncloud
>
More information about the Owncloud
mailing list