SQL定时监控
+ 新建监控
新增监控配置
别名:
监控SQL:
结果判断条件:
>=
<=
开:
关:
提交
17341315051;18086849671;18782245302;15902886168;
hukejia@esender.com.cn;luoxin@esender.com.cn;xiongzhizong@esender.com.cn;fengdong@esender.com.cn;
别名:
监控SQL:
SELECT COUNT(1) AS '总量' FROM billing.migu_appdown WHERE CREATE_TIME >= CURDATE() AND CREATE_TIME < DATE_ADD(CURDATE(), INTERVAL 1 DAY) AND ACTION_TYPE = 'showPage' AND `STATUS` IN (1, 9)
结果判断条件:
>=
<=
开:
关:
提交
17341315051;18086849671;18782245302;15902886168;
hukejia@esender.com.cn;luoxin@esender.com.cn;xiongzhizong@esender.com.cn;fengdong@esender.com.cn;
别名:
监控SQL:
SELECT COUNT(*) AS ip_count FROM billing.migu_appdown WHERE CREATE_TIME >= CURDATE() AND CREATE_TIME < DATE_ADD(CURDATE(), INTERVAL 1 DAY) AND ACTION_TYPE = 'DownLoad' GROUP BY REAL_IP HAVING ip_count > 1 ORDER BY ip_count DESC LIMIT 1;
结果判断条件:
>=
<=
开:
关:
提交
17341315051;18086849671;18782245302;15902886168;
hukejia@esender.com.cn;luoxin@esender.com.cn;xiongzhizong@esender.com.cn;fengdong@esender.com.cn;
别名:
监控SQL:
SELECT COALESCE ( ( SELECT COUNT(*) AS ip_count FROM ringbell.ai_video_ring_setting_detail WHERE CREATE_TIME >= CURDATE() AND CREATE_TIME < DATE_ADD(CURDATE(), INTERVAL 1 DAY) AND IP IS NOT NULL GROUP BY IP HAVING ip_count >= 1 ORDER BY ip_count DESC LIMIT 1 ), 0 ) AS max_repeat_ip_count;
结果判断条件:
>=
<=
开:
关:
提交
17341315051;18086849671;18782245302;15902886168;
hukejia@esender.com.cn;luoxin@esender.com.cn;xiongzhizong@esender.com.cn;fengdong@esender.com.cn;
别名:
监控SQL:
SELECT COUNT(1) FROM ( SELECT * FROM log WHERE CREATE_TIME >= CURDATE() AND CREATE_TIME < CURDATE() + INTERVAL 1 DAY AND IP IS NOT NULL GROUP BY IP HAVING COUNT(DISTINCT PHONE) > 15) tab
结果判断条件:
>=
<=
开:
关:
提交
17341315051;18086849671;18782245302;15902886168;
hukejia@esender.com.cn;luoxin@esender.com.cn;xiongzhizong@esender.com.cn;fengdong@esender.com.cn;
别名:
监控SQL:
SELECT IF ( show_page_count = 0, 0.0, ROUND( download_count / show_page_count * 100, 1 ) ) AS download_showpage_percent FROM ( SELECT SUM( CASE WHEN ACTION_TYPE = 'showPage' AND STATUS = 2 THEN 1 ELSE 0 END ) AS show_page_count, SUM( CASE WHEN ACTION_TYPE = 'DownLoad' THEN 1 ELSE 0 END ) AS download_count FROM billing.migu_appdown WHERE CREATE_TIME >= DATE_SUB(NOW(), INTERVAL 60 MINUTE) AND CREATE_TIME <= NOW() AND ( ( ACTION_TYPE = 'showPage' AND `STATUS` = 2 ) OR ACTION_TYPE = 'DownLoad' ) ) AS t;
结果判断条件:
>=
<=
开:
关:
提交
17666294451
1
别名:
监控SQL:
SELECT SCHEMANAME AS '数据库' FROM informationschema.SCHEMATA;
结果判断条件:
>=
<=
开:
关:
提交
导航
首页