Database Storage Capacity

[cancer10]

I was wondering what is the Database Storage Capacity for the following databases:

MySQL 5

Microsoft Sql Server 2005

MS Access 2003



Thanx

[russell]

there is no theoretical storage limit in MSSQL 2005. Limited only by the size of the physical disk -- unless you are using Express edition, in which case you are limited to 4GB

http://www.microsoft.com/sql/prodinf...-features.mspx

[cancer10]

And what is the limit for MYSQL?


Any idea?


Thanx

[felgall]

MySQL is limited by the largest file size that the operating system you run it on can handle (between 4Gb and 256Tb depending on the O/S). With the innoDB table format you can even span multiple files with one table allowing for tables in the database of up to 64Tb.

The maximum database size for Access is 2Gb for the entire database.

[cancer10]

MySQL is limited by the largest file size that the operating system you run it on can handle (between 4Gb and 256Tb depending on the O/S). With the innoDB table format you can even span multiple files with one table allowing for tables in the database of up to 64Tb.

Sorry for digging this old thread, but could u plz tell me on which OS does mysql support 256Tb of DB size?


Thanx

[Webnerd]

Rtfm

[cancer10]

I have seached through the so called "Frickin' Manual" but didnt found anything.

[Fang]

http://dev.mysql.com/doc/refman/5.0/en/full-table.html