Details
Description
Hi guys, long time ago (2006) i request a feature at mysql dev team, and it was too easy that a 15old years guy done it
i want to know inoformation about query cache, like a select * from query_cache
there´s more information at http://bugs.mysql.com/bug.php?id=23714
this help a lot when debuging and checking what´s the best policy to use with query cache
Gliffy Diagrams
Attachments
Issue Links
- relates to
-
MDEV-4516 SELECT from I_S.QUERY_CACHE_INFO produces ER_UNKNOWN_ERROR when query cache size is 0
-
- Closed
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
only running
select * from query_cache_info;
/* Affected rows: 0 Registros encontrados: 1 Avisos: 0 Duração de 1 query: 0,015 sec. */
select * from query_cache_info;
/* Erro SQL (6): Error on delete of 'C:\Users\Beto\AppData\Local\Temp#sqlc24_7_1a6.MAD' (Errcode: 13) */
very fast, i get the same error sql(6), errcode:13
show warnings
"Level" "Code" "Message"
"Error" "6" "Error on delete of 'C:\Users\Beto\AppData\Local\Temp#sqlc24_7_1a6.MAD' (Errcode: 13)"
flush query cache; stop working...
Qcache_queries_in_cache=1
select * from query_cache_info -> return 1 row
FLUSH QUERY CACHE;
Qcache_queries_in_cache=1
select * from query_cache_info -> return 1 row (the same row)
flush tables work
Qcache_queries_in_cache=1
select * from query_cache_information -> return 1 rows
flush tables
Qcache_queries_in_cache=0
select * from query_cache_information -> return 0 rows
DELETE FROM `QUERY_CACHE_INFO` WHERE `STATEMENT_SCHEMA`='information_schema' AND `STATEMENT_TEXT`='select SQL_CACHE * from test.a where b like \'ab%\'' AND `RESULT_BLOCKS_COUNT`=1 AND `RESULT_BLOCKS_SIZE`=23936 AND `RESULT_BLOCKS_SIZE_USED`=23935 LIMIT 1;
don't work... but i think it will not work since delete isn't implemented 
well =) very nice job guys!!!
please disconsider this comments
putting they in MDEV-4516
thanks!
I'll try to look at Roland Bouman's I_S plugin and see if we could bundle it