REGISTER or LOGIN to have the annoying ads removed.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Changing the sessions table for mybb to optimize.
#1
I got this neat little tip from Tikitiki. Basically it's simple to implement. It requires you to change the sessions table to HEAP (memory). This SHOULD help prevent sessions table crashing and it will also automatically truncate (delete) sessions older than 24 hours.

Run this in your phpmyadmin:

Code:
ALTER TABLE `mybb_sessions` ENGINE = memory

This of course assumes your prefix is mybb. Alter it if you have changed your prefix.
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  Get rid of your session table crashing labrocca 19 21,614 Apr 19, 2017, 12:43 AM
Last Post: Barbarjreusser
Question Problem with ficons ( table spacing ) chris1 4 2,080 May 31, 2013, 02:57 PM
Last Post: Xronize
Question Changing buddy icons Derek765 0 799 Jan 25, 2013, 08:22 AM
Last Post: Derek765
  Changing PM notification colour Raid0 1 846 May 16, 2012, 06:08 AM
Last Post: Oliver Evans
  Need help changing reply box Thermogenic 6 2,375 May 12, 2012, 09:55 PM
Last Post: Thermogenic

Forum Jump:


Users browsing this thread: 1 Guest(s)