Hi,

My opmanager installation is very slow, when I look in the mysql processlist I see the following entry all the time, this query is running almost continuously and taking +20 sec. to complete. 'Copy to tmp table' seems to me to be a very timeconsuming action. Anyone know why it's doing this all the time and is this harmfull for the performance ?

|  6 | root | localhost:28812 | opmanagerdb | Query   |   18 | Copying to tmp table | select * from ( ( select   ManagedObject.DISPLAYNAME,ManagedObject.NAME, Event_2012_12_15_24.TEXT, Ev |

Kr,

Ronald