Documentation Home
Oracle Enterprise Manager for MySQL Database User's Guide
Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb
HTML Download (TGZ) - 223.8Kb
HTML Download (Zip) - 231.3Kb


Oracle Enterprise Manager for MySQL Database User's Guide  /  Metrics  /  InnoDB Adaptive Hash Activity Metrics

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

NameDescription
Hash Node HeapThe total number of (16Kb) pages allocated to the InnoDB adaptive hash index.
Hash Searches Per SecThe per second average of the searches within InnoDB satisified by the adaptive hash index.
Hash Table SizeThe total number of array cells allocated to the InnoDB adaptive hash index.
Hash Used CellsThe 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 SecThe per second average of the searches within InnoDB not satisfied by the adaptive hash index.