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