Call to Information Schema is very slow for mariadb. can we use mysql.proc instead.

[ashishkhadloya-ai]

Software versions
MySqlConnector version: 2.4
Server type (MySQL, MariaDB, Aurora, etc.) and version: MARIADB 10.5
.NET version: .net8
(Optional) ORM NuGet packages and versions:

Describe the bug
There ia a documented bug which was fixed before.
Heavy usage of information schema periodically causing server performance issue #569

But the same issue is still re creatable for MARIADB. I have check the code in CachedProcedure.cs file line no 16 and it say use proc table only for not mariadb. but i am facing same issue with mariadb 10.5

Is there a workaround for the same

[bgrainger]

This looks like it might have been a bug introduced in e28e2a5.

The previous code allowed the use of mysql.proc with MariaDB because its version was "5.5.5" (which was less than 8.0). The new code probably meant to only run that check for MySQL Server but had the side-effect of disabling that branch for MariaDB.