MariaDB

Introduction

MariaDB monitoring involves collecting and analyzing data related to the performance of a MariaDB database. By monitoring this data, potential performance issues can be identified, and corrective actions can be taken to enhance the database's efficiency and reliability.

Getting Started

Compatibility

The MariaDB O11ySource is designed to work with all versions greater than or equal to 11, and it has been tested with MariaDB 11.3.

Data Collection Method

The MariaDB O11ySource is configured to collect various kinds of metrics related to MariaDB Performance & MariaDB Engine Performance, Additionally, if MariaDB is deployed in non-standalone mode, it also collects metrics for Master-Slave. Error logs and slow log details are also captured.

vuSmartMaps uses an internal agent to collect MariaDB Performance Metrics, MariaDB Engine Performance Metrics, MariaDB Master-Slave Metrics, Logbeat agent is used to collect MariaDB Slow Logs, MariaDB Error Logs

Prerequisites

Dependent Configuration

To configure this O11ySource, create a 'credential' of type 'user' under the 'Definition' tab.

Inputs for Configuring Data Source

• Instance Name: Please enter the name of the MariaDB instance. This should be a unique identifier for the specific MariaDB deployment you want to monitor.
• DB Details: Please provide the details of DB
• IP Address: IP address needs to be a valid IP Address.
• Port: Enter a valid port
• Credential: This field is required
• DB Instance Role: DB Instance Role to indetify whether it is master or slave
• DB Name: Name of the database to be polled for metrics
• Metrics Collection Queries: These queries are utilized for MariaDB server's metrics.
• Query: Choose the Queries
• Polling Interval [seconds]: How frequently data is gathered. interval should be between 60 - 86400 seconds

Firewall Requirement

To collect data from this O11ySource, ensure the following ports are opened:

Source IP	Destination IP	Destination Port	Protocol	Direction
vuSmartMaps IP	IP address of the MariaDB server	3306*	TCP	Outbound
IP address of the MariaDB server	vuSmartMaps Kafka Broker IP	9092*	TCP	Inbound

*Before providing the firewall requirements, please update the port based on the customer environment.

Configuring the Target

Configure Metrics Collection from MariaDB Server

• On each MariaDB server, create a database user for the vuSmartMaps Agent.
• *For MariaDB versions below 10.4, create the vunet user with the following command:

CREATE USER 'vunet'@'%' IDENTIFIED BY '<UNIQUEPASSWORD>';

• *For MariaDB version 10.4 and above, create the vunet user with the native password hashing method:

CREATE USER 'vunet'@'%' IDENTIFIED WITH mysql_native_password '<UNIQUEPASSWORD>';

• The vuSmartMaps agent required the below permissions to collect the metrics from MariaDB. Grant the vunet user only the following limited privileges:
• *Grant replication client with the following command:

GRANT REPLICATION CLIENT ON *.* TO 'vunet'@'%';

• *Grant replication client with the following command:

GRANT PROCESS ON *.* TO 'vunet'@'%';

• *Grant replication client with the following command:

GRANT SELECT ON performance_schema.* TO 'vunet'@'%';


GRANT SELECT ON sys.schema_unused_indexes TO 'vunet'@'%';


GRANT SELECT ON sys.x$statements_with_full_table_scans TO 'vunet'@'%';

• Performance Metrics must be enabled for MariaDB:

[mysqld]


performance_schema = ON

Configure Logs Collection from MariaDB Server

By default, MariaDB logs everything in /var/log/syslog. To make the logs more accessible, follow these steps:

• Edit /etc/mysql/conf.d/mysqld_safe_syslog.cnf and remove or comment the lines.
• Edit /etc/mysql/my.cnf and add the following lines to enable general, error, and slow query logs:

[mysqld_safe]


log_error = /var/log/mysql/mariadb_error.log


[mysqld]


general_log = on


general_log_file = /var/log/mysql/mariadb.log


log_error = /var/log/mysql/mariadb_error.log


slow_query_log = on


slow_query_log_file = /var/log/mysql/mariadb_slow.log


long_query_time = 2

• Save the file and restart MariaDB using the following command:

service mariadb restart

Configuration Steps

• Enable the O11ySource.
• Select the Sources tab and press the + button to add Mariadb instance details that has to be monitored.
• Set up metrics and log collection configurations.The O11ysource already provides predefined metric collection queries. You have the flexibility to adjust query intervals, modify existing queries, and introduce new queries as needed. Afterwards, select Save and Continue to proceed with downloading the Logbeat agent.
• The following packages will be available for download based on the OS <Logbeat full install package> - Downloads the full Logbeat agent package with required configurations for a fresh installation <Logbeat config update package> - Downloads the agent configuration package to update an existing Logbeat installation
• Download the agent installation or update package, then click Finish to close the data source window.

Metrics Collected

Name	Description	Data Type
timestamp	The timestamp when the metrics were recorded	DateTime
tenant_id	The tenant ID	LowCardinality(String)
bu_id	The business unit ID	LowCardinality(String)
host	The host name where the metrics are collected	LowCardinality(String)
type	The type of the entity being monitored	LowCardinality(String)
ClusterID	Name of the culster for which the metrics are collected	LowCardinality(String)
DBName	Name of the database for which the metrics are collected	LowCardinality(String)
uniqueId	Unique identifier for the record	LowCardinality(String)
Max_connections	The maximum number of simultaneous client connections	UInt64
Key_buffer_size	The size of the key buffer used for MyISAM indexes	UInt64
Max_prepared_stmt_count	Maximum number of prepared statements allowed	UInt64
Table_open_cache	The number of open tables cache	UInt64
Thread_cache_size	The size of the thread cache	UInt64
Aborted_clients	The number of connections aborted by the client	UInt64
Aborted_connects	The number of failed connection attempts	UInt64
Binlog_cache_disk_use	The number of transactions stored in the binlog cache but overflowed to disk	UInt64
Binlog_cache_use	The number of transactions using the binlog cache	UInt64
Bytes_received	The number of bytes received from all clients	UInt64
Bytes_sent	The number of bytes sent to all clients	UInt64
Threads_cached	Number of threads in the cache	UInt64
Threads_connected	Number of currently open connections	UInt64
Threads_created	Number of threads created to handle connections	UInt64
Threads_running	Number of threads actively executing queries	UInt64
Connections	Total number of connection attempts	UInt64
Created_tmp_disk_tables	Number of temporary tables created on disk	UInt64
Created_tmp_files	Number of temporary files created	UInt64
Created_tmp_tables	Number of in-memory temporary tables created	UInt64
Max_used_connections	The highest number of simultaneous connections	UInt64
Open_files	Number of files open by the server	UInt64
Open_streams	Number of open streams (used for logging)	UInt64
Opened_tables	Number of tables that have been opened	UInt64
Open_tables	Number of tables currently open	UInt64
Table_locks_waited	Number of times a table lock was not available immediately and had to be waited for	UInt64
Uptime	The amount of time (in seconds) the server has been running	UInt64
Queries	The total number of queries the server has handled	UInt64
Questions	The total number of questions asked of the server	UInt64
Connection_errors_max_connections	Number of connection attempts refused due to reaching the max connection limit	UInt64
Connection_errors_internal	Number of connection errors caused by internal problems	UInt64
Max_used_connections_timestamp	Timestamp when Max_used_connections was reached	String
Key_reads	The number of physical reads of a key block from the disk	UInt64
Key_read_requests	The number of requests to read a key block	UInt64
Prepared_stmt_count	Number of currently prepared SQL statements	UInt64
Slow_queries	Number of queries that have taken longer than the long_query_time threshold	UInt64
Key_write_requests	The number of requests to write a key block	UInt64
Key_writes	The number of physical writes to key blocks on disk	UInt64
Handler_commit	Number of internal transaction commits performed	UInt64
Handler_delete	Number of rows deleted	UInt64
Handler_prepare	Number of transaction prepares in two-phase commit	UInt64
Handler_read_first	Number of times the first entry was read from an index	UInt64
Handler_read_key	Number of requests to read a row based on a key	UInt64
Handler_read_next	Number of requests to read the next row in key order	UInt64
Handler_read_prev	Number of requests to read the previous row in key order	UInt64
Handler_read_rnd	Number of requests to read a row based on a fixed position	UInt64
Handler_read_rnd_next	Number of requests to read the next row in data file order	UInt64
Handler_rollback	Number of rollback operations performed	UInt64
Handler_update	Number of rows updated	UInt64
Handler_write	Number of rows inserted	UInt64
SELECT_full_join	Number of joins without indexes (full table scan joins)	UInt64
SELECT_full_range_join	Number of joins that used a range search	UInt64
SELECT_range	Number of joins that used range scans on indexed fields	UInt64
SELECT_range_check	Number of joins where key usage was checked after each row	UInt64
SELECT_scan	Number of full table scans performed	UInt64
Sort_merge_passes	Number of merge passes performed during sort operations	UInt64
Sort_range	Number of sorts performed within a range	UInt64
Sort_rows	Number of rows sorted	UInt64
Sort_scan	Number of full table sorts	UInt64
Table_locks_immediate	Number of times a table lock was acquired immediately without waiting	UInt64
Table_open_cache_hits	Number of hits in the table cache	UInt64
Table_open_cache_misses	Number of misses in the table cache	UInt64
Aborted_clients_diff	Change in Aborted_clients since the last measurement	UInt64
Aborted_connects_diff	Change in Aborted_connects since the last measurement	UInt64
Binlog_cache_use_diff	Change in Binlog_cache_use since the last measurement	UInt64
Bytes_received_diff	Change in Bytes_received since the last measurement	UInt64
Bytes_sent_diff	Change in Bytes_sent since the last measurement	UInt64
Connections_diff	Change in Connections since the last measurement	UInt64
Created_tmp_disk_tables_diff	Change in Created_tmp_disk_tables since the last measurement	UInt64
Created_tmp_files_diff	Change in Created_tmp_files since the last measurement	UInt64
Created_tmp_tables_diff	Change in Created_tmp_tables since the last measurement	UInt64
Queries_diff	Change in Queries since the last measurement	UInt64
Table_locks_waited_diff	Change in Table_locks_waited since the last measurement	UInt64
Questions_diff	Change in Questions since the last measurement	UInt64
Connection_errors_max_connections_diff	Change in Connection_errors_max_connections since the last measurement	UInt64
Connection_errors_internal_diff	Change in Connection_errors_internal since the last measurement	UInt64
Slow_queries_diff	Change in Slow_queries since the last measurement	UInt64
Handler_commit_diff	Change in Handler_commit since the last measurement	UInt64
Handler_delete_diff	Change in Handler_delete since the last measurement	UInt64
Handler_prepare_diff	Change in Handler_prepare since the last measurement	UInt64
Handler_read_first_diff	Change in Handler_read_first since the last measurement	UInt64
Handler_read_key_diff	Change in Handler_read_key since the last measurement	UInt64
Handler_read_next_diff	Change in Handler_read_next since the last measurement	UInt64
Handler_read_prev_diff	Change in Handler_read_prev since the last measurement	UInt64
Handler_read_rnd_diff	Change in Handler_read_rnd since the last measurement	UInt64
Handler_read_rnd_next_diff	Change in Handler_read_rnd_next since the last measurement	UInt64
Handler_rollback_diff	Change in Handler_rollback since the last measurement	UInt64
Handler_update_diff	Change in Handler_update since the last measurement	UInt64
Handler_write_diff	Change in Handler_write since the last measurement	UInt64
SELECT_full_join_diff	Change in SELECT_full_join since the last measurement	UInt64
SELECT_full_range_join_diff	Change in SELECT_full_range_join since the last measurement	UInt64
SELECT_range_diff	Change in SELECT_range since the last measurement	UInt64
SELECT_range_check_diff	Change in SELECT_range_check since the last measurement	UInt64
SELECT_scan_diff	Change in SELECT_scan since the last measurement	UInt64
Sort_merge_passes_diff	Change in Sort_merge_passes since the last measurement	UInt64
Sort_range_diff	Change in Sort_range since the last measurement	UInt64
Sort_rows_diff	Change in Sort_rows since the last measurement	UInt64
Sort_scan_diff	Change in Sort_scan since the last measurement	UInt64
Table_locks_immediate_diff	Change in Table_locks_immediate since the last measurement	UInt64
Table_open_cache_hits_diff	Change in Table_open_cache_hits since the last measurement	UInt64
Table_open_cache_misses_diff	Change in Table_open_cache_misses since the last measurement	UInt64
timestamp	The timestamp when the metrics were recorded	DateTime
tenant_id	The tenant ID	LowCardinality(String)
bu_id	The business unit ID	LowCardinality(String)
host	The host name where the metrics were collected	LowCardinality(String)
type	The type of the entity being monitored	LowCardinality(String)
ClusterID	Name of the culster for which the metrics are collected	LowCardinality(String)
DBName	Name of the database for which the metrics are collected	LowCardinality(String)
uniqueId	Unique identifier for the record	LowCardinality(String)
Innodb_background_log_sync	The number of background log sync operations performed by InnoDB	UInt64
Innodb_buffer_pool_bytes_data	Total bytes of data in the InnoDB buffer pool	UInt64
Innodb_buffer_pool_bytes_dirty	Total bytes of dirty pages in the InnoDB buffer pool	UInt64
Innodb_buffer_pool_pages_data	Number of pages containing data in the buffer pool	UInt64
Innodb_buffer_pool_pages_dirty	Number of dirty pages in the buffer pool	UInt64
Innodb_buffer_pool_pages_flushed	Number of buffer pool pages that have been flushed	UInt64
Innodb_buffer_pool_pages_free	Number of free pages in the InnoDB buffer pool	UInt64
Innodb_buffer_pool_pages_total	Total number of pages in the InnoDB buffer pool	UInt64
Innodb_buffer_pool_read_ahead	Number of pages read ahead by the buffer pool	UInt64
Innodb_buffer_pool_read_ahead_evicted	Number of pages read ahead but subsequently evicted	UInt64
Innodb_buffer_pool_read_ahead_rnd	Number of pages read ahead randomly	UInt64
Innodb_buffer_pool_read_requests	Total number of logical read requests	UInt64
Innodb_buffer_pool_reads	Total number of physical reads performed	UInt64
Innodb_buffer_pool_wait_free	Number of times waiting for free buffer pool pages	UInt64
Innodb_buffer_pool_write_requests	Total number of write requests to the buffer pool	UInt64
Innodb_data_fsyncs	Number of fsync() operations on InnoDB data files	UInt64
Innodb_data_pending_fsyncs	Number of fsync() operations currently pending	UInt64
Innodb_data_pending_reads	Number of read operations currently pending	UInt64
Innodb_data_pending_writes	Number of write operations currently pending	UInt64
Innodb_data_read	Amount of data read in bytes	UInt64
Innodb_data_reads	Number of read operations performed	UInt64
Innodb_data_writes	Number of write operations performed	UInt64
Innodb_data_written	Amount of data written in bytes	UInt64
Innodb_dblwr_pages_written	Number of doublewrite pages written	UInt64
Innodb_dblwr_writes	Number of doublewrite operations	UInt64
Innodb_log_waits	Number of times log buffer waits occurred	UInt64
Innodb_log_write_requests	Number of log write requests	UInt64
Innodb_log_writes	Number of physical writes to the log file	UInt64
Innodb_os_log_written	Amount of data written to the log file in bytes	UInt64
Innodb_page_size	InnoDB page size	UInt64
Innodb_pages_created	Number of pages created by InnoDB	UInt64
Innodb_pages_read	Number of pages read by InnoDB	UInt64
Innodb_pages_written	Number of pages written by InnoDB	UInt64
Innodb_row_lock_current_waits	Number of row lock waits currently in progress	UInt64
Innodb_row_lock_time	Total time spent in row lock waits in milliseconds	UInt64
Innodb_row_lock_waits	Number of times row locks were waited for	UInt64
Innodb_buffer_pool_size	Size of the buffer pool in pages	UInt64
Innodb_log_waits_diff	Change in Innodb_log_waits since the last measurement	UInt64
Innodb_log_waits_rate	Rate of Innodb_log_waits over time	Float64
Innodb_log_write_requests_diff	Change in Innodb_log_write_requests since the last measurement	UInt64
Innodb_log_write_requests_rate	Rate of Innodb_log_write_requests over time	Float64
Innodb_pages_read_diff	Change in Innodb_pages_read since the last measurement	UInt64
Innodb_pages_read_rate	Rate of Innodb_pages_read over time	Float64
Innodb_data_written_diff	Change in Innodb_data_written since the last measurement	UInt64
Innodb_data_written_rate	Rate of Innodb_data_written over time	Float64
Innodb_buffer_pool_wait_free_diff	Change in Innodb_buffer_pool_wait_free since the last measurement	UInt64
Innodb_buffer_pool_wait_free_rate	Rate of Innodb_buffer_pool_wait_free over time	Float64
Innodb_pages_created_diff	Change in Innodb_pages_created since the last measurement	UInt64
Innodb_pages_created_rate	Rate of Innodb_pages_created over time	Float64
Innodb_pages_written_diff	Change in Innodb_pages_written since the last measurement	UInt64
Innodb_pages_written_rate	Rate of Innodb_pages_written over time	Float64
Innodb_buffer_pool_write_requests_diff	Change in Innodb_buffer_pool_write_requests since the last measurement	UInt64
Innodb_buffer_pool_write_requests_rate	Rate of Innodb_buffer_pool_write_requests over time	Float64
Innodb_data_read_diff	Change in Innodb_data_read since the last measurement	UInt64
Innodb_data_read_rate	Rate of Innodb_data_read over time	Float64
Innodb_buffer_pool_pages_flushed_diff	Change in Innodb_buffer_pool_pages_flushed since the last measurement	UInt64
Innodb_buffer_pool_pages_flushed_rate	Rate of Innodb_buffer_pool_pages_flushed over time	Float64
Innodb_buffer_pool_read_requests_diff	Change in Innodb_buffer_pool_read_requests since the last measurement	UInt64
Innodb_buffer_pool_read_requests_rate	Rate of Innodb_buffer_pool_read_requests over time	Float64
Innodb_data_fsyncs_diff	Change in Innodb_data_fsyncs since the last measurement	UInt64
Innodb_data_fsyncs_rate	Rate of Innodb_data_fsyncs over time	Float64
Innodb_page_size_diff	Change in Innodb_page_size since the last measurement	UInt64
Innodb_page_size_rate	Rate of Innodb_page_size over time	Float64
Innodb_data_reads_diff	Change in Innodb_data_reads since the last measurement	UInt64
Innodb_data_reads_rate	Rate of Innodb_data_reads over time	Float64
Innodb_buffer_pool_reads_diff	Change in Innodb_buffer_pool_reads since the last measurement	UInt64
Innodb_buffer_pool_reads_rate	Rate of Innodb_buffer_pool_reads over time	Float64
Innodb_data_writes_diff	Change in Innodb_data_writes since the last measurement	UInt64
Innodb_data_writes_rate	Rate of Innodb_data_writes over time	Float64
Innodb_log_writes_diff	Change in Innodb_log_writes since the last measurement	UInt64
Innodb_log_writes_rate	Rate of Innodb_log_writes over time	Float64
timestamp	The timestamp when the metrics were recorded	DateTime
tenant_id	The tenant ID	LowCardinality(String)
bu_id	The business unit ID	LowCardinality(String)
host	The host name where the metrics were collected	LowCardinality(String)
type	The type of the entity being monitored	LowCardinality(String)
ClusterID	Name of the culster for which the metrics are collected	LowCardinality(String)
DBName	Name of the database for which the metrics are collected	LowCardinality(String)
uniqueId	Unique identifier for the record	LowCardinality(String)
Com_delete	Total number of DELETE operations	UInt64
Com_SELECT	Total number of SELECT operations	UInt64
Com_insert	Total number of INSERT operations	UInt64
Com_update	Total number of UPDATE operations	UInt64
Com_delete_multi	Number of multi-table DELETE operations	UInt64
Com_insert_SELECT	Number of INSERT ... SELECT operations	UInt64
Com_replace_SELECT	Number of REPLACE ... SELECT operations	UInt64
Com_update_multi	Number of multi-table UPDATE operations	UInt64
Com_replace	Total number of REPLACE operations	UInt64
Com_load	Number of LOAD DATA operations	UInt64
Com_delete_diff	Change in the number of DELETE operations since the last measurement	UInt64
Com_insert_diff	Change in the number of INSERT operations since the last measurement	UInt64
Com_SELECT_diff	Change in the number of SELECT operations since the last measurement	UInt64
Com_update_diff	Change in the number of UPDATE operations since the last measurement	UInt64
Com_delete_multi_diff	Change in the number of multi-table DELETE operations since the last measurement	UInt64
Com_insert_SELECT_diff	Change in the number of INSERT ... SELECT operations since the last measurement	UInt64
Com_replace_SELECT_diff	Change in the number of REPLACE ... SELECT operations since the last measurement	UInt64
Com_update_multi_diff	Change in the number of multi-table UPDATE operations since the last measurement	UInt64
Com_replace_diff	Change in the number of REPLACE operations since the last measurement	UInt64
Com_load_diff	Change in the number of LOAD DATA operations since the last measurement	UInt64
timestamp	The timestamp when the metrics were recorded	DateTime
tenant_id	The tenant ID	LowCardinality(String)
bu_id	The business unit ID	LowCardinality(String)
host	The host name where the metrics were collected	LowCardinality(String)
type	The type of the entity being monitored	LowCardinality(String)
ClusterID	Name of the culster for which the metrics are collected	LowCardinality(String)
DBName	Name of the database for which the metrics are collected	LowCardinality(String)
table_scan_query	The query that performed the table scan	String
table_scan_exec_count	The number of executions of the table scan	UInt64
table_scan_total_latency	Total latency incurred by the table scan in microseconds	UInt64
table_scan_no_index_used_pct	Percentage of scans where no index was used	String
table_scan_row_sent_avg	Average number of rows sent during table scans	String
table_scan_rows_examined	Total number of rows examined during the table scan	String
table_scan_first_seen	First time the table scan was observed	DateTime
table_scan_last_seen	Last time the table scan was observed	DateTime
timestamp	The timestamp when the metrics were recorded	DateTime
tenant_id	The tenant ID	LowCardinality(String)
bu_id	The business unit ID	LowCardinality(String)
host	The host name where the metrics were collected	LowCardinality(String)
type	The type of the entity being monitored	LowCardinality(String)
ClusterID	Name of the culster for which the metrics are collected	LowCardinality(String)
DBName	Name of the database for which the metrics are collected	LowCardinality(String)
Master_id	Unique identifier for the master server in replication	LowCardinality(String)
Port	Port used for communication	LowCardinality(String)
Server_id	Unique identifier for the server in replication	LowCardinality(String)
Master_Host	Hostname of the master server	LowCardinality(String)
Connect_Retry	Number of seconds between connection retry attempts	UInt64
Exec_Master_Log_Pos	Position in the master's log file where replication starts	UInt64
Gtid_IO_Pos	Current GTID (Global Transaction Identifier) position for replication	String
Last_Errno	Error number from the last replication event	UInt64
Last_Error	Description of the last error	String
Last_IO_Errno	Error number from the last I/O event during replication	UInt64
Last_IO_Error	Description of the last I/O error during replication	String
Last_SQL_Errno	Error number from the last SQL event during replication	UInt64
Last_SQL_Error	Description of the last SQL error during replication	String
Master_Log_File	Log file name on the master server	String
Master_Port	Port number used by the master server	String
Master_SSL_Allowed	Indicates whether SSL is allowed for the master connection	String
Master_SSL_CA_File	SSL CA file used for the master connection	String
Master_SSL_CA_Path	SSL CA path used for the master connection	String
Master_SSL_Cert	SSL certificate used for the master connection	String
Master_SSL_Cipher	SSL cipher used for the master connection	String
Master_SSL_Crl	SSL CRL (Certificate Revocation List) used for the master connection	String
Master_SSL_Crlpath	SSL CRL path used for the master connection	String
Master_SSL_Key	SSL key used for the master connection	String
Master_SSL_Verify_Server_Cert	Indicates if the master's server certificate is verified	String
Master_Server_Id	Unique identifier of the master server	String
Master_User	Username for connecting to the master server	String
Parallel_Mode	The replication parallel mode being used	String
Read_Master_Log_Pos	Position of the last read event in the master's log file	UInt64
Relay_Log_File	Name of the relay log file	String
Relay_Log_Pos	Position in the relay log file	UInt64
Relay_Log_Space	Total space used by the relay log	UInt64
Relay_Master_Log_File	Log file on the master server that the relay log is reading	String
Replicate_Do_DB	Databases to replicate	String
Replicate_Do_Domain_Ids	Domain IDs to replicate	String
Replicate_Do_Table	Tables to replicate	String
Replicate_Ignore_DB	Databases to ignore for replication	String
Replicate_Ignore_Domain_Ids	Domain IDs to ignore for replication	String
Replicate_Ignore_Server_Ids	Server IDs to ignore for replication	String
Replicate_Ignore_Table	Tables to ignore for replication	String
Replicate_Rewrite_DB	Database names to rewrite during replication	String
Replicate_Wild_Do_Table	Tables with wildcards to replicate	String
Replicate_Wild_Ignore_Table	Tables with wildcards to ignore during replication	String
SQL_Delay	Seconds to delay replication	UInt64
Seconds_Behind_Master	Time in seconds the slave is behind the master	UInt64
Skip_Counter	Number of events to skip during replication	UInt64
Slave_DDL_Groups	Number of Data Definition Language (DDL) groups processed	UInt64
Slave_IO_Running	Indicates whether the I/O thread is running	String
Slave_IO_State	State of the slave's I/O thread	String
Slave_Non_Transactional_Groups	Number of non-transactional groups processed	UInt64
Slave_SQL_Running	Indicates whether the SQL thread is running	String
Slave_SQL_Running_State	State of the SQL thread in replication	String
Slave_Transactional_Groups	Number of transactional groups processed	UInt64
Until_Condition	Condition to stop replication	String
Until_Log_File	Log file to stop replication	String
Until_Log_Pos	Log position to stop replication	UInt64
Using_Gtid	Indicates if GTID is being used for replication	String
Last_Errno_diff	Change in the error number from the last replication event	UInt64
Last_IO_Errno_diff	Change in the I/O error number from the last replication event	UInt64
Last_SQL_Errno_diff	Change in the SQL error number from the last replication event	UInt64
timestamp	The timestamp when the metrics were recorded	DateTime
tenant_id	The tenant ID	LowCardinality(String)
bu_id	The business unit ID	LowCardinality(String)
host	The host name where the metrics were collected	LowCardinality(String)
type	The type of the entity being monitored	LowCardinality(String)
ClusterID	Name of the culster for which the metrics are collected	LowCardinality(String)
DBName	Name of the database for which the metrics are collected	LowCardinality(String)
object_schema	The schema of the database object	String
object_name	The name of the database object (e.g. table index)	String
index_name	The name of the index	String
total_size_mb	The total size of the index in megabytes	Float64
timestamp	The timestamp when the metrics were recorded	DateTime
tenant_id	The tenant ID	LowCardinality(String)
bu_id	The business unit ID	LowCardinality(String)
host	The host name where the metrics were collected	LowCardinality(String)
type	The type of the entity being monitored	LowCardinality(String)
ClusterID	Name of the culster for which the metrics are collected	LowCardinality(String)
DBName	Name of the database for which the metrics are collected	LowCardinality(String)
ID	Unique identifier for the process	UInt64
USER	The user executing the command	String
HOST	The host from which the command is executed	String
COMMAND	The command being executed	String
TIME	Time in seconds the command has been running	UInt64
STATE	Current state of the command	String
timestamp	The timestamp when the metrics were recorded	DateTime
tenant_id	The tenant ID	LowCardinality(String)
bu_id	The business unit ID	LowCardinality(String)
host	The host name where the metrics were collected	LowCardinality(String)
type	The type of the entity being monitored	LowCardinality(String)
ClusterID	Name of the culster for which the metrics are collected	LowCardinality(String)
DBName	Name of the database for which the metrics are collected	LowCardinality(String)
uniqueId	Unique identifier for the record	LowCardinality(String)
Query_cache_size	Total size of the query cache in bytes	UInt64
Qcache_hits	Total number of cache hits	UInt64
Qcache_inserts	Total number of queries added to the cache	UInt64
Qcache_lowmem_prunes	Total number of queries removed from the cache due to low memory	UInt64
Qcache_total_blocks	Total number of blocks in the query cache	UInt64
Qcache_free_blocks	Number of free blocks in the query cache	UInt64
Qcache_free_memory	Amount of free memory in the query cache in bytes	UInt64
Qcache_not_cached	Number of queries that were not cached	UInt64
Qcache_queries_in_cache	Current number of queries in the cache	UInt64
Qcache_not_cached_diff	Change in the number of uncached queries	UInt64
Qcache_queries_in_cache_diff	Change in the number of cached queries	UInt64
timestamp	The timestamp when the log was recorded	DateTime
tenant_id	The tenant ID	LowCardinality(String)
bu_id	The business unit ID	LowCardinality(String)
host	The host name where the log was generated	LowCardinality(String)
type	The type of log entry	LowCardinality(String)
ClusterID	Name of the culster for which the metrics are collected	LowCardinality(String)
DBName	Name of the database associated with the log	LowCardinality(String)
ThreadId	Identifier for the thread that generated the log	String
LogLevel	The severity level of the log entry (e.g. INFO ERROR)	String
Logmessage	The log message itself	String
tags	An array of additional tags or metadata related to the log entry	Array(String)
timestamp	The timestamp when the query was executed	DateTime
tenant_id	The tenant ID	LowCardinality(String)
bu_id	The business unit ID	LowCardinality(String)
host	The host name where the query was executed	LowCardinality(String)
type	The type of log entry	LowCardinality(String)
ClusterID	Name of the culster for which the metrics are collected	LowCardinality(String)
DBName	The name of the database associated with the query	LowCardinality(String)
User	The user who executed the query	String
IPAddress	The IP address from which the query was initiated	LowCardinality(String)
ThreadId	The thread ID associated with the query execution	String
QueryTime	The time taken to execute the query in seconds	Float64
LockTime	The time spent waiting for locks during query execution in seconds	Float64
RowsSent	The number of rows sent back to the client	UInt64
RowsExamined	The number of rows examined during query execution	UInt64
RowsAffected	The number of rows affected during query execution	UInt64
BytesSent	The number of bytes sent during query execution	UInt64
Query	The SQL query that was executed	String
QCHit	Query Cache Hit Status	String
tags	An array of additional tags or metadata related to the query	Array(String)