MySQL Settings

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.