tencent cloud

Feedback

Hotspot Update Protection

Last updated: 2024-04-25 11:21:31

    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

    
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support