Why are mysql cache files deleted?

Question

MySQL

Hello!
Made a new folder for mysql query cache - /var/lib/mysql/tmp.
Files are created, but for some reason they are immediately deleted, what is the principle of operation and is it possible to disable this automatic deletion?

Answer 1

This is not a query cache, but temporary tables, and they should be deleted., Because the final result will be stored (if it does not exceed the limits, of course) in the query cache, which is entirely in memory.