1
javier
CBB Corrupted mysql messages problem
  • 2006/1/23 18:40

  • javier

  • Not too shy to talk

  • Posts: 184

  • Since: 2002/8/6 1


Hi,
i have a big problem with the bb_post and bb_post_text tables of my CBB forum.


I have 58906 entrys in bb_post
and 59171 entrys in bb_post_text

that mean i have 265 corrupted entrys (missing in bb_post)

Reciently my host suspended my site dued to intensive MySQL querys in sleep mode, (see here https://xoops.org/modules/newbb/viewtopic.php?topic_id=46176&forum=7&post_id=202825#forumpost202825 )


Can be ALL these CBB corrupted data the guilty of the server load?

Sometimes happend exactly the contrary way, ex: i make a searh in the forum and i see post titles with missing post text data, when you click in one, give you a MySQL error and return to the forum index.

That can be the guilty (in few words CAN produce sleep process? )
of the sleep MySQL processes or simply come the day i need a dedicated server?


what i can do?
exist any way to detect what entrys are corrupted and delete?
if that is not the guilty of the sleep process i prefer no touch that,


thanks in advance.
best regards

javier

Login

Who's Online

356 user(s) are online (324 user(s) are browsing Support Forums)


Members: 0


Guests: 356


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits