监控项
<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>
提交成功!非常感谢您的反馈,我们会继续努力做到更好!