How big is your database?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • psx-dude
    Senior Member
    • Oct 2000
    • 201
    • 3.0.0 Release Candidate 4

    How big is your database?

    I'm wondering how big everyone else's database are, just to get an insight into what to expect if my vb ever becomes popular, just post like i did.. The best way to get the db size is to use phpmyadmin and just view the table, it says the size at the bottom.


    Board info:
    -Registered Members: 278
    -Total Threads: 1,899
    -Total Posts: 46,330

    dB Size: 288.5mb

    What can I say, I have people who post tons of attachments... like this guy.
    My board: http://forums.psx-dude.net
    Others: Find it Damn't!, Anime Site.
  • IDN
    Senior Member
    • Apr 2002
    • 4030
    • 3.5.x

    #2
    like 1.5 megs
    Running vB since 4-14-2002

    Comment

    • George L
      Former vBulletin Support
      • May 2000
      • 32996
      • 3.8.x

      #3
      Board info:
      -Registered Members: 6,197
      -Total Threads: 41,726
      -Total Posts: 698,405
      -Total PMs: 76,768
      -Total Attachments: 8,671
      -Total Forums: 162

      dB Size: 1011mb
      :: 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 [ vbulletin.com blog summary ]

      Comment

      • Jake Bunce
        Senior Member
        • Dec 2000
        • 46598
        • 3.6.x

        #4
        Re: How big is your database?

        umm... 125MB or something

        Comment

        • Mr. X
          Senior Member
          • May 2001
          • 1112
          • 2.3.0

          #5
          Around 22mb
          website: joe.pcfx.cc
          forums: pcfx.cc
          gallery: here

          Comment

          • werehere
            Senior Member
            • Apr 2000
            • 1827

            #6
            Over a GIG, without any attachments allowed, and not very many PM's.
            We're Here Forums!
            [email protected]

            Comment

            • rylin
              Senior Member
              • Jan 2001
              • 1067

              #7
              48791 Members
              152045 Threads
              1567463 Posts

              root@forums:/var/lib/mysql/vbulletin# du -ch
              1.8G .
              1.8G total
              root@forums:/var/lib/mysql/vbulletin#
              bzipped mysqldumps are around 600mb atm
              My open eyes see everything, and you see nothing. . .
              That forum

              Comment

              • The Realist
                Senior Member
                • Jul 2001
                • 653
                • 4.0.x

                #8
                Board info:

                Registered Members: 1,692
                Total Threads: 12,128
                Total Posts: 47,251
                Total PMs: 543
                Total Attachments: 8,671
                Total Forums: 193
                searchindex: 3,239,301
                DB Size: 279.6 MB

                [root@site mysql]# du -ch
                281M ./skytronic-forums_com
                281M total
                [root@site mysql]#

                Last edited by The Realist; Mon 10 Jun '02, 2:54am.

                Comment

                • Cloughie
                  Senior Member
                  • Feb 2001
                  • 478

                  #9
                  bout 225,000 posts, 2300 members, 15,000 posts = 400mb
                  www.wannabebig.com
                  www.wannabebigforums.com
                  www.atlargenutrition.com

                  Comment

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

                    #10
                    55MB
                    MCSE, MVP, CCIE
                    Microsoft Beta Team

                    Comment

                    • DirectPixel
                      Senior Member
                      • Jan 2002
                      • 4703
                      • 3.5.x

                      #11
                      How can you tell how big your DB is?
                      :)

                      Comment

                      • rockergrrl
                        Senior Member
                        • Jul 2000
                        • 1115

                        #12
                        Members: 14
                        Threads: 364
                        Posts: 1,941

                        A month ago, we lost about 800 posts due to hard drive failure (and my failure to remember to backup my DB... lol)

                        7mb... lol

                        You can tell how big your database is by using phpmyadmin -- the latest version. It adds up all the tables, and gives the total.

                        Comment

                        • George L
                          Former vBulletin Support
                          • May 2000
                          • 32996
                          • 3.8.x

                          #13
                          Originally posted by eiSecure
                          How can you tell how big your DB is?
                          using latest version of phpmyadmin to view your databases
                          :: 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 [ vbulletin.com blog summary ]

                          Comment

                          • Hotte
                            Member
                            • Apr 2000
                            • 93
                            • 3.0.0 Release Candidate 2

                            #14
                            Members: 12169
                            Threads: 56572
                            Posts: 948213
                            Size: 672 MB

                            Comment

                            • DirectPixel
                              Senior Member
                              • Jan 2002
                              • 4703
                              • 3.5.x

                              #15
                              Oh, okay.

                              This is gonna sound pathetic, but...

                              Posts: 189.5 KB
                              Attachments: 2.1 MB
                              Total: 3.8 MB
                              Members: 38
                              Threads: 74
                              Posts: 639

                              :)

                              Comment

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