Performance Issue: Ultimate Member Causing Long-Running MySQL Queries

  • Yogesh Damasiya

    (@yogid)


    2 months, 3 weeks ago

    Hello Ultimate Member Support Team,

    I hope you are doing well.

    We are experiencing significant MySQL performance issues on one of our WordPress sites and, after detailed investigation, we found that the Ultimate Member plugin is responsible for the majority of the slow database queries.

    Issue Details

    Our server logs and query analysis indicate that Ultimate Member is repeatedly executing large user-count and access-control queries that scan millions of rows in the wp_users and wp_usermeta tables. These queries are taking 20 to 80+ seconds per execution and are accounting for approximately 90% of the total slow query time on the site.

    The website currently has 60,000+ registered users, with a large volume of records in wp_users and wp_usermeta.

    The most frequently involved files are:

    • /wp-content/plugins/ultimate-member/includes/common/class-users.php (around line 1001)
    • /wp-content/plugins/ultimate-member/includes/core/class-access.php (around line 267)

    Impact

    • Severe database load
    • Increased page load times
    • MySQL slow query logs filling rapidly

    Site Context:

    Additional Impact:
    Due to these long-running queries, the WordPress admin area is intermittently returning 502 Bad Gateway errors, particularly during backend operations and page loads.

    Request for Assistance

    Could you please help us with the following:

    1. Are these queries expected behavior for Ultimate Member on sites with a large user base?
    2. Are there any recommended configuration changes, indexes, or optimizations we should apply?
    3. Is there a known fix, patch, or update that improves performance for large wp_users / wp_usermeta tables?
    4. Are there any features or modules we should disable to reduce query load?

    We would greatly appreciate your guidance on optimizing Ultimate Member for this environment, as the plugin is critical to the site’s functionality.

    Please let us know if you need any additional logs, query samples, or environment details from our end.

    Thank you for your time and support.

    Best regards,
    Yogesh

You must be logged in to reply to this topic.