Skip to content

Support disabling stored procedure cache #1175

Open
@bgrainger

Description

@bgrainger

Based on #924 and #1174, there are a small number of users who modify stored procedure definitions in the database at runtime; this can be a problem because MySqlConnector caches the procedure definitions and can invoke them with the wrong parameter types or order.

Connector/NET can disable its procedure cache by setting Procedure Cache Size = 0 in the connection string. MySqlConnector doesn't support that option.

We could add Procedure Cache Size and only support zero vs non-zero (to disable or enable caching, respectively), or add a new Use Procedure Cache = false connection string option (default is true) to enable users to opt out.

This might have a significant impact on performance, so it could be worth testing whether it's even an option people would want to use. If it's too slow if caching is disabled, other workarounds (such as clearing the pool to get the side-effect of clearing the procedure cache) might be a better solution anyway.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions