asked on

mysql Reload option!

can someone please explain how does "mysql reload" works comparing to "mysql restart".
I made some changes on my.conf file, and I can't afford to restart mysql server. since "reload" is one of the mysql options (mysql start|restart|stop|force-reload|relaod), I tried it, but it doesn't apply the changes that I made to my.conf.

thanks

Gary

reload reloads the conf files (configuration files) without stopping the server/program which should be pretty much instantaneous

restart stops the server/program and then starts it again which takes time

CCVOIP

ASKER

thanks for your reply.
if reload reloads the conf files, why it is not working for me. I uncommented two parameter within my.cnf:
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
and saved the changes, then executed /etc/init.d/mysql reload
but "show master status" still returns empty set

Gary

Not everything can be reloaded and log_bin would be one of them - that requires a restart - why would you want to change this while running?

I'll see if I can find a comprehensive list

CCVOIP

ASKER

so the "reload" applies only for a dynamic variables!!
I was asked to set up a replication, and see if there is any way to do it without restarting the mysql server. I wonder if you have any suggestion to achieve that

thanks

Gary

Yes, cannot find a list of what you can change but yes dynamic variables that do not adversely affect the MySQL server.
So things like changing paths for example are not gonna work.

ASKER CERTIFIED SOLUTION

Gary

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CCVOIP

ASKER

thanks for the link. I am going to work on it when there is no heavy access to the production server.