Overview
For businesses with frequent updates or flash sales, the hotspot update feature greatly optimizes the performance of the UPDATE operation on frequently updated rows. If automatic hotspot update detection is enabled, the system will automatically detect whether there is a single row of hotspot update. If such an update is detected, it will queue the large number of concurrent UPDATE operations and execute them sequentially. This helps reduce the risk of concurrency performance being compromised by numerous row locks.
Supported Versions
TDSQL-C for MySQL 5.7 (kernel version 2.0.23/2.1.9) or later.
TDSQL-C for MySQL 8.0 (kernel version 3.1.5) or later.
Use Cases
This feature is suitable for scenarios where the pressure of updating a single row or multiple rows with the primary key specified is very high, such as flash sales.
Parameter Description
Parameter | Effective Immediately | Type | Default Value | Valid Values | Description |
cdb_sql_filter_enable | yes | bool | off | on/off | Whether to enable hotspot update |
Use Limits