database - How do you refresh the MySQL configuration file without restarting?

Question

Apache has such a feature, what about MySQL?

Does one exist?

question from:https://stackoverflow.com/questions/917865/how-do-you-refresh-the-mysql-configuration-file-without-restarting

Answer 1

You were so close! The kill -HUP method wasn't working for me either.

You were calling:

select @@global.max_connections;

All you needed was to set instead of select:

set @@global.max_connections = 400;

See:

http://www.netadmintools.com/art573.html

http://www.electrictoolbox.com/update-max-connections-mysql/