Hello, we are working on big shop with more than 130 000 items and 4 stores (languages).
We met a big problem with index management and this is why we set index update in manual mode and left them for shell processing with indexer.php from CLI (we are on dedicated server). However every time we try to reindex catalog_url we get:
PHP Fatal error: Allowed memory size of 2147483648 bytes exhausted (tried to allocate 71 bytes) in /var/www/vhosts/*******/httpdocs/magento/lib/Zend/Db/Adapter/Abstract.php on line 869
Memory limit for PHP CLi is 10gb of ram in php.ini
I tried php -d memory_limit=10000M -f indexer.php --reindex catalog_url
Moreover ini_set(’memory_limit’, ‘10000M’), but no effect.
We cannot skip that 2gb limit in any way. it is Debian 6 based server with Plesk on it. Moreover indexer.php is called from root user and ulimit-a shows unlimited resources for processes.
i try to find solution in the web but no success ..
catalogsearch_fulltext index is a problem too . All other indexes are update for around 20 minutes. We are processing indexes one by one - we do not use indexer.php reindexall.