Tips to increase mybb performence

[User 2877]

You can trim/empty mybb_sessions any time without logging anyone out.

Just to confirm what he says is true. Truncating the sessions table will not effect users. A new session row will be created based on their existing cookie.

[Mr407]

This user has been denied support.

Thanks for this thread, I have been looking for threads like this to make the site i'm working on
top of the line!

[remshad]

hi,


based on my experience storage engine type 'memory' give better performance rather than InnoDb

because it take ram to store table buffers and field datas

[vovas]

Have somebody how to with transfer all tables to InnoDB?

[Time_to_start]

Wow thank you, but why and how to change a "MyIsam" table to "MEMORY"??

[spork985]

Sessions best as InnoDB.

HF has a 300-500mb sessions table at any given time. It's perfectly fine. I had serious issues with MyISAM for sessions and even with MEMORY/HEAP. It's been 100% since I moved to InnoDB (MySQL 5.5+).

I find the complete opposite. InnoDB was a huge improvement over MyISAM for obvious row locking reasons, but I still ran into deadlocks every now and then on forums that got many hits very fast. These typically came from social sites such as stumble upon. I converted these forum's session tables to the memory engine and haven't had the problem since. I'm running MySQL 5.6.

[dthiago]

So...if i change all tables to innoDB.

It required some modification in the installed plugins?

Best performance?

Any problems related?

[Xbat]

nice tips