Catalogsearch_fulltext index Not Doing Anything in Database
Hi, we have a problem with a CE 2.1.8 install with around 250k SKUS. The site was migrated to a new higher spec VPS and everything initially indexed fine and the site works.
We then did a small CSV import with some product price updates. After the import we reindex as required, but the catalogsearch_fulltext index never seems to complete even when left overnight several times. As far as I know server spec is fine, and recommended configs have been made to improve performance.
The indexer stays on processing forever, but when I look in the database, nothing seems to be going into the 'catalogsearch_fulltext_scope1' table which I would expect the indexer to be populating.
Any ideas - super frustrating as while the index is running, no products are showing in the store categories.