Page MenuHomeMiraheze

Monitor size of database tables
Closed, DeclinedPublic

Description

We should monitor the size of Database tables and ensure that data in it is not uncontrolled.

Event Timeline

RhinosF1 triaged this task as Normal priority.Jun 27 2021, 15:10
RhinosF1 created this task.
Unknown Object (User) moved this task from Backlog to Long Term on the MediaWiki (SRE) board.Jun 27 2021, 17:08
Unknown Object (User) moved this task from Unsorted to Long Term on the Universal Omega board.
Unknown Object (User) lowered the priority of this task from Normal to Low.Jul 24 2021, 04:40
Reception123 removed a subscriber: Unknown Object (User).Aug 24 2021, 19:05
Unknown Object (User) subscribed.Oct 17 2021, 19:20

Do you mean moniter the size of every individual table on all wikis? If not can you elaborate?

Do you mean moniter the size of every individual table on all wikis? If not can you elaborate?

I think that would be very hard to do without huge bloat. We should probably sample the data.

Unknown Object (User) added a comment.Oct 17 2021, 19:52

Do you mean moniter the size of every individual table on all wikis? If not can you elaborate?

I think that would be very hard to do without huge bloat. We should probably sample the data.

Yes I know, that's why I was asking. I'm not sure how we can really do this in a good way. I don't see how this can really be done in Grafana, so any ideas about it then?

No, we don't have any per table / per DB stats. I think we discussed it being in a seperate report.

Unknown Object (User) added a comment.Jan 23 2022, 04:02

If this is per wiki, subdivided into tables, then this isn't feasible for Grafana (in my opinion). And I'm not sure how else we would collect and usefully display this information.

Unknown Object (User) closed this task as Declined.Jan 27 2022, 16:20
Unknown Object (User) claimed this task.

I'm going to go ahead and mark this as declined per what I said above. However, do reopen if a method to do so can be found.