Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Growth of the number of prepared statements on server #935

Open
notxcain opened this issue Aug 17, 2022 · 0 comments
Open

Growth of the number of prepared statements on server #935

notxcain opened this issue Aug 17, 2022 · 0 comments

Comments

@notxcain
Copy link

notxcain commented Aug 17, 2022

Hey folks!

I don't know why but we noticed that PrepareCache in finagle-mysql does not send enough CloseRequests to match PrepareRequests when the cache's capacity gets reached. That leads to a growing number of prepared statements on server. We noticed that it lags behind at around 2-4 rps and this is the exact growth rate we see on the server.

However we see that only in production and I can't reproduce that locally.

Any ideas on why this could it happen?

Don't pay attention to the spikes, it's application restart
image

Environment
MySQL 8.0
Fiangle 21.8.0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

1 participant