User Tools

Site Tools


magento_indexing

Indexing

mysql> use magento;
mysql> select * from index_process;
+------------+------------------------------+-----------------+---------------------+---------------------+-----------+
| process_id | indexer_code                 | status          | started_at          | ended_at            | mode      |
+------------+------------------------------+-----------------+---------------------+---------------------+-----------+
|          1 | catalog_product_attribute    | pending         | 2014-05-05 20:11:54 | 2014-05-05 20:11:55 | real_time |
|          2 | catalog_product_price        | pending         | 2013-12-30 11:19:23 | 2013-12-30 11:19:23 | real_time |
|          3 | catalog_url                  | pending         | 2013-04-25 18:50:10 | 2013-04-25 18:50:10 | manual    | <----should be manual
|          4 | catalog_product_flat         | pending         | 2013-12-27 11:53:30 | 2013-12-27 11:53:31 | real_time |
|          5 | catalog_category_flat        | pending         | 2013-04-12 09:19:07 | 2013-04-12 09:19:07 | real_time |
|          6 | catalog_category_product     | pending         | 2013-12-23 14:44:15 | 2013-12-23 14:44:25 | real_time |
|          7 | catalogsearch_fulltext       | pending         | 2013-12-26 14:48:44 | 2013-12-26 14:48:46 | manual    | <----should be manual
|          8 | cataloginventory_stock       | pending         | 2014-05-05 20:11:05 | 2014-05-05 20:11:05 | real_time |
|          9 | tag_summary                  | pending         | 2014-05-05 20:11:54 | 2014-05-05 20:11:54 | real_time |
|         36 | url_redirect                 | require_reindex |                NULL |                NULL | real_time |
|         37 | catalog_url_category         | require_reindex |                NULL |                NULL | real_time |
|         38 | catalog_url_product          | require_reindex |                NULL |                NULL | real_time |
|         39 | catalog_category_product_cat | require_reindex |                NULL |                NULL | real_time |
|         40 | targetrule                   | require_reindex |                NULL |                NULL | real_time |
+------------+------------------------------+-----------------+---------------------+---------------------+-----------+
14 rows in set (0.00 sec)

To update the two databases to manual indexing you can use the following commands:
mysql> update index_process
    -> set mode="manual"
    -> where indexer_code="catalog_url";

mysql> update index_process
    -> set mode="manual"
    -> where indexer_code="catalogsearch_fulltext";

A re-index all cron should be running once a day. Any more times and this can start causing lock issues on your device:
crontab -u root -l

@daily /usr/bin/php /var/www/vhosts/local.deals/htdocs/shell/indexer.php reindexall


Index Time

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)

magento_indexing.txt · Last modified: 2024/05/23 07:26 by 127.0.0.1

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