How to view mysql connection Parameters

How to view mysql connection parameters 1. view the details of all current connections :. /mysqladmin-uadmin-p-h10.140.1.1 processlist www.2cto.com 2. view only the current number of connections (Threads is the number of connections .) :. /mysqladmin-uadmin-p-h10.140.1.1 status 3. How to know the number of concurrent connections set in MySQL (view max_connections): mysql> show variables; www.2cto.com: in my. add "set-variable = max_connections = 1000" under [mysqld] In cnf and then restart the MySQL service.