Service Instance Metrics

This page describes the metrics used to monitor state of an a9s MariaDB Service Instance. For further information on how to monitor an a9s Service Instance, see the Set up Monitoring section of the Application Developer's documentation.

Metric Groups

info

Some metrics may change between the MariaDB versions, therefore they might differ or not be available based on the MariaDB version that is currently running on the Service Instance. In order to be sure, consult the documentation link provided in the metric item description and confirm the information based on both the MariaDB metric and version.

General Status

General MariaDB status.

info

This table only includes custom metrics not the ones directly exposed by MariaDB. You can find a full list of all existing Metrics below. For a detailed description you can have a look at the official MariaDB documentation

Metric Id	Type	Description
reads	Integer	Sum total of com_select and qcache_hits.
writes	Integer	Sum total of com_insert, com_update, and com_delete.
innodb_buffer_pool_pages_utilization	It is the calculation by the formula (innodb_buffer_pool_pages_total - innodb_buffer_pool_pages_free) / innodb_buffer_pool_pages_total.

info

MariaDB metrics that return ON or OFF will return 1 and 0. All other metrics returning strings are ignored.

Metrics

*.mariadb.*.*.*.*.status.aborted_clients
*.mariadb.*.*.*.*.status.aborted_connects
*.mariadb.*.*.*.*.status.aborted_connects_preauth
*.mariadb.*.*.*.*.status.access_denied_errors
*.mariadb.*.*.*.*.status.acl_column_grants
*.mariadb.*.*.*.*.status.acl_database_grants
*.mariadb.*.*.*.*.status.acl_function_grants
*.mariadb.*.*.*.*.status.acl_package_body_grants
*.mariadb.*.*.*.*.status.acl_package_spec_grants
*.mariadb.*.*.*.*.status.acl_procedure_grants
*.mariadb.*.*.*.*.status.acl_proxy_users
*.mariadb.*.*.*.*.status.acl_role_grants
*.mariadb.*.*.*.*.status.acl_roles
*.mariadb.*.*.*.*.status.acl_table_grants
*.mariadb.*.*.*.*.status.acl_users
*.mariadb.*.*.*.*.status.aria_pagecache_blocks_not_flushed
*.mariadb.*.*.*.*.status.aria_pagecache_blocks_unused
*.mariadb.*.*.*.*.status.aria_pagecache_blocks_used
*.mariadb.*.*.*.*.status.aria_pagecache_read_requests
*.mariadb.*.*.*.*.status.aria_pagecache_reads
*.mariadb.*.*.*.*.status.aria_pagecache_write_requests
*.mariadb.*.*.*.*.status.aria_pagecache_writes
*.mariadb.*.*.*.*.status.aria_transaction_log_syncs
*.mariadb.*.*.*.*.status.binlog_bytes_written
*.mariadb.*.*.*.*.status.binlog_cache_disk_use
*.mariadb.*.*.*.*.status.binlog_cache_use
*.mariadb.*.*.*.*.status.binlog_commits
*.mariadb.*.*.*.*.status.binlog_group_commit_trigger_count
*.mariadb.*.*.*.*.status.binlog_group_commit_trigger_lock_wait
*.mariadb.*.*.*.*.status.binlog_group_commit_trigger_timeout
*.mariadb.*.*.*.*.status.binlog_group_commits
*.mariadb.*.*.*.*.status.binlog_snapshot_position
*.mariadb.*.*.*.*.status.binlog_stmt_cache_disk_use
*.mariadb.*.*.*.*.status.binlog_stmt_cache_use
*.mariadb.*.*.*.*.status.busy_time
*.mariadb.*.*.*.*.status.bytes_received
*.mariadb.*.*.*.*.status.bytes_sent
*.mariadb.*.*.*.*.status.column_compressions
*.mariadb.*.*.*.*.status.column_decompressions
*.mariadb.*.*.*.*.status.com_admin_commands
*.mariadb.*.*.*.*.status.com_alter_db
*.mariadb.*.*.*.*.status.com_alter_db_upgrade
*.mariadb.*.*.*.*.status.com_alter_event
*.mariadb.*.*.*.*.status.com_alter_function
*.mariadb.*.*.*.*.status.com_alter_procedure
*.mariadb.*.*.*.*.status.com_alter_sequence
*.mariadb.*.*.*.*.status.com_alter_server
*.mariadb.*.*.*.*.status.com_alter_table
*.mariadb.*.*.*.*.status.com_alter_tablespace
*.mariadb.*.*.*.*.status.com_alter_user
*.mariadb.*.*.*.*.status.com_analyze
*.mariadb.*.*.*.*.status.com_assign_to_keycache
*.mariadb.*.*.*.*.status.com_backup
*.mariadb.*.*.*.*.status.com_backup_lock
*.mariadb.*.*.*.*.status.com_begin
*.mariadb.*.*.*.*.status.com_binlog
*.mariadb.*.*.*.*.status.com_call_procedure
*.mariadb.*.*.*.*.status.com_change_db
*.mariadb.*.*.*.*.status.com_change_master
*.mariadb.*.*.*.*.status.com_check
*.mariadb.*.*.*.*.status.com_checksum
*.mariadb.*.*.*.*.status.com_commit
*.mariadb.*.*.*.*.status.com_compound_sql
*.mariadb.*.*.*.*.status.com_create_db
*.mariadb.*.*.*.*.status.com_create_event
*.mariadb.*.*.*.*.status.com_create_function
*.mariadb.*.*.*.*.status.com_create_index
*.mariadb.*.*.*.*.status.com_create_package
*.mariadb.*.*.*.*.status.com_create_package_body
*.mariadb.*.*.*.*.status.com_create_procedure
*.mariadb.*.*.*.*.status.com_create_role
*.mariadb.*.*.*.*.status.com_create_sequence
*.mariadb.*.*.*.*.status.com_create_server
*.mariadb.*.*.*.*.status.com_create_table
*.mariadb.*.*.*.*.status.com_create_temporary_table
*.mariadb.*.*.*.*.status.com_create_trigger
*.mariadb.*.*.*.*.status.com_create_udf
*.mariadb.*.*.*.*.status.com_create_user
*.mariadb.*.*.*.*.status.com_create_view
*.mariadb.*.*.*.*.status.com_dealloc_sql
*.mariadb.*.*.*.*.status.com_delete
*.mariadb.*.*.*.*.status.com_delete_multi
*.mariadb.*.*.*.*.status.com_do
*.mariadb.*.*.*.*.status.com_drop_db
*.mariadb.*.*.*.*.status.com_drop_event
*.mariadb.*.*.*.*.status.com_drop_function
*.mariadb.*.*.*.*.status.com_drop_index
*.mariadb.*.*.*.*.status.com_drop_package
*.mariadb.*.*.*.*.status.com_drop_package_body
*.mariadb.*.*.*.*.status.com_drop_procedure
*.mariadb.*.*.*.*.status.com_drop_role
*.mariadb.*.*.*.*.status.com_drop_sequence
*.mariadb.*.*.*.*.status.com_drop_server
*.mariadb.*.*.*.*.status.com_drop_table
*.mariadb.*.*.*.*.status.com_drop_temporary_table
*.mariadb.*.*.*.*.status.com_drop_trigger
*.mariadb.*.*.*.*.status.com_drop_user
*.mariadb.*.*.*.*.status.com_drop_view
*.mariadb.*.*.*.*.status.com_empty_query
*.mariadb.*.*.*.*.status.com_execute_immediate
*.mariadb.*.*.*.*.status.com_execute_sql
*.mariadb.*.*.*.*.status.com_flush
*.mariadb.*.*.*.*.status.com_get_diagnostics
*.mariadb.*.*.*.*.status.com_grant
*.mariadb.*.*.*.*.status.com_grant_role
*.mariadb.*.*.*.*.status.com_ha_close
*.mariadb.*.*.*.*.status.com_ha_open
*.mariadb.*.*.*.*.status.com_ha_read
*.mariadb.*.*.*.*.status.com_help
*.mariadb.*.*.*.*.status.com_insert
*.mariadb.*.*.*.*.status.com_insert_select
*.mariadb.*.*.*.*.status.com_install_plugin
*.mariadb.*.*.*.*.status.com_kill
*.mariadb.*.*.*.*.status.com_load
*.mariadb.*.*.*.*.status.com_lock_tables
*.mariadb.*.*.*.*.status.com_optimize
*.mariadb.*.*.*.*.status.com_preload_keys
*.mariadb.*.*.*.*.status.com_prepare_sql
*.mariadb.*.*.*.*.status.com_purge
*.mariadb.*.*.*.*.status.com_purge_before_date
*.mariadb.*.*.*.*.status.com_release_savepoint
*.mariadb.*.*.*.*.status.com_rename_table
*.mariadb.*.*.*.*.status.com_rename_user
*.mariadb.*.*.*.*.status.com_repair
*.mariadb.*.*.*.*.status.com_replace
*.mariadb.*.*.*.*.status.com_replace_select
*.mariadb.*.*.*.*.status.com_reset
*.mariadb.*.*.*.*.status.com_resignal
*.mariadb.*.*.*.*.status.com_revoke
*.mariadb.*.*.*.*.status.com_revoke_all
*.mariadb.*.*.*.*.status.com_revoke_role
*.mariadb.*.*.*.*.status.com_rollback
*.mariadb.*.*.*.*.status.com_rollback_to_savepoint
*.mariadb.*.*.*.*.status.com_savepoint
*.mariadb.*.*.*.*.status.com_select
*.mariadb.*.*.*.*.status.com_set_option
*.mariadb.*.*.*.*.status.com_show_authors
*.mariadb.*.*.*.*.status.com_show_binlog_events
*.mariadb.*.*.*.*.status.com_show_binlog_status
*.mariadb.*.*.*.*.status.com_show_binlogs
*.mariadb.*.*.*.*.status.com_show_charsets
*.mariadb.*.*.*.*.status.com_show_collations
*.mariadb.*.*.*.*.status.com_show_contributors
*.mariadb.*.*.*.*.status.com_show_create_db
*.mariadb.*.*.*.*.status.com_show_create_event
*.mariadb.*.*.*.*.status.com_show_create_func
*.mariadb.*.*.*.*.status.com_show_create_package
*.mariadb.*.*.*.*.status.com_show_create_package_body
*.mariadb.*.*.*.*.status.com_show_create_proc
*.mariadb.*.*.*.*.status.com_show_create_table
*.mariadb.*.*.*.*.status.com_show_create_trigger
*.mariadb.*.*.*.*.status.com_show_create_user
*.mariadb.*.*.*.*.status.com_show_databases
*.mariadb.*.*.*.*.status.com_show_engine_logs
*.mariadb.*.*.*.*.status.com_show_engine_mutex
*.mariadb.*.*.*.*.status.com_show_engine_status
*.mariadb.*.*.*.*.status.com_show_errors
*.mariadb.*.*.*.*.status.com_show_events
*.mariadb.*.*.*.*.status.com_show_explain
*.mariadb.*.*.*.*.status.com_show_fields
*.mariadb.*.*.*.*.status.com_show_function_status
*.mariadb.*.*.*.*.status.com_show_generic
*.mariadb.*.*.*.*.status.com_show_grants
*.mariadb.*.*.*.*.status.com_show_keys
*.mariadb.*.*.*.*.status.com_show_open_tables
*.mariadb.*.*.*.*.status.com_show_package_body_status
*.mariadb.*.*.*.*.status.com_show_package_status
*.mariadb.*.*.*.*.status.com_show_plugins
*.mariadb.*.*.*.*.status.com_show_privileges
*.mariadb.*.*.*.*.status.com_show_procedure_status
*.mariadb.*.*.*.*.status.com_show_processlist
*.mariadb.*.*.*.*.status.com_show_profile
*.mariadb.*.*.*.*.status.com_show_profiles
*.mariadb.*.*.*.*.status.com_show_relaylog_events
*.mariadb.*.*.*.*.status.com_show_slave_hosts
*.mariadb.*.*.*.*.status.com_show_slave_status
*.mariadb.*.*.*.*.status.com_show_status
*.mariadb.*.*.*.*.status.com_show_storage_engines
*.mariadb.*.*.*.*.status.com_show_table_status
*.mariadb.*.*.*.*.status.com_show_tables
*.mariadb.*.*.*.*.status.com_show_triggers
*.mariadb.*.*.*.*.status.com_show_variables
*.mariadb.*.*.*.*.status.com_show_warnings
*.mariadb.*.*.*.*.status.com_shutdown
*.mariadb.*.*.*.*.status.com_signal
*.mariadb.*.*.*.*.status.com_start_all_slaves
*.mariadb.*.*.*.*.status.com_start_slave
*.mariadb.*.*.*.*.status.com_stmt_close
*.mariadb.*.*.*.*.status.com_stmt_execute
*.mariadb.*.*.*.*.status.com_stmt_fetch
*.mariadb.*.*.*.*.status.com_stmt_prepare
*.mariadb.*.*.*.*.status.com_stmt_reprepare
*.mariadb.*.*.*.*.status.com_stmt_reset
*.mariadb.*.*.*.*.status.com_stmt_send_long_data
*.mariadb.*.*.*.*.status.com_stop_all_slaves
*.mariadb.*.*.*.*.status.com_stop_slave
*.mariadb.*.*.*.*.status.com_truncate
*.mariadb.*.*.*.*.status.com_uninstall_plugin
*.mariadb.*.*.*.*.status.com_unlock_tables
*.mariadb.*.*.*.*.status.com_update
*.mariadb.*.*.*.*.status.com_update_multi
*.mariadb.*.*.*.*.status.com_xa_commit
*.mariadb.*.*.*.*.status.com_xa_end
*.mariadb.*.*.*.*.status.com_xa_prepare
*.mariadb.*.*.*.*.status.com_xa_recover
*.mariadb.*.*.*.*.status.com_xa_rollback
*.mariadb.*.*.*.*.status.com_xa_start
*.mariadb.*.*.*.*.status.connection_errors_accept
*.mariadb.*.*.*.*.status.connection_errors_internal
*.mariadb.*.*.*.*.status.connection_errors_max_connections
*.mariadb.*.*.*.*.status.connection_errors_peer_address
*.mariadb.*.*.*.*.status.connection_errors_select
*.mariadb.*.*.*.*.status.connection_errors_tcpwrap
*.mariadb.*.*.*.*.status.connections
*.mariadb.*.*.*.*.status.cpu_time
*.mariadb.*.*.*.*.status.created_tmp_disk_tables
*.mariadb.*.*.*.*.status.created_tmp_files
*.mariadb.*.*.*.*.status.created_tmp_tables
*.mariadb.*.*.*.*.status.delayed_errors
*.mariadb.*.*.*.*.status.delayed_insert_threads
*.mariadb.*.*.*.*.status.delayed_writes
*.mariadb.*.*.*.*.status.delete_scan
*.mariadb.*.*.*.*.status.empty_queries
*.mariadb.*.*.*.*.status.executed_events
*.mariadb.*.*.*.*.status.executed_triggers
*.mariadb.*.*.*.*.status.feature_application_time_periods
*.mariadb.*.*.*.*.status.feature_check_constraint
*.mariadb.*.*.*.*.status.feature_custom_aggregate_functions
*.mariadb.*.*.*.*.status.feature_delay_key_write
*.mariadb.*.*.*.*.status.feature_dynamic_columns
*.mariadb.*.*.*.*.status.feature_fulltext
*.mariadb.*.*.*.*.status.feature_gis
*.mariadb.*.*.*.*.status.feature_insert_returning
*.mariadb.*.*.*.*.status.feature_invisible_columns
*.mariadb.*.*.*.*.status.feature_json
*.mariadb.*.*.*.*.status.feature_locale
*.mariadb.*.*.*.*.status.feature_subquery
*.mariadb.*.*.*.*.status.feature_system_versioning
*.mariadb.*.*.*.*.status.feature_timezone
*.mariadb.*.*.*.*.status.feature_trigger
*.mariadb.*.*.*.*.status.feature_window_functions
*.mariadb.*.*.*.*.status.feature_xml
*.mariadb.*.*.*.*.status.handler_commit
*.mariadb.*.*.*.*.status.handler_delete
*.mariadb.*.*.*.*.status.handler_discover
*.mariadb.*.*.*.*.status.handler_external_lock
*.mariadb.*.*.*.*.status.handler_icp_attempts
*.mariadb.*.*.*.*.status.handler_icp_match
*.mariadb.*.*.*.*.status.handler_mrr_init
*.mariadb.*.*.*.*.status.handler_mrr_key_refills
*.mariadb.*.*.*.*.status.handler_mrr_rowid_refills
*.mariadb.*.*.*.*.status.handler_prepare
*.mariadb.*.*.*.*.status.handler_read_first
*.mariadb.*.*.*.*.status.handler_read_key
*.mariadb.*.*.*.*.status.handler_read_last
*.mariadb.*.*.*.*.status.handler_read_next
*.mariadb.*.*.*.*.status.handler_read_prev
*.mariadb.*.*.*.*.status.handler_read_retry
*.mariadb.*.*.*.*.status.handler_read_rnd
*.mariadb.*.*.*.*.status.handler_read_rnd_deleted
*.mariadb.*.*.*.*.status.handler_read_rnd_next
*.mariadb.*.*.*.*.status.handler_rollback
*.mariadb.*.*.*.*.status.handler_savepoint
*.mariadb.*.*.*.*.status.handler_savepoint_rollback
*.mariadb.*.*.*.*.status.handler_tmp_delete
*.mariadb.*.*.*.*.status.handler_tmp_update
*.mariadb.*.*.*.*.status.handler_tmp_write
*.mariadb.*.*.*.*.status.handler_update
*.mariadb.*.*.*.*.status.handler_write
*.mariadb.*.*.*.*.status.innodb_adaptive_hash_hash_searches
*.mariadb.*.*.*.*.status.innodb_adaptive_hash_non_hash_searches
*.mariadb.*.*.*.*.status.innodb_available_undo_logs
*.mariadb.*.*.*.*.status.innodb_background_log_sync
*.mariadb.*.*.*.*.status.innodb_buffer_pool_bytes_data
*.mariadb.*.*.*.*.status.innodb_buffer_pool_bytes_dirty
*.mariadb.*.*.*.*.status.innodb_buffer_pool_pages_data
*.mariadb.*.*.*.*.status.innodb_buffer_pool_pages_dirty
*.mariadb.*.*.*.*.status.innodb_buffer_pool_pages_flushed
*.mariadb.*.*.*.*.status.innodb_buffer_pool_pages_free
*.mariadb.*.*.*.*.status.innodb_buffer_pool_pages_lru_flushed
*.mariadb.*.*.*.*.status.innodb_buffer_pool_pages_lru_freed
*.mariadb.*.*.*.*.status.innodb_buffer_pool_pages_made_not_young
*.mariadb.*.*.*.*.status.innodb_buffer_pool_pages_made_young
*.mariadb.*.*.*.*.status.innodb_buffer_pool_pages_misc
*.mariadb.*.*.*.*.status.innodb_buffer_pool_pages_old
*.mariadb.*.*.*.*.status.innodb_buffer_pool_pages_split
*.mariadb.*.*.*.*.status.innodb_buffer_pool_pages_total
*.mariadb.*.*.*.*.status.innodb_buffer_pool_pages_utilization
*.mariadb.*.*.*.*.status.innodb_buffer_pool_read_ahead
*.mariadb.*.*.*.*.status.innodb_buffer_pool_read_ahead_evicted
*.mariadb.*.*.*.*.status.innodb_buffer_pool_read_ahead_rnd
*.mariadb.*.*.*.*.status.innodb_buffer_pool_read_requests
*.mariadb.*.*.*.*.status.innodb_buffer_pool_reads
*.mariadb.*.*.*.*.status.innodb_buffer_pool_wait_free
*.mariadb.*.*.*.*.status.innodb_buffer_pool_write_requests
*.mariadb.*.*.*.*.status.innodb_bulk_operations
*.mariadb.*.*.*.*.status.innodb_checkpoint_age
*.mariadb.*.*.*.*.status.innodb_checkpoint_max_age
*.mariadb.*.*.*.*.status.innodb_data_fsyncs
*.mariadb.*.*.*.*.status.innodb_data_pending_fsyncs
*.mariadb.*.*.*.*.status.innodb_data_pending_reads
*.mariadb.*.*.*.*.status.innodb_data_pending_writes
*.mariadb.*.*.*.*.status.innodb_data_read
*.mariadb.*.*.*.*.status.innodb_data_reads
*.mariadb.*.*.*.*.status.innodb_data_writes
*.mariadb.*.*.*.*.status.innodb_data_written
*.mariadb.*.*.*.*.status.innodb_dblwr_pages_written
*.mariadb.*.*.*.*.status.innodb_dblwr_writes
*.mariadb.*.*.*.*.status.innodb_deadlocks
*.mariadb.*.*.*.*.status.innodb_defragment_compression_failures
*.mariadb.*.*.*.*.status.innodb_defragment_count
*.mariadb.*.*.*.*.status.innodb_defragment_failures
*.mariadb.*.*.*.*.status.innodb_encryption_n_merge_blocks_decrypted
*.mariadb.*.*.*.*.status.innodb_encryption_n_merge_blocks_encrypted
*.mariadb.*.*.*.*.status.innodb_encryption_n_rowlog_blocks_decrypted
*.mariadb.*.*.*.*.status.innodb_encryption_n_rowlog_blocks_encrypted
*.mariadb.*.*.*.*.status.innodb_encryption_n_temp_blocks_decrypted
*.mariadb.*.*.*.*.status.innodb_encryption_n_temp_blocks_encrypted
*.mariadb.*.*.*.*.status.innodb_encryption_num_key_requests
*.mariadb.*.*.*.*.status.innodb_encryption_rotation_estimated_iops
*.mariadb.*.*.*.*.status.innodb_encryption_rotation_pages_flushed
*.mariadb.*.*.*.*.status.innodb_encryption_rotation_pages_modified
*.mariadb.*.*.*.*.status.innodb_encryption_rotation_pages_read_from_cache
*.mariadb.*.*.*.*.status.innodb_encryption_rotation_pages_read_from_disk
*.mariadb.*.*.*.*.status.innodb_history_list_length
*.mariadb.*.*.*.*.status.innodb_ibuf_discarded_delete_marks
*.mariadb.*.*.*.*.status.innodb_ibuf_discarded_deletes
*.mariadb.*.*.*.*.status.innodb_ibuf_discarded_inserts
*.mariadb.*.*.*.*.status.innodb_ibuf_free_list
*.mariadb.*.*.*.*.status.innodb_ibuf_merged_delete_marks
*.mariadb.*.*.*.*.status.innodb_ibuf_merged_deletes
*.mariadb.*.*.*.*.status.innodb_ibuf_merged_inserts
*.mariadb.*.*.*.*.status.innodb_ibuf_merges
*.mariadb.*.*.*.*.status.innodb_ibuf_segment_size
*.mariadb.*.*.*.*.status.innodb_ibuf_size
*.mariadb.*.*.*.*.status.innodb_instant_alter_column
*.mariadb.*.*.*.*.status.innodb_log_waits
*.mariadb.*.*.*.*.status.innodb_log_write_requests
*.mariadb.*.*.*.*.status.innodb_log_writes
*.mariadb.*.*.*.*.status.innodb_lsn_current
*.mariadb.*.*.*.*.status.innodb_lsn_flushed
*.mariadb.*.*.*.*.status.innodb_lsn_last_checkpoint
*.mariadb.*.*.*.*.status.innodb_master_thread_active_loops
*.mariadb.*.*.*.*.status.innodb_master_thread_idle_loops
*.mariadb.*.*.*.*.status.innodb_max_trx_id
*.mariadb.*.*.*.*.status.innodb_mem_adaptive_hash
*.mariadb.*.*.*.*.status.innodb_mem_dictionary
*.mariadb.*.*.*.*.status.innodb_num_open_files
*.mariadb.*.*.*.*.status.innodb_num_page_compressed_trim_op
*.mariadb.*.*.*.*.status.innodb_num_pages_decrypted
*.mariadb.*.*.*.*.status.innodb_num_pages_encrypted
*.mariadb.*.*.*.*.status.innodb_num_pages_page_compressed
*.mariadb.*.*.*.*.status.innodb_num_pages_page_compression_error
*.mariadb.*.*.*.*.status.innodb_num_pages_page_decompressed
*.mariadb.*.*.*.*.status.innodb_onlineddl_pct_progress
*.mariadb.*.*.*.*.status.innodb_onlineddl_rowlog_pct_used
*.mariadb.*.*.*.*.status.innodb_onlineddl_rowlog_rows
*.mariadb.*.*.*.*.status.innodb_os_log_fsyncs
*.mariadb.*.*.*.*.status.innodb_os_log_pending_fsyncs
*.mariadb.*.*.*.*.status.innodb_os_log_pending_writes
*.mariadb.*.*.*.*.status.innodb_os_log_written
*.mariadb.*.*.*.*.status.innodb_page_compression_saved
*.mariadb.*.*.*.*.status.innodb_page_size
*.mariadb.*.*.*.*.status.innodb_pages_created
*.mariadb.*.*.*.*.status.innodb_pages_read
*.mariadb.*.*.*.*.status.innodb_pages_written
*.mariadb.*.*.*.*.status.innodb_row_lock_current_waits
*.mariadb.*.*.*.*.status.innodb_row_lock_time
*.mariadb.*.*.*.*.status.innodb_row_lock_time_avg
*.mariadb.*.*.*.*.status.innodb_row_lock_time_max
*.mariadb.*.*.*.*.status.innodb_row_lock_waits
*.mariadb.*.*.*.*.status.innodb_rows_deleted
*.mariadb.*.*.*.*.status.innodb_rows_inserted
*.mariadb.*.*.*.*.status.innodb_rows_read
*.mariadb.*.*.*.*.status.innodb_rows_updated
*.mariadb.*.*.*.*.status.innodb_secondary_index_triggered_cluster_reads
*.mariadb.*.*.*.*.status.innodb_secondary_index_triggered_cluster_reads_avoided
*.mariadb.*.*.*.*.status.innodb_system_rows_deleted
*.mariadb.*.*.*.*.status.innodb_system_rows_inserted
*.mariadb.*.*.*.*.status.innodb_system_rows_read
*.mariadb.*.*.*.*.status.innodb_system_rows_updated
*.mariadb.*.*.*.*.status.innodb_truncated_status_writes
*.mariadb.*.*.*.*.status.innodb_undo_truncations
*.mariadb.*.*.*.*.status.key_blocks_not_flushed
*.mariadb.*.*.*.*.status.key_blocks_unused
*.mariadb.*.*.*.*.status.key_blocks_used
*.mariadb.*.*.*.*.status.key_blocks_warm
*.mariadb.*.*.*.*.status.key_read_requests
*.mariadb.*.*.*.*.status.key_reads
*.mariadb.*.*.*.*.status.key_write_requests
*.mariadb.*.*.*.*.status.key_writes
*.mariadb.*.*.*.*.status.last_query_cost
*.mariadb.*.*.*.*.status.master_gtid_wait_count
*.mariadb.*.*.*.*.status.master_gtid_wait_time
*.mariadb.*.*.*.*.status.master_gtid_wait_timeouts
*.mariadb.*.*.*.*.status.max_statement_time_exceeded
*.mariadb.*.*.*.*.status.max_used_connections
*.mariadb.*.*.*.*.status.memory_used
*.mariadb.*.*.*.*.status.memory_used_initial
*.mariadb.*.*.*.*.status.not_flushed_delayed_rows
*.mariadb.*.*.*.*.status.open_files
*.mariadb.*.*.*.*.status.open_streams
*.mariadb.*.*.*.*.status.open_table_definitions
*.mariadb.*.*.*.*.status.open_tables
*.mariadb.*.*.*.*.status.opened_files
*.mariadb.*.*.*.*.status.opened_plugin_libraries
*.mariadb.*.*.*.*.status.opened_table_definitions
*.mariadb.*.*.*.*.status.opened_tables
*.mariadb.*.*.*.*.status.opened_views
*.mariadb.*.*.*.*.status.performance_schema_accounts_lost
*.mariadb.*.*.*.*.status.performance_schema_cond_classes_lost
*.mariadb.*.*.*.*.status.performance_schema_cond_instances_lost
*.mariadb.*.*.*.*.status.performance_schema_digest_lost
*.mariadb.*.*.*.*.status.performance_schema_file_classes_lost
*.mariadb.*.*.*.*.status.performance_schema_file_handles_lost
*.mariadb.*.*.*.*.status.performance_schema_file_instances_lost
*.mariadb.*.*.*.*.status.performance_schema_hosts_lost
*.mariadb.*.*.*.*.status.performance_schema_index_stat_lost
*.mariadb.*.*.*.*.status.performance_schema_locker_lost
*.mariadb.*.*.*.*.status.performance_schema_memory_classes_lost
*.mariadb.*.*.*.*.status.performance_schema_metadata_lock_lost
*.mariadb.*.*.*.*.status.performance_schema_mutex_classes_lost
*.mariadb.*.*.*.*.status.performance_schema_mutex_instances_lost
*.mariadb.*.*.*.*.status.performance_schema_nested_statement_lost
*.mariadb.*.*.*.*.status.performance_schema_prepared_statements_lost
*.mariadb.*.*.*.*.status.performance_schema_program_lost
*.mariadb.*.*.*.*.status.performance_schema_rwlock_classes_lost
*.mariadb.*.*.*.*.status.performance_schema_rwlock_instances_lost
*.mariadb.*.*.*.*.status.performance_schema_session_connect_attrs_lost
*.mariadb.*.*.*.*.status.performance_schema_socket_classes_lost
*.mariadb.*.*.*.*.status.performance_schema_socket_instances_lost
*.mariadb.*.*.*.*.status.performance_schema_stage_classes_lost
*.mariadb.*.*.*.*.status.performance_schema_statement_classes_lost
*.mariadb.*.*.*.*.status.performance_schema_table_handles_lost
*.mariadb.*.*.*.*.status.performance_schema_table_instances_lost
*.mariadb.*.*.*.*.status.performance_schema_table_lock_stat_lost
*.mariadb.*.*.*.*.status.performance_schema_thread_classes_lost
*.mariadb.*.*.*.*.status.performance_schema_thread_instances_lost
*.mariadb.*.*.*.*.status.performance_schema_users_lost
*.mariadb.*.*.*.*.status.prepared_stmt_count
*.mariadb.*.*.*.*.status.qcache_free_blocks
*.mariadb.*.*.*.*.status.qcache_free_memory
*.mariadb.*.*.*.*.status.qcache_hits
*.mariadb.*.*.*.*.status.qcache_inserts
*.mariadb.*.*.*.*.status.qcache_lowmem_prunes
*.mariadb.*.*.*.*.status.qcache_not_cached
*.mariadb.*.*.*.*.status.qcache_queries_in_cache
*.mariadb.*.*.*.*.status.qcache_total_blocks
*.mariadb.*.*.*.*.status.queries
*.mariadb.*.*.*.*.status.questions
*.mariadb.*.*.*.*.status.reads
*.mariadb.*.*.*.*.status.resultset_metadata_skipped
*.mariadb.*.*.*.*.status.rows_read
*.mariadb.*.*.*.*.status.rows_sent
*.mariadb.*.*.*.*.status.rows_tmp_read
*.mariadb.*.*.*.*.status.rpl_semi_sync_master_clients
*.mariadb.*.*.*.*.status.rpl_semi_sync_master_get_ack
*.mariadb.*.*.*.*.status.rpl_semi_sync_master_net_avg_wait_time
*.mariadb.*.*.*.*.status.rpl_semi_sync_master_net_wait_time
*.mariadb.*.*.*.*.status.rpl_semi_sync_master_net_waits
*.mariadb.*.*.*.*.status.rpl_semi_sync_master_no_times
*.mariadb.*.*.*.*.status.rpl_semi_sync_master_no_tx
*.mariadb.*.*.*.*.status.rpl_semi_sync_master_request_ack
*.mariadb.*.*.*.*.status.rpl_semi_sync_master_timefunc_failures
*.mariadb.*.*.*.*.status.rpl_semi_sync_master_tx_avg_wait_time
*.mariadb.*.*.*.*.status.rpl_semi_sync_master_tx_wait_time
*.mariadb.*.*.*.*.status.rpl_semi_sync_master_tx_waits
*.mariadb.*.*.*.*.status.rpl_semi_sync_master_wait_pos_backtraverse
*.mariadb.*.*.*.*.status.rpl_semi_sync_master_wait_sessions
*.mariadb.*.*.*.*.status.rpl_semi_sync_master_yes_tx
*.mariadb.*.*.*.*.status.rpl_semi_sync_slave_send_ack
*.mariadb.*.*.*.*.status.rpl_transactions_multi_engine
*.mariadb.*.*.*.*.status.select_full_join
*.mariadb.*.*.*.*.status.select_full_range_join
*.mariadb.*.*.*.*.status.select_range
*.mariadb.*.*.*.*.status.select_range_check
*.mariadb.*.*.*.*.status.select_scan
*.mariadb.*.*.*.*.status.slave_connections
*.mariadb.*.*.*.*.status.slave_heartbeat_period
*.mariadb.*.*.*.*.status.slave_open_temp_tables
*.mariadb.*.*.*.*.status.slave_received_heartbeats
*.mariadb.*.*.*.*.status.slave_retried_transactions
*.mariadb.*.*.*.*.status.slave_skipped_errors
*.mariadb.*.*.*.*.status.slaves_connected
*.mariadb.*.*.*.*.status.slaves_running
*.mariadb.*.*.*.*.status.slow_launch_threads
*.mariadb.*.*.*.*.status.slow_queries
*.mariadb.*.*.*.*.status.sort_merge_passes
*.mariadb.*.*.*.*.status.sort_priority_queue_sorts
*.mariadb.*.*.*.*.status.sort_range
*.mariadb.*.*.*.*.status.sort_rows
*.mariadb.*.*.*.*.status.sort_scan
*.mariadb.*.*.*.*.status.ssl_accept_renegotiates
*.mariadb.*.*.*.*.status.ssl_accepts
*.mariadb.*.*.*.*.status.ssl_callback_cache_hits
*.mariadb.*.*.*.*.status.ssl_client_connects
*.mariadb.*.*.*.*.status.ssl_connect_renegotiates
*.mariadb.*.*.*.*.status.ssl_ctx_verify_depth
*.mariadb.*.*.*.*.status.ssl_ctx_verify_mode
*.mariadb.*.*.*.*.status.ssl_default_timeout
*.mariadb.*.*.*.*.status.ssl_finished_accepts
*.mariadb.*.*.*.*.status.ssl_finished_connects
*.mariadb.*.*.*.*.status.ssl_session_cache_hits
*.mariadb.*.*.*.*.status.ssl_session_cache_misses
*.mariadb.*.*.*.*.status.ssl_session_cache_overflows
*.mariadb.*.*.*.*.status.ssl_session_cache_size
*.mariadb.*.*.*.*.status.ssl_session_cache_timeouts
*.mariadb.*.*.*.*.status.ssl_sessions_reused
*.mariadb.*.*.*.*.status.ssl_used_session_cache_entries
*.mariadb.*.*.*.*.status.ssl_verify_depth
*.mariadb.*.*.*.*.status.ssl_verify_mode
*.mariadb.*.*.*.*.status.stack_usage
*.mariadb.*.*.*.*.status.subquery_cache_hit
*.mariadb.*.*.*.*.status.subquery_cache_miss
*.mariadb.*.*.*.*.status.syncs
*.mariadb.*.*.*.*.status.table_locks_immediate
*.mariadb.*.*.*.*.status.table_locks_waited
*.mariadb.*.*.*.*.status.table_open_cache_active_instances
*.mariadb.*.*.*.*.status.table_open_cache_hits
*.mariadb.*.*.*.*.status.table_open_cache_misses
*.mariadb.*.*.*.*.status.table_open_cache_overflows
*.mariadb.*.*.*.*.status.tc_log_max_pages_used
*.mariadb.*.*.*.*.status.tc_log_page_size
*.mariadb.*.*.*.*.status.tc_log_page_waits
*.mariadb.*.*.*.*.status.threadpool_idle_threads
*.mariadb.*.*.*.*.status.threadpool_threads
*.mariadb.*.*.*.*.status.threads_cached
*.mariadb.*.*.*.*.status.threads_connected
*.mariadb.*.*.*.*.status.threads_created
*.mariadb.*.*.*.*.status.threads_running
*.mariadb.*.*.*.*.status.transactions_gtid_foreign_engine
*.mariadb.*.*.*.*.status.transactions_multi_engine
*.mariadb.*.*.*.*.status.update_scan
*.mariadb.*.*.*.*.status.uptime
*.mariadb.*.*.*.*.status.uptime_since_flush_status
*.mariadb.*.*.*.*.status.writes
*.mariadb.*.*.*.*.status.wsrep_applier_thread_count
*.mariadb.*.*.*.*.status.wsrep_apply_oooe
*.mariadb.*.*.*.*.status.wsrep_apply_oool
*.mariadb.*.*.*.*.status.wsrep_apply_waits
*.mariadb.*.*.*.*.status.wsrep_apply_window
*.mariadb.*.*.*.*.status.wsrep_causal_reads
*.mariadb.*.*.*.*.status.wsrep_cert_deps_distance
*.mariadb.*.*.*.*.status.wsrep_cert_index_size
*.mariadb.*.*.*.*.status.wsrep_cert_interval
*.mariadb.*.*.*.*.status.wsrep_cluster_conf_id
*.mariadb.*.*.*.*.status.wsrep_cluster_size
*.mariadb.*.*.*.*.status.wsrep_cluster_weight
*.mariadb.*.*.*.*.status.wsrep_commit_oooe
*.mariadb.*.*.*.*.status.wsrep_commit_oool
*.mariadb.*.*.*.*.status.wsrep_commit_window
*.mariadb.*.*.*.*.status.wsrep_desync_count
*.mariadb.*.*.*.*.status.wsrep_flow_control_paused
*.mariadb.*.*.*.*.status.wsrep_flow_control_paused_ns
*.mariadb.*.*.*.*.status.wsrep_flow_control_recv
*.mariadb.*.*.*.*.status.wsrep_flow_control_sent
*.mariadb.*.*.*.*.status.wsrep_gmcast_segment
*.mariadb.*.*.*.*.status.wsrep_last_committed
*.mariadb.*.*.*.*.status.wsrep_local_bf_aborts
*.mariadb.*.*.*.*.status.wsrep_local_cached_downto
*.mariadb.*.*.*.*.status.wsrep_local_cert_failures
*.mariadb.*.*.*.*.status.wsrep_local_commits
*.mariadb.*.*.*.*.status.wsrep_local_index
*.mariadb.*.*.*.*.status.wsrep_local_recv_queue
*.mariadb.*.*.*.*.status.wsrep_local_recv_queue_avg
*.mariadb.*.*.*.*.status.wsrep_local_recv_queue_max
*.mariadb.*.*.*.*.status.wsrep_local_recv_queue_min
*.mariadb.*.*.*.*.status.wsrep_local_replays
*.mariadb.*.*.*.*.status.wsrep_local_send_queue
*.mariadb.*.*.*.*.status.wsrep_local_send_queue_avg
*.mariadb.*.*.*.*.status.wsrep_local_send_queue_max
*.mariadb.*.*.*.*.status.wsrep_local_send_queue_min
*.mariadb.*.*.*.*.status.wsrep_local_state
*.mariadb.*.*.*.*.status.wsrep_open_connections
*.mariadb.*.*.*.*.status.wsrep_open_transactions
*.mariadb.*.*.*.*.status.wsrep_protocol_application
*.mariadb.*.*.*.*.status.wsrep_protocol_gcs
*.mariadb.*.*.*.*.status.wsrep_protocol_replicator
*.mariadb.*.*.*.*.status.wsrep_protocol_version
*.mariadb.*.*.*.*.status.wsrep_received
*.mariadb.*.*.*.*.status.wsrep_received_bytes
*.mariadb.*.*.*.*.status.wsrep_repl_data_bytes
*.mariadb.*.*.*.*.status.wsrep_repl_keys
*.mariadb.*.*.*.*.status.wsrep_repl_keys_bytes
*.mariadb.*.*.*.*.status.wsrep_repl_other_bytes
*.mariadb.*.*.*.*.status.wsrep_replicated
*.mariadb.*.*.*.*.status.wsrep_replicated_bytes
*.mariadb.*.*.*.*.status.wsrep_rollbacker_thread_count
*.mariadb.*.*.*.*.status.wsrep_thread_count

Sys Schema

The sys schema objects can be used for typical tuning and diagnosis use cases.

Metric Id	Type	Description
sessions.count	Integer	Amount of sessions based on the query SELECT COUNT(*) AS sessions FROM x$session
io/file.event_class	Integer	The event class. documentation
io/file.total	Integer	The total number of occurrences of events in the class. documentation
io/file.total_latency	Integer	The total wait time of timed occurrences of events in the class. documentation
io/file.min_latency	Integer	The minimum single wait time of timed occurrences of events in the class. documentation
io/file.avg_latency	Integer	The average wait time per timed occurrence of events in the class. documentation
io/file.max_latency	Integer	The maximum single wait time of timed occurrences of events in the class. documentation
io/table.event_class	Integer	The event class. documentation
io/table.total	Integer	The event class. documentation
io/table.total_latency	Integer	The total wait time of timed occurrences of events in the class. documentation
io/table.min_latency	Integer	The minimum single wait time of timed occurrences of events in the class. documentation
io/table.avg_latency	Integer	The average wait time per timed occurrence of events in the class. documentation
io/table.max_latency	Integer	The maximum single wait time of timed occurrences of events in the class. documentation
lock/table.event_class	Integer	The event class. documentation
lock/table.total	Integer	The total number of occurrences of events in the class. documentation
lock/table.total_latency	Integer	The total wait time of timed occurrences of events in the class. documentation
lock/table.min_latency	Integer	The minimum single wait time of timed occurrences of events in the class. documentation
lock/table.avg_latency	Integer	The average wait time per timed occurrence of events in the class. documentation
lock/table.max_latency	Integer	The maximum single wait time of timed occurrences of events in the class. documentation

Metrics

*.mariadb.*.*.*.*.sys.sessions.count
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/io/file.event_class
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/io/file.total
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/io/file.total_latency
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/io/file.min_latency
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/io/file.avg_latency
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/io/file.max_latency
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/io/table.event_class
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/io/table.total
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/io/table.total_latency
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/io/table.min_latency
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/io/table.avg_latency
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/io/table.max_latency
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/lock/table.event_class
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/lock/table.total
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/lock/table.total_latency
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/lock/table.min_latency
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/lock/table.avg_latency
*.mariadb.*.*.*.*.sys.wait_classes_global_by_latency.event_class.wait/lock/table.max_latency