2019-03-15, 11:40 PM
Hey Guys,
I upgraded from mybb 1.6.11 to the latest version within a month ago. This past week my board has closed twice due to mybb automatically repairing a crashed table. The only resource I could find was a 2009 thread back when Labrocca was active (crazy, right?). He suggested the sessions table was a likely culprit (but again, from 2009) and he suggested changing the table to HEAP/MEMORY instead of MYISAM. Is this still good advice or should I avoid doing this with the current mybb version?
Some background. We jumped hosts and upgraded mybb version because the mybb_posts table would crash almost weekly, causing users to be unable to access the board and make posts, and required host intervention to fix. This time around the board closes automatically as per trying to repair the crashed table, who's name is not mentioned, but nothing seems to be wrong with the actual forum. I am able to view threads, make new posts, etc, so I simply open the forum again manually.
Can someone help me understand how to best address this issue?
What is the best known method for determining which table has crashed and determining the root cause of the issue?
bb url
http://subliminal-talk.com/
Thank you,
Cyanide
I upgraded from mybb 1.6.11 to the latest version within a month ago. This past week my board has closed twice due to mybb automatically repairing a crashed table. The only resource I could find was a 2009 thread back when Labrocca was active (crazy, right?). He suggested the sessions table was a likely culprit (but again, from 2009) and he suggested changing the table to HEAP/MEMORY instead of MYISAM. Is this still good advice or should I avoid doing this with the current mybb version?
Some background. We jumped hosts and upgraded mybb version because the mybb_posts table would crash almost weekly, causing users to be unable to access the board and make posts, and required host intervention to fix. This time around the board closes automatically as per trying to repair the crashed table, who's name is not mentioned, but nothing seems to be wrong with the actual forum. I am able to view threads, make new posts, etc, so I simply open the forum again manually.
Can someone help me understand how to best address this issue?
What is the best known method for determining which table has crashed and determining the root cause of the issue?
bb url
http://subliminal-talk.com/
Thank you,
Cyanide