All Low add-ons are now owned by EEHarbor. Read the blog post.

Support archive

Converting to InnoDB tables in Low Search

Christian Rochford 28 Jun 2017 16:38 question, complete

I've just set up an install of EE3 (3.5.9) using Low Search (5.1.0) on a nginx server. The clients database is throwing an error due to the MyISAM table. My client is using Percona DB Clustering as part of a provision for a load balancer, this allows for table replication and it works fine for InnoDB tables but they cannot convert the MyISAM table, do you know if there's any way of changing 'exp_low_search_indexes' to InnoDB?

Replies

  1. Low 28 Jun 2017 17:04

    That table needed MyISAM, because MySQL versions lower than 5.6 did not support the necessary full-text indexes for InnoDB.

    So, it depends on your MySQL version. It it's 5.5 or lower, then you will need MyISAM on that table. Otherwise, you can try to convert it to InnoDB.

  2. Christian Rochford 29 Jun 2017 07:32

    Great thanks for confirming that.