Using the example from https://dev.mysql.com/doc/refman/5.6/en/storage-engine-setting.html I do the following on my AWS Aurora server:
CREATE TABLE t3 (i INT) ENGINE = MEMORY;
The response I get back is as follows:
0 row(s) affected, 1 warning(s): 1266 Using storage engine InnoDB for table 't3';
Why isn't the MEMORY engine being used? According to SHOW ENGINES; it's supported...
https://dba.stackexchange.com/a/186989/2703 includes this statement which is reported to be from AWS support:
Aurora is designed to provide support for only InnoDB storage engine for regular tables. Engines other than InnoDB are only supported for session-level temporary tables. With default configuration, when you try to create a table using a storage engine other than InnoDB, Aurora will implicitly create the table as InnoDB. Session level temporary tables are not persistent and they will be dropped once the session is completed.