MySQL Query Cache - What is Query Cache in MySQL?

What is Query Cache in MySQL?

Query Cache in MySQL is used in scenarios when the same queries need to be executed on the same data set. These queries also return the same result. Query cache is most useful when there are tables that are not expected to change very often. It is important to note that the query cache does not return old data. If the tables are modified, any important entries in the query cache are flushed.
MySQL Exception - How is Exception Handling handled in MySQL?
MySQL Exception - Exception handling means changing the usual expected flow of the code. This needs to be done to avoid errors....
MySQL - What are the Performance and Scalability characteristics of MySQL?
MySQL Performance and Scalability - MySQL has a unique storage engine architecture that makes it adaptable to most servers. MySQL meets the expectations of....
MySQL limitations - What are the limitations of mysql in Comparison of Oracle?
MySQL limitations - Transactions are better supported in Oracle as compared to Mysql. ROLE feature is available....
Post your comment