Each time I take a look at one of my site (who log 2000 pages view a day) I get a mysql slow query, that is a big problem because 2000 pages a day is very small indeed.
This is the query :

```

1. Query_time: 21 Lock_time: 0 Rows_sent: 268 Rows_examined: 7195655
   SELECT name,
   type,
   count(distinct t1.idvisit) as nb_visits,
   count(distinct visitor_idcookie) as nb_uniq_visitors,
   count(*) as nb_hits
   FROM (piwik_log_visit as t1
   LEFT JOIN piwik_log_link_visit_action as t2 USING (idvisit))
   LEFT JOIN piwik_log_action as t3 USING (idaction)
   WHERE visit_server_date = ‘2008-03-17’
   AND idsite = ‘2’
   GROUP BY t3.idaction;

```