Hi i have a website in magento2 , in my database we have
467500 rows in cron_schedule table , my site is lacking alot and most of the time it goes down displaying server timeout issue .
The configuration of my server is 18gb ram with 1 tb HDD , my database got crashed during the time of when cron jobs run , its my guess it is creating issue .
i see 462318 statuses are in pending states in my cron_schedule table out of 467500 statuses .
I just wants to know is this creating issue ? should i delete that all rows in my table for quick heal ? , as my db is crashing so much , what will be the permanent solution for this ?