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
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
No comments:
Post a Comment