tdsql_cache_range_max_use_cnt is used to set the maximum number of times the cached range information can be used before it becomes invalid. Caching range information can reduce disk access frequency, thereby improving query performance. When this limit is reached, the system removes the least recently used data blocks based on the LRU algorithm to free up space for new data blocks.tdsql_cache_range_max_use_cnt parameter, you need to consider the following factors:tdsql_cache_range_max_use_cnt parameter may improve the hit rate of range query cache, thus enhancing query performance. However, an extremely large value may cause the data blocks in the cache not to expire quickly enough, thereby reducing the effectiveness of the cache.tdsql_cache_range_max_use_cnt parameter needs to be adjusted. If a performance bottleneck is identified, you can try to adjust the parameter to optimize performance.Required | Description |
Parameter Type | ULONGLONG |
Default Value | 100000 |
Value Range | 0 ~ 18446744073709551615 |
Effective Scope | GLOBAL SESSION |
Restart Required | No |
피드백