Announcement

Collapse
No announcement yet.

Database Size

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

  • #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


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

      1.4GB

      Comment


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

        Comment


        • #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


          • #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


            • #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


              • #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


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

                  Comment


                  • #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


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

                      Comment


                      • #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 customization and demonstration site.
                        vBulletin 5 Documentation - Updated every Friday. Report issues here.
                        vBulletin 5 API - Full / Mobile
                        I am not currently available for vB Messenger Chats.

                        Comment


                        • #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


                          • #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


                            • #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...
                              X