Super Slow Query for
-
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 JOINwp_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;
- The topic ‘Super Slow Query for’ is closed to new replies.