MySQL records limits

Discussion in 'Site & Server Administration' started by fifo, Apr 18, 2010.

0
  1. #1
    Does anyone know what is the limit of records in a MySQL table?
     
    fifo, Apr 18, 2010 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    Your limit is really just going to be hardware (probably disk space) more than anything. MySQL can handle many, many billions of records in a single table without any problems.
     
    digitalpoint, Apr 19, 2010 IP
  3. fifo

    fifo Peon

    Messages:
    31
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Aha ... thanks... so i have to find good server
     
    fifo, Apr 19, 2010 IP
  4. cDc

    cDc Peon

    Messages:
    127
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Obviously think about your data types too - billions of rows in a table with two int columns is not too huge - but billions of rows with longtext/varchar fields are going to cause a bigger problem.....
     
    cDc, Apr 20, 2010 IP
  5. nezZario

    nezZario Peon

    Messages:
    45
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    There is no hard limit. Some OS's/filesystems have a 4-8gb limit on filesizes. So that will be one limit. Other than that, it will be how big your disk is, etc.
    Keep in mind, it doesn't matter how long a query take, if you're worried about SIZE .. only the size of your disk (harddrive) + the OS/filesystem is going to affect your SIZE of the database.

    You might want to have a look at innoDB instead of myISAM
     
    nezZario, Apr 27, 2010 IP