By using AWS re:Post, you agree to the Terms of Use
/AWS RDS Aurora MySql Serverless: ft_min_word_len is not being recognized/

AWS RDS Aurora MySql Serverless: ft_min_word_len is not being recognized

0

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

2 Answers
1

Aurora Serverless v1 doesn't support all DB cluster parameters. document

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
answered 2 months ago
0

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

answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions