How to change parameter partial_revokes

0

I'm running a MySQL 8.0 instance and wonder if it is possible to modify the system parameter partial_revokes, introduced in version 8.0.16: https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_partial_revokes . I have tried to create a new option parameters group but the option partial_revokes does not show up at all when searching for it.

When executing statement SHOW VARIABLES, the option partial_revokes is however shown in the results list.

So, anyone knows if this option is possible to modify?

Best regards,
Max

Max-Max
질문됨 2년 전464회 조회
1개 답변
0
수락된 답변

Hi Max-Max

If you are unable to locate the parameter within the parameter group, that means that parameter is currently not modifiable/supported within RDS.
Not all parameters available in MySQL 8.0 are modifiable for RDS MySQL.To determine the supported parameters for your DB engine, you can view the parameters in the DB parameter group used by the DB instance. For more information, see [1].

You can easily use the CLI command below to view the parameters for the parameter group, use grep to filter for the parameter you’re looking for:

aws rds describe-db-parameters --db-parameter-group-name default.mysql8.0 | grep partial_revokes

To learn more about the CLI and grep commands see [2] & [3]

Executing the statement SHOW VARIABLES would indeed show partial_revokes in the results list, however RDS being a managed service, there is limited access to OS level changes and SUPER privileges are restricted. Running the "SET PERSIST partial_revokes = ON;" on the database itself would give an access denied error.

I hope this helps

References:

[1] Viewing parameter values for a DB parameter group
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html#USER_WorkingWithParamGroups.Viewing

[2]CLI command
https://docs.aws.amazon.com/cli/latest/reference/rds/

[3] How to use grep
https://www.ibm.com/docs/zh/aix/7.1?topic=g-grep-command

답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠