Comments - Sample my.cnf Files

7 years, 4 months ago Jan Steinman

I use GROUP CONCAT to build lists of links in HTML, such as this one:

With all the crufty HTML that must be included, that means GROUP CONCAT results are close to 16k in the example above, when the default maximum is 1k.

This can be very puzzling, as the 1k will often happen in the middle of quoted or anchored text, which then plays havoc with the rest of the page.

So I include this in my.cnf:

group_concat_max_len = 64k

which makes it unlikely to break.

If you think this is a bad idea, please let me know! So far, there's no consequences I can see.

5 years, 11 months ago Daniel Black

It just uses more ram temporary. In 10.2 the default has become 1M.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.