tencent cloud

Boost Engagement with Tencent RTC Free TrialFree video and chat features await!

Feedback

TDSQL-C for MySQL

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



Catalog

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
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon