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
Similar Posts:
- [Solved] MYSQL Error 1040 (HY000): too many connections
- ORA-12519: TNS:no appropriate service handler f…
- How to Solve Mysql Error 1206: The total number of locks exceeds the lock table size
- Some solutions to the error of [the underlying provider failed on open]
- MySQL Lock Error: Lock wait timeout exceeded [How to Solve]
- [Solved] MySQL Fail to Start Error: Error number 28 means ‘No space left on device’
- [Solved] xtrabackup: error: xb_load_tablespaces() failed with error code 57
- [How to Solve] Starting MySQL.. ERROR! The server quit without updating PID file
- MySQL Error Number 1005 Can’t create table (Errno:150)
- [Solved] MySQL query reports an error: Legal mix of settlements