if its too large for a small forum, how do we shrink database?
What do you mean by "shrink"? You can't really reduce the size of a database without deleting rows...
Saying that, you could reduce the size a small amount by emptying the sessions table and deleting any inactive users with 0 posts.
Don't mybb stores original posts when someone revised their post?
I don't believe it does, no. It simply stores the UID of the user who edited the post and the time it was edited.
Do you think a mybb forum with 2K posts will have at least 600mb sql file?
any reason why its this huge?
It shouldn't be that large.
What tables have the most amount of rows?
in the mybb_events is 379.1 MB and mybb_sessions is 241.0 MB
[
attachment=26921]
is this normal?
Can we have a link to your forum? There's definitely something wrong here.
You should also make sure the Daily Cleanup task is active and you have {$task_image} in your footer template.
Same issue, I have to keep truncating mybb_sessions
Its getting REALLY annoying.