Posts: 9,866
Threads: 594
Joined: Jan 2006
Quote: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.
Posts: 893
Threads: 49
Joined: Jun 2009
Reputation:
44
(2013-01-25, 05:30 AM)labrocca Wrote: 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.
RedHat Certified Systems Administrator