i have Catalog_product_index_price and Catalog_product_index_price_idx talbles which are 1G large with 10 million rows each. the catalog has ~ 500K products.

I'm trying to reindex the catalog_product_price but to no avail, the mysql server crashes every time even when i increased the timeout.

I know that the size of the tables are the reason why it's unable to complete. What options do i have to solve this issue.



Your Answer

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

Browse other questions tagged or ask your own question.