Bug #79806 DD does not clear the cache mem properly
Submitted: 29 Dec 2015 15:05 Modified: 25 Jan 2016 14:12
Reporter: Sayantan Dutta Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:mysql-trunk OS:Any
Assigned to: CPU Architecture:Any

[29 Dec 2015 15:05] Sayantan Dutta 
Description:
The commands FLUSH TABLES, FLUSH STATUS should free the cache, however performance_schema global_variables and global_status variables are not flushed from the cache.

It results in a sporadic failure
http://pb2.no.oracle.com/?template=mysql_show_test_failure&search=yes&push_id=8853722&test... 

where the fetch commands are not repeated and hence are missing form the result file.

How to repeat:
The link above in pb2 can be used.

add something like
show global variables like "performance_schema1%";
show global status like "performance_schema1%"; 

in perfschema.privilege_table_io test

before any of the flushes.
[25 Jan 2016 14:12] Paul DuBois 
Fixed in 5.8.0.

Bug affects no released version. No changelog entry needed.