MySQL set query cache _mysql

You can use the following statement
Query_cache_size = 268435456
Query_cache_type = 1
Query_cache_limit = 1048576
Deposit to [mysqld] of/etc/my.cnf file
Then restart the MySQL database
Service mysqld Restart
will start the MySQL caching mechanism query cache. In use, the query cache stores the text of a SELECT query and the corresponding results that are delivered to the client.
If you receive a similar query later, the server retrieves the results from the query cache instead of parsing and executing the same query again.
Note: The query cache never returns expired data. When the data is modified, any related entries in the query cache are dumped and purged.
For tables where changes are not too frequent and a large number of identical queries