Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved [Performance] Crashed Table
#1
Not Solved
This user has been denied support. This user has been denied support.
I restarted my Vps.
Now, the mybb_sessions table is crashed.

I have repaired it, and now the forum works, but i never saw similar problem in my site.

Is there any way to analyze the db for possible problems?

+Can i clean all the data from the mybb_sessions table?
I'm a proud MyBB user. Toungue
#2
Not Solved
If you clear out the sessions table it'll just log everybody out.
MyReactions - All Plugins

Can you still feel the butterflies?

Free never tasted like pudding.
#3
Not Solved
Tables crash all the time, it's just the thing of having a large forum.
If you empty the mybb_sessions table, all sessions will be stopped.
No PM support
My YouTube
#4
Not Solved
This user has been denied support. This user has been denied support.
Thank you!

Now i see, the posts table contains more records than what the forum statistics shows.
(I recounted the statistics in mybb's admin cp too)

How to analyze this problem?
I'm a proud MyBB user. Toungue
#5
Not Solved
You mean the pid is higher or there's more actual rows??
MyReactions - All Plugins

Can you still feel the butterflies?

Free never tasted like pudding.
#6
Not Solved
This user has been denied support. This user has been denied support.
More rows.
I'm a proud MyBB user. Toungue
#7
Not Solved
In ./inc/functions_rebuild.php, line 27:

$query = $db->simple_select("forums", "SUM(posts) AS numposts");

Try changing that to:

$query = $db->simple_select("posts", "COUNT(*) AS numposts");

Does it work then?? Don't know why it counts the number from the forums table by default as if that's out of sync, the stats will be out of sync too... maybe instead of the code edit, run the Rebuild Forum Counters one first.
MyReactions - All Plugins

Can you still feel the butterflies?

Free never tasted like pudding.
#8
Not Solved
This user has been denied support. This user has been denied support.
While i optimized the posts table, my webmaster rebooted the server.
Is that can be the source of the problem?

I have rebuilded the forum counters. Nothing happened.

Now i editing the functions_rebuild.php...
I'm a proud MyBB user. Toungue
#9
Not Solved
You can try to set your SESSIONS table to innodb. It will increase stability.
#10
Not Solved
This user has been denied support. This user has been denied support.
Thanks. i ask my webmaster about this.

I forgotten to say but my threads table out of sync too.
(and maybe some other tables too... Sad )
I'm a proud MyBB user. Toungue


Forum Jump:


Users browsing this thread: 1 Guest(s)