Skip to main content
Version: Cloud

Monitor Aurora-MySQL DB


Ensure that both the project and application are created within sfPoller. If they have not been created yet, you can click here to learn how to create a project and application in sfPoller.

Configure sfPoller to Collect Metrics

Follow the below step to add endpoints and plugins:

  1. In the Application tab of sfPoller, navigate to your Project > Application.

  2. Click on the Application, it will take you to the Endpoint page.

  3. Click the Add Endpoint button, add the following data, and save.

    • Service Type: Select AWS Service

    • Name: Give a meaningful name to the endpoint

    • IP/Endpoint: Add the application IP

    • Instance Name: Give the Instance name of your application

  4. In the Plugins window, click the +Add button.

  5. In the Add Plugin window, select the below details and save.

    • Plugin Type: Metric

    • Plugin: cloudwatch-aurora or cloudwatch-auroramysqlinsights

    • Interval: Choose an interval value. The minimum value for the interval is 300

    • Status: By default, the status is Enabled

  6. Click the global Save button in the window's top right corner to save all the changes made so far.

View Database Metrics and Logs

Follow the below steps to view the metrics collected from Aurora DB.

  1. Go to the Application tab in SnappyFlow and navigate to your Project > Application > Dashboard.

  2. You can view the database metrics in the Metrics section.


Once plugins are added to sfPoller, they will be automatically detected within the Metrics section. However, if the plugins are not detected, you can import templates to view the corresponding metrics.

  1. To access the unprocessed data gathered from the plugins, navigate to the Browse data section and choose the Index: Metric, Instance: Endpoint, Plugin, and Document Type.

Template Details

TemplatePluginDocument TypeDescription
Auroracloudwatch-auroraInstanceStats, ClusterStatsMonitors AWS AuroraDB instance to collect all the cluster-level and instance-level metrics.
Aurora_MYSQL_Insightscloudwatch-auroramysqlinsightsRDSauroramysqlDetailsMonitors AWS Aurora MySql DB to collect both native and non-native MySql metrics.

Metric List

Aurora-mysql InstanceStats
RowLockTimeThe total time spent acquiring row locks for InnoDB tables.
SelectLatencyThe average amount of time for select operations.
LoginFailuresThe average number of failed login attempts per second.
InsertThroughputThe average number of insert operations per second.
InsertLatencyThe average duration of insert operations.
DMLThroughputThe average number of inserts, updates, and deletes per second.
DMLLatencyThe average duration of inserts, updates, and deletes.
DeleteThroughputThe average number of deleted queries per second.
DeleteLatencyThe average duration of delete operations.
DDLThroughputThe average number of DDL requests per second.
DDLLatencyThe average duration of requests such as example, create, alter, and drop requests.
BlockedTransactionsThe average number of transactions in the database that are blocked per second.
AuroraBinlogReplicaLagThe amount of time that a binary log replica DB cluster running on Aurora MySQL-Compatible Edition lags behind the binary log replication source.
UpdateThroughputThe average number of updates per second.
StorageNetworkTransmitThroughputThe amount of network throughput received from the Aurora storage subsystem by each instance in the DB cluster.
StorageNetworkReceiveThroughputThe amount of network throughput received from the Aurora storage subsystem by each instance in the DB cluster.
SwapUsageThe amount of swap space used. This metric is available for the Aurora MySQL DB instance.
FreeableMemoryThe amount of available random access memory, in bytes.
FreeLocalStorageThis metric reports the amount of storage available to each instance for temporary tables and logs.
DeadlocksThe average number of deadlocks in the database per second.
ReadLatencyThe average amount of time taken per disk I/O operation.
CPUUtilizationThe percentage of CPU used by an instance.
DatabaseConnectionsThe number of client network connections to the database instance.
CommitThroughputThe average number of commit operations per second.
CommitLatencyThe average duration of commit operations.
EngineUptimeThe amount of time that the instance has been running.
db.SQL.Com_selectno of select statements executed.
db.SQL.Innodb_rows_deletedThe number of rows deleted from InnoDB tables.
db.SQL.Innodb_rows_insertedThe number of rows inserted into InnoDB tables.
db.SQL.Innodb_rows_readThe number of rows read into InnoDB tables.
db.SQL.Innodb_rows_updatedThe number of rows updated into InnoDB tables.
db.SQL.QuestionsThe number of statements executed by the server.
db.Users.Aborted_clientsThe number of connections that were aborted because the client died without closing the connection properly.
db.Users.Aborted_connectsThe number of failed attempts to connect to the MySQL server.
db.Users.Threads_createdThe number of threads created to handle connections.
db.Cache.innoDB_buffer_pool_hitsThe number of reads that InnoDB could satisfy from the buffer pool.
db.Cache.innoDB_buffer_pool_hit_rateThe percentage of reads that InnoDB could satisfy from the buffer pool.
db.Cache.innoDB_buffer_pool_usageThe percentage of the InnoDB buffer pool that contains data (pages).
db.Cache.query_cache_hit_rateThe hit ratio for the MySQL result set cache (query cache).
db.SQL.innodb_rows_changedThe total InnoDB row operations
db.Transactions.active_transactionsThe total active transactions.
db.Locks.innodb_deadlocksThe total number of deadlocks.
db.Locks.innodb_lock_timeoutsThe total number of deadlocks that timed out.