Super Slow Query for

  • Resolved mnkhalid

    (@mnkhalid)


    2 years, 11 months ago

    Found the following in slow query log, leading to increase in Disk Que in AWS Database, copied and tested the query and it takes 20+ seconds when there are no entries found. Is there a way to fix this??

    Rows_sent: 0 Rows_examined: 1989074 this seems to be the major cause of concern.

    # Time: 2022-04-17T23:40:24.614832Z # User@Host: dbuser[dbuser] @ [ip_address] Id: 52099 # Query_time: 21.551505 Lock_time: 0.000002 Rows_sent: 0 Rows_examined: 1989074 use bitnami_wordpress; SET timestamp=1650238803; SELECT wpm.post_id, wpost.post_date, wpost.post_status FROM wp_postmeta AS wpm LEFT JOIN wp_posts AS wpost ON wpm.post_id = wpost.ID WHERE wpm.meta_key = ‘_billing_email’ AND wpm.meta_value = ‘xyz@gmail’ AND wpm.post_id = wpost.ID Order BY wpm.post_id DESC LIMIT 1;

Viewing 1 replies (of 1 total)
  • Plugin Support priyankajagtap

    (@priyankajagtap)

    Hi @mnkhalid,

    First of all, apologize for the inconvenience caused to you due to this error.

    I have forwarded this database error to the development team and we will check and get back to you with an update on how to fix this error and increase the speed of execution. I hope that is fine.

    Regards,
    Priyanka

Viewing 1 replies (of 1 total)
  • The topic ‘Super Slow Query for’ is closed to new replies.