Oracle Enterprise Manager for MySQL Database
Lists the InnoDB Adaptive Hash Activity metrics and provides a brief description of each.
Table 6.10 InnoDB Adaptive Hash Activity Metrics
| Name | Description |
|---|---|
| Hash Node Heap | The total number of (16Kb) pages allocated to the InnoDB adaptive hash index. |
| Hash Searches Per Sec | The per second average of the searches within InnoDB satisified by the adaptive hash index. |
| Hash Table Size | The total number of array cells allocated to the InnoDB adaptive hash index. |
| Hash Used Cells | 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 | The per second average of the searches within InnoDB not satisfied by the adaptive hash index. |