I was looking into tweaking my MySQL on a new server that just handles a couple sites one with OScommerce and get heavy use on MySQL.
So I looked in the my.cnf file and there is only very few settings
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
After just pressing update on the settings for mysql on NodeWorx I added all the directives you can edit through NodeWorx.
Not sure if this is the deserid behavior or not, but to me I just assumed the default settings I saw in NodeWorx were the live settings for MySQL.
Also, if I make a change to a setting via cmd line that can be seen in NodeWorx, it doesn’t show the correct value. I guess it’s pulling the live settings and not what is in the my.cnf file. Ill see after I do a restart. Ok, after restart it does update to the new settings.