|
|
Maximum size limit for mysql table - Mysql
|
Views : 1188
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
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........
|
|
By - Selva, On - 2009-07-24 |
|
|
|
