MySQL Forums
Forum List  »  InnoDB

multiple files per tablespace of a table
Posted by: Ravi Thati
Date: September 10, 2013 07:17AM

Hi,


The below are lines from http://dev.mysql.com/doc/refman/5.7/en/innodb-restrictions.html page.


1. On some older operating systems, files must be less than 2GB. This is not a limitation of InnoDB itself, but if you require a large tablespace, you will need to configure it using several smaller data files rather than one or a file large data files.

2. The minimum tablespace size is 10MB. The maximum tablespace size is four billion database pages (64TB). This is also the maximum size for a table.


The question:
We have innodb_file_per_table enabled (by default as its a latest vesrion)
Now while we create new INNODB tables, INNODB maintains table.ibd file. Let us say our table size is growing.
Can we create multiple files for single table in this scenario?
like how system table space can have multiple files.
If yes, please describe how to do .

--
Thanks,
Ravi Thati

Options: ReplyQuote


Subject
Views
Written By
Posted
multiple files per tablespace of a table
1955
September 10, 2013 07:17AM


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.