I have analyze output slow queries, how resolve it?

morteza3245

• June 14, 2015 15:39

Hello i have output analyze of slow queries using MysqlSLA, how i can resolve it? below is one of output:' Count : 1 (0.00%) Time : 1.218819 s total, 1.218819 s avg, 1.218819 s to 1.218819 s max (0.01%) Lock Time (s) : 178 ?s total, 178 ?s avg, 178 ?s to 178 ?s max (0.00%) Rows sent : 10 avg, 10 to 10 max (0.00%) Rows examined : 2.90k avg, 2.90k to 2.90k max (0.00%) Database : myuser_db Users : myuser_dns@localhost : 100.00% (1) of query, 0.34% (840) of all users Query abstract: SET timestamp=N; SELECT SQL_CALC_FOUND_ROWS vlos4f_posts.id FROM vlos4f_posts WHERE N=N AND (((vlos4f_posts.post_title LIKE 'S') OR (vlos4$ Query sample: SET timestamp=1434310303; SELECT SQL_CALC_FOUND_ROWS vlos4f_posts.ID FROM vlos4f_posts WHERE 1=1 AND (((vlos4f_posts.post_title LIKE '%MR%') OR (vlos4f_posts.pos$
Thanks.

• 

  cPanelMichael

  • June 17, 2015 12:50

  Hello, You can try repairing or optimizing the table, or follow a third-party resource such as:

  0

Please sign in to leave a comment.