MySQL Database

Table 1-272 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-273 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.

Table 1-274 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-275 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-276 Supported Status and Performance Metrics for Relational Database

Metric Group Category Name Unit Description

Database Resource Stats

 

Instance ID

NA

RDB instance

Database Resource Stats

 

Host Name

NA

Host name of the instance

Database Resource Stats

Response

RDB Instance CPU Time

sec

CPU time used by the instance

Database Resource Stats

 

RDB Instance CPU collection Interval

sec

collection interval

Database Resource Stats

Response

RDB Aggregated CPU Time

sec

Aggregated CPU time used by DB

Database Resource Stats

 

RDB Aggregated CPU interval

sec

collection interval time

Database Resource Stats

Load

RDB Instance Memory

GB

Memory consumed by instance in GB

Database Resource Stats

 

RDB Instance Memory interval

sec

Memory Collection interval

Database Resource Stats

Load

Aggregated RDB Memory

GB

Aggregated memory consumed by DB in GB

Database Resource Stats

 

Aggregated RDB Memory interval

sec

Aggregated memory usage collection interval

Database Resource Stats

Load

RDB Instance I/O Bandwidth Usage

MB/sec

I/O bandwidth usage for db instance

Database Resource Stats

Load

RDB Instance I/O Per Second

IOPS

I/O per second rate for instance.

Database Resource Stats

Load

RDB Instance I/O interval

sec

IO rate collection interval

Database Resource Stats

Load

Aggregated DB I/O Bandwidth Usage

MB/sec

Aggregated I/O bandwidth usage for DB

Database Resource Stats

Load

Aggregated DB I/O Per Second

IOPS

Aggregated IO per second rate for DB

Storage Usage By Tablespace

 

Storage Tablespace Name

NA

Tablespace Name

Storage Usage By Tablespace

Capacity

Total Space Allocated

GB

Total size of a tablespace's datafiles in GB

Storage Usage By Tablespace

Utilization

Space Utilization Percentage

%

Percent of storage space utilized

Storage Usage By Tablespace

Load

Space Used

GB

Tablespace used in GB

Storage Space Usage

Utilization

Storage Space Allocated

GB

Storage space allocated in GB

Storage Space Usage

Utilization

Storage Space Utilization

%

Percent of storage space utilized

Storage Space Usage

Load

Space Used

GB

Storage space used in GB

Load

Load

Logons

NA

The number of logons during the last collection interval

Load

Load

Logons Rate

logons/sec

Number of logons per second during the last collection interval

Load

Load

Transactions

NA

Number of transactions during the last collection interval

Load

Load

Transactions Rate

txns/sec

Number of transactions per second during the last collection interval

Load

Load

Executions

NA

Number of executions during the last collection interval

Load

Load

Execution Rate

executions/sec

Number of executions per second during the last collection interval

Load

Load

Network I/O

bytes

Number of bytes sent and received over the network during the last collection interval

Load

Load

Network I/O Rate

bytes/sec

Network I/O in bytes/second during the last collection interval

Top SQL Executions

Load

SQL ID

NA

Unique Identifier for the SQL statement

Top SQL Executions

Load

Top SQL Text

NA

SQL text of the top-ranked SQL

Top SQL Executions

Response

Execution Count

NA

Execution Count of the top-ranked SQL

Top SQL Executions

Response

Total Elapsed Time

ms

Total time used to execute the SQL statement. This includes CPU time and wait time

I/O Per Second

Load

I/O Per Second

IOPS

I/O per second.

I/O Per Second

Load

I/O Bandwidth Usage

MB/sec

I/O bandwidth usage during the last collection interval

Instance CPU

Utilization

Instance ID

NA

RDB instance

Instance CPU

Utilization

Host Name

NA

Host name of the instance

Instance CPU

Utilization

CPU Usage

sec

All CPUs usage during the interval for this instance

Instance CPU

Utilization

CPU Utilization

%

Percentage of CPU that was utilized in this instance

Instance CPU

 

Interval

sec

Interval of metric collection

Instance Memory Usage

Utilization

Instance ID

NA

RDB instance

Instance Memory Usage

Utilization

Host Name

NA

Host name of the instance

Instance Memory Usage

Utilization

Instance Memory Usage

GB

Memory used in GB

Instance Memory Usage

Utilization

Memory Utilization

%

Percentage of memory that is utilized in this instance

Instance Memory Usage

 

Interval

sec

Interval of metric collection

I/O Per Second Instance Level

Load

Instance ID

NA

RDB instance

I/O Per Second Instance Level

Load

Host Name

NA

Host name of the instance

I/O Per Second Instance Level

Load

I/O Per Second

IOPS

I/O per second for this instance

I/O Per Second Instance Level

Load

I/O Bandwidth Usage

MB/sec

I/O bandwidth usage during the last collection interval for this instance

I/O Per Second Instance Level

 

Interval

sec

Interval of metric collection

Database Activity

 

Instance ID

NA

RDB instance

Database Activity

 

Host Name

NA

Host name of the instance

Database Activity

Load

CPU Time

sec

CPU time (in seconds) of foreground sessions

Database Activity

Load

Wait Time

sec

Wait time (in seconds) of foreground sessions

Database Activity

Load

I/O Time

sec

I/O time (in seconds) of foreground sessions

Database Activity

 

Interval

sec

Interval of metric collection

Instance Load

 

Instance ID

NA

RDB instance

Instance Load

 

Host Name

NA

Host name of the instance

Instance Load

Load

Logons

NA

The number of logons during the last collection interval

Instance Load

Load

Logons Rate

logons/sec

Number of logons per second during the last collection interval

Instance Load

Load

Transactions

NA

Number of transactions during the last collection interval

Instance Load

Load

Transactions Rate

txns/sec

Number of transactions per second during the last collection interval

Instance Load

Load

Executions

NA

Number of executions during the last collection interval

Instance Load

Load

Executions Rate

executions/sec

Number of executions per second during the last collection interval

Instance Load

Load

Network I/O

bytes

Number of bytes sent and received over the network during the last collection interval

Instance Load

Load

Network I/O Rate

bytes/sec

Network I/O in bytes/second during the last collection interval

Instance Load

 

Interval

sec

Interval of metric collection

SQL Statistics

 

SQL ID

NA

SQL ID

SQL Statistics

 

Plan Hash Value

NA

Numerical representation of the SQL plan for the cursor

SQL Statistics

Load

Executions

NA

Number of times the SQL statement was executed

SQL Statistics

Response

Elapsed Time

ms

Total time (in milliseconds) used by this SQL for parsing, executing and fetching

SQL Statistics

N/A

Interval

sec

Interval of metric collection

Table 1-277 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-278 Status and Performance Metrics for Generic Target

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