• Resolved renandepaula

    (@renancomn)


    O plugin atualizado está gerando um queries ineficientes causando causando a queda do servidor. N?o recomendo que instalem a vers?o 1.5.2.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author bycoders_

    (@bycoders)

    Olá @renancomn

    Poderia, por gentileza, nos enviar evidências para que possamos investigar a causa dessa lentid?o? Se possível, encaminhe-as para [email protected].

    Plugin Author bycoders_

    (@bycoders)

    Olá @renancomn

    Agradecemos pelas informa??es enviadas por e-mail. Já estamos analisando a situa??o e entraremos em contato com você em breve.

    Para colaborar com a reclama??o do @renancomn , estamos com esse problema desde a vers?o 1.5.0 como relatado neste mesmo fórum (e o post foi fechado, sem retorno de solu??o). Haviamos pulado a vers?o 1.5.0 e 1.51 e resolvemos atualizar para a vers?o 1.5.2, mas o problema persiste.

    Exemplo de query com lag (ocultamos o ID do pagamento com os asteriscos)

    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

    Print da utiliza??o da máquina

    Print da query

    Dados do servidor:

    ### wp-core ###

    version: 6.6.1
    site_language: pt_BR
    user_language: pt_BR
    timezone: -03:00
    permalink: /%postname%/
    https_status: true
    multisite: false
    user_registration: 0
    blog_public: 1
    default_comment_status: undefined
    environment_type: production
    user_count: 647
    dotorg_communication: true

    ### wp-dropins (3) ###

    advanced-cache.php: true
    db.php: true
    object-cache.php: true

    ### wp-server ###

    server_architecture: Linux 4.4.0-1128-aws x86_64
    httpd_software: nginx/1.16.1
    php_version: 7.4.1 64bit
    php_sapi: fpm-fcgi
    max_input_variables: 1000
    time_limit: 30
    memory_limit: 256M
    admin_memory_limit: 256M
    max_input_time: 60
    upload_max_filesize: 2M
    php_post_max_size: 8M
    curl_version: 7.47.0 OpenSSL/1.0.2g
    suhosin: false
    imagick_availability: true
    pretty_permalinks: true
    htaccess_extra_rules: true
    current: 2024-07-25T14:55:00+00:00
    utc-time: Thursday, 25-Jul-24 14:55:00 UTC
    server-time: 2024-07-25T11:54:59-03:00

    ### wp-database ###

    extension: mysqli
    server_version: 8.0.36
    client_version: mysqlnd 7.4.1
    max_allowed_packet: 67108864
    max_connections: 135

    ### wp-filesystem ###

    wordpress: writable
    wp-content: writable
    uploads: writable
    plugins: writable
    themes: writable
    fonts: not writable
    mu-plugins: writable

    Woocommerce Vers?o 9.1.2
    Plugin Author bycoders_

    (@bycoders)

    Olá @renancomn @bertz
    Fizemos o upload de uma nova vers?o que deve corrigir este erro. Recomendamos que a nova vers?o seja instalado no ambiente de testes para valida??o.

    Se ainda houver problemas, por favor, entre em contato aqui ou pelo e-mail [email protected].

    • This reply was modified 7 months, 2 weeks ago by bycoders_.

    Alguém conseguiu confirmar se ficou ok a 1.5.3?

    Ainda estou usando a 1.4.9.

    Thread Starter renandepaula

    (@renancomn)

    Tem que testar. Até agora nada aqui

    @renancomn a vers?o 1.5.3 n?o resolveu o problema? Chegou a enviar e-mail para [email protected]? Ainda estou na vers?o 1.5.0 devido a estes relatos.
    Obrigado pela aten??o

    Thread Starter renandepaula

    (@renancomn)

    Problema resolvido na vers?o 1.5.4

Viewing 8 replies - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.