SitePoint Sponsor

User Tag List

Results 1 to 9 of 9
  1. #1
    SitePoint Addict Chris Roane's Avatar
    Join Date
    Jul 1999
    Location
    Helena, MT
    Posts
    287
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    How many tables, or how much "stuff" can a MySQL database hold?

    If Site Point used MySQL as their database backend, do you think it would ever fill up completely or fill up enough to slow down the site considerably?

    Just wondering.

    Thanks!

    Chris Roane

  2. #2
    AdSpeed.com Son Nguyen's Avatar
    Join Date
    Aug 2000
    Location
    Silicon Valley
    Posts
    2,241
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    This is a good link:

    http://www.mysql.com/documentation/m...ion=Table_size

    MySQL Version 3.22 has a 4G limit on table size. With the new MyISAM in MySQL Version 3.23 the maximum table size is pushed up to 8 million terabytes (2 ^ 63 bytes).
    You think SPF could get up to that limit?
    - Son Nguyen
    AdSpeed.com - Ad Serving and Ad Management Made Easy

  3. #3
    SitePoint Wizard silver trophy Karl's Avatar
    Join Date
    Jul 1999
    Location
    Derbyshire, UK
    Posts
    4,411
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The MyISAM tables are rather large and they are a much better choice than the old format tables as I beleive I am correct in stating that the MyISAM tables are binary portable now.
    Karl Austin :: Profile :: KDA Web Services Ltd.
    Business Web Hosting :: Managed Dedicated Hosting
    Call 0800 542 9764 today and ask how we can help your business grow.

  4. #4
    SitePoint Wizard TWTCommish's Avatar
    Join Date
    Aug 1999
    Location
    Pittsburgh, PA, USA
    Posts
    3,910
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    SitePoint could hit that at some point - I believe all their HTML is stored inside, as well as all documents. And of course these massive forums. In a year or two, who knows? It may only be text, but it's a lot of text. vBulletin's templates are pretty sizeable themselves.

    It's probably a long way off - there may be tons of text now, but text itself is small, and 4GB is an outrageous amount when you're talking about simple text.

  5. #5
    AdSpeed.com Son Nguyen's Avatar
    Join Date
    Aug 2000
    Location
    Silicon Valley
    Posts
    2,241
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yeah, when seeing the table size could be 8 million terabytes, I couldn't believe my eyes, I though 8 million something, but terabytes Whoo... that's huge!

    Basically the posts are all text, so won't be that bad, I believe the design of vB takes care of scalability
    - Son Nguyen
    AdSpeed.com - Ad Serving and Ad Management Made Easy

  6. #6
    SitePoint Wizard TWTCommish's Avatar
    Join Date
    Aug 1999
    Location
    Pittsburgh, PA, USA
    Posts
    3,910
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I confess: I don't konw what a terrabyte is. I'm assuming it's a bunch of gigabytes.

  7. #7
    AdSpeed.com Son Nguyen's Avatar
    Join Date
    Aug 2000
    Location
    Silicon Valley
    Posts
    2,241
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Exactly, it's a bunch of GB
    1 TB = 1024 GB
    - Son Nguyen
    AdSpeed.com - Ad Serving and Ad Management Made Easy

  8. #8
    SitePoint Wizard TWTCommish's Avatar
    Join Date
    Aug 1999
    Location
    Pittsburgh, PA, USA
    Posts
    3,910
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    That's 8,192 GB! That's, uh, a lot of GB. If it's that many, as opposed to the 4GB, then I don't see SP taking it all up unless SQL allows them to start storing multimedia inside.

  9. #9
    SitePoint Wizard silver trophy Karl's Avatar
    Join Date
    Jul 1999
    Location
    Derbyshire, UK
    Posts
    4,411
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can already store binary files in MySQL. I use it to store word documents for one site.
    Karl Austin :: Profile :: KDA Web Services Ltd.
    Business Web Hosting :: Managed Dedicated Hosting
    Call 0800 542 9764 today and ask how we can help your business grow.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •