Question : I would like to make some timing tests in my PostgreSQL database. I would like to clear cache […]
Tag: cache
Columns count in SELECT query and SQL Server buffer cache
Question : Let’s assume that I have a table with 30-50 millions records. It has ~40 columns. Currently when I […]
Is there any way to disable MongoDB’s cache?
Question : I’m not getting recent data when querying, and I believe it has to do with cache. Probably, MongoDB’s […]
Sudden performance decrease in SQL Server
Question : I’ve got a problem with a SQL Server 2008 R2 instance. Last week the performance suddenly broke down. […]
Query_cache doesn’t work with join
Question : I have a simple join query, but for some reason query_cache won’t cache it! SELECT id, news, approve, […]
MySQL cache is not getting hit by subqueries
Question : I noticed something weird on MySQL query_cache behavior and I would like to know if this is a […]
Qcache_free_memory not full yet I get alot of Qcache_lowmem_prunes
Question : I just started dabbling with the query cache for our CMS. Can anyone tell me (or at least […]
Does MySQL/InnoDB use table caches when dealing with foreign tables?
Question : TL;DR: Does a table referred to via schema.table get held in table cache? I have a large number […]
Oracle 11.2 using too few memory
Question : it is about one year that I have changed my server from Oracle 10g to 11.2g (and also […]
Caching queries that last longer then then X seconds
Question : Let’s assume that I want work with query cache enabled. For example let’s set it to 128mb value […]