Google Cloud SQL (MySQL) Container (GCP_GCSQL_SQL_MYSQL_CNTR)
This monitor type contains attributes that indicates the MySQL database performance of the cloud SQL (MySQL) instance.
Attributes (parameters)
The following attributes are available for this monitor type:
Name | Description | Unit | Default Key Performance Indicator (KPI) | Value set by |
|---|---|---|---|---|
InnoDB dirty pages (InnoDBDirtyPages) | This attribute displays the number of unflushed pages in the InnoDB buffer pool. | # | No | |
InnoDB free pages (InnoDBFreePages) | This attribute displays the number of unused pages in the InnoDB buffer pool. | # | No | |
InnoDB fsync calls (InnoDBFsyncCalls) | This attribute displays the delta count of InnoDB fsync() calls. | # | No | |
InnoDB log fsync calls (InnoDBLogFsyncCalls) | This attribute displays the delta count of InnoDB fsync() calls to the log file. | # | No | |
InnoDB pages read (InnoDBPagesRead) | This attribute displays the delta count of InnoDB pages read. | # | No | |
InnoDB pages written (InnoDBPagesWritten) | This attribute displays the delta count of InnoDB pages written. | # | No | |
InnoDB total pages (InnoDBTotalPages) | This attribute displays the total number of pages in the InnoDB buffer pool. | # | No | |
Last I/O thread error number (LastIOThreadErrorNumber) | This attribute displays the error number of the most recent error that caused the I/O thread to stop. | # | No | |
Last SQL thread error number (LastSQLThreadErrorNumber) | This attribute displays the error number of the most recent error that caused the SQL thread to stop. | # | No | |
MySQL InnoDB dictionary cache (MySQLInnoDBDictionaryCache) | This attribute displays the memory allocated for InnoDB dictionary cache. | GB | No | |
MySQL open tables (MySQLOpenTables) | This attribute displays the number of tables that are currently open. | # | No | |
MySQL opened table count (MySQLOpenedTableCount) | This attribute displays the number of tables that have been opened since the last sample. | # | No | |
MySQL open table definitions (MySQLOpenTableDefinitions) | This attribute displays the number of table definitions that are currently cached. | # | No | |
MySQL opened table definitions count (MySQLOpenedTableDefCount) | This attribute displays the number of table definitions that have been cached since the last sample. | # | No | |
Network bytes received by MySQL (NetworkBytesReceivedByMySQL) | This attribute displays the delta count of bytes received by MySQL process. | GB | Yes | |
Network bytes sent by MySQL (NetworkBytesSentByMySQL) | This attribute displays the delta count of bytes sent by MySQL process. | GB | Yes | |
Replication lag (ReplicationLag) | This attribute displays the number of seconds the read replica is behind its primary (approximation). | sec | No | |
Slave I/O thread running (SlaveIOThreadRunning) | This attribute indicates whether the I/O thread for reading the primary's binary log is running. | 0-Yes, | No | |
Slave I/O thread running state (SlaveIOThreadRunningState) | This attribute indicates whether the I/O thread for reading the primary's binary log is running. | 0 - Yes, 1 - No | No | |
Slave SQL thread running (SlaveSQLThreadRunning) | This attribute indicates whether the SQL thread for executing events in the relay log is running. | 0 Running, | No | |
Slave SQL thread running state (SlaveSQLThreadRunningState) | This attribute Indicates whether the SQL thread for executing events in the relay log is running. | 0-Yes, | No | |
Queries | This attribute displays the delta count of statements executed by the server. | # | No | |
Questions | This attribute displays the delta count of statements executed by the server sent by the client. | # | No |

