TIFLASH_TABLES

TIFLASH_TABLES - 图1

Warning

Do not use this table in production environments, as the fields of the table are unstable, and subject to change in new releases of TiDB, without prior notice.

TIFLASH_TABLES - 图2

Note

This table is not available on TiDB Serverless clusters.

The TIFLASH_TABLES table provides statistical information about data tables in TiFlash.

  1. USE information_schema;
  2. DESC tiflash_tables;
  1. +-------------------------------------------+--------------+------+------+---------+-------+
  2. | Field                                     | Type         | Null | Key  | Default | Extra |
  3. +-------------------------------------------+--------------+------+------+---------+-------+
  4. | DATABASE                                  | varchar(64)  | YES  |      | NULL    |       |
  5. | TABLE                                     | varchar(64)  | YES  |      | NULL    |       |
  6. | TIDB_DATABASE                             | varchar(64)  | YES  |      | NULL    |       |
  7. | TIDB_TABLE                                | varchar(64)  | YES  |      | NULL    |       |
  8. | TABLE_ID                                  | bigint(64)   | YES  |      | NULL    |       |
  9. | IS_TOMBSTONE                              | bigint(64)   | YES  |      | NULL    |       |
  10. | SEGMENT_COUNT                             | bigint(64)   | YES  |      | NULL    |       |
  11. | TOTAL_ROWS                                | bigint(64)   | YES  |      | NULL    |       |
  12. | TOTAL_SIZE                                | bigint(64)   | YES  |      | NULL    |       |
  13. | TOTAL_DELETE_RANGES                       | bigint(64)   | YES  |      | NULL    |       |
  14. | DELTA_RATE_ROWS                           | double       | YES  |      | NULL    |       |
  15. | DELTA_RATE_SEGMENTS                       | double       | YES  |      | NULL    |       |
  16. | DELTA_PLACED_RATE                         | double       | YES  |      | NULL    |       |
  17. | DELTA_CACHE_SIZE                          | bigint(64)   | YES  |      | NULL    |       |
  18. | DELTA_CACHE_RATE                          | double       | YES  |      | NULL    |       |
  19. | DELTA_CACHE_WASTED_RATE                   | double       | YES  |      | NULL    |       |
  20. | DELTA_INDEX_SIZE                          | bigint(64)   | YES  |      | NULL    |       |
  21. | AVG_SEGMENT_ROWS                          | double       | YES  |      | NULL    |       |
  22. | AVG_SEGMENT_SIZE                          | double       | YES  |      | NULL    |       |
  23. | DELTA_COUNT                               | bigint(64)   | YES  |      | NULL    |       |
  24. | TOTAL_DELTA_ROWS                          | bigint(64)   | YES  |      | NULL    |       |
  25. | TOTAL_DELTA_SIZE                          | bigint(64)   | YES  |      | NULL    |       |
  26. | AVG_DELTA_ROWS                            | double       | YES  |      | NULL    |       |
  27. | AVG_DELTA_SIZE                            | double       | YES  |      | NULL    |       |
  28. | AVG_DELTA_DELETE_RANGES                   | double       | YES  |      | NULL    |       |
  29. | STABLE_COUNT                              | bigint(64)   | YES  |      | NULL    |       |
  30. | TOTAL_STABLE_ROWS                         | bigint(64)   | YES  |      | NULL    |       |
  31. | TOTAL_STABLE_SIZE                         | bigint(64)   | YES  |      | NULL    |       |
  32. | TOTAL_STABLE_SIZE_ON_DISK                 | bigint(64)   | YES  |      | NULL    |       |
  33. | AVG_STABLE_ROWS                           | double       | YES  |      | NULL    |       |
  34. | AVG_STABLE_SIZE                           | double       | YES  |      | NULL    |       |
  35. | TOTAL_PACK_COUNT_IN_DELTA                 | bigint(64)   | YES  |      | NULL    |       |
  36. | MAX_PACK_COUNT_IN_DELTA                   | bigint(64)   | YES  |      | NULL    |       |
  37. | AVG_PACK_COUNT_IN_DELTA                   | double       | YES  |      | NULL    |       |
  38. | AVG_PACK_ROWS_IN_DELTA                    | double       | YES  |      | NULL    |       |
  39. | AVG_PACK_SIZE_IN_DELTA                    | double       | YES  |      | NULL    |       |
  40. | TOTAL_PACK_COUNT_IN_STABLE                | bigint(64)   | YES  |      | NULL    |       |
  41. | AVG_PACK_COUNT_IN_STABLE                  | double       | YES  |      | NULL    |       |
  42. | AVG_PACK_ROWS_IN_STABLE                   | double       | YES  |      | NULL    |       |
  43. | AVG_PACK_SIZE_IN_STABLE                   | double       | YES  |      | NULL    |       |
  44. | STORAGE_STABLE_NUM_SNAPSHOTS              | bigint(64)   | YES  |      | NULL    |       |
  45. | STORAGE_STABLE_OLDEST_SNAPSHOT_LIFETIME   | double       | YES  |      | NULL    |       |
  46. | STORAGE_STABLE_OLDEST_SNAPSHOT_THREAD_ID  | bigint(64)   | YES  |      | NULL    |       |
  47. | STORAGE_STABLE_OLDEST_SNAPSHOT_TRACING_ID | varchar(128) | YES  |      | NULL    |       |
  48. | STORAGE_DELTA_NUM_SNAPSHOTS               | bigint(64)   | YES  |      | NULL    |       |
  49. | STORAGE_DELTA_OLDEST_SNAPSHOT_LIFETIME    | double       | YES  |      | NULL    |       |
  50. | STORAGE_DELTA_OLDEST_SNAPSHOT_THREAD_ID   | bigint(64)   | YES  |      | NULL    |       |
  51. | STORAGE_DELTA_OLDEST_SNAPSHOT_TRACING_ID  | varchar(128) | YES  |      | NULL    |       |
  52. | STORAGE_META_NUM_SNAPSHOTS                | bigint(64)   | YES  |      | NULL    |       |
  53. | STORAGE_META_OLDEST_SNAPSHOT_LIFETIME     | double       | YES  |      | NULL    |       |
  54. | STORAGE_META_OLDEST_SNAPSHOT_THREAD_ID    | bigint(64)   | YES  |      | NULL    |       |
  55. | STORAGE_META_OLDEST_SNAPSHOT_TRACING_ID   | varchar(128) | YES  |      | NULL    |       |
  56. | BACKGROUND_TASKS_LENGTH                   | bigint(64)   | YES  |      | NULL    |       |
  57. | TIFLASH_INSTANCE                          | varchar(64)  | YES  |      | NULL    |       |
  58. +-------------------------------------------+--------------+------+------+---------+-------+
  59. 54 rows in set (0.00 sec)

Fields in the TIFLASH_TABLES table are described as follows:

  • DATABASE: The name of the database that the table belongs to in TiFlash.
  • TABLE: The name of the table in TiFlash.
  • TIDB_DATABASE: The name of the database that the table belongs to in TiDB.
  • TIDB_TABLE: The name of the table in TiDB.
  • TABLE_ID: The internal ID of the table, which is unique within a TiDB cluster.
  • IS_TOMBSTONE: Indicates whether the table can be recycled. 1 indicates that the table can be recycled, and 0 indicates that the table is in a normal state.
  • SEGMENT_COUNT: The number of segments in the table. A segment is a data management unit in TiFlash.
  • TOTAL_ROWS: The total number of rows in the table.
  • TOTAL_SIZE: The total size of the table (in bytes).
  • TOTAL_DELETE_RANGES: The total number of Delete Ranges in the table.
  • DELTA_RATE_ROWS: The ratio of the total rows of the table in the Delta layer to the total rows of that table.
  • DELTA_RATE_SEGMENTS: The proportion of segments that contain a non-empty Delta layer in the table.
  • DELTA_PLACED_RATE: The proportion of rows that have completed index construction of the table in the Delta layer.
  • DELTA_CACHE_SIZE: The size of the cache of the table in the Delta layer (in bytes).
  • DELTA_CACHE_RATE: The proportion of cache data of the table in the Delta layer.
  • DELTA_CACHE_WASTED_RATE: The proportion of invalid cache data of the table in the Delta layer.
  • DELTA_INDEX_SIZE: The size of the memory occupied by indexes in the Delta layer (in bytes).
  • AVG_SEGMENT_ROWS: The average number of rows in all segments of the table.
  • AVG_SEGMENT_SIZE: The average size of all segments of the table (in bytes).
  • DELTA_COUNT: The number of segments that contain a non-empty Delta layer in the table.
  • TOTAL_DELTA_ROWS: The total number of rows in the Delta layer.
  • TOTAL_DELTA_SIZE: The total size of the data in the Delta layer (in bytes).
  • AVG_DELTA_ROWS: The average number of rows of data in all Delta layers.
  • AVG_DELTA_SIZE: The average size of data in all Delta layers (in bytes).
  • AVG_DELTA_DELETE_RANGES: The average number of Delete Range operations in all Delta layers.
  • STABLE_COUNT: The number of segments that contain a non-empty Stable layer in the table.
  • TOTAL_STABLE_ROWS: The total number of rows in all Stable layers.
  • TOTAL_STABLE_SIZE: The total size of the data in all Stable layers (in bytes).
  • TOTAL_STABLE_SIZE_ON_DISK: The disk space occupied by the data in all Stable layers (in bytes).
  • AVG_STABLE_ROWS: The average number of rows of data in all Stable layers.
  • AVG_STABLE_SIZE: The average size of data in all Stable layers (in bytes).
  • TOTAL_PACK_COUNT_IN_DELTA: The total number of Column Files in all Delta layers.
  • MAX_PACK_COUNT_IN_DELTA: The maximum number of Column Files in a single Delta layer.
  • AVG_PACK_COUNT_IN_DELTA: The average number of Column Files in all Delta layers.
  • AVG_PACK_ROWS_IN_DELTA: The average number of rows in all Column Files in all Delta layers.
  • AVG_PACK_SIZE_IN_DELTA: The average size of data in all Column Files in all Delta layers (in bytes).
  • TOTAL_PACK_COUNT_IN_STABLE: The total number of Packs in all Stable layers.
  • AVG_PACK_COUNT_IN_STABLE: The average number of Packs in all Stable layers.
  • AVG_PACK_ROWS_IN_STABLE: The average number of rows in all Packs in all Stable layers.
  • AVG_PACK_SIZE_IN_STABLE: The average size of data in all Packs in the Stable layer (in bytes).
  • STORAGE_STABLE_NUM_SNAPSHOTS: The number of snapshots in the Stable layer.
  • STORAGE_STABLE_OLDEST_SNAPSHOT_LIFETIME: The duration of the earliest snapshot in the Stable layer (in seconds).
  • STORAGE_STABLE_OLDEST_SNAPSHOT_THREAD_ID: The thread ID of the earliest snapshot in the Stable layer.
  • STORAGE_STABLE_OLDEST_SNAPSHOT_TRACING_ID: The tracing ID of the earliest snapshot in the Stable layer.
  • STORAGE_DELTA_NUM_SNAPSHOTS: The number of snapshots in the Delta layer.
  • STORAGE_DELTA_OLDEST_SNAPSHOT_LIFETIME: The duration of the earliest snapshot in the Delta layer (in seconds).
  • STORAGE_DELTA_OLDEST_SNAPSHOT_THREAD_ID: The thread ID of the earliest snapshot in the Delta layer.
  • STORAGE_DELTA_OLDEST_SNAPSHOT_TRACING_ID: The tracing ID of the earliest snapshot in the Delta layer.
  • STORAGE_META_NUM_SNAPSHOTS: The number of snapshots in the meta information.
  • STORAGE_META_OLDEST_SNAPSHOT_LIFETIME: The duration of the earliest snapshot in the meta information (in seconds).
  • STORAGE_META_OLDEST_SNAPSHOT_THREAD_ID: The thread ID of the earliest snapshot in the meta information.
  • STORAGE_META_OLDEST_SNAPSHOT_TRACING_ID: The tracing ID of the earliest snapshot in the meta information.
  • BACKGROUND_TASKS_LENGTH: The length of the task queue in the background.
  • TIFLASH_INSTANCE: The address of the TiFlash instance.