Mysql – Query Cache Implementation Details

MySQLquery-cache

I am new to DBA stack exchange & this is my first question. Kindly help me in finding a low level documentation for Query Cache module in MySQL since I am planning to work with the source code of Query Cache. I googled a lot but I was provided with only high level details. Is it available in MySQL website (I tried but not an exhaustive search)? Please help me.

Best Answer

This is the best documentation available for the query cache:

sql_cache.cc

I am not kidding, the header of that file contains the most detailed overview I have ever found. Next thing is the own code, which is on the very same link.

There is a query cache chapter on this book, and this other book, but only 4-5 paragraphs, in the context of its relation with the handlers interface.

Apart from that, you should read the general internals code guide.