Feasible method for clearing mysql Query cache _ MySQL

Mysql caches the same SQL statement and completes it in an instant during the second run. to clear the cache, you can use the following method to optimize an SQL statement, it was found that a slow SQL statement (nearly 1 minute) was completed in an instant during the second operation (0.00sec)

This is because mysql caches the same SQL statement. the server directly reads data from the cache of the last query result instead of re-analyzing and executing the SQL statement.

You can clear the query cache using the following methods:

Reset query cache;