MySQL Forums
Forum List  »  Oracle

Having different tablespace for multiple databases
Posted by: Parvesh Garg
Date: July 07, 2007 04:54AM

Hi Experts,

I have a MySQL with 6 databases and innodb_data_file_path set to ibdata1:256M:autoextend. I saw the size of this file on disk which was ~50GB.

Just wondering if InnoDB will have performance issues with such a large file size. AFAIK, having a very big file in any system should have performance issues with writing, reading, locating data etc.

How about splitting this file per database. I mean having each database create its own .ibd file. I know InnoDB has an option where this data file can be split per table (still maintaining a shared tablespace), but could not find any option to split this file per database.

Can someone please comment?

Thanks in advance,

Options: ReplyQuote

Written By
Having different tablespace for multiple databases
July 07, 2007 04:54AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.