- 监控源端分析是否存在延迟
SELECT nodeid, CASE WHEN TIMESTAMPDIFF(SECOND, UPDATE_TIME, now()) > 900 THEN concat( 'NODE NO UPDATE ', TIMESTAMPDIFF(SECOND, UPDATE_TIME, now()), '(s)' ) ELSE CONCAT( 'NODE ANALYZE LOG DELAY ', delay, '(s)' ) END info FROM bus_push_capture bcp, bus_cluster_container_customer bccc WHERE bcp.NODEID = bccc.customerid AND bccc.`status` > 0 AND ( TIMESTAMPDIFF(SECOND, UPDATE_TIME, now()) > 900 OR delay > 900 )
文档更新时间: 2024-12-22 05:40 作者:阿力