How to Quickly Locate Statements Using TiFlash

Translated
1

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

Original topic: 如何快速定位使用tiflash的语句

| username: Raymond

May I ask how to quickly locate the statements using TiFlash? My current method is to use the PLAN field in CLUSTER_STATEMENTS_SUMMARY\G to see if the execution plan shows TiFlash. Are there any other ways?

2
| username: Billmay表妹 | Original post link

In addition to using the PLAN field in the CLUSTER_STATEMENTS_SUMMARY view to check whether the execution plan uses TiFlash, you can also use the EXPLAIN ANALYZE command to view detailed information about the execution plan to determine whether TiFlash is used.

The specific steps are as follows:

  1. Execute the EXPLAIN ANALYZE command to view detailed information about the execution plan.
EXPLAIN ANALYZE SELECT * FROM table_name;
  1. Look for the Extra field in the execution plan. If the value of this field is Using TiFlash, it indicates that the statement uses TiFlash.
3
| username: redgame | Original post link

CLUSTER_STATEMENTS_SUMMARY is already very good.

4
| username: cassblanca | Original post link

You can also see it in the execution plan.

5
| username: system | Original post link

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