CODEWITHSUNDEEP
mysqllinuxamazon-web-servicesamazon-rds
VInayK
VInayK

Reputation: 1559

change innodb_log_file_size variable value for Amazon RDS MYSQL Linux server

we are using Amazon RDS linux server for MYSQL. what is the way to change my.cnf file variable values ??

i am trying to change innodb_log_file_size variable. Can you please update me which is the best way to change?

So please help me on this

Upvotes: 2

Views: 4905

Answers (3)

Vishal
Vishal

Reputation: 742

I'm facing similar issue where I need to change the value of global variable in my Amazon Aurora Serverless cluster.

enter image description here

As you can see in the above documentation screenshot the innodb_log_file_size is not a dynamic variable so it won't be available in the DB Parameter Group.

Values of these kind of non dynamic global variables can only be changed by modifying MySQL config files (my.cnf) or by modifying server startup command.

Since you are using Amazon RDS MySQL there users don't have access to config files so no you cannot modify the value of innodb_log_file_size global variable, This functionality is not available in Amazon RDS as of now.

Upvotes: 1

sqlmike
sqlmike

Reputation: 21

You cannot change that value in Aurora, the storage engine is different than rds mysql or standard mysql and optimized internally. No need to worry about changing it.

Upvotes: 2

mbdvg
mbdvg

Reputation: 2714

Create a new DB paramater group with your required values and attach to your RDS.

Upvotes: 2

Related Questions