Our database have 6+GB, 1200w+ lines of maas event in database.
![48%20PM](https://discourse-maas-io-uploads.s3.us-east-1.amazonaws.com/original/1X/579a8217dd4aa2e9b1578df42cc4046e66eefb41.png)
I’m suspecting that this is the real cause of machine listing issue (see Updated to 2.6 from 2.5 now UI slow and not usable and https://bugs.launchpad.net/maas/+bug/1835316)
I saw that there was a similar issue and mark resolved https://bugs.launchpad.net/maas/+bug/1403080
not sure it’s a regression or we should let this table grow?
Can the data inside be safely deleted?
Following the @hyuwang question… Is there any garbage collector for the DB? There are tons of old events/data there
We don’t have any garbage collection at the moment but are discussing ideas.
It’s safe to truncate this table, assuming you no longer care about historical events.
1 Like
IMHO, having such a large number of events shouldn’t be a case of performance issues because the UI shouldn’t even try to load all of them. In fact, it should be only loading:
- The latest event on the machine listing page per machine, if any.
- The first few events on a details page.
So I believe this has already been fixed on the UI perspective?
1 Like
ya, problem gone after merge the UI fix
sorry, let me put my words back. just a few days after the truncation, our table once again grow up to 500M+ rows, and everything become slow again.
the problem still exists after the UI fix, I found some extremely complex query which join multiple table with maasserver_event. See the detail in my other post here Updated to 2.6 from 2.5 now UI slow and not usable
1 Like