Trying to fix slow multisite database queries…

  • I’m having some performance issues with a multisite install and have some logs showing slow database queries, most of which seem the same. Here’s one of them:

    1. Executed 1h 30m 29s ago for 341.212287 sec on Database --> Unknown (NOT FOUND / DELETED)
Date: 2016-09-13 17:03:47 Query_time: 341.212287 Rows_examined: 1: Rows_sent 1 Lock_time: 78.800129
# Schema: db_name Last_errno: 0 Killed: 0 SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'dm_no_primary_domain' AND site_id = 1;

    What is this & how can I fix it?

Viewing 1 replies (of 1 total)

  • It might be due to a slow database. Or it could be something wrong with your WP instance. The very first thing I would so is run an explain on that exact query (phpmyadmin). That is for the WP Domain mapping plugin and should be a very fast query.

Viewing 1 replies (of 1 total)
  • The topic ‘Trying to fix slow multisite database queries…’ is closed to new replies.