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

Do not cache empty resultset #1693

Closed
renecannao opened this issue Sep 15, 2018 · 1 comment
Closed

Do not cache empty resultset #1693

renecannao opened this issue Sep 15, 2018 · 1 comment
Assignees
@renecannao
Labels
CACHE QUERY PROCESSOR
Milestone
v2.0.1

Comments

@renecannao
Copy link
Contributor

I have been informed of an interesting use case for which query cache should be enabled only for not empty resultsets.
This behavior can be controlled adding a new global variable.
@renecannao renecannao added this to the v2.0.0 milestone Sep 15, 2018
@renecannao renecannao self-assigned this Sep 15, 2018
@renecannao renecannao mentioned this issue Sep 17, 2018
Closed
@renecannao renecannao modified the milestones: v2.0.0, v2.0.1 Sep 17, 2018
renecannao added a commit that referenced this issue Sep 18, 2018
@renecannao
Add new variable mysql-query_cache_stores_empty_result #1693
ca63fe8 
The variable controls if resultset withour rows will be cached or not
renecannao added a commit that referenced this issue Sep 18, 2018
@renecannao
Add new variable mysql-query_cache_stores_empty_result #1693
c68d72a 
The variable controls if resultset withour rows will be cached or not
pondix pushed a commit that referenced this issue Sep 21, 2018
Merge pull request #1698 from sysown/v1.4.12-1693
9d64771 
Add new variable mysql-query_cache_stores_empty_result #1693
pondix pushed a commit that referenced this issue Sep 21, 2018
Merge pull request #1699 from sysown/v2.0.0-1693
3569417 
 Add new variable mysql-query_cache_stores_empty_result #1693
@renecannao
Copy link
Contributor Author

Closing

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@renecannao renecannao

Labels
CACHE QUERY PROCESSOR
Projects
None yet
Milestone
v2.0.1
Development

No branches or pull requests
1 participant
@renecannao