• 监控源端分析是否存在延迟
    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   作者:阿力