Skip to main content
added 576 characters in body
Source Link
Kyle Brandt
  • 85.9k
  • 77
  • 318
  • 463

TheMySQL Specificly:
The options in my.cnf are system variables. These variables are either dynamic (can be changed at runtime) or not dynamic. The ones that are dynamic, can be changed at run time with the SET variable syntax. You can see the variables with SHOW VARIABLES;. But according to this link in the manual, the binary log option is not dynamic. So it looks like you have to restart

You. You might want to wait for someone who knows mysql a little better than myself to confirm this however.

Daemons in General:
In Linux, /etc/init.d/ holds scripts that start and stop daemons (services). Since these are scripts, you can view them with a text editor. Many of these scripts will take a reload argument. Looking at my mysql script, reload as an argument uses the mysqladmin command. So the manual for mysqladmin under reload says:

reload

Reload the grant tables. 

So looks like in general, this isn't for configuration changes, but rather changes in privileges (Maybe the equivalent flush privileges command? ).

The options in my.cnf are system variables. These variables are either dynamic (can be changed at runtime) or not dynamic. The ones that are dynamic, can be changed at run time with the SET variable syntax. You can see the variables with SHOW VARIABLES;. But according to this link in the manual, the binary log option is not dynamic. So it looks like you have to restart

You might want to wait for someone who knows mysql a little better than myself to confirm this however.

MySQL Specificly:
The options in my.cnf are system variables. These variables are either dynamic (can be changed at runtime) or not dynamic. The ones that are dynamic, can be changed at run time with the SET variable syntax. You can see the variables with SHOW VARIABLES;. But according to this link in the manual, the binary log option is not dynamic. So it looks like you have to restart. You might want to wait for someone who knows mysql a little better than myself to confirm this however.

Daemons in General:
In Linux, /etc/init.d/ holds scripts that start and stop daemons (services). Since these are scripts, you can view them with a text editor. Many of these scripts will take a reload argument. Looking at my mysql script, reload as an argument uses the mysqladmin command. So the manual for mysqladmin under reload says:

reload

Reload the grant tables. 

So looks like in general, this isn't for configuration changes, but rather changes in privileges (Maybe the equivalent flush privileges command? ).

added 475 characters in body; added 18 characters in body
Source Link
Kyle Brandt
  • 85.9k
  • 77
  • 318
  • 463

I think you want:

sudo /etc/init.d/mysql reload 

Instead of restartThe options in my. But I amcnf are system variables. These variables are either dynamic (can be changed at runtime) or not sure ifdynamic. The ones that only reloads privileges andare dynamic, can be changed at run time with the SET variable syntax. You can see the variables with SHOW VARIABLES;. But according to this link in the manual, the binary log option is not configuration parametersdynamic. So it looks like you have to restart

You might want to wait for someone who knows mysql a little better than myself to confirm this however.

I think you want:

sudo /etc/init.d/mysql reload 

Instead of restart. But I am not sure if that only reloads privileges and not configuration parameters.

The options in my.cnf are system variables. These variables are either dynamic (can be changed at runtime) or not dynamic. The ones that are dynamic, can be changed at run time with the SET variable syntax. You can see the variables with SHOW VARIABLES;. But according to this link in the manual, the binary log option is not dynamic. So it looks like you have to restart

You might want to wait for someone who knows mysql a little better than myself to confirm this however.

Source Link
Kyle Brandt
  • 85.9k
  • 77
  • 318
  • 463

I think you want:

sudo /etc/init.d/mysql reload 

Instead of restart. But I am not sure if that only reloads privileges and not configuration parameters.