6.10 InnoDB Adaptive Hash Activity Metrics

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.