Comment 3 for bug 712591

Revision history for this message
Valentine Gostev (longbow) wrote :

Peter,

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.