Comments - Sample my.cnf Files
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.
I use GROUP CONCAT to build lists of links in HTML, such as this one: http://www.ecoreality.org/wiki/Template:Seed_searches
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.
It just uses more ram temporary. In 10.2 the default has become 1M.