Logical queries that are cached and those that are not

Question

I am using PHP with MySQL 5.6 for my project, and I wanted to test and register which of my queries are cached and which are not.

I know that if the same query is repeatedly and repeatedly sent to the database, it retrieves the result from the cache, rather than retrieving from the database. Now, this is what I want to check, because I want to optimize my queries.

Now how do I do this? Is there any way?

Thanks in advance.

Answer 1

, , , . , MySQL, EXPLAIN .

https://dev.mysql.com/doc/refman/5.6/en/slow-query-log.html

- " , ". : , . , MySQL, , -, - : MySQL? (Qcache_queries_in_cache)