Key_blocks_warm
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 in the warm list.
DETAILS
Scope | Global |
Data Type |
|
The Key_blocks_warm status variable shows the number of MyISAM key cache blocks in the warm list.
EXAMPLES
Show Value with SHOW STATUS
SHOW GLOBAL STATUS statement can show the global value:
SHOW GLOBAL STATUS
LIKE 'Key_blocks_warm';
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_warm';
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_warm';