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.

Sign up for GitHub

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

Jump to bottom

MySQL: Update default statement_cache_size #7727

Closed
janpio opened this issue Jun 17, 2021 · 2 comments · Fixed by prisma/quaint#348 or prisma/prisma-engines#2966
Closed

MySQL: Update default statement_cache_size #7727

janpio opened this issue Jun 17, 2021 · 2 comments · Fixed by prisma/quaint#348 or prisma/prisma-engines#2966
Assignees
@pimeys
Labels
kind/tech A technical change. team/schema Issue for team Schema. tech/engines Issue for tech Engines. topic: breaking change topic: mysql topic: prisma4
Milestone
4.0.0

Comments

@janpio
Copy link
Member

janpio commented Jun 17, 2021 •
edited

Follow up to learnings from #6872

Currently 1000 per connection. Easy to lead to more prepared statements to be created than the MySQL limit for prepared statements: 1000 x connection limit in pool x application servers.

(Setting to 0 disables the cache completely and leads to prepared statements to be deleted after each query by default)
@janpio janpio added topic: mysql kind/tech A technical change. labels Jun 17, 2021
@pantharshit00 pantharshit00 added the team/client Issue for team Client. label Jun 20, 2021
@janpio janpio added the tech/engines Issue for tech Engines. label Jun 21, 2021
@janpio janpio mentioned this issue Jul 11, 2021
Closed
@janpio
Copy link
Member Author

janpio commented Feb 16, 2022 •
edited

Note to @pimeys: Let's prepare a PR that changes this value already.

@matthewmueller matthewmueller added team/schema Issue for team Schema. and removed team/client Issue for team Client. labels Feb 18, 2022
@pimeys pimeys mentioned this issue Mar 2, 2022
Merged
@pimeys
Copy link
Contributor

pimeys commented Mar 2, 2022

Parking for Prisma 4.

@pimeys pimeys added this to the 4.0.x milestone Jun 1, 2022
@pimeys pimeys reopened this Jun 8, 2022
@pimeys pimeys mentioned this issue Jun 8, 2022
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@pimeys pimeys

Labels
kind/tech A technical change. team/schema Issue for team Schema. tech/engines Issue for tech Engines. topic: breaking change topic: mysql topic: prisma4
Projects
None yet
Milestone
4.0.0
5 participants
@pimeys @matthewmueller @janpio @floelhoeffel @pantharshit00