I want to clear the cache in information_schema.tables in mysql 5.6 running this query
$this->db->query("SET information_schema_stats_expiry = 0");
but this is not working in 5.6. Is there any otherway to clear cache without upgrading mysql version.