Module transparent caching mysql queries in memcached

0 like 0 dislike
30 views
Is there a subject, as the perl module?
I would like to make requests, not thinking that there's a frontend in the form of memcached, and the backend in mysql.
by | 30 views

3 Answers

0 like 0 dislike
"Transparent caching" is, in mysql.
It is so good and transparent works, what about him don't even know.
The problem arises when you need the cache to invalidinput. For example, updating some records. So you invented transparent caching will be forced to repeat the behavior of the mysql cache to remove all queries containing the table to update. So why write what is already written?
\r
Hence the conclusion: if you want something to accelerate faster cache mysql caching should be transparent. For each operator should at least specify the estimated lifetime of the result in the cache.
by
0 like 0 dislike
However, try to pick up the script for mysql-proxy: github.com/clofresh/mysql-proxy-cache
of course it will cache all ignoring the logic of the application.
\r
I do not quite understand why would you need such a solution.
Built-in caching of queries can be controlled explicitly through keywords SQL_CACHE and SQL_NO_CACHE.
by
0 like 0 dislike
Memcached::Client not satisfied?
by

Related questions

0 like 0 dislike
1 answer
asked Jun 5, 2019 by kiranananda
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
asked Jun 4, 2019 by tuxx
0 like 0 dislike
1 answer
asked May 20, 2019 by McMike
0 like 0 dislike
2 answers
110,608 questions
257,186 answers
0 comments
28,758 users