Performance issues on latest version 4.3.2

Hi,

I detect slow queries in mysql/mariadb with latest molongui version. CPU has spikes. My ratio for slow queries is 3:

# Time: 210603  5:47:13
# User@Host: pdpu[pdpu] @ localhost []
# Thread_id: 1714  Schema: pdpdb  QC_hit: No
# Query_time: 3.579276  Lock_time: 0.000143  Rows_sent: 5  Rows_examined: 411820
# Rows_affected: 0  Bytes_sent: 141
SET timestamp=1622699233;
SELECT SQL_CALC_FOUND_ROWS  wp_a2h1t94d2x_posts.ID FROM wp_a2h1t94d2x_posts  LEFT JOIN wp_a2h1t94d2x_postmeta ON (wp_a2h1t94d2x_posts.ID = wp_a2h1t94d2x_postmeta.post_id AND wp_a2h1t94d2x_postmeta.meta_key = '_molongui_author' )  LEFT JOIN wp_a2h1t94d2x_postmeta AS mt1 ON ( wp_a2h1t94d2x_posts.ID = mt1.post_id )  LEFT JOIN wp_a2h1t94d2x_postmeta AS mt2 ON ( wp_a2h1t94d2x_posts.ID = mt2.post_id ) WHERE 1=1  AND ( 
  ( 
    ( wp_a2h1t94d2x_postmeta.post_id IS NULL AND wp_a2h1t94d2x_posts.post_author = 9 )
    OR 
    ( 
      mt1.meta_key = '_molongui_author' 
      AND 
      ( mt2.meta_key = '_molongui_author' AND mt2.meta_value = 'user-9' )
    )
  )
) AND wp_a2h1t94d2x_posts.post_type = 'post' AND (wp_a2h1t94d2x_posts.post_status = 'publish') GROUP BY wp_a2h1t94d2x_posts.ID ORDER BY wp_a2h1t94d2x_posts.post_date DESC LIMIT 1350, 10;
# Time: 210603  5:47:30
# User@Host: pdpu[pdpu] @ localhost []
# Thread_id: 1741  Schema: pdpdb  QC_hit: No
# Query_time: 3.230110  Lock_time: 0.000077  Rows_sent: 10  Rows_examined: 406837
# Rows_affected: 0  Bytes_sent: 196
SET timestamp=1622699250;
SELECT SQL_CALC_FOUND_ROWS  wp_a2h1t94d2x_posts.ID FROM wp_a2h1t94d2x_posts  LEFT JOIN wp_a2h1t94d2x_postmeta ON (wp_a2h1t94d2x_posts.ID = wp_a2h1t94d2x_postmeta.post_id AND wp_a2h1t94d2x_postmeta.meta_key = '_molongui_author' )  LEFT JOIN wp_a2h1t94d2x_postmeta AS mt1 ON ( wp_a2h1t94d2x_posts.ID = mt1.post_id )  LEFT JOIN wp_a2h1t94d2x_postmeta AS mt2 ON ( wp_a2h1t94d2x_posts.ID = mt2.post_id ) WHERE 1=1  AND ( 
  ( 
    ( wp_a2h1t94d2x_postmeta.post_id IS NULL AND wp_a2h1t94d2x_posts.post_author = 15 )
    OR 
    ( 
      mt1.meta_key = '_molongui_author' 
      AND 
      ( mt2.meta_key = '_molongui_author' AND mt2.meta_value = 'user-15' )
    )
  )
) AND wp_a2h1t94d2x_posts.post_type = 'post' AND (wp_a2h1t94d2x_posts.post_status = 'publish') GROUP BY wp_a2h1t94d2x_posts.ID ORDER BY wp_a2h1t94d2x_posts.post_date DESC LIMIT 130, 10;
# Time: 210603  5:47:31
# User@Host: pdpu[pdpu] @ localhost []
# Thread_id: 1742  Schema: pdpdb  QC_hit: No
# Query_time: 3.187128  Lock_time: 0.000119  Rows_sent: 10  Rows_examined: 400738
# Rows_affected: 0  Bytes_sent: 196
SET timestamp=1622699251;
SELECT SQL_CALC_FOUND_ROWS  wp_a2h1t94d2x_posts.ID FROM wp_a2h1t94d2x_posts  LEFT JOIN wp_a2h1t94d2x_postmeta ON (wp_a2h1t94d2x_posts.ID = wp_a2h1t94d2x_postmeta.post_id AND wp_a2h1t94d2x_postmeta.meta_key = '_molongui_author' )  LEFT JOIN wp_a2h1t94d2x_postmeta AS mt1 ON ( wp_a2h1t94d2x_posts.ID = mt1.post_id )  LEFT JOIN wp_a2h1t94d2x_postmeta AS mt2 ON ( wp_a2h1t94d2x_posts.ID = mt2.post_id ) WHERE 1=1  AND ( 
  ( 
    ( wp_a2h1t94d2x_postmeta.post_id IS NULL AND wp_a2h1t94d2x_posts.post_author = 65 )
    OR 
    ( 
      mt1.meta_key = '_molongui_author' 
      AND 
      ( mt2.meta_key = '_molongui_author' AND mt2.meta_value = 'user-65' )
    )
  )
) AND wp_a2h1t94d2x_posts.post_type = 'post' AND (wp_a2h1t94d2x_posts.post_status = 'publish') GROUP BY wp_a2h1t94d2x_posts.ID ORDER BY wp_a2h1t94d2x_posts.post_date DESC LIMIT 20, 10;

• This topic was modified 2 years, 10 months ago by Jacobo Nájera.