Database admnistrator required to find out why some queries are stuck in sending data phase

Database Administrator needed to troubleshoot and resolve issues with stuck queries in a MariaDB 10.4 database. The client is experiencing performance problems due to these stuck queries and needs assistance in identifying and resolving the underlying cause. The ideal candidate should have experience in database administration with a focus on query optimization and performance tuning.

Key Requirements:
- Strong knowledge and experience with MariaDB 10.4
- Expertise in troubleshooting and resolving stuck queries
- Proficiency in query optimization and performance tuning
- Familiarity with database error logs and error message analysis
- Ability to diagnose and resolve performance issues affecting the database

If you have the necessary skills and experience, please submit your proposal outlining your approach to resolving the stuck query issue and improving the overall performance of the database.

For related info check

https://github.com/magento/magento2/issues/36667
https://jira.mariadb.org/browse/MDEV-32033

Furthermore the queries run really fast so there's no apparent issue in the indexers or the database table structures. The server has ample room for memory and nvme disks.

All common troubleshooting steps have been taken.

Zero milestones will be placed and there's no reward for trying. Only complete solutions that resolve the issues at hand will be accepted.