摘要: (1)假如需要实现的需求是 SUM(COUNT(DISTINCT moengageuserid)) OVER (PARTITION BY eventname, date(from_unixtime(time_bucket)) ORDER BY eventname, time_bucket) AS r 阅读全文
posted @ 2021-12-11 23:46 5sdba 阅读(38) 评论(0) 推荐(0) 编辑
摘要: (1)如有用成熟的监控系统prometheus或者zabbix等开源的监控系统,没必要单独自己写脚本来取值监控,有时兴趣来了写了个简单的脚本,监控mysql与postgres数据库lag: #coding=utf-8 import pymysql,psycopg2 import requests,d 阅读全文
posted @ 2021-12-11 22:49 5sdba 阅读(67) 评论(0) 推荐(0) 编辑