I have a online store website by Magento. I built this website from scratch. But after doing a diff on the tables from a production server to a local server, I just have noticed that some new tables have been created all ending with _cl. These are:
# TABLE: catalog_category_product_cl
# TABLE: cataloginventory_stock_cl
# TABLE: catalog_product_price_cl
# TABLE: catalog_product_category_cl
# TABLE: customer_dummy_cl
# TABLE: catalogrule_product_cl
# TABLE: catalog_product_attribute_cl
# TABLE: catalogsearch_fulltext_cl
# TABLE: design_config_dummy_cl
# TABLE: catalogrule_rule_cl
Seeing as these are all related to indexes within Magento, I assume that they are "change Logs" or suchlike (if this could be confirmed, I would appreciated it!).
I have a two part question around this, how are these tables populated, and how often / how are these tables cleaned?
Any help on this would be greatly appreciated. Thank you very much!!
Magento 2 Tables Being Created Ending in “_cl”, Problems with Magento 2