I have just converted my vBulletin board to XenForo
I have been having problems with my session_activity table (MEMORY TABLE).
It has overheads on the table and every few hrs, it goes empty (Queries start building up up in mySQL process list : Copying to tmp table) leading to downtime with server loads on 70+ ranges.
I just restored a backup and it went through fine, and it just happened again.
I even upgraded to xenForo 1.1 beta but the problem is still the same.
I would appreciate some help regarding the issue.