www.webdeveloper.com
Results 1 to 8 of 8

Thread: Database Storage Capacity

  1. #1
    Join Date
    Sep 2006
    Posts
    643

    Question Database Storage Capacity

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

    MySQL 5

    Microsoft Sql Server 2005

    MS Access 2003



    Thanx

  2. #2
    Join Date
    Feb 2003
    Posts
    2,745
    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

  3. #3
    Join Date
    Sep 2006
    Posts
    643
    And what is the limit for MYSQL?


    Any idea?


    Thanx

  4. #4
    Join Date
    Mar 2005
    Location
    Sydney, Australia
    Posts
    7,974
    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.
    Stephen

  5. #5
    Join Date
    Sep 2006
    Posts
    643
    Quote Originally Posted by felgall View Post
    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

  6. #6
    Join Date
    Jul 2005
    Location
    USA
    Posts
    912
    Rtfm
    Bitter web veteran

  7. #7
    Join Date
    Sep 2006
    Posts
    643
    I have seached through the so called "Frickin' Manual" but didnt found anything.

  8. #8
    Join Date
    Apr 2003
    Location
    Netherlands
    Posts
    21,654
    At least 98% of internet users' DNA is identical to that of chimpanzees

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles