I would like to reduce the size of the _cl tables in EE 1.14

 catalog_product_index_price_cl                |    1572.00 |
| catalogsearch_fulltext_cl                     |    1512.00 |
| catalog_product_flat_cl                       |     977.00 |
| cataloginventory_stock_status_cl              |     604.00 |

Found the answer here :

Mechanics of the new Changelog Tables (ex: catalog_category_product_cat_cl)

The Enterprise_Mview module already has the ability to clean these tables. It takes the latest version_id for each table from enterprise_mview_metadata and deletes any rows with a version_id lower than that. You can enable index cleaning by going to System > Configuration > (ADVANCED section) > Index Management and setting Enable Scheduled Cleanup to Yes under Index Clean Schedule.

Thanks to https://magento.stackexchange.com/users/5694/tyler-v

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.