slow queries in bp-core-classes
We have ~25k users.
We’re still on BP Version 1.2.9 – (working on upgrading to 1.3)
I’m wondering if the issue below is addressed by 1.3 and/or if there is something we can do on 1.2.9
Here is an example of a slow query:
`SELECT DISTINCT u.ID as id, u.user_registered, u.user_nicename, u.user_login, u.display_name, u.user_email , um.meta_value as last_activity FROM wp_users u LEFT JOIN wp_usermeta um ON um.user_id = u.ID WHERE u.user_status = 0 AND um.meta_key = ‘last_activity’ ORDER BY um.meta_value`
I think this is coming from bp-core-classes -> function get_users
We’ve increased :
query_cache_size to 128M
query_cache_limit: to 2M
join_buffer_size to 2M
But we still have problems during high traffic.
Any suggestions on optimizing that query or some other approach ?
You must be logged in to reply to this topic.