i've upgraded an rhel4 box from m2-740 (i think, can't remember exactly) to m3-381. shortly after starting (or restarting) zimbra, i get mysqld running at 99% cpu, and lots of entries in logger_myslow.log like:
# Time: 060105 2:12:17
# User@Host: zimbra[zimbra] @ localhost 
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 504206
select avg(total) from disk_aggregate where host = 'mail.radiatormail.co.uk' and device = '/dev/hda5' and period_start >= '2005-12-30 00:00:00' and period_end <= '2005-12-31 00:00:00';
they seem to be mainly about hdax, although a few other queries too. does this indicate some queries that aren't indexed correctly? how come they're so frequent? they seem to be constant, a tail -f shows them several times per second.