What is the maximum value for group_concat_max_len?

Help
1

We are running 7.1.4 on 64-bit linux. What is the maximum value we can set for group_concat_max_len? Doesn’t seem to be listed in the doc anywhere I can see.

Thanks,
Marty

2

Hi Marty,

The maximum value is max_allowed_packet (the biggest single result we are allowed to send back to the client). By default, that is 100 MB.

-Adam