Question: How to check active connections in mysql?
show status where `variable_name` = 'Threads_connected';
Question: How to check the limit of MySQL active connections?
SHOW VARIABLES LIKE "max_connections";
Question: Display the list of active MySQL Process list?
show processlist;
Question: How to check the max no of connections used?
SHOW STATUS WHERE `variable_name` = 'Max_used_connections';
Question: MySQL set the max no of connections used (Temporarily/Quick)?
SET GLOBAL max_connections = 512;
Question: MySQL set the max no of connections used (Temporarily/Quick)?
Open my.cnf or my.ini in MySQL
max_connections = 512
service mysqld restart
Question: MySQL check number of connections throughout history?
show status like 'Connections%';