I collected cnosdb trace through jaeger, and found by building a table that the execution plan collected was for query. Is there a problem?

huangapple go评论66阅读模式
英文:

I collected cnosdb trace through jaeger, and found by building a table that the execution plan collected was for query. Is there a problem?

问题

我通过Jaeger收集了cnosdb的跟踪信息,并通过构建一个表格发现收集的执行计划是针对查询的。是否有问题?
我根据官方文档修改了配置信息,如下:

[trace]
auto_generate_span = false
[trace.jaeger]
jaeger_agent_endpoint = 'http://localhost:14268/api/traces'
max_concurrent_exports = 2
max_queue_size = 4096

然后通过官方脚本启动了3mta 2data集群,如下:

bash run_cluster.sh

然后通过写入数据接口创建了一个表格,如下:

curl -i -u "root:" -H "Accept: application/json" -H "uber-trace-id: 3a3a43:432e345:0:1" -XPOST "http://127.0.0.1:12002/api/v1/sql?db=usage_schema&pretty=true" -d "CREATE TABLE air (visibility DOUBLE,temperature DOUBLE,presssure DOUBLE,TAGS(station));"

最后,通过JaegerUI检查跟踪,如下:

Limit: skip=0, fetch=5 [time:Timestamp(Nanosecond, None), database:Utf8;N, host:Utf8;N, node_id:Utf8;N, tenant:Utf8;N, user:Utf8;N, value:UInt64;N]
  Sort: user_queries.time DESC NULLS FIRST [time:Timestamp(Nanosecond, None), database:Utf8;N, host:Utf8;N, node_id:Utf8;N, tenant:Utf8;N, user:Utf8;N, value:UInt64;N]
    Projection: user_queries.time, user_queries.database, user_queries.host, user_queries.node_id, user_queries.tenant, user_queries.user, user_queries.value [time:Timestamp(Nanosecond, None), database:Utf8;N, host:Utf8;N, node_id:Utf8;N, tenant:Utf8;N, user:Utf8;N, value:UInt64;N]
      TableScan: user_queries [time:Timestamp(Nanosecond, None), database:Utf8;N, host:Utf8;N, node_id:Utf8;N, tenant:Utf8;N, user:Utf8;N, value:UInt64;N]

这不是查询的执行计划吗?收集的信息有问题吗?

英文:

I collected cnosdb trace information through jaeger, and found by building a table that the execution plan collected was for query. Is there a problem?
I modify the configuration information according to the official document, as follows:

[trace]
auto_generate_span = false
[trace.jaeger]
jaeger_agent_endpoint = 'http://localhost:14268/api/traces'
max_concurrent_exports = 2
max_queue_size = 4096

Then pull up the 3mta 2data cluster through the official script, as follows:

bash run_cluster.sh

Then create a table by writing to the data interface, as follows:

curl -i -u "root:" -H "Accept: application/json" -H "uber-trace-id: 3a3a43:432e345:0:1" -XPOST "http://127.0.0.1:12002/api/v1/sql?db=usage_schema&pretty=true" -d "CREATE TABLE air (visibility DOUBLE,temperature DOUBLE,presssure DOUBLE,TAGS(station));"

Finally, check the trace through jaegerUI, as follows:

Limit: skip=0, fetch=5 [time:Timestamp(Nanosecond, None), database:Utf8;N, host:Utf8;N, node_id:Utf8;N, tenant:Utf8;N, user:Utf8;N, value:UInt64;N]
  Sort: user_queries.time DESC NULLS FIRST [time:Timestamp(Nanosecond, None), database:Utf8;N, host:Utf8;N, node_id:Utf8;N, tenant:Utf8;N, user:Utf8;N, value:UInt64;N]
    Projection: user_queries.time, user_queries.database, user_queries.host, user_queries.node_id, user_queries.tenant, user_queries.user, user_queries.value [time:Timestamp(Nanosecond, None), database:Utf8;N, host:Utf8;N, node_id:Utf8;N, tenant:Utf8;N, user:Utf8;N, value:UInt64;N]
      TableScan: user_queries [time:Timestamp(Nanosecond, None), database:Utf8;N, host:Utf8;N, node_id:Utf8;N, tenant:Utf8;N, user:Utf8;N, value:UInt64;N]

Isn't this the execution plan of the query? Is there a problem with the collected information?

答案1

得分: 0

我稍后检查了Jaeger配置。默认情况下,它不会按时间降序显示。之后,每次操作都以时间降序检查Jaeger日志是正常的。

英文:

I checked the jaeger configuration later. By default, it is not displayed in descending order of time. After that, it is normal to check the jaeger log in descending order of time for each operation.

huangapple
  • 本文由 发表于 2023年7月11日 10:56:52
  • 转载请务必保留本文链接:https://go.coder-hub.com/76658453.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定