Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 5.5.31
-
Fix Version/s: 5.5.32
-
Component/s: None
-
Labels:None
Description
MariaDB [test]> set global query_cache_size = 1024*1024; Query OK, 0 rows affected (0.00 sec) MariaDB [test]> select * from information_schema.query_cache_info; Empty set (0.00 sec) MariaDB [test]> set global query_cache_size = 0; Query OK, 0 rows affected (0.00 sec) MariaDB [test]> select * from information_schema.query_cache_info; ERROR 1105 (HY000): Unknown error
bzr version-info
revision-id: monty@askmonty.org-20130512082916-vjlzg3tjtlbvnowy revno: 3759 branch-nick: 5.5
Gliffy Diagrams
Attachments
Issue Links
- relates to
-
MDEV-249 QUERY CACHE INFORMATION
-
- Closed
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
set global query_cache_type=0, global query_cache_size=1000000;
get the same error code
/* Erro SQL (1105): Unknown error */
this is a "patch" (my first one in mariadb!! =) )
diff -u qc_info.old.cc qc_info.cc > diff_qc_info.cc
of mariadb 5.5.31 query cache plugin
i did more checks about query_cache_size and query_cache_type
i put more columns too (please review since i don't know very well what i'm doing)
that's all =)
Thanks! But this particular bug is already fixed. Could you create a new issue — for adding more columns to the table — and attach your patch there please?
yes, it's: MDEV-4581
MDEV-249have more information about others errors1)flush query cache don't work (DISCONSIDER THIS, I SHOULD USE reset query cache)
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 works...
Qcache_queries_in_cache=1
select * from query_cache_info -> return 1 row
FLUSH TABLES;
Qcache_queries_in_cache=0
select * from query_cache_info -> return 0 row
-------
uninstall plugin QUERY_CACHE_INFO;
Qcache_queries_in_cache=1;
flush query cache;
Qcache_queries_in_cache=1;
that's not a plugin problem, maybe a mariadb query cache problem
2)
"select * from query_cache_information"
many times per second (press f5 in heidisql and leave pressed)
give errors some times, errcode=13 (no permission?) sql err=6 (problem deleting file)
show warnings
"Level" "Code" "Message"
"Error" "6" "Error on delete of 'C:\Users\Beto\AppData\Local\Temp#sqlc24_7_1a6.MAD' (Errcode: 13)"
file #sqlc24_7_1a6.MAD
http://www.megafileupload.com/en/file/420206/-sqlc24-7-1a6-MAD.html
sorry there wasn't another open place to upload a binary file
hum.. temporary file isn't deleted
my temporary folder have about 10 files like this
#sqlc24_7_16e.MAD
#sqlc24_7_16c.MAD
#sqlc24_7_2d4.MAD
#sqlc24_7_2b8.MAD
....
3)when query_cache_size=0
set global query_cache_size=0;
select * from `information_schema`.`QUERY_CACHE_INFO`;
/* Erro SQL (1105): Unknown error */
4)DELETE?
could we delete some query cached? ok =) not now, but maybe in future?
5)more columns
i don't know if we have this information but, could be nice have a hit_count per query
6)how to use "query_cache_strip_comments" var?
what it do? how to use it?