How many tables mysql database can have?

Discussion in 'MySQL' started by mohamed79, Apr 6, 2009.

0
  1. #1
    How many tables mysql database can have?
     
    mohamed79, Apr 6, 2009 IP
  2. emed

    emed Peon

    Messages:
    70
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #2
    emed, Apr 7, 2009 IP
  3. donny meddly

    donny meddly Peon

    Messages:
    63
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    well unlimited, depends on the space of the mysql database. some hosts restrict them, some not. tables arent a problem, its when they get filled, thats what takes up most space.
     
    donny meddly, Apr 7, 2009 IP
  4. MayurGondaliya

    MayurGondaliya Well-Known Member

    Messages:
    1,233
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    170
    #4
    Theoretically, there is no limit. But practically, it depends upon your OS and Hardware. MySQL performance may degrade when you reach to a few gigs of data.
     
    MayurGondaliya, Apr 7, 2009 IP
  5. mohamed79

    mohamed79 Peon

    Messages:
    66
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    thanks so much
     
    mohamed79, Apr 7, 2009 IP
  6. suprabhat

    suprabhat Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    depend on the mysql version u are using
     
    suprabhat, Apr 10, 2009 IP
  7. T.Guru

    T.Guru Peon

    Messages:
    78
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #7
    It depends on a few things, but I dont think there are limits to the number of Mysql tables.
     
    T.Guru, Apr 16, 2009 IP