Database slow queries

  • Resolved nashua

    (@nashua)


    3 years, 1 month ago

    Hello,
    We have some trouble with slow queries on our database and this code: “bodhi_svgs_admin_notice_dismissed” is 7 times in our top10. What is going wrong there?

    the code is fpr example:
    ——————–
    7. Executed 5h 9m 15s ago for 26.110432 sec on Database –> dbzzv9uatcjhvy
    Date: 2021-12-08 08:34:06 Query_time: 26.110432 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000000 Query_chars: 101
    SELECT option_value FROM wp_options WHERE option_name = ‘bodhi_svgs_admin_notice_dismissed’ LIMIT 1;
    ————————————-

    What does this mean? And why is it so often in the slow query list?
    thank you for your help
    Jeroen

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Benbodhi

    (@benbodhi)

    Hi there,

    That’s very strange! There was an old upgrade notice a few years back that once dismissed, needed to be stored in the DB so it wasn’t shown again.

    I’ll look at completely removing that since it’s a very old version that it was in regards to.

    Why it shows up 7 times is beyond me… unless your admin needs to load 7 times and it checks the DB for the status of the dismissed msg over and over.

    It may just be a symptom of the slowness rather than cause, but I’m not 100%.
    Never seen it cause this issue on many many other sites.

    Would love to know if you figure it out.

    And I’ll plan to remove it anyway.

    Thanks for sharing. Let me know if o can be of any further help.

    Plugin Author Benbodhi

    (@benbodhi)

    Notice removed as of version 2.4 ??

    I’ll be pushing it live in the next few hours, it’s already uploaded to trunk now in case you’d like to test right away.

    Please do let me know if you face any issues still after the update.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database slow queries’ is closed to new replies.