Dashboard Data Issues

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: dashboard数据问题

| username: jiangh

Where is the data for slow queries in the dashboard stored? Can it be queried with SQL? I need to perform some aggregate queries.

| username: xfworld | Original post link

Check this out.

| username: jiangh | Original post link

The time recorded in this table is not as long as the one on the dashboard.

| username: 像风一样的男子 | Original post link

The CLUSTER_SLOW_QUERY table records the slow SQL queries of the cluster.

| username: jiangh | Original post link

This time is also very short.
image

| username: 像风一样的男子 | Original post link

This slow SQL log is pulled from the TiDB server. You can check it on the server.

| username: tidb菜鸟一只 | Original post link

It is a collection of all slowlog log files on your host. If the files are large, the query will be very slow.

| username: zhanggame1 | Original post link

The TiDB server has a slow log. Where does it come from?

| username: 昵称想不起来了 | Original post link

Refer to Slow Log Memory Mapping Table

| username: 昵称想不起来了 | Original post link

However, real-time parsing can be a bit slow. It might be best to batch pull historical data for analysis during business downtime.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.