Zabbix MySQL

2025-05-11 zabbix 筆記 zabbix MySQL

zabbix mySQL 監控

監控項關鍵字（item_key) 監控項名稱（item_name） 備註
mysql.dbsize["{ MYSQL.HOST}","{ MYSQL.PORT}",“數據庫名字”] Info: Size of database 數據庫名字 數據庫大小
mysql.ping["{ MYSQL.HOST}","{ MYSQL.PORT}"] Availability: MySQL status 數據庫狀態1：正常0：異常
mysql.aborted_clients.rate Connections: Aborted clients per second 每秒中止的客戶端數
mysql.aborted_connects.rate Connections: Aborted connections per second 每秒中止的連接數
mysql.connection_errors_accept.rate Connections: Connection errors accept per second 每秒接受的連接錯誤數
mysql.connection_errors_internal.rate Connections: Connection errors internal per second 每秒內部連接錯誤數
mysql.connection_errors_max_connections.rate Connections: Connection errors max connections per second 連接錯誤每秒最大連接數
mysql.connection_errors_peer_address.rate Connections: Connection errors peer address per second 每秒對等地址連接錯誤數
mysql.connection_errors_select.rate Connections: Connection errors select per second 每秒查詢的連接錯誤數
mysql.connection_errors_tcpwrap.rate Connections: Connection errors tcpwrap per second 每秒tcpwrap 連接錯誤錯誤數
mysql.connections.rate Connections: Connections per second 每秒連接數
mysql.max_used_connections Connections: Max used connections 使用的最大連接數
mysql.threads_cached Connections: Threads cached 緩存的線程數
mysql.threads_connected Connections: Threads connected 連接的線程數
mysql.threads_created Connections: Threads created 創建的線程數
mysql.version["{ MYSQL.HOST}","{ MYSQL.PORT}"] Info: MySQL version MySQL 版本
mysql.uptime Info: Uptime 運行時間
mysql.buffer_pool_efficiency Performance: Buffer pool efficiency 緩衝池效率（%）
mysql.buffer_pool_utilization Performance: Buffer pool utilization 緩衝池利用率（%）
mysql.created_tmp_files Performance: Created tmp files on disk 在磁盤上創建的臨時文件數
mysql.created_tmp_disk_tables Performance: Created tmp tables on disk 在磁盤上創建的臨時表數
mysql.created_tmp_tables Performance: Created tmp tables on memory 在內存中創建的臨時表數
mysql.innodb_buffer_pool_pages_free Performance: InnoDB buffer pool pages free InnoDB 緩衝池頁面可用
mysql.innodb_buffer_pool_pages_total Performance: InnoDB buffer pool pages total InnoDB 緩衝池頁總數
mysql.innodb_buffer_pool_read_requests Performance: InnoDB buffer pool read requests InnoDB 緩衝池讀取請求
mysql.innodb_buffer_pool_reads Performance: InnoDB buffer pool reads InnoDB 緩衝池讀取
mysql.innodb_row_lock_time Performance: InnoDB row lock time InnoDB 行鎖定時間
mysql.innodb_row_lock_time_max Performance: InnoDB row lock time max InnoDB 最大行鎖定時間
mysql.innodb_row_lock_waits Performance: InnoDB row lock waits InnoDB 行鎖等待
mysql.slow_queries.rate Performance: Slow queries per second 每秒慢查询数
mysql.bytes_received.rate Throughput: Bytes received 接收的字节数
mysql.bytes_sent.rate Throughput: Bytes sent 发送的字节数
mysql.com_delete.rate Throughput: Command Delete per second 每秒删除操作数
mysql.com_insert.rate Throughput: Command Insert per second 每秒插入操作数
mysql.com_select.rate Throughput: Command Select per second 每秒查询操作数
mysql.com_update.rate Throughput: Command Update per second 每秒更新操作数
mysql.queries.rate Throughput: Queries per second 每秒查询数
mysql.questions.rate Throughput: Questions per second 每秒问题数

Relevant Topics


Recent Posts