AWS RDS Aurora MySql Serverless: ft_min_word_len is not being recognized

Question

Hello,

I have trouble setting the 'ft_min_word_len' parameter to '3' for my RDS Aurora MySql 5.7 Serverless Instance. In den RDS Console everything seems to be fine but querying the parameter with "SHOW VARIABLES LIKE 'ft_min_word_len'" still gives me '4'. 
I know I have to "repair" the table afterwards, but at first the value of 'ft_min_word_len' has to be '3' .

I have also tried to create a complete new parameter group and assigned this one to my instance - without sucess. Other parameters (e.g. character set database) are being correct regognized.
 
Is there a limitation for "ft_min_word_len" on serverless instances? I did not find any informations in the documentation about this.

I can also provide screenshots, if needed.

Thanks,
Sebastian

Answer

Aurora Serverless v1 doesn't support all DB cluster parameters. [document](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.how-it-works.html#aurora-serverless.parameter-groups)

You can find supported parameters using below command.

```
aws rds describe-engine-default-cluster-parameters \
  --db-parameter-group-family aurora-mysql5.7 --query \
  'EngineDefaults.Parameters[*].{ParameterName:ParameterName,SupportedEngineModes:SupportedEngineModes} | [?contains(SupportedEngineModes, `serverless`) == `true`] | [*].{param:ParameterName}' \
  --region us-east-1  --output text

aws_default_lambda_role
character_set_server
collation_server
innodb_file_per_table
lc_time_names
lower_case_table_names
require_secure_transport
server_audit_events
server_audit_excl_users
server_audit_incl_users
server_audit_logging
ssl_cipher
time_zone
tls_version
```

Answer

Hello,

thanks for your help and clarifying this to me !
Actually there seems to be no way to modify this parameter in Aurora Mysql Serverless, only in Aurora Mysql provisioned.

Does anybody know if this will be supported by a future version of Aurora Mysql Serverless? We will prove to switch to Aurora Mysql provisioned- but we would wait if this will become available in a couple of month.

Regards,
Sebastian

AWS RDS Aurora MySql Serverless: ft_min_word_len is not being recognized

Relevanter Inhalt