WordPress.org
Get WordPress

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #57764


Ignore:
Timestamp:
02/20/2023 02:11:17 AM (20 months ago)
Author:
dd32
Comment:

Welcome to Trac @Blogizma,

Although you haven't posted the full SQL, the SQL you've posed is generated by wp_count_attachments(), which did have some caching added in 6.1 via #55227. The part of the SQL query which hasn't been included is possibly the most relevant part, as it determines what about the query is expensive.

You can view the full SQL query by using SHOW FULL PROCESSLIST; as a query or using the process manager and ensuring it has the "full query" option checked.

Some more details are needed to know what the problem is here though, does the site have a lot of posts? or uploads? How many are we talking? (10,000? 100,000?)

At first, it sounds like this might be caused by a plugin, and may be better resolved through the ​WordPress support forums unless a bug can be determined.

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #57764

    • Property Keywords reporter-feedback added
    • Property Component changed from General to Upload
    • Property Type changed from feature request to defect (bug)

  • Ticket #57764 – Description

    initial v1  
    11Hello,
    2 There is very excessive CPU consumption in MYSQL process on our site. When we check this via Show MYSQL proccess
     2There is very excessive CPU consumption in MYSQL process on our site. When we check this via Show MYSQL proccess we encounter this query.
    33
    44{{{
    … …  
    66}}}
    77
    8  we encounter this query.
    9 
    108I am waiting for your help to solve the problem.