Reloading MySQL my.cnf changes

Do you have to restart MySQL to edit changes? Or can you edit them on the fly and restart MySQL or make the changes inside MySQL?

This server runs 100s of website that are active and I don't really want to bring mysql down for a restart unless I have to.

If you want to change some of the global configuration setting of MySQL There are two ways.

1. By Changing variable using SET GLOBAL option on running MySQL instance,this does not require server restart we can change variables like Ex : I need to set my key buffer to 128 MB

SET GLOBAL key_buffer_size = 12810241024;

But using this technique we can not change or configure all variables and once we restart MySQL these GLOBAL settings are lost.

1. By Changing variables in config file (my.cnf)

This requires a server restart but changes are permanent.

StackExchange Database Administrators Q#42122, answer score: 16