3

I added 50,000 products using magmi and catalog URL rewrites and Catalog SearchIndex are processing for last 16 hours. Some categories show blank page even though, they have thousands of products in them.

How do I know if index is actually processing and not stuck?

Improve this question
1
  • 1
    Try using top and/or htop to see if there is something running and consuming resources.
    – mbalparda
    Aug 23, 2015 at 3:47

2 Answers 2

Reset to default
3

You can log into MySQL using command line client and run query to check what queries are being executed at the moment:

show full processlist;

If you see insert or delete queries accessing index tables, run status query a couple of times and check if "Time" column changes. If its value is being changed and query is still there, it may mean that your indexing is not hang and is still running.

Improve this answer
1

You can check index status using following shell command.

php indexer.php --status
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.