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?

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

2 Answers 2


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.


You can check index status using following shell command.

php indexer.php --status

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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