I may suggest another workaround:
If user needs to have some tables in their own table spaces (innodb_file_per_table) and the same time it is faster to create/drop transient tables while they are in system table space, the necessary tables are created during innodb_file_per_table is enabled, then server is restarted with innodb_file_per_table disabled:
tables created during innodb_file_per_table enabled remain in their own table spaces when we disable option, newly created tables are stored in system one.
The only limitation I see now: that if we want to create a table in separate ibd files we will have to restart the server.
Peter,
I may suggest another workaround: file_per_ table) and the same time it is faster to create/drop transient tables while they are in system table space, the necessary tables are created during innodb_ file_per_ table is enabled, then server is restarted with innodb_ file_per_ table disabled:
If user needs to have some tables in their own table spaces (innodb_
tables created during innodb_ file_per_ table enabled remain in their own table spaces when we disable option, newly created tables are stored in system one.
The only limitation I see now: that if we want to create a table in separate ibd files we will have to restart the server.