Recurring db query is slowing down the server
-
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)
Viewing 5 replies - 1 through 5 (of 5 total)
- The topic ‘Recurring db query is slowing down the server’ is closed to new replies.