mysql -u root -p -e "SHOW VARIABLES LIKE 'max_connections';"

Category: Databases & SQL

mysql -u root -p -e "SHOW VARIABLES LIKE 'max_connections';"

Show the connection limit

Reads the max_connections system variable, which caps concurrent client connections. Exceeding it produces too many connections errors. Compare with SHOW STATUS LIKE 'Threads_connected'.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.