MySQL:增加GROUP_CONCAT_MAX_LEN参数-有危险吗? [英] MySQL: Increasing GROUP_CONCAT_MAX_LEN param - any dangers?

问题描述

现在，我的MySQL服务器正在使用GROUP_CONCAT_MAX_LEN的默认值1024字节，我需要增加它.

Right now, my MySQL server is using the default value of 1024 bytes for the GROUP_CONCAT_MAX_LEN, and I need to increase it.

我知道它受到MAX_ALLOWED_PACKET参数约束的事实，该参数目前足够大.

I am aware of the fact it is constrained by the MAX_ALLOWED_PACKET param, which is currently very sufficient in size.

增加GROUP_CONCAT_MAX_LEN是否会产生任何影响? 有什么后果或危险我应该意识到吗?

Will incraesing the GROUP_CONCAT_MAX_LEN affect anything? Does it have any consequences or dangers I should be aware of?

谢谢.

推荐答案

除了增加MySQL服务器中的处理时间和增加流量(甚至是本地流量)之外，没有.如果确实要增加它，请在更改之前和之后进行基准测试.这样一来，您可以更加科学地进行修改.

Aside from increasing processing time in the MySQL server, and increasing traffic (even locally), no. If you do increase it though, benchmark before and after the change. This way you can be a bit more scientific about your modifications.

我不是100％正确，但是请看一下:

I'm not 100% correct, but take a look at this:

http://dev. mysql.com/doc/refman/5.5/en/group-by-functions.html#function_group-concat

这篇关于MySQL:增加GROUP_CONCAT_MAX_LEN参数-有危险吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！