Experiencing database performance issues

  • Resolved bekind

    (@pkverma99)


    5 years, 5 months ago

    Dear Support – Thanks for providing this wonderful plugin. It seems to do its job really well. I overall like the solution but I am confused with one behavior that I am seeing on my website. We have some plugins that update usermeta by calling “update_user_meta” method of wordpress.

    I have noticed that many times when such a call is made, the database takes an inordinate amount of time (in 10s of seconds). I have worked with my hosting provider (Kinsta in this case) and they dont see anything wrong with my usermeta table in terms of size. I was not experiencing this behavior prior to using redis cache. So it’s somehow related but I am not able to understand it. Here is a screenshot that shows what I am seeing through New Relic (https://prnt.sc/v4wckn) and another screenshot of the trace to the DB call (https://prnt.sc/v4wdqc). The DB call took 14 seconds and also caused some other requests to slow down. This was the very first request though.

    Kindly let me know if it would be a good idea to exlude user meta from cache. And if yes, some guidance on how that can be done would be helpful.

    To share with you the page that the user was accessing is a simple blog post (https://os.me/wealth/)

    Thanks in advance.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter bekind

    (@pkverma99)

    5 years, 5 months ago

    To provide some more context, what we experience is a cascading effect as more database requests start piling up. During that cascade, the website becomes very slow. In about 15 minutes, the cascade gets automatically resolved & things are back to normal.

    What I have noticed is that cascade is usually triggered by update_user_meta which somehow seems to throw object cache out of gear.

    Hope that helps get appropriate context.

    Regards

    Plugin Author Till Krüss

    (@tillkruess)

    5 years, 5 months ago

    Hi there!

    This plugin is unrelated to your issue. If your database query is slow the Kinsta support can help you optimize your MySQL tables for better performance.

    Thread Starter bekind

    (@pkverma99)

    5 years, 5 months ago

    Thanks @tillkruess. Any response on below query?
    ===========
    Kindly let me know if it would be a good idea to exlude user meta from cache. And if yes, some guidance on how that can be done would be helpful.
    =========

    Plugin Author Till Krüss

    (@tillkruess)

    5 years, 5 months ago

    You can ignore the user meta cache group 👍🏻

    The question has been answered many times in the forums, give it a search.

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

The topic ‘Experiencing database performance issues’ is closed to new replies.