Bug #1898 DROP database invalidates whole query cache

Submitted:	20 Nov 2003 3:41	Modified:	9 Dec 2003 13:20
Reporter:	Oleksandr Byelkin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.0	OS:	Any (any)
Assigned to:	Oleksandr Byelkin	CPU Architecture:	Any

Description:
DROP database invalidates whole query cache 

How to repeat:
+ set GLOBAL query_cache_size=1355776; 
+ drop table if exists t1; 
+ drop database if exists mysqltest; 
+ create table t1(a int); 
+ select * from t1; 
+ a 
+ show status like "Qcache_queries_in_cache"; 
+ Variable_name Value 
+ Qcache_queries_in_cache       1 
+ create database mysqltest; 
+ create table mysqltest.t1 (i int not null auto_increment, a int, primary key 
(i)); 
+ select * from mysqltest.t1; 
+ i     a 
+ show status like "Qcache_queries_in_cache"; 
+ Variable_name Value 
+ Qcache_queries_in_cache       2 
+ drop database mysqltest; 
+ show status like "Qcache_queries_in_cache"; 
+ Variable_name Value 
+ Qcache_queries_in_cache       0 
+ drop table t1; 
+ set GLOBAL query_cache_size=0; 
 

Suggested fix:
fix Query_cache::invalidate(char *db)

ChangeSet 
  1.1623 03/11/20 18:12:49 bell@sanja.is.com.ua +3 -0 
  database invalidation invalidate queries only of given database (BUG#1898)

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.