Magento's _cl tables had 902 million rows
Magento 2's indexer architecture is not built for an 800K-product catalog with daily supplier-feed updates. The _cl changelog tables grow faster than the cron can drain them, and eventually something gives. This is the nightly reindex-and-truncate cron I now run, why the order of operations matters, and why none of the Magento experts I asked found this in six months.






