Unit becomes slow when accessing Monitoring Pages for >7 days

Summary

The web UI slows considerably after client visits the URL page and sets a time range of > 30 days

Overview

When navigating the monitor section of the web UI, the web UI becomes potentially slow when accessing the application groups or URL pages for a time range greater than 7 days.
The system will operate fine after coming out of a reboot, but when going to the graph for a time period > the last 7 days (potentially other graphs too) the system starts to slow down a lot and pages take multiple minutes to load.

Furthermore, the following information is logged:
[mgmtd.NOTICE]: Async: timed out getting external response for type query_request session 34963 id 173423674 from monitord-20947
[mgmtd.NOTICE]: Async: timed out getting external response for type query_request session 34963 id 173423794 from monitord-20947

Cause

The cause is currently being investigated by Exinda engineers

Resolution

There is no resolution at this time.

Defect ID

D-05037

Internal Notes

Some scripts were run and found out that database culler not clearing the URL tables in the database. They're supposed to have around 4k elements in the monthly table, but this case has 1.43 million. When the page tries to load information from the monthly table database it takes a long time because of all the information to trawl through. Since the database is supposed to be 4,000 or so, and that the system should be removing extra entries to make it fit to 4,000, In this case, obviously it's not doing it. The web UI stays slow because the monitor process keeps trying to get this data and expends a lot of resources doing it.