Key_writes
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 writes made to the MyISAM key cache where the dirty blocks have already been written to the underlying storage.
DETAILS
Scope | Global |
Data Type |
|
The Key_writes
status variable shows the number of writes made to the MyISAM key cache where the dirty blocks have already 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_writes';
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_writes';
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_writes';