hertzbeat icon indicating copy to clipboard operation
hertzbeat copied to clipboard

Published 20 hours ago • verified publisher icon apache

慢查询如何实现的？

Open wy1689979008 opened this issue 2 years ago • 3 comments

想请问一下MySQL慢查询是如何实现的？

wy1689979008 avatar Jun 06 '22 14:06 wy1689979008

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

I would like to ask how MySQL slow query is implemented?

Issues-translate-bot avatar Jun 06 '22 14:06 Issues-translate-bot

hi 可以考虑配置将mysql慢查询写入表(不写入日志)，然后使用hertzbeat自定义监控自定义sql查询对应指标

tomsun28 avatar Jun 07 '22 01:06 tomsun28

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

hi You can consider configuring to write MySQL slow query to the table (not to log), and then use hertzbeat to custom monitor the corresponding indicators of custom SQL query

Issues-translate-bot avatar Jun 07 '22 01:06 Issues-translate-bot