Having different tablespace for multiple databases
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,
Parvesh
Subject
Views
Written By
Posted
Having different tablespace for multiple databases
3679
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.