监控项

<p class="p">MySQL服务与云监控Argus服务紧密集成,提供完备的性能监控。通过云监控Argus服务可查看MySQL服务的资源使用情况等信息,以下为常用监控项的详细信息:</p> <table class="table" id="Metric__table_fzt_tp2_1xb"><caption></caption><colgroup><col><col><col></colgroup><thead class="thead"> <tr class="row"> <th class="entry" id="Metric__table_fzt_tp2_1xb__entry__1"> <p class="p">监控项</p> </th> <th class="entry" id="Metric__table_fzt_tp2_1xb__entry__2"> <p class="p">监控项名称</p> </th> <th class="entry" id="Metric__table_fzt_tp2_1xb__entry__3"> <p class="p">单位</p> </th> </tr> </thead><tbody class="tbody"> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_status</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">数据库可用性(0:异常,1:正常)</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">0/1</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_cpu_used_pct</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">CPU使用率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">%</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_mem_used_pct</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">内存使用率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">%</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_disk_used_pct</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">磁盘空间总体使用率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">%</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_disk_used</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">磁盘空间总体使用量</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">GB</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_disk_used_data</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">数据空间使用量</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">GB</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_disk_used_log</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">日志空间使用量</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">GB</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_disk_used_tmp</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">临时文件空间使用量</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">GB</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_connections_pct</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">连接数使用率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">%</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_io_thread_status</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">IO线程状态(0:异常,1:正常)</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">0/1</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_sql_thread_status</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">SQL线程状态(0:异常,1:正常)</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">0/1</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_seconds_behind_master</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">复制延迟</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">秒(s)</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_read_only_status</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">读写状态(0:可写,1:只读)</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">0/1</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_insert_per_second</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">每秒INSERT数</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">个</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_update_per_second</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">每秒UPDATE数</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">个</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_delete_per_second</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">每秒DELETE数</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">个</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_select_per_second</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">每秒SELECT数</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">个</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">max_connections</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">数据库总连接数</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">个</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">threads_running</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">当前活跃连接数</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">个</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">QPS</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">QPS</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">个</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">TPS</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">TPS</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">个</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_buffer_pool_pages_usage</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">缓冲池利用率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">%</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_buffer_pool_hits</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">缓冲池命中率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">%</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_buffer_pool_pages_dirty_rate</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">缓冲池脏块率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">%</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_data_read</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">InnoDB读取吞吐量</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">bytes</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_data_written</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">InnoDB写入吞吐量</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">bytes</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_data_reads</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">InnoDB文件读取频率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">次</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_data_writes</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">InnoDB文件写入频率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">次</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_data_log_write_requests</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">InnoDB日志写请求频率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">次</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_log_writes</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">InnoDB日志物理写频率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">次</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_data_fsyncs</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">InnoDB日志fsync()写频率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">次</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">created_tmp_tables</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">临时表数量</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">个</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">created_tmp_disk_tables</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">在硬盘上自动创建的临时表的数量</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">个</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_rows_deleted</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">行删除速率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">次</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_rows_inserted</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">行插入速率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">次</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_rows_read</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">行读取速率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">次</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_rows_updated</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">行更新速率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">次</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">slow_queries</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">慢日志个数统计</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">次</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">qcache_hits</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">查询缓存命中率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">次</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">qcache_usage</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">查询缓存使用率</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">次</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">open_tables</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">已经打开的表数</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">个</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">threads_created</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">已创建的线程数</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">个</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">threads_connected</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">连接的线程数</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">个</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_buffer_pool_pages_free</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">InnoDB 空页数</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">个</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_buffer_pool_pages_total</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">InnoDB 总页数</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">个</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_row_lock_time_avg</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">InnoDB 平均获取行锁时间</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">毫秒(ms)</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">innodb_row_lock_waits</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">InnoDB 等待行锁次数</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">毫秒(ms)</p> </td> </tr> <tr class="row"> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__1 "> <p class="p">mysql_hostname</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__2 "> <p class="p">当前主机实例发生主备切换</p> </td> <td class="entry" headers="Metric__table_fzt_tp2_1xb__entry__3 "> <p class="p">-</p> </td> </tr> </tbody></table>
以上内容是否解决了您的问题?
请补全提交信息!
联系我们

电话咨询

400-151-8800

邮件咨询

fincloud@ocft.com

在线客服

工单支持

解决云产品相关技术问题