Re: Extremely slow query

[Vinod Sugur]

Hi Akash,

Can you paste the Explain plan for the above mentioned queries?

Also please try executing the following queries:

SELECT host_ip , SUM(events), TRUNCATE((SUM(bytes) * 1.0000), 2), SUM(bytes)
FROM vp_top_summary use index (`vpts_f`)
WHERE report_id IN (8001,7001) AND host_id = 1 GROUP BY host_ip ORDER BY "MBytes" DESC LIMIT 20;



SELECT count(1)
FROM sgmsdb.vp_top_summary use index (`vpts_f`)
WHERE report_id IN (6001,7001) AND host_id = 1 GROUP BY host_ip ;

Let me know if it helps.

~
Vinod