Hello,
The following query takes 6 minutes to complete …
SELECT DISTINCT user FROM mysql.db
WHERE
BINARY db IN (
SELECT DISTINCT db FROM mysql.db
WHERE BINARY user=?
)
… when I have a join_buffer_size over 2,048 KiB.
The effect is pretty remarkable: if I set the buffer size to 2,048 KiB,
the query finishes in about 0.1 seconds, but with the buffer size at 2,049 KiB
it takes several minutes.
The long query time doesn’t happen in MySQL 5.7, but we see it in
MariaDB 10.1 and 10.2.
Is this a known issue?
Thank you!
-Felipe Gasper
Mississauga, Ontario
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
