Originally posted by prabhu rangan:
Hi Paul,
Thank you very much for sharing your ideas.
Will this be a permanent solution. Because while i tried using 'set global group_concat_max_len=1M' through command line, it is changed but once i restart mysql and check the size using 'SHOW VARIABLES LIKE 'group%'; it again shows the default value as '1024'.
Thats why im asking paul. Hope you would be clear. So i manually added these lines in my "/etc/my.cnf" file:
# Set max allowed packet size to 2 MB
max_allowed_packet=2M
# Set group concat max length to 1 MB
group_concat_max_len=1M
Regards,
Prabhu.
I believe the set command is only effective until you restart your database... my.cnf controls it when you restart.
Keep in mind when setting the value higher that the effective maximum length of the return value will be constrained by the value of the max_allowed_packet variable.