php sessions + redis/memcache + phpBB

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
SuperFedya
Registered User
Posts: 248
Joined: Sun Jul 14, 2002 9:14 pm
Contact:

php sessions + redis/memcache + phpBB

Post by SuperFedya » Wed Oct 01, 2014 2:20 pm

Hi,

Somebody used Redis or Memcache to store php sessions?
When I switched to it from file based sessions (sessions.save_handler = redis), I got thousands of queries like this:

Code: Select all

SELECT COUNT(session_id) AS sessions
                       FROM phpbb_sessions
                       WHERE sessions_user_id = 1
                        AND session_time >=1412124242 
And mysql takes 250-350% of the CPU...

Is there something special about phpbb_sessions and Redis session storage? Somebody else tried this combination? Or maybe with memcache?

Another question - when I'll use memcache or APC as phpbb cache, it will affect the sessions table?

Thanks

Locked

Return to “[3.0.x] Support Forum”