Key_blocks_not_flushed
This page is part of MariaDB's Documentation.
The parent of this page is: Status Variables for MariaDB Enterprise Server
Topics on this page:
Overview
Shows the number of MyISAM key cache blocks which have been modified but not flushed to disk.
DETAILS
Scope | Global |
Data Type |
|
The Key_blocks_not_flushed status variable shows the number of MyISAM key cache blocks which have been modified but not flushed to disk.
EXAMPLES
Show Value with SHOW STATUS
SHOW GLOBAL STATUS statement can show the global value:
SHOW GLOBAL STATUS
LIKE 'Key_blocks_not_flushed';
Since this status variable is only global scope, SHOW STATUS and SHOW SESSION STATUS also show the global value.
Information Schema
The information_schema.GLOBAL_STATUS table can be queried to obtain the global value:
SELECT *
FROM information_schema.GLOBAL_STATUS
WHERE VARIABLE_NAME LIKE 'Key_blocks_not_flushed';
This status variable is only global scope, so the information_schema.SESSION_STATUS table can also be queried to obtain the global value:
SELECT *
FROM information_schema.SESSION_STATUS
WHERE VARIABLE_NAME LIKE 'Key_blocks_not_flushed';