Comments - MariaDB connector API get all foreign keys return slowly with MySQL server 8.0.33+
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
I note this has a referenced table. If the schema (database) is passed as the second argument to getExportedKeys does this significantly improve the query time?
For clarity, also what is the MariaDB server version?
As far as I can see in the Connector/J implementation, its left to the server to implement this in a performing way.
Can you create a bug report on https://jira.mariadb.org - MDEV for the server or CONJ for Connector/J.
Thank you for your updates
Tried passing the schema to getExportedKeys and the execution time to get the foreign key didn't vary much.
About MariaDB server, we don't use it.
We only use MariaDB connector as a client to connect with MySQL server 8.0.33.
The bug is opened https://jira.mariadb.org/browse/CONJ-1180 for Connector/J
Hope team can take a look at it soon to see why query performance issues occurred.