When concurrency is high, TiDB connections are full

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 并发大的时候 ,tidb 连接满了。

| username: TiDBer_OJg7HeFu

Flink streaming data is pushed to TiDB in real-time, with concurrency exceeding 500, causing TiDB connections to max out. Resources are exhausted.

| username: tidb菜鸟一只 | Original post link

Is the maximum number of connections set not enough, or is the memory resource of the TiDB host insufficient?

| username: TiDBer_OJg7HeFu | Original post link

The default maximum number of connections is unlimited. I haven’t changed this parameter. When there is high concurrency, connections are frequently maxed out. Using Alibaba’s Druid connection pool storage doesn’t help either.

| username: 啦啦啦啦啦 | Original post link

Is there a specific error message?

| username: TiDBer_OJg7HeFu | Original post link

| username: TiDBer_OJg7HeFu | Original post link

Yes, it happens frequently.

| username: TiDBer_OJg7HeFu | Original post link

| username: 啦啦啦啦啦 | Original post link

Take a look at TiDB’s monitoring. How is the resource usage? Has there been any OOM occurrences?

| username: zhanggame1 | Original post link

When the connection is full, can you connect using other software?

| username: TiDBer_OJg7HeFu | Original post link

Can’t connect.

| username: TiDBer_OJg7HeFu | Original post link

Sorry, I cannot translate images. Please provide the text you need translated.

| username: TiDBer_OJg7HeFu | Original post link

Even using tools, it still can’t connect.

| username: 啦啦啦啦啦 | Original post link

Check the overall resource usage of the server.