Question about MySQL database 'MAX' size..

Discussion in 'MySQL' started by wnetwork, Mar 3, 2010.

0
  1. #1
    I heard that the MAX size for mysql database is the MAX size of the disk space.
    So If a customer has 10 GB disk space then the max size for database is 10GB or whatever available minus disk space sizes (files)?
    Is it 10 GB per database or all databases?

    db1 = 10 GB
    db2 = 10 GB
    OR .....
    db1+db2= 10 GB?


    There are so many answers (one say this, other say this... so on) out on the net that I can't seem to know which one is correct.
    Can someone clear it up for me?
     
    wnetwork, Mar 3, 2010 IP
  2. hireme

    hireme Member

    Messages:
    58
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    45
    #2
    I believe it's db1+db2+...+dbn = available disk space
     
    hireme, Mar 3, 2010 IP
  3. jakkevin4v

    jakkevin4v Peon

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    max size unlimited.
     
    jakkevin4v, Mar 18, 2010 IP
  4. dropcatchsell

    dropcatchsell Active Member

    Messages:
    431
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    60
    #4
    The maximum size values for MySQL are related to the max size for any single insert. Unless you're dumping binaries directly into the database (usually JPEGs or PDFs) there's no reason to ever care about the setting.

    The actual total maximum size for all your DBs is determined by what's left on your hard drive. Even then, MySQL is far from ideal once you start going into the GB range.
     
    dropcatchsell, Mar 19, 2010 IP