Membership High MySQL Usage

Have about 3k members registered on website with membership with different membership status like active, expired.

Membership 2 Pro has a Cron function for check membership status at every 6hours. Now issue is that it checks each and every user's membership status, and update membership accordingly so this cause a huge Mysql query, and brings the server down, every 6 hours.

Don't see any specific log, or server error related to this. But could notice high server load every six hours.
http://prntscr.com/iilk5h

Would like to know any workaround to to fix how the cron checks, or anything helpful.

  • Nithin
    • Support Wizard

    Hello Hazem Tasmem,

    Hope you are doing good today. :slight_smile:

    I'm bringing this into our developers attention, so that he could see whether there is anything that could be done within the plugin side, or guide you on what could be done regarding this.

    Please do note that developers work round the clock with many critical issues, and hence have a slow response time. Either myself, or the developer will keep you posted. Have a nice day ahead. :slight_smile:

    Best Regards,
    Nithin

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.