Guys i'm with doubt about view and query cachecheck:reset query cache;create table t (a int);insert into t values (1);insert into t values (2);create view v as select * from t;select * from teste.v;select * from information_schema.QUERY_CACHE_QUERIES; (from mdev-4682)select * from information_schema.QUERY_CACHE_QUERIES_tables; (from mdev-4682)select * from information_schema.QUERY_CACHE_tables; (from mdev-4682)at 2 last command, i got this:|| *QUERY_CACHE_ID* || *SCHEMA* || *TABLE* |||| 1 || teste || |||| 1 || teste || t |||| *TABLE_SCHEMA* || *TABLE_NAME* || *TABLE_HASHED* || *TABLE_TYPE* || *QUERIES_IN_CACHE* |||| teste || t || 1 || NON_TRANSACT || 1 |||| teste || || 1 || NON_TRANSACT || 1 ||the table "" shouldn't be "v" view? why it's blank?--Roberto Spadim