Libmemcached and caching sessions

[ehsanix]

Hello,
I have libmemcached configured and I am using it for session caching as well (config.php settings)
So I was wondering why I have still lots of queries like this?

 Waiting for table level lock | INSERT INTO xf_session_activity ...

 

[ehsanix]

Is this a dumb question? Or I have to wait for somebody to help?

 

[MattW]

xf_session_activity is already a MEMORY table, and doesn't use the session caching. It's where current user activity is stored.

@Mike posted a fix for this if your site is large:

https://xenforo.com/community/threads/user-online-feature-degrading-database-performance.82725/

 

[ehsanix]

Thanks for the tip.