[Issue] magento/magento2#: Add a new index for `cron_schedule` table

[m2-assistant]

This issue is automatically created based on existing pull request: #27391: magento/magento2#: Add a new index for cron_schedule table

---

Preconditions(*)

Magento\Cron\Model\ResourceModel\Schedule::trySetJobStatusAtomic() executes an UPDATE SQL with an additional status parameter:

 UPDATE `cron_schedule` SET `status` = ? WHERE (schedule_id = ?) AND (status = ?) 

UPDATE is a hard query and New Relic report about this:

PR adds an additional index based on

• schedule_id
• status

fields.

Related Pull Requests

Fixed Issues (if relevant)

1. magento/magento2#<issue_number>: Issue title

Steps to reproduce: (*)

Actual Result: (*)

Expected Result: (*)

1. ...
2. ...

Questions or comments

Contribution checklist (*)

• Pull request has a meaningful description of its purpose
• All commits are accompanied by meaningful commit messages
• All new or changed code is covered with unit/integration tests (if applicable)
• All automated tests passed successfully (all builds are green)

[magento-engcom-team]

✅ Confirmed by @engcom-Alfa
Thank you for verifying the issue. Based on the provided information internal tickets MC-37523 were created

Issue Available: @engcom-Alfa, You will be automatically unassigned. Contributors/Maintainers can claim this issue to continue. To reclaim and continue work, reassign the ticket to yourself.