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