Monitoring Agent for MySQL metrics

The metrics for Monitoring Agent for MySQL resource types collect data for monitoring with IBM Cloud Pak for Multicloud Management. Every Monitoring Agent for MySQL resource type defines a set of dimensions and metrics. The descriptions provide such information as data type, dimension key, and metric unit.

Resource mySQLDatabase

Set of Databases of MySQL server that shows monitoring metrics of particular database. The following section lists the metrics, dimensions and components of Resource mySQLDatabase.

Metrics

The following metrics are available for the resource.

Data Length

• DATA_LENGTH is the length of the data file, in MB.
• The type is double.
• The unit is megabytes.

Database Size

• Show total length (index length + data length).
• The type is double.
• The unit is megabytes.

Index Length

• INDEX_LENGTH is the length of the index file, in MB.
• The type is double.
• The unit is megabytes.

Number of Tables

• Shows total number of tables.
• The type is int.
• The unit is tables.

Dimensions

The following dimensions are available for the resource.

Instance Name

• The instance name of the agent representing this MySQL.
• The type is string.

IP Address

• The IP address of the MySQL server.
• The type is string.

Node

• Originnode.
• The type is string.

Port

• The configured MySQL port.
• The type is string.

Table Schema

• Shows table Schema Name.
• The type is string.

Timestamp

• This is the local time when the data was collected. This is available for thresholds, but not in the UI.
• The type is timestamp.

Component: Database Events

Events generated by MySQL, from the table EVENTS. The following section lists the metrics and dimensions of Component Database Events.

Metrics

The following metrics are available for the component.

Events Created

• When this event was created.
• The type is string.
• The unit is events.

Events Definer

• The account of the user who defined this event.
• The type is string.
• The unit is definer.

Events Ends

• The end time for a repeated event (if defined).
• The type is timestamp.
• The unit is timestamp.

Events Event Comment

• User comment for this event.
• The type is string.
• The unit is comment.

Events Event Definition

• The statement triggered by this event.
• The type is string.
• The unit is definition.

Events Event Type

• The repetition type of this event.
• The type is string.
• The unit is eventType.

Events Execute At

• The time specified for a one time event.
• The type is timestamp.
• The unit is timestamp.

Events Interval Field

• The interval's units specified for a repeating event.
• The type is string.
• The unit is intervalField.

Events Interval Value

• The interval specified for a repeating event.
• The type is string.
• The unit is intervalValue.

Events Last Altered

• When this event was last altered. This is available for thresholds, but not in the UI.
• The type is timestamp.
• The unit is timestamp.

Events Last Executed

• When this event was last executed.
• The type is timestamp.
• The unit is timestamp.

Events Originator

• The server ID of the originating server for this event (or 0 if not replicated).
• The type is int.
• The unit is event.

Events Preserve on Completion

• Whether to preserve this event upon completion.
• The type is string.
• The unit is preserveOnCompletion.

Events Starts Time

• The start time for a repeated event (if defined).
• The type is timestamp.
• The unit is timestamp.

Events Status

• Whether this event is enabled, disabled, or enabled on a slave server.
• The type is string.
• The unit is status.

Dimensions

The following dimensions are available for the component.

Events Character Set Client

• The session client character set in use when the event was created. This is available for thresholds, but not in the UI.
• The type is string.

Events Collation Connection

• The session collation connection in set when the event was created. This is available for thresholds, but not in the UI.
• The type is string.

Events Database COllation

• The collation of the database for this event. This is available for thresholds, but not in the UI.
• The type is string.

Events Event Body

• The language of 'DO' text for this event. This is available for thresholds, but not in the UI.
• The type is string.

Events Event Catalog

• The catalog for this event.
• The type is string.

Events Event Name

• The name of this event.
• The type is string.

Events Event Schema

• The schema for this event.
• The type is string.

Events Node

• Originnode.
• The type is string.

Events SQL Mode

• The server's SQL mode when this event was created. This is available for thresholds, but not in the UI.
• The type is string.

Events Timestamp

• This is the local time when the data was collected. This is available for thresholds, but not in the UI.
• The type is timestamp.

Events Timezone

• The time zone for this event.
• The type is string.

Component: Database Process List

Information regarding running threads, from the table PROCESSLIST. The following section lists the metrics and dimensions of Component Database Process List.

Metrics

The following metrics are available for the component.

DB Process List Command

• The type of command this thread is executing.
• The type is string.
• The unit is command.

DB Process List Host

• The host name responsible for spawning this thread.
• The type is string.
• The unit is host.

DB Process List Information

• Extra information regarding this thread.
• The type is string.
• The unit is information.

DB Process List State

• The state of this thread.
• The type is string.
• The unit is state.

DB Process List Time

• The time this thread has been executing this command.
• The type is int.
• The unit is seconds.

DB Process List User

• The user responsible for spawning this thread.
• The type is string.
• The unit is user.

Dimensions

The following dimensions are available for the component.

DB Process List Database Name

• The database this thread is using.
• The type is string.

DB Process List Id

• The ID of this thread.
• The type is int.

DB Process List Node

• Originnode.
• The type is string.

DB Process List Timestamp

• This is the local time when the data was collected. This is available for thresholds, but not in the UI.
• The type is timestamp.

Component: Database Schemata

Information about the MySQL Databases, from the table SCHEMATA. The following section lists the metrics and dimensions of Component Database Schemata.

Metrics

The following metrics are available for the component.

Catalog Name

• The catalog name for this database. This is available for thresholds, but not in the UI.
• The type is string.
• The unit is name.

Default Character Set Name

• The default character set for this database.
• The type is string.
• The unit is name.

Default Collation Name

• The default collation for this database.
• The type is string.
• The unit is name.

Schemata Sql Path

• The SQL path for this database.
• The type is string.
• The unit is path.

Dimensions

The following dimensions are available for the component.

Schema Name

• The name of this database.
• The type is string.

Schemata Node

• Originnode.
• The type is string.

Schemata Timestamp

• This is the local time when the data was collected. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is timestamp.

Resource mySQLInstance

Instances that shows monitoring metrics for MySQL server. The following section lists the dimensions and components of Resource mySQLInstance.

Dimensions

The following dimensions are available for the resource.

Agent Configuration Instance Name

• The instance name of the agent representing this MySQL.
• The type is string.

Agent Configuration IP Address

• The IP address of the MySQL server.
• The type is string.

Agent Configuration Node

• Originnode.
• The type is string.

Agent Configuration Port

• The configured MySQL port.
• The type is string.

Agent Configuration Timestamp

• This is the local time when the data was collected. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is timestamp.

Component: Global Status Info

It provides information about the uptime days, bytes sent and bytes received for MySQL server. The following section lists the metrics and dimensions of Component Global Status Info.

Metrics

The following metrics are available for the component.

Global Status Bytes Received

• The number of bytes sent to or received from all clients.
• The type is int.
• The unit is bytes.

Global Status Bytes Sent

• The number of bytes sent to all clients.
• The type is int.
• The unit is bytes.

Global Status Uptime Days

• The number of days since the MySQL server was started.
• The type is int.
• The unit is days.

Dimensions

The following dimensions are available for the component.

Global Status Node

• Originnode.
• The type is string.

Global Status Timestamp

• This is the local time when the data was collected. This is available for thresholds, but not in the UI.
• The type is timestamp.

Component: Instance Application Availability

Provides information on availability of the MySQL service. The following section lists the metrics and dimensions of Component Instance Application Availability.

Metrics

The following metrics are available for the component.

Application Availability Status

• The status of the MySQL service, such as up or down.
• The type is string.
• The unit is status.

Dimensions

The following dimensions are available for the component.

Application Availability FQDN

• Fully qualified domain name of this server.
• The type is string.

Application Availability Node

• Originnode.
• The type is string.

Application Availability Timestamp

• This is the local time when the data was collected. This is available for thresholds, but not in the UI.
• The type is timestamp.

Component: Instance Buffer Pool Size

It provides information about database size , number of tables in database. The following section lists the metrics and dimensions of Component Instance Buffer Pool Size.

Metrics

The following metrics are available for the component.

Buffer Pool Size Data Length

• DATA_LENGTH is the length of the data file, in MB.
• The type is double.
• The unit is megabytes.

Buffer Pool Size Database Size

• Show total length (index length + data length).
• The type is double.
• The unit is megabytes.

Buffer Pool Size Index Length

• INDEX_LENGTH is the length of the index file, in MB.
• The type is double.
• The unit is megabytes.

Buffer Pool Size Number of Tables

• Shows total number of tables.
• The type is int.
• The unit is tables.

Dimensions

The following dimensions are available for the component.

Buffer Pool Size Node

• Originnode.
• The type is string.

Buffer Pool Size Table Schema

• Shows table Schema Name.
• The type is string.

Buffer Pool Size Timestamp

• This is the local time when the data was collected. This is available for thresholds, but not in the UI.
• The type is timestamp.

Component: Instance Database CPU

It provide information about the percentage of total CPU usage of mysqld process. The following section lists the metrics and dimensions of Component Instance Database CPU.

Metrics

The following metrics are available for the component.

Database CPU Database CPU Usage

• The total CPU usage percentage of mysqld process.
• The type is double.
• The unit is percent.

Dimensions

The following dimensions are available for the component.

Database CPU Node

• Originnode.
• The type is string.

Database CPU Timestamp

• This is the local time when the data was collected. This is available for thresholds, but not in the UI.
• The type is timestamp.

Component: Instance Database Memory Usage

It provides information about the memory usage of mysqld process in MB. The following section lists the metrics and dimensions of Component Instance Database Memory Usage.

Metrics

The following metrics are available for the component.

Database Memory Usage

• The memory usage of mysqld process in MB.
• The type is double.
• The unit is megabytes.

Dimensions

The following dimensions are available for the component.

Database Memory Node

• Originnode.
• The type is string.

Database Memory Usage Timestamp

• This is the local time when the data was collected. This is available for thresholds, but not in the UI.
• The type is timestamp.

Component: Instance Error Info

Information regarding MySQL errors. The following section lists the metrics and dimensions of Component Instance Error Info.

Metrics

The following metrics are available for the component.

Error Info Count of Addr Info Permanent Errors

• The number of permanent errors during host name-to-IP reverse DNS resolution. This is available for thresholds, but not in the UI.
• The type is int.
• The unit is errors.

Error Info Count of Addr Info Transient Errors

• The number of transient errors during host name-to-IP reverse DNS resolution. This is available for thresholds, but not in the UI.
• The type is int.
• The unit is errors.

Error Info Count of Auth Plugin Errors

• The number of errors reported by authentication plugins. This is available for thresholds, but not in the UI.
• The type is int.
• The unit is errors.

Error Info Count of Authentication Errors

• The number of errors caused by failed authentication.
• The type is int.
• The unit is errors.

Error Info Count of Default Database Errors

• The number of errors related to the default database.
• The type is int.
• The unit is errors.

Error Info Count of FCRDNS Errors

• The number of forward-confirmed reverse DNS errors.
• The type is int.
• The unit is errors.

Error Info Count of Format Errors

• The number of host name format errors.
• The type is int.
• The unit is errors.

Error Info Count of Handshake Errors

• The number of errors detected at the wire protocol level.
• The type is int.
• The unit is errors.

Error Info Count of Host ACL Errors

• The number of errors that occur because no users are permitted to connect from the client host.
• The type is int.
• The unit is errors.

Error Info Count of Host Blocked Errors

• The number of connections that were blocked because SUM_CONNECT_ERRORS exceeded the value of the max_connect_errors system.
• The type is int.
• The unit is errors.

Error Info Count of Init Connect Errors

• The number of errors caused by execution failures of statements in theinit_connectsystem variable value.
• The type is int.
• The unit is errors.

Error Info Count of Local Errors

• The number of errors local to the server implementation and not related to the network, authentication, or authorization.
• The type is int.
• The unit is errors.

Error Info Count of Max User Connections Errors

• The number of errors caused by exceeding per-user connection quotas.
• The type is int.
• The unit is errors.

Error Info Count of Max User Connections Per Hour Errors

• The number of errors caused by exceeding per-user connections-per-hour quotas. This is available for thresholds, but not in the UI.
• The type is int.
• The unit is errors.

Error Info Count of Name Info Permanent Errors

• The number of permanent errors during IP-to-host name DNS resolution. This is available for thresholds, but not in the UI.
• The type is int.
• The unit is errors.

Error Info Count of Name Info Transient Errors

• The number of transient errors during IP-to-host name DNS resolution. This is available for thresholds, but not in the UI.
• The type is int.
• The unit is errors.

Error Info Count of No Auth Plugin Errors

• The number of errors due to requests for an unavailable authentication plugin. This is available for thresholds, but not in the UI.
• The type is int.
• The unit is errors.

Error Info Count of Proxy User ACL Errors

• The number of errors detected when proxy user A is proxied to another user B who does exist but for whom A does not have thePROXYprivilege. This is available for thresholds, but not in the UI.
• The type is int.
• The unit is errors.

Error Info Count of Proxy User Errors

• The number of errors detected when proxy user A is proxied to another user B who does not exist.
• The type is int.
• The unit is errors.

Error Info Count of SSL Errors

• The number of errors due to SSL problems.
• The type is int.
• The unit is errors.

Error Info Count of Sum Connect Errors

• Only protocol handshake errors are counted, and only for hosts that passed validation (HOST_VALIDATED = YES).. This is available for thresholds, but not in the UI.
• The type is int.
• The unit is errors.

Error Info Count of Unknown Errors

• The number of other, unknown errors not accounted for by other columns in this table. This is available for thresholds, but not in the UI.
• The type is int.
• The unit is errors.

Error Info First Error Seen

• The timestamp of the first error seen from the client in theIPcolumn. This is available for thresholds, but not in the UI.
• The type is timestamp.
• The unit is Timestamp.

Error Info First Seen

• The timestamp of the first connection attempt seen from the client in the IPcolumn. This is available for thresholds, but not in the UI.
• The type is timestamp.
• The unit is timestamp.

Error Info Last Error Seen

• The timestamp of the most recent error seen from the client in theIPcolumn. This is available for thresholds, but not in the UI.
• The type is timestamp.
• The unit is timestamp.

Error Info Last Seen

• The timestamp of the most recent connection attempt seen from the client in theIPcolumn. This is available for thresholds, but not in the UI.
• The type is timestamp.
• The unit is timestamp.

Dimensions

The following dimensions are available for the component.

Error Info Client IP Address

• The IP address of the client that connected to the server.
• The type is string.

Error Info Host

• The resolved DNS host name for that client IP, or NULL if the name is unknown.
• The type is string.

Error Info Host Validated

• Whether the IP-to-host name-to-IP DNS resolution was performed successfully for the client IP. IfHOST_VALIDATEDisYES. This is available for thresholds, but not in the UI.
• The type is string.

Error Info Node

• Originnode.
• The type is string.

ErrorInfo Timestamp

• This is the local time when the data was collected. This is available for thresholds, but not in the UI.
• The type is timestamp.

Component: Instance Global Status

All global status variables and their values, from the table GLOBAL_STATUS. The following section lists the metrics and dimensions of Component Instance Global Status.

Metrics

The following metrics are available for the component.

Global Status Variable Name

• The global status variable name. This is available for thresholds, but not in the UI.
• The type is string.
• The unit is name.

Global Status Variable Value

• The global status variable value. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is string.
• The unit is value.

Global Status Variable Value As Integer

• The global status variable value as an integer.
• The type is int.
• The unit is value.

Dimensions

The following dimensions are available for the component.

Global Status Node

• Originnode.
• The type is string.

Global Status Timestamp

• This is the local time when the data was collected. This is available for thresholds, but not in the UI.
• The type is timestamp.

Component: Instance Innodb Buffer Pool Pages

Review the paging KPIs for the InnoDB storage engine buffer pool. The following section lists the metrics and dimensions of Component Instance Innodb Buffer Pool Pages.

Metrics

The following metrics are available for the component.

Innodb Buffer Pool Pages Data

• The number of pages containing data (dirty or clean).
• The type is int.
• The unit is pages.

Innodb Buffer Pool Pages Free

• The number of free pages.
• The type is int.
• The unit is pages.

Innodb Buffer Pool Pages Misc

• The number of pages that are busy because they have been allocated for administrative overhead such as row locks or the adaptive hash index.
• The type is int.
• The unit is pages.

Innodb Buffer Pool Pages Total

• The total size of buffer pool, in pages.
• The type is int.
• The unit is pages.

Dimensions

The following dimensions are available for the component.

Innodb Buffer Pool Pages Node

• Originnode.
• The type is string.

Innodb Buffer Pool Pages Timestamp

• This is the local time when the data was collected. This is available for thresholds, but not in the UI.
• The type is timestamp.

Component: Instance Lock Info

Information regarding locks on which transactions are waiting. The following section lists the metrics and dimensions of Component Instance Lock Info.

Metrics

The following metrics are available for the component.

Instance Lock Info Lock Wait Count

• Show the number of InnoDB transactions that are currently blocked, indicating the lock it has requested and any locks that are blocking that request.
• The type is int.
• The unit is locks.

Dimensions

The following dimensions are available for the component.

Instance Lock Info Node

• Originnode.
• The type is string.

Instance Lock Info Timestamp

• This is the local time when the data was collected. This is available for thresholds, but not in the UI.
• The type is timestamp.

Component: Instance RowOperations

It show row operation information. The following section lists the metrics and dimensions of Component Instance RowOperations.

Metrics

The following metrics are available for the component.

Row Operations Count of Rows Deleted

• The number of rows deleted from InnoDB tables.
• The type is int.
• The unit is rows.

Row Operations Count of Rows Inserted

• The number of rows inserted into InnoDB tables.
• The type is int.
• The unit is rows.

Row Operations Count of Rows Read

• The number of rows read from InnoDB tables.
• The type is int.
• The unit is rows.

Row Operations Count of Rows Updated

• The number of rows updated in InnoDB tables.
• The type is int.
• The unit is rows.

Row Operations Count of System Rows Deleted

• The number of system rows deleted from InnoDB tables. This is available for thresholds, but not in the UI.
• The type is int.
• The unit is rows.

Row Operations Count of System Rows Inserted

• The number of system rows inserted into InnoDB tables. This is available for thresholds, but not in the UI.
• The type is int.
• The unit is rows.

Row Operations Count of System Rows Read

• The number of system rows read from InnoDB tables. This is available for thresholds, but not in the UI.
• The type is int.
• The unit is rows.

Row Operations Count of System Rows Updated

• The number of system rows updated in InnoDB tables. This is available for thresholds, but not in the UI.
• The type is int.
• The unit is rows.

Dimensions

The following dimensions are available for the component.

Row Operations Node

• Originnode.
• The type is string.

Row Operations Timestamp

• This is the local time when the data was collected. This is available for thresholds, but not in the UI.
• The type is timestamp.

Component: Instance Status

It provides metrics regarding overall SQL server status. The following section lists the metrics and dimensions of Component Instance Status.

Metrics

The following metrics are available for the component.

Status Active Connections

• The number of currently connected threads.
• The type is int.
• The unit is connections.

Status Cache Miss Rate Percent

• The percentage of key reads that have gone to disk in the last 5 minutes.
• The type is double.
• The unit is percent.

Status Count of Queries

• The raw number of queries per second that have occurred since server start. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is int.
• The unit is queries.

Status Count of Slow Queries

• The raw number of slow queries per second that have occurred since server start. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is int.
• The unit is queries.

Status Full Table Scans Percent

• The percentage of read requests that indicate full table scans in the last 5 minutes.
• The type is double.
• The unit is percent.

Status Key Read Request Per Second

• The number of key block reads per second from a physical disk in the last 5 minutes. This is available for thresholds, but not in the UI.
• The type is double.
• The unit is requests/second.

Status Key Reads Per Second

• The number of key block read requests per second in the last 5 minutes. This is available for thresholds, but not in the UI.
• The type is double.
• The unit is reads/second.

Status Maximum Connections

• The configured maximum number of allowed connections. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is int.
• The unit is connections.

Status Open Tables

• The number of currently open tables. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is int.
• The unit is tables.

Status Queries Per Second

• The number of queries per second that have occurred in the last 5 minutes. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is double.
• The unit is queries/second.

Status Read Requests First Per Second

• The number of read requests per second for the first row in the last 5 minutes. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is double.
• The unit is requests/second.

Status Read Requests Key Per Second

• The number of read requests per second for a row based on a key in the last 5 minutes. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is double.
• The unit is requests/second.

Status Read Requests Next Per Second

• The number of read requests per second for the next row in key order in the last 5 minutes. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is double.
• The unit is requests/second.

Status Read Requests Previous Per Second

• The number of read requests per second for the previous row in key order in the last 5 minutes. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is double.
• The unit is requests/second.

Status Read Requests RND Next Per Second

• The number of read requests per second for the next row in the data file in the last 5 minutes. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is double.
• The unit is requests/second.

Status Read Requests RND Per Second

• The number of read requests per second for a row in a fixed position in the last 5 minutes. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is double.
• The unit is requests/second.

Status Server Connections Used Percent

• The percentage of the server's available connections currently in use.
• The type is double.
• The unit is percent.

Status Slow Queries Per Second

• The number of slow queries per second that have occurred in the last 5 minutes. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is double.
• The unit is queries/second.

Status Slow Queries Percent

• The percentage of queries that have been slow in the last 5 minutes.
• The type is double.
• The unit is percent.

Status Table Cache Percent Used

• The percentage of the server's available table cache currently in use.
• The type is double.
• The unit is percent.

Status Table Open Cache

• The configured number of open tables for all threads. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is int.
• The unit is tables.

Status Temporary Disk Tables Created Per Second

• The number of temporary tables per second that have been created on disk in the last 5 minutes. This is available for thresholds, but not in the UI.
• The type is double.
• The unit is tables/second.

Status Temporary Tables Created Per Second

• The number of temporary tables per second that have been created in the last 5 minutes. This is available for thresholds, but not in the UI.
• The type is double.
• The unit is tables/second.

Status Temporary Tables On Disk Percent

• The percentage of temporary tables that are created on disk in the last 5 minutes.
• The type is double.
• The unit is percent.

Status TImestamp

• This is the local time when the data was collected. This is available for thresholds, but not in the UI.
• The type is timestamp.
• The unit is timestamp.

Dimensions

The following dimensions are available for the component.

Status Node

• Originnode.
• The type is string.

Component: Instance Users

Users attribute group displays each user that connects to the server along with current and total connections. The following section lists the metrics and dimensions of Component Instance Users.

Metrics

The following metrics are available for the component.

Users Current Connections

• CurrentConnections attribute displays current connections for the user.
• The type is int.
• The unit is connections.

Users Total Connections

• TotalConnections attributes displays total connections for the user.
• The type is int.
• The unit is connections.

Dimensions

The following dimensions are available for the component.

Users Node

• OriginNode.
• The type is string.

Users Timestamp

• This is the local time when the data was collected. This is available for thresholds, but not in the UI.
• The type is timestamp.

Users User

• User attribute displays the connection's client user name for the connection, or No_Values if an internal thread.
• The type is string.