Tag Archives: mysqlslap: Error when connecting to server: 1064 Reach limit of connections

[Solved] mysqlslap: Error when connecting to server: 1064 Reach limit of connections

Background: today, mysqlslap is used to test the performance. When the concurrency number is 100, an error is reported, as shown in the figure

Script to run:

mysqlslap -h172.xx.xx.xx  -P9030 -uxx  --concurrency=100 --iterations=1 --create-schema=bds --query=/home/zhangjun/test.sql --engine=innodb --number-of-queries=1 --debug-info

Error message:

Solution:

Set the maximum number of user connections to solve this problem