A while ago I wrote about MySQL 5.1 information schema
plug-ins.
At the time, I wrote a plug-in to report the contents of the
query cache, but for all kinds of reasons, I never found the time
to write a decent article about it, nor to release the
code.
I am not sure if I'll ever find the time to write that article,
but I just tidied up the code, and installed it in a new MySQL 5.1.26-rc server. It seems to work there, so
I put the code up on the web.
Inside the source file, there's instructions to build and deploy
it. If all goes well, you can do things like:
mysql> select * from information_schema.mysql_cached_queries\G
*************************** 1. row ***************************
STATEMENT_ID: 1
SCHEMA_NAME: test
STATEMENT_TEXT: select count(*) from world.city
RESULT_BLOCKS_COUNT: 1
RESULT_BLOCKS_SIZE: 512
RESULT_BLOCKS_SIZE_USED: 106
1 row in set (0.00 sec)
Are you interested in this plugin-in? Do you have any
suggestions? Download it, and put your comments here.