Dear users of PerfParse,
There is an index missing off one of the tables. This effects the Raw
History. Adding this index should speed reports from minutes to seconds.
However I will not be adding this in a normal database version change.
This is because adding the index may take many hours if you have data.
Therefore all new databases will have this index. If you want to add
it, which I advise, please enter:
mysql> ALTER TABLE perfdata_service_raw ADD INDEX search_idx (host_name,
service_description, ctime);
Please let me know if you require more information.
Regards,
Ben Clewett.
|
