SQL Container Metrics (MySQL DB)

The following table describes the metrics that are required for monitoring the health of the MySQL DB services.
Note:
  • Data field is the name of the metric in the captured data.
  • Given fields are key fields which can be used to identify any abnormalities.
  • For more information on MySQL server status monitoring, see https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html.
MySQL DB Stats Sample: 
DB-Stats Sample

{
"Connection_errors_accept": 0,
"Connection_errors_internal": 0,
"Connection_errors_max_connections": 0,
"Connection_errors_peer_address": 0,
"Connection_errors_select": 0,
"Connection_errors_tcpwrap": 0,
"Connections": 234,
"Delayed_insert_threads": 0,
"Innodb_buffer_pool_dump_status": "Dumping",
"Innodb_buffer_pool_load_status": "Buffer",
"Innodb_buffer_pool_resize_status": "",
"Innodb_buffer_pool_pages_data": 1802,
"Innodb_buffer_pool_bytes_data": 29523968,
"Innodb_buffer_pool_pages_dirty": 0,
"Innodb_buffer_pool_bytes_dirty": 0,
"Innodb_buffer_pool_pages_flushed": 2834,
"Innodb_buffer_pool_pages_free": 6302,
"Innodb_buffer_pool_pages_misc": 87,
"Innodb_buffer_pool_pages_total": 8191,
"Innodb_buffer_pool_read_ahead_rnd": 0,
"Innodb_buffer_pool_read_ahead": 0,
"Innodb_buffer_pool_read_ahead_evicted": 0,
"Innodb_buffer_pool_read_requests": 3247529,
"Innodb_buffer_pool_reads": 1603,
"Innodb_buffer_pool_wait_free": 0,
"Innodb_buffer_pool_write_requests": 279100,
"Innodb_data_fsyncs": 11193,
"Innodb_data_pending_fsyncs": 0,
"Innodb_data_pending_reads": 0,
"Innodb_data_pending_writes": 0,
"Innodb_data_read": 29266432,
"Innodb_data_reads": 2006,
"Innodb_data_writes": 13727,
"Innodb_data_written": 126338560,
"Innodb_dblwr_pages_written": 2799,
"Innodb_dblwr_writes": 148,
"Innodb_log_waits": 0,
"Innodb_log_write_requests": 36527,
"Innodb_log_writes": 10540,
"Innodb_os_log_fsyncs": 10722,
"Innodb_os_log_pending_fsyncs": 0,
"Innodb_os_log_pending_writes": 0,
"Innodb_os_log_written": 33955840,
"Innodb_page_size": 16384,
"Innodb_pages_created": 134,
"Innodb_pages_read": 1668,
"Innodb_pages_written": 2834,
"Innodb_row_lock_current_waits": 0,
"Innodb_row_lock_time": 0,
"Innodb_row_lock_time_avg": 0,
"Innodb_row_lock_time_max": 0,
"Innodb_row_lock_waits": 0,
"Innodb_rows_deleted": 11712,
"Innodb_rows_inserted": 11924,
"Innodb_rows_read": 4709484,
"Innodb_rows_updated": 90,
"Innodb_num_open_files": 76,
"Innodb_truncated_status_writes": 0,
"Innodb_available_undo_logs": 128,
"Max_used_connections": 6,
"Max_used_connections_time": "2019-03-25",
"Performance_schema_accounts_lost": 0,
"Performance_schema_cond_classes_lost": 0,
"Performance_schema_cond_instances_lost": 0,
"Performance_schema_digest_lost": 0,
"Performance_schema_file_classes_lost": 0,
"Performance_schema_file_handles_lost": 0,
"Performance_schema_file_instances_lost": 0,
"Performance_schema_hosts_lost": 0,
"Performance_schema_index_stat_lost": 0,
"Performance_schema_locker_lost": 0,
"Performance_schema_memory_classes_lost": 0,
"Performance_schema_metadata_lock_lost": 0,
"Performance_schema_mutex_classes_lost": 0,
"Performance_schema_mutex_instances_lost": 0,
"Performance_schema_nested_statement_lost": 0,
"Performance_schema_prepared_statements_lost": 0,
"Performance_schema_program_lost": 0,
"Performance_schema_rwlock_classes_lost": 0,
"Performance_schema_rwlock_instances_lost": 0,
"Performance_schema_session_connect_attrs_lost": 0,
"Performance_schema_socket_classes_lost": 0,
"Performance_schema_socket_instances_lost": 0,
"Performance_schema_stage_classes_lost": 0,
"Performance_schema_statement_classes_lost": 0,
"Performance_schema_table_handles_lost": 0,
"Performance_schema_table_instances_lost": 0,
"Performance_schema_table_lock_stat_lost": 0,
"Performance_schema_thread_classes_lost": 0,
"Performance_schema_thread_instances_lost": 0,
"Performance_schema_users_lost": 0,
"Qcache_queries_in_cache": 0,
"Queries": 415232,
"Slow_launch_threads": 0,
"Slow_queries": 0,
"Threads_cached": 2,
"Threads_connected": 4,
"Threads_created": 6,
"Threads_running": 1,
"Uptime": 19807,
"Uptime_since_flush_status": 19807,
"ingestion_time": "2019-03-25T15:07:38+00:00"
}
Name Data Field Unit Data Type Details
Connection_errors_accept Connection_errors_accept N/A Number The number of errors that occurred during calls to accept() on the listening port.
Connection_errors_max_connections Connection_errors_max_connections N/A Number The number of connections refused because the server max_connections limit was reached.
Connection_errors_peer_address Connection_errors_peer_address N/A Number The number of errors that occurred while searching for connecting client IP addresses.
Innodb_pages_read Innodb_pages_read N/A Number The number of pages read from the InnoDB buffer pool by operations on InnoDB tables.
Innodb_rows_deleted Innodb_rows_deleted N/A Number The number of rows deleted from InnoDB tables.
Innodb_rows_inserted Innodb_rows_inserted N/A Number The number of rows inserted into InnoDB tables.
Innodb_rows_read Innodb_rows_read N/A Number The number of rows read from InnoDB tables.
Innodb_rows_updated Innodb_rows_updated N/A Number The number of rows updated in InnoDB tables.
Max_used_connections Max_used_connections N/A Number The maximum number of connections that have been in use simultaneously since the server started.
Max_used_connections_time Max_used_connections_time N/A Time The time at which Max_used_connections reached its current value.
Queries Queries N/A Number The number of statements executed by the server. This variable includes statements executed within stored programs, unlike the Questions variable. It does not count COM_PING or COM_STATISTICS commands. The discussion at the beginning of this section indicates how to relate this statement-counting status variable to other such variables.
Slow_queries Slow_queries N/A Number The number of queries that have taken more than long_query_time seconds. This counter increments regardless of whether the slow query log is enabled. For information about that log, see Section 5.4.5, "The Slow Query Log" at HTTPS://DEV.MYSQL.COM/DOC/REFMAN/8.0/EN/SLOW-QUERY-LOG.HTML.
Threads_cached Threads_cached N/A Number The number of threads in the thread cache.
Threads_connected Threads_connected N/A Number The number of currently open connections.
Threads_created Threads_created N/A Number 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.
Threads_running Threads_running N/A Number The number of threads that are not sleeping.
Uptime Uptime Seconds Number The number of seconds that the server has been up.
Uptime_since_flush_status Uptime_since_flush_status Seconds Number The number of seconds since the most recent FLUSH STATUS statement.