Why mySql is not responding during group by query?

MySql has default setting and system configuration is I5(2.5GHz 8GB Ram)

Table has 18 mill rows and i trying to run this query

select  ID ,count(*)   
from table 
where TYPE='good'  
group by ID ,TYPE  
limit 2 ;

would please explain how i can solve this problem