Page MenuHomePhorge

Consider replacing MyISAM with InnoDB?

Asked by l2dy on Nov 5 2023, 16:58.


Phorge uses the InnoDB table engine. The only exception is the search_documentfield table which uses MyISAM because MySQL doesn't support fulltext search in InnoDB (recent versions do, but we haven't added support yet).

MySQL supports FULLTEXT indexes for InnoDB tables since 5.6.4, so rP6cedd4a95cfc23a1679400fb64863c49f24f2306 no longer stands.

quickstart.sql needs to be updated, as well as several sql patch files and documentation in docs/contributor/database.diviner.