Page MenuHomeMiraheze

Monitor performance of DB Queries
Closed, DeclinedPublic

Description

We should be checking performance so if new indexes / better data storage needs implementing then we know.

This would have alerted us in advance to the delays with inserts that caused the issues.

Event Timeline

RhinosF1 triaged this task as Normal priority.Jun 27 2021, 15:12
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) added a comment.Jun 30 2021, 02:09

Do we not already have monitoring in Grafana that is sufficient enough to know about the mentioned issue/future issues?

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

No we don't have any slow DB query logs / fine grain data?

Unknown Object (User) added a comment.Jan 21 2022, 21:44

No we don't have any slow DB query logs / fine grain data?

We have this.

Doesn't tell us which query, how often it's being done, via what trigger, how long it took

Unknown Object (User) added a comment.Jan 21 2022, 21:46

Doesn't tell us which query, how often it's being done, via what trigger, how long it took

https://github.com/miraheze/puppet/blob/064dd8c3c8a51e02d9ad628988ed272cd46d3e24/modules/mariadb/templates/config/mw.cnf.erb#L83

Unknown Object (User) added a comment.Jan 23 2022, 03:58

I honestly don't see of any way to do this that benefits MWE, as any logging would only be accessible by Infrastructure and Reception123, and only actually logging can be done for this. It isn't feasible to do in Grafana (in my opinion).

Unknown Object (User) added a comment.Jan 23 2022, 03:59

Not if you want that much specificity anyway.

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.