Hi,

We have some issues with our Application Manager. We've installed 190 monitors on a windows server (1 Xeon 2.4 CPU, 2GB mem) and the monitor is reporting more and more false alerts about the health. The CPU is often on 100%, so we decided to place an extra CPU, but now we notice *** DEAD *** queries in MySQL Administrator. In the slowquerylogger.log we see that same query.

# Time: 091223 10:30:55
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 11  Lock_time: 0  Rows_sent: 1  Rows_examined: 10383387
select min(COLLECTIONTIME) as mintime,max(COLLECTIONTIME) as maxtime from AM_HOSTPGSPACEDATACOLLECTED;

Could you advice us what's going wrong?

Kind regards,

Marcel