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

xf_session_activity -> Overhead

Discussion in 'Troubleshooting and Problems' started by TheBigK, May 9, 2013.

  1. TheBigK

    TheBigK Well-Known Member

    I see the following through phpMyAdmin -

    Screen Shot 2013-05-09 at 1.21.14 PM.png

    Just want to know this is normal? My server had a few issues and I found that users were not able to register.

    I tried repairing the tables, and then uninstalled the TaiGa Chat pro addon. The users were then able to register.

    Just want to know the overhead there, in the xf_session_activity is normal?
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    That's not a problem.

    Any specific error message? What was happening?
  3. TheBigK

    TheBigK Well-Known Member

    It was a regular error message "Server error occurred. Please try again later.". I checked the server error logs in the admincp and then found a couple of errors related to Taiga Chat pro addon. I uninstalled the addon and tried running a 'repair' on entire database. The repair didn't work because I think it's not supported. But users are now able to register.

    Do XF dbs need repair/optimise periodically?
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Most of the tables are InnoDB which don't support repair. Though it doesn't hurt to optimize the MyISAM tables.
    TheBigK likes this.
  5. Dinh Thanh

    Dinh Thanh Well-Known Member

    Same issue. Some time this table is overhead and Server unexpected.

Share This Page