I am reading about the file systems in Linux from here. This particular sentence kind of confuses me.
- Maximum individual file size can be from 16 GB to 2 TB.
- Overall ext3 file system size can be from 2 TB to 32 TB.
So, does the above sentence mean I cannot have a single file that is greater than 2 TB in size?
If that is the case, can't I have a single
mysql table which has greater than 2 TB capacity? The tables are stored as per the
datadir parameter mentioned in
/etc/my.cnf. So assuming, I have a HDD of 4 TB capacity and a
mysql table of size 2.5 TB, can the table be fit into the HDD or not?
I am not concerned with the maximum file size as the answer of Barmar specifies.
I am more concerned on finding out will there be any error thrown if I have a single
mysql table that is greater than the size of the maximum allowable individual file size of ext3 file system.