mysql overloading…400% CPU

  • Resolved euseller

    (@euseller)


    6 years, 9 months ago

    So, got overloading my maria db 10.3.x, tested, confirmed
    400% overloading CPU mysql every 3 flow

    testing inbound data:
    – fresh install restricted content plugin last ver
    – wp rocket cache active + some other plugins
    – 1 membership – premium plan
    – create 3 categories: one parent, 2 additional: – cat1, cat2 and cat_main (parent) – rule – all content in this cateroies is restricted and visible for premium members only
    – posted one tested content and choosed cat2 and cat_main, both. And marked cat2 as main.

    Now lets test – go to http://www.test.com/cat_main/ and page loading is slow…looks to VDS CPU htop – oh my god…overloading…mysql

    go to console wp, disable plugin, stop frontend page loading…
    look to CPU console – good, now is ok

    i think u need check your plugin, of course here is many additional inboard parameters what i not posted… like mysql slow log and etc but…sorry havt time for this (

    U need check mysql query for wp_posts INNER JOIn wp_postmeta i think

    • This topic was modified 6 years, 9 months ago by euseller.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Ashley

    (@nosegraze)

    6 years, 9 months ago

    Hi there,

    It sounds like this is about the pro plugin. Can you please submit a ticket here: https://restrictcontentpro.com/support/ ?

    This forum is for the free version only.

    Thread Starter euseller

    (@euseller)

    6 years, 9 months ago

    ohh, i just post bug, not ask for support, because on codecanyon and official site no bug tracker forum like i see

    iv tested again and
    – with wp rocket – not working correct with “hide all content” option in setting
    – 400% CPU mysql stay overloading after OFF “hide all content” option in setting also, so mean problem not in this setting

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘mysql overloading…400% CPU’ is closed to new replies.