yswdqz commented on PR #9575:
URL: https://github.com/apache/skywalking/pull/9575#issuecomment-1238911476
> @yswdqz Could you share how the final LAL script would like? How could we
know the logs about MySQL slow SQL reports? Have we successfully set the tags
for logs?
The LAL script are following:
```
rules:
- name: mysql-slowsql
dsl: |
filter {
json{
}
slowSql {
serviceName parsed.service as String
id parsed.id as String
statement parsed.statement as String
latency parsed.query_time as Long
layer parsed.layer as String
timeBucket parsed.time as Long
}
}
```
I think we don't need to know the log is about MySQL slow SQL reports. We
just set the slowSql in LAL, and it can generate service and TopNStatement by
the log, and save them into database.
The json I send via http is following:
```
[{"date":1662478799.208541,"body":{"json":{"json":"{\"time\":\"20220906153959\",\"id\":\"cb92c1a5b-2691e-fb2f-457a-9c72a392d9ed\",\"service\":\"root[root]@[175.172.37.237]\",\"statement\":\"SET
timestamp=1662478799;select
sleep(2);\",\"layer\":\"MYSQL\",\"query_time\":2000}"}},"service":"root[root]@[175.172.37.237]"}]
```
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
