I would be grateful for the advice.
There is an application for processing incoming dumps from a remote source. The application on the fly creates a temporary database for this dump, tables in it (50-60 pieces), inserts data, conducts a series of service operations with them, "nails" the temporary database and proceeds to the next dump.
In the application, performance is extremely critical (runtime), and the drop in this performance was found only at the time of the CREATE instruction, on the server side. On a cycle of creating a structure alone, it takes about 1+ minutes, and the insertion of the data itself takes place in general quickly. Shut up on the creation of the database structure and tables.
I suspect that everything depends on the subtleties of the implementation of InnoDB, but unfortunately I am not an expert in this field. Maybe someone will advise how to speed up this process?
Windows platform x86 / x64, MySQL 5.6, InnoDB engine.
