Database Size

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • stanmxl
    Senior Member
    • Mar 2003
    • 315

    Database Size

    I'm curious about the database size that some of you have. Could you please list the size of your database along with the number of posts, threads and members you have? I've only administered fairly small boards until now and the biggest database I ever got was only 50 MB.
  • George L
    Former vBulletin Support
    • May 2000
    • 32996
    • 3.8.x

    #2
    around

    854k posts
    54k thread
    110k private messages
    12k attachments at av 36kb size
    7880+ members
    = 1.3GB
    :: 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

    • Kier
      Former Lead Developer, vBulletin
      • Sep 2000
      • 8179

      #3
      1,016,132 posts
      40,644 threads
      9,934 private messages
      4,013 members
      no attachments

      1.4GB

      Comment

      • IDN
        Senior Member
        • Apr 2002
        • 4030
        • 3.5.x

        #4
        What forums do you run?
        Running vB since 4-14-2002

        Comment

        • DWZ
          Senior Member
          • Jan 2002
          • 985
          • 2.2.9

          #5
          6,075 members
          21,391 threads
          253,562 posts
          7,476 PMs
          no attachments
          = 178MB

          Seach index @ 3 letter words minimum
          = 90MB

          Total 261MB

          www.ausforum.com

          Comment

          • Martz
            Senior Member
            • Apr 2001
            • 1051

            #6
            Total: 656.1 MB

            379mb (8000+) attachments
            29k threads
            700k+ posts
            HP DL-380 G6, 2x E5520, 28GB RAM, 4x300GB SAS, VMWare ESXi
            -
            Unreal Tournament : Assault forums - irc://irc.utassault.net:6667 -

            Comment

            • fury
              Senior Member
              • Jun 2001
              • 1464

              #7
              164,950 posts
              5,197 PM's
              926 attachments
              136,962 searchable words
              1,550,111 search index records

              145.7mb (145.4 after an optimize...)

              Off Topic Central

              Comment

              • Overgrow
                Senior Member
                • May 2000
                • 381

                #8
                1.9 million posts (deleted 300k)
                39,000 members (deleted 17k)
                300k PMs
                0 attachments
                0 searchindex
                =
                1680 mb database
                880 mb indices
                15 mb avatars
                vB Retro -> See vBulletin 1.1.2 and travel back to the Year 2000!
                Overgrow the Government: The Edge Forums
                presented by Overgrow Marijuana Magazine


                *warning: adult content since vB1.1... now faster than ever!

                Comment

                • zfrank
                  Member
                  • Feb 2002
                  • 99

                  #9
                  Posts: 321,162
                  Threads: 74,343
                  Members: 25,662
                  Attachment: 1
                  PM: 2,000
                  Database: 445MB

                  Comment

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

                    #10
                    Database Data Usage: 84.46 MB
                    Database Index Usage: 18.54 MB
                    Attachment Usage: 15.31 MB (Deleted 30-MB)
                    Custom Avatar Usage: 0.96 MB
                    Members: 738, Threads: 8,726, Posts: 80,875
                    MCSE, MVP, CCIE
                    Microsoft Beta Team

                    Comment

                    • 0ptima
                      Senior Member
                      • Jan 2002
                      • 1557

                      #11
                      How did you guys purge parts of your attachement table? An sql query by date? Any referential integrity problems?

                      Comment

                      • Wayne Luke
                        vBulletin Technical Support Lead
                        • Aug 2000
                        • 73981

                        #12
                        Originally posted by 0ptima
                        How did you guys purge parts of your attachement table? An sql query by date? Any referential integrity problems?
                        A query by date could do it.

                        Since MySQL, doesn't have referential integrity, there really can't be any problems. The biggest thing that would happen is a post wouldn't show up depending on how the query is run.
                        Translations provided by Google.

                        Wayne Luke
                        The Rabid Badger - a vBulletin Cloud demonstration site.
                        vBulletin 5 API

                        Comment

                        • Vile
                          Senior Member
                          • Jul 2002
                          • 2779
                          • 3.6.x

                          #13
                          Members: 6,870
                          Threads: 9,153
                          Posts: 73,069
                          Custom Avatar Usage: 1.13 MB
                          Attachment Usage: 11.95 MB
                          Total Database Size: 89.76 MB
                          Webmaster / Administrator
                          www.MegaGames.com
                          www.MGForums.com

                          Comment

                          • Floris
                            Senior Member
                            • Dec 2001
                            • 37767

                            #14
                            Members: 487
                            Threads: 1344
                            Posts: 15,327

                            Index: 5,7 MB
                            Attachment: 15 MB
                            C.Avatars: 0,11 MB
                            C.profile Picture: 0,05 MB

                            Database Data: 37 MB

                            Comment

                            • IDN
                              Senior Member
                              • Apr 2002
                              • 4030
                              • 3.5.x

                              #15
                              Overgrow, how ca you still search if your searchindex is 0???
                              Running vB since 4-14-2002

                              Comment

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