InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Does Mysql 5.6 Have A Query Cache? Does It Work On Server, Instance Or Database? |
|
Answer» Yes. The query cache operates on the SERVER level, CACHING complete result sets matched with the ORIGINAL query string. If an exactly identical query is made (which often happens, particularly in web applications), no parsing or execution is necessary; the result is sent directly from the cache. Various tuning options are available. Yes. The query cache operates on the server level, caching complete result sets matched with the original query string. If an exactly identical query is made (which often happens, particularly in web applications), no parsing or execution is necessary; the result is sent directly from the cache. Various tuning options are available. |
|