Announcement

Collapse
No announcement yet.

Data Usage, Index Usage etc.

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

  • Data Usage, Index Usage etc.

    I have just a few questions about usage.
    1. Is data usage the size of my db?
    2. What is Index Usage
    3. Is data usage only increased by the number of Threads / Posts

  • #2
    1) Yes.

    2) That is your search index.

    3) Database usage is increased by everything, except attachments / avatars if you have those configured to be stored in the file system.

    Comment


    • #3
      Originally posted by Jake Bunce
      3) Database usage is increased by everything, except attachments / avatars if you have those configured to be stored in the file system.
      Thankyou.

      Is there an advantage to storing attachments / avatars in the file system.

      i.e. will the system run faster? Or is it just a case of preference of storage location.

      Comment


      • #4
        For busy forums it is nice to give the database a break by storing attachments in the file system. It allows for faster MySQL performance.

        Comment


        • #5
          Originally posted by Jake Bunce
          For busy forums it is nice to give the database a break by storing attachments in the file system. It allows for faster MySQL performance.
          Thankyou.

          On a side note. Why is it when I view this thread when not logged-in I can see your avatar. But once I log-in I can't see it?

          Comment


          • #6
            That's a user preference:

            User CP -> Edit Options -> Show Avatars

            Comment


            • #7
              Hmm...

              I don't remember selecting where to store attachments and avatars before.

              How can I tell where they are stored and if they are stored in the dB, how can I pull them out and store them in the file system?

              Thanks!

              Comment


              • #8
                Nm, hehe, found it...

                http://www.vbulletin.com/forum/showt...ht=attachments

                Comment

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