I have a DB cluster with AWS RDS MySQL serverless. I changed the parameter group group_concat_max_len to 4096, but when run this query: SHOW VARIABLES LIKE '%group_concat%' it gives me 1024 (which is the default value). How can i change it?
I have a DB cluster with AWS RDS MySQL serverless. I changed the parameter group group_concat_max_len to 4096, but when run this query: SHOW VARIABLES LIKE '%group_concat%' it gives me 1024 (which is the default value). How can i change it?
For Aurora MySQL Serverless cluster, modifications to only few parameters will take effect. For all other configuration parameters, cluster will use default values even when you modify it. 'group_concat_max_len' is not in the list, so even if you make changes to its value, it will not take effect.
From AWS doc: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.how-it-works.html