Advanced Cloud Database Template for Aurora
Description
Advanced Cloud Database Template for Aurora
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MySQL Database Threads Monitor | mysql.connected.threads.count | MySQL Connected Threads count | MySQL Connected Threads count. | |
mysql.created.threads | MySQL Created Threads | count | The number of threads created to handle connections. If Threads_created is big,you may want to increase the thread_cache_size value. The cache miss rate can be calculated as Threads_created/Connections. | |
mysql.threads.cached.count | MySQL Cached Threads count | MySQL Cached Threads count. | ||
mysql.running.threads | MySQL Running Threads | count | The number of threads that are not sleeping. | |
mysql.threads.stacksize | MySQL Threads Stacksize | NULL | The stack size for each thread. Many of the limits detected by the crash-me test are dependent on this value. | |
Advanced Cloud MySQL Database Table Monitor | mysq.tmp.table.delta.util | MySL temporary table delta utilization | MySL temporary table delta utilization. | |
mysq.tmp.table.util | MySQL temporary table utilization | MySQL temporary table utilization. | ||
mysql.temporary.files.created | MySQL Temporary Files Created | psec | The rate of temporary files created by second. | |
mysql.disk.temporarytables.created | MySQL Disk Temporary Tables Created | psec | The rate of temporary tables created by second. | |
mysql.full.table.scan.delta.util | MySQL full table scan delta utilization | MySQL full table scan delta utilization. | ||
mysql.full.table.scan.util | MySQL full table scan utilization | MySQL full table scan utilization. | ||
mysq.open.files.util | MySQL Open file utilization | MySQL Open file utilization. | ||
mysql.open.files | MySQL Open Files | count | The number of files that have been opened with my_open() (a mysys library function). Parts of the server that open files without using this function do not increment the count. | |
mysql.open.tables | MySQL Open Tables | count | The number of tables that have been opened with my_open(). | |
mysql.table.locks_immediate | MySQL Table Locks Immediate | count | The number of times that a request for a table lock could be granted immediately. | |
Advanced Cloud MySQL Database Network Monitor | mysql.bytes.received | MySQL Bytes Received | Bps | The number of bytes received from all clients. |
mysql.bytes.sent | MySQL Bytes Sent | Bps | The number of bytes sent to all clients. | |
Advanced Cloud MySQL Database Miscellaneous Monitor | mysql.slave.status | MySQL Slave Status | MySQL Slave Status. | |
mysq.slave.seconds.behind.master | MySQL Slave behind master | MySQL Slave behind master. | ||
mysql.system.uptime | MySQL System Uptime | m | MySQL System Uptime. | |
mysql.streams.open | MySQL Streams Open | count | The number of streams that are open (used mainly for logging). | |
Advanced Cloud MySQL Database innoDB Monitor | mysql.innodb.data.pending.reads | MySQL Innodb Data Pending Reads | count | The current number of pending reads. |
mysql.innodb.data.pending.writes | MySQL Innodb Data Pending Writes | count | The total number of data writes. | |
mysql.innodb.bufferpool.pagesfree | MySQL Innodb Buffer Pool Pages free | count | The number of free pages in the InnoDB Buffer Pool. | |
mysql.innodb.bufferpool.pagestotal | Mysql Innodb Bufferpool Pagestotal | count | The total number of pages in the InnoDB Buffer Pool. | |
mysql.innodb.buffer_pool_reads | MySQL Innodb Bufferpool Reads | count | The number of logical reads that InnoDB could not satisfy from the buffer pool,and had to read directly from the disk. | |
mysql.innodb.buffer_pool_read_requests | MySQL Innodb Bufferpool Read Requests | count | The number of reads done to the InnoDB buffer pool. | |
mysql.innodb.buffer_pool_write_requests | MySQL Innodb Bufferpool Write Requests | count | The number of writes done to the InnoDB buffer pool. | |
mysql.innodb.bufferpool.dirtypages | Mysql Innodb Bufferpool Dirtypages | count | The current number of dirty pages in the InnoDB buffer pool. | |
mysql.innodb.bufferpool.utilization | MySQL Innodb Bufferpool Utilization | % | The utilization of the InnoDB Buffer Pool.shown as fraction. | |
mysql.innodb.data.reads | MySQL Innodb Data Reads | count | The total number of data reads (OS file reads). | |
mysql.innodb.data.writes | MySQL InnoDB Data Writes | count | The total number of data writes. | |
mysql.innodb.row.lock.waits | MySQL Innodb Row Lock waits | count | The number of times operations on InnoDB tables had to wait for a row lock. | |
mysql.innodb.row.lock.time | mysql Innodb Row Lock Time | ms | The total time spent in acquiring row locks for InnoDB tables,in milliseconds. | |
Advanced Cloud MySQL Database Connection Monitor | mysql.aborted.clients | MySQL Aborted Clients | count | The number of connections that were aborted because the client died without closing the connection properly. |
mysql.max.connections | MySQL Max Connections | count | Max Limit of Connections. | |
mysql.max.connections.connection_errors | MySQL Max Connections Connection Errors | count | The number of connections refused due to internal server errors. | |
mysql.aborted.connects | MySQL Aborted Connects | count | The number of failed attempts to connect to the MySQL server. | |
mysql.internal.connection.errors | MySQL Internal Connection Errors | count | The number of connections refused due to internal errors in the server,such as failure to start a new thread or an out-of-memory condition. | |
mysql.ssl.client.connects | MySQL SSL Client Connects | count | The number of SSL connection attempts to an SSL-enabled master. | |
mysql.active.transactions | MySQL Active Transactions | count | Number of active transactions. | |
mysql.server.connections | MySQL Server Connections | count | The number of connection attempts (successful or not) to the MySQL server. | |
Advanced Cloud MySQL Database Command Monitor | mysql.update.commands | MySQL Update Commands | psec | The number of times UPDATE command has been executed. |
mysql.select.commands | MySQL Select Command | psec | The number of times SELECT command has been executed. | |
mysql.delete.commands | MySQL Delete Command | psec | The number of times Delete command has been executed. | |
mysql.insert.commands | MySQL Insert Command | psec | The number of times Insert command has been executed. | |
mysql.rollback.commands | MySQL Rollback Command | psec | The number of times RollBack command has been executed. | |
mysql.droptable.commands | MySQL DropTable Command | psec | The number of times Drop Table command has been executed. | |
mysql.dropuser.commands | MySQL Dropuser Commands | psec | The number of times DROP USER command has been executed. | |
mysql.dropdatabase.commands | MySQL DropDatabase Commands | psec | The number of times DROP DATABASE command has been executed. | |
mysql.createtable.commands | MySQL CreateTable Commands | psec | The number of times CREATE TABLE command has been executed. | |
mysql.createuser.commands | MySQL Createuser Commands | psec | The number of times CREATE USER command has been executed. | |
mysql.createdatabase.commands | MySQL Createdatabase Commands | psec | The number of times CREATE DATABASE command has been executed | |
mysql.slow.query.count | MySQL Slow Query Count | qpm | MySQL Slow Query Count |
Advanced Cloud Database Template for MariaDB
Description
Advanced Cloud Database Template for MariaDB
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MySQL Database Threads Monitor | mysql.connected.threads.count | MySQL Connected Threads count | MySQL Connected Threads count. | |
mysql.created.threads | MySQL Created Threads | count | The number of threads created to handle connections. If Threads_created is big,you may want to increase the thread_cache_size value. The cache miss rate can be calculated as Threads_created/Connections. | |
mysql.threads.cached.count | MySQL Cached Threads count | MySQL Cached Threads count. | ||
mysql.running.threads | MySQL Running Threads | count | The number of threads that are not sleeping. | |
mysql.threads.stacksize | MySQL Threads Stacksize | NULL | The stack size for each thread. Many of the limits detected by the crash-me test are dependent on this value. | |
Advanced Cloud MySQL Database Table Monitor | mysq.tmp.table.delta.util | MySL temporary table delta utilization | MySL temporary table delta utilization. | |
mysq.tmp.table.util | MySQL temporary table utilization | MySQL temporary table utilization. | ||
mysql.temporary.files.created | MySQL Temporary Files Created | psec | The rate of temporary files created by second. | |
mysql.disk.temporarytables.created | MySQL Disk Temporary Tables Created | psec | The rate of temporary tables created by second. | |
mysql.full.table.scan.delta.util | MySQL full table scan delta utilization | MySQL full table scan delta utilization. | ||
mysql.full.table.scan.util | MySQL full table scan utilization | MySQL full table scan utilization. | ||
mysq.open.files.util | MySQL Open file utilization | MySQL Open file utilization. | ||
mysql.open.files | MySQL Open Files | count | The number of files that have been opened with my_open() (a mysys library function). Parts of the server that open files without using this function do not increment the count. | |
mysql.open.tables | MySQL Open Tables | count | The number of tables that have been opened with my_open(). | |
mysql.table.locks_immediate | MySQL Table Locks Immediate | count | The number of times that a request for a table lock could be granted immediately. | |
Advanced Cloud MySQL Database Network Monitor | mysql.bytes.received | MySQL Bytes Received | Bps | The number of bytes received from all clients. |
mysql.bytes.sent | MySQL Bytes Sent | Bps | The number of bytes sent to all clients. | |
Advanced Cloud MySQL Database Miscellaneous Monitor | mysql.slave.status | MySQL Slave Status | MySQL Slave Status. | |
mysq.slave.seconds.behind.master | MySQL Slave behind master | MySQL Slave behind master. | ||
mysql.system.uptime | MySQL System Uptime | m | MySQL System Uptime. | |
mysql.streams.open | MySQL Streams Open | count | The number of streams that are open (used mainly for logging). | |
Advanced Cloud MySQL Database innoDB Monitor | mysql.innodb.data.pending.reads | MySQL Innodb Data Pending Reads | count | The current number of pending reads. |
mysql.innodb.data.pending.writes | MySQL Innodb Data Pending Writes | count | The total number of data writes. | |
mysql.innodb.bufferpool.pagesfree | MySQL Innodb Buffer Pool Pages free | count | The number of free pages in the InnoDB Buffer Pool. | |
mysql.innodb.bufferpool.pagestotal | Mysql Innodb Bufferpool Pagestotal | count | The total number of pages in the InnoDB Buffer Pool. | |
mysql.innodb.buffer_pool_reads | MySQL Innodb Bufferpool Reads | count | The number of logical reads that InnoDB could not satisfy from the buffer pool,and had to read directly from the disk. | |
mysql.innodb.buffer_pool_read_requests | MySQL Innodb Bufferpool Read Requests | count | The number of reads done to the InnoDB buffer pool. | |
mysql.innodb.buffer_pool_write_requests | MySQL Innodb Bufferpool Write Requests | count | The number of writes done to the InnoDB buffer pool. | |
mysql.innodb.bufferpool.dirtypages | Mysql Innodb Bufferpool Dirtypages | count | The current number of dirty pages in the InnoDB buffer pool. | |
mysql.innodb.bufferpool.utilization | MySQL Innodb Bufferpool Utilization | % | The utilization of the InnoDB Buffer Pool. Shown as fraction. | |
mysql.innodb.data.reads | MySQL Innodb Data Reads | count | The total number of data reads (OS file reads). | |
mysql.innodb.data.writes | MySQL InnoDB Data Writes | count | The total number of data writes. | |
mysql.innodb.row.lock.waits | MySQL Innodb Row Lock waits | count | The number of times operations on InnoDB tables had to wait for a row lock. | |
mysql.innodb.row.lock.time | mysql Innodb Row Lock Time | ms | The total time spent in acquiring row locks for InnoDB tables,in milliseconds. | |
Advanced Cloud MySQL Database Connection Monitor | mysql.aborted.clients | MySQL Aborted Clients | count | The number of connections that were aborted because the client died without closing the connection properly. |
mysql.max.connections | MySQL Max Connections | count | Max Limit of Connections. | |
mysql.max.connections.connection_errors | MySQL Max Connections Connection Errors | count | The number of connections refused due to internal server errors. | |
mysql.aborted.connects | MySQL Aborted Connects | count | The number of failed attempts to connect to the MySQL server. | |
mysql.internal.connection.errors | MySQL Internal Connection Errors | count | The number of connections refused due to internal errors in the server,such as failure to start a new thread or an out-of-memory condition. | |
mysql.ssl.client.connects | MySQL SSL Client Connects | count | The number of SSL connection attempts to an SSL-enabled master. | |
mysql.active.transactions | MySQL Active Transactions | count | Number of active transactions | |
mysql.server.connections | MySQL Server Connections | count | The number of connection attempts (successful or not) to the MySQL server. | |
Advanced Cloud MySQL Database Command Monitor | mysql.update.commands | MySQL Update Commands | psec | The number of times UPDATE command has been executed. |
mysql.select.commands | MySQL Select Command | psec | The number of times SELECT command has been executed. | |
mysql.delete.commands | MySQL Delete Command | psec | The number of times Delete command has been executed. | |
mysql.insert.commands | MySQL Insert Command | psec | The number of times Insert command has been executed. | |
mysql.rollback.commands | MySQL Rollback Command | psec | The number of times RollBack command has been executed. | |
mysql.droptable.commands | MySQL DropTable Command | psec | The number of times Drop Table command has been executed. | |
mysql.dropuser.commands | MySQL Dropuser Commands | psec | The number of times DROP USER command has been executed. | |
mysql.dropdatabase.commands | MySQL DropDatabase Commands | psec | The number of times DROP DATABASE command has been executed. | |
mysql.createtable.commands | MySQL CreateTable Commands | psec | The number of times CREATE TABLE command has been executed. | |
mysql.createuser.commands | MySQL Createuser Commands | psec | The number of times CREATE USER command has been executed. | |
mysql.createdatabase.commands | MySQL Createdatabase Commands | psec | The number of times CREATE DATABASE command has been executed. | |
mysql.slow.query.count | MySQL Slow Query Count | qpm | MySQL Slow Query Count. |
Advanced Cloud Database Template for MsSQL
Description
Advanced Cloud Database Template for MsSQL
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MSSQL Database Transactions Monitor | mssql.longest.transaction time | Longest transaction time | s | The length of time (in seconds) since the start of the transaction that has been active longer than any other current transaction. This counter only shows activity when the database is under read committed snapshot isolation level. It does not log any activity if the database is in any other isolation level. |
Advanced Cloud MSSQL Database SQL Statistics Monitor | mssql.batch.requests | Batch requests | psec | Number of SQL batch requests received by server. |
mssql.sql.compilations | Sql compilations | psec | Number of SQL compilations. | |
msql.sql.recompilations | Sql recompilations | psec | Number of statement recompiles per second. Counts the number of times statement recompiles are triggered. Generally,you want the recompiles to be low. | |
Advanced Cloud MSSQL Database Resource pool Stats Monitor | mssql.resource.pool.used.memory | Resource pool used memory | KB | The amount of memory used,in kilobytes (KB),for the resource pool. |
mssql.resource.pool.disk.read.io | Resource pool disk read IO | rops | Number of read operations from the disk in the last second. | |
mssql.resource.pool.disk.write.io | Resource pool disk write IO | wps | Number of bytes written to the disk in the last second. | |
Advanced Cloud MSSQL Database Miscellaneous Monitor | msql.last.elapsed.time | Last elapsed time | microsec | Elapsed time,reported in microseconds (but only accurate to milliseconds),for the most recently completed execution of this plan. |
mssql.buffer.cache.hit.ratio | Buffer cache hit ratio | None | Percentage of pages that were found in the buffer pool without having to incur a read from disk. | |
mssql.procedure.cache.hit.ratio | Procedure Cache Hit Ratio | NULL | Procedure Cache Hit ratio (calculated from server start-up). | |
mssql.page.life.expectancy | MSSQL PageLifeExpectancy | s | Number of seconds a page will stay in the buffer pool without references. | |
Advanced Cloud MSSQL Database Memory Manager Monitor | mssql.total.server.memory | Total server memory | KB | Total amount of dynamic memory the server is currently consuming. |
mssql.memory.grants.pending | Memory Grants Pending | NULL | Current number of processes waiting for a workspace memory grant. | |
mssql.database.cache.memory | Database cache memory | KB | Amount of memory the server is currently using for the database cache. | |
mssql.connection.memory | Connection Memory | KB | Total amount of dynamic memory the server is using for maintaining connections. | |
mssql.lock.memory | Lock Memory | KB | Total amount of dynamic memory the server is using for locks. | |
mssql.free.memory | Free Memory | KB | Amount of memory the server is currently not using. | |
mssql.sql.cache.memory | SQL Cache Memory | KB | Total amount of dynamic memory the server is using for the dynamic SQL cache. | |
mssql.optimizer.memory | Optimizer Memory | KB | Total amount of dynamic memory the server is using for query optimization. | |
Advanced Cloud MSSQL Database Locks Monitor | mssql.lock.waits | Lock waits | psec | Number of lock requests that could not be satisfied immediately and required the caller to wait before being granted the lock. |
mssql.avg.lock.wait.time | Average lock wait time | ms | The average amount of wait time (milliseconds) for each lock request that resulted in a wait. | |
mssql.lock.timeouts | Lock timeouts | psec | Number of lock requests that timed out. This includes requests for no wait locks. | |
Advanced Cloud MSSQL Database Latches Monitor | mssql.latch.waits | Latch waits | psec | Number of latch requests that could not be granted immediately and had to wait before being granted. |
Advanced Cloud MSSQL Database General Statistics Monitor | mssql.user.connections | User connections | NULL | The number of users connected to the system. |
mssql.blocked.process | Blocked processes | NULL | The number of currently blocked processes. | |
Advanced Cloud MSSQL Database Databases Monitor | mssql.log.flushes | Log Flushes | psec | The number of log flushes. |
mssql.db.transactions | Db transactions | psec | The number of transactions started for the database. | |
mssql.db.data.file.size | Data File Size | KB | The cumulative size of all the data files in the database. | |
mssql.lock.deadlocks | Deadlocks | psec | The number of lock requests that resulted in a deadlock. | |
Advanced Cloud MSSQL Database Buffer Monitor | mssql.database.page.reads | Page reads | psec | Number of physical database page reads issued. |
mssql.database.page.writes | Database Page writes | wps | Number of physical database page writes issued. | |
mssql.buffer.lazy.writes | Buffer lazy writes | wps | Number of buffers written by buffer manager's lazy writer. | |
mssql.checkpoint.pages | Checkpoint pages | psec | Indicates the number of pages flushed to disk per second by a checkpoint or other operation that require all dirty pages to be flushed. | |
Advanced Cloud MSSQL Database Access Methods Monitor | mssql.page.splits | Page splits | psec | The number of page splits per second that occur as the result of overflowing index pages. |
mssql.full.scans | Full scans | psec | Number of unrestricted full scans. These can either be base table or full index scans. |
Advanced Cloud Database Template for MySQL
Description
Advanced Cloud Database Template for MySQL
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MySQL Database Threads Monitor | mysql.connected.threads.count | MySQL Connected Threads count | MySQL Connected Threads count. | |
mysql.created.threads | MySQL Created Threads | count | The number of threads created to handle connections. If Threads_created is big,you may want to increase the thread_cache_size value. The cache miss rate can be calculated as Threads_created/Connections. | |
mysql.threads.cached.count | MySQL Cached Threads count | MySQL Cached Threads count. | ||
mysql.running.threads | MySQL Running Threads | count | The number of threads that are not sleeping. | |
mysql.threads.stacksize | MySQL Threads Stacksize | NULL | The stack size for each thread. Many of the limits detected by the crash-me test are dependent on this value. | |
Advanced Cloud MySQL Database Table Monitor | mysq.tmp.table.delta.util | MySL temporary table delta utilization | MySL temporary table delta utilization | |
mysq.tmp.table.util | MySQL temporary table utilization | MySQL temporary table utilization | ||
mysql.temporary.files.created | MySQL Temporary Files Created | psec | The rate of temporary files created by second. | |
mysql.disk.temporarytables.created | MySQL Disk Temporary Tables Created | psec | The rate of temporary tables created by second. | |
mysql.full.table.scan.delta.util | MySQL full table scan delta utilization | MySQL full table scan delta utilization. | ||
mysql.full.table.scan.util | MySQL full table scan utilization | MySQL full table scan utilization. | ||
mysq.open.files.util | MySQL Open file utilization | MySQL Open file utilization | ||
mysql.open.files | MySQL Open Files | count | The number of files that have been opened with my_open() (a mysys library function). Parts of the server that open files without using this function do not increment the count. | |
mysql.open.tables | MySQL Open Tables | count | The number of tables that have been opened with my_open(). | |
mysql.table.locks_immediate | MySQL Table Locks Immediate | count | The number of times that a request for a table lock could be granted immediately. | |
Advanced Cloud MySQL Database Network Monitor | mysql.bytes.received | MySQL Bytes Received | Bps | The number of bytes received from all clients. |
mysql.bytes.sent | MySQL Bytes Sent | Bps | The number of bytes sent to all clients. | |
Advanced Cloud MySQL Database Miscellaneous Monitor | mysql.slave.status | MySQL Slave Status | MySQL Slave Status. | |
mysq.slave.seconds.behind.master | MySQL Slave behind master | MySQL Slave behind master. | ||
mysql.system.uptime | MySQL System Uptime | m | MySQL System Uptime. | |
mysql.streams.open | MySQL Streams Open | count | The number of streams that are open (used mainly for logging). | |
Advanced Cloud MySQL Database innoDB Monitor | mysql.innodb.data.pending.reads | MySQL Innodb Data Pending Reads | count | The current number of pending reads. |
mysql.innodb.data.pending.writes | MySQL Innodb Data Pending Writes | count | The total number of data writes. | |
mysql.innodb.bufferpool.pagesfree | MySQL Innodb Buffer Pool Pages free | count | The number of free pages in the InnoDB Buffer Pool. | |
mysql.innodb.bufferpool.pagestotal | Mysql Innodb Bufferpool Pagestotal | count | The total number of pages in the InnoDB Buffer Pool. | |
mysql.innodb.buffer_pool_reads | MySQL Innodb Bufferpool Reads | count | The number of logical reads that InnoDB could not satisfy from the buffer pool,and had to read directly from the disk. | |
mysql.innodb.buffer_pool_read_requests | MySQL Innodb Bufferpool Read Requests | count | The number of reads done to the InnoDB buffer pool. | |
mysql.innodb.buffer_pool_write_requests | MySQL Innodb Bufferpool Write Requests | count | The number of writes done to the InnoDB buffer pool. | |
mysql.innodb.bufferpool.dirtypages | Mysql Innodb Bufferpool Dirtypages | count | The current number of dirty pages in the InnoDB buffer pool. | |
mysql.innodb.bufferpool.utilization | MySQL Innodb Bufferpool Utilization | % | The utilization of the InnoDB Buffer Pool. Shown as fraction. | |
mysql.innodb.data.reads | MySQL Innodb Data Reads | count | The total number of data reads (OS file reads). | |
mysql.innodb.data.writes | MySQL InnoDB Data Writes | count | The total number of data writes. | |
mysql.innodb.row.lock.waits | MySQL Innodb Row Lock waits | count | The number of times operations on InnoDB tables had to wait for a row lock. | |
mysql.innodb.row.lock.time | mysql Innodb Row Lock Time | ms | The total time spent in acquiring row locks for InnoDB tables,in milliseconds. | |
Advanced Cloud MySQL Database Connection Monitor | mysql.aborted.clients | MySQL Aborted Clients | count | The number of connections that were aborted because the client died without closing the connection properly. |
mysql.max.connections | MySQL Max Connections | count | Max Limit of Connections. | |
mysql.max.connections.connection_errors | MySQL Max Connections Connection Errors | count | The number of connections refused due to internal server errors. | |
mysql.aborted.connects | MySQL Aborted Connects | count | The number of failed attempts to connect to the MySQL server. | |
mysql.internal.connection.errors | MySQL Internal Connection Errors | count | The number of connections refused due to internal errors in the server,such as failure to start a new thread or an out-of-memory condition. | |
mysql.ssl.client.connects | MySQL SSL Client Connects | count | The number of SSL connection attempts to an SSL-enabled master. | |
mysql.active.transactions | MySQL Active Transactions | count | Number of active transactions. | |
mysql.server.connections | MySQL Server Connections | count | The number of connection attempts (successful or not) to the MySQL server. | |
Advanced Cloud MySQL Database Command Monitor | mysql.update.commands | MySQL Update Commands | psec | The number of times UPDATE command has been executed. |
mysql.select.commands | MySQL Select Command | psec | The number of times SELECT command has been executed. | |
mysql.delete.commands | MySQL Delete Command | psec | The number of times Delete command has been executed. | |
mysql.insert.commands | MySQL Insert Command | psec | The number of times Insert command has been executed. | |
mysql.rollback.commands | MySQL Rollback Command | psec | The number of times RollBack command has been executed. | |
mysql.droptable.commands | MySQL DropTable Command | psec | The number of times Drop Table command has been executed. | |
mysql.dropuser.commands | MySQL Dropuser Commands | psec | The number of times DROP USER command has been executed. | |
mysql.dropdatabase.commands | MySQL DropDatabase Commands | psec | The number of times DROP DATABASE command has been executed. | |
mysql.createtable.commands | MySQL CreateTable Commands | psec | The number of times CREATE TABLE command has been executed. | |
mysql.createuser.commands | MySQL Createuser Commands | psec | The number of times CREATE USER command has been executed. | |
mysql.createdatabase.commands | MySQL Createdatabase Commands | psec | The number of times CREATE DATABASE command has been executed | |
mysql.slow.query.count | MySQL Slow Query Count | qpm | MySQL Slow Query Count |
Advanced Cloud Database Template for Oracle
Description
Advanced Cloud Database Template for Oracle
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud OracleDB Performance | oracle.invalid.objects | Invalid Objects | count | Checks for invalid objects in database. |
oracle.failed.logon.count | Failed Logon Count | count | It monitors the failed logon attempts of the current user | |
oracle.blocking.lock.queries | Oracle Blocking Lock Queries | count | Validates the how many block lock queries?on particular database. | |
oracle.long.running.queries | Oracle Long Running Queries | count | Validates the how many long running queries?on particular database. | |
Advanced Cloud Oracle Table Space | oracle.table.space.util | Table Space Utilization | % | It monitors the table space utilization. |
oracle.table.space.used | Table Space Used | Mb | It monitors the table space used. | |
oracle.temp.table.space.free | Temp Table Space Free | Mb | It monitors temporary table space free. | |
oracle.temp.table.space.used | Temp Table Space Used | Mb | It monitors temporary table space used. | |
oracle.temp.table.space.util | Temp Table Space Utilization | % | It monitors temporary table space utilization. | |
oracle.table.space.free | Oracle Table Space Free | MB | Validates the Size allocated for the table by database. | |
Advanced Cloud Oracle System Summary | oracle.cpu.usage.per.sec | CPU Usage Per Sec | NULL | This metric represents the CPU usage per second by the database processes,measured in hundredths of a second. |
oracle.cpu.usage.per.txn | CPU Usage Per Txn | NULL | The amount of CPU usage per transaction for the specific task or session. | |
oracle.database.cpu.time.ratio | Database CPU Time Ratio | NULL | The Database CPU Time Ratio is of limited value as a tuning tool. The Database CPU Time Ratio is computed by dividing the amount of CPU used in the database by the amount of total database time. Total database time is the time spent by the database on user-level calls. | |
oracle.executions.per.txn | Executions Per Txn | NULL | The average amount of time per execution. | |
oracle.executions.per.sec | Executions Per Sec | NULL | The average transactions per second. | |
oracle.sql.service.response.time | Sql Service Response Time | ms | SQL Response Time is the average elapsed time per execution of a representative set of SQL statements,relative to a baseline. | |
oracle.user.transaction.per.sec | User Transaction Per Sec | NULL | The User Commits Per Sec Oracle metric data item represents the number of user commits performed,per second during the sample period. | |
oracle.response.time.per.txn | Response Time Per Txn | NULL | The Response Time Per Txn Oracle metric is using only statistics available within the database,this data item gives the best approximation of response time,in seconds,per transaction during this sample period. | |
oracle.database.wait.time.ratio | Database Wait Time Ratio | NULL | It monitors database wait time ratio. | |
Advanced Cloud Oracle System Stats | oracle.user.commits | User Commits | psec | This metric represents the number of user commits performed per second in last two monitoring polls. |
oracle.redo.log.space.requests | Redo Log Space Requests | Req per Sec | It represents the active log file is full and Oracle is waiting for disk space to be allocated for the redo log entries. | |
oracle.user.rollbacks.persec | User Rollbacks | psec | This metric represents the number of times,per second,that users manually issue the ROLLBACK statement or an error occurred during a user's transactions. | |
oracle.cache.blocks.lost | Cache Blocks Lost | count | This metric represents the number of global cache blocks lost over the user-defined observation period. | |
oracle.table.scan.blocks.persec | Table Scan Blocks | psec | Number of blocks received via table scans. | |
oracle.io.wait.time | IO Wait Time | ms | How much time the application was blocked,waiting for all I/O operation to complete | |
oracle.logons.per.sec | Logons Per Sec | count | This metric represents the number of logons per second during the sample period. | |
oracle.db.instance.uptime | DB Instance Uptime | Days | It represents db instance uptime since start up. | |
oracle.check.db.alive | Check Db Alive | NULL | Monitors connectivity to the database instance. | |
Advanced Cloud Oracle SGA stats | oracle.shared.pool.free | Shared Pool Free | MB | It monitors the free shared pool memory in MB. |
oracle.java.pool.free | Java Pool Free | MB | It monitors the free java pool memory in MB. | |
oracle.large.pool.free | Large Pool Free | MB | It monitors the free large pool memory in MB. | |
Advanced Cloud Oracle Sessions | oracle.session.cpu_used | Session Cpu Used | s | It monitors the session cpu usage in seconds. |
oracle.active.sessions | Active Sessions | count | It monitors the active sessions | |
oracle.inactive.sessions | Inactive Sessions | count | It monitors the inactive sessions | |
oracle.session.limit.usage | Session Limit Usage | % | It monitors the sessions utilization. | |
oracle.session.waits | Session Waits | s | It monitors the session waits. | |
Advanced Cloud Oracle Library stats | oracle.library.cache.gets | Oracle Library Cache Gets | Validates the Number of Library Cache gets by database. | |
oracle.library.cachereloads | Library Cache Reloads | NULL | Validates the Number of Library Cache Reloads by database. | |
oracle.cache.invalidations | Oracle Cache Invalidations | Validates the how many Cache invalidations on particular database. | ||
Advanced Cloud Oracle Errors | oracle.errors | OracleErrors | NULL | OracleErrors |
Oracle System Summary | oracle.cpu.usage.per.sec | CPU Usage Per Sec | NULL | This metric represents the CPU usage per second by the database processes,measured in hundredths of a second. |
oracle.cpu.usage.per.txn | CPU Usage Per Txn | NULL | The amount of CPU usage per transaction for the specific task or session. | |
oracle.database.cpu.time.ratio | Database CPU Time Ratio | NULL | The Database CPU Time Ratio is of limited value as a tuning tool. The Database CPU Time Ratio is computed by dividing the amount of CPU used in the database by the amount of total database time. Total database time is the time spent by the database on user-level calls. | |
oracle.executions.per.txn | Executions Per Txn | NULL | The average amount of time per execution. | |
oracle.executions.per.sec | Executions Per Sec | NULL | The average transactions per second. | |
oracle.sql.service.response.time | Sql Service Response Time | ms | SQL Response Time is the average elapsed time per execution of a representative set of SQL statements,relative to a baseline. | |
oracle.user.transaction.per.sec | User Transaction Per Sec | NULL | The User Commits Per Sec Oracle metric data item represents the number of user commits performed,per second during the sample period. | |
oracle.response.time.per.txn | Response Time Per Txn | NULL | The Response Time Per Txn Oracle metric is using only statistics available within the database,this data item gives the best approximation of response time,in seconds,per transaction during this sample period. | |
oracle.database.wait.time.ratio | Database Wait Time Ratio | NULL | It monitors database wait time ratio. |
Advanced Cloud Database Template for PostgreSQL
Description
Advanced Cloud Database Template for PostgreSQL
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud PostgreSQL Database Transactions RolledBack Monitor | postgresql.database.transaction.rollback | Postgresql Database Transactions RolledBack | NULL | Number of transactions in this database that have been rolled back. |
Advanced Cloud PostgreSQL Database Session Monitor | postgresql.activity.count | Postgresql Activity Count | NULL | This will tell you how close you are to hitting your max_connections limit,and show up any clients which are leaking database connections. |
postgresql.locks.count | Postgresql Locks Count | NULL | The number of connections blocked waiting for a lock can be an indicator of a slow transaction with an exclusive lock. | |
Advanced Cloud PostgreSQL Database Performance Monitor | postgresql.database.temp_bytes | Postgresql Database Temporary Bytes | NULL | Total amount of data written to temporary files by queries in this database. All temporary files are counted,regardless of why the temporary file was created,and regardless of the log_temp_files setting. |
postgresql.database.rows_fetched | Postgresql Database Rows Fetched | NULL | Number of rows fetched by queries in this database. | |
postgresql.database.rows_returned | Postgresql Database Rows Returned | NULL | Number of rows returned by queries in this database. | |
postgresql.database.rows_updated | Postgresql Database Rows Updated | NULL | Number of rows updated by queries in this database. | |
postgresql.database.rows_deleted | Postgresql Database Rows Deleted | NULL | Number of rows deleted by queries in this database. | |
postgresql.database.rows_inserted | Postgresql Database Rows Inserted | NULL | Number of rows inserted by queries in this database. | |
postgresql.stat_tables.seq_tup_read | Postgresql Tables Row Sequential Scan | NULL | Number of live rows fetched by sequential scans. | |
postgresql.bgwriter.buffers_checkpoint | Postgresql Bgwriter Buffers Checkpoint | NULL | Number of buffers written during checkpoints. | |
postgresql.bgwriter.buffers_clean | Postgresql Bgwriter Buffers Clean | NULL | Number of buffers written by the background writer. | |
postgresql.bgwriter.buffers_backend | Postgresql Bgwriter Buffers Backend | NULL | Number of buffers written directly by a backend. | |
postgresql.bgwriter.checkpoints_timed | Postgresql Bgwriter Checkpoints Timed | NULL | Number of scheduled checkpoints that have been performed. | |
postgresql.bgwriter.checkpoints_req | Postgresql Bgwriter Checkpoints Request | NULL | Number of requested checkpoints that have been performed. | |
Advanced Cloud PostgreSQL Database Memory Monitor | postgresql.database.size | Postgresql Database Size | GB | This helps is know the size of the database. |
Advanced Cloud PostgreSQL Database Locks Monitor | postgresql.usertable.rowsdead | Postgresql User Table Rows Dead | NULL | This query gives the number of dead rows (tuples) in the table. |
postgresql.database.deadlocks | Postgresql Database Deadlocks | count | Number of deadlocks detected in this database. | |
postgresql.locks.granted | Postgresql Locks Granted | NULL | True if lock is held,false if lock is awaited. | |
Advanced Cloud PostgreSQL Database IO Monitor | postgresql.statio_tables.buffer_hits | Postgresql Statio Tables Buffer Hits | hps | Number of buffer hits in this table. |
postgresql.statio_tables.index_block_read | Postgresql Statio Tables Index Block Read | NULL | Number of disk blocks read from all indexes on this table. | |
postgresql.statio_tables.index_buffer_hit | Postgresql Statio Tables Index Buffer Hits | hps | Number of buffer hits in all indexes on this table. | |
Advanced Cloud PostgreSQL Database Disk Usage Monitor | postgresql.class.relpages | Postgresql Class Relpages | count | This query is used to display the tables and their respective indexes in descending order of relpages. |
Advanced Cloud PostgreSQL Database Deadlocks Monitor | postgresql.database.deadlocks | Postgresql Database Deadlocks | count | Number of deadlocks detected in this database. |
postgresql.database.conflict.deadlocks | Postgresql Database Conflict Deadlocks | count | Number of conflicts in this database that have been canceled due to deadlocks. | |
Advanced Cloud PostgreSQL Database Cpu Utilization Monitor | postgresql.activity.long_transactions | Postgresql Activity Long Transactions | h | Long-running transactions are bad because they prevent Postgres from vacuuming old data. This causes database bloat and,in extreme circumstances,shutdown due to transaction ID (xid) wraparound. Transactions should be kept as short as possible,ideally less than a minute. |
Advanced Cloud PostgreSQL Database Connection Statistics Monitor | postgresql.database.connections | Postgresql Database Connections | NULL | The number of active connections to postgres database. |
postgresql.settings.connection | Postgresql Settings Connections | NULL | The number of connections to this database as a fraction of the maximum number of allowed connections. | |
postgresql.user_tables.rows_count | Postgresql User Tables Rows Count | count | Number of rows scans. | |
postgresql.max_connections | Postgresql Max Connections | NULL | The maximum number of client connections allowed to this database.shown as connection. | |
postgresql.user.table.count | User Table Count | NULL | It monitors the number of user tables in current database. | |
Advanced Cloud PostgreSQL Database BlockHits Monitor | postgresql.statiotables.toastblkshit | Postgresql Statio Tables Toast Blks Hit | NULL | Number of buffer hits in this table's TOAST table (if any). |
postgresql.statiotables.idxblkshit | Postgresql Statio Tables Idx Blks Hit | count | Number of buffer hits in all indexes on this table. | |
postgresql.database.blkshit | Postgresql Database Blocks Hits | NULL | Number of times disk blocks were found already in the buffer cache,so that a read was not necessary (this only includes hits in the PostgreSQL buffer cache,not the operating system's file system cache). | |
postgresql.statioindexes.bufferhits | Postgresql Statio Indexes Buffer Hits | NULL | Number of buffer hits in this index |
Advanced Cloud MSSQL Database Access Methods Template
Description
Advanced Cloud MSSQL Database Access Methods Template.
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MSSQL Database Access Methods Monitor | mssql.page.splits | Page splits | psec | The number of page splits per second that occur as the result of overflowing index pages. |
mssql.full.scans | Full scans | psec | Number of unrestricted full scans. These can either be base table or full index scans. |
Advanced Cloud MSSQL Database Buffer Template
Description
Advanced Cloud MSSQL Database Buffer Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MSSQL Database Buffer Monitor | mssql.database.page.reads | Page reads | psec | Number of physical database page reads issued. |
mssql.database.page.writes | Database Page writes | wps | Number of physical database page writes issued. | |
mssql.buffer.lazy.writes | Buffer lazy writes | wps | Number of buffers written by buffer manager's lazy writer. | |
mssql.checkpoint.pages | Checkpoint pages | psec | Indicates the number of pages flushed to disk per second by a checkpoint or other operation that require all dirty pages to be flushed. |
Advanced Cloud MSSQL Database Databases Template
Description
Advanced Cloud MSSQL Database Databases Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MSSQL Database Databases Monitor | mssql.log.flushes | Log Flushes | psec | The number of log flushes. |
mssql.db.transactions | Db transactions | psec | The number of transactions started for the database. | |
mssql.db.data.file.size | Data File Size | KB | The cumulative size of all the data files in the database. | |
mssql.lock.deadlocks | Deadlocks | psec | The number of lock requests that resulted in a deadlock. |
Advanced Cloud MSSQL Database General Statistics Template
Description
Advanced Cloud MSSQL Database General Statistics Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MSSQL Database General Statistics Monitor | mssql.user.connections | User connections | NULL | The number of users connected to the system. |
mssql.blocked.process | Blocked processes | NULL | The number of currently blocked processes. |
Advanced Cloud MSSQL Database Latches Template
Description
Advanced Cloud MSSQL Database Latches Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MSSQL Database Latches Monitor | mssql.latch.waits | Latch waits | psec | Number of latch requests that could not be granted immediately and had to wait before being granted. |
Advanced Cloud MSSQL Database Locks Template
Description
Advanced Cloud MSSQL Database Locks Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MSSQL Database Locks Monitor | mssql.lock.waits | Lock waits | psec | Number of lock requests that could not be satisfied immediately and required the caller to wait before being granted the lock. |
mssql.avg.lock.wait.time | Average lock wait time | ms | The average amount of wait time (milliseconds) for each lock request that resulted in a wait. | |
mssql.lock.timeouts | Lock timeouts | psec | Number of lock requests that timed out. This includes requests for no wait locks. |
Advanced Cloud MSSQL Database Memory Manager Template
Description
Advanced Cloud MSSQL Database Memory Manager Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MSSQL Database Memory Manager Monitor | mssql.total.server.memory | Total server memory | KB | Total amount of dynamic memory the server is currently consuming. |
mssql.memory.grants.pending | Memory Grants Pending | NULL | Current number of processes waiting for a workspace memory grant. | |
mssql.database.cache.memory | Database cache memory | KB | Amount of memory the server is currently using for the database cache. | |
mssql.connection.memory | Connection Memory | KB | Total amount of dynamic memory the server is using for maintaining connections. | |
mssql.lock.memory | Lock Memory | KB | Total amount of dynamic memory the server is using for locks. | |
mssql.free.memory | Free Memory | KB | Amount of memory the server is currently not using. | |
mssql.sql.cache.memory | SQL Cache Memory | KB | Total amount of dynamic memory the server is using for the dynamic SQL cache. | |
mssql.optimizer.memory | Optimizer Memory | KB | Total amount of dynamic memory the server is using for query optimization. |
Advanced Cloud MSSQL Database Miscellaneous Template
Description
Advanced Cloud MSSQL Database Miscellaneous Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MSSQL Database Miscellaneous Monitor | msql.last.elapsed.time | Last elapsed time | microsec | Elapsed time,reported in microseconds (but only accurate to milliseconds),for the most recently completed execution of this plan. |
mssql.buffer.cache.hit.ratio | Buffer cache hit ratio | None | Percentage of pages that were found in the buffer pool without having to incur a read from disk. | |
mssql.procedure.cache.hit.ratio | Procedure Cache Hit Ratio | NULL | Procedure Cache Hit ratio (calculated from server start-up). | |
mssql.page.life.expectancy | MSSQL PageLifeExpectancy | s | Number of seconds a page will stay in the buffer pool without references. |
Advanced Cloud MSSQL Database Resource pool Stats Template
Description
Advanced Cloud MSSQL Database Resource pool Stats Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MSSQL Database Resource pool Stats Monitor | mssql.resource.pool.used.memory | Resource pool used memory | KB | The amount of memory used,in kilobytes (KB),for the resource pool. |
mssql.resource.pool.disk.read.io | Resource pool disk read IO | rops | Number of read operations from the disk in the last second. | |
mssql.resource.pool.disk.write.io | Resource pool disk write IO | wps | Number of bytes written to the disk in the last second. |
Advanced Cloud MSSQL Database SQL Statistics Template
Description
Advanced Cloud MSSQL Database SQL Statistics Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MSSQL Database SQL Statistics Monitor | mssql.batch.requests | Batch requests | psec | Number of SQL batch requests received by server. |
mssql.sql.compilations | Sql compilations | psec | Number of SQL compilations. | |
msql.sql.recompilations | Sql recompilations | psec | Number of statement recompiles per second. Counts the number of times statement recompiles are triggered. Generally,you want the recompiles to be low. |
Advanced Cloud MSSQL Database Transactions Template
Description
Advanced Cloud MSSQL Database Transactions Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MSSQL Database Transactions Monitor | mssql.longest.transaction time | Longest transaction time | s | The length of time (in seconds) since the start of the transaction that has been active longer than any other current transaction. This counter only shows activity when the database is under read committed snapshot isolation level. It does not log any activity if the database is in any other isolation level. |
Advanced Cloud MySQL Database Command Template
Description
Advanced Cloud MySQL Database Command Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MySQL Database Command Monitor | mysql.update.commands | MySQL Update Commands | psec | The number of times UPDATE command has been executed. |
mysql.select.commands | MySQL Select Command | psec | The number of times SELECT command has been executed. | |
mysql.delete.commands | MySQL Delete Command | psec | The number of times Delete command has been executed. | |
mysql.insert.commands | MySQL Insert Command | psec | The number of times Insert command has been executed. | |
mysql.rollback.commands | MySQL Rollback Command | psec | The number of times RollBack command has been executed. | |
mysql.droptable.commands | MySQL DropTable Command | psec | The number of times Drop Table command has been executed. | |
mysql.dropuser.commands | MySQL Dropuser Commands | psec | The number of times DROP USER command has been executed. | |
mysql.dropdatabase.commands | MySQL DropDatabase Commands | psec | The number of times DROP DATABASE command has been executed. | |
mysql.createtable.commands | MySQL CreateTable Commands | psec | The number of times CREATE TABLE command has been executed. | |
mysql.createuser.commands | MySQL Createuser Commands | psec | The number of times CREATE USER command has been executed. | |
mysql.createdatabase.commands | MySQL Createdatabase Commands | psec | The number of times CREATE DATABASE command has been executed. | |
mysql.slow.query.count | MySQL Slow Query Count | qpm | MySQL Slow Query Count. |
Advanced Cloud MySQL Database Connection Template
Description
Advanced Cloud MySQL Database Connection Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MySQL Database Connection Monitor | mysql.aborted.clients | MySQL Aborted Clients | count | The number of connections that were aborted because the client died without closing the connection properly. |
mysql.max.connections | MySQL Max Connections | count | Max Limit of Connections. | |
mysql.max.connections.connection_errors | MySQL Max Connections Connection Errors | count | The number of connections refused due to internal server errors. | |
mysql.aborted.connects | MySQL Aborted Connects | count | The number of failed attempts to connect to the MySQL server. | |
mysql.internal.connection.errors | MySQL Internal Connection Errors | count | The number of connections refused due to internal errors in the server,such as failure to start a new thread or an out-of-memory condition. | |
mysql.ssl.client.connects | MySQL SSL Client Connects | count | The number of SSL connection attempts to an SSL-enabled master. | |
mysql.active.transactions | MySQL Active Transactions | count | Number of active transactions | |
mysql.server.connections | MySQL Server Connections | count | The number of connection attempts (successful or not) to the MySQL server. |
Advanced Cloud MySQL Database innoDB Template
Description
Advanced Cloud MySQL Database innoDB Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MySQL Database innoDB Monitor | mysql.innodb.data.pending.reads | MySQL Innodb Data Pending Reads | count | The current number of pending reads. |
mysql.innodb.data.pending.writes | MySQL Innodb Data Pending Writes | count | The total number of data writes. | |
mysql.innodb.bufferpool.pagesfree | MySQL Innodb Buffer Pool Pages free | count | The number of free pages in the InnoDB Buffer Pool. | |
mysql.innodb.bufferpool.pagestotal | Mysql Innodb Bufferpool Pagestotal | count | The total number of pages in the InnoDB Buffer Pool. | |
mysql.innodb.buffer_pool_reads | MySQL Innodb Bufferpool Reads | count | The number of logical reads that InnoDB could not satisfy from the buffer pool,and had to read directly from the disk. | |
mysql.innodb.buffer_pool_read_requests | MySQL Innodb Bufferpool Read Requests | count | The number of reads done to the InnoDB buffer pool. | |
mysql.innodb.buffer_pool_write_requests | MySQL Innodb Bufferpool Write Requests | count | The number of writes done to the InnoDB buffer pool. | |
mysql.innodb.bufferpool.dirtypages | Mysql Innodb Bufferpool Dirtypages | count | The current number of dirty pages in the InnoDB buffer pool. | |
mysql.innodb.bufferpool.utilization | MySQL Innodb Bufferpool Utilization | % | The utilization of the InnoDB Buffer Pool. Shown as fraction. | |
mysql.innodb.data.reads | MySQL Innodb Data Reads | count | The total number of data reads (OS file reads). | |
mysql.innodb.data.writes | MySQL InnoDB Data Writes | count | The total number of data writes. | |
mysql.innodb.row.lock.waits | MySQL Innodb Row Lock waits | count | The number of times operations on InnoDB tables had to wait for a row lock. | |
mysql.innodb.row.lock.time | mysql Innodb Row Lock Time | ms | The total time spent in acquiring row locks for InnoDB tables,in milliseconds. |
Advanced Cloud MySQL Database Miscellaneous Template
Description
Advanced Cloud MySQL Database Miscellaneous Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MySQL Database Miscellaneous Monitor | mysql.slave.status | MySQL Slave Status | MySQL Slave Status. | |
mysq.slave.seconds.behind.master | MySQL Slave behind master | MySQL Slave behind master. | ||
mysql.system.uptime | MySQL System Uptime | m | MySQL System Uptime. | |
mysql.streams.open | MySQL Streams Open | count | The number of streams that are open (used mainly for logging). |
Advanced Cloud MySQL Database Network Template
Description
Advanced Cloud MySQL Database Network Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MySQL Database Network Monitor | mysql.bytes.received | MySQL Bytes Received | Bps | The number of bytes received from all clients. |
mysql.bytes.sent | MySQL Bytes Sent | Bps | The number of bytes sent to all clients. |
Advanced Cloud MySQL Database Table Template
Description
Advanced Cloud MySQL Database Table Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MySQL Database Table Monitor | mysq.tmp.table.delta.util | MySL temporary table delta utilization | MySL temporary table delta utilization. | |
mysq.tmp.table.util | MySQL temporary table utilization | MySQL temporary table utilization. | ||
mysql.temporary.files.created | MySQL Temporary Files Created | psec | The rate of temporary files created by second. | |
mysql.disk.temporarytables.created | MySQL Disk Temporary Tables Created | psec | The rate of temporary tables created by second. | |
mysql.full.table.scan.delta.util | MySQL full table scan delta utilization | MySQL full table scan delta utilization. | ||
mysql.full.table.scan.util | MySQL full table scan utilization | MySQL full table scan utilization. | ||
mysq.open.files.util | MySQL Open file utilization | MySQL Open file utilization. | ||
mysql.open.files | MySQL Open Files | count | The number of files that have been opened with my_open() (a mysys library function). Parts of the server that open files without using this function do not increment the count | |
mysql.open.tables | MySQL Open Tables | count | The number of tables that have been opened with my_open(). | |
mysql.table.locks_immediate | MySQL Table Locks Immediate | count | The number of times that a request for a table lock could be granted immediately. |
Advanced Cloud MySQL Database Threads Template
Description
Advanced Cloud MySQL Database Threads Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud MySQL Database Threads Monitor | mysql.connected.threads.count | MySQL Connected Threads count | MySQL Connected Threads count | |
mysql.created.threads | MySQL Created Threads | count | The number of threads created to handle connections. If Threads_created is big,you may want to increase the thread_cache_size value. The cache miss rate can be calculated as Threads_created/Connections. | |
mysql.threads.cached.count | MySQL Cached Threads count | MySQL Cached Threads count | ||
mysql.running.threads | MySQL Running Threads | count | The number of threads that are not sleeping. | |
mysql.threads.stacksize | MySQL Threads Stacksize | NULL | The stack size for each thread. Many of the limits detected by the crash-me test are dependent on this value. |
Advanced Cloud Oracle Database Errors Template
Description
Advanced Cloud Oracle Database Errors Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud Oracle Errors | oracle.errors | OracleErrors | NULL | OracleErrors |
Advanced Cloud Oracle Database Library stats Template
Description
Advanced Cloud Oracle Database Library stats Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud Oracle Library stats | oracle.library.cache.gets | Oracle Library Cache Gets | Validates the Number of Library Cache gets by database. | |
oracle.library.cachereloads | Library Cache Reloads | NULL | Validates the Number of Library Cache Reloads by database. | |
oracle.cache.invalidations | Oracle Cache Invalidations | Validates the how many Cache invalidations on particular database. |
Advanced Cloud Oracle Database Performance Template
Description
Advanced Cloud Oracle Database Performance Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud OracleDB Performance | oracle.invalid.objects | Invalid Objects | count | Checks for invalid objects in database. |
oracle.failed.logon.count | Failed Logon Count | count | It monitors the failed logon attempts of the current user. | |
oracle.blocking.lock.queries | Oracle Blocking Lock Queries | count | Validates the how many block lock queries?on particular database. | |
oracle.long.running.queries | Oracle Long Running Queries | count | Validates the how many long running queries?on particular database. |
Advanced Cloud Oracle Database Sessions Template
Description
Advanced Cloud Oracle Database Sessions Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud Oracle Sessions | oracle.session.cpu_used | Session Cpu Used | s | It monitors the session cpu usage in seconds. |
oracle.active.sessions | Active Sessions | count | It monitors the active sessions. | |
oracle.inactive.sessions | Inactive Sessions | count | It monitors the inactive sessions. | |
oracle.session.limit.usage | Session Limit Usage | % | It monitors the sessions utilization. | |
oracle.session.waits | Session Waits | s | It monitors the session waits. |
Advanced Cloud Oracle Database SGA stats Template
Description
Advanced Cloud Oracle Database SGA stats Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud Oracle SGA stats | oracle.shared.pool.free | Shared Pool Free | MB | It monitors the free shared pool memory in MB. |
oracle.java.pool.free | Java Pool Free | MB | It monitors the free java pool memory in MB. | |
oracle.large.pool.free | Large Pool Free | MB | It monitors the free large pool memory in MB. |
Advanced Cloud Oracle Database System Stats Template
Description
Advanced Cloud Oracle Database System Stats Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud Oracle System Stats | oracle.user.commits | User Commits | psec | This metric represents the number of user commits performed per second in last two monitoring polls. |
oracle.redo.log.space.requests | Redo Log Space Requests | Req per Sec | It represents the active log file is full and Oracle is waiting for disk space to be allocated for the redo log entries. | |
oracle.user.rollbacks.persec | User Rollbacks | psec | This metric represents the number of times,per second,that users manually issue the ROLLBACK statement or an error occurred during a user's transactions. | |
oracle.cache.blocks.lost | Cache Blocks Lost | count | This metric represents the number of global cache blocks lost over the user-defined observation period. | |
oracle.table.scan.blocks.persec | Table Scan Blocks | psec | Number of blocks received via table scans. | |
oracle.io.wait.time | IO Wait Time | ms | How much time the application was blocked,waiting for all I/O operation to complete. | |
oracle.logons.per.sec | Logons Per Sec | count | This metric represents the number of logons per second during the sample period. | |
oracle.db.instance.uptime | DB Instance Uptime | Days | It represents db instance uptime since start up. | |
oracle.check.db.alive | Check Db Alive | NULL | Monitors connectivity to the database instance. |
Advanced Cloud Oracle Database System Summary Template
Description
Advanced Cloud Oracle Database System Summary Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud Oracle System Summary | oracle.cpu.usage.per.sec | CPU Usage Per Sec | NULL | This metric represents the CPU usage per second by the database processes,measured in hundredths of a second. |
oracle.cpu.usage.per.txn | CPU Usage Per Txn | NULL | The amount of CPU usage per transaction for the specific task or session. | |
oracle.database.cpu.time.ratio | Database CPU Time Ratio | NULL | The Database CPU Time Ratio is of limited value as a tuning tool.The Database CPU Time Ratio is computed by dividing the amount of CPU used in the database by the amount of total database time. Total database time is the time spent by the database on user-level calls. | |
oracle.executions.per.txn | Executions Per Txn | NULL | The average amount of time per execution | |
oracle.executions.per.sec | Executions Per Sec | NULL | The average transactions per second | |
oracle.sql.service.response.time | Sql Service Response Time | ms | SQL Response Time is the average elapsed time per execution of a representative set of SQL statements,relative to a baseline. | |
oracle.user.transaction.per.sec | User Transaction Per Sec | NULL | The User Commits Per Sec Oracle metric data item represents the number of user commits performed,per second during the sample period. | |
oracle.response.time.per.txn | Response Time Per Txn | NULL | The Response Time Per Txn Oracle metric is using only statistics available within the database,this data item gives the best approximation of response time,in seconds,per transaction during this sample period. | |
oracle.database.wait.time.ratio | Database Wait Time Ratio | NULL | It monitors database wait time ratio. |
Advanced Cloud Oracle Database Table Space Template
Description
Advanced Cloud Oracle Database Table Space Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Oracle Table Space | oracle.table.space.util | Table Space Utilization | % | It monitors the table space utilization. |
oracle.table.space.used | Table Space Used | Mb | It monitors the table space used. | |
oracle.temp.table.space.free | Temp Table Space Free. | Mb | It monitors temporary table space free. | |
oracle.temp.table.space.used | Temp Table Space Used | Mb | It monitors temporary table space used. | |
oracle.temp.table.space.util | Temp Table Space Utilization | % | It monitors temporary table space utilization. | |
oracle.table.space.free | Oracle Table Space Free | MB | Validates the Size allocated for the table by database. | |
Advanced Cloud Oracle Table Space | oracle.table.space.util | Table Space Utilization | % | It monitors the table space utilization. |
oracle.table.space.used | Table Space Used | Mb | It monitors the table space used. | |
oracle.temp.table.space.free | Temp Table Space Free | Mb | It monitors temporary table space free. | |
oracle.temp.table.space.used | Temp Table Space Used | Mb | It monitors temporary table space used. | |
oracle.temp.table.space.util | Temp Table Space Utilization | % | It monitors temporary table space utilization. | |
oracle.table.space.free | Oracle Table Space Free | MB | Validates the Size allocated for the table by database. |
Advanced Cloud PostgreSQL Database BlockHits Template
Description
Advanced Cloud PostgreSQL Database BlockHits Template.
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud PostgreSQL Database BlockHits Monitor | postgresql.statiotables.toastblkshit | Postgresql Statio Tables Toast Blks Hit | NULL | Number of buffer hits in this table's TOAST table (if any). |
postgresql.statiotables.idxblkshit | Postgresql Statio Tables Idx Blks Hit | count | Number of buffer hits in all indexes on this table. | |
postgresql.database.blkshit | Postgresql Database Blocks Hits | NULL | Number of times disk blocks were found already in the buffer cache,so that a read was not necessary (this only includes hits in the PostgreSQL buffer cache,not the operating system's file system cache). | |
postgresql.statioindexes.bufferhits | Postgresql Statio Indexes Buffer Hits | NULL | Number of buffer hits in this index. |
Advanced Cloud PostgreSQL Database Connection Statistics Template
Description
Advanced Cloud PostgreSQL Database Connection Statistics Template.
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud PostgreSQL Database Connection Statistics Monitor | postgresql.database.connections | Postgresql Database Connections | NULL | The number of active connections to postgres database. |
postgresql.settings.connection | Postgresql Settings Connections | NULL | The number of connections to this database as a fraction of the maximum number of allowed connections. | |
postgresql.user_tables.rows_count | Postgresql User Tables Rows Count | count | number of rows scans. | |
postgresql.max_connections | Postgresql Max Connections | NULL | The maximum number of client connections allowed to this database.shown as connection. | |
postgresql.user.table.count | User Table Count | NULL | It monitors the number of user tables in current database. |
Advanced Cloud PostgreSQL Database Cpu Utilization Template
Description
Advanced Cloud PostgreSQL Database Cpu Utilization Template.
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud PostgreSQL Database Cpu Utilization Monitor | postgresql.activity.long_transactions | Postgresql Activity Long Transactions | h | Long-running transactions are bad because they prevent Postgres from vacuuming old data. This causes database bloat and,in extreme circumstances,shutdown due to transaction ID (xid) wraparound. Transactions should be kept as short as possible,ideally less than a minute. |
Advanced Cloud PostgreSQL Database Deadlocks Template
Description
Advanced Cloud PostgreSQL Database Deadlocks Template
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud PostgreSQL Database Deadlocks Monitor | postgresql.database.deadlocks | Postgresql Database Deadlocks | count | Number of deadlocks detected in this database. |
postgresql.database.conflict.deadlocks | Postgresql Database Conflict Deadlocks | count | Number of conflicts in this database that have been canceled due to deadlocks. |
Advanced Cloud PostgreSQL Database Disk Usage Template
Description
Advanced Cloud PostgreSQL Database Disk Usage Template.
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud PostgreSQL Database Disk Usage Monitor | postgresql.class.relpages | Postgresql Class Relpages | count | This query is used to display the tables and their respective indexes in descending order of relpages. |
Advanced Cloud PostgreSQL Database IO Template
Description
Advanced Cloud PostgreSQL Database IO Template.
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud PostgreSQL Database IO Monitor | postgresql.statio_tables.buffer_hits | Postgresql Statio Tables Buffer Hits | hps | Number of buffer hits in this table. |
postgresql.statio_tables.index_block_read | Postgresql Statio Tables Index Block Read. | NULL | Number of disk blocks read from all indexes on this table. | |
postgresql.statio_tables.index_buffer_hit | Postgresql Statio Tables Index Buffer Hits | hps | Number of buffer hits in all indexes on this table |
Advanced Cloud PostgreSQL Database Locks Template
Description
Advanced Cloud PostgreSQL Database Locks Template.
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud PostgreSQL Database Locks Monitor | postgresql.usertable.rowsdead | Postgresql User Table Rows Dead | NULL | This query gives the number of dead rows (tuples) in the table. |
postgresql.database.deadlocks | Postgresql Database Deadlocks | count | Number of deadlocks detected in this database. | |
postgresql.locks.granted | Postgresql Locks Granted | NULL | True if lock is held,false if lock is awaited. |
Advanced Cloud PostgreSQL Database Memory Template
Description
Advanced Cloud PostgreSQL Database Memory Template.
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud PostgreSQL Database Memory Monitor | Advanced Cloud PostgreSQL Database Memory Monitor | Postgresql Database Size | GB | This helps is know the size of the database. |
Advanced Cloud PostgreSQL Database Performance Template
Description
Advanced Cloud PostgreSQL Database Performance Template.
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud PostgreSQL Database Performance Monitor | postgresql.database.temp_bytes | Postgresql Database Temporary Bytes | NULL | Total amount of data written to temporary files by queries in this database. All temporary files are counted,regardless of why the temporary file was created,and regardless of the log_temp_files setting. |
postgresql.database.rows_fetched | Postgresql Database Rows Fetched | NULL | Number of rows fetched by queries in this database. | |
postgresql.database.rows_returned | Postgresql Database Rows Returned | NULL | Number of rows returned by queries in this database. | |
postgresql.database.rows_updated | Postgresql Database Rows Updated | NULL | Number of rows updated by queries in this database. | |
postgresql.database.rows_deleted | Postgresql Database Rows Deleted | NULL | Number of rows deleted by queries in this database. | |
postgresql.database.rows_inserted | Postgresql Database Rows Inserted | NULL | Number of rows inserted by queries in this database. | |
postgresql.stat_tables.seq_tup_read | Postgresql Tables Row Sequential Scan | NULL | Number of live rows fetched by sequential scans. | |
postgresql.bgwriter.buffers_checkpoint | Postgresql Bgwriter Buffers Checkpoint | NULL | Number of buffers written during checkpoints | |
postgresql.bgwriter.buffers_clean | Postgresql Bgwriter Buffers Clean | NULL | Number of buffers written by the background writer. | |
postgresql.bgwriter.buffers_backend | Postgresql Bgwriter Buffers Backend | NULL | Number of buffers written directly by a backend. | |
postgresql.bgwriter.checkpoints_timed | Postgresql Bgwriter Checkpoints Timed | NULL | Number of scheduled checkpoints that have been performed. | |
postgresql.bgwriter.checkpoints_req | Postgresql Bgwriter Checkpoints Request | NULL | Number of requested checkpoints that have been performed. |
Advanced Cloud PostgreSQL Database Session Template
Description
Advanced Cloud PostgreSQL Database Session Template.
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud PostgreSQL Database Session Monitor | postgresql.activity.count | Postgresql Activity Count | NULL | This will tell you how close you are to hitting your max_connections limit,and show up any clients which are leaking database connections. |
postgresql.locks.count | Postgresql Locks Count | NULL | The number of connections blocked waiting for a lock can be an indicator of a slow transaction with an exclusive lock. |
Advanced Cloud PostgreSQL Database Transactions RolledBack Template
Description
Advanced Cloud PostgreSQL Database Transactions RolledBack Template.
Prerequisites
No prerequisite
Supported Metric
Monitor Name | Metric Name | Metric Display Name | Unit | Description |
---|---|---|---|---|
Advanced Cloud PostgreSQL Database Transactions RolledBack Monitor | postgresql.database.transaction.rollback | Postgresql Database Transactions RolledBack | NULL | Number of transactions in this database that have been rolled back. |