MySQL Bugs: #86212: Query Cache Usage in MYSQL Server 5.7.9

Bug #86212	Query Cache Usage in MYSQL Server 5.7.9
Submitted:	8 May 2017 8:31	Modified:	9 May 2017 7:58
Reporter:	Samira Kumar Dash	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Query Cache	Severity:	S1 (Critical)
Version:	5.7.9	OS:	CentOS
Assigned to:		CPU Architecture:	Any

Description:
Hi, 

Recently, I have migrated one of our server from 5.5 version to 5.7 and we are getting issue with query cache. Query cache is being properly used in previous version but it is not using the query cache. Please help me out to resolve this issue. 

Thanks
Samira Kumar Dash

How to repeat:
Variables defined for Query Cache:

have_query_cache=Yes
query_cache_limit=1 MB
query_cache_size=32 MB
query_cache_type=ON

Thank you for taking the time to report a problem.  Unfortunately you are not using a current version of the product you reported a problem with -- the problem might already be fixed. Please download a new version from http://www.mysql.com/downloads/

There is no test-case associated with the bug so there is nothing for me to try and verify here. If you come up with a test case, then I'll be happy to try and verify it. If you are able to reproduce the bug with one of the latest versions, please change the version on this bug report to the version you tested and change the status back to "Open".  Again, thank you for your continued support of MySQL.

Thank your for quick response. 

If you can give me an example of test case so that I can prepare and upload it and it will be really helpful for us. 

Thanks
Samira Kumar Dash

Hello Samira Kumar Dash,

Please note that we don't fix bugs in old versions.So, I suggest you to try latest version which is 5.7.18 , check if the problem still exists. if you are still seeing the problem that you have reported here then report us back exact problem that you are seeing with test case (SQL dump with CREATE TABLE statements, subset of data etc. Also, queries if any etc reproduce the problem). Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Thanks,
Umesh