Category

Caching

Caching, MySQL
How to improve MySQL query cache hit ratio
12.13.07 | Permalink | Comment?

I have already mentioned one of the downside of MySQL query cache, query invalidation. Each time when you insert/update/delete records from the table, cached queries from that table will be invalidated even if the edited records are not in the cached subset.
The simple way to improve MySQL query cache hit ratio is not to update […]
Caching, MySQL
MySQL query cache
12.09.07 | Permalink | 1 Comment

On the Internet, caching is everything. Domain name servers cache your DNS records, proxies and browsers tries to cache your content, your’s server’s OS cache frequently used files into the memory… Although these are all different types of caching, they all have one thing in common, they improves overall performance of the system.
If you want […]