High Mysql usage

  • Hi,

    We’re running wordpress sites with around 350G MYISAM and 2G INNODB MYSQL DATA. We’re seeing lot of SELECT * queries for wp_posts which are putting mysql usage to very high and resulting in node crash. Can anybody please help on how can we reduce queries load ? Here is the attached list of running queries :

    https://pastebin.com/cy1iVpQt

    My point is, are these queries optimized by wordpress because queries with (*) are bad written queries which scans the whole table.

    Awaiting your response.

    Regards.

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

    (@leglesslizard)

    Hi,

    Are you using query monitor? This is a plugin that will show you all queries on the page, their speed, highlight any slow ones and show you where they are being used. I’d have a look at that and remove any extensions that are running slow queries unless they are essential to the site (maybe look at alternatives or contact the developers to make them aware of the slow queries)

    @shahzaibcb How to these correlate to your log files, are these activities from your site users, admins, editors etc?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘High Mysql usage’ is closed to new replies.

Tags