SphinxSearch
SphinxSearch copied to clipboard
Reindex gets stuck/finishes early
We have ~80 000 products, 6 store views.
I can see in catalogsearch_fulltext table that there's 500 000+ entries.
sphinx_catalogsearch_fulltext_tmp gets stuck somewhere around 27 000 (and thus never transfers the data to sphinx_catalogsearch_fulltext)
No errors show up in Mysql error log.
I do get some errors near the start of reindex, though, in system.log
User Error: DDL statements are not allowed in transactions in /home/user/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php on line 484
Magento 1.9.3.2
Seems like PHP runs out of memory. I had it set to 1024M by the way.
Does this keep everything in memory until it's done?