Results 1 to 14 of 14
  1. #1
    Join Date
    Mar 2007
    Posts
    77

    Unanswered: maximum limit of a mySQL database?

    Hi to all,

    If I am going to deploy my program which uses mySQL as its database server, I would like to ask if what is the maximum limit of a mySQL database? is it over 1 TB? or lower? I know that I can search this query on google, but I'd rather take the info from the experts here.

    Thanks and god bless!

  2. #2
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    For MyISAM 256TB as of MySQL 5.0.6 however this can be increased.
    For InnoDB the max tablespace is 64TB.
    Bear in mind it also depends on what OS you have as individual files are limited :
    Win32 w/NTFS : 2TB (possibly larger)
    Linux 2.4+ : (using ext3 filesystem) 4TB

    so really you'll be looking at splitting tables up into sizeable chunks in reality...

  3. #3
    Join Date
    Mar 2007
    Posts
    77
    If in Windows XP, you mean that I can only have a 2 TB size of a mySQL database?

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10

  5. #5
    Join Date
    Mar 2007
    Posts
    77
    they are referring here about mySQL tables, which its limit size is 4 GB. Is it the same of what I meant about the 'database' size? To be specific, I am asking about the whole size of a single database in mySQL, not just the 'table' size.

  6. #6
    Join Date
    Mar 2007
    Posts
    77
    by the way georgedev, the link you have given is not working.

    Thanks anyways

  7. #7
    Join Date
    Mar 2004
    Posts
    480
    the link works for me.

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    george, i really must know -- what was your purpose in linking to (a mirror of) the ancient 3.23 mysql manual???

    that's like someone asking for help with windows and you point them to the windows 3.1 manual

    why?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  9. #9
    Join Date
    Mar 2007
    Posts
    77
    sorry about that george, it does work

  10. #10
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Lol alright Rudy, but if you read the first few lines you get a lovely answer of
    Quote Originally Posted by that site
    MySQL Version 3.22 has a 4G limit on table size. With the new MyISAM in MySQL Version 3.23 the maximum table size is pushed up to 8 million terabytes (2 ^ 63 bytes).
    Which was reasonably applicable imo
    George
    Home | Blog

  11. #11
    Join Date
    Mar 2004
    Posts
    480
    Unless of course that information had changed and was not applicable in the current versions.

  12. #12
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Has it changed?
    George
    Home | Blog

  13. #13
    Join Date
    Mar 2004
    Posts
    480
    not sure, all i'm saying is you are pointing to something over three years old and there have been a lot of other changes in mysql over that time.

  14. #14
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Will the constaints have been decreased with new versions - I doubt it.
    But I guess you're right. I only did I quick look in my links, never noticed the version etc (doesn't help that I don't have practical knowledge of mySQL, only theoretical )
    George
    Home | Blog

Posting Permissions

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