HTN20190109 https://blog.hatena.ne.jp/HTN20190109/ HTN20190109の日記 https://htn20190109.hatenablog.com/ DB Oracle SELECT 1-(phy.value/(cur.value+con.value)) "cache hit ratio" FROM v$sysstat cur, v$sysstat con, v$sysstat phy WHERE cur.name = 'db block gets from cache' AND con.name = 'consistent gets from cache' AND phy.name = 'physical reads cache' ; MySQL http://parameter.jp/post-265/ show engine innodb … 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2019%2F07%2F09%2F013857" title="キャッシュヒット率 - HTN20190109の日記" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2019-07-09 01:38:57 rich https://htn20190109.hatenablog.com/entry/2019/07/09/013857 1.0 100%