No announcement yet.

Attachments: mySQL -vs- web space?

  • Filter
  • Time
  • Show
Clear All
new posts

  • [CMS] Attachments: mySQL -vs- web space?

    I know that there are threads similar to what I'm asking, but is it advisable to store attachments in the mySQL database or the file system? Are there performance benefits to one over another?

    I have just started using vBulletin and therefore have a small-sized CMS. One of the things I'm concerned about is backing up and restoring a mySQL database (which I've never done before). If you try restoring a database that's 1GB+ and the upload times out or something, do you have to restart from the beginning or can you just resume? I ask only because I've seen posts on people having databases that are 50GB+.

    Thanks for helping.

  • #2
    Only serve attachments from MySQL if you have a specific reason to - it's less efficient than using the file system.
    Last edited by Darkimmortal; Sat 23rd Jan '10, 6:04pm.
    vB4 SuperCharged


    • #3
      Performance wise filesystem is better once you have >100MB in attachments. If mysql command line restore of database timesout you'd have to start other again with fresh empty database to restore to. You won't be able to resume.
      :: Always Back Up Forum Database + Attachments BEFORE upgrading !
      :: Nginx SPDY SSL - World Flags Demo [video results]
      :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ blog summary ]


      • #4
        Thanks, I've gone ahead and transferred them over to the filesystem.