tidb 有没有系统视图 ，可以获取每个组件的状态

🪐 TiDB 技术问题
23

select value from METRICS_SCHEMA.up group by job order by time limit 1;
报了这个
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘METRICS_SCHEMA.up.value’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

24 
set session sql_mode='';
select * from (select instance,job,value,time from up order by time desc)as a group by instance,job;

试下这个

25

5分钟跑一次也行吧？

26

可以，没影响

27

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。