Renato Losio

Cloud Expert, AWS Data Hero, InfoQ Editor, Speaker, Remote

The best way to optimize IOPS on RDS MySQL

Amazon RDS fully supports the InnoDB storage engine for MySQL DB instances and there are features like snapshot restore that are supported for the InnoDB storage engine only.

show storage engines;


But InnoDB is NOT the best performing storage engine on RDS.

No, I am not talking about MyISAM, I am talking about BLACKHOLE.

Best way to optimize IOPS and have fewer problems with data is not to have the data in the first place.

Don’t store data you do not need to store. You might not even need to change your application to achieve that. Go ahead with that ALTER TABLE.

ALTER TABLE myUselessTable ENGINE=BLACKHOLE;