Maximum size limit for mysql table

by Selva 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
MacOS2TB
Linux4TB
Solaris 9/1016TB



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........

Tagged in:

2508
like
0
dislike
0
mail
flag

You must LOGIN to add comments