MySQL クエリーのキャッシュヒット率をSQLで求める方法 - QiitaSELECT @QCACHE_FREE_BLOCKS := VARIABLE_VALUE FROM information_schema.`GLOBAL_STATUS` where VARIABLE_NAME = 'QCACHE_FREE_BLOCKS'; SELECT @QCACHE_FREE_MEMORY := VARIABLE_VALUE FROM information_schema.`GLOBAL_STATUS` where VARIABLE_NAME = 'QCACHE_FREE_MEMORY'; SELECT @QCACHE_HITS := VARIABLE_VALUE FROM information_schema.`GLOBAL_STATUS` where VARIABLE_NAME = 'QCACHE_HITS'; SELECT @QCACHE_INSERTS := V
