Link to home
Create AccountLog in
Avatar of CCVOIP
CCVOIP

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
Avatar of Gary
Gary
Flag of Ireland image

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
Avatar of CCVOIP
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
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
Avatar of 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
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
Avatar of Gary
Gary
Flag of Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of CCVOIP

ASKER

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