Re: Is there a known pattern for creating caches of data?

[Rick James]

CREATE TABLE new LIKE cache;
Populate new. (Note: the LIKE will already have the indexes.)
RENAME TABLE cache TO old, new TO cache;
DROP TABLE old;

Since the RENAME is atomic, you will never see "no such table".