CODEWITHSUNDEEP
mysqlamazon-web-servicesrds
user3697289
user3697289

Reputation: 155

RDS Parameter Group

I'm using Amazon RDS , and create parameter group to version MySql5.5. I was wondering whether it is possible to enable innodb_locks_unsafe_for_binlog on an RDS instance somehow? The GUI doesn't seem to allow this.

Thank you!!

Upvotes: 1

Views: 639

Answers (1)

Edelmar Ziegler
Edelmar Ziegler

Reputation: 111

I believe the GUI only shows parameters that can be changed, so no, you cannot change that on RDS.

Also, it seems this parameter is deprecated for current versions of MySQL. According to the official documentation on MySQL site:

http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_locks_unsafe_for_binlog

As of MySQL 5.6.3, innodb_locks_unsafe_for_binlog is deprecated and will be removed in a future MySQL release.

So that would be a likely reason why this parameter cannot be changed.

Cheers,

Upvotes: 1

Related Questions