If you have SSH access to your Linux (or Unix) server you can easy re-index Magento database from Linux command shell.
You can use such re-index method to decrease load on your server. The PHP shell commands will be executed directly, without Apache overloading.
Here is an instruction on how to use default Magento indexer via SSH console:
1 - Go to "shell" folder in your Magento installation:
cd shell
2 - Execute the re-index process using this command:
php -f indexer.php reindexall
It is possible to get full list of Magento indexer commands using this command:
php -f indexer.php help
To get a list of all available indexes, execute this command:
php -f indexer.php info
By default there are 8 indexes in Magento:
catalog_product_attribute Product Attributes catalog_product_price Product Prices catalog_url Catalog Url Rewrites catalog_product_flat Product Flat Data catalog_category_flat Category Flat Data catalog_category_product Category Products catalogsearch_fulltext Catalog Search Index cataloginventory_stock Stock status
Content-type: text/html
Usage: php -f indexer.php — [options]
–status Show Indexer(s) Status
–mode Show Indexer(s) Index Mode
–mode-realtime Set index mode type “Update on Save”
–mode-manual Set index mode type “Manual Update”
–reindex Reindex Data
info Show allowed indexers
reindexall Reindex Data by all indexers
help This help
Comma separated indexer codes or value “all” for all indexers
**********************************************************
Is there a syntax error?
Thanks…V
Load Balancer Connected to 4 Apache Webservers, 1 MySQL database running Percona MySQL
When using php indexer.php --reindexall and monitoring the incoming queries to MySQL I noticed that my queries were originating from all 4 of the webservers, even though I only started the indexing process on 1 of the webservers.
Do you know how isolate the indexing process to only the server it is initiated on? Have you found any performance differences in running these as comma delimited (php indexer.php --reindex catalog_product_price,catalog_url,catalog_product_flat)?