Number of MySQL connections under pressure measurement

Maximum number of connections supported by Mysql server

The performance of the host directly affects the maximum number of concurrent connections supported by the MySQL server side, such as insufficient memory to cause connection creation to fail.

/etc/my.conf configures the maximum number of connections that MySQL server can receive, and the performance of the host directly determines the maximum number of connections that can be created.

Use the Mysqlslap tool to measure the maximum number of connections supported by MySQL server, host configuration: Intel (R) Xeon (r) E5506 2.13GHz (4 core 8 threads) *2/memory 32gb/sas 300G

The steps are as follows:

Modify the max_connections=10000 of the/etc/my.conf file, MySQL default maximum connection number 151, restart MySQL service

Run the command line Mysqlslap

1 mysqlslap-hlocalhost-uroot-pletv   --create-schema=nova  --query="" 2--concurrency=9000  --number-of-queries= 9000-vv     

Insufficient host memory causes connection creation to fail

The maximum number of connections created by the host is around 8000

Number of MySQL connections under pressure measurement