Magento 2.2 has issues with giant `cron_schedule` tables. The cron job running time will increase when the table gets bigger, causing heavy CPU usage.
Magento 2.2 has issues with giant
cron_schedule tables. The cron job running time will increase when the table gets bigger, causing heavy CPU usage.
In one of our stores the
cron_schedule table exeeded 1.000.000 rows. To identify the problem run the following SQL query:
SELECT count(*) FROM `cron_schedule`
Remove the old rows in
DELETE FROM cron_schedule WHERE scheduled_at < Date_sub(Now(), interval 24 hour);
This module will execute the cleanup query once a day.
composer require vendic/magento2-clean-cron-schedule
Vendic develops technically challenging e-commerce websites using Magento 2, as well as innovative headless PWA shops. Feel free to check out our projects on our website.