mozilla
Increase cache hit rate
Our table cache hit rate currently stands at 0.85 and is consistently below the recommended value of 0.99. In such case it is recommended to upgrade database plan for more RAM.
As per the docs, the best way to understand what plan is best for your workload is to try them.
Our initial testing didn't show significant gains, but that could have been caused by cold cache.
Upgraded plan on prod to Standard 2 today. Let's observe how that affects the cache hit rate and the overall performance.
Table cache hit rate seems to be constantly at 98%. Do we want to keep this open?
Let's close it. Bumping the plan clearly improved the hit rate and the next DB plan is much more expensive.
The best next step for further increasing the hit rate is probably #2938.