XF 1.1 xf_session_activity table

[Mr.Smith]

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.

Thank you

 

[Jake Bunce]

Are there any zombie processes in your mysql process list? Of course you can manually kill processes that are consuming resources. But that doesn't address the underlying problem.

Is that table locked? What size is it when things start to go south? What about disk activity? Do the server logs show any related errors?

For reference:
http://stackoverflow.com/questions/7000646/locating-zombie-mysql-connections
http://www.webhostingtalk.com/showthread.php?t=939722
http://www.mysqlperformanceblog.com/2007/01/19/tmp_table_size-and-max_heap_table_size/
http://dev.mysql.com/doc/refman/5.0/en/memory-storage-engine.html