Thursday, November 16

Too many connections? No problem!

We can increasing max_connections in MySQL without logging into MySQL instance
Is there any way we can increase max_connections variable in MySQL without logging into MySQL, mostly in situations wherein max_connections are exhausted ?

Many times a DBA needs to debug what's going withing MySQL instance in case its max out, below command can come for rescue

gdb -p $(cat <PATH OF PID FILE> -ex "set max_connections=1500" –batch