Buddypress with large scale users
I am trying to optimise a wordpress (4.8.3)/ BuddyPress (2.8.2) site with 5000+ users hosted in WPEngine. Getting error in WPEngine error log.
The WPEngine error log shows following error:
[Wed Nov 15 23:50:15.430014 2017] [:error] [pid 21215] [client 22.214.171.124:32469]
KILLED QUERY (35690 characters long generated in
SELECT COUNT(u.user_id) FROM wp_bp_activity u WHERE 1=1 AND u.component = ‘members’ AND u.type = ‘last_activity’
AND u.user_id IN (72,790,8 …..
- You must be logged in to reply to this topic.