magento_indexing
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| magento_indexing [2016/07/18 06:42] – created luke7858 | magento_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 / | ||
| - | </ | ||
| <sxh bash> | <sxh bash> | ||
| + | mysql> use magento; | ||
| mysql> select * from index_process; | mysql> select * from index_process; | ||
| +------------+------------------------------+-----------------+---------------------+---------------------+-----------+ | +------------+------------------------------+-----------------+---------------------+---------------------+-----------+ | ||
| Line 27: | Line 22: | ||
| +------------+------------------------------+-----------------+---------------------+---------------------+-----------+ | +------------+------------------------------+-----------------+---------------------+---------------------+-----------+ | ||
| 14 rows in set (0.00 sec) | 14 rows in set (0.00 sec) | ||
| + | </ | ||
| + | \\ | ||
| + | To update the two databases to manual indexing you can use the following commands: | ||
| + | <sxh bash> | ||
| + | mysql> update index_process | ||
| + | -> set mode=" | ||
| + | -> where indexer_code=" | ||
| + | |||
| + | mysql> update index_process | ||
| + | -> set mode=" | ||
| + | -> where indexer_code=" | ||
| + | </ | ||
| + | \\ | ||
| + | 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 / | ||
| + | </ | ||
| + | \\ | ||
| + | \\ | ||
| + | === Index Time === | ||
| + | <sxh bash> | ||
| + | mysql> SELECT indexer_code, | ||
| + | +---------------------------+----------+ | ||
| + | | indexer_code | ||
| + | +---------------------------+----------+ | ||
| + | | catalog_url | ||
| + | | catalog_product_attribute | 2 | | ||
| + | | catalog_category_product | ||
| + | | catalogsearch_fulltext | ||
| + | | catalog_product_price | ||
| + | | catalog_product_flat | ||
| + | | catalog_category_flat | ||
| + | | cataloginventory_stock | ||
| + | | tag_summary | ||
| + | +---------------------------+----------+ | ||
| + | 9 rows in set (0.00 sec) | ||
| </ | </ | ||
magento_indexing.1468824141.txt.gz · Last modified: 2024/05/23 07:26 (external edit)