1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.1 Anyway to check my DB's "health"?

Discussion in 'XenForo Questions and Support' started by Mr. Goodie2Shoes, Nov 10, 2011.

  1. Mr. Goodie2Shoes

    Mr. Goodie2Shoes Well-Known Member

    well thats my question :p

    is there anyway to check my database for any error or "bad" table??
     
  2. Floris

    Floris Guest

    Mr. Goodie2Shoes likes this.
  3. Mike

    Mike XenForo Developer Staff Member

    If you're not getting errors, it's basically fine. :)
     
    Mr. Goodie2Shoes likes this.
  4. Brogan

    Brogan XenForo Moderator Staff Member

    There is a Check DB function in cPanel, but if a table was marked as crashed it would already be reported.

    Damn! Double ninja'ed.
     
    Mr. Goodie2Shoes likes this.
  5. Mr. Goodie2Shoes

    Mr. Goodie2Shoes Well-Known Member

  6. Floris

    Floris Guest

    First for everything hehe.
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    In my defence I was updating the FAQ :D
     
  8. Floris

    Floris Guest

    The trick is *basically*

    Corruption is most of the time not such a big deal. As much as how not defragging your win98 instance wasn't really a big deal either.

    Until the thing blows up.

    It simply could cause bigger issues, which leads to potential data loss when it could have been prevented.

    Run an optimize and repair a few times. And yes, that will report back some tables as up to date, some as unable to check or optimize, and some simply don't support the type of action because they're like a session table, or simply stored in memory for other reasons.
     
  9. Mr. Goodie2Shoes

    Mr. Goodie2Shoes Well-Known Member

    okay I got this:
    all the tables are "OK" but for three of them, I get: The storage engine for the table doesn't support check
    the tables are: attachment_view, session_activity & thread_view
     
  10. Brogan

    Brogan XenForo Moderator Staff Member

    Those are memory tables.
     
  11. Mr. Goodie2Shoes

    Mr. Goodie2Shoes Well-Known Member

    gotcha! ;)
     
  12. Floris

    Floris Guest

    Sounds like it's all sorted, time to move on to the next thing: Posting awesome content on your great xenforo instance. Best of luck.
     
    Mr. Goodie2Shoes likes this.

Share This Page