multiple databases!!!

[Carissa]

I am running a Tomcat servlet application that collect information from different kind of flat files and stores it under a MySQL database.
Earlier, this application creates a huge InnoDB tablespace datafile that sizes more than 300GB.

This works perfectly, but next release of this product will be able to manage multi-instances, i.e. multiple "log collectors" will gather information from different flat files, and each "log collector" will store its information into a dedicated MySQL database. also, the same tablespace will be used for storing all instance's databases.

is it possible to store multiple databases into THE SAME InnoDB tablespace, as these developers pretend? If so, how concurrent locks are managed when accessing different databases that would share the same tablespace? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Saggie]

If you are using a database called 'sample', you still be able to create another database. And the system database 'mysql' is already present too. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --