Properties on MySQL Instances

Properties are grouped below by topic.

Replication status

Name	Description	Typical values
database_role	Database role
global_read_only	Read only flag
global_super_read_only	Super read only flag
inndb_node_count	Number of InnoDB Cluster nodes
is_cluster_inndb	Whether the instance is an InnoDB Cluster
is_mysql_branch	Whether the instance is a MySQL branch
is_replica	Whether the instance is a replica
is_standby	Whether the instance is a standby
master_slave_file	Master status
master_slave_file/Binlog_Do_DB	Databases to replicate
master_slave_file/Binlog_Ignore_DB	Databases to ignore for replication
master_slave_file/Executed_Gtid_Set	Executed GTID set
master_slave_file/Position	Binary log position
Replica_IO_State	Replica status
Replica_IO_State/Auto_Position	Whether auto positioning is enabled
Replica_IO_State/Channel_name	Channel name
Replica_IO_State/Connect_Retry	Connection retry interval
Replica_IO_State/Exec_Source_Log_Pos	Executed source log position
Replica_IO_State/Executed_Gtid_Set	Executed GTID set
Replica_IO_State/Get_source_public_key	Whether to get the source public key
Replica_IO_State/Last_Errno	Last error number
Replica_IO_State/Last_Error	Last error
Replica_IO_State/Last_IO_Errno	Last IO error number
Replica_IO_State/Last_IO_Error	Last IO error
Replica_IO_State/Last_IO_Error_Timestamp	Last IO error timestamp
Replica_IO_State/Last_SQL_Errno	Last SQL error number
Replica_IO_State/Last_SQL_Error	Last SQL error
Replica_IO_State/Last_SQL_Error_Timestamp	Last SQL error timestamp
Replica_IO_State/Network_Namespace	Network namespace
Replica_IO_State/Read_Source_Log_Pos	Read source log position
Replica_IO_State/Relay_Log_File	Relay log file
Replica_IO_State/Relay_Log_Pos	Relay log position
Replica_IO_State/Relay_Log_Space	Relay log space
Replica_IO_State/Relay_Source_Log_File	Relay source log file
Replica_IO_State/Replica_IO_Running	Replica IO running state
Replica_IO_State/Replica_SQL_Running	Replica SQL running state
Replica_IO_State/Replica_SQL_Running_State	Replica SQL running state
Replica_IO_State/Replicate_Do_DB	Replicate do databases
Replica_IO_State/Replicate_Do_Table	Replicate do tables
Replica_IO_State/Replicate_Ignore_DB	Replicate ignore databases
Replica_IO_State/Replicate_Ignore_Server_Ids	Replicate ignore server IDs
Replica_IO_State/Replicate_Ignore_Table	Replicate ignore tables
Replica_IO_State/Replicate_Rewrite_DB	Replicate rewrite database mapping
Replica_IO_State/Replicate_Wild_Do_Table	Replicate wildcard do tables
Replica_IO_State/Replicate_Wild_Ignore_Table	Replicate wildcard ignore tables
Replica_IO_State/Retrieved_Gtid_Set	Retrieved GTID set
Replica_IO_State/Seconds_Behind_Source	Seconds behind source
Replica_IO_State/Skip_Counter	Skip counter
Replica_IO_State/Source_Bind	Source bind address
Replica_IO_State/Source_Host	Source host
Replica_IO_State/Source_Info_File	Source info file
Replica_IO_State/Source_Log_File	Source log file
Replica_IO_State/Source_Port	Source port
Replica_IO_State/Source_public_key_path	Source public key path
Replica_IO_State/Source_Retry_Count	Source retry count
Replica_IO_State/Source_Server_Id	Source server ID
Replica_IO_State/Source_SSL_Allowed	Whether SSL is allowed
Replica_IO_State/Source_SSL_CA_File	Source SSL CA file
Replica_IO_State/Source_SSL_CA_Path	Source SSL CA path
Replica_IO_State/Source_SSL_Cert	Source SSL certificate
Replica_IO_State/Source_SSL_Cipher	Source SSL cipher
Replica_IO_State/Source_SSL_Crl	Source SSL CRL
Replica_IO_State/Source_SSL_Crlpath	Source SSL CRL path
Replica_IO_State/Source_SSL_Key	Source SSL key
Replica_IO_State/Source_SSL_Verify_Server_Cert	Whether to verify the source server certificate
Replica_IO_State/Source_TLS_Version	Source TLS version
Replica_IO_State/Source_User	Source user
Replica_IO_State/Source_UUID	Source UUID
Replica_IO_State/SQL_Delay	SQL delay
Replica_IO_State/SQL_Remaining_Delay	Remaining SQL delay
Replica_IO_State/Until_Condition	Until condition
Replica_IO_State/Until_Log_File	Until log file
Replica_IO_State/Until_Log_Pos	Until log position
Server_Id	Server list
Server_Id/Host	Host
Server_Id/Port	Port
Server_Id/Replica_UUID	Replica UUID
Server_Id/Source_Id	Source ID

Activity and statistics

Name	Description	Typical values
activity	Overall activity score
activity_logical_reads	Logical reads per second
activity_logical_reads_activity	Activity score derived from logical reads
activity_logical_reads_counter	Current logical reads counter
activity_logical_reads_lasttime	Last logical read sample time in milliseconds since 1970
instance_running_sec	Instance uptime in seconds
instance_started_sec_1970	Instance start time in seconds since 1970
issues_date	Issues history by date
issues_date/issues_count	Issue count
issues_per_day_histr_sec	Issues per day history
issues_per_day_histr_sec/histr_date	History date
issues_per_day_histr_sec/job_count	Job count
issues_per_day_histr_sec/job_warnings	Job warnings
issues_per_day_histr_sec/sc_warnings	Security and compliance warnings
sec_after_1970	Seconds since 1970
show_grants_count	Number of grant rows
used_connections	Maximum used connections
aborted_connects	Aborted connection count
aborted_connects_last	Previous aborted connection count
aborted_connects_lasttime	Last aborted connection sample time in milliseconds since 1970
utc_diff_h	UTC difference in hours
utc_diff_s	UTC difference in seconds
sql_repository_size_mb	SQL repository size in MB
sql_statistics_avg_exec_time_ms	Average SQL execution time in ms
sql_statistics_exec_time_ms	SQL execution time in ms
sql_statistics_max_exec_time_ms	Maximum SQL execution time in ms

Instance and engine metadata

Name	Description	Typical values
one_int_engine	Constant value one for the engine
one	Constant value one
platform_info	Platform and version info	MySQL 8.0.37
version	MySQL version
version_string	Version string
maj_version	Major MySQL version
is_mysql_branch	Whether the instance is a MySQL branch
iscluster	Whether the instance is clustered
database	Database name
db_count	The number of databases on the instance	23
dbhost	Database host name
hosttype	Host type
engine_edition	MySQL
global_hostname	Host name
started	A text representation of the start time for the instance	21.10.2020 11:39:16, 11.10.2023 11:47:08
users	User names
mysql_test
prop_user	Property user

Capabilities and engine checks

Name	Description	Typical values
eng_inst_priv
has_mysql_sys_schema	Whether the sys schema is available
has_processlist	Whether the processlist table is available
global_status_information_schema	Whether the information_schema.global_status table is available
global_status_performance_schema	Whether the performance_schema.global_status table is available
global_variables_information_schema	Whether the information_schema.global_variables table is available
global_variables_performance_schema	Whether the performance_schema.global_variables table is available
sid
dummy	Constant value ten
max_connections	Maximum number of connections
memory_usage_old	Legacy memory usage calculation

Grants and privileges

Name	Description	Typical values
grant_list_all	All grants
grant_replication_client	Replication Client privilege
grant_replication_slave	Replication Slave privilege
grant_super	Super privilege
show_grants	SHOW GRANTS output

Issues and service checks

Name	Description	Typical values
sc_alert_job_count	Alert job count
sc_disable_job_count	Disabled job count
sc_issues_count_current	Current issues count
sc_job_count	Job count
sc_task_id	Task ID
sc_task_id/sc_details	Task details
sc_task_id/sc_last_run	Last task run
sc_task_id/sc_name	Task name
sc_task_id/sc_status	Task status
sc_task_id/sc_status_job	Task status job