It looks more like hack for me.
Proper solution is to support TABLESPACE option in CREATE TABLE like in NDB.
i.e: CREATE TABLE t1 ( -> c1 INT STORAGE DISK, -> c2 INT STORAGE MEMORY -> ) TABLESPACE 'system'
or TABLESPACE 'local'
'system' is to put file in ibdata1, 'local' to use separate file.
It looks more like hack for me.
Proper solution is
to support TABLESPACE option in CREATE TABLE like in NDB.
i.e:
CREATE TABLE t1 (
-> c1 INT STORAGE DISK,
-> c2 INT STORAGE MEMORY
-> ) TABLESPACE 'system'
or TABLESPACE 'local'
'system' is to put file in ibdata1,
'local' to use separate file.