• Resolved Felix Patzelt

    (@blackmagichappens)


    Hello,
    Every 2 second a ATUM db query is slowing down the server and using nearly 100% of all cpus. How to fix this problem?
    
    SELECT XYZposts.ID
    FROM XYZposts
    LEFT JOIN XYZpostmeta
    ON ( XYZposts.ID = XYZpostmeta.post_id )
    LEFT JOIN XYZpostmeta AS mt1
    ON ( XYZposts.ID = mt1.post_id
    AND mt1.meta_key = '_wpm_conversion_pixel_fired' )
    LEFT JOIN XYZpostmeta AS mt2
    ON ( XYZposts.ID = mt2.post_id )
    WHERE 1=1
    AND ( XYZposts.post_date > '2023-12-24 13:38:03' )
    AND ( XYZpostmeta.meta_key = '_wpm_process_through_wpm'
    AND mt1.post_id IS NULL
    AND ( mt2.meta_key = '_created_via'
    AND mt2.meta_value = 'checkout' ) )
    AND XYZposts.post_type = 'shop_order'
    AND ((XYZposts.post_status = 'wc-pending'
    OR XYZposts.post_status = 'wc-processing'
    OR XYZposts.post_status = 'wc-on-hold'
    OR XYZposts.post_status = 'wc-completed'))
    GROUP BY XYZposts.ID
    ORDER BY XYZposts.post_date DESC
    
    SELECT SQL_CALC_FOUND_ROWS XYZposts.ID
    FROM XYZposts
    WHERE 1=1
    AND XYZposts.post_type = 'shop_order'
    AND ((XYZposts.post_status = 'wc-pending'
    OR XYZposts.post_status = 'wc-processing'
    OR XYZposts.post_status = 'wc-on-hold'
    OR XYZposts.post_status = 'wc-completed'
    OR XYZposts.post_status = 'wc-cancelled'
    OR XYZposts.post_status = 'wc-refunded'
    OR XYZposts.post_status = 'wc-failed'
    OR XYZposts.post_status = 'wc-arrival-shipment'
    OR XYZposts.post_status = 'wc-sollvorkasse'
    OR XYZposts.post_status = 'wc-lieferstopp'
    OR XYZposts.post_status = 'wc-ratenzahlung'
    OR XYZposts.post_status = 'wc-inkasso'
    OR XYZposts.post_status = 'wc-inkassoerl'
    OR XYZposts.post_status = 'wc-hinweis'
    OR XYZposts.post_status = 'wc-zukauf'
    OR XYZposts.post_status = 'wc-7'
    OR XYZposts.post_status = 'wc-orderbezzuruck'
    OR XYZposts.post_status = 'wc-6'
    OR XYZposts.post_status = 'wc-5'
    OR XYZposts.post_status = 'wc-4'
    OR XYZposts.post_status = 'wc-praemien'
    OR XYZposts.post_status = 'wc-abbuchen'
    OR XYZposts.post_status = 'wc-dhl'
    OR XYZposts.post_status = 'wc-1'
    OR XYZposts.post_status = 'wc-2'
    OR XYZposts.post_status = 'wc-3'
    OR XYZposts.post_status = 'wc-rueckfrage'
    OR XYZposts.post_status = 'wc-gewinnspiel'
    OR XYZposts.post_status = 'wc-klarna_manbez'
    OR XYZposts.post_status = 'wc-nachbearbeiten'
    OR XYZposts.post_status = 'wc-zukaufnuvega'
    OR XYZposts.post_status = 'wc-zukaufyodeyma'
    OR XYZposts.post_status = 'wc-zukaufdermalogica'
    OR XYZposts.post_status = 'wc-zukaufkleanthous'
    OR XYZposts.post_status = 'wc-manstorniert'
    OR XYZposts.post_status = 'wc-1'
    OR XYZposts.post_status = 'wc-2'
    OR XYZposts.post_status = 'wc-3'
    OR XYZposts.post_status = 'wc-4'
    OR XYZposts.post_status = 'wc-5'
    OR XYZposts.post_status = 'wc-6'
    OR XYZposts.post_status = 'wc-7'
    OR XYZposts.post_status = 'wc-zukaufall'
    OR XYZposts.post_status = 'wc-unzufrieden'
    OR XYZposts.post_status = 'wc-erwretoure'
    OR XYZposts.post_status = 'wc-8'
    OR XYZposts.post_status = 'wc-9'
    OR XYZposts.post_status = 'wc-weihnachten'
    OR XYZposts.post_status = 'wc-abholbereit'))
    ORDER BY XYZposts.post_date DESC
    LIMIT 0, 20
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Jose Andres Piera

    (@japiera)

    Hi @blackmagichappens,

    Apologies for any inconvenience caused.

    How did you conclude that the query is executed by ATUM? None of the meta fields in the query are included in ATUM (_wpm_conversion_pixel_fired, _wpm_process_through_wpm).

    Best Regards,
    José Andrés

    Thread Starter Felix Patzelt

    (@blackmagichappens)

    I thought these were stock updating keys and I thought that’s what cloudways support figured. I also read before that ATUM add-on caused such an issue before on wp forum.

    Plugin Author Jose Andres Piera

    (@japiera)

    Hi @blackmagichappens,

    I see.

    ATUM doesn’t use such a fields.

    I kindly recommend you search those fields in your site’s code to find which plugin is causing the issue.

    Best Regards,
    José Andrés

    Thread Starter Felix Patzelt

    (@blackmagichappens)

    Ok, thank you

    Plugin Author Jose Andres Piera

    (@japiera)

    You’re welcome.

    Best Regards,
    José Andrés

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Recurring db query is slowing down the server’ is closed to new replies.