tencent cloud

TDSQL Boundless

Release Notes
Product Introduction
Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Usage specification recommendations
Kernel Features
Kernel Overview
Kernel Version Release Notes
Functionality Features
Performance Features
Billing
Billing Overview
Purchase Method
Pricing Details
Renewal
Overdue Payments
Refund
Getting Started
Creating an Instance
Connect to Instances
User Guide
Data Migration
Data Subscription
Instance Management
Parameter Configuration
Account Management
Security Group
Backup and Restoration
Database Auditing
Tag Management
Use Cases
Technical Evolution and Usage Practices of Online DDL
Lock Mechanism Analysis and Troubleshooting Practices
Data Intelligent Scheduling and Related Practices for Performance Optimization
TDSQL Boundless Selection Guide and Practical Tutorial
Developer Guide
Developer Guide (MySQL Compatibility Mode)
Developer Guide (HBase Compatibility Mode)
Performance Tuning
Performance Tuning Overview
SQL Tuning
DDL Tuning
Performance White Paper
Performance Overview
TPC-C Test
Sysbench Test
API Documentation
History
Introduction
API Category
Making API Requests
Instance APIs
Security Group APIs
Task APIs
Backup APIs
Rollback APIs
Parameter APIs
Database APIs
Data Types
Error Codes
General Reference
System Architecture
SQL Reference
Database Parameter Description
TPC-H benchmark data model reference
Error Code Information
Security and Compliance
FAQs
Agreements
Service Level Agreement
Terms of Service
Privacy Policy
Data Processing And Security Agreement
Contact Us
Glossary
문서TDSQL BoundlessGeneral ReferenceSQL ReferenceData DictionaryINFORMATION_SCHEMARANGE_CACHE

RANGE_CACHE

PDF
포커스 모드
폰트 크기
마지막 업데이트 시간: 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)
이전 주제: PERSIST다음 주제: ROUTE_CACHE_HYPER_NODE

도움말 및 지원

문제 해결에 도움이 되었나요?

피드백