Performance Issue: Expire Users Plugin Causing Long-Running MySQL Queries

  • Yogesh Damasiya

    (@yogid)


    5 months ago

    Hello Expire Users Support Team,

    I hope you are doing well.

    We are currently facing serious MySQL performance issues on one of our WordPress production sites. After reviewing server slow query logs and application traces, we identified that the Expire Users plugin is contributing to long-running database queries, which are impacting site performance and stability.Site Details

    • Site URL: https://influancehaircare.com
    • Total registered users: 60,000+
    • Hosting environment: WP Engine
    • Affected area: WordPress admin (backend)

    Issue Details

    Our analysis shows that the Expire Users plugin is executing queries that scan a large volume of user-related data, resulting in slow-running MySQL queries.

    The primary file involved is:

    • /wp-content/plugins/expire-users/includes/query.php (around line 17)

    These queries are taking a significant amount of time to complete and are frequently triggered, contributing to overall database load.Impact Observed

    • High database CPU usage
    • Slow backend response times
    • MySQL slow query log entries increasing rapidly
    • 502 Bad Gateway errors occurring in the WordPress admin
    • Admin actions timing out during normal usage

    This behavior becomes more pronounced due to the large user base (60k+ users) on the site.

    Request for Assistance

    Could you please help us with the following:

    1. Is this query behavior expected for Expire Users on sites with a large number of users?
    2. Are there any recommended optimizations, configuration changes, or database indexes we should apply?
    3. Is there an updated version, patch, or alternative approach to improve performance at scale?
    4. Are there any scheduled hooks, cron jobs, or background processes in the plugin that can be optimized or limited?

    The plugin is important for managing user expirations, so we would appreciate guidance on how to use it efficiently in a high-user-count environment.

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

    Thank you for your time and support. We look forward to your response.

    Best regards,
    Yogesh

You must be logged in to reply to this topic.