Seeking Advice on Optimizing TiDB Cluster for High Concurrency

[sykp241095]

Original author: marksmith991
Original time: 2024-08-27 05:33:24.841571
Original ID/Slug: 10291 / seeking-advice-on-optimizing-tidb-cluster-for-high-concurrency

Hey everyone,

Im relatively new to TiDB and have been experimenting with it for a project that requires handling a lot of concurrent transactions. So far, it is been pretty impressive, but as I scale up, I am starting to run into some performance hiccups when the concurrency gets high.

I am curious to hear from those of you who have experience with optimizing TiDB clusters for high concurrency. What are some best practices or tips you would recommend? Are there specific configurations or tweaks that have made a noticeable difference in your deployments?

Also I have gone through these resources/articles https://docs.pingcap.com/tidb/v7.6/high-concurrency-best-practices What Is Blue Prism however, they are quite useful but I want to learn from community.

Also, I am wondering if there are any common pitfalls to avoid when tuning the cluster under heavy loads. Would love to hear your thoughts and experiences!

Thanks in advance

Best Regards