Dec 16, 2010, 02:24 AM
Max_connections in mySQL
In Plesk 10.0.1, I noticed that the max_connections in my.cnf file was commented. When running this command in SSH: mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow ` variables | grep 'max.*connections', the results is 100.
I need to tweak the mySQL due to higher connections, and is it safe to remove the comment character in my.cnf and change the value? I guess I need to restart mySQL service to make the changes work, right?
Dec 16, 2010, 03:23 AM
Yes, you are correct and you can tune my.cnf