MySQL Database

Table 1-288 Supported Configuration Metrics for MySQL Database

Metric Group Name Unit Description
Character Set Instance N/A MySQL Instance
Character Set Character Set GB Character set

MySQL Cluster Memory Capacity

Data Node Identifier N/A Data node identifier
MySQL Cluster Memory Capacity Data Memory Capacity GB Data memory capacity (for each Data Node Identifier)
MySQL Cluster Memory Capacity Index Memory Capacity GB Index memory capacity (for each Data Node Identifier)
MySQL Cluster Memory Capacity Long Buffer Capacity GB Long buffer capacity (for each Data Node Identifier)
MySQL Cluster Memory Capacity Redo Log Buffer Capacity GB Redo log buffer capacity (for each Data Node Identifier)

Table 1-289 Supported Configuration Metrics for Relational Database

Metric Group Name Unit Description
Creation Date Creation Date N/A Date when the database was created
Total Memory Capacity Host Memory GB Total host memory capacity in GB
Resource Allocation Instance Name N/A RDB Instance
Resource Allocation Host Name N/A Host name of the instance
Resource Allocation Total CPUs N/A total number of CPUs allocated or available in this instance
Resource Allocation Total Memory GB Total amount of usable Physical RAM allocated or available to this instance.
Lookup Config Metrics Value NA Value

Table 1-290 Supported Configuration Metrics for Hosted Target

Metric Group Name Unit Description
Resource Allocation Total CPUs N/A Total number of CPUs allocated or available to the entity
Resource Allocation Total Memory GB Total amount of usable Physical RAM allocated or available to the entity

Table 1-291 Supported Status and Performance Metrics for MySQL Database

Metric Group Category Name Unit Description
MySQL Instances Status Response Instance N/A MySQL Instance
MySQL Instances Status N/A Status N/A MySQL instance status
Throughput Load Instance N/A MySQL Instance
Throughput N/A Active Connections N/A Number of active connections
Throughput N/A Logons Per Sec logons/sec Number of logons per second
Throughput N/A Transactions Per Sec txns/sec Number of transactions per second
Throughput N/A Executions Per Sec executions/sec Number of executions per second
Throughput N/A Bytes Received bytes Number of bytes received
Throughput N/A Bytes Sent bytes Number of bytes sent
Top Wait Events Load Instance N/A MySQL Instance
Top Wait Events N/A Wait Event Name N/A Wait event name
Top Wait Events N/A Total Waits N/A Total number of waits
Top Wait Events N/A Average Wait Time sec Average wait time
Maximum Allowed Connections Capacity Instance N/A MySQL Instance
Maximum Allowed Connections N/A Maximum Allowed Connections N/A Maximum number of allowed connections
Maximum Used Connections Utilization Instance N/A MySQL Instance
Maximum Used Connections N/A Variable Name N/A Variable name
Maximum Used Connections N/A Maximum Used Connections N/A Maximum number of used connections
MySQL Data Nodes Status Response Data Node Identifier N/A Data node identifier
MySQL Data Nodes Status N/A Data Node Status N/A Data node status
MySQL Cluser Nodes Memory Usage Utilization Data Node Identifier N/A Data node identifier
MySQL Cluser Nodes Memory Usage N/A Data Memory Used GB Data memory used
MySQL Cluser Nodes Memory Usage N/A Index Memory Used GB Index memory used
MySQL Cluser Nodes Memory Usage N/A Long Buffer Used GB Long buffer used
MySQL Cluser Nodes Memory Usage N/A Redo Log Buffer Used GB Redo log buffer used
MySQL Cluser Nodes Memory Usage N/A Data Memory Utilization % Data memory utilization
MySQL Cluser Nodes Memory Usage N/A Index Memory Utilization % Index memory utilization
MySQL Cluser Nodes Memory Usage N/A Long Buffer Utilization % Long buffer utilization
MySQL Cluser Nodes Memory Usage N/A Redo Log Buffer Utilization % Redo buffer utilization
MySQL Cluster Disk Page Buffer Load Data Node Identifier N/A Data node identifier
MySQL Cluster Disk Page Buffer N/A Hit N/A Number of requests for pages that were available in buffer
MySQL Cluster Disk Page Buffer N/A Miss N/A Number of requests that had to be read from pages on disk
MySQL Cluster Disk Page Buffer N/A Hit Rate % Disk data read performance
MySQL Cluser CPU Usage Utilization Data Node Identifier N/A Data node identifier
MySQL Cluser CPU Usage N/A CPU Used by Data Node sec CPU used by all threads in data node in the last collection interval
MySQL Cluster Tablespaces Utilization Data Node Identifier N/A Data node identifier
MySQL Cluster Tablespaces N/A Tablespace Name N/A Tablespace name
MySQL Cluster Tablespaces N/A Space used in tablespace GB Space used in tablespace
MySQL Cluster Tablespaces Capacity Total space available in tablespace GB Total space available in tablespace

Note:

MySQL databases don’t support Storage Space Allocated or Storage Space Utilization metrics.

Table 1-292 Supported Status and Performance Metrics for Hosted Target

Metric Group Category Name Unit Description
CPU Utilization CPU Usage sec All CPUs usage during the interval
CPU N/A CPU Utilization % Percentage of CPU that was utilized
CPU N/A Interval sec Interval of metric collection
Memory Load Memory Usage GB Memory used in GB
Memory Utilization Memory Utilization % Percentage of memory that is utilized
Memory N/A Interval sec Interval of metric collection

Table 1-293 Status and Performance Metrics for Generic Target

Metric Group Category Name Unit Description
Response Availability Status N/A Status of the target