如何在不重新启动的情况下刷新MySQL配置文件？ [英] How do you refresh the MySQL configuration file without restarting?

问题描述

有一个存在？

解决方案

你太近了！ 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/

这篇关于如何在不重新启动的情况下刷新MySQL配置文件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！