且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在不重新启动的情况下刷新MySQL配置文件?

更新时间:2023-12-06 17:11:28

你太近了! kill -HUP 方法也不能为我工作。



您正在呼叫:

 选择@@ global.max_connections; 

只需设置而不是select:

  set @@ global.max_connections = 400; 

请参阅:



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



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


Apache has such a feature, what about MySQL?

Does one exist?

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/