Attempting to fix the MySQL timeout with SQLA2

[Dev-iL]

Attempting to fix the MySQL deadlocks and other SQLA2 no-autocommit issues.

related: #58049

---

^ Add meaningful description above Read the Pull Request Guidelines for more information. In case of fundamental code changes, an Airflow Improvement Proposal (AIP) is needed. In case of a new dependency, check compliance with the ASF 3rd Party License Policy. In case of backwards incompatible changes please leave a note in a newsfragment file, named {pr_number}.significant.rst or {issue_number}.significant.rst, in airflow-core/newsfragments.