Hi,
My sessions table crashed 3rd time in this month. Can anyone please help me?
BTW I tried this
ALTER TABLE `mybb_sessions` ENGINE = memory
It returns an error
#1114 - The table '#sql-xxx_xxxx is full
TY.
Yes I am using that method to fix it. But its only a temporary way.
There must be a way to stop the table from crashing altogether.
REPAIR TABLE `mybb_sessions`;
Yep, I've done that.....
But like I said, there must be some other way.
The only way i've heard about preventing it is to change it to the engine:memory. Seeing as you've already tried that I can't help you sorry. I take it the repair query fixed your forum then?
Yep but I have to do it almost every week. And if I am away the forum remains down....
If it keeps happening, you should ask why. It shouldn't happen on a regular basis.
I've noticed one thing, when too many users are online, the table crashes.
In Task Manager > Tables Check
If I change the task to run after every 5 min, will that help?
It'll give you a much better idea of what's causing it, as it'll check every table every five minutes.