MySQL 8 max connections

In MySQL 8.0.14 and later, there is support for a special admin

address and port.

Users with the SERVICE_CONNECTION_ADMIN privilege can

connect to this port even when there are more than max_connections connections.



There is no limit (other than the operating system limit on open files

and processes)

how many connections can be made this way. That makes it easier to investigate

out of connections issues.



See also: https://dev.mysql.com/doc/refman/8.0/en/client-connections.html#client-connections-administrative-interface

Comments

Popular posts from this blog

Check MySQL query history from command line

Installing chocolatey on Windows

Fixed: ImportError: No module named utilities.common.tools