The database we use has a read and write intensive load. Some read queries are heavy.
Unfortunately the Query Cache cannot be used as it is invalidated too quickly.
We wanted to avoid the classic Memcached/MySQL couple to simplify the architecture and decrease connections/latency.
Is there a strategy to add a "time based cache" in MySQL? (ideally per collection)
- Each query group has a different TTL (from 5 seconds to several days).