mysql blobs and limits

Discussion in 'MySQL' started by georgiecasey, Mar 12, 2007.

0
  1. #1
    Hi,

    I run a filebased site and store fileinfo in one mysql tabel and the actual file in a mediumblob another table. Files are each about 250KB. It's currently about 6000 records but it's quickly expanding and will be about 150,000 records soon, the file table will be about 50GB! I can't seem to find much info on limits of mySQL, will my database slow down with this much or even crash.

    Thanks for any info
     
    georgiecasey, Mar 12, 2007 IP
  2. spachev

    spachev Peon

    Messages:
    42
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    If your queries are written well (using keys properly so only a few rows are examined per query), it should slow down only a little bit. You can compress the blobs using the compress() MySQL function if you are not doing it already.
     
    spachev, Mar 12, 2007 IP
  3. georgiecasey

    georgiecasey Member

    Messages:
    56
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #3
    But the table is currently about 2GB, and when I use phpMyadmin to browse to the end of the table, it takes 46 seconds! Is this normal for a large table. I know I'd never really use that query in a working environment.
     
    georgiecasey, Mar 12, 2007 IP
  4. georgiecasey

    georgiecasey Member

    Messages:
    56
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #4
    Cheers for the compress tip, never heard of that
     
    georgiecasey, Mar 12, 2007 IP