How big is your sql forums db?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • 94civicEX
    Member
    • May 2001
    • 48

    How big is your sql forums db?

    Just out of curiousity?
  • Shining Arcanine
    Senior Member
    • Feb 2003
    • 2482
    • 3.0.3

    #2
    It is about 137MB and my forums have close to 150,000 posts.

    Comment

    • digitalpoint
      Senior Member
      • Mar 2004
      • 2573
      • 4.1.x

      #3
      Data Usage: 525.81 MB
      Index Usage: 208.33 MB
      Attachment Usage: 69.71 MB
      Avatar Usage: 8.04 MB
      Profile Picture Usage: 3.41 MB

      That's for:
      Threads: 64,520, Posts: 724,749, Members: 20,993

      (fulltext searches/indexes are on)
      Sphinx Search for vBulletin 4: https://marketplace.digitalpoint.com...tin-4.870/item
      Someone send me a message on Twitter when this site is usable again. https://twitter.com/digitalpoint

      Comment

      • infexious
        Senior Member
        • Aug 2005
        • 463
        • 3.0.8

        #4
        my attachment storage comes close to a gigabyte, yet my database is about 30mb

        Comment

        • harmor
          Senior Member
          • Aug 2003
          • 1334

          #5
          Data Usage 4.86 MB
          Index Usage 945.0 KB
          Attachment Usage 0
          Avatar Usage 25.3 KB
          Profile Picture Usage 4.2 KB

          Threads: 88, Posts: 224, Members: 29

          Comment

          • Raz Meister
            Senior Member
            • Jun 2001
            • 1148

            #6
            Currently 3.2GB
            Raz - KMC Forums

            Comment

            • ZeryabPhone
              Member
              • Jun 2005
              • 95
              • 3.5.x

              #7
              Data Usage : 202.86 MB
              Index Usage : 79.67 MB
              Attachment Usage : 30.25 GB
              Avatar Usage : 911.0 KB
              Profile Picture Usage : 714.5 KB
              -------
              Threads: 8,753, Posts: 59,534, Members: 3,818

              and last week i delete about 16.200+ members registetred only to view the attachments and they make my server load very high for nothing.

              Comment

              • Vtec44
                Senior Member
                • Jan 2005
                • 1555
                • 3.7.x

                #8
                about 100mb, 135k posts, 1600 members
                So Cal Sportbike forum - So Cal Moto - Kawasaki Ninja 250R Forum - Custom vinyl decals - Southern California camping forum

                Comment

                • Joe Gronlund
                  Senior Member
                  • Nov 2001
                  • 5789
                  • 3.8.x

                  #9
                  Originally posted by ZeryabPhone
                  Data Usage : 202.86 MB
                  Index Usage : 79.67 MB
                  Attachment Usage : 30.25 GB
                  Avatar Usage : 911.0 KB
                  Profile Picture Usage : 714.5 KB
                  -------
                  Threads: 8,753, Posts: 59,534, Members: 3,818
                  Gotta enough attachments there?
                  MCSE, MVP, CCIE
                  Microsoft Beta Team

                  Comment

                  • Reeve of Shinra
                    Senior Member
                    • Sep 2001
                    • 4325
                    • 4.0.0

                    #10
                    A little over 2 gigs.
                    Plan, Do, Check, Act!

                    Comment

                    • Rolla
                      Senior Member
                      • Jan 2005
                      • 145
                      • 3.6.x

                      #11
                      50 megs for 75K posts

                      Comment

                      • 94civicEX
                        Member
                        • May 2001
                        • 48

                        #12
                        Originally posted by ZeryabPhone
                        Data Usage : 202.86 MB
                        Index Usage : 79.67 MB
                        Attachment Usage : 30.25 GB
                        Avatar Usage : 911.0 KB
                        Profile Picture Usage : 714.5 KB
                        -------
                        Threads: 8,753, Posts: 59,534, Members: 3,818

                        and last week i delete about 16.200+ members registetred only to view the attachments and they make my server load very high for nothing.
                        Where are you getting this summary?

                        Comment

                        • Vtec44
                          Senior Member
                          • Jan 2005
                          • 1555
                          • 3.7.x

                          #13
                          Originally posted by 94civicEX
                          Where are you getting this summary?
                          It's in your Admin CP welcome page.
                          So Cal Sportbike forum - So Cal Moto - Kawasaki Ninja 250R Forum - Custom vinyl decals - Southern California camping forum

                          Comment

                          • ZeryabPhone
                            Member
                            • Jun 2005
                            • 95
                            • 3.5.x

                            #14
                            Originally posted by Joe Gronlund
                            Gotta enough attachments there?
                            yep , and here is the attachments Statistics

                            Total Attachments : 20,824
                            Disk Space Used : 30.27 GB
                            Average Attachment Filesize : 1.49 MB
                            Total Downloads : 849,033

                            its sharing forum

                            Comment

                            • 94civicEX
                              Member
                              • May 2001
                              • 48

                              #15
                              Originally posted by Vtec44
                              It's in your Admin CP welcome page.
                              That's odd, cause I don't see it, haha.

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...