[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