Vers?o 1.5.0 – Query com lag
-
Ontem realizei a atualiza??o para a vers?o 1.5.0 e após o update, as nossas máquinas atingiram 99% da capacidade de processamento na leitura. Ao investigarmos, constatamos que é uma query realizada pelo plugin do Paypal. Ao desabilitarmos o plugin, a query n?o é executada, mas ao habilitarmos ela volta repetidamente e trava o processamento dos bancos de dados.
SELECT wp_wc_orders.id FROM wp_wc_orders INNER JOIN wp_wc_orders_meta AS meta0 ON ( wp_wc_orders.id = meta0.order_id ) INNER JOIN wp_wc_orders_meta AS meta1 ON ( wp_wc_orders.id = meta1.order_id ) INNER JOIN wp_wc_orders_meta AS meta2 ON ( wp_wc_orders.id = meta2.order_id ) WHERE 1=1 AND (wp_wc_orders.status IN ('wc-pending','wc-processing','wc-on-hold','wc-completed','wc-cancelled','wc-refunded','wc-failed','wc-checkout-draft')) AND (wp_wc_orders.type = 'shop_order') AND (((meta0.meta_key = 'paypal_brasil_sale_id' AND meta0.meta_value = '************') OR (meta1.meta_key = 'wc_ppp_brasil_sale_id' AND meta1.meta_value = '***********') OR (meta2.meta_key = 'wc_bcdc_brasil_sale_id' AND meta2.meta_value = '**********'))) GROUP BY wp_wc_orders.id ORDER BY wp_wc_orders.date_created_gmt DESC LIMIT 0, 18446744073709551615
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘Vers?o 1.5.0 – Query com lag’ is closed to new replies.