Re: SQL CACHE Not used. When it should be?

[Rick James]

How slow is
SELECT NO_SQL_CACHE * FROM MYUSERTABLE WHERE NAME=SUBSTRING_INDEX(USER(),'@',1);
without the Query cache? Is it really that slow?

That is probably not cached because the value "USER()" varies between users.

Will MYUSERTABLE be changed much? If it is changed frequently, the Query cache may be of little use anyway! Remember, _all_ entries for a table are purged whenever _any_ row is modified or inserted into that table.

SHOW TABLE STATUS LIKE 'MYUSERTABLE'; -- I would like to see its size and engine.
SHOW CREATE TABLE MYUSERTABLE; -- do you have an index on NAME?