High mysql usage on hosting provider

  • Resolved tsaffeld

    (@tsaffeld)


    1 year, 1 month ago

    WE were noticing some slowness on the backend of our website – after contacting our hosting provider they said that MySQL is regularly going to 100% usage, though- which will cause slowness:

    When I look at the top offending files for MySQL usage- it seems to be the “sassy-social-share” plugin: 7383 /nas/content/live/maverick/index.php:17 6251 /nas/content/live/maverick/wp-content/plugins/sassy-social-share/public/class-sassy-social-share-public.php:1226

    Any way to stop this plugin from chewing up so much of the CPU power – which ultimately causes excessive SQL queries – which slow down the site’s performance?

    Log screenshot – https://snipboard.io/d9jyiz.jpg

Viewing 1 replies (of 1 total)
  • Plugin Author Heateor Support

    (@heateor)

    If you have integrated social share bar with social share count enabled on a web page listing a lot of posts, each social share bar will query the postmeta to fetch number of shares for every post.

    In this case, you can try disabling the options Show share counts and Show total shares in the Standard Interface section at the plugin configuration page.

Viewing 1 replies (of 1 total)
  • The topic ‘High mysql usage on hosting provider’ is closed to new replies.