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?
Best Answer
You can log into MySQL using command line client and run query to check what queries are being executed at the moment:
If you see
insert
ordelete
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.