User Tools

Site Tools


magento_indexing

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
magento_indexing [2016/07/18 06:42] luke7858magento_indexing [2024/05/23 07:26] (current) – external edit 127.0.0.1
Line 1: Line 1:
 === Indexing === === Indexing ===
-A re-index all cron should be running once a day. Any more times and this can start causing lock issues on your device: 
-<sxh bash> 
-crontab -u root -l 
- 
-@daily /usr/bin/php /var/www/vhosts/local.deals/htdocs/shell/indexer.php reindexall 
-</sxh> 
 <sxh bash> <sxh bash>
 mysql> use magento; mysql> use magento;
Line 28: Line 22:
 +------------+------------------------------+-----------------+---------------------+---------------------+-----------+ +------------+------------------------------+-----------------+---------------------+---------------------+-----------+
 14 rows in set (0.00 sec) 14 rows in set (0.00 sec)
 +</sxh>
 +\\
 +To update the two databases to manual indexing you can use the following commands:
 +<sxh bash>
 +mysql> update index_process
 +    -> set mode="manual"
 +    -> where indexer_code="catalog_url";
 +
 +mysql> update index_process
 +    -> set mode="manual"
 +    -> where indexer_code="catalogsearch_fulltext";
 +</sxh>
 +\\
 +A re-index all cron should be running once a day. Any more times and this can start causing lock issues on your device:
 +<sxh bash>
 +crontab -u root -l
 +
 +@daily /usr/bin/php /var/www/vhosts/local.deals/htdocs/shell/indexer.php reindexall
 +</sxh>
 +\\
 +\\
 +=== Index Time ===
 +<sxh bash>
 +mysql> SELECT indexer_code, TIMESTAMPDIFF(SECOND, started_at, ended_at) as duration from index_process ORDER BY duration DESC;
 ++---------------------------+----------+
 +| indexer_code              | duration |
 ++---------------------------+----------+
 +| catalog_url                     16 | <----in seconds
 +| catalog_product_attribute |        2 |
 +| catalog_category_product  |        2 |
 +| catalogsearch_fulltext    |        2 |
 +| catalog_product_price            1 |
 +| catalog_product_flat      |        0 |
 +| catalog_category_flat            0 |
 +| cataloginventory_stock    |        0 |
 +| tag_summary                      0 |
 ++---------------------------+----------+
 +9 rows in set (0.00 sec)
 </sxh> </sxh>
magento_indexing.1468824171.txt.gz · Last modified: 2024/05/23 07:26 (external edit)

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki