extra_port

Support CLI: Yes

Support configuration file: Yes

Support dynamic modification: No

Scope: global

Parameter type: numeric

Default value: 0

Value range: 0 to 4294967295

This parameter is used to specify an extra port to listen on. The specified port can be used in case that new connections cannot be established because all worker threads are busy or locked when the thread pool feature is enabled. If this parameter is set to 0, no extra port is enabled.

Run the following command to connect to the extra port (similar to the method of using the port parameter, whose value defaults to 3306):

1

mysql --port='extra-port-number' --protocol=tcp

If this parameter is set to 0 and new connections cannot be set up because all worker threads are busy or locked when the thread pool feature is enabled, you can use the local connection to access the system where the MySQL service is running.

1	mysql -uroot -S xxxxx.sock -p

Or

1	mysql -uroot -h localhost -P3306 -p