Announcement

Collapse
No announcement yet.

What do these mean?

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

  • What do these mean?

    Data Usage
    Index Usage


    ^^^in the admincp?

  • #2
    Go ahead and play with it, feel it, poke @ it

    Comment


    • #3
      Originally posted by LEAD_WEIGHT
      Go ahead and play with it, feel it, poke @ it
      That doesn't really help answer the question of course.

      The data usage is the amount of data stored in the MySQL database that vBulletin uses.

      The index usage is the amount of data the table indexes use in the MySQL database that vBulletin uses.

      Comment


      • #4
        Originally posted by Floris
        That doesn't really help answer the question of course.

        The data usage is the amount of data stored in the MySQL database that vBulletin uses.

        The index usage is the amount of data the table indexes use in the MySQL database that vBulletin uses.
        I deleted a forum with a whole bunch of threads and post but my data and index usage mb didnt go down. Why is that?

        Comment


        • #5
          Possibly the indexes would have to be rebuilt by mySQL...
          Best Regards
          Colin Frei

          Please don't contact me per PM.

          Comment


          • #6
            Originally posted by Colin F
            Possibly the indexes would have to be rebuilt by mySQL...
            how

            Comment


            • #7
              I'm not sure to be honest. What you can do is drop and readd the index.

              On the other hand, why is it a problem?
              Best Regards
              Colin Frei

              Please don't contact me per PM.

              Comment


              • #8
                Originally posted by porkyaaa
                I deleted a forum with a whole bunch of threads and post but my data and index usage mb didnt go down. Why is that?
                Run Repair/Optimize in the Admin CP.

                Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment


                • #9
                  Originally posted by Steve Machol
                  Run Repair/Optimize in the Admin CP.

                  Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue
                  for some reason when I do that. it timesout

                  Comment


                  • #10
                    Then try repairing the tables in phpMyAdmin.
                    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                    Change CKEditor Colors to Match Style (for 4.1.4 and above)

                    Steve Machol Photography


                    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                    Comment


                    • #11
                      Originally posted by Steve Machol
                      Then try repairing the tables in phpMyAdmin.
                      how do you repair it in phpmyadmin?

                      Comment


                      • #12
                        Choose the tables and then select the 'repair' option.
                        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                        Change CKEditor Colors to Match Style (for 4.1.4 and above)

                        Steve Machol Photography


                        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                        Comment


                        • #13
                          which table should I select? all of them? and what does repairing do? does it delete the old post and old threads from the deleted forums? thanks

                          Comment


                          • #14
                            Originally posted by Colin F
                            I'm not sure to be honest. What you can do is drop and readd the index.

                            On the other hand, why is it a problem?
                            I advise against this if you are not familiar with MySQL databases.

                            Comment


                            • #15
                              I have like 2.6 million post and I deleted a forum with a million and I optimized and repaired datbases in phpmyadmin and it still shows 2.6 million for post

                              Comment

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