Use pd-ctl operator to manually transfer hot regions to less busy nodes. Hot regions can be viewed through pd-ctl hot region or tikv_hot_region (approximately these two names) to check the top read regions.
Use pd-ctl operator to manually split hot regions and then wait for scheduling. Splitting should be effective for hotspots concentrated on certain keys.
Check if the leader distribution is even and whether any leader weight settings are causing uneven distribution.
Tables can add scatter scheduling to evenly distribute all regions across all nodes, suitable for scenarios with many hot regions. However, sometimes scatter scheduling may not work well.
Use shuffle leader scheduling to randomly swap leaders, but turn it off immediately after enabling it; otherwise, random leader scheduling can severely impact performance.
Adjust table structure using auto_random, shard_rowid_bits, hash partitioning, and other methods.
|
username: robert233
|
username: 
|
username: 
|
username: 
|
username: 
|
username: