Key_write_requests
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 write requests made to the MyISAM key cache, even if the dirty blocks have not yet been written to the underlying storage.
DETAILS
Scope | Global |
Data Type |
|
The Key_write_requests status variable shows the number of write requests made to the MyISAM key cache, even if the dirty blocks have not yet been written to the underlying storage.
For information about how to configure the key buffer size and compute the miss and write rates in the key cache, see key_buffer_size.
EXAMPLES
Show Value with SHOW STATUS
SHOW GLOBAL STATUS statement can show the global value:
SHOW GLOBAL STATUS
LIKE 'Key_write_requests';
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_write_requests';
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_write_requests';