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 |