Gary Mort gamort

Senior Backend Developer at Overdose Digital @OverdoseDigital

gamort / magento1_enterprise_index_diagnostics.sql

Created October 6, 2016 17:26 — forked from mttjohnson/magento1_enterprise_index_diagnostics.sql

Magento 1.x Enterprise Partial Indexing Diagnostics Toolset

	-- When products are added/removed from a category this table stores all the relation data
	select * from catalog_category_product where product_id = '24526';

	-- The index that is used for presenting products in a category on the frontend
	select * from catalog_category_product_index where product_id = '24526';

	-- The change log table used for Magento EE partial index functionality
	select * from catalog_category_product_index_cl where product_id = '24526' and version_id > (select version_id from enterprise_mview_metadata where changelog_name = 'catalog_category_product_index_cl');