• Resolved as517

    (@as517)


    Hi. I use the old version of this plugin (8.4)

    Slow query causes the server to crash.
    Example

    
    # Query_time: 5.251648  Lock_time: 0.000346 Rows_sent: 2  Rows_examined: 199189
    SET timestamp=1595970481;
    SELECT   trade_posts.ID FROM trade_posts  LEFT JOIN trade_postmeta ON ( trade_posts.ID = trade_postmeta.post_id )  LEFT JOIN trade_postmeta AS mt1 ON (trade_posts.ID = mt1.post_id AND mt1.meta_key = '_fep_delete_by_1' )  LEFT JOIN trade_postmeta AS mt2 ON (trade_posts.ID = mt2.post_id AND mt2.meta_key = '_fep_parent_read_by_1' ) WHERE 1=1  AND trade_posts.post_parent = 0  AND ( 
      ( trade_postmeta.meta_key = '_fep_participants' AND trade_postmeta.meta_value = '1' ) 
      AND 
      mt1.post_id IS NULL 
      AND 
      mt2.post_id IS NULL
    ) AND trade_posts.post_type = 'fep_message' AND ((trade_posts.post_status = 'publish')) GROUP BY trade_posts.ID ORDER BY trade_posts.post_date DESC;
    

    What is the solution to this problem?

    Thank you for help.

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘MySQL queries optimization’ is closed to new replies.