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