How many tables can a mySQL db hold?

Discussion in 'OT Technology' started by numLocked, May 10, 2005.

  1. numLocked

    numLocked New Member

    Joined:
    Jul 8, 2004
    Messages:
    2,430
    Likes Received:
    0
    Location:
    Charleston, SC
    My host only gives me 1 database, but im running a bunch of sites off of it. I have like 70 tables in the DB right now, which stikes me as a fair number. Is there any compelling reason to buy multiple DBs to keep track of different sites? I'm not concerned with speed or organization or anything, just if it's a problem having a bunch of tables in a single DB. Thanks.
     
  2. P07r0457

    P07r0457 New Member

    Joined:
    Sep 20, 2004
    Messages:
    28,491
    Likes Received:
    0
    Location:
    Southern Oregon
    not really any limit that is actually relevant. It's more in terms of security, and organization.
     
  3. kingtoad

    kingtoad OT Supporter

    Joined:
    Sep 2, 2003
    Messages:
    55,922
    Likes Received:
    11
    Location:
    Los Angeles
    You can have as many tables as you want. There are limits on the tables though, each table is capable of holding 4GB of data.
     
  4. P07r0457

    P07r0457 New Member

    Joined:
    Sep 20, 2004
    Messages:
    28,491
    Likes Received:
    0
    Location:
    Southern Oregon
    I think that's file-system dependent, due to the maximum size of a given file... and MySQL even has a workaround for certain platforms that splits the table into more than 1 file.
     
  5. numLocked

    numLocked New Member

    Joined:
    Jul 8, 2004
    Messages:
    2,430
    Likes Received:
    0
    Location:
    Charleston, SC
    awesome, thanks for the answers guys :bigthumb:
     

Share This Page