Announcement

Collapse
No announcement yet.

Table 'post' is marked as crashed and should be repaired

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

  • Table 'post' is marked as crashed and should be repaired

    I am getting these fairly often now. I shutdown the forums and do the repairs and they go away for a few days and back again. I have around 7M posts. Any words as to what I should do?

  • #2
    where are you doing the repairs? vB ACP or in the cPanel?

    Comment


    • #3
      Have you done an optimise as well as a repair?

      REPAIR TABLE post;
      OPTIMIZE TABLE post;
      MARK.B | vBULLETIN SUPPORT

      TalkNewsUK - My vBulletin 5.5.2 Demo
      AdminAmmo - My Cloud Demo

      Comment


      • #4
        I do it from the command line. i do the entire database:
        mysqlcheck -r -p database
        mysqlcheck -o -p database

        Comment


        • #5
          Originally posted by SoloX View Post
          I do it from the command line. i do the entire database:
          mysqlcheck -r -p database
          mysqlcheck -o -p database
          Hmm well that should crack it...

          if it's still happening, do you have any modifications installed? if so try disabling them one by one to see if any of them are causing this.
          MARK.B | vBULLETIN SUPPORT

          TalkNewsUK - My vBulletin 5.5.2 Demo
          AdminAmmo - My Cloud Demo

          Comment


          • #6
            Originally posted by SoloX View Post
            I am getting these fairly often now. I shutdown the forums and do the repairs and they go away for a few days and back again. I have around 7M posts. Any words as to what I should do?
            Try speaking to your host - your should not be getting crashes that often.
            Baby, I was born this way

            Comment


            • #7
              Thanks all for your answers.
              Paul, I am the host. This is a dedicated machine. Its dual quad core CPU, 6GB ram, (3) 146GB SCSI in raid config. The server is fairly capable of handling the load. what I have noticed is that sometimes the load index spikes to like 50 or 60 for 10-15 mins and then it goes back to normal 2-3. Physical free memory stays around 2-3GB but swap is heavily used. If RAM is available, less swap should be used, right?

              I can provide any more stats if someone is willing to look into this strange behavior. I have been running this board for 10+ years and this is the first of this kind of problem.

              Comment

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