Hello Doris Team,
I am facing an issue when performing load testing on Apache Doris using mysqlslap.
Here are the details:
Doris Version: apache-doris-3.0.7
Environment: 1 FE Node, 2 BE Node.
When I run the following command, it works fine:
mysqlslap --iterations=1 --user=root --host=192.168.2.3 --port=9030 --create-schema=abc --concurrency=1050
Result:
Benchmark
Average number of seconds to run all queries: 1.175 seconds
Minimum number of seconds to run all queries: 1.175 seconds
Maximum number of seconds to run all queries: 1.175 seconds
Number of clients running queries: 1050
Average number of queries per client: 0
But when I immediately run the same command again, I get the following error:
mysqlslap: Error when connecting to server: 2003 Can't connect to MySQL server on '192.168.2.3:9030' (111)
I have already set:
SET PROPERTY FOR 'root' 'max_user_connections' = '10000';
This issue also happens when I run my application load tests, not just with mysqlslap. It seems Doris is rejecting new connections after the first high-concurrency test, even though I increased max_user_connections.
Could you please help me understand:
Why Doris refuses the second attempt with the same concurrency test?
Do I need to adjust any other FE/BE configuration parameters besides max_user_connections?
Is there a recommended best practice for load testing Doris with more than 1000 concurrent connections?
Thanks in advance for your support.
