1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.1 xf_session_activity table

Discussion in 'Troubleshooting and Problems' started by Mr.Smith, Oct 31, 2011.

  1. Mr.Smith

    Mr.Smith Member

    Screen shot 2011-10-31 at 1.16.23 PM.png
    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 :)
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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:

Share This Page