dimanche 2 août 2015

How to disable innodb_doublewrite for MySQL at Amazon RDS?

Please can anyone help me to disable "innodb_doublewrite" for my MySQL database hosted at Amazon RDS. I need this as we need to quickly update around 15 Million rows.

I know there is a startup option for this:

--skip-innodb_doublewrite

But how to use it?

Apart from that, Amazon RDS Parameters Group does not show the option of "innodb_doublewrite" for editing. Amazon does not also allow direct editing of my.cnf file.

I can access the MySQL through my Linux Server. But don't know exactly how to use the startup option for Amazon RDS. Please can any one help me to disable this option?




Aucun commentaire:

Enregistrer un commentaire