I've been noticing the Magento cron job running for over 10 hours now. An strace only shows polls. However I do see the following query running

    `e`.*, `at_visibility`.`value` AS `visibility`
    `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_entity_int` AS `at_visibility` ON (
    `at_visibility`.`entity_id` = `e`.`entity_id`
    `at_visibility`.`attribute_id` = '95'
AND (`at_visibility`.`store_id` = 0)
    (at_visibility. VALUE = '4')
LIMIT 10 OFFSET 329420

Any ideas what Magento is doing right now? How can I debug this further?

  • That is a reindex i think. – mbalparda Aug 13 '14 at 14:14
  • LIMIT 10 OFFSET 329420 man it takes lot of data to process, try to run this query with explain and it will explain what it does and how hard it hits the db – Anton S Aug 13 '14 at 16:46
  • great and what did you found out? – Anton S Aug 16 '14 at 18:17

This seems to be part of the product catalog reindex.

| 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.