Information Schema XTRADB_INTERNAL_HASH_TABLES Table
MariaDB starting with 10.0.9
The XTRADB_INTERNAL_HASH_TABLES
table was added in MariaDB 10.0.9.
The Information Schema XTRADB_INTERNAL_HASH_TABLES
table contains InnoDB/XtraDB hash table memory usage information.
The PROCESS
privilege is required to view the table.
It has the following columns:
Column
Description
Column
Description
INTERNAL_HASH_TABLE_NAME
Hash table name
TOTAL_MEMORY
Total memory
CONSTANT_MEMORY
Constant memory
VARIABLE_MEMORY
Variable memory
Example
SELECT * FROM information_schema.XTRADB_INTERNAL_HASH_TABLES;
+--------------------------------+--------------+-----------------+-----------------+
| INTERNAL_HASH_TABLE_NAME | TOTAL_MEMORY | CONSTANT_MEMORY | VARIABLE_MEMORY |
+--------------------------------+--------------+-----------------+-----------------+
| Adaptive hash index | 2217568 | 2213368 | 4200 |
| Page hash (buffer pool 0 only) | 139112 | 139112 | 0 |
| Dictionary Cache | 613423 | 554768 | 58655 |
| File system | 816368 | 812272 | 4096 |
| Lock System | 332872 | 332872 | 0 |
| Recovery System | 0 | 0 | 0 |
+--------------------------------+--------------+-----------------+-----------------+
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?