Space Limit/capacity Of Mysql?

[leiaah 0]

Hey guys I was wondering if MySQL has a space limit. I know that MSAccess has a limit of 2GB and that SQL Server doesn't, only the harddisk capacity. Do you guys know?

[lamode 0]

MySQL Version 3.22 had a 4 GB (4 gigabyte) limit on table size. With the MyISAM table type in MySQL Version 3.23, the maximum table size was pushed up to 8 million terabytes (2 ^ 63 bytes).
Note, however, that operating systems have their own file-size limits. Here are some examples:

Operating System  File-Size Limit 
Linux-Intel 32 bit  2 GB, 4GB or more, depends on Linux version 
Linux-Alpha  8 TB (?) 
Solaris 2.5.1  2 GB (possible 4GB with patch) 
Solaris 2.6  4 GB (can be changed with flag) 
Solaris 2.7 Intel  4 GB 
Solaris 2.7 UltraSPARC  512 GB

i hope this answer your question.

Notice from snlildude87:

Use the quote tags whenever applicable

Edited April 29, 2005 by snlildude87 (see edit history)

[leiaah 0]

Ummm..okay thanks. What is MyISAM?

[snlildude87 0]

Ummm..okay thanks.  What is MyISAM? 

136154[/snapback]

MyISAM is the default storage engine as of MySQL 3.23. It is based on the ISAM code but has many useful extensions.

 

Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. An .frm file stores the table definition. The data file has an .MYD (MYData) extension.

That explains why you get more space with myisam....