Lists the InnoDB Adaptive Hash Activity metrics and provides a brief description of each.
Table 4.8 InnoDB Adaptive Hash Activity Metrics
| Name | Description |
|---|---|
| Hash Node Heap (Total) | The total number of (16Kb) pages allocated to the InnoDB adaptive hash index. |
| Hash Searches Per Sec (Total) | The per second average of the searches within InnoDB satisifiedby the adapative hash index. |
| Hash Table Size (Total) | The total number of array cells allocated to the InnoDB adaptive hash index. |
| Hash Used Cells (Total) | The total number of cells within the hash index array that are in use. This variable is no longer available as of MySQL version 5.1.28. |
| Non Hash Searches Per Sec (Total) | The per second average of the searches within InnoDB not satisified by the adaptive hash index. |