Andrey Anshin

Looks promising only couple of tests: 1. `pytest.warns(expected_warning=None)` I miss that one when did https://github.com/apache/airflow/pull/38027 2. FAB tests

I could reproduce FAB tests failure in pytest 7 if I run this module in random order ```console root@d9cbab8b3875:/opt/airflow# pip install pytest-random-order root@d9cbab8b3875:/opt/airflow# pytest tests/providers/fab/auth_manager/test_security.py --random-order ... ======================================================================= 3 failed,...

> I also fixed it by changing the fixtures scope from module to function, but it increased the test processing time. We need to add a teardown block somewhere to...

But yeah if fix help we just need to create a task for a properly fix this test module

> Looks like an index hint should be needed or smth like that. Very interesting one. I will mark it for 2.7.1 hoping maybe someone will have time to fix...

And I currently think how to optimize or get rid off magic wrapper https://github.com/apache/airflow/blob/32a490e2cf380f57b58f187497352bd4dd49e869/airflow/utils/sqlalchemy.py#L535

First of all I would recommend considering possibility of upgrading to a new version of MySQL, [5.7 it is almost EOL](https://endoflife.date/mysql), even if Amazon would support MySQL 5.7 on Aurora...

> Those are a bit guesses - maybe @Taragolis who have done a bit more analysis can also confirm if my thinking is right. To be honest I've had a...

> I am not an expert in MySQL either, but from what I found out on internet, I dont think MySQL automatically runs analyze command, that could be the reason...

@thanhtrung5763 No one proposed a fix yet