tencent cloud

TDSQL Boundless

DocumentaçãoTDSQL BoundlessGeneral ReferenceSQL ReferenceData DictionaryINFORMATION_SCHEMARANGE_CACHE

RANGE_CACHE

PDF
Modo Foco
Tamanho da Fonte
Última atualização: 2026-02-10 11:06:30

Function

INFORMATION_SCHEMA.RANGE_CACHE displays the Block Range Stats stored in the Range Cache, facilitating problem troubleshooting.

Field Description

Field Name
Type
Description
TABLE_SCHEMA
varchar(192)
Database name.
TABLE_NAME
varchar(192)
The table name.
INDEX_NAME
varchar(192)
Index name.
RANGE_CACHE_MISS
bigint
The number of Range Cache misses.
RANGE_CACHE_SAMPLE_ROWS
bigint
The number of sampled rows in the Block Range.
RANGE_CACHE_REFILL_TS
bigint
The timestamp of Block Range refill.
START_KEY
varchar(192)
start key of the Block Range (Start Key).
END_KEY
varchar(192)
end key of the Block Range (End Key).
RANGE_ROWS
bigint
Estimated number of rows in the Block Range.
RANGE_HINTS
bigint
Number of hits for Block Range.
RANGE_TIMESTAMP
bigint
timestamp generated by Block Range Stat.

Examples

tdsql > select * from information_schema.range_cache limit 1 \\G;
*************************** 1. row ***************************
           TABLE_SCHEMA: sbtest
             TABLE_NAME: sbtest1
             INDEX_NAME: PRIMARY
       RANGE_CACHE_MISS: 9486
RANGE_CACHE_SAMPLE_ROWS: 323
  RANGE_CACHE_REFILL_TS: 20251024023139
              START_KEY: 000027C280000001
                END_KEY: 000027C280000143
             RANGE_ROWS: 162
            RANGE_HINTS: 1
        RANGE_TIMESTAMP: 20251024023144
1 row in set (11.64 sec)
Anterior: PERSISTPróximo: ROUTE_CACHE_HYPER_NODE

Ajuda e Suporte

Esta página foi útil?

comentários