Caching mysql queries

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Beginners question:

I'm a little confused about the working of the mysql-cache. I don't
understand the mechanism. What is it exactly you cash ? The result of a
query ? And what if there are certain records addes or removed ?

Please explain this because I need this knowledge to support a customer
of mine who wants to know this technique in detail.



Re: Caching mysql queries

Peppi wrote:
Quoted text here. Click to load it

Right, the results of a query are cached, if possible.  They are
associated with the exact query that generated the results.

If any records are added or removed or updated in the underlying table,
the cached result set is invalidated and discarded.  The next execution
of that query must be run against the current state of the table.  The
results will be cached again, and that cached copy can be reused while
the table is unchanged.

Quoted text here. Click to load it

Why don't you read the chapter in the documentation and then come back
if you have more specific questions.  Your questions are probably
answered there.

Bill K.

Re: Caching mysql queries

 As you said, more answers were found in the documentation.

Thanks Bill !


Bill Karwin schreef:

Quoted text here. Click to load it

Site Timeline