tristaZero commented on issue #4131: ShardingSphere storage configuration, e2e test and doc for SkyWalking 7 URL: https://github.com/apache/skywalking/issues/4131#issuecomment-587315261 ### Some Query SQLs select count(1) total alarm_record where 1=1 and time_bucket >= 20191210165700 and time_bucket <= 20191210171299 order by start_time desc select * from alarm_record where 1=1 and time_bucket >= ? and time_bucket <= ? order by start_time desc LIMIT 0, 20 select avg(value) value,entity_id from endpoint_avg where time_bucket >= ? and time_bucket <= ? group by entity_id order by value desc limit 10 select count(1) total from segment where 1=1 and time_bucket >= ? and time_bucket <= ? order by latency desc select * from segment where 1=1 and time_bucket >= 20191210165700 and time_bucket <= 20191210171299 order by latency desc LIMIT 0, 15 select entity_id id, avg(value) value from service_cpm where (entity_id in ('2','3')) and time_bucket>= ? and time_bucket<=? group by entity_id select avg(value) value,entity_id from service_cpm where time_bucket >= ? and time_bucket <= ? group by entity_id order by value desc limit 10 select id, value from endpoint_p90 where id in ('201912101657','201912101658','201912101659','201912101700','201912101701','201912101702','201912101703','201912101704','201912101705','201912101706','201912101707','201912101708','201912101709','201912101710','201912101711','201912101712') select id, value from instance_clr_cpu where id in ('201912101657_2','201912101658_2','201912101659_2','201912101700_2','201912101701_2','201912101702_2','201912101703_2','201912101704_2','201912101705_2','201912101706_2','201912101707_2','201912101708_2','201912101709_2','201912101710_2','201912101711_2','201912101712_2') select id, value from service_p50 where id in ('201912101657_2','201912101658_2','201912101659_2','201912101700_2','201912101701_2','201912101702_2','201912101703_2','201912101704_2','201912101705_2','201912101706_2','201912101707_2','201912101708_2','201912101709_2','201912101710_2','201912101711_2','201912101712_2') select entity_id from service_relation_client_side where time_bucket>= 201912101657 and time_bucket<=201912101712 and (source_service_id=2 or dest_service_id=2 ) group by entity_id select entity_id id, avg(value) value from service_resp_time where (entity_id in ('2','3')) and time_bucket>= 201912101657 and time_bucket<=201912101712 group by entity_id select entity_id id, avg(percentage) value from service_sla where (entity_id in ('2','3')) and time_bucket>= ? and time_bucket<=? group by entity_id
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services
