Maximum size limit for mysql table
by Selva[ Edit ] 2009-07-24 15:54:24
In mysql the maximum size of the table is determined by operating system in which the Mysql is installed.Mysql stores the data of a table in a file and every operating system limits size of a file,so the maxmimum size of a table can upto the maximum file size limit allowed by the operating system.
The following table shows the file size limit of operating systems:
| Operating System | File Size Limt |
| Windows (FAT32) | 4GB |
| Windows (NTFS) | 2TB |
| MacOS | 2TB |
| Linux | 4TB |
| Solaris 9/10 | 16TB |
So in Windows (with NTFS file system) a table in Mysql database can contain upto 4GB of data,in linux a table can contain 4TB of data........
