]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Imrpove MySQL/MariaDB dialect initialization.
authorFederico Caselli <cfederico87@gmail.com>
Thu, 30 Dec 2021 22:29:55 +0000 (23:29 +0100)
committerFederico Caselli <cfederico87@gmail.com>
Mon, 3 Jan 2022 20:42:05 +0000 (21:42 +0100)
commitead6c7f8aee866cd9b5c901b762725b1cb16e151
tree905053a772684260573d16b6a9013f86e0b0180a
parentdd8e33d84f9d0449c14e51a4e3ffdefdd470f961
Imrpove MySQL/MariaDB dialect initialization.

Replace ``SHOW VARIABLES LIKE`` statement with equivalent
``SELECT @@variable`` in MySQL and MariaDB dialect initialization.
This should avoid mutex contention caused by ``SHOW VARIABLES``,
improving initialization performance.

Change-Id: Id836ef534fcc1473c7aaf9270d08a4da9b8f62cf
closes: #7518
(cherry picked from commit 5e06f0f579df45116696fed78d65abcccc1dc3e3)
doc/build/changelog/unreleased_14/7518.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/mysql/base.py
lib/sqlalchemy/dialects/mysql/pyodbc.py
test/dialect/mysql/test_dialect.py