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.